//绑定DropDownList默认数据 private void BindData() { BLL.BLLGet_chart_Data DGD = new BLL.BLLGet_chart_Data(); //if (this.sec_type.Items[this.sec_type.SelectedIndex].Value == "T_BASE_PARAID_WIND") //{ DataSet DS = DGD.Get_Paraid("administrator.T_BASE_CHARTPARAID", "T_LEVEL1", "11"); if (DS != null && DS.Tables[0].Rows.Count > 0) { DataSet DDS = DGD.Get_Paraid("administrator.T_BASE_CHARTPARAID", "T_LEVEL2", DS.Tables[0].Rows[0][0].ToString()); DataSet DDDS = DGD.Get_Paraid("administrator.T_BASE_CHARTPARAID", "T_LEVEL3", DDS.Tables[0].Rows[0][0].ToString()); this.ddl_level1.DataSource = DS; this.ddl_level1.DataTextField = "T_LEVEL1"; this.ddl_level1.DataValueField = "T_LEVEL1"; this.ddl_level1.DataBind(); this.ddl_level2.DataSource = DDS; this.ddl_level2.DataTextField = "T_LEVEL2"; this.ddl_level2.DataValueField = "T_LEVEL2"; this.ddl_level2.DataBind(); this.ddl_level3.DataSource = DDDS; this.ddl_level3.DataTextField = "T_LEVEL3"; this.ddl_level3.DataValueField = "T_LEVEL3"; this.ddl_level3.DataBind(); } }
/// <summary> /// 保存测点,趋势模板 /// </summary> /// <param name="id">测点集合</param> private void ChangePara(string id) { BLL.BLLGet_chart_Data DGD = new BLL.BLLGet_chart_Data(); if (id.Split('&')[0] == "1") { if (id.Split('&')[2] == "") { DGD.Delete_Chart_All(id.Split('&')[1]); } else { DGD.Delete_Chart(id.Split('&')[1]); for (int i = 0; i < id.Split('&')[2].Split(',').Length; i++) { DGD.Insert_paraid_ByChartid(id.Split('&')[1], id.Split('&')[2].Split(',')[i].Split('|')[0]); } //string str = ""; //for (int i = 0; i < id.Split('&')[2].Split(',').Length; i++) //{ // str += "'" + id.Split('&')[2].Split(',')[i].Split('|')[0] + "'"; // if ((id.Split('&')[2].Split(',').Length == 1) || (i != id.Split('&')[2].Split(',').Length - 1)) // { // str += ","; // } //} //DGD.Delete_Paraid(id.Split('&')[0], str); } } else if (id.Split('&')[0] == "2") { string num = ""; if (DGD.Select_ChartId().Tables[0].Rows.Count > 0) { num = DGD.Select_ChartId().Tables[0].Rows[0][0].ToString(); } else { num = "1"; } DGD.Insert_ChartId(num, id.Split('&')[2].ToString(), id.Split('&')[1].ToString()); for (int i = 0; i < id.Split('&')[3].Split(',').Length; i++) { if (DGD.Select_Para_id(num, id.Split('&')[2].ToString()).Tables[0].Rows.Count <= 0) { DGD.Insert_para_id(id.Split('&')[3].Split(',')[i].Split('|')[0]); } } } }
/// <summary> /// 解析测点并画曲线 /// </summary> /// <param name="id"></param> private void GetPara_id(string id) { BLL.BLLGet_chart_Data DGD = new BLL.BLLGet_chart_Data(); DataSet DS = DGD.GetPara_id(chart_id); string str = ""; for (int i = 0; i < DS.Tables[0].Rows.Count; i++) { str += DS.Tables[0].Rows[i]["REALTIME"].ToString() + "|" + DS.Tables[0].Rows[i]["PARADESC"].ToString(); if ((DS.Tables[0].Rows.Count != 1) || (i != DS.Tables[0].Rows.Count - 1)) { str += ","; } } if (str != "") { GET_PARANAME(str.TrimEnd(',')); } }
/// <summary> /// 保存测点,趋势模板 /// </summary> /// <param name="id">测点集合</param> private void ChangePara(string id) { BLL.BLLGet_chart_Data DGD = new BLL.BLLGet_chart_Data(); if (id.Split('&')[0] == "1") { if (id.Split('&')[2] == "") { DGD.Delete_Chart_All(id.Split('&')[1]); } else { DGD.Delete_Chart(id.Split('&')[1]); for (int i = 0; i < id.Split('&')[2].Split(',').Length; i++) { DGD.Insert_paraid_ByChartid(id.Split('&')[1], id.Split('&')[2].Split(',')[i].Split('|')[0]); } } } else if (id.Split('&')[0] == "2") { string num = ""; if (DGD.Select_ChartId().Tables[0].Rows.Count > 0) { num = DGD.Select_ChartId().Tables[0].Rows[0][0].ToString(); } else { num = "1"; } DGD.Insert_ChartId(num, id.Split('&')[2].ToString(), id.Split('&')[1].ToString()); for (int i = 0; i < id.Split('&')[3].Split(',').Length; i++) { if (DGD.Select_Para_id(num, id.Split('&')[2].ToString()).Tables[0].Rows.Count <= 0) { DGD.Insert_para_id(id.Split('&')[3].Split(',')[i].Split('|')[0]); } } } }
/// <summary> /// 解析测点并画曲线 /// </summary> /// <param name="id"></param> private void GetPara_id(string id) { BLL.BLLGet_chart_Data DGD = new BLL.BLLGet_chart_Data(); DataSet DS = DGD.GetPara_id(chart_id); string str = ""; for (int i = 0; i < DS.Tables[0].Rows.Count; i++) { str += DS.Tables[0].Rows[i]["T_REALTIME"].ToString() + "|" + DS.Tables[0].Rows[i]["T_PARADESC"].ToString(); if ((DS.Tables[0].Rows.Count != 1) || (i != DS.Tables[0].Rows.Count - 1)) { str += ","; } } if (str != "") { GET_PARANAME(str.TrimEnd(',')); } }