//绑定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();
}
}
//绑定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(','));
}
}
