private void ShowInfo(string S_Point, string E_Point)
{
Maticsoft.BLL.cjpll bll = new Maticsoft.BLL.cjpll();
Maticsoft.Model.cjpll model = bll.GetModel(S_Point, E_Point);
this.lblStormSystem_ID.Text = model.StormSystem_ID;
this.lblS_Point.Text = model.S_Point;
this.lblS_Deep.Text = model.S_Deep.ToString();
this.lblS_Elev.Text = model.S_Elev.ToString();
this.lblE_Point.Text = model.E_Point;
this.lblE_Deep.Text = model.E_Deep.ToString();
this.lblE_Elev.Text = model.E_Elev.ToString();
this.lblType.Text = model.Type;
this.lblPressure_Type.Text = model.Pressure_Type;
this.lblInvert_Silphon.Text = model.Invert_Silphon;
this.lblMaterial.Text = model.Material;
this.lblShapeType.Text = model.ShapeType;
this.lblGrade.Text = model.Grade;
this.lblPsize.Text = model.Psize;
this.lblFlowDir.Text = model.FlowDir;
this.lblConduitStyle.Text = model.ConduitStyle;
this.lblAddress.Text = model.Address;
this.lblDataSource.Text = model.DataSource;
this.lblSdate.Text = model.Sdate;
this.lblMdate.Text = model.Mdate;
this.lblPipe_Type.Text = model.Pipe_Type;
this.lblStatus.Text = model.Status;
this.lblNote.Text = model.Note;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.cjpll GetModel(string Exp_No0, string Exp_No1)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select StormSystem_ID,Exp_No0,S_Deep,S_Elev,Exp_No1,E_Deep,E_Elev,Type,Pressure_Type,Invert_Silphon,Material,ShapeType,Grade,Psize,FlowDir,ConduitStyle,Address,DataSource,Sdate,Mdate,Pipe_Type,Status,Note,FileName,Uploadtime,Lno,S_Point,E_Point,LnoTime,PipeLength from cjpll ");
strSql.Append(" where Exp_No0=@Exp_No0 and Exp_No1=@Exp_No1 ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Exp_No0", MySqlDbType.VarChar, 150),
new MySqlParameter("@Exp_No1", MySqlDbType.VarChar, 150)
};
parameters[0].Value = Exp_No0;
parameters[1].Value = Exp_No1;
Maticsoft.Model.cjpll model = new Maticsoft.Model.cjpll();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtStormSystem_ID.Text.Trim().Length == 0)
{
strErr += "StormSystem_ID不能为空！\\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(txtS_Elev.Text))
{
strErr += "S_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(txtE_Elev.Text))
{
strErr += "E_Elev格式错误！\\n";
}
if (this.txtType.Text.Trim().Length == 0)
{
strErr += "Type不能为空！\\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.txtShapeType.Text.Trim().Length == 0)
{
strErr += "ShapeType不能为空！\\n";
}
if (this.txtGrade.Text.Trim().Length == 0)
{
strErr += "Grade不能为空！\\n";
}
if (this.txtPsize.Text.Trim().Length == 0)
{
strErr += "Psize不能为空！\\n";
}
if (this.txtFlowDir.Text.Trim().Length == 0)
{
strErr += "FlowDir不能为空！\\n";
}
if (this.txtConduitStyle.Text.Trim().Length == 0)
{
strErr += "ConduitStyle不能为空！\\n";
}
if (this.txtAddress.Text.Trim().Length == 0)
{
strErr += "Address不能为空！\\n";
}
if (this.txtDataSource.Text.Trim().Length == 0)
{
strErr += "DataSource不能为空！\\n";
}
if (this.txtSdate.Text.Trim().Length == 0)
{
strErr += "Sdate不能为空！\\n";
}
if (this.txtMdate.Text.Trim().Length == 0)
{
strErr += "Mdate不能为空！\\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.txtNote.Text.Trim().Length == 0)
{
strErr += "Note不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string StormSystem_ID = this.txtStormSystem_ID.Text;
string S_Point = this.txtS_Point.Text;
decimal S_Deep = decimal.Parse(this.txtS_Deep.Text);
decimal S_Elev = decimal.Parse(this.txtS_Elev.Text);
string E_Point = this.txtE_Point.Text;
decimal E_Deep = decimal.Parse(this.txtE_Deep.Text);
decimal E_Elev = decimal.Parse(this.txtE_Elev.Text);
string Type = this.txtType.Text;
string Pressure_Type = this.txtPressure_Type.Text;
string Invert_Silphon = this.txtInvert_Silphon.Text;
string Material = this.txtMaterial.Text;
string ShapeType = this.txtShapeType.Text;
string Grade = this.txtGrade.Text;
string Psize = this.txtPsize.Text;
string FlowDir = this.txtFlowDir.Text;
string ConduitStyle = this.txtConduitStyle.Text;
string Address = this.txtAddress.Text;
string DataSource = this.txtDataSource.Text;
string Sdate = this.txtSdate.Text;
string Mdate = this.txtMdate.Text;
string Pipe_Type = this.txtPipe_Type.Text;
string Status = this.txtStatus.Text;
string Note = this.txtNote.Text;
Maticsoft.Model.cjpll model = new Maticsoft.Model.cjpll();
model.StormSystem_ID = StormSystem_ID;
model.S_Point = S_Point;
model.S_Deep = S_Deep;
model.S_Elev = S_Elev;
model.E_Point = E_Point;
model.E_Deep = E_Deep;
model.E_Elev = E_Elev;
model.Type = Type;
model.Pressure_Type = Pressure_Type;
model.Invert_Silphon = Invert_Silphon;
model.Material = Material;
model.ShapeType = ShapeType;
model.Grade = Grade;
model.Psize = Psize;
model.FlowDir = FlowDir;
model.ConduitStyle = ConduitStyle;
model.Address = Address;
model.DataSource = DataSource;
model.Sdate = Sdate;
model.Mdate = Mdate;
model.Pipe_Type = Pipe_Type;
model.Status = Status;
model.Note = Note;
Maticsoft.BLL.cjpll bll = new Maticsoft.BLL.cjpll();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.cjpll model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into cjpll(");
strSql.Append("StormSystem_ID,Exp_No0,S_Deep,S_Elev,Exp_No1,E_Deep,E_Elev,Type,Pressure_Type,Invert_Silphon,Material,ShapeType,Grade,Psize,FlowDir,ConduitStyle,Address,DataSource,Sdate,Mdate,Pipe_Type,Status,Note,FileName,Uploadtime,Lno,S_Point,E_Point,LnoTime,PipeLength)");
strSql.Append(" values (");
strSql.Append("@StormSystem_ID,@Exp_No0,@S_Deep,@S_Elev,@Exp_No1,@E_Deep,@E_Elev,@Type,@Pressure_Type,@Invert_Silphon,@Material,@ShapeType,@Grade,@Psize,@FlowDir,@ConduitStyle,@Address,@DataSource,@Sdate,@Mdate,@Pipe_Type,@Status,@Note,@FileName,@Uploadtime,@Lno,@S_Point,@E_Point,@LnoTime,@PipeLength)");
MySqlParameter[] parameters =
{
new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 255),
new MySqlParameter("@Exp_No0", MySqlDbType.VarChar, 150),
new MySqlParameter("@S_Deep", MySqlDbType.Decimal, 10),
new MySqlParameter("@S_Elev", MySqlDbType.Decimal, 10),
new MySqlParameter("@Exp_No1", MySqlDbType.VarChar, 150),
new MySqlParameter("@E_Deep", MySqlDbType.Decimal, 10),
new MySqlParameter("@E_Elev", MySqlDbType.Decimal, 10),
new MySqlParameter("@Type", MySqlDbType.VarChar, 50),
new MySqlParameter("@Pressure_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Invert_Silphon", MySqlDbType.VarChar, 10),
new MySqlParameter("@Material", MySqlDbType.VarChar, 100),
new MySqlParameter("@ShapeType", MySqlDbType.VarChar, 100),
new MySqlParameter("@Grade", MySqlDbType.VarChar, 10),
new MySqlParameter("@Psize", MySqlDbType.VarChar, 255),
new MySqlParameter("@FlowDir", MySqlDbType.VarChar, 10),
new MySqlParameter("@ConduitStyle", MySqlDbType.VarChar, 100),
new MySqlParameter("@Address", MySqlDbType.VarChar, 255),
new MySqlParameter("@DataSource", MySqlDbType.VarChar, 10),
new MySqlParameter("@Sdate", MySqlDbType.VarChar, 100),
new MySqlParameter("@Mdate", MySqlDbType.VarChar, 100),
new MySqlParameter("@Pipe_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Status", MySqlDbType.VarChar, 10),
new MySqlParameter("@Note", MySqlDbType.VarChar, 255),
new MySqlParameter("@FileName", MySqlDbType.VarChar, 255),
new MySqlParameter("@Uploadtime", MySqlDbType.VarChar, 255),
new MySqlParameter("@Lno", MySqlDbType.VarChar, 255),
new MySqlParameter("@S_Point", MySqlDbType.VarChar, 255),
new MySqlParameter("@E_Point", MySqlDbType.VarChar, 255),
new MySqlParameter("@LnoTime", MySqlDbType.VarChar, 255),
new MySqlParameter("@PipeLength", MySqlDbType.Decimal, 7)
};
parameters[0].Value = model.StormSystem_ID;
parameters[1].Value = model.Exp_No0;
parameters[2].Value = model.S_Deep;
parameters[3].Value = model.S_Elev;
parameters[4].Value = model.Exp_No1;
parameters[5].Value = model.E_Deep;
parameters[6].Value = model.E_Elev;
parameters[7].Value = model.Type;
parameters[8].Value = model.Pressure_Type;
parameters[9].Value = model.Invert_Silphon;
parameters[10].Value = model.Material;
parameters[11].Value = model.ShapeType;
parameters[12].Value = model.Grade;
parameters[13].Value = model.Psize;
parameters[14].Value = model.FlowDir;
parameters[15].Value = model.ConduitStyle;
parameters[16].Value = model.Address;
parameters[17].Value = model.DataSource;
parameters[18].Value = model.Sdate;
parameters[19].Value = model.Mdate;
parameters[20].Value = model.Pipe_Type;
parameters[21].Value = model.Status;
parameters[22].Value = model.Note;
parameters[23].Value = model.FileName;
parameters[24].Value = model.Uploadtime;
parameters[25].Value = model.Lno;
parameters[26].Value = model.S_Point;
parameters[27].Value = model.E_Point;
parameters[28].Value = model.LnoTime;
parameters[29].Value = model.PipeLength;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.cjpll DataRowToModel(DataRow row)
{
Maticsoft.Model.cjpll model = new Maticsoft.Model.cjpll();
if (row != null)
{
if (row["StormSystem_ID"] != null)
{
model.StormSystem_ID = row["StormSystem_ID"].ToString();
}
if (row["Exp_No0"] != null)
{
model.Exp_No0 = row["Exp_No0"].ToString();
}
if (row["S_Deep"] != null && row["S_Deep"].ToString() != "")
{
model.S_Deep = decimal.Parse(row["S_Deep"].ToString());
}
if (row["S_Elev"] != null && row["S_Elev"].ToString() != "")
{
model.S_Elev = decimal.Parse(row["S_Elev"].ToString());
}
if (row["Exp_No1"] != null)
{
model.Exp_No1 = row["Exp_No1"].ToString();
}
if (row["E_Deep"] != null && row["E_Deep"].ToString() != "")
{
model.E_Deep = decimal.Parse(row["E_Deep"].ToString());
}
if (row["E_Elev"] != null && row["E_Elev"].ToString() != "")
{
model.E_Elev = decimal.Parse(row["E_Elev"].ToString());
}
if (row["Type"] != null)
{
model.Type = row["Type"].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["ShapeType"] != null)
{
model.ShapeType = row["ShapeType"].ToString();
}
if (row["Grade"] != null)
{
model.Grade = row["Grade"].ToString();
}
if (row["Psize"] != null)
{
model.Psize = row["Psize"].ToString();
}
if (row["FlowDir"] != null)
{
model.FlowDir = row["FlowDir"].ToString();
}
if (row["ConduitStyle"] != null)
{
model.ConduitStyle = row["ConduitStyle"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["DataSource"] != null)
{
model.DataSource = row["DataSource"].ToString();
}
if (row["Sdate"] != null)
{
model.Sdate = row["Sdate"].ToString();
}
if (row["Mdate"] != null)
{
model.Mdate = row["Mdate"].ToString();
}
if (row["Pipe_Type"] != null)
{
model.Pipe_Type = row["Pipe_Type"].ToString();
}
if (row["Status"] != null)
{
model.Status = row["Status"].ToString();
}
if (row["Note"] != null)
{
model.Note = row["Note"].ToString();
}
if (row["FileName"] != null)
{
model.FileName = row["FileName"].ToString();
}
if (row["Uploadtime"] != null)
{
model.Uploadtime = row["Uploadtime"].ToString();
}
if (row["Lno"] != null)
{
model.Lno = row["Lno"].ToString();
}
if (row["S_Point"] != null)
{
model.S_Point = row["S_Point"].ToString();
}
if (row["E_Point"] != null)
{
model.E_Point = row["E_Point"].ToString();
}
if (row["LnoTime"] != null)
{
model.LnoTime = row["LnoTime"].ToString();
}
if (row["PipeLength"] != null && row["PipeLength"].ToString() != "")
{
model.PipeLength = decimal.Parse(row["PipeLength"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.cjpll model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update cjpll set ");
strSql.Append("StormSystem_ID=@StormSystem_ID,");
strSql.Append("S_Deep=@S_Deep,");
strSql.Append("S_Elev=@S_Elev,");
strSql.Append("E_Deep=@E_Deep,");
strSql.Append("E_Elev=@E_Elev,");
strSql.Append("Type=@Type,");
strSql.Append("Pressure_Type=@Pressure_Type,");
strSql.Append("Invert_Silphon=@Invert_Silphon,");
strSql.Append("Material=@Material,");
strSql.Append("ShapeType=@ShapeType,");
strSql.Append("Grade=@Grade,");
strSql.Append("Psize=@Psize,");
strSql.Append("FlowDir=@FlowDir,");
strSql.Append("ConduitStyle=@ConduitStyle,");
strSql.Append("Address=@Address,");
strSql.Append("DataSource=@DataSource,");
strSql.Append("Sdate=@Sdate,");
strSql.Append("Mdate=@Mdate,");
strSql.Append("Pipe_Type=@Pipe_Type,");
strSql.Append("Status=@Status,");
strSql.Append("Note=@Note,");
strSql.Append("FileName=@FileName,");
strSql.Append("Uploadtime=@Uploadtime,");
strSql.Append("Lno=@Lno,");
strSql.Append("S_Point=@S_Point,");
strSql.Append("E_Point=@E_Point,");
strSql.Append("LnoTime=@LnoTime,");
strSql.Append("PipeLength=@PipeLength");
strSql.Append(" where Exp_No0=@Exp_No0 and Exp_No1=@Exp_No1 ");
MySqlParameter[] parameters =
{
new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 255),
new MySqlParameter("@S_Deep", MySqlDbType.Decimal, 10),
new MySqlParameter("@S_Elev", MySqlDbType.Decimal, 10),
new MySqlParameter("@E_Deep", MySqlDbType.Decimal, 10),
new MySqlParameter("@E_Elev", MySqlDbType.Decimal, 10),
new MySqlParameter("@Type", MySqlDbType.VarChar, 50),
new MySqlParameter("@Pressure_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Invert_Silphon", MySqlDbType.VarChar, 10),
new MySqlParameter("@Material", MySqlDbType.VarChar, 100),
new MySqlParameter("@ShapeType", MySqlDbType.VarChar, 100),
new MySqlParameter("@Grade", MySqlDbType.VarChar, 10),
new MySqlParameter("@Psize", MySqlDbType.VarChar, 255),
new MySqlParameter("@FlowDir", MySqlDbType.VarChar, 10),
new MySqlParameter("@ConduitStyle", MySqlDbType.VarChar, 100),
new MySqlParameter("@Address", MySqlDbType.VarChar, 255),
new MySqlParameter("@DataSource", MySqlDbType.VarChar, 10),
new MySqlParameter("@Sdate", MySqlDbType.VarChar, 100),
new MySqlParameter("@Mdate", MySqlDbType.VarChar, 100),
new MySqlParameter("@Pipe_Type", MySqlDbType.VarChar, 10),
new MySqlParameter("@Status", MySqlDbType.VarChar, 10),
new MySqlParameter("@Note", MySqlDbType.VarChar, 255),
new MySqlParameter("@FileName", MySqlDbType.VarChar, 255),
new MySqlParameter("@Uploadtime", MySqlDbType.VarChar, 255),
new MySqlParameter("@Lno", MySqlDbType.VarChar, 255),
new MySqlParameter("@S_Point", MySqlDbType.VarChar, 255),
new MySqlParameter("@E_Point", MySqlDbType.VarChar, 255),
new MySqlParameter("@LnoTime", MySqlDbType.VarChar, 255),
new MySqlParameter("@PipeLength", MySqlDbType.Decimal, 7),
new MySqlParameter("@Exp_No0", MySqlDbType.VarChar, 150),
new MySqlParameter("@Exp_No1", MySqlDbType.VarChar, 150)
};
parameters[0].Value = model.StormSystem_ID;
parameters[1].Value = model.S_Deep;
parameters[2].Value = model.S_Elev;
parameters[3].Value = model.E_Deep;
parameters[4].Value = model.E_Elev;
parameters[5].Value = model.Type;
parameters[6].Value = model.Pressure_Type;
parameters[7].Value = model.Invert_Silphon;
parameters[8].Value = model.Material;
parameters[9].Value = model.ShapeType;
parameters[10].Value = model.Grade;
parameters[11].Value = model.Psize;
parameters[12].Value = model.FlowDir;
parameters[13].Value = model.ConduitStyle;
parameters[14].Value = model.Address;
parameters[15].Value = model.DataSource;
parameters[16].Value = model.Sdate;
parameters[17].Value = model.Mdate;
parameters[18].Value = model.Pipe_Type;
parameters[19].Value = model.Status;
parameters[20].Value = model.Note;
parameters[21].Value = model.FileName;
parameters[22].Value = model.Uploadtime;
parameters[23].Value = model.Lno;
parameters[24].Value = model.S_Point;
parameters[25].Value = model.E_Point;
parameters[26].Value = model.LnoTime;
parameters[27].Value = model.PipeLength;
parameters[28].Value = model.Exp_No0;
parameters[29].Value = model.Exp_No1;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
