protected void Page_Load(object sender, EventArgs e) { sec_type_real = Request["sec_type_real"]; electric_id_real = Request["electric_id_real"]; sec_crew_real = Request["sec_crew_real"]; if ((sec_type_real != "") && (sec_type_real != null)) { DataSet DS = BCA.Get_Electric_Info(sec_type_real, out errMsg); DataSet DDS = BCA.Get_Unit_Info(DS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); Return_dataset(DS); Return_dataset(DDS); } else if ((electric_id_real != "") && (electric_id_real != null)) { DataSet DS = BCA.Get_Unit_Info(electric_id_real, out errMsg); Return_dataset(DS); } else if ((sec_crew_real != "") && (sec_crew_real != null)) { BLL.PerformanceAlarm.BLLWarningThreshold BWT = new BLL.PerformanceAlarm.BLLWarningThreshold(); DataSet DS = BWT.GETKAOHRDIAN_DESC(sec_crew_real); Return_dataset(DS); } Response.Clear(); Response.Write(sb.ToString()); 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(); }
protected void Page_Load(object sender, EventArgs e) { sec_type_real = Request["sec_type_real"]; electric_id_real = Request["electric_id_real"]; PrpPara = Request["PrpPara"]; PrpPara_insert = Request["PrpPara_insert"]; pre_query = Request["pre_query"]; if ((sec_type_real != "") && (sec_type_real != null)) { DataSet DS = BCA.Get_Electric_Info(sec_type_real, out errMsg); DataSet DDS = BCA.Get_Unit_Info(DS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); Return_dataset(DS); Return_dataset(DDS); } else if ((electric_id_real != "") && (electric_id_real != null)) { DataSet DS = BCA.Get_Unit_Info(electric_id_real, out errMsg); Return_dataset(DS); } else if ((PrpPara != "") && (PrpPara != null)) { BLL.BLLProPara BPP = new BLL.BLLProPara(); DataSet DS = BPP.Get_Required_data(PrpPara.Split('|')[1], PrpPara.Split('|')[0]); if (DS.Tables[0].Rows.Count > 0) { for (int i = 0; i < DS.Tables[0].Columns.Count; i++) { sb.Append(DS.Tables[0].Rows[0][i].ToString() + ","); } sb.ToString().TrimEnd(','); } } else if ((PrpPara_insert != "") && (PrpPara_insert != null)) { BLL.BLLProPara BPP = new BLL.BLLProPara(); int num = 0; if (PrpPara_insert.Split('|')[0] == "1") { num = BPP.InsertProductionElementData(PrpPara_insert.Split('|')[1] + ",'" + DateTime.Now + "'"); } else { num = BPP.InsertProductionIndustryData(PrpPara_insert.Split('|')[1] + ",'" + DateTime.Now + "'"); } sb.Append(num); } else if ((pre_query != "") && (pre_query != null)) { BLL.BLLProPara BPP = new BLL.BLLProPara(); DataSet DS = BPP.GetProductionPreData(pre_query.Split(';')[0].Split(',')[0], pre_query.Split(';')[0].Split(',')[1], pre_query.Split(';')[1]); return_table(DS); } Response.Clear(); Response.Write(sb.ToString()); 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_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(); } }
protected void Page_Load(object sender, EventArgs e) { sec_type = Request["sec_type"]; electric_id = Request["electric_id"]; crew_id = Request["crew_id"]; sec_type_real = Request["sec_type_real"]; electric_id_real = Request["electric_id_real"]; crew_id_real = Request["crew_id_real"]; //风电、太阳能选项改变时,绑定DropDownLIst数据 if ((sec_type != "") && (sec_type != null)) { DataSet DS = BCA.Get_Electric_Info(sec_type, out errMsg); DataSet DDS = BCA.Get_Unit_Info(DS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); Return_dataset(DS); Return_dataset(DDS); DataSet DDDS = BCA.Get_BASE_CRICPARA(DDS.Tables[0].Rows[0]["T_UNITID"].ToString(), out errMsg); int count = 0; if (DDDS.Tables[0].Rows.Count > 0) { sb.Append("<table><tr>"); for (int i = 0; i < DDDS.Tables[0].Rows.Count; i++) { count++; if (count % 3 == 0) { sb.Append("<td width=\"300px\"><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 width=\"300px\"><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 % 3 != 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>"); } } //分公司选项改变时,绑定DropDownLIst数据 else if ((electric_id != "") && (electric_id != null)) { Return_dataset(BCA.Get_Unit_Info(electric_id, out errMsg)); DataSet DDDS = BCA.Get_BASE_CRICPARA(BCA.Get_Unit_Info(electric_id, out errMsg).Tables[0].Rows[0]["T_UNITID"].ToString(), out errMsg); 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>"); } } else if ((crew_id != "") && (crew_id != null)) { DataSet DDDS = BCA.Get_BASE_CRICPARA(crew_id, out errMsg); 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>"); } } else if ((sec_type_real != "") && (sec_type_real != null)) { DataSet DS = BCA.Get_Electric_Info(sec_type_real, out errMsg); DataSet DDS = BCA.Get_Unit_Info(DS.Tables[0].Rows[0]["T_PLANTID"].ToString(), out errMsg); DataSet DDDS = BCA.Get_Para_Info(DDS.Tables[0].Rows[0]["T_UNITID"].ToString(), out errMsg); Return_dataset(DS); Return_dataset(DDS); Return_dataset(DDDS); } else if ((electric_id_real != "") && (electric_id_real != null)) { DataSet DS = BCA.Get_Unit_Info(electric_id_real, out errMsg); DataSet DDS = BCA.Get_Para_Info(DS.Tables[0].Rows[0]["T_UNITID"].ToString(), out errMsg); Return_dataset(DS); Return_dataset(DDS); } else if ((crew_id_real != "") && (crew_id_real != null)) { DataSet DS = BCA.Get_Para_Info(crew_id_real, out errMsg); Return_dataset(DS); } Response.Clear(); Response.Write(sb.ToString()); 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); 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); 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(); }