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;
}
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>
/// <returns></returns>
private void DeletePointRealeatTables()
{
Maticsoft.BLL.cjplp cjplpBLL = new Maticsoft.BLL.cjplp();
Maticsoft.BLL.ps_comb ps_combBLL = new Maticsoft.BLL.ps_comb();
Maticsoft.BLL.ps_discharger ps_dischargerBLL = new Maticsoft.BLL.ps_discharger();
Maticsoft.BLL.ps_gate ps_gateBLL = new Maticsoft.BLL.ps_gate();
Maticsoft.BLL.ps_manhole ps_manholeBLL = new Maticsoft.BLL.ps_manhole();
Maticsoft.BLL.ps_outfall ps_outfallBLL = new Maticsoft.BLL.ps_outfall();
Maticsoft.BLL.ps_point ps_pointBLL = new Maticsoft.BLL.ps_point();
Maticsoft.BLL.ps_pumpstation ps_pumpstationBLL = new Maticsoft.BLL.ps_pumpstation();
Maticsoft.BLL.ps_retention ps_retentionBLL = new Maticsoft.BLL.ps_retention();
Maticsoft.BLL.ps_valve ps_valveBLL = new Maticsoft.BLL.ps_valve();
Maticsoft.BLL.ps_weir ps_weirBLL = new Maticsoft.BLL.ps_weir();
Maticsoft.BLL.ps_wwtp ps_wwtpBLL = new Maticsoft.BLL.ps_wwtp();
//删除选择的内容
if (this.listBoxControlDeleteBlock.Items.Count > 0)
{
//构造sql查询语句
string strWhere = String.Empty;
;
for (int i = 0; i < listBoxControlDeleteBlock.Items.Count; i++)
{
if (i == listBoxControlDeleteBlock.Items.Count - 1)
{
strWhere += "FileName='" + listBoxControlDeleteBlock.Items[i].ToString() + "'";
}
else
{
strWhere += "FileName='" + listBoxControlDeleteBlock.Items[i].ToString() + "' or";
}
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.cjplp> deleteCjplpsModelList = cjplpBLL.GetModelList(strWhere);
for (int j = 0; j < deleteCjplpsModelList.Count; j++)
{
cjplpBLL.Delete(deleteCjplpsModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_comb> deleteps_combModelList = ps_combBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_combModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_combModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_discharger> deleteps_dischargerModelList = ps_dischargerBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_dischargerModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_dischargerModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_gate> deleteps_gateModelList = ps_gateBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_gateModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_gateModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_manhole> deleteps_manholeModelList = ps_manholeBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_manholeModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_manholeModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_outfall> deleteps_outfallModelList = ps_outfallBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_outfallModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_outfallModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_point> deleteps_pointModelList = ps_pointBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_pointModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_pointModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_pumpstation> deleteps_pumpstationModelList = ps_pumpstationBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_pumpstationModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_pumpstationModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_retention> deleteps_retentionModelList = ps_retentionBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_retentionModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_retentionModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_valve> deleteps_valveModelList = ps_valveBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_valveModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_valveModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_weir> deleteps_weirModelList = ps_weirBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_weirModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_weirModelList[j].Exp_NoOri);
}
//删除cjplp原始数据库的点
List <Maticsoft.Model.ps_wwtp> deleteps_wwtpModelList = ps_wwtpBLL.GetModelList(strWhere);
for (int j = 0; j < deleteps_wwtpModelList.Count; j++)
{
cjplpBLL.Delete(deleteps_wwtpModelList[j].Exp_NoOri);
}
//同步编码表
// AsynData.asynRecordTabl();
}
// return cjplpBLL;
}
