Example #1
0
        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();
        }
Example #2
0
        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();
        }
Example #3
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_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();
        }
Example #4
0
        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, "-请选择-");
        }
Example #5
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, "-请选择-");
 }
Example #6
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();
            }
        }
Example #9
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_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;
        }
Example #11
0
        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();
        }
Example #12
0
        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();
        }
Example #13
0
        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();
        }
Example #14
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_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();
 }
Example #15
0
 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();
 }
Example #16
0
        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();
        }