private void Get_Real() { string[] str_data = new string[real_data.Split(';').Length - 1]; string stime = null; BLL.BLLRealQuery BRQ = new BLL.BLLRealQuery(); for (int i = 0; i < real_data.Split(';').Length; i++) { if (i != real_data.Split(';').Length - 1) { str_data[i] += real_data.Split(';')[i].Split(',')[0] + "," + real_data.Split(';')[i].Split(',')[1]; } else { stime = real_data.Split(';')[i].Split(',')[0]; } } list = BRQ.GetChartData_Real(str_data, stime); object obj = new { list = list }; Response.Clear(); string result = JsonConvert.SerializeObject(obj); Response.Write(result); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { string real_data_real = Request["real_data_real"]; string[] str_data = new string[real_data_real.Split(';').Length - 1]; string stime = null; BLL.BLLRealQuery BRQ = new BLL.BLLRealQuery(); for (int i = 0; i < real_data_real.Split(';').Length; i++) { if (i != real_data_real.Split(';').Length - 1) { str_data[i] += real_data_real.Split(';')[i].Split(',')[0]; } else { stime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } } string list_real = BRQ.GetChartRealData(str_data, stime); Response.Clear(); Response.Write(list_real); Response.End(); }
private void Sec_data_bind() { BLL.BLLRealQuery BLQ = new BLL.BLLRealQuery(); DataSet DS = BLQ.Get_Company_Info(out errMsg); DataSet DSS = BLQ.Get_Electric_Info(DS.Tables[0].Rows[0]["T_COMPANYID"].ToString(), out errMsg); DataSet DDS = BLQ.Get_Unit_Info(DSS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); this.sec_company.DataSource = DS.Tables[0].DefaultView; this.sec_company.DataTextField = "T_COMPANYDESC"; this.sec_company.DataValueField = "T_COMPANYID"; this.sec_company.DataBind(); this.sec_electric.DataSource = DSS.Tables[0].DefaultView; this.sec_electric.DataTextField = "T_PLANTDESC"; this.sec_electric.DataValueField = "T_PLANTID"; this.sec_electric.DataBind(); this.sec_crew.DataSource = DDS.Tables[0].DefaultView; this.sec_crew.DataTextField = "T_UNITDESC"; this.sec_crew.DataValueField = "T_UNITID"; this.sec_crew.DataBind(); DataSet DDDS = BLQ.Get_BASE_CRICPARA(DDS.Tables[0].Rows[0]["T_UNITID"].ToString(), out errMsg); //foreach (DataRow dr in .Tables[0].Rows) //{ // //ListItem li = new ListItem(); // //li.Value = dr["T_PARAID"].ToString(); // //li.Text = dr["T_PARADESC"].ToString(); // //li.Attributes.Add("alt", dr["T_PARAID"].ToString()); // //cbl_data_point.Items.Add(li); //} StringBuilder sb = new StringBuilder(); int count = 0; if (DDDS.Tables[0].Rows.Count > 0) { sb.Append("<table ><tr>"); //border=\"1\" for (int i = 0; i < DDDS.Tables[0].Rows.Count; i++) { count++; if (count % 7 == 0) { sb.Append("<td><input type='checkbox' name='" + DDDS.Tables[0].Rows[i][1].ToString() + "' value='" + DDDS.Tables[0].Rows[i][0].ToString() + "'>" + DDDS.Tables[0].Rows[i][1].ToString() + "<br></td></tr>"); } else { sb.Append("<td><input type='checkbox' name='" + DDDS.Tables[0].Rows[i][1].ToString() + "' value='" + DDDS.Tables[0].Rows[i][0].ToString() + "'>" + DDDS.Tables[0].Rows[i][1].ToString() + "</td>"); } if ((count % 7 != 0) && (i == DDDS.Tables[0].Rows.Count - 1)) { sb.Append("</tr>"); } //sb.Append(DS.Tables[0].Rows[i][0].ToString() + "," + DS.Tables[0].Rows[i][1].ToString() + ";"); } sb.Append("</table>"); } this.div_point_name.InnerHtml = sb.ToString(); }
private void Sec_data_bind() { BLL.BLLRealQuery BLQ = new BLL.BLLRealQuery(); DataSet DS = BLQ.Get_Company_Info(out errMsg); this.sec_company.DataSource = DS.Tables[0].DefaultView; this.sec_company.DataTextField = "T_COMPANYDESC"; this.sec_company.DataValueField = "T_COMPANYID"; this.sec_company.DataBind(); this.sec_company.Items.Insert(0, "-请选择-"); }
private void Sec_data_bind() { BLL.BLLRealQuery BLQ = new BLL.BLLRealQuery(); DataSet DS = BLQ.Get_Company_Info(out errMsg); DataSet DSS = BLQ.Get_Electric_Info(DS.Tables[0].Rows[0]["T_COMPANYID"].ToString(), out errMsg); DataSet DDS = BLQ.Get_Unit_Info(DSS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); this.sec_company.DataSource = DS.Tables[0].DefaultView; this.sec_company.DataTextField = "T_COMPANYDESC"; this.sec_company.DataValueField = "T_COMPANYID"; this.sec_company.DataBind(); this.sec_company.Items.Insert(0, "-请选择-"); }
private void Sec_data_bind() { BLL.BLLRealQuery BLQ = new BLL.BLLRealQuery(); DataSet DS = BLQ.Get_Company_Info(out errMsg); DataSet DSS = BLQ.Get_Electric_Info(DS.Tables[0].Rows[0]["T_COMPANYID"].ToString(), out errMsg); DataSet DDS = BLQ.Get_Unit_Info(DSS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); this.sec_company.DataSource = DS.Tables[0].DefaultView; this.sec_company.DataTextField = "T_COMPANYDESC"; this.sec_company.DataValueField = "T_COMPANYID"; this.sec_company.DataBind(); this.sec_company.Items.Insert(0, "-请选择-"); BLL.PerformanceAlarm.BLLUnitPerformance BUP = new BLL.PerformanceAlarm.BLLUnitPerformance(); DataSet DS_FC = BUP.GetFAULTCATEGORY(); DataSet DS_FP = BUP.GetFAULTPROPERTY(); DataSet DS_FT = BUP.GetFAULTPROFESSIONAL(); DataSet DS_FA = BUP.GetFAULTREASON(); this.cbl_yjlb.DataSource = DS_FC.Tables[0].DefaultView; this.cbl_yjlb.DataTextField = "T_CATEGORYDESC"; this.cbl_yjlb.DataValueField = "T_CATEGORYID"; this.cbl_yjlb.DataBind(); this.cbl_yjlb.Items[0].Selected = true; this.cbl_yjxz.DataSource = DS_FP.Tables[0].DefaultView; this.cbl_yjxz.DataTextField = "T_PROPERTYDESC"; this.cbl_yjxz.DataValueField = "T_PROPERTYID"; this.cbl_yjxz.DataBind(); this.cbl_yjxz.Items[0].Selected = true; this.cbl_yjzyfl.DataSource = DS_FT.Tables[0].DefaultView; this.cbl_yjzyfl.DataTextField = "T_PROFESSIONALDESC"; this.cbl_yjzyfl.DataValueField = "T_PROFESSIONALID"; this.cbl_yjzyfl.DataBind(); this.cbl_yjzyfl.Items[0].Selected = true; this.cbl_yjyyfl.DataSource = DS_FA.Tables[0].DefaultView; this.cbl_yjyyfl.DataTextField = "T_REASONDESC"; this.cbl_yjyyfl.DataValueField = "T_REASONID"; this.cbl_yjyyfl.DataBind(); this.cbl_yjyyfl.Items[0].Selected = true; }
private void Sec_data_bind() { BLL.BLLRealQuery BLQ = new BLL.BLLRealQuery(); DataSet DS = BLQ.Get_Company_Info(out errMsg); if (DS != null && DS.Tables[0].Rows.Count > 0) { DataSet DSS = BLQ.Get_Electric_Info(DS.Tables[0].Rows[0]["T_COMPANYID"].ToString(), out errMsg); DataSet DDS = BLQ.Get_Unit_Info(DSS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); this.sec_company.DataSource = DS.Tables[0].DefaultView; this.sec_company.DataTextField = "T_COMPANYDESC"; this.sec_company.DataValueField = "T_COMPANYID"; this.sec_company.DataBind(); this.sec_electric.DataSource = DSS.Tables[0].DefaultView; this.sec_electric.DataTextField = "T_PLANTDESC"; this.sec_electric.DataValueField = "T_PLANTID"; this.sec_electric.DataBind(); this.sec_crew.DataSource = DDS.Tables[0].DefaultView; this.sec_crew.DataTextField = "T_UNITDESC"; this.sec_crew.DataValueField = "T_UNITID"; this.sec_crew.DataBind(); } }
private void Sec_data_bind() { BLL.BLLRealQuery BLQ = new BLL.BLLRealQuery(); DataSet DS = BLQ.Get_Company_Info(out errMsg); DataSet DSS = BLQ.Get_Electric_Info(DS.Tables[0].Rows[0]["T_COMPANYID"].ToString(), out errMsg); DataSet DDS = BLQ.Get_Unit_Info(DSS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); this.sec_company.DataSource = DS.Tables[0].DefaultView; this.sec_company.DataTextField = "T_COMPANYDESC"; this.sec_company.DataValueField = "T_COMPANYID"; this.sec_company.DataBind(); this.sec_electric.DataSource = DSS.Tables[0].DefaultView; this.sec_electric.DataTextField = "T_PLANTDESC"; this.sec_electric.DataValueField = "T_PLANTID"; this.sec_electric.DataBind(); this.sec_crew.DataSource = DDS.Tables[0].DefaultView; this.sec_crew.DataTextField = "T_UNITDESC"; this.sec_crew.DataValueField = "T_UNITID"; this.sec_crew.DataBind(); DataSet DDDS = BLQ.Get_BASE_CRICPARA(DDS.Tables[0].Rows[0]["T_UNITID"].ToString(), out errMsg); //foreach (DataRow dr in .Tables[0].Rows) //{ // //ListItem li = new ListItem(); // //li.Value = dr["T_PARAID"].ToString(); // //li.Text = dr["T_PARADESC"].ToString(); // //li.Attributes.Add("alt", dr["T_PARAID"].ToString()); // //cbl_data_point.Items.Add(li); //} StringBuilder sb = new StringBuilder(); int count = 0; if (DDDS.Tables[0].Rows.Count > 0) { sb.Append("<table ><tr>");//border=\"1\" for (int i = 0; i < DDDS.Tables[0].Rows.Count; i++) { count++; if (count % 7 == 0) { sb.Append("<td><input type='checkbox' name='" + DDDS.Tables[0].Rows[i][1].ToString() + "' value='" + DDDS.Tables[0].Rows[i][0].ToString() + "'>" + DDDS.Tables[0].Rows[i][1].ToString() + "<br></td></tr>"); } else { sb.Append("<td><input type='checkbox' name='" + DDDS.Tables[0].Rows[i][1].ToString() + "' value='" + DDDS.Tables[0].Rows[i][0].ToString() + "'>" + DDDS.Tables[0].Rows[i][1].ToString() + "</td>"); } if ((count % 7 != 0) && (i == DDDS.Tables[0].Rows.Count - 1)) { sb.Append("</tr>"); } //sb.Append(DS.Tables[0].Rows[i][0].ToString() + "," + DS.Tables[0].Rows[i][1].ToString() + ";"); } sb.Append("</table>"); } this.div_point_name.InnerHtml=sb.ToString(); }
private void Sec_data_bind() { BLL.BLLRealQuery BLQ = new BLL.BLLRealQuery(); DataSet DS = BLQ.Get_Company_Info(out errMsg); DataSet DSS = BLQ.Get_Electric_Info(DS.Tables[0].Rows[0]["T_COMPANYID"].ToString(), out errMsg); DataSet DDS = BLQ.Get_Unit_Info(DSS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); this.sec_company.DataSource = DS.Tables[0].DefaultView; this.sec_company.DataTextField = "T_COMPANYDESC"; this.sec_company.DataValueField = "T_COMPANYID"; this.sec_company.DataBind(); this.sec_company.Items.Insert(0, "-请选择-"); BLL.PerformanceAlarm.BLLUnitPerformance BUP = new BLL.PerformanceAlarm.BLLUnitPerformance(); DataSet DS_FC= BUP.GetFAULTCATEGORY(); DataSet DS_FP = BUP.GetFAULTPROPERTY(); DataSet DS_FT = BUP.GetFAULTPROFESSIONAL(); DataSet DS_FA = BUP.GetFAULTREASON(); this.cbl_yjlb.DataSource = DS_FC.Tables[0].DefaultView; this.cbl_yjlb.DataTextField = "T_CATEGORYDESC"; this.cbl_yjlb.DataValueField = "T_CATEGORYID"; this.cbl_yjlb.DataBind(); this.cbl_yjlb.Items[0].Selected = true; this.cbl_yjxz.DataSource = DS_FP.Tables[0].DefaultView; this.cbl_yjxz.DataTextField = "T_PROPERTYDESC"; this.cbl_yjxz.DataValueField = "T_PROPERTYID"; this.cbl_yjxz.DataBind(); this.cbl_yjxz.Items[0].Selected = true; this.cbl_yjzyfl.DataSource = DS_FT.Tables[0].DefaultView; this.cbl_yjzyfl.DataTextField = "T_PROFESSIONALDESC"; this.cbl_yjzyfl.DataValueField = "T_PROFESSIONALID"; this.cbl_yjzyfl.DataBind(); this.cbl_yjzyfl.Items[0].Selected = true; this.cbl_yjyyfl.DataSource = DS_FA.Tables[0].DefaultView; this.cbl_yjyyfl.DataTextField = "T_REASONDESC"; this.cbl_yjyyfl.DataValueField = "T_REASONID"; this.cbl_yjyyfl.DataBind(); this.cbl_yjyyfl.Items[0].Selected = true; }
private void get_data() { string[] str_data = new string[real_data.Split(';').Length - 1]; string stime = null, etime = null; string max_data = "", min_data = ""; BLL.BLLRealQuery BRQ = new BLL.BLLRealQuery(); for (int i = 0; i < real_data.Split(';').Length; i++) { if (i != real_data.Split(';').Length - 1) { str_data[i] += real_data.Split(';')[i].Split(',')[0] + "," + real_data.Split(';')[i].Split(',')[1]; } else { stime = real_data.Split(';')[i].Split(',')[0]; etime = real_data.Split(';')[i].Split(',')[1]; } } list = BRQ.GetChartData(str_data, stime, etime, out max_data, out min_data); Hashtable data_dv = new Hashtable(); //data_dv.Add("时间", "时间"); ArrayList list1 = new ArrayList(); string[] str = new string[9] { "#058DC7", "#50B432", "#ED561B", "#DDDF00", "#24CBE5", "#64E572", "#FF9655", "#FFF263", "#6AF9C4" }; int num1 = 0; for (int i = 0; i < 600; i++) { //{'field':'name','title':'Name','width':100,'align':'center'}, int num = 0; Hashtable _dv = new Hashtable(); foreach (Hashtable _ht in list) { ArrayList _data = (ArrayList)_ht["data"]; if (i > _data.Count - 1) { break; } ArrayList _listdata = new ArrayList(); _listdata = (ArrayList)_data[i]; string _name = _ht["name"].ToString(); if (i == 0) { Hashtable _dv1 = new Hashtable(); _dv1.Add("lineColor", str[num1]); _dv1.Add("title", "{text:'" + _name + "'}"); //_dv.Add("opposite", true);//Y轴右端显示 _dv1.Add("lineWidth", 1); list1.Add(_dv1); num1++; } //string[] _val = (string[])_data["data"]; ////int[] _time = (int[])_val[0]; if (i == 0) { data_dv.Add(_name, _name); } //_dv.Add("name", _name); _dv.Add(_name, Math.Round(Convert.ToDouble(_listdata[1]), 2).ToString()); if (num == 0) { _dv.Add("时间", Convert.ToDouble(_listdata[0]).ToString()); // ConvertIntDatetime(Convert.ToDouble(_listdata[0])).ToString() } num++; } _list.Add(_dv); } name_list.Add(data_dv); object obj = new { max_data = max_data.TrimEnd(','), min_data = min_data.TrimEnd(','), title = "趋势呈现数据图", y_data = list1, list = list }; Response.Clear(); string result = JsonConvert.SerializeObject(obj); Response.Write(result); Response.End(); }
private void Sec_data_bind() { BLL.BLLRealQuery BLQ = new BLL.BLLRealQuery(); DataSet DS = BLQ.Get_Company_Info(out errMsg); this.sec_company.DataSource = DS.Tables[0].DefaultView; this.sec_company.DataTextField = "T_COMPANYDESC"; this.sec_company.DataValueField = "T_COMPANYID"; this.sec_company.DataBind(); this.sec_company.Items.Insert(0, "-请选择-"); BLL.DataManage.BLLUnitDataManage BDM = new BLL.DataManage.BLLUnitDataManage(); this.sec_type.DataSource = BDM.Get_Type().Tables[0].DefaultView; this.sec_type.DataTextField = "PARADESC"; this.sec_type.DataValueField = "PARA_ID"; this.sec_type.DataBind(); this.sec_type.Items.Insert(0, "-请选择-"); this.sec_data_type.DataSource = BDM.Get_Type().Tables[0].DefaultView; this.sec_data_type.DataTextField = "PARADESC"; this.sec_data_type.DataValueField = "PARA_ID"; this.sec_data_type.DataBind(); }
private void get_data() { string[] str_data = new string[real_data.Split(';').Length - 1]; string stime = null, etime = null; string max_data ="", min_data = ""; BLL.BLLRealQuery BRQ = new BLL.BLLRealQuery(); for (int i = 0; i < real_data.Split(';').Length; i++) { if (i != real_data.Split(';').Length - 1) { str_data[i] += real_data.Split(';')[i].Split(',')[0] + "," + real_data.Split(';')[i].Split(',')[1]; } else { stime = real_data.Split(';')[i].Split(',')[0]; etime = real_data.Split(';')[i].Split(',')[1]; } } list = BRQ.GetChartData(str_data, stime, etime, out max_data, out min_data); Hashtable data_dv = new Hashtable(); //data_dv.Add("时间", "时间"); ArrayList list1 = new ArrayList(); string[] str = new string[9] { "#058DC7", "#50B432", "#ED561B", "#DDDF00", "#24CBE5", "#64E572", "#FF9655", "#FFF263", "#6AF9C4" }; int num1 = 0; for (int i = 0; i < 600; i++) { //{'field':'name','title':'Name','width':100,'align':'center'}, int num = 0; Hashtable _dv = new Hashtable(); foreach (Hashtable _ht in list) { ArrayList _data = (ArrayList)_ht["data"]; if (i > _data.Count-1) { break; } ArrayList _listdata = new ArrayList(); _listdata = (ArrayList)_data[i]; string _name = _ht["name"].ToString(); if (i==0) { Hashtable _dv1 = new Hashtable(); _dv1.Add("lineColor", str[num1]); _dv1.Add("title", "{text:'" + _name + "'}"); //_dv.Add("opposite", true);//Y轴右端显示 _dv1.Add("lineWidth", 1); list1.Add(_dv1); num1++; } //string[] _val = (string[])_data["data"]; ////int[] _time = (int[])_val[0]; if (i==0) { data_dv.Add(_name, _name); } //_dv.Add("name", _name); _dv.Add(_name, Math.Round(Convert.ToDouble(_listdata[1]), 2).ToString()); if (num == 0) { _dv.Add("时间", Convert.ToDouble(_listdata[0]).ToString()); // ConvertIntDatetime(Convert.ToDouble(_listdata[0])).ToString() } num++; } _list.Add(_dv); } name_list.Add(data_dv); object obj = new { max_data = max_data.TrimEnd(','), min_data = min_data.TrimEnd(','), title = "趋势呈现数据图", y_data=list1, list = list }; Response.Clear(); string result = JsonConvert.SerializeObject(obj); Response.Write(result); Response.End(); }
private void Sec_data_bind() { BLL.BLLRealQuery BLQ = new BLL.BLLRealQuery(); DataSet DS = BLQ.Get_Company_Info(out errMsg); DataSet DSS = BLQ.Get_Electric_Info(DS.Tables[0].Rows[0]["T_COMPANYID"].ToString(), out errMsg); DataSet DDS = BLQ.Get_Unit_Info(DSS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); this.sec_company.DataSource = DS.Tables[0].DefaultView; this.sec_company.DataTextField = "T_COMPANYDESC"; this.sec_company.DataValueField = "T_COMPANYID"; this.sec_company.DataBind(); this.sec_electric.DataSource = DSS.Tables[0].DefaultView; this.sec_electric.DataTextField = "T_PLANTDESC"; this.sec_electric.DataValueField = "T_PLANTID"; this.sec_electric.DataBind(); this.sec_crew.DataSource = DDS.Tables[0].DefaultView; this.sec_crew.DataTextField = "T_UNITDESC"; this.sec_crew.DataValueField = "T_UNITID"; this.sec_crew.DataBind(); this.lb_point_name.DataSource = BLQ.Get_Para_Info(DDS.Tables[0].Rows[0]["T_UNITID"].ToString(), out errMsg); this.lb_point_name.DataTextField = "T_PARADESC"; this.lb_point_name.DataValueField = "T_PARAID"; this.lb_point_name.DataBind(); }
private void get_data() { string[] str_data = new string[real_data.Split(';').Length - 1]; string stime = null, etime = null; string max_data ="", min_data = ""; BLL.BLLRealQuery BRQ = new BLL.BLLRealQuery(); for (int i = 0; i < real_data.Split(';').Length; i++) { if (i != real_data.Split(';').Length - 1) { str_data[i] += real_data.Split(';')[i].Split(',')[0] + "," + real_data.Split(';')[i].Split(',')[1]; } else { stime = real_data.Split(';')[i].Split(',')[0]; etime = real_data.Split(';')[i].Split(',')[1]; } } DataTable dt = new DataTable(); list = BRQ.GetChartData(str_data, stime, etime, out max_data, out min_data); Hashtable data_dv = new Hashtable(); for (int i = 0; i < 600; i++) { //{'field':'name','title':'Name','width':100,'align':'center'}, int num = 0; Hashtable _dv = new Hashtable(); foreach (Hashtable _ht in list) { ArrayList _data = (ArrayList)_ht["data"]; ArrayList _listdata = new ArrayList(); _listdata = (ArrayList)_data[i]; string _name = _ht["name"].ToString(); //string[] _val = (string[])_data["data"]; ////int[] _time = (int[])_val[0]; if (i==0) { data_dv.Add(_name, _name); } //_dv.Add("name", _name); _dv.Add(_name, _listdata[1]); if (num != 0) { _dv.Add("时间", ConvertIntDatetime(Convert.ToDouble(_listdata[0])).ToString()); if (i == 0) { data_dv.Add("时间", "时间"); } } num++; } _list.Add(_dv); } name_list.Add(data_dv); //foreach (Hashtable _ht in list) //{ // string _name = _ht["name"].ToString(); // ArrayList _data = (ArrayList)_ht["data"]; // //string[] _val = (string[])_data["data"]; // ////int[] _time = (int[])_val[0]; // for (int i = 0; i < _data.Count; i++) // { // ArrayList _listdata = new ArrayList(); // _listdata = (ArrayList)_data[i]; // Hashtable _dv = new Hashtable(); // _dv.Add("name", _name); // _dv.Add("time", ConvertIntDatetime(Convert.ToDouble(_listdata[0])).ToString()); // _dv.Add("data", _listdata[1]); // _list.Add(_dv); // } //} object obj = new { max_data = max_data.TrimEnd(','), min_data = min_data.TrimEnd(','), title = "趋势呈现数据图", list = list }; Response.Clear(); string result = JsonConvert.SerializeObject(obj); Response.Write(result); Response.End(); }