public PD_PROJECT_BZFFLIST_Model GetModel(string AUTO_NO) { StringBuilder builder = new StringBuilder(); builder.Append("select AUTO_NO,PD_BZFFLIST_DATE,PD_BZFFLIST_COMPANY,PD_BZFFLIST_COUNTRY,PD_BZFFLIST_PEASANT_CODE,PD_BZFFLIST_PEASANT_NAME,PD_BZFFLIST_IDNO,PD_BZFFLIST_FFNUM,PD_BZFFLIST_FFSTAND,PD_BZFFLIST_FFMONEY,PD_BZFFLIST_ACCOUNTNO,PD_BZFFLIST_PEASANT_ADDR from PD_PROJECT_BZFFLIST "); builder.Append(" where AUTO_NO=:AUTO_NO "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Char, 50) }; cmdParms[0].Value = AUTO_NO; PD_PROJECT_BZFFLIST_Model model = new PD_PROJECT_BZFFLIST_Model(); DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } model.AUTO_NO = set.Tables[0].Rows[0]["AUTO_NO"].ToString(); if (set.Tables[0].Rows[0]["PD_BZFFLIST_DATE"].ToString() != "") { model.PD_BZFFLIST_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_BZFFLIST_DATE"].ToString())); } model.PD_BZFFLIST_COMPANY = set.Tables[0].Rows[0]["PD_BZFFLIST_COMPANY"].ToString(); model.PD_BZFFLIST_COUNTRY = set.Tables[0].Rows[0]["PD_BZFFLIST_COUNTRY"].ToString(); model.PD_BZFFLIST_PEASANT_CODE = set.Tables[0].Rows[0]["PD_BZFFLIST_PEASANT_CODE"].ToString(); model.PD_BZFFLIST_PEASANT_NAME = set.Tables[0].Rows[0]["PD_BZFFLIST_PEASANT_NAME"].ToString(); model.PD_BZFFLIST_IDNO = set.Tables[0].Rows[0]["PD_BZFFLIST_IDNO"].ToString(); if (set.Tables[0].Rows[0]["PD_BZFFLIST_FFNUM"].ToString() != "") { model.PD_BZFFLIST_FFNUM = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["PD_BZFFLIST_FFNUM"].ToString())); } if (set.Tables[0].Rows[0]["PD_BZFFLIST_FFSTAND"].ToString() != "") { model.PD_BZFFLIST_FFSTAND = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["PD_BZFFLIST_FFSTAND"].ToString())); } if (set.Tables[0].Rows[0]["PD_BZFFLIST_FFMONEY"].ToString() != "") { model.PD_BZFFLIST_FFMONEY = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["PD_BZFFLIST_FFMONEY"].ToString())); } model.PD_BZFFLIST_ACCOUNTNO = set.Tables[0].Rows[0]["PD_BZFFLIST_ACCOUNTNO"].ToString(); model.PD_BZFFLIST_PEASANT_ADDR = set.Tables[0].Rows[0]["PD_BZFFLIST_PEASANT_ADDR"].ToString(); return model; }
public List<PD_PROJECT_BZFFLIST_Model> DataTableToList(DataTable dt) { List<PD_PROJECT_BZFFLIST_Model> list = new List<PD_PROJECT_BZFFLIST_Model>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PD_PROJECT_BZFFLIST_Model item = new PD_PROJECT_BZFFLIST_Model { AUTO_NO = dt.Rows[i]["AUTO_NO"].ToString() }; if (dt.Rows[i]["PD_BZFFLIST_DATE"].ToString() != "") { item.PD_BZFFLIST_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_BZFFLIST_DATE"].ToString())); } item.PD_BZFFLIST_COMPANY = dt.Rows[i]["PD_BZFFLIST_COMPANY"].ToString(); item.PD_BZFFLIST_COUNTRY = dt.Rows[i]["PD_BZFFLIST_COUNTRY"].ToString(); item.PD_BZFFLIST_PEASANT_CODE = dt.Rows[i]["PD_BZFFLIST_PEASANT_CODE"].ToString(); item.PD_BZFFLIST_PEASANT_NAME = dt.Rows[i]["PD_BZFFLIST_PEASANT_NAME"].ToString(); item.PD_BZFFLIST_IDNO = dt.Rows[i]["PD_BZFFLIST_IDNO"].ToString(); if (dt.Rows[i]["PD_BZFFLIST_FFNUM"].ToString() != "") { item.PD_BZFFLIST_FFNUM = new decimal?(int.Parse(dt.Rows[i]["PD_BZFFLIST_FFNUM"].ToString())); } if (dt.Rows[i]["PD_BZFFLIST_FFSTAND"].ToString() != "") { item.PD_BZFFLIST_FFSTAND = new decimal?(int.Parse(dt.Rows[i]["PD_BZFFLIST_FFSTAND"].ToString())); } if (dt.Rows[i]["PD_BZFFLIST_FFMONEY"].ToString() != "") { item.PD_BZFFLIST_FFMONEY = new decimal?(int.Parse(dt.Rows[i]["PD_BZFFLIST_FFMONEY"].ToString())); } item.PD_BZFFLIST_ACCOUNTNO = dt.Rows[i]["PD_BZFFLIST_ACCOUNTNO"].ToString(); item.PD_BZFFLIST_PEASANT_ADDR = dt.Rows[i]["PD_BZFFLIST_PEASANT_ADDR"].ToString(); list.Add(item); } } return list; }
public void Add(PD_PROJECT_BZFFLIST_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into PD_PROJECT_BZFFLIST("); builder.Append("AUTO_NO,PD_BZFFLIST_DATE,PD_BZFFLIST_COMPANY,PD_BZFFLIST_COUNTRY,PD_BZFFLIST_PEASANT_CODE,PD_BZFFLIST_PEASANT_NAME,PD_BZFFLIST_IDNO,PD_BZFFLIST_FFNUM,PD_BZFFLIST_FFSTAND,PD_BZFFLIST_FFMONEY,PD_BZFFLIST_ACCOUNTNO,PD_BZFFLIST_PEASANT_ADDR)"); builder.Append(" values ("); builder.Append(":AUTO_NO,:PD_BZFFLIST_DATE,:PD_BZFFLIST_COMPANY,:PD_BZFFLIST_COUNTRY,:PD_BZFFLIST_PEASANT_CODE,:PD_BZFFLIST_PEASANT_NAME,:PD_BZFFLIST_IDNO,:PD_BZFFLIST_FFNUM,:PD_BZFFLIST_FFSTAND,:PD_BZFFLIST_FFMONEY,:PD_BZFFLIST_ACCOUNTNO,:PD_BZFFLIST_PEASANT_ADDR)"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Char, 0x24), new OracleParameter(":PD_BZFFLIST_DATE", OracleType.DateTime), new OracleParameter(":PD_BZFFLIST_COMPANY", OracleType.VarChar, 100), new OracleParameter(":PD_BZFFLIST_COUNTRY", OracleType.VarChar, 100), new OracleParameter(":PD_BZFFLIST_PEASANT_CODE", OracleType.VarChar, 100), new OracleParameter(":PD_BZFFLIST_PEASANT_NAME", OracleType.VarChar, 200), new OracleParameter(":PD_BZFFLIST_IDNO", OracleType.VarChar, 50), new OracleParameter(":PD_BZFFLIST_FFNUM", OracleType.Number, 20), new OracleParameter(":PD_BZFFLIST_FFSTAND", OracleType.Number, 20), new OracleParameter(":PD_BZFFLIST_FFMONEY", OracleType.Number, 20), new OracleParameter(":PD_BZFFLIST_ACCOUNTNO", OracleType.VarChar, 100), new OracleParameter(":PD_BZFFLIST_PEASANT_ADDR", OracleType.VarChar, 100) }; cmdParms[0].Value = model.AUTO_NO; cmdParms[1].Value = model.PD_BZFFLIST_DATE; cmdParms[2].Value = model.PD_BZFFLIST_COMPANY; cmdParms[3].Value = model.PD_BZFFLIST_COUNTRY; cmdParms[4].Value = model.PD_BZFFLIST_PEASANT_CODE; cmdParms[5].Value = model.PD_BZFFLIST_PEASANT_NAME; cmdParms[6].Value = model.PD_BZFFLIST_IDNO; cmdParms[7].Value = model.PD_BZFFLIST_FFNUM; cmdParms[8].Value = model.PD_BZFFLIST_FFSTAND; cmdParms[9].Value = model.PD_BZFFLIST_FFMONEY; cmdParms[10].Value = model.PD_BZFFLIST_ACCOUNTNO; cmdParms[11].Value = model.PD_BZFFLIST_PEASANT_ADDR; DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); }
public bool Update(PD_PROJECT_BZFFLIST_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update PD_PROJECT_BZFFLIST set "); builder.Append("PD_BZFFLIST_DATE=:PD_BZFFLIST_DATE,"); builder.Append("PD_BZFFLIST_COMPANY=:PD_BZFFLIST_COMPANY,"); builder.Append("PD_BZFFLIST_COUNTRY=:PD_BZFFLIST_COUNTRY,"); builder.Append("PD_BZFFLIST_PEASANT_CODE=:PD_BZFFLIST_PEASANT_CODE,"); builder.Append("PD_BZFFLIST_PEASANT_NAME=:PD_BZFFLIST_PEASANT_NAME,"); builder.Append("PD_BZFFLIST_IDNO=:PD_BZFFLIST_IDNO,"); builder.Append("PD_BZFFLIST_FFNUM=:PD_BZFFLIST_FFNUM,"); builder.Append("PD_BZFFLIST_FFSTAND=:PD_BZFFLIST_FFSTAND,"); builder.Append("PD_BZFFLIST_FFMONEY=:PD_BZFFLIST_FFMONEY,"); builder.Append("PD_BZFFLIST_ACCOUNTNO=:PD_BZFFLIST_ACCOUNTNO,"); builder.Append("PD_BZFFLIST_PEASANT_ADDR=:PD_BZFFLIST_PEASANT_ADDR"); builder.Append(" where AUTO_NO=:AUTO_NO "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_BZFFLIST_DATE", OracleType.DateTime), new OracleParameter(":PD_BZFFLIST_COMPANY", OracleType.VarChar, 100), new OracleParameter(":PD_BZFFLIST_COUNTRY", OracleType.VarChar, 100), new OracleParameter(":PD_BZFFLIST_PEASANT_CODE", OracleType.VarChar, 100), new OracleParameter(":PD_BZFFLIST_PEASANT_NAME", OracleType.VarChar, 200), new OracleParameter(":PD_BZFFLIST_IDNO", OracleType.VarChar, 50), new OracleParameter(":PD_BZFFLIST_FFNUM", OracleType.Number, 20), new OracleParameter(":PD_BZFFLIST_FFSTAND", OracleType.Number, 20), new OracleParameter(":PD_BZFFLIST_FFMONEY", OracleType.Number, 20), new OracleParameter(":PD_BZFFLIST_ACCOUNTNO", OracleType.VarChar, 100), new OracleParameter(":PD_BZFFLIST_PEASANT_ADDR", OracleType.VarChar, 100), new OracleParameter(":AUTO_NO", OracleType.Char, 0x24) }; cmdParms[0].Value = model.PD_BZFFLIST_DATE; cmdParms[1].Value = model.PD_BZFFLIST_COMPANY; cmdParms[2].Value = model.PD_BZFFLIST_COUNTRY; cmdParms[3].Value = model.PD_BZFFLIST_PEASANT_CODE; cmdParms[4].Value = model.PD_BZFFLIST_PEASANT_NAME; cmdParms[5].Value = model.PD_BZFFLIST_IDNO; cmdParms[6].Value = model.PD_BZFFLIST_FFNUM; cmdParms[7].Value = model.PD_BZFFLIST_FFSTAND; cmdParms[8].Value = model.PD_BZFFLIST_FFMONEY; cmdParms[9].Value = model.PD_BZFFLIST_ACCOUNTNO; cmdParms[10].Value = model.PD_BZFFLIST_PEASANT_ADDR; cmdParms[11].Value = model.AUTO_NO; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }
private PD_PROJECT_BZFFLIST_Model GetModel(PD_PROJECT_BZFFLIST_Model model) { if (model == null) { model = new PD_PROJECT_BZFFLIST_Model(); } string str = ""; if (!PageValidate.IsDateTime(this.txtPD_BZFFLIST_DATE.Text)) { str = str + @"补贴发放时间格式错误!\n"; } if (this.txtPD_BZFFLIST_COMPANY.Text.Trim().Length == 0) { str = str + @"补贴发放单位不能为空!\n"; } if (this.ddlPD_BZFFLIST_COUNTRY.SelectedValue.Trim().Length == 0) { str = str + @"所属乡镇不能为空!\n"; } if (this.txtPD_BZFFLIST_PEASANT_CODE.Text.Trim().Length == 0) { str = str + @"农户代码不能为空!\n"; } if (this.txtPD_BZFFLIST_PEASANT_NAME.Text.Trim().Length == 0) { str = str + @"农户姓名不能为空!\n"; } if (this.txtPD_BZFFLIST_IDNO.Text.Trim().Length == 0) { str = str + @"身份证号码不能为空!\n"; } if (!PageValidate.IsNumber(this.txtPD_BZFFLIST_FFNUM.Text)) { str = str + @"补贴数量格式错误!\n"; } if (!PageValidate.IsNumber(this.txtPD_BZFFLIST_FFSTAND.Text)) { str = str + @"补贴标准格式错误!\n"; } if (!PageValidate.IsNumber(this.txtPD_BZFFLIST_FFMONEY.Text)) { str = str + @"补贴金额格式错误!\n"; } if (this.txtPD_BZFFLIST_ACCOUNTNO.Text.Trim().Length == 0) { str = str + @"发放账号不能为空!\n"; } if (this.txtPD_BZFFLIST_PEASANT_ADDR.Text.Trim().Length == 0) { str = str + @"农户家庭住址不能为空!\n"; } if (str != "") { PageShowText.ShowMessage(str, this.Page); return null; } string text = this.lblAUTO_NO.Text; DateTime time = DateTime.Parse(this.txtPD_BZFFLIST_DATE.Text); string str3 = this.txtPD_BZFFLIST_COMPANY.Text; string selectedValue = this.ddlPD_BZFFLIST_COUNTRY.SelectedValue; string str5 = this.txtPD_BZFFLIST_PEASANT_CODE.Text; string str6 = this.txtPD_BZFFLIST_PEASANT_NAME.Text; string str7 = this.txtPD_BZFFLIST_IDNO.Text; int num = int.Parse(this.txtPD_BZFFLIST_FFNUM.Text); int num2 = int.Parse(this.txtPD_BZFFLIST_FFSTAND.Text); int num3 = int.Parse(this.txtPD_BZFFLIST_FFMONEY.Text); string str8 = this.txtPD_BZFFLIST_ACCOUNTNO.Text; string str9 = this.txtPD_BZFFLIST_PEASANT_ADDR.Text; model.AUTO_NO = text; model.PD_BZFFLIST_DATE = new DateTime?(time); model.PD_BZFFLIST_COMPANY = str3; model.PD_BZFFLIST_COUNTRY = selectedValue; model.PD_BZFFLIST_PEASANT_CODE = str5; model.PD_BZFFLIST_PEASANT_NAME = str6; model.PD_BZFFLIST_IDNO = str7; model.PD_BZFFLIST_FFNUM = new decimal?(num); model.PD_BZFFLIST_FFSTAND = new decimal?(num2); model.PD_BZFFLIST_FFMONEY = new decimal?(num3); model.PD_BZFFLIST_ACCOUNTNO = str8; model.PD_BZFFLIST_PEASANT_ADDR = str9; return model; }
private void CreateData() { PD_PROJECT_BZFFLIST_Bll bll = new PD_PROJECT_BZFFLIST_Bll(); PD_PROJECT_BZFFLIST_Model model = new PD_PROJECT_BZFFLIST_Model(); model = this.GetModel(null); if (model != null) { bll.Add(model); } else { return; } PageShowText.Refurbish("添加成功", this.Page); }
public void Add(PD_PROJECT_BZFFLIST_Model model) { this.dal.Add(model); }
public bool Update(PD_PROJECT_BZFFLIST_Model model) { return this.dal.Update(model); }