protected void lbtn_refresh_Click(object sender, EventArgs e)
    {
        string dtss        = datemin.Value + " " + datemax.Value;
        string dtes        = datemin.Value + " " + datemax2.Value;
        string cequ        = ddl_cequ.SelectedValue;
        string gongzuomain = ddl_gongzuomian.SelectedValue;
        string strConn     = ConfigurationManager.ConnectionStrings["webConnectionString"].ToString();

        DrawImage.DrawingCurve dc = new DrawImage.DrawingCurve(strConn);
        Bitmap img = DrawImage.DrawingCurve.DrawingImg26(cequ, gongzuomain, dtss, dtes);
        string str = Server.MapPath("./xiazai/");

        img.Save(str + "huozhusuoliangfenxi.jpg");
        img1.Src = "xiazai/huozhusuoliangfenxi.jpg";

        string  sql = "select * from PressurePar where areaname='" + ddl_cequ.SelectedValue + "' and facename='" + gongzuomain + "'";
        DataSet ds  = DB.ExecuteSqlDataSet(sql, null);

        if (ds.Tables[0].Rows.Count > 0)
        {
            sql = "select * from HuoZhuPar where areaName='" + ddl_cequ.SelectedValue + "' and FaceName='" + gongzuomain + "'";
            ds  = DB.ExecuteSqlDataSet(sql, null);
            if (ds.Tables[0].Rows.Count > 0)
            {
                txtsuoliangyujingzhi.Value  = ds.Tables[0].Rows[0]["YujingValue"].ToString();
                txtsuoliangbaojingzhi.Value = ds.Tables[0].Rows[0]["AlarmValue"].ToString();
            }
        }
        sql = "select * from HuoZhuSenInfo where areaName='" + ddl_cequ.SelectedValue + "' and FaceName='" + gongzuomain + "'";
        ds  = DB.ExecuteSqlDataSet(sql, null);
        txtchuanganqizushu.Value = ds.Tables[0].Rows.Count.ToString();
    }
    protected void search_Click(object sender, EventArgs e)
    {
        string    dts       = datemin.Value;
        string    dte       = datemax.Value;
        string    cequ      = ddl_cequ.SelectedValue;
        string    gzm       = ddl_gongzuomian.SelectedValue;
        string    zjbh      = ddl_zhijiabianhao.SelectedValue;
        DataTable dt_img    = new DataTable();
        DataTable dt_export = new DataTable();
        string    strConn   = ConfigurationManager.ConnectionStrings["webConnectionString"].ToString();

        DrawImage.DrawingCurve dc = new DrawImage.DrawingCurve(strConn);
        Bitmap img  = DrawImage.DrawingCurve.DrawingImg6(cequ, gzm, "4", zjbh, dts, dte, dt_img, dt_export);
        string str  = Server.MapPath("./xiazai/");
        string str2 = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "ZhongCaiGongZuoZuLiLiShiShuJuFenXiQuxian.jpg";

        img.Save(str + str2);
        panel1.BackImageUrl = "xiazai/" + str2;
        StringBuilder sb = new StringBuilder();

        sb.Append("[");
        for (int i = 0; i < dt_img.Rows.Count; i++)
        {
            if (i == 0)
            {
                sb.Append("{");
            }
            else
            {
                sb.Append(",{");
            }
            sb.Append(string.Format("\"{0}\":\"{1}\"", "content", dt_img.Rows[i]["content"].ToString()));
            sb.Append("}");
        }
        sb.Append("]");
        txtjson.Text = sb.ToString();

        //进尺数据
        string  sql = "select sum(hcjcnose) hcjcnose,sum(hcjcmid) hcjcmid,sum(hcjctail) hcjctail from Huicai where AreaName = '" + cequ + "' and FaceName = '" + gzm + "'";// and left(convert(nvarchar(50),datetime,20),10) <='" + t2 + "' ";
        DataSet ds  = DB.ExecuteSqlDataSet(sql, null);

        if (ds.Tables[0].Rows.Count > 0)
        {
            head.Value = ds.Tables[0].Rows[0]["hcjcnose"].ToString() == "" ? "0.00" : ds.Tables[0].Rows[0]["hcjcnose"].ToString();
            body.Value = ds.Tables[0].Rows[0]["hcjcmid"].ToString() == "" ? "0.00" : ds.Tables[0].Rows[0]["hcjcmid"].ToString();
            foot.Value = ds.Tables[0].Rows[0]["hcjctail"].ToString() == "" ? "0.00" : ds.Tables[0].Rows[0]["hcjctail"].ToString();
        }
        else
        {
            head.Value = "0.00";
            body.Value = "0.00";
            foot.Value = "0.00";
        }
    }
