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);
}
