private void bindData() { DictSpecs ds = new DictSpecs(); Orion.Common.ISQLService sql = ds.Persistence.sql; DataView dv1 = new DataView(sql.ExecuteDataTable("select description,no1 from vw_area")); Chart1.Series[0].Points.DataBindXY(dv1, "description", dv1, "no1"); DataView dv2 = new DataView(sql.ExecuteDataTable("select description,no1 from vw_factory")); Chart2.Series[0].Points.DataBindXY(dv2, "description", dv2, "no1"); DataView dv3 = new DataView(sql.ExecuteDataTable("select description,no1 from vw_section")); Chart3.Series[0].Points.DataBindXY(dv3, "description", dv3, "no1"); }
private void bindData() { if (String.IsNullOrEmpty(txtEnd.Text)) { return; } if (String.IsNullOrEmpty(txtBegin.Text)) { return; } DateTime d1; DateTime d2; try { d1 = Convert.ToDateTime(txtBegin.Text); d2 = Convert.ToDateTime(txtEnd.Text); } catch (Exception e) { txtBegin.Text = ""; txtEnd.Text = ""; return; } Session["SelectDateBegin"] = txtBegin.Text; Session["SelectDateEnd"] = txtEnd.Text; string f = "%"; if (Request["factory"] != null) { f = Request["factory"]; } DictSpecs ds = new DictSpecs(); String sqlstring = String.Format(@"select area,factory,section,sum(checkposition) as checkposition, sum(passPosition) as passPosition,SectionNo as AreaNo from vw_jobmain2 where factory='{2}' and jobdate between '{0}' and '{1}' group by area,factory,section,sectionNo", txtBegin.Text, d2.AddDays(1).ToString("yyyy-MM-dd"), f); DataTable dt = ds.Persistence.sql.ExecuteDataTable(sqlstring); grdMain.DataSource = dt; grdMain.DataBind(); DataView dv = new DataView(dt); Chart3.Series[0].Points.DataBindXY(dv, "section", dv, "checkPosition"); Chart3.Series[1].Points.DataBindXY(dv, "section", dv, "passPosition"); Chart3.Series[2].Points.DataBindXY(dv, "section", dv, "AreaNo"); Orion.Common.ISQLService sql = ds.Persistence.sql; //DataView dvArea = new DataView(sql.ExecuteDataTable("")); }
private void bindData() { if (String.IsNullOrEmpty(txtEnd.Text)) return; if (String.IsNullOrEmpty(txtBegin.Text)) return; DateTime d1; DateTime d2; try { d1 = Convert.ToDateTime(txtBegin.Text); d2 = Convert.ToDateTime(txtEnd.Text); } catch (Exception e) { txtBegin.Text = ""; txtEnd.Text = ""; return; } Session["SelectDateBegin"] = txtBegin.Text; Session["SelectDateEnd"] = txtEnd.Text; string f = "%"; if (Request["factory"] != null) { f = Request["factory"]; } DictSpecs ds = new DictSpecs(); String sqlstring =String.Format(@"select area,factory,section,sum(checkposition) as checkposition, sum(passPosition) as passPosition,SectionNo as AreaNo from vw_jobmain2 where factory='{2}' and jobdate between '{0}' and '{1}' group by area,factory,section,sectionNo",txtBegin.Text,d2.AddDays(1).ToString("yyyy-MM-dd"),f); DataTable dt = ds.Persistence.sql.ExecuteDataTable(sqlstring); grdMain.DataSource = dt; grdMain.DataBind(); DataView dv = new DataView(dt); Chart3.Series[0].Points.DataBindXY(dv, "section", dv, "checkPosition"); Chart3.Series[1].Points.DataBindXY(dv, "section", dv, "passPosition"); Chart3.Series[2].Points.DataBindXY(dv, "section", dv, "AreaNo"); Orion.Common.ISQLService sql = ds.Persistence.sql; //DataView dvArea = new DataView(sql.ExecuteDataTable("")); }