private void ShowInfo(string Lno)
{
Maticsoft.BLL.ps_pipe bll = new Maticsoft.BLL.ps_pipe();
Maticsoft.Model.ps_pipe model = bll.GetModel(Lno);
this.lblPrj_No.Text = model.Prj_No;
this.lblPrj_Name.Text = model.Prj_Name;
this.lblLno.Text = model.Lno;
this.lblGrade.Text = model.Grade;
this.lblS_Point.Text = model.S_Point;
this.lblS_Deep.Text = model.S_Deep.ToString();
this.lblIn_Elev.Text = model.In_Elev.ToString();
this.lblE_Point.Text = model.E_Point;
this.lblE_Deep.Text = model.E_Deep.ToString();
this.lblOut_Elev.Text = model.Out_Elev.ToString();
this.lblSewageSystem_ID.Text = model.SewageSystem_ID;
this.lblStormSystem_ID.Text = model.StormSystem_ID;
this.lblType.Text = model.Type;
this.lblCode.Text = model.Code;
this.lblPressure_Type.Text = model.Pressure_Type;
this.lblInvert_Silphon.Text = model.Invert_Silphon;
this.lblMaterial.Text = model.Material;
this.lblServiceLife.Text = model.ServiceLife;
this.lblShapeType.Text = model.ShapeType;
this.lblPSize.Text = model.PSize;
this.lblPipeLength.Text = model.PipeLength.ToString();
this.lblFlowDir.Text = model.FlowDir;
this.lblEmBed.Text = model.EmBed;
this.lblInterface.Text = model.Interface;
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.lblPlan.Text = model.Plan;
this.lblPipe_Type.Text = model.Pipe_Type;
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_No0.Text = model.Exp_No0;
this.lblExp_No1.Text = model.Exp_No1;
this.lblfilename.Text = model.filename;
this.lblupdate.Text = model.update;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.ps_pipe GetModel(string Lno)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Prj_No,Prj_Name,Lno,Grade,S_Point,S_Deep,In_Elev,E_Point,E_Deep,Out_Elev,SewageSystem_ID,StormSystem_ID,Type,Code,Pressure_Type,Invert_Silphon,Material,ServiceLife,ShapeType,PSize,PipeLength,FlowDir,EmBed,Interface,Address,DataSource,Sunit,Sdate,UpdateTime,Mdate,Plan,Pipe_Type,Status,Ename,Design_Dept,Conster_Dept,Belong,Operator,Note,Exp_No0,Exp_No1,FileName,Uploadtime from ps_pipe ");
strSql.Append(" where Lno=@Lno ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Lno", MySqlDbType.VarChar, 100)
};
parameters[0].Value = Lno;
Maticsoft.Model.ps_pipe model = new Maticsoft.Model.ps_pipe();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
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.txtGrade.Text.Trim().Length == 0)
{
strErr += "Grade不能为空！\\n";
}
if (this.txtS_Point.Text.Trim().Length == 0)
{
strErr += "S_Point不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtS_Deep.Text))
{
strErr += "S_Deep格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtIn_Elev.Text))
{
strErr += "In_Elev格式错误！\\n";
}
if (this.txtE_Point.Text.Trim().Length == 0)
{
strErr += "E_Point不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtE_Deep.Text))
{
strErr += "E_Deep格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtOut_Elev.Text))
{
strErr += "Out_Elev格式错误！\\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 (this.txtCode.Text.Trim().Length == 0)
{
strErr += "Code不能为空！\\n";
}
if (this.txtPressure_Type.Text.Trim().Length == 0)
{
strErr += "Pressure_Type不能为空！\\n";
}
if (this.txtInvert_Silphon.Text.Trim().Length == 0)
{
strErr += "Invert_Silphon不能为空！\\n";
}
if (this.txtMaterial.Text.Trim().Length == 0)
{
strErr += "Material不能为空！\\n";
}
if (this.txtServiceLife.Text.Trim().Length == 0)
{
strErr += "ServiceLife不能为空！\\n";
}
if (this.txtShapeType.Text.Trim().Length == 0)
{
strErr += "ShapeType不能为空！\\n";
}
if (this.txtPSize.Text.Trim().Length == 0)
{
strErr += "PSize不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtPipeLength.Text))
{
strErr += "PipeLength格式错误！\\n";
}
if (this.txtFlowDir.Text.Trim().Length == 0)
{
strErr += "FlowDir不能为空！\\n";
}
if (this.txtEmBed.Text.Trim().Length == 0)
{
strErr += "EmBed不能为空！\\n";
}
if (this.txtInterface.Text.Trim().Length == 0)
{
strErr += "Interface不能为空！\\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.txtPlan.Text.Trim().Length == 0)
{
strErr += "Plan不能为空！\\n";
}
if (this.txtPipe_Type.Text.Trim().Length == 0)
{
strErr += "Pipe_Type不能为空！\\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_No0.Text.Trim().Length == 0)
{
strErr += "Exp_No0不能为空！\\n";
}
if (this.txtExp_No1.Text.Trim().Length == 0)
{
strErr += "Exp_No1不能为空！\\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 Lno = this.lblLno.Text;
string Grade = this.txtGrade.Text;
string S_Point = this.txtS_Point.Text;
decimal S_Deep = decimal.Parse(this.txtS_Deep.Text);
decimal In_Elev = decimal.Parse(this.txtIn_Elev.Text);
string E_Point = this.txtE_Point.Text;
decimal E_Deep = decimal.Parse(this.txtE_Deep.Text);
decimal Out_Elev = decimal.Parse(this.txtOut_Elev.Text);
string SewageSystem_ID = this.txtSewageSystem_ID.Text;
string StormSystem_ID = this.txtStormSystem_ID.Text;
string Type = this.txtType.Text;
string Code = this.txtCode.Text;
string Pressure_Type = this.txtPressure_Type.Text;
string Invert_Silphon = this.txtInvert_Silphon.Text;
string Material = this.txtMaterial.Text;
string ServiceLife = this.txtServiceLife.Text;
string ShapeType = this.txtShapeType.Text;
string PSize = this.txtPSize.Text;
decimal PipeLength = decimal.Parse(this.txtPipeLength.Text);
string FlowDir = this.txtFlowDir.Text;
string EmBed = this.txtEmBed.Text;
string Interface = this.txtInterface.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 Plan = this.txtPlan.Text;
string Pipe_Type = this.txtPipe_Type.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_No0 = this.txtExp_No0.Text;
string Exp_No1 = this.txtExp_No1.Text;
string filename = this.txtfilename.Text;
string update = this.txtupdate.Text;
Maticsoft.Model.ps_pipe model = new Maticsoft.Model.ps_pipe();
model.Prj_No = Prj_No;
model.Prj_Name = Prj_Name;
model.Lno = Lno;
model.Grade = Grade;
model.S_Point = S_Point;
model.S_Deep = S_Deep;
model.In_Elev = In_Elev;
model.E_Point = E_Point;
model.E_Deep = E_Deep;
model.Out_Elev = Out_Elev;
model.SewageSystem_ID = SewageSystem_ID;
model.StormSystem_ID = StormSystem_ID;
model.Type = Type;
model.Code = Code;
model.Pressure_Type = Pressure_Type;
model.Invert_Silphon = Invert_Silphon;
model.Material = Material;
model.ServiceLife = ServiceLife;
model.ShapeType = ShapeType;
model.PSize = PSize;
model.PipeLength = PipeLength;
model.FlowDir = FlowDir;
model.EmBed = EmBed;
model.Interface = Interface;
model.Address = Address;
model.DataSource = DataSource;
model.Sunit = Sunit;
model.Sdate = Sdate;
model.UpdateTime = UpdateTime;
model.Mdate = Mdate;
model.Plan = Plan;
model.Pipe_Type = Pipe_Type;
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_No0 = Exp_No0;
model.Exp_No1 = Exp_No1;
model.filename = filename;
model.update = update;
Maticsoft.BLL.ps_pipe bll = new Maticsoft.BLL.ps_pipe();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.ps_pipe model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ps_pipe(");
strSql.Append("Prj_No,Prj_Name,Lno,Grade,S_Point,S_Deep,In_Elev,E_Point,E_Deep,Out_Elev,SewageSystem_ID,StormSystem_ID,Type,Code,Pressure_Type,Invert_Silphon,Material,ServiceLife,ShapeType,PSize,PipeLength,FlowDir,EmBed,Interface,Address,DataSource,Sunit,Sdate,UpdateTime,Mdate,Plan,Pipe_Type,Status,Ename,Design_Dept,Conster_Dept,Belong,Operator,Note,Exp_No0,Exp_No1,FileName,Uploadtime)");
strSql.Append(" values (");
strSql.Append("@Prj_No,@Prj_Name,@Lno,@Grade,@S_Point,@S_Deep,@In_Elev,@E_Point,@E_Deep,@Out_Elev,@SewageSystem_ID,@StormSystem_ID,@Type,@Code,@Pressure_Type,@Invert_Silphon,@Material,@ServiceLife,@ShapeType,@PSize,@PipeLength,@FlowDir,@EmBed,@Interface,@Address,@DataSource,@Sunit,@Sdate,@UpdateTime,@Mdate,@Plan,@Pipe_Type,@Status,@Ename,@Design_Dept,@Conster_Dept,@Belong,@Operator,@Note,@Exp_No0,@Exp_No1,@FileName,@Uploadtime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Prj_No", MySqlDbType.VarChar, 255),
new MySqlParameter("@Prj_Name", MySqlDbType.VarChar, 255),
new MySqlParameter("@Lno", MySqlDbType.VarChar, 100),
new MySqlParameter("@Grade", MySqlDbType.VarChar, 10),
new MySqlParameter("@S_Point", MySqlDbType.VarChar, 100),
new MySqlParameter("@S_Deep", MySqlDbType.Decimal, 7),
new MySqlParameter("@In_Elev", MySqlDbType.Decimal, 7),
new MySqlParameter("@E_Point", MySqlDbType.VarChar, 100),
new MySqlParameter("@E_Deep", MySqlDbType.Decimal, 7),
new MySqlParameter("@Out_Elev", MySqlDbType.Decimal, 7),
new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Type", MySqlDbType.VarChar, 4),
new MySqlParameter("@Code", MySqlDbType.VarChar, 10),
new MySqlParameter("@Pressure_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Invert_Silphon", MySqlDbType.VarChar, 1),
new MySqlParameter("@Material", MySqlDbType.VarChar, 20),
new MySqlParameter("@ServiceLife", MySqlDbType.VarChar, 10),
new MySqlParameter("@ShapeType", MySqlDbType.VarChar, 10),
new MySqlParameter("@PSize", MySqlDbType.VarChar, 20),
new MySqlParameter("@PipeLength", MySqlDbType.Decimal, 7),
new MySqlParameter("@FlowDir", MySqlDbType.VarChar, 10),
new MySqlParameter("@EmBed", MySqlDbType.VarChar, 50),
new MySqlParameter("@Interface", MySqlDbType.VarChar, 50),
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("@Plan", MySqlDbType.VarChar, 10),
new MySqlParameter("@Pipe_Type", MySqlDbType.VarChar, 10),
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_No0", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_No1", 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.Lno;
parameters[3].Value = model.Grade;
parameters[4].Value = model.S_Point;
parameters[5].Value = model.S_Deep;
parameters[6].Value = model.In_Elev;
parameters[7].Value = model.E_Point;
parameters[8].Value = model.E_Deep;
parameters[9].Value = model.Out_Elev;
parameters[10].Value = model.SewageSystem_ID;
parameters[11].Value = model.StormSystem_ID;
parameters[12].Value = model.Type;
parameters[13].Value = model.Code;
parameters[14].Value = model.Pressure_Type;
parameters[15].Value = model.Invert_Silphon;
parameters[16].Value = model.Material;
parameters[17].Value = model.ServiceLife;
parameters[18].Value = model.ShapeType;
parameters[19].Value = model.PSize;
parameters[20].Value = model.PipeLength;
parameters[21].Value = model.FlowDir;
parameters[22].Value = model.EmBed;
parameters[23].Value = model.Interface;
parameters[24].Value = model.Address;
parameters[25].Value = model.DataSource;
parameters[26].Value = model.Sunit;
parameters[27].Value = model.Sdate;
parameters[28].Value = model.UpdateTime;
parameters[29].Value = model.Mdate;
parameters[30].Value = model.Plan;
parameters[31].Value = model.Pipe_Type;
parameters[32].Value = model.Status;
parameters[33].Value = model.Ename;
parameters[34].Value = model.Design_Dept;
parameters[35].Value = model.Conster_Dept;
parameters[36].Value = model.Belong;
parameters[37].Value = model.Operator;
parameters[38].Value = model.Note;
parameters[39].Value = model.Exp_No0;
parameters[40].Value = model.Exp_No1;
parameters[41].Value = model.FileName;
parameters[42].Value = model.Uploadtime;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.ps_pipe DataRowToModel(DataRow row)
{
Maticsoft.Model.ps_pipe model = new Maticsoft.Model.ps_pipe();
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["Lno"] != null)
{
model.Lno = row["Lno"].ToString();
}
if (row["Grade"] != null)
{
model.Grade = row["Grade"].ToString();
}
if (row["S_Point"] != null)
{
model.S_Point = row["S_Point"].ToString();
}
if (row["S_Deep"] != null && row["S_Deep"].ToString() != "")
{
model.S_Deep = decimal.Parse(row["S_Deep"].ToString());
}
if (row["In_Elev"] != null && row["In_Elev"].ToString() != "")
{
model.In_Elev = decimal.Parse(row["In_Elev"].ToString());
}
if (row["E_Point"] != null)
{
model.E_Point = row["E_Point"].ToString();
}
if (row["E_Deep"] != null && row["E_Deep"].ToString() != "")
{
model.E_Deep = decimal.Parse(row["E_Deep"].ToString());
}
if (row["Out_Elev"] != null && row["Out_Elev"].ToString() != "")
{
model.Out_Elev = decimal.Parse(row["Out_Elev"].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["Code"] != null)
{
model.Code = row["Code"].ToString();
}
if (row["Pressure_Type"] != null)
{
model.Pressure_Type = row["Pressure_Type"].ToString();
}
if (row["Invert_Silphon"] != null)
{
model.Invert_Silphon = row["Invert_Silphon"].ToString();
}
if (row["Material"] != null)
{
model.Material = row["Material"].ToString();
}
if (row["ServiceLife"] != null)
{
model.ServiceLife = row["ServiceLife"].ToString();
}
if (row["ShapeType"] != null)
{
model.ShapeType = row["ShapeType"].ToString();
}
if (row["PSize"] != null)
{
model.PSize = row["PSize"].ToString();
}
if (row["PipeLength"] != null && row["PipeLength"].ToString() != "")
{
model.PipeLength = decimal.Parse(row["PipeLength"].ToString());
}
if (row["FlowDir"] != null)
{
model.FlowDir = row["FlowDir"].ToString();
}
if (row["EmBed"] != null)
{
model.EmBed = row["EmBed"].ToString();
}
if (row["Interface"] != null)
{
model.Interface = row["Interface"].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["Plan"] != null)
{
model.Plan = row["Plan"].ToString();
}
if (row["Pipe_Type"] != null)
{
model.Pipe_Type = row["Pipe_Type"].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_No0"] != null)
{
model.Exp_No0 = row["Exp_No0"].ToString();
}
if (row["Exp_No1"] != null)
{
model.Exp_No1 = row["Exp_No1"].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_pipe model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ps_pipe set ");
strSql.Append("Prj_No=@Prj_No,");
strSql.Append("Prj_Name=@Prj_Name,");
strSql.Append("Grade=@Grade,");
strSql.Append("S_Point=@S_Point,");
strSql.Append("S_Deep=@S_Deep,");
strSql.Append("In_Elev=@In_Elev,");
strSql.Append("E_Point=@E_Point,");
strSql.Append("E_Deep=@E_Deep,");
strSql.Append("Out_Elev=@Out_Elev,");
strSql.Append("SewageSystem_ID=@SewageSystem_ID,");
strSql.Append("StormSystem_ID=@StormSystem_ID,");
strSql.Append("Type=@Type,");
strSql.Append("Code=@Code,");
strSql.Append("Pressure_Type=@Pressure_Type,");
strSql.Append("Invert_Silphon=@Invert_Silphon,");
strSql.Append("Material=@Material,");
strSql.Append("ServiceLife=@ServiceLife,");
strSql.Append("ShapeType=@ShapeType,");
strSql.Append("PSize=@PSize,");
strSql.Append("PipeLength=@PipeLength,");
strSql.Append("FlowDir=@FlowDir,");
strSql.Append("EmBed=@EmBed,");
strSql.Append("Interface=@Interface,");
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("Plan=@Plan,");
strSql.Append("Pipe_Type=@Pipe_Type,");
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_No0=@Exp_No0,");
strSql.Append("Exp_No1=@Exp_No1,");
strSql.Append("FileName=@FileName,");
strSql.Append("Uploadtime=@Uploadtime");
strSql.Append(" where Lno=@Lno ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Prj_No", MySqlDbType.VarChar, 255),
new MySqlParameter("@Prj_Name", MySqlDbType.VarChar, 255),
new MySqlParameter("@Grade", MySqlDbType.VarChar, 10),
new MySqlParameter("@S_Point", MySqlDbType.VarChar, 100),
new MySqlParameter("@S_Deep", MySqlDbType.Decimal, 7),
new MySqlParameter("@In_Elev", MySqlDbType.Decimal, 7),
new MySqlParameter("@E_Point", MySqlDbType.VarChar, 100),
new MySqlParameter("@E_Deep", MySqlDbType.Decimal, 7),
new MySqlParameter("@Out_Elev", MySqlDbType.Decimal, 7),
new MySqlParameter("@SewageSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Type", MySqlDbType.VarChar, 4),
new MySqlParameter("@Code", MySqlDbType.VarChar, 10),
new MySqlParameter("@Pressure_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Invert_Silphon", MySqlDbType.VarChar, 1),
new MySqlParameter("@Material", MySqlDbType.VarChar, 20),
new MySqlParameter("@ServiceLife", MySqlDbType.VarChar, 10),
new MySqlParameter("@ShapeType", MySqlDbType.VarChar, 10),
new MySqlParameter("@PSize", MySqlDbType.VarChar, 20),
new MySqlParameter("@PipeLength", MySqlDbType.Decimal, 7),
new MySqlParameter("@FlowDir", MySqlDbType.VarChar, 10),
new MySqlParameter("@EmBed", MySqlDbType.VarChar, 50),
new MySqlParameter("@Interface", MySqlDbType.VarChar, 50),
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("@Plan", MySqlDbType.VarChar, 10),
new MySqlParameter("@Pipe_Type", MySqlDbType.VarChar, 10),
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_No0", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_No1", MySqlDbType.VarChar, 255),
new MySqlParameter("@FileName", MySqlDbType.VarChar, 255),
new MySqlParameter("@Uploadtime", MySqlDbType.VarChar, 255),
new MySqlParameter("@Lno", MySqlDbType.VarChar, 100)
};
parameters[0].Value = model.Prj_No;
parameters[1].Value = model.Prj_Name;
parameters[2].Value = model.Grade;
parameters[3].Value = model.S_Point;
parameters[4].Value = model.S_Deep;
parameters[5].Value = model.In_Elev;
parameters[6].Value = model.E_Point;
parameters[7].Value = model.E_Deep;
parameters[8].Value = model.Out_Elev;
parameters[9].Value = model.SewageSystem_ID;
parameters[10].Value = model.StormSystem_ID;
parameters[11].Value = model.Type;
parameters[12].Value = model.Code;
parameters[13].Value = model.Pressure_Type;
parameters[14].Value = model.Invert_Silphon;
parameters[15].Value = model.Material;
parameters[16].Value = model.ServiceLife;
parameters[17].Value = model.ShapeType;
parameters[18].Value = model.PSize;
parameters[19].Value = model.PipeLength;
parameters[20].Value = model.FlowDir;
parameters[21].Value = model.EmBed;
parameters[22].Value = model.Interface;
parameters[23].Value = model.Address;
parameters[24].Value = model.DataSource;
parameters[25].Value = model.Sunit;
parameters[26].Value = model.Sdate;
parameters[27].Value = model.UpdateTime;
parameters[28].Value = model.Mdate;
parameters[29].Value = model.Plan;
parameters[30].Value = model.Pipe_Type;
parameters[31].Value = model.Status;
parameters[32].Value = model.Ename;
parameters[33].Value = model.Design_Dept;
parameters[34].Value = model.Conster_Dept;
parameters[35].Value = model.Belong;
parameters[36].Value = model.Operator;
parameters[37].Value = model.Note;
parameters[38].Value = model.Exp_No0;
parameters[39].Value = model.Exp_No1;
parameters[40].Value = model.FileName;
parameters[41].Value = model.Uploadtime;
parameters[42].Value = model.Lno;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