Exemple #3
0
    protected void search_Click(object sender, EventArgs e)
    {
        string    dts       = datemin.Value;
        string    dte       = datemax.Value;
        string    cequ      = ddl_cequ.SelectedValue;
        string    gzm       = ddl_gongzuomian.SelectedValue;
        string    zjbh      = ddl_zhijiabianhao.SelectedValue;
        DataTable dt_img    = new DataTable();
        DataTable dt_export = new DataTable();
        string    zhu       = "1";//左柱

        if (zuozhu.Checked == true)
        {
            zhu = "1";
        }
        if (youzhu.Checked == true)
        {
            zhu = "2";
        }
        string strConn = ConfigurationManager.ConnectionStrings["webConnectionString"].ToString();

        DrawImage.DrawingCurve dc = new DrawImage.DrawingCurve(strConn);
        //Bitmap img = DrawImage.DrawingCurve.DrawingImg(cequ, gzm, zjbh, dts, dte);
        decimal CCL     = Convert.ToDecimal(ConfigurationManager.ConnectionStrings["CCmin"].ToString());
        decimal ZLvalue = Convert.ToDecimal(ConfigurationManager.ConnectionStrings["ZLvalue"].ToString());
        Bitmap  img     = DrawImage.DrawingCurve.DrawingImg9(cequ, gzm, zhu, zjbh, dts, dte, dt_img, dt_export, CCL, ZLvalue);
        string  str     = Server.MapPath("./xiazai/");
        string  str2    = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "anquanfakaiqiquxian.jpg";

        img.Save(str + str2);
        panel1.BackImageUrl = "xiazai/" + str2;
        StringBuilder sb = new StringBuilder();

        sb.Append("[");
        for (int i = 0; i < dt_img.Rows.Count; i++)
        {
            if (i == 0)
            {
                sb.Append("{");
            }
            else
            {
                sb.Append(",{");
            }
            sb.Append(string.Format("\"{0}\":\"{1}\"", "content", dt_img.Rows[i]["content"].ToString()));
            sb.Append("}");
        }
        sb.Append("]");
        txtjson.Text = sb.ToString();
    }
    protected void search_Click(object sender, EventArgs e)
    {
        string url = datemin.Value;

        if (url == "")
        {
            SystemTool.AlertShow(this, "开始日期不能为空");
            return;
        }
        url = datemax.Value;
        if (url == "")
        {
            SystemTool.AlertShow(this, "结束日期不能为空");
            return;
        }
        string riqi        = datemin.Value;
        string riqi2       = datemax.Value;
        string t1          = "00:00:00"; // datemax.Value;
        string t2          = "23:59:59"; // datemax2.Value;
        string cequ        = ddl_cequ.SelectedValue;
        string gongzuomian = ddl_gongzuomian.SelectedValue;
        string yz          = ConfigurationManager.ConnectionStrings["YuZhi"].ToString();//小于此值,舍去yuzhi.Value;
        string zhu         = "3";
        string strConn     = ConfigurationManager.ConnectionStrings["webConnectionString"].ToString();

        DrawImage.DrawingCurve dc = new DrawImage.DrawingCurve(strConn);
        Bitmap img  = DrawImage.DrawingCurve.DrawingImg10_0(cequ, gongzuomian, zhu, yz, riqi, riqi2 + " " + t2);
        string str  = Server.MapPath("./xiazai/");
        string str2 = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "MeiRiGongZuoZuLiFenBuQuXian.jpg";

        img.Save(str + str2);
        img1.ImageUrl           = "xiazai/" + str2;
        ViewState["date"]       = riqi;
        ViewState["date2"]      = riqi2;
        ViewState["baojingzhi"] = "0";
        ViewState["yujingzhi"]  = "0";
        string  sqlbjz = "select * from dbo.PressurePar where areaname='" + cequ + "' and facename='" + gongzuomian + "'";
        DataSet result = DB.ExecuteSqlDataSet(sqlbjz, null);

        if (result.Tables[0].Rows.Count > 0)
        {
            ViewState["baojingzhi"] = result.Tables[0].Rows[0]["pressuremax"].ToString();
            ViewState["yujingzhi"]  = result.Tables[0].Rows[0]["pressuremin"].ToString();
        }
    }
