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; }
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; }
/// <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); } }
/// <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); } }
/// <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); }
/// <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); } }
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"); }