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();
}
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_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, "-请选择-");
}
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();
}