受不了了 internal static void SetCharControl5(ChartControl chartControl, DataTable dataTable, ViewType viewType, string columnname, string title)
{
chartControl.Series.Clear();//你懂得
chartControl.Titles.Clear();//同上
List<string> TypeList = new List<string>();
//查询运输类型数量
foreach (DataRow dataRow in dataTable.Rows)
{
string caption = dataRow[columnname].ToString();
if (!TypeList.Contains(caption))
TypeList.Add(caption);
}
Series bases = new Series("test",viewType);
for (int i = 0; i < TypeList.Count; i++)
{
Series series = new Series(TypeList[i], viewType);
foreach (DataRow dataRow in dataTable.Rows)
{
string caption = dataRow[columnname].ToString();
if (caption == TypeList[i])
{
//string week = dataRow["T_WEEK"] as string; 居然返回null
int week = Convert.ToInt32(dataRow["T_WEEK"]);
if (week==0) continue;
series.Points.Add(new SeriesPoint(week,
new double[] { Convert.ToDouble(dataRow["TOTAL_COST"]) }));
bases.Points.Add(new SeriesPoint(week, new double[] {0}));
} }
chartControl.Series.Add(series);
//chartControl.SeriesSorting = SortingMode.Ascending;
}表结构
T_WEEK TRANS_MODEL TOTAL_COST T_YEAR
12 航空运输 3323 2009
15 航空运输 700 2009
10 江海运输 0 2009这个我现在要生成图片 我用以上方法写了过程
生成的图片 按道理说 应该先显示10 然后 12 15现在却是 先12 15 10怎么改都没用 这控件参考资料极少
{
chartControl.Series.Clear();//你懂得
chartControl.Titles.Clear();//同上
List<string> TypeList = new List<string>();
//查询运输类型数量
foreach (DataRow dataRow in dataTable.Rows)
{
string caption = dataRow[columnname].ToString();
if (!TypeList.Contains(caption))
TypeList.Add(caption);
}
Series bases = new Series("test",viewType);
for (int i = 0; i < TypeList.Count; i++)
{
Series series = new Series(TypeList[i], viewType);
foreach (DataRow dataRow in dataTable.Rows)
{
string caption = dataRow[columnname].ToString();
if (caption == TypeList[i])
{
//string week = dataRow["T_WEEK"] as string; 居然返回null
int week = Convert.ToInt32(dataRow["T_WEEK"]);
if (week==0) continue;
series.Points.Add(new SeriesPoint(week,
new double[] { Convert.ToDouble(dataRow["TOTAL_COST"]) }));
bases.Points.Add(new SeriesPoint(week, new double[] {0}));
} }
chartControl.Series.Add(series);
//chartControl.SeriesSorting = SortingMode.Ascending;
}表结构
T_WEEK TRANS_MODEL TOTAL_COST T_YEAR
12 航空运输 3323 2009
15 航空运输 700 2009
10 江海运输 0 2009这个我现在要生成图片 我用以上方法写了过程
生成的图片 按道理说 应该先显示10 然后 12 15现在却是 先12 15 10怎么改都没用 这控件参考资料极少
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货