private void ShowInfo(string Exp_No)
{
Maticsoft.BLL.ps_discharger bll = new Maticsoft.BLL.ps_discharger();
Maticsoft.Model.ps_discharger 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.lblCode.Text = model.Code;
this.lblAddress.Text = model.Address;
this.lblName.Text = model.Name;
this.lblCodeID.Text = model.CodeID;
this.lblRepresentative.Text = model.Representative;
this.lblTel.Text = model.Tel;
this.lblManager.Text = model.Manager;
this.lblLicence_ID.Text = model.Licence_ID;
this.lblLicence_Issue_Date.Text = model.Licence_Issue_Date;
this.lblSort.Text = model.Sort;
this.lblConn_ManholeID.Text = model.Conn_ManholeID;
this.lblBusiness.Text = model.Business;
this.lblProcess.Text = model.Process;
this.lblPollutant_Name.Text = model.Pollutant_Name;
this.lblTreatment_Method.Text = model.Treatment_Method;
this.lblTreatment_Facilities.Text = model.Treatment_Facilities;
this.lblTreatment_Capacity.Text = model.Treatment_Capacity.ToString();
this.lblWater_Daily_Consumption.Text = model.Water_Daily_Consumption.ToString();
this.lblWater_Self_Supply_Daily.Text = model.Water_Self_Supply_Daily.ToString();
this.lblWater_Discharge_Quantity.Text = model.Water_Discharge_Quantity.ToString();
this.lblProduction_Waste_Quantity.Text = model.Production_Waste_Quantity.ToString();
this.lblSanitary_Waste_Quantity.Text = model.Sanitary_Waste_Quantity.ToString();
this.lblTemp.Text = model.Temp.ToString();
this.lblpH.Text = model.pH.ToString();
this.lblSS.Text = model.SS.ToString();
this.lblBOD5.Text = model.BOD5.ToString();
this.lblCODcr.Text = model.CODcr.ToString();
this.lblNH3_N.Text = model.NH3_N.ToString();
this.lblTN.Text = model.TN.ToString();
this.lblTP.Text = model.TP.ToString();
this.lblSunit.Text = model.Sunit;
this.lblSdate.Text = model.Sdate;
this.lblUpdateTime.Text = model.UpdateTime;
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_discharger GetModel(string Exp_No)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Prj_No,Prj_Name,Exp_No,Code,Address,Name,CodeID,Representative,Tel,Manager,Licence_ID,Licence_Issue_Date,Sort,Conn_ManholeID,Business,Process,Pollutant_Name,Treatment_Method,Treatment_Facilities,Treatment_Capacity,Water_Daily_Consumption,Water_Self_Supply_Daily,Water_Discharge_Quantity,Production_Waste_Quantity,Sanitary_Waste_Quantity,Temp,pH,SS,BOD5,CODcr,NH3_N,TN,TP,Sunit,Sdate,UpdateTime,Note,Exp_NoOri,FileName,Uploadtime from ps_discharger ");
strSql.Append(" where Exp_No=@Exp_No ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Exp_No", MySqlDbType.VarChar, 100)
};
parameters[0].Value = Exp_No;
Maticsoft.Model.ps_discharger model = new Maticsoft.Model.ps_discharger();
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.txtPrj_No.Text.Trim().Length == 0)
{
strErr += "Prj_No不能为空！\\n";
}
if (this.txtPrj_Name.Text.Trim().Length == 0)
{
strErr += "Prj_Name不能为空！\\n";
}
if (this.txtExp_No.Text.Trim().Length == 0)
{
strErr += "Exp_No不能为空！\\n";
}
if (this.txtCode.Text.Trim().Length == 0)
{
strErr += "Code不能为空！\\n";
}
if (this.txtAddress.Text.Trim().Length == 0)
{
strErr += "Address不能为空！\\n";
}
if (this.txtName.Text.Trim().Length == 0)
{
strErr += "Name不能为空！\\n";
}
if (this.txtCodeID.Text.Trim().Length == 0)
{
strErr += "CodeID不能为空！\\n";
}
if (this.txtRepresentative.Text.Trim().Length == 0)
{
strErr += "Representative不能为空！\\n";
}
if (this.txtTel.Text.Trim().Length == 0)
{
strErr += "Tel不能为空！\\n";
}
if (this.txtManager.Text.Trim().Length == 0)
{
strErr += "Manager不能为空！\\n";
}
if (this.txtLicence_ID.Text.Trim().Length == 0)
{
strErr += "Licence_ID不能为空！\\n";
}
if (this.txtLicence_Issue_Date.Text.Trim().Length == 0)
{
strErr += "Licence_Issue_Date不能为空！\\n";
}
if (this.txtSort.Text.Trim().Length == 0)
{
strErr += "Sort不能为空！\\n";
}
if (this.txtConn_ManholeID.Text.Trim().Length == 0)
{
strErr += "Conn_ManholeID不能为空！\\n";
}
if (this.txtBusiness.Text.Trim().Length == 0)
{
strErr += "Business不能为空！\\n";
}
if (this.txtProcess.Text.Trim().Length == 0)
{
strErr += "Process不能为空！\\n";
}
if (this.txtPollutant_Name.Text.Trim().Length == 0)
{
strErr += "Pollutant_Name不能为空！\\n";
}
if (this.txtTreatment_Method.Text.Trim().Length == 0)
{
strErr += "Treatment_Method不能为空！\\n";
}
if (this.txtTreatment_Facilities.Text.Trim().Length == 0)
{
strErr += "Treatment_Facilities不能为空！\\n";
}
if (!PageValidate.IsDecimal(txtTreatment_Capacity.Text))
{
strErr += "Treatment_Capacity格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtWater_Daily_Consumption.Text))
{
strErr += "Water_Daily_Consumption格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtWater_Self_Supply_Daily.Text))
{
strErr += "Water_Self_Supply_Daily格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtWater_Discharge_Quantity.Text))
{
strErr += "Water_Discharge_Quantity格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtProduction_Waste_Quantity.Text))
{
strErr += "Production_Waste_Quantity格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtSanitary_Waste_Quantity.Text))
{
strErr += "Sanitary_Waste_Quantity格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtTemp.Text))
{
strErr += "Temp格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtpH.Text))
{
strErr += "pH格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtSS.Text))
{
strErr += "SS格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtBOD5.Text))
{
strErr += "BOD5格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtCODcr.Text))
{
strErr += "CODcr格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtNH3_N.Text))
{
strErr += "NH3_N格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtTN.Text))
{
strErr += "TN格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtTP.Text))
{
strErr += "TP格式错误！\\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.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.txtExp_No.Text;
string Code = this.txtCode.Text;
string Address = this.txtAddress.Text;
string Name = this.txtName.Text;
string CodeID = this.txtCodeID.Text;
string Representative = this.txtRepresentative.Text;
string Tel = this.txtTel.Text;
string Manager = this.txtManager.Text;
string Licence_ID = this.txtLicence_ID.Text;
string Licence_Issue_Date = this.txtLicence_Issue_Date.Text;
string Sort = this.txtSort.Text;
string Conn_ManholeID = this.txtConn_ManholeID.Text;
string Business = this.txtBusiness.Text;
string Process = this.txtProcess.Text;
string Pollutant_Name = this.txtPollutant_Name.Text;
string Treatment_Method = this.txtTreatment_Method.Text;
string Treatment_Facilities = this.txtTreatment_Facilities.Text;
decimal Treatment_Capacity = decimal.Parse(this.txtTreatment_Capacity.Text);
decimal Water_Daily_Consumption = decimal.Parse(this.txtWater_Daily_Consumption.Text);
decimal Water_Self_Supply_Daily = decimal.Parse(this.txtWater_Self_Supply_Daily.Text);
decimal Water_Discharge_Quantity = decimal.Parse(this.txtWater_Discharge_Quantity.Text);
decimal Production_Waste_Quantity = decimal.Parse(this.txtProduction_Waste_Quantity.Text);
decimal Sanitary_Waste_Quantity = decimal.Parse(this.txtSanitary_Waste_Quantity.Text);
decimal Temp = decimal.Parse(this.txtTemp.Text);
decimal pH = decimal.Parse(this.txtpH.Text);
decimal SS = decimal.Parse(this.txtSS.Text);
decimal BOD5 = decimal.Parse(this.txtBOD5.Text);
decimal CODcr = decimal.Parse(this.txtCODcr.Text);
decimal NH3_N = decimal.Parse(this.txtNH3_N.Text);
decimal TN = decimal.Parse(this.txtTN.Text);
decimal TP = decimal.Parse(this.txtTP.Text);
string Sunit = this.txtSunit.Text;
string Sdate = this.txtSdate.Text;
string UpdateTime = this.txtUpdateTime.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_discharger model = new Maticsoft.Model.ps_discharger();
model.Prj_No = Prj_No;
model.Prj_Name = Prj_Name;
model.Exp_No = Exp_No;
model.Code = Code;
model.Address = Address;
model.Name = Name;
model.CodeID = CodeID;
model.Representative = Representative;
model.Tel = Tel;
model.Manager = Manager;
model.Licence_ID = Licence_ID;
model.Licence_Issue_Date = Licence_Issue_Date;
model.Sort = Sort;
model.Conn_ManholeID = Conn_ManholeID;
model.Business = Business;
model.Process = Process;
model.Pollutant_Name = Pollutant_Name;
model.Treatment_Method = Treatment_Method;
model.Treatment_Facilities = Treatment_Facilities;
model.Treatment_Capacity = Treatment_Capacity;
model.Water_Daily_Consumption = Water_Daily_Consumption;
model.Water_Self_Supply_Daily = Water_Self_Supply_Daily;
model.Water_Discharge_Quantity = Water_Discharge_Quantity;
model.Production_Waste_Quantity = Production_Waste_Quantity;
model.Sanitary_Waste_Quantity = Sanitary_Waste_Quantity;
model.Temp = Temp;
model.pH = pH;
model.SS = SS;
model.BOD5 = BOD5;
model.CODcr = CODcr;
model.NH3_N = NH3_N;
model.TN = TN;
model.TP = TP;
model.Sunit = Sunit;
model.Sdate = Sdate;
model.UpdateTime = UpdateTime;
model.Note = Note;
model.Exp_NoOri = Exp_NoOri;
model.filename = filename;
model.update = update;
Maticsoft.BLL.ps_discharger bll = new Maticsoft.BLL.ps_discharger();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.ps_discharger model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ps_discharger(");
strSql.Append("Prj_No,Prj_Name,Exp_No,Code,Address,Name,CodeID,Representative,Tel,Manager,Licence_ID,Licence_Issue_Date,Sort,Conn_ManholeID,Business,Process,Pollutant_Name,Treatment_Method,Treatment_Facilities,Treatment_Capacity,Water_Daily_Consumption,Water_Self_Supply_Daily,Water_Discharge_Quantity,Production_Waste_Quantity,Sanitary_Waste_Quantity,Temp,pH,SS,BOD5,CODcr,NH3_N,TN,TP,Sunit,Sdate,UpdateTime,Note,Exp_NoOri,FileName,Uploadtime)");
strSql.Append(" values (");
strSql.Append("@Prj_No,@Prj_Name,@Exp_No,@Code,@Address,@Name,@CodeID,@Representative,@Tel,@Manager,@Licence_ID,@Licence_Issue_Date,@Sort,@Conn_ManholeID,@Business,@Process,@Pollutant_Name,@Treatment_Method,@Treatment_Facilities,@Treatment_Capacity,@Water_Daily_Consumption,@Water_Self_Supply_Daily,@Water_Discharge_Quantity,@Production_Waste_Quantity,@Sanitary_Waste_Quantity,@Temp,@pH,@SS,@BOD5,@CODcr,@NH3_N,@TN,@TP,@Sunit,@Sdate,@UpdateTime,@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("@Code", MySqlDbType.VarChar, 10),
new MySqlParameter("@Address", MySqlDbType.VarChar, 100),
new MySqlParameter("@Name", MySqlDbType.VarChar, 100),
new MySqlParameter("@CodeID", MySqlDbType.VarChar, 255),
new MySqlParameter("@Representative", MySqlDbType.VarChar, 50),
new MySqlParameter("@Tel", MySqlDbType.VarChar, 50),
new MySqlParameter("@Manager", MySqlDbType.VarChar, 50),
new MySqlParameter("@Licence_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Licence_Issue_Date", MySqlDbType.VarChar, 255),
new MySqlParameter("@Sort", MySqlDbType.VarChar, 50),
new MySqlParameter("@Conn_ManholeID", MySqlDbType.VarChar, 10),
new MySqlParameter("@Business", MySqlDbType.VarChar, 100),
new MySqlParameter("@Process", MySqlDbType.VarChar, 255),
new MySqlParameter("@Pollutant_Name", MySqlDbType.VarChar, 100),
new MySqlParameter("@Treatment_Method", MySqlDbType.VarChar, 200),
new MySqlParameter("@Treatment_Facilities", MySqlDbType.VarChar, 200),
new MySqlParameter("@Treatment_Capacity", MySqlDbType.Decimal, 7),
new MySqlParameter("@Water_Daily_Consumption", MySqlDbType.Decimal, 7),
new MySqlParameter("@Water_Self_Supply_Daily", MySqlDbType.Decimal, 7),
new MySqlParameter("@Water_Discharge_Quantity", MySqlDbType.Decimal, 7),
new MySqlParameter("@Production_Waste_Quantity", MySqlDbType.Decimal, 7),
new MySqlParameter("@Sanitary_Waste_Quantity", MySqlDbType.Decimal, 7),
new MySqlParameter("@Temp", MySqlDbType.Decimal, 7),
new MySqlParameter("@pH", MySqlDbType.Decimal, 7),
new MySqlParameter("@SS", MySqlDbType.Decimal, 7),
new MySqlParameter("@BOD5", MySqlDbType.Decimal, 7),
new MySqlParameter("@CODcr", MySqlDbType.Decimal, 7),
new MySqlParameter("@NH3_N", MySqlDbType.Decimal, 7),
new MySqlParameter("@TN", MySqlDbType.Decimal, 7),
new MySqlParameter("@TP", MySqlDbType.Decimal, 7),
new MySqlParameter("@Sunit", MySqlDbType.VarChar, 255),
new MySqlParameter("@Sdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@UpdateTime", 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.Code;
parameters[4].Value = model.Address;
parameters[5].Value = model.Name;
parameters[6].Value = model.CodeID;
parameters[7].Value = model.Representative;
parameters[8].Value = model.Tel;
parameters[9].Value = model.Manager;
parameters[10].Value = model.Licence_ID;
parameters[11].Value = model.Licence_Issue_Date;
parameters[12].Value = model.Sort;
parameters[13].Value = model.Conn_ManholeID;
parameters[14].Value = model.Business;
parameters[15].Value = model.Process;
parameters[16].Value = model.Pollutant_Name;
parameters[17].Value = model.Treatment_Method;
parameters[18].Value = model.Treatment_Facilities;
parameters[19].Value = model.Treatment_Capacity;
parameters[20].Value = model.Water_Daily_Consumption;
parameters[21].Value = model.Water_Self_Supply_Daily;
parameters[22].Value = model.Water_Discharge_Quantity;
parameters[23].Value = model.Production_Waste_Quantity;
parameters[24].Value = model.Sanitary_Waste_Quantity;
parameters[25].Value = model.Temp;
parameters[26].Value = model.pH;
parameters[27].Value = model.SS;
parameters[28].Value = model.BOD5;
parameters[29].Value = model.CODcr;
parameters[30].Value = model.NH3_N;
parameters[31].Value = model.TN;
parameters[32].Value = model.TP;
parameters[33].Value = model.Sunit;
parameters[34].Value = model.Sdate;
parameters[35].Value = model.UpdateTime;
parameters[36].Value = model.Note;
parameters[37].Value = model.Exp_NoOri;
parameters[38].Value = model.FileName;
parameters[39].Value = model.Uploadtime;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.ps_discharger DataRowToModel(DataRow row)
{
Maticsoft.Model.ps_discharger model = new Maticsoft.Model.ps_discharger();
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["Code"] != null)
{
model.Code = row["Code"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["CodeID"] != null)
{
model.CodeID = row["CodeID"].ToString();
}
if (row["Representative"] != null)
{
model.Representative = row["Representative"].ToString();
}
if (row["Tel"] != null)
{
model.Tel = row["Tel"].ToString();
}
if (row["Manager"] != null)
{
model.Manager = row["Manager"].ToString();
}
if (row["Licence_ID"] != null)
{
model.Licence_ID = row["Licence_ID"].ToString();
}
if (row["Licence_Issue_Date"] != null)
{
model.Licence_Issue_Date = row["Licence_Issue_Date"].ToString();
}
if (row["Sort"] != null)
{
model.Sort = row["Sort"].ToString();
}
if (row["Conn_ManholeID"] != null)
{
model.Conn_ManholeID = row["Conn_ManholeID"].ToString();
}
if (row["Business"] != null)
{
model.Business = row["Business"].ToString();
}
if (row["Process"] != null)
{
model.Process = row["Process"].ToString();
}
if (row["Pollutant_Name"] != null)
{
model.Pollutant_Name = row["Pollutant_Name"].ToString();
}
if (row["Treatment_Method"] != null)
{
model.Treatment_Method = row["Treatment_Method"].ToString();
}
if (row["Treatment_Facilities"] != null)
{
model.Treatment_Facilities = row["Treatment_Facilities"].ToString();
}
if (row["Treatment_Capacity"] != null && row["Treatment_Capacity"].ToString() != "")
{
model.Treatment_Capacity = decimal.Parse(row["Treatment_Capacity"].ToString());
}
if (row["Water_Daily_Consumption"] != null && row["Water_Daily_Consumption"].ToString() != "")
{
model.Water_Daily_Consumption = decimal.Parse(row["Water_Daily_Consumption"].ToString());
}
if (row["Water_Self_Supply_Daily"] != null && row["Water_Self_Supply_Daily"].ToString() != "")
{
model.Water_Self_Supply_Daily = decimal.Parse(row["Water_Self_Supply_Daily"].ToString());
}
if (row["Water_Discharge_Quantity"] != null && row["Water_Discharge_Quantity"].ToString() != "")
{
model.Water_Discharge_Quantity = decimal.Parse(row["Water_Discharge_Quantity"].ToString());
}
if (row["Production_Waste_Quantity"] != null && row["Production_Waste_Quantity"].ToString() != "")
{
model.Production_Waste_Quantity = decimal.Parse(row["Production_Waste_Quantity"].ToString());
}
if (row["Sanitary_Waste_Quantity"] != null && row["Sanitary_Waste_Quantity"].ToString() != "")
{
model.Sanitary_Waste_Quantity = decimal.Parse(row["Sanitary_Waste_Quantity"].ToString());
}
if (row["Temp"] != null && row["Temp"].ToString() != "")
{
model.Temp = decimal.Parse(row["Temp"].ToString());
}
if (row["pH"] != null && row["pH"].ToString() != "")
{
model.pH = decimal.Parse(row["pH"].ToString());
}
if (row["SS"] != null && row["SS"].ToString() != "")
{
model.SS = decimal.Parse(row["SS"].ToString());
}
if (row["BOD5"] != null && row["BOD5"].ToString() != "")
{
model.BOD5 = decimal.Parse(row["BOD5"].ToString());
}
if (row["CODcr"] != null && row["CODcr"].ToString() != "")
{
model.CODcr = decimal.Parse(row["CODcr"].ToString());
}
if (row["NH3_N"] != null && row["NH3_N"].ToString() != "")
{
model.NH3_N = decimal.Parse(row["NH3_N"].ToString());
}
if (row["TN"] != null && row["TN"].ToString() != "")
{
model.TN = decimal.Parse(row["TN"].ToString());
}
if (row["TP"] != null && row["TP"].ToString() != "")
{
model.TP = decimal.Parse(row["TP"].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["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_discharger model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ps_discharger set ");
strSql.Append("Prj_No=@Prj_No,");
strSql.Append("Prj_Name=@Prj_Name,");
strSql.Append("Code=@Code,");
strSql.Append("Address=@Address,");
strSql.Append("Name=@Name,");
strSql.Append("CodeID=@CodeID,");
strSql.Append("Representative=@Representative,");
strSql.Append("Tel=@Tel,");
strSql.Append("Manager=@Manager,");
strSql.Append("Licence_ID=@Licence_ID,");
strSql.Append("Licence_Issue_Date=@Licence_Issue_Date,");
strSql.Append("Sort=@Sort,");
strSql.Append("Conn_ManholeID=@Conn_ManholeID,");
strSql.Append("Business=@Business,");
strSql.Append("Process=@Process,");
strSql.Append("Pollutant_Name=@Pollutant_Name,");
strSql.Append("Treatment_Method=@Treatment_Method,");
strSql.Append("Treatment_Facilities=@Treatment_Facilities,");
strSql.Append("Treatment_Capacity=@Treatment_Capacity,");
strSql.Append("Water_Daily_Consumption=@Water_Daily_Consumption,");
strSql.Append("Water_Self_Supply_Daily=@Water_Self_Supply_Daily,");
strSql.Append("Water_Discharge_Quantity=@Water_Discharge_Quantity,");
strSql.Append("Production_Waste_Quantity=@Production_Waste_Quantity,");
strSql.Append("Sanitary_Waste_Quantity=@Sanitary_Waste_Quantity,");
strSql.Append("Temp=@Temp,");
strSql.Append("pH=@pH,");
strSql.Append("SS=@SS,");
strSql.Append("BOD5=@BOD5,");
strSql.Append("CODcr=@CODcr,");
strSql.Append("NH3_N=@NH3_N,");
strSql.Append("TN=@TN,");
strSql.Append("TP=@TP,");
strSql.Append("Sunit=@Sunit,");
strSql.Append("Sdate=@Sdate,");
strSql.Append("UpdateTime=@UpdateTime,");
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("@Code", MySqlDbType.VarChar, 10),
new MySqlParameter("@Address", MySqlDbType.VarChar, 100),
new MySqlParameter("@Name", MySqlDbType.VarChar, 100),
new MySqlParameter("@CodeID", MySqlDbType.VarChar, 255),
new MySqlParameter("@Representative", MySqlDbType.VarChar, 50),
new MySqlParameter("@Tel", MySqlDbType.VarChar, 50),
new MySqlParameter("@Manager", MySqlDbType.VarChar, 50),
new MySqlParameter("@Licence_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@Licence_Issue_Date", MySqlDbType.VarChar, 255),
new MySqlParameter("@Sort", MySqlDbType.VarChar, 50),
new MySqlParameter("@Conn_ManholeID", MySqlDbType.VarChar, 10),
new MySqlParameter("@Business", MySqlDbType.VarChar, 100),
new MySqlParameter("@Process", MySqlDbType.VarChar, 255),
new MySqlParameter("@Pollutant_Name", MySqlDbType.VarChar, 100),
new MySqlParameter("@Treatment_Method", MySqlDbType.VarChar, 200),
new MySqlParameter("@Treatment_Facilities", MySqlDbType.VarChar, 200),
new MySqlParameter("@Treatment_Capacity", MySqlDbType.Decimal, 7),
new MySqlParameter("@Water_Daily_Consumption", MySqlDbType.Decimal, 7),
new MySqlParameter("@Water_Self_Supply_Daily", MySqlDbType.Decimal, 7),
new MySqlParameter("@Water_Discharge_Quantity", MySqlDbType.Decimal, 7),
new MySqlParameter("@Production_Waste_Quantity", MySqlDbType.Decimal, 7),
new MySqlParameter("@Sanitary_Waste_Quantity", MySqlDbType.Decimal, 7),
new MySqlParameter("@Temp", MySqlDbType.Decimal, 7),
new MySqlParameter("@pH", MySqlDbType.Decimal, 7),
new MySqlParameter("@SS", MySqlDbType.Decimal, 7),
new MySqlParameter("@BOD5", MySqlDbType.Decimal, 7),
new MySqlParameter("@CODcr", MySqlDbType.Decimal, 7),
new MySqlParameter("@NH3_N", MySqlDbType.Decimal, 7),
new MySqlParameter("@TN", MySqlDbType.Decimal, 7),
new MySqlParameter("@TP", MySqlDbType.Decimal, 7),
new MySqlParameter("@Sunit", MySqlDbType.VarChar, 255),
new MySqlParameter("@Sdate", MySqlDbType.VarChar, 255),
new MySqlParameter("@UpdateTime", 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.Code;
parameters[3].Value = model.Address;
parameters[4].Value = model.Name;
parameters[5].Value = model.CodeID;
parameters[6].Value = model.Representative;
parameters[7].Value = model.Tel;
parameters[8].Value = model.Manager;
parameters[9].Value = model.Licence_ID;
parameters[10].Value = model.Licence_Issue_Date;
parameters[11].Value = model.Sort;
parameters[12].Value = model.Conn_ManholeID;
parameters[13].Value = model.Business;
parameters[14].Value = model.Process;
parameters[15].Value = model.Pollutant_Name;
parameters[16].Value = model.Treatment_Method;
parameters[17].Value = model.Treatment_Facilities;
parameters[18].Value = model.Treatment_Capacity;
parameters[19].Value = model.Water_Daily_Consumption;
parameters[20].Value = model.Water_Self_Supply_Daily;
parameters[21].Value = model.Water_Discharge_Quantity;
parameters[22].Value = model.Production_Waste_Quantity;
parameters[23].Value = model.Sanitary_Waste_Quantity;
parameters[24].Value = model.Temp;
parameters[25].Value = model.pH;
parameters[26].Value = model.SS;
parameters[27].Value = model.BOD5;
parameters[28].Value = model.CODcr;
parameters[29].Value = model.NH3_N;
parameters[30].Value = model.TN;
parameters[31].Value = model.TP;
parameters[32].Value = model.Sunit;
parameters[33].Value = model.Sdate;
parameters[34].Value = model.UpdateTime;
parameters[35].Value = model.Note;
parameters[36].Value = model.Exp_NoOri;
parameters[37].Value = model.FileName;
parameters[38].Value = model.Uploadtime;
parameters[39].Value = model.Exp_No;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
