#region 画统计图
/// <summary> /// 画统计图
/// </summary> private void LoadWebChartControl()
{
this.WebChartControl1.Series.Clear();
var sql = string.Format("{0} and ({1}) order by TimeTypeValue asc", GetSql_Chart(), string.IsNullOrEmpty(AspxGridViewPagger1.FilterSql) ? "1=1" : AspxGridViewPagger1.FilterSql);
var data = Support.DBHelper.GetDataBySql(sql).ExecuteTable();
WebChartControl1.Visible= data.Rows.Count >0;
WebChartControl_Div.Visible= data.Rows.Count > 0;
List<OrderStatics> listOrderStatics = new List<OrderStatics>();
List<string> listTime = new List<string>();
for (int i = 0; i < data.Rows.Count; i++)
{
listOrderStatics.Add(new OrderStatics()
{
ChartName= data.Rows[i]["StaticObjValue"].ToString(),
ChartX= data.Rows[i]["TimeTypeValue"].ToString(),
ChartY= Tool.StringUnit.ToDecimal(data.Rows[i]["moneY"])
});
listTime.Add(data.Rows[i]["TimeTypeValue"].ToString());
}
List<string> listStaticObjValue = new List<string>();
listOrderStatics.ForEach(o=>
{
if (!listStaticObjValue.Contains(o.ChartName))
{
listStaticObjValue.Add(o.ChartName);
}
});
foreach (var objValue in listStaticObjValue)
{
#region MyRegion
var series_name = string.Empty;
switch (StaObj)
{
case "SellerID"://业务员 series_name = GetSellerName(objValue);
break;
case "ShopName"://店铺 series_name = GetShopCName(objValue);
break;
case "ShippingAgent"://货代 series_name = objValue;
break;
}
Series series= new Series(series_name, ViewType.Line);
List<OrderStatics> listOrderStaticsItem = listOrderStatics.Where(z => z.ChartName == objValue).OrderBy(o => o.ChartX).ToList();
foreach (var item in listOrderStaticsItem)
{
series.Points.Add(new SeriesPoint(item.ChartX, item.ChartY));
}
//设置标题
// var title = new ChartTitle()
// WebChartControl1.Titles.Clear();
//WebChartControl1.Titles.Add(title); series.Label.PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;//设置数值显示为百分比
//series.Label.PointOptions.PointView = PointView.ArgumentAndValues;//设置参数值 series.ArgumentScaleType = ScaleType.Auto;//设置x坐标显示类型(Qualitative:定性的) WebChartControl1.BinaryStorageMode = BinaryStorageMode.Session;
this.WebChartControl1.Series.Add(series);
#endregion
}
}
#endregion
<dxchartsui:WebChartControlID="WebChartControl1" runat="server" Width="1260" Height="300"
ShowLoadingPanelImage="True"> </dxchartsui:WebChartControl>
文章名称:图表:WebChartControl-创新互联
转载注明:https://www.cdcxhl.com/article38/cohppp.html
成都网站建设公司_创新互联,为您提供企业网站制作、关键词优化、微信小程序、网站内链、网站改版、电子商务
声明:本网站发布的内容(图片、视频和文字)以用户投稿、用户转载内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-86922220;邮箱:631063699@qq.com。内容未经允许不得转载,或转载时需注明来源: 创新互联