Exemple #5
0
    protected void search_Click(object sender, EventArgs e)
    {
        string       time1          = datemin.Value;
        string       time2          = datemax.Value;
        string       cequ           = ddl_cequ.SelectedValue;
        string       roadway        = ddl_roadway.SelectedValue;
        string       maoguleixing   = ddl_maoguleixing.SelectedValue;
        string       anzhuangweizhi = ddl_anzhuangweizhi.SelectedValue;
        DrawingCurve MyDc           = new DrawingCurve();
        DataTable    a       = new DataTable();
        DataTable    b       = new DataTable();
        string       strConn = ConfigurationManager.ConnectionStrings["webConnectionString"].ToString();

        DrawImage.DrawingCurve dc = new DrawImage.DrawingCurve(strConn);
        Bitmap img = DrawImage.DrawingCurve.DrawingImg22(cequ, roadway, maoguleixing, anzhuangweizhi, time1, time2, a);
        string str = Server.MapPath("./xiazai/");

        img.Save(str + "maoganmaosuoshujufenxi.jpg");
        panel1.BackImageUrl = "xiazai/maoganmaosuoshujufenxi.jpg";
        StringBuilder sb = new StringBuilder();

        sb.Append("[");
        for (int i = 0; i < a.Rows.Count; i++)
        {
            if (i == 0)
            {
                sb.Append("{");
            }
            else
            {
                sb.Append(",{");
            }
            sb.Append(string.Format("\"{0}\":\"{1}\"", "content", a.Rows[i]["content"].ToString()));
            sb.Append("}");
        }
        sb.Append("]");
        txtjson.Text = sb.ToString();
    }
    protected void search_Click(object sender, EventArgs e)
    {
        string    dts       = datemin.Value;
        string    dte       = datemax.Value;
        string    cequ      = ddl_cequ.SelectedValue;
        string    gzm       = ddl_gongzuomian.SelectedValue;
        string    zjbh      = ddl_zhijiabianhao.SelectedValue;
        DataTable dt_img    = new DataTable();
        DataTable dt_export = new DataTable();
        string    zhu       = "3";

        if (zhengjia.Checked == true)
        {
            zhu = "3";
        }
        if (zuozhu.Checked == true)
        {
            zhu = "1";
        }
        if (youzhu.Checked == true)
        {
            zhu = "2";
        }
        string strConn = ConfigurationManager.ConnectionStrings["webConnectionString"].ToString();

        DrawImage.DrawingCurve dc = new DrawImage.DrawingCurve(strConn);
        //Bitmap img = DrawImage.DrawingCurve.DrawingImg(cequ, gzm, zjbh, dts, dte);
        decimal CCL     = Convert.ToDecimal(ConfigurationManager.ConnectionStrings["CCmin"].ToString());
        decimal ZLvalue = Convert.ToDecimal(ConfigurationManager.ConnectionStrings["ZLvalue"].ToString());
        Bitmap  img     = DrawImage.DrawingCurve.DrawingImg7(cequ, gzm, zhu, zjbh, dts, dte, dt_img, dt_export, CCL, ZLvalue);
        string  str     = Server.MapPath("./xiazai/");
        string  str2    = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "chuzhangliyumozulifenxiquxian.jpg";

        img.Save(str + str2);
        panel1.BackImageUrl = "xiazai/" + str2;
        StringBuilder sb = new StringBuilder();

        sb.Append("[");
        for (int i = 0; i < dt_img.Rows.Count; i++)
        {
            if (i == 0)
            {
                sb.Append("{");
            }
            else
            {
                sb.Append(",{");
            }
            sb.Append(string.Format("\"{0}\":\"{1}\"", "content", dt_img.Rows[i]["content"].ToString()));
            sb.Append("}");
        }
        sb.Append("]");
        txtjson.Text       = sb.ToString();
        ViewState["excel"] = dt_export;
        //保存分析数据到PreReport
//        string sqlck = "select * from PreReport where areaName='"+cequ+"' and faceName='"+gzm+"' and bracketNo='"+zjbh+"' and reportDate='"+dts+"'";
//        DataSet dsck = DB.ExecuteSqlDataSet(sqlck, null);
//        if (dsck.Tables[0].Rows.Count <=0) {
//            decimal CCLmax = 0;// Convert.ToDecimal(dt_export.Compute("Min(chuchengli)", "true"));
//            decimal MZLmax = 0;// Convert.ToDecimal(dt_export.Compute("Max(mozuli)", "true"));
//            int intCCL = 0;
//            int intMZL = 0;
//            decimal decCCL = 0;
//            decimal decMZL = 0;
//            for (int i = 0; i < dt_export.Rows.Count; i++)
//            {
//                if (dt_export.Rows[i]["chuchengli"].ToString() != "")
//                {
//                    intCCL += 1;
//                    decCCL += Convert.ToDecimal(dt_export.Rows[i]["chuchengli"].ToString());
//                    CCLmax = CCLmax > Convert.ToDecimal(dt_export.Rows[i]["chuchengli"].ToString()) ? CCLmax : Convert.ToDecimal(dt_export.Rows[i]["chuchengli"].ToString());

//                }
//                if (dt_export.Rows[i]["mozuli"].ToString() != "")
//                {
//                    intMZL += 1;
//                    decMZL += Convert.ToDecimal(dt_export.Rows[i]["mozuli"].ToString());
//                    MZLmax = MZLmax > Convert.ToDecimal(dt_export.Rows[i]["mozuli"].ToString()) ? MZLmax : Convert.ToDecimal(dt_export.Rows[i]["mozuli"].ToString());
//                }
//            }
//            decimal CCLavg = intCCL == 0 ? 0 : decCCL / intCCL;
//            decimal MZLavg = intMZL == 0 ? 0 : decMZL / intMZL;
//            decimal GZZLmax = 0;
//            decimal GZZLmin = 0;
//            decimal GZZLavg = 0;
//            string SensorNo = "";
//            string distance = "";
//            dte += " 23:59:59";
//            string sqlgzzl = @"select max(pressure1) maxpre,min(pressure1) minpre,max(pressure2) maxpre2,min(pressure2) minpre2,avg(pressure1+pressure2)/2 avgpre3 from pressuredata
//where areaName='" + cequ + "' and FaceName = '" + gzm + "' and SensorNo = (select SensorNo from PreSenInfo where areaName = '" + cequ + "' and FaceName='" + gzm + "' and BracketNo = '" + zjbh + "') and time between '" + dts + "' and '" + dte + "' and (Pressure1>=" + CCL + " or Pressure2>=" + CCL + ") ";
//            DataSet dsgzzl = DB.ExecuteSqlDataSet(sqlgzzl, null);
//            if (dsgzzl.Tables[0].Rows.Count > 0)
//            {
//                string m1 = dsgzzl.Tables[0].Rows[0]["maxpre"].ToString() == "" ? "0" : dsgzzl.Tables[0].Rows[0]["maxpre"].ToString();
//                decimal maxpre = Convert.ToDecimal(m1);
//                string m2 = dsgzzl.Tables[0].Rows[0]["maxpre2"].ToString() == "" ? "0" : dsgzzl.Tables[0].Rows[0]["maxpre2"].ToString();
//                decimal maxpre2 = Convert.ToDecimal(m2);
//                string m3 = dsgzzl.Tables[0].Rows[0]["avgpre3"].ToString() == "" ? "0" : dsgzzl.Tables[0].Rows[0]["avgpre3"].ToString();
//                decimal avgpre3 = Convert.ToDecimal(m3);
//                GZZLmax = maxpre > maxpre2 ? maxpre : maxpre2;
//                GZZLavg = avgpre3;
//                string m4 = dsgzzl.Tables[0].Rows[0]["minpre"].ToString() == "" ? "0" : dsgzzl.Tables[0].Rows[0]["minpre"].ToString();
//                decimal minpre = Convert.ToDecimal(m4);
//                string m5 = dsgzzl.Tables[0].Rows[0]["minpre2"].ToString() == "" ? "0" : dsgzzl.Tables[0].Rows[0]["minpre2"].ToString();
//                decimal minpre2 = Convert.ToDecimal(m5);
//                GZZLmin = minpre < minpre2 ? minpre : minpre2;

//            }
//            sqlgzzl = "select SensorNo,distance from PreSenInfo where areaName = '" + cequ + "' and FaceName='" + gzm + "' and BracketNo = '" + zjbh + "'";
//            dsgzzl = DB.ExecuteSqlDataSet(sqlgzzl, null);
//            if (dsgzzl.Tables[0].Rows.Count > 0)
//            {
//                SensorNo = dsgzzl.Tables[0].Rows[0]["SensorNo"].ToString();
//                distance = dsgzzl.Tables[0].Rows[0]["distance"].ToString();
//            }
//            sqlgzzl = "insert into PreReport (areaName,faceName,sensorNo,bracketNo,distance,ZLmax,ZLavg,CCLmax,CCLavg,MZLmax,MZLavg,reportDate,zlmin) values('" + cequ + "','" + gzm + "','" + SensorNo + "','" + zjbh + "','" + distance + "','" + GZZLmax + "','" + GZZLavg + "','" + CCLmax + "','" + CCLavg + "','" + MZLmax + "','" + MZLavg + "','" + dts + "','" + GZZLmin + "')";
//            DB.ExecuteSql(sqlgzzl, null);
//        }
    }