protected void DPLSELECTVENDOR_SelectedIndexChanged1(object sender, EventArgs e) { ArrayList ColorGuider = new ArrayList(); ArrayList[] DataArray = { new ArrayList(), new ArrayList(), new ArrayList() }; ArrayList XLabel = new ArrayList(); ColorGuider.Add("unit rate"); ColorGuider.Add("travel time"); ColorGuider.Add("travel cost"); cmd.CommandText = "select pricepercomponent from quatation where vendorname='" + DPLSELECTVENDOR.SelectedItem.Text + "'and componentname='" + Session["component"] + "'"; DataArray[0].Add(Convert.ToInt32(cmd.ExecuteScalar())); cmd.CommandText = "select traveltime from quatation where vendorname='" + DPLSELECTVENDOR.SelectedItem.Text + "'and componentname='" + Session["component"] + "'"; DataArray[1].Add(Convert.ToInt32(cmd.ExecuteScalar())); cmd.CommandText = "select travelcost from quatation where vendorname='" + DPLSELECTVENDOR.SelectedItem.Text + "'and componentname='" + Session["component"] + "'"; DataArray[2].Add(Convert.ToInt32(cmd.ExecuteScalar())); Chartlet1.ChartTitle.Text = "VENDOR STATUS"; Chartlet1.XLabels.UnitText = "VENDOR"; Chartlet1.YLabels.UnitText = "RUPEES"; Chartlet1.InitializeData(DataArray, XLabel, ColorGuider); XLabel.Add("status"); }
protected void Page_Load(object sender, EventArgs e) { //X坐标轴标识数组 //Labels on X Axis ArrayList XTitle = new ArrayList(); XTitle.Add("East"); XTitle.Add("South"); XTitle.Add("West"); XTitle.Add("North"); XTitle.Add("NorthEast"); XTitle.Add("SouthWest"); XTitle.Add("NorthWest"); //图表数据(1组) //Chart Data ArrayList[] ChartData = new ArrayList[1]; ChartData[0] = new ArrayList(); ChartData[0].Add(80); ChartData[0].Add(40); ChartData[0].Add(30); ChartData[0].Add(24); ChartData[0].Add(22); ChartData[0].Add(20); ChartData[0].Add(16); Chartlet1.InitializeData(ChartData, XTitle, null); Chartlet1.ChartTitle = "nihao"; }
private void init() { string id = Request.QueryString["ProductsID"]; if (id == null) { Response.End(); return; } int ids = int.Parse(id); DataSet ds = new DataSet(); ds = Leyp.SQLServerDAL.Factory.getProductsStockDAL().getDataSetByProductsID(ids); DataTable dd = ds.Tables["dd"]; ArrayList XTitle = new ArrayList(); ArrayList[] ChartData = new ArrayList[1]; ChartData[0] = new ArrayList(); if (dd != null) { foreach (DataRow dr in dd.Rows) { XTitle.Add(dr[6].ToString().Substring(0, 4) + "-" + dr[5].ToString()); ChartData[0].Add(Int32.Parse(dr[4].ToString())); } Chartlet1.InitializeData(ChartData, XTitle, null); Chartlet1.ChartTitle = "商品分布图"; } }
public void LoadData() { /*** * 这里就不用数据库了,手动添加一些数据。你正式使用时,是不需要这么繁琐的,只要绑定一个数据源既可。 * 数据库绑定请参看下面的四个构造函数 * void BindChartData(SqlDataSource) * void BindChartData(DataSet) * void BindChartData(DataView) * void BindChartData(DataTable) * ****/ ArrayList ColorGuider = new ArrayList(); ArrayList[] DataArray = { new ArrayList(), new ArrayList(), new ArrayList() }; ArrayList XLabel = new ArrayList(); //1.Set data by manual, you can read data from database use below statements //手动添加数据,你也可以使用下面的代码从数据库中读取数据 ColorGuider.Add("cost/sample"); ColorGuider.Add("travel time"); ColorGuider.Add("trevel cost"); XLabel.Add("East"); XLabel.Add("South"); XLabel.Add("West"); XLabel.Add("North"); //Chartlet1.TipsShow = false; DataArray[0].Add(200); DataArray[0].Add(45.2); DataArray[0].Add(33.69); DataArray[0].Add(60.20); DataArray[1].Add(76.1); DataArray[1].Add(68); DataArray[1].Add(43); DataArray[1].Add(10); DataArray[2].Add(10); DataArray[2].Add(77); DataArray[2].Add(15); DataArray[2].Add(79); Chartlet1.ChartTitle.Text = "vipin chandran p"; Chartlet1.XLabels.UnitText = "Region"; Chartlet1.YLabels.UnitText = "Yield / %"; Chartlet1.InitializeData(DataArray, XLabel, ColorGuider); }
/**** 请用BindChartData()方法绑定数据 ****/ public void LoadData(string cs) { ArrayList ColorGuider = new ArrayList(); ArrayList[] DataArray = { new ArrayList(), new ArrayList(), new ArrayList() }; ArrayList XLabel = new ArrayList(); //1.Set data by manual, you can read data from database use below statements //手动添加数据,你也可以使用下面的代码从数据库中读取数据 ColorGuider.Add("Laura"); ColorGuider.Add("Jesy"); ColorGuider.Add("Linda"); XLabel.Add("East"); XLabel.Add("South"); XLabel.Add("West"); XLabel.Add("North"); //Chartlet1.TipsShow = false; DataArray[0].Add(98.9); DataArray[0].Add(45.2); DataArray[0].Add(33.69); DataArray[0].Add(60.20); DataArray[1].Add(76.1); DataArray[1].Add(68); DataArray[1].Add(43); DataArray[1].Add(10); DataArray[2].Add(10); DataArray[2].Add(77); DataArray[2].Add(15); DataArray[2].Add(79); Chartlet1.ChartTitle.Text = "Chartlet Demo"; Chartlet1.XLabels.UnitText = "Region"; Chartlet1.YLabels.UnitText = "Yield / %"; Chartlet1.InitializeData(DataArray, XLabel, ColorGuider); }
public void LoadData() { /**** * void BindChartData(SqlDataSource) * void BindChartData(DataSet) * void BindChartData(DataView) * void BindChartData(DataTable) * ****/ cmd.CommandText = "select count(*) from quatation where componentname='" + Session["component"].ToString() + "'"; int count = Convert.ToInt32(cmd.ExecuteScalar()); ArrayList ColorGuider = new ArrayList(); ArrayList[] DataArray = { new ArrayList(), new ArrayList(), new ArrayList() }; ArrayList XLabel = new ArrayList(); //1.Set data by manual, you can read data from database use below statements ColorGuider.Add("unit rate"); ColorGuider.Add("travel time"); ColorGuider.Add("travel cost"); //DPLORDEREDCOMPONENTS.Items.Insert(0, "COMPONENTS"); XLabel.Add("VENDOR"); //Chartlet1.TipsShow = false; //ok /* * DataArray[0].Add(200); * DataArray[0].Add(45.2); * DataArray[0].Add(33.69); * DataArray[0].Add(60.20); * DataArray[0].Add(34); * * * DataArray[1].Add(76.1); * DataArray[1].Add(68); * DataArray[1].Add(43); * DataArray[1].Add(10); * DataArray[1].Add(167); * * DataArray[2].Add(10); * DataArray[2].Add(77); * DataArray[2].Add(15); * DataArray[2].Add(79); * DataArray[2].Add(56); */ //ok cmd.CommandText = "select pricepercomponent from quatation where vendorname='" + DPLSELECTVENDOR.SelectedItem.Text + "' and componentname='" + Session["component"] + "'"; DataArray[0].Add(Convert.ToInt32(cmd.ExecuteScalar())); cmd.CommandText = "select traveltime from quatation where vendorname='" + DPLSELECTVENDOR.SelectedItem.Text + "'and componentname='" + Session["component"] + "'"; DataArray[1].Add(Convert.ToInt32(cmd.ExecuteScalar())); cmd.CommandText = "select travelcost from quatation where vendorname='" + DPLSELECTVENDOR.SelectedItem.Text + "'and componentname='" + Session["component"] + "'"; DataArray[2].Add(Convert.ToInt32(cmd.ExecuteScalar())); Chartlet1.ChartTitle.Text = "VENDOR STATUS"; Chartlet1.XLabels.UnitText = "VENDOR"; Chartlet1.YLabels.UnitText = "RUPEES"; Chartlet1.InitializeData(DataArray, XLabel, ColorGuider); XLabel.Add("status"); }
/// <summary> /// 绑定图表 /// </summary> /// <param name="whereStr">当前筛选条件</param> /// <param name="type">1表示试卷名或姓名,2表示专业名,3表示科目名</param> public void LoadData(string whereStr, int type) { if (scoreList.Rows.Count > 0) { Chartlet1.AppearanceStyle = (FanG.Chartlet.AppearanceStyles)System.Enum.Parse(typeof(FanG.Chartlet.AppearanceStyles), "Bar_3D_Aurora_NoCrystal_NoGlow_NoBorder", true); DataTable classListTable = TbScoreManager.GetClassList(whereStr, type); ArrayList classList = new ArrayList(); foreach (DataRow classRow in classListTable.Rows) { classList.Add(classRow["BjName"]); } DataTable testpaperListTable = TbScoreManager.GetTestPaperList(whereStr, type); ArrayList testpaperList = new ArrayList(); foreach (DataRow testRow in testpaperListTable.Rows) { testpaperList.Add(testRow["SjName"]); } ArrayList[] DataArray = new ArrayList[testpaperList.Count]; for (int i = 0; i < DataArray.Length; i++) { DataArray[i] = new ArrayList(); int sjid = int.Parse(testpaperListTable.Rows[i]["SjiD"].ToString()); float sjZongScore = TbQuestionTypesManager.GetSumScoreBySjid(sjid); for (int j = 0; j < classList.Count; j++) { string nowClassName = classList[j].ToString(); float sumScore = 0; DataTable dtScorelist = TbScoreManager.GetScoreListBySjidAndClassname(sjid, nowClassName); if (dtScorelist.Rows.Count > 0) { foreach (DataRow row in dtScorelist.Rows) { float score = 0; if (float.Parse(row["DxtScore"].ToString()) > 0) { score += float.Parse(row["DxtScore"].ToString()); } if (float.Parse(row["DuoxtScore"].ToString()) > 0) { score += float.Parse(row["DuoxtScore"].ToString()); } if (float.Parse(row["PdtScore"].ToString()) > 0) { score += float.Parse(row["PdtScore"].ToString()); } if (float.Parse(row["ZgtScore"].ToString()) > 0) { score += float.Parse(row["ZgtScore"].ToString()); } sumScore += score; } float avgScore = sumScore / dtScorelist.Rows.Count; DataArray[i].Add(avgScore / sjZongScore * 100); } } } string title = ""; switch (type) { case 1: if (whereStr == "") { title = "全部"; } else { title = "筛选:" + whereStr; } break; case 2: title = "专业:" + whereStr; break; case 3: title = "科目:" + whereStr; break; } Chartlet1.ChartTitle.Text = title; Chartlet1.XLabels.UnitText = "班级/平均分"; Chartlet1.YLabels.UnitText = "总分"; Chartlet1.MaxValueY = 100; Chartlet1.InitializeData(DataArray, classList, testpaperList); } }