Esempio n. 1
0
 private void ShowInfo(string Exp_No)
 {
     Maticsoft.BLL.ps_retention   bll   = new Maticsoft.BLL.ps_retention();
     Maticsoft.Model.ps_retention model = bll.GetModel(Exp_No);
     this.txtPrj_No.Text          = model.Prj_No;
     this.txtPrj_Name.Text        = model.Prj_Name;
     this.lblExp_No.Text          = model.Exp_No;
     this.txtMapCode.Text         = model.MapCode;
     this.txtName.Text            = model.Name;
     this.txtSewageSystem_ID.Text = model.SewageSystem_ID;
     this.txtStormSystem_ID.Text  = model.StormSystem_ID;
     this.txtType.Text            = model.Type;
     this.txtX.Text            = model.X.ToString();
     this.txtY.Text            = model.Y.ToString();
     this.txtHigh.Text         = model.High.ToString();
     this.txtInflow_Type.Text  = model.Inflow_Type;
     this.txtOutflow_Type.Text = model.Outflow_Type;
     this.txtTotal_Vol.Text    = model.Total_Vol.ToString();
     this.txtB_Level.Text      = model.B_Level.ToString();
     this.txtMax_Level.Text    = model.Max_Level.ToString();
     this.txtMin_Level.Text    = model.Min_Level.ToString();
     this.txtDesign_Time.Text  = model.Design_Time.ToString();
     this.txtPs_Num.Text       = model.Ps_Num;
     this.txtFlowDir.Text      = model.FlowDir;
     this.txtCode.Text         = model.Code;
     this.txtAddress.Text      = model.Address;
     this.txtDataSource.Text   = model.DataSource;
     this.txtSunit.Text        = model.Sunit;
     this.txtSdate.Text        = model.Sdate;
     this.txtUpdateTime.Text   = model.UpdateTime;
     this.txtMdate.Text        = model.Mdate;
     this.txtDataListID.Text   = model.DataListID;
     this.txtStatus.Text       = model.Status;
     this.txtEname.Text        = model.Ename;
     this.txtDesign_Dept.Text  = model.Design_Dept;
     this.txtConster_Dept.Text = model.Conster_Dept;
     this.txtBelong.Text       = model.Belong;
     this.txtOperator.Text     = model.Operator;
     this.txtNote.Text         = model.Note;
     this.txtExp_NoOri.Text    = model.Exp_NoOri;
     this.txtfilename.Text     = model.filename;
     this.txtupdate.Text       = model.update;
 }
Esempio n. 2
0
 private void ShowInfo(string Exp_No)
 {
     Maticsoft.BLL.ps_retention   bll   = new Maticsoft.BLL.ps_retention();
     Maticsoft.Model.ps_retention model = bll.GetModel(Exp_No);
     this.lblPrj_No.Text          = model.Prj_No;
     this.lblPrj_Name.Text        = model.Prj_Name;
     this.lblExp_No.Text          = model.Exp_No;
     this.lblMapCode.Text         = model.MapCode;
     this.lblName.Text            = model.Name;
     this.lblSewageSystem_ID.Text = model.SewageSystem_ID;
     this.lblStormSystem_ID.Text  = model.StormSystem_ID;
     this.lblType.Text            = model.Type;
     this.lblX.Text            = model.X.ToString();
     this.lblY.Text            = model.Y.ToString();
     this.lblHigh.Text         = model.High.ToString();
     this.lblInflow_Type.Text  = model.Inflow_Type;
     this.lblOutflow_Type.Text = model.Outflow_Type;
     this.lblTotal_Vol.Text    = model.Total_Vol.ToString();
     this.lblB_Level.Text      = model.B_Level.ToString();
     this.lblMax_Level.Text    = model.Max_Level.ToString();
     this.lblMin_Level.Text    = model.Min_Level.ToString();
     this.lblDesign_Time.Text  = model.Design_Time.ToString();
     this.lblPs_Num.Text       = model.Ps_Num;
     this.lblFlowDir.Text      = model.FlowDir;
     this.lblCode.Text         = model.Code;
     this.lblAddress.Text      = model.Address;
     this.lblDataSource.Text   = model.DataSource;
     this.lblSunit.Text        = model.Sunit;
     this.lblSdate.Text        = model.Sdate;
     this.lblUpdateTime.Text   = model.UpdateTime;
     this.lblMdate.Text        = model.Mdate;
     this.lblDataListID.Text   = model.DataListID;
     this.lblStatus.Text       = model.Status;
     this.lblEname.Text        = model.Ename;
     this.lblDesign_Dept.Text  = model.Design_Dept;
     this.lblConster_Dept.Text = model.Conster_Dept;
     this.lblBelong.Text       = model.Belong;
     this.lblOperator.Text     = model.Operator;
     this.lblNote.Text         = model.Note;
     this.lblExp_NoOri.Text    = model.Exp_NoOri;
     this.lblfilename.Text     = model.filename;
     this.lblupdate.Text       = model.update;
 }
Esempio n. 3
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Maticsoft.Model.ps_retention GetModel(string Exp_No)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select Prj_No,Prj_Name,Exp_No,MapCode,Name,SewageSystem_ID,StormSystem_ID,Type,X,Y,High,Inflow_Type,Outflow_Type,Total_Vol,B_Level,Max_Level,Min_Level,Design_Time,Ps_Num,FlowDir,Code,Address,DataSource,Sunit,Sdate,UpdateTime,Mdate,DataListID,Status,Ename,Design_Dept,Conster_Dept,Belong,Operator,Note,Exp_NoOri,FileName,Uploadtime from ps_retention ");
            strSql.Append(" where Exp_No=@Exp_No ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Exp_No", MySqlDbType.VarChar, 100)
            };
            parameters[0].Value = Exp_No;

            Maticsoft.Model.ps_retention model = new Maticsoft.Model.ps_retention();
            DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Esempio n. 4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.ps_retention model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ps_retention(");
            strSql.Append("Prj_No,Prj_Name,Exp_No,MapCode,Name,SewageSystem_ID,StormSystem_ID,Type,X,Y,High,Inflow_Type,Outflow_Type,Total_Vol,B_Level,Max_Level,Min_Level,Design_Time,Ps_Num,FlowDir,Code,Address,DataSource,Sunit,Sdate,UpdateTime,Mdate,DataListID,Status,Ename,Design_Dept,Conster_Dept,Belong,Operator,Note,Exp_NoOri,FileName,Uploadtime)");
            strSql.Append(" values (");
            strSql.Append("@Prj_No,@Prj_Name,@Exp_No,@MapCode,@Name,@SewageSystem_ID,@StormSystem_ID,@Type,@X,@Y,@High,@Inflow_Type,@Outflow_Type,@Total_Vol,@B_Level,@Max_Level,@Min_Level,@Design_Time,@Ps_Num,@FlowDir,@Code,@Address,@DataSource,@Sunit,@Sdate,@UpdateTime,@Mdate,@DataListID,@Status,@Ename,@Design_Dept,@Conster_Dept,@Belong,@Operator,@Note,@Exp_NoOri,@FileName,@Uploadtime)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Prj_No",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Prj_Name",        MySqlDbType.VarChar, 100),
                new MySqlParameter("@Exp_No",          MySqlDbType.VarChar, 100),
                new MySqlParameter("@MapCode",         MySqlDbType.VarChar,  10),
                new MySqlParameter("@Name",            MySqlDbType.VarChar, 100),
                new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar,  50),
                new MySqlParameter("@StormSystem_ID",  MySqlDbType.VarChar,  50),
                new MySqlParameter("@Type",            MySqlDbType.VarChar,   4),
                new MySqlParameter("@X",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@Y",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@High",            MySqlDbType.Decimal,  10),
                new MySqlParameter("@Inflow_Type",     MySqlDbType.VarChar,  10),
                new MySqlParameter("@Outflow_Type",    MySqlDbType.VarChar,  10),
                new MySqlParameter("@Total_Vol",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@B_Level",         MySqlDbType.Decimal,  10),
                new MySqlParameter("@Max_Level",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@Min_Level",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@Design_Time",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@Ps_Num",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@FlowDir",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@Code",            MySqlDbType.VarChar,  10),
                new MySqlParameter("@Address",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@DataSource",      MySqlDbType.VarChar,  10),
                new MySqlParameter("@Sunit",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@Sdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@UpdateTime",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@Mdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@DataListID",      MySqlDbType.VarChar,  50),
                new MySqlParameter("@Status",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Ename",           MySqlDbType.VarChar, 100),
                new MySqlParameter("@Design_Dept",     MySqlDbType.VarChar, 255),
                new MySqlParameter("@Conster_Dept",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@Belong",          MySqlDbType.VarChar, 255),
                new MySqlParameter("@Operator",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Note",            MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_NoOri",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@FileName",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Uploadtime",      MySqlDbType.VarChar, 255)
            };
            parameters[0].Value  = model.Prj_No;
            parameters[1].Value  = model.Prj_Name;
            parameters[2].Value  = model.Exp_No;
            parameters[3].Value  = model.MapCode;
            parameters[4].Value  = model.Name;
            parameters[5].Value  = model.SewageSystem_ID;
            parameters[6].Value  = model.StormSystem_ID;
            parameters[7].Value  = model.Type;
            parameters[8].Value  = model.X;
            parameters[9].Value  = model.Y;
            parameters[10].Value = model.High;
            parameters[11].Value = model.Inflow_Type;
            parameters[12].Value = model.Outflow_Type;
            parameters[13].Value = model.Total_Vol;
            parameters[14].Value = model.B_Level;
            parameters[15].Value = model.Max_Level;
            parameters[16].Value = model.Min_Level;
            parameters[17].Value = model.Design_Time;
            parameters[18].Value = model.Ps_Num;
            parameters[19].Value = model.FlowDir;
            parameters[20].Value = model.Code;
            parameters[21].Value = model.Address;
            parameters[22].Value = model.DataSource;
            parameters[23].Value = model.Sunit;
            parameters[24].Value = model.Sdate;
            parameters[25].Value = model.UpdateTime;
            parameters[26].Value = model.Mdate;
            parameters[27].Value = model.DataListID;
            parameters[28].Value = model.Status;
            parameters[29].Value = model.Ename;
            parameters[30].Value = model.Design_Dept;
            parameters[31].Value = model.Conster_Dept;
            parameters[32].Value = model.Belong;
            parameters[33].Value = model.Operator;
            parameters[34].Value = model.Note;
            parameters[35].Value = model.Exp_NoOri;
            parameters[36].Value = model.FileName;
            parameters[37].Value = model.Uploadtime;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 5
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Maticsoft.Model.ps_retention DataRowToModel(DataRow row)
 {
     Maticsoft.Model.ps_retention model = new Maticsoft.Model.ps_retention();
     if (row != null)
     {
         if (row["Prj_No"] != null)
         {
             model.Prj_No = row["Prj_No"].ToString();
         }
         if (row["Prj_Name"] != null)
         {
             model.Prj_Name = row["Prj_Name"].ToString();
         }
         if (row["Exp_No"] != null)
         {
             model.Exp_No = row["Exp_No"].ToString();
         }
         if (row["MapCode"] != null)
         {
             model.MapCode = row["MapCode"].ToString();
         }
         if (row["Name"] != null)
         {
             model.Name = row["Name"].ToString();
         }
         if (row["SewageSystem_ID"] != null)
         {
             model.SewageSystem_ID = row["SewageSystem_ID"].ToString();
         }
         if (row["StormSystem_ID"] != null)
         {
             model.StormSystem_ID = row["StormSystem_ID"].ToString();
         }
         if (row["Type"] != null)
         {
             model.Type = row["Type"].ToString();
         }
         if (row["X"] != null && row["X"].ToString() != "")
         {
             model.X = decimal.Parse(row["X"].ToString());
         }
         if (row["Y"] != null && row["Y"].ToString() != "")
         {
             model.Y = decimal.Parse(row["Y"].ToString());
         }
         if (row["High"] != null && row["High"].ToString() != "")
         {
             model.High = decimal.Parse(row["High"].ToString());
         }
         if (row["Inflow_Type"] != null)
         {
             model.Inflow_Type = row["Inflow_Type"].ToString();
         }
         if (row["Outflow_Type"] != null)
         {
             model.Outflow_Type = row["Outflow_Type"].ToString();
         }
         if (row["Total_Vol"] != null && row["Total_Vol"].ToString() != "")
         {
             model.Total_Vol = decimal.Parse(row["Total_Vol"].ToString());
         }
         if (row["B_Level"] != null && row["B_Level"].ToString() != "")
         {
             model.B_Level = decimal.Parse(row["B_Level"].ToString());
         }
         if (row["Max_Level"] != null && row["Max_Level"].ToString() != "")
         {
             model.Max_Level = decimal.Parse(row["Max_Level"].ToString());
         }
         if (row["Min_Level"] != null && row["Min_Level"].ToString() != "")
         {
             model.Min_Level = decimal.Parse(row["Min_Level"].ToString());
         }
         if (row["Design_Time"] != null && row["Design_Time"].ToString() != "")
         {
             model.Design_Time = decimal.Parse(row["Design_Time"].ToString());
         }
         if (row["Ps_Num"] != null)
         {
             model.Ps_Num = row["Ps_Num"].ToString();
         }
         if (row["FlowDir"] != null)
         {
             model.FlowDir = row["FlowDir"].ToString();
         }
         if (row["Code"] != null)
         {
             model.Code = row["Code"].ToString();
         }
         if (row["Address"] != null)
         {
             model.Address = row["Address"].ToString();
         }
         if (row["DataSource"] != null)
         {
             model.DataSource = row["DataSource"].ToString();
         }
         if (row["Sunit"] != null)
         {
             model.Sunit = row["Sunit"].ToString();
         }
         if (row["Sdate"] != null)
         {
             model.Sdate = row["Sdate"].ToString();
         }
         if (row["UpdateTime"] != null)
         {
             model.UpdateTime = row["UpdateTime"].ToString();
         }
         if (row["Mdate"] != null)
         {
             model.Mdate = row["Mdate"].ToString();
         }
         if (row["DataListID"] != null)
         {
             model.DataListID = row["DataListID"].ToString();
         }
         if (row["Status"] != null)
         {
             model.Status = row["Status"].ToString();
         }
         if (row["Ename"] != null)
         {
             model.Ename = row["Ename"].ToString();
         }
         if (row["Design_Dept"] != null)
         {
             model.Design_Dept = row["Design_Dept"].ToString();
         }
         if (row["Conster_Dept"] != null)
         {
             model.Conster_Dept = row["Conster_Dept"].ToString();
         }
         if (row["Belong"] != null)
         {
             model.Belong = row["Belong"].ToString();
         }
         if (row["Operator"] != null)
         {
             model.Operator = row["Operator"].ToString();
         }
         if (row["Note"] != null)
         {
             model.Note = row["Note"].ToString();
         }
         if (row["Exp_NoOri"] != null)
         {
             model.Exp_NoOri = row["Exp_NoOri"].ToString();
         }
         if (row["FileName"] != null)
         {
             model.FileName = row["FileName"].ToString();
         }
         if (row["Uploadtime"] != null)
         {
             model.Uploadtime = row["Uploadtime"].ToString();
         }
     }
     return(model);
 }
Esempio n. 6
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Maticsoft.Model.ps_retention model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update ps_retention set ");
            strSql.Append("Prj_No=@Prj_No,");
            strSql.Append("Prj_Name=@Prj_Name,");
            strSql.Append("MapCode=@MapCode,");
            strSql.Append("Name=@Name,");
            strSql.Append("SewageSystem_ID=@SewageSystem_ID,");
            strSql.Append("StormSystem_ID=@StormSystem_ID,");
            strSql.Append("Type=@Type,");
            strSql.Append("X=@X,");
            strSql.Append("Y=@Y,");
            strSql.Append("High=@High,");
            strSql.Append("Inflow_Type=@Inflow_Type,");
            strSql.Append("Outflow_Type=@Outflow_Type,");
            strSql.Append("Total_Vol=@Total_Vol,");
            strSql.Append("B_Level=@B_Level,");
            strSql.Append("Max_Level=@Max_Level,");
            strSql.Append("Min_Level=@Min_Level,");
            strSql.Append("Design_Time=@Design_Time,");
            strSql.Append("Ps_Num=@Ps_Num,");
            strSql.Append("FlowDir=@FlowDir,");
            strSql.Append("Code=@Code,");
            strSql.Append("Address=@Address,");
            strSql.Append("DataSource=@DataSource,");
            strSql.Append("Sunit=@Sunit,");
            strSql.Append("Sdate=@Sdate,");
            strSql.Append("UpdateTime=@UpdateTime,");
            strSql.Append("Mdate=@Mdate,");
            strSql.Append("DataListID=@DataListID,");
            strSql.Append("Status=@Status,");
            strSql.Append("Ename=@Ename,");
            strSql.Append("Design_Dept=@Design_Dept,");
            strSql.Append("Conster_Dept=@Conster_Dept,");
            strSql.Append("Belong=@Belong,");
            strSql.Append("Operator=@Operator,");
            strSql.Append("Note=@Note,");
            strSql.Append("Exp_NoOri=@Exp_NoOri,");
            strSql.Append("FileName=@FileName,");
            strSql.Append("Uploadtime=@Uploadtime");
            strSql.Append(" where Exp_No=@Exp_No ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Prj_No",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Prj_Name",        MySqlDbType.VarChar, 100),
                new MySqlParameter("@MapCode",         MySqlDbType.VarChar,  10),
                new MySqlParameter("@Name",            MySqlDbType.VarChar, 100),
                new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar,  50),
                new MySqlParameter("@StormSystem_ID",  MySqlDbType.VarChar,  50),
                new MySqlParameter("@Type",            MySqlDbType.VarChar,   4),
                new MySqlParameter("@X",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@Y",               MySqlDbType.Decimal,  10),
                new MySqlParameter("@High",            MySqlDbType.Decimal,  10),
                new MySqlParameter("@Inflow_Type",     MySqlDbType.VarChar,  10),
                new MySqlParameter("@Outflow_Type",    MySqlDbType.VarChar,  10),
                new MySqlParameter("@Total_Vol",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@B_Level",         MySqlDbType.Decimal,  10),
                new MySqlParameter("@Max_Level",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@Min_Level",       MySqlDbType.Decimal,   7),
                new MySqlParameter("@Design_Time",     MySqlDbType.Decimal,   7),
                new MySqlParameter("@Ps_Num",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@FlowDir",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@Code",            MySqlDbType.VarChar,  10),
                new MySqlParameter("@Address",         MySqlDbType.VarChar, 100),
                new MySqlParameter("@DataSource",      MySqlDbType.VarChar,  10),
                new MySqlParameter("@Sunit",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@Sdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@UpdateTime",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@Mdate",           MySqlDbType.VarChar, 255),
                new MySqlParameter("@DataListID",      MySqlDbType.VarChar,  50),
                new MySqlParameter("@Status",          MySqlDbType.VarChar,  10),
                new MySqlParameter("@Ename",           MySqlDbType.VarChar, 100),
                new MySqlParameter("@Design_Dept",     MySqlDbType.VarChar, 255),
                new MySqlParameter("@Conster_Dept",    MySqlDbType.VarChar, 255),
                new MySqlParameter("@Belong",          MySqlDbType.VarChar, 255),
                new MySqlParameter("@Operator",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Note",            MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_NoOri",       MySqlDbType.VarChar, 255),
                new MySqlParameter("@FileName",        MySqlDbType.VarChar, 255),
                new MySqlParameter("@Uploadtime",      MySqlDbType.VarChar, 255),
                new MySqlParameter("@Exp_No",          MySqlDbType.VarChar, 100)
            };
            parameters[0].Value  = model.Prj_No;
            parameters[1].Value  = model.Prj_Name;
            parameters[2].Value  = model.MapCode;
            parameters[3].Value  = model.Name;
            parameters[4].Value  = model.SewageSystem_ID;
            parameters[5].Value  = model.StormSystem_ID;
            parameters[6].Value  = model.Type;
            parameters[7].Value  = model.X;
            parameters[8].Value  = model.Y;
            parameters[9].Value  = model.High;
            parameters[10].Value = model.Inflow_Type;
            parameters[11].Value = model.Outflow_Type;
            parameters[12].Value = model.Total_Vol;
            parameters[13].Value = model.B_Level;
            parameters[14].Value = model.Max_Level;
            parameters[15].Value = model.Min_Level;
            parameters[16].Value = model.Design_Time;
            parameters[17].Value = model.Ps_Num;
            parameters[18].Value = model.FlowDir;
            parameters[19].Value = model.Code;
            parameters[20].Value = model.Address;
            parameters[21].Value = model.DataSource;
            parameters[22].Value = model.Sunit;
            parameters[23].Value = model.Sdate;
            parameters[24].Value = model.UpdateTime;
            parameters[25].Value = model.Mdate;
            parameters[26].Value = model.DataListID;
            parameters[27].Value = model.Status;
            parameters[28].Value = model.Ename;
            parameters[29].Value = model.Design_Dept;
            parameters[30].Value = model.Conster_Dept;
            parameters[31].Value = model.Belong;
            parameters[32].Value = model.Operator;
            parameters[33].Value = model.Note;
            parameters[34].Value = model.Exp_NoOri;
            parameters[35].Value = model.FileName;
            parameters[36].Value = model.Uploadtime;
            parameters[37].Value = model.Exp_No;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 7
0
        public void btnSave_Click(object sender, EventArgs e)
        {
            string strErr = "";

            if (this.txtPrj_No.Text.Trim().Length == 0)
            {
                strErr += "Prj_No不能为空!\\n";
            }
            if (this.txtPrj_Name.Text.Trim().Length == 0)
            {
                strErr += "Prj_Name不能为空!\\n";
            }
            if (this.txtMapCode.Text.Trim().Length == 0)
            {
                strErr += "MapCode不能为空!\\n";
            }
            if (this.txtName.Text.Trim().Length == 0)
            {
                strErr += "Name不能为空!\\n";
            }
            if (this.txtSewageSystem_ID.Text.Trim().Length == 0)
            {
                strErr += "SewageSystem_ID不能为空!\\n";
            }
            if (this.txtStormSystem_ID.Text.Trim().Length == 0)
            {
                strErr += "StormSystem_ID不能为空!\\n";
            }
            if (this.txtType.Text.Trim().Length == 0)
            {
                strErr += "Type不能为空!\\n";
            }
            if (!PageValidate.IsDecimal(txtX.Text))
            {
                strErr += "X格式错误!\\n";
            }
            if (!PageValidate.IsDecimal(txtY.Text))
            {
                strErr += "Y格式错误!\\n";
            }
            if (!PageValidate.IsDecimal(txtHigh.Text))
            {
                strErr += "High格式错误!\\n";
            }
            if (this.txtInflow_Type.Text.Trim().Length == 0)
            {
                strErr += "Inflow_Type不能为空!\\n";
            }
            if (this.txtOutflow_Type.Text.Trim().Length == 0)
            {
                strErr += "Outflow_Type不能为空!\\n";
            }
            if (!PageValidate.IsDecimal(txtTotal_Vol.Text))
            {
                strErr += "Total_Vol格式错误!\\n";
            }
            if (!PageValidate.IsDecimal(txtB_Level.Text))
            {
                strErr += "B_Level格式错误!\\n";
            }
            if (!PageValidate.IsDecimal(txtMax_Level.Text))
            {
                strErr += "Max_Level格式错误!\\n";
            }
            if (!PageValidate.IsDecimal(txtMin_Level.Text))
            {
                strErr += "Min_Level格式错误!\\n";
            }
            if (!PageValidate.IsDecimal(txtDesign_Time.Text))
            {
                strErr += "Design_Time格式错误!\\n";
            }
            if (this.txtPs_Num.Text.Trim().Length == 0)
            {
                strErr += "Ps_Num不能为空!\\n";
            }
            if (this.txtFlowDir.Text.Trim().Length == 0)
            {
                strErr += "FlowDir不能为空!\\n";
            }
            if (this.txtCode.Text.Trim().Length == 0)
            {
                strErr += "Code不能为空!\\n";
            }
            if (this.txtAddress.Text.Trim().Length == 0)
            {
                strErr += "Address不能为空!\\n";
            }
            if (this.txtDataSource.Text.Trim().Length == 0)
            {
                strErr += "DataSource不能为空!\\n";
            }
            if (this.txtSunit.Text.Trim().Length == 0)
            {
                strErr += "Sunit不能为空!\\n";
            }
            if (this.txtSdate.Text.Trim().Length == 0)
            {
                strErr += "Sdate不能为空!\\n";
            }
            if (this.txtUpdateTime.Text.Trim().Length == 0)
            {
                strErr += "UpdateTime不能为空!\\n";
            }
            if (this.txtMdate.Text.Trim().Length == 0)
            {
                strErr += "Mdate不能为空!\\n";
            }
            if (this.txtDataListID.Text.Trim().Length == 0)
            {
                strErr += "DataListID不能为空!\\n";
            }
            if (this.txtStatus.Text.Trim().Length == 0)
            {
                strErr += "Status不能为空!\\n";
            }
            if (this.txtEname.Text.Trim().Length == 0)
            {
                strErr += "Ename不能为空!\\n";
            }
            if (this.txtDesign_Dept.Text.Trim().Length == 0)
            {
                strErr += "Design_Dept不能为空!\\n";
            }
            if (this.txtConster_Dept.Text.Trim().Length == 0)
            {
                strErr += "Conster_Dept不能为空!\\n";
            }
            if (this.txtBelong.Text.Trim().Length == 0)
            {
                strErr += "Belong不能为空!\\n";
            }
            if (this.txtOperator.Text.Trim().Length == 0)
            {
                strErr += "Operator不能为空!\\n";
            }
            if (this.txtNote.Text.Trim().Length == 0)
            {
                strErr += "Note不能为空!\\n";
            }
            if (this.txtExp_NoOri.Text.Trim().Length == 0)
            {
                strErr += "Exp_NoOri不能为空!\\n";
            }
            if (this.txtfilename.Text.Trim().Length == 0)
            {
                strErr += "filename不能为空!\\n";
            }
            if (this.txtupdate.Text.Trim().Length == 0)
            {
                strErr += "update不能为空!\\n";
            }

            if (strErr != "")
            {
                MessageBox.Show(this, strErr);
                return;
            }
            string  Prj_No          = this.txtPrj_No.Text;
            string  Prj_Name        = this.txtPrj_Name.Text;
            string  Exp_No          = this.lblExp_No.Text;
            string  MapCode         = this.txtMapCode.Text;
            string  Name            = this.txtName.Text;
            string  SewageSystem_ID = this.txtSewageSystem_ID.Text;
            string  StormSystem_ID  = this.txtStormSystem_ID.Text;
            string  Type            = this.txtType.Text;
            decimal X            = decimal.Parse(this.txtX.Text);
            decimal Y            = decimal.Parse(this.txtY.Text);
            decimal High         = decimal.Parse(this.txtHigh.Text);
            string  Inflow_Type  = this.txtInflow_Type.Text;
            string  Outflow_Type = this.txtOutflow_Type.Text;
            decimal Total_Vol    = decimal.Parse(this.txtTotal_Vol.Text);
            decimal B_Level      = decimal.Parse(this.txtB_Level.Text);
            decimal Max_Level    = decimal.Parse(this.txtMax_Level.Text);
            decimal Min_Level    = decimal.Parse(this.txtMin_Level.Text);
            decimal Design_Time  = decimal.Parse(this.txtDesign_Time.Text);
            string  Ps_Num       = this.txtPs_Num.Text;
            string  FlowDir      = this.txtFlowDir.Text;
            string  Code         = this.txtCode.Text;
            string  Address      = this.txtAddress.Text;
            string  DataSource   = this.txtDataSource.Text;
            string  Sunit        = this.txtSunit.Text;
            string  Sdate        = this.txtSdate.Text;
            string  UpdateTime   = this.txtUpdateTime.Text;
            string  Mdate        = this.txtMdate.Text;
            string  DataListID   = this.txtDataListID.Text;
            string  Status       = this.txtStatus.Text;
            string  Ename        = this.txtEname.Text;
            string  Design_Dept  = this.txtDesign_Dept.Text;
            string  Conster_Dept = this.txtConster_Dept.Text;
            string  Belong       = this.txtBelong.Text;
            string  Operator     = this.txtOperator.Text;
            string  Note         = this.txtNote.Text;
            string  Exp_NoOri    = this.txtExp_NoOri.Text;
            string  filename     = this.txtfilename.Text;
            string  update       = this.txtupdate.Text;


            Maticsoft.Model.ps_retention model = new Maticsoft.Model.ps_retention();
            model.Prj_No          = Prj_No;
            model.Prj_Name        = Prj_Name;
            model.Exp_No          = Exp_No;
            model.MapCode         = MapCode;
            model.Name            = Name;
            model.SewageSystem_ID = SewageSystem_ID;
            model.StormSystem_ID  = StormSystem_ID;
            model.Type            = Type;
            model.X            = X;
            model.Y            = Y;
            model.High         = High;
            model.Inflow_Type  = Inflow_Type;
            model.Outflow_Type = Outflow_Type;
            model.Total_Vol    = Total_Vol;
            model.B_Level      = B_Level;
            model.Max_Level    = Max_Level;
            model.Min_Level    = Min_Level;
            model.Design_Time  = Design_Time;
            model.Ps_Num       = Ps_Num;
            model.FlowDir      = FlowDir;
            model.Code         = Code;
            model.Address      = Address;
            model.DataSource   = DataSource;
            model.Sunit        = Sunit;
            model.Sdate        = Sdate;
            model.UpdateTime   = UpdateTime;
            model.Mdate        = Mdate;
            model.DataListID   = DataListID;
            model.Status       = Status;
            model.Ename        = Ename;
            model.Design_Dept  = Design_Dept;
            model.Conster_Dept = Conster_Dept;
            model.Belong       = Belong;
            model.Operator     = Operator;
            model.Note         = Note;
            model.Exp_NoOri    = Exp_NoOri;
            model.filename     = filename;
            model.update       = update;

            Maticsoft.BLL.ps_retention bll = new Maticsoft.BLL.ps_retention();
            bll.Update(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx");
        }