public void Add(TB_PROJECT_BZ_Model model) { StringBuilder builder = new StringBuilder(); model.PD_PROJECT_CODE = DateTime.Now.ToString("yyyyMMddhhmmssffffff"); builder.Append("insert into TB_PROJECT("); builder.Append("PD_PROJECT_FILENO_ZB,PD_PROJECT_CODE,PD_PROJECT_NAME,PD_YEAR,PD_PROJECT_TYPE,PD_GK_DEPART,PD_FOUND_XZ,PD_PROJECT_IFGS,PD_PROJECT_IFGS_BEFORE,PD_PROJECT_OPEN_BODY,PD_PROJECT_STATUS,PD_PROJECT_FILENO_JG,PD_PROJECT_INPUT_COMPANY,PD_PROJECT_INPUT_MAN,PD_PROJECT_INPUT_DATE,PD_PROJECT_BZYJ,PD_PROJECT_BZFW,PD_PROJECT_BZDX,PD_PROJECT_BZNUM,PD_PROJECT_BZSTAND_NUM,PD_PROJECT_BZMONEY,PD_PROJECT_BZFF_DATE,PD_PROJECT_SJFF_DATE,PD_PROJECT_IFFF,PD_PROJECT_JGYQ,PD_PROJECT_JGJL,PD_PROJECT_JG_RESULT,PD_PROJECT_SERVERPK)"); builder.Append(" values ("); builder.Append(":PD_PROJECT_FILENO_ZB,:PD_PROJECT_CODE,:PD_PROJECT_NAME,:PD_YEAR,:PD_PROJECT_TYPE,:PD_GK_DEPART,:PD_FOUND_XZ,:PD_PROJECT_IFGS,:PD_PROJECT_IFGS_BEFORE,:PD_PROJECT_OPEN_BODY,:PD_PROJECT_STATUS,:PD_PROJECT_FILENO_JG,:PD_PROJECT_INPUT_COMPANY,:PD_PROJECT_INPUT_MAN,:PD_PROJECT_INPUT_DATE,:PD_PROJECT_BZYJ,:PD_PROJECT_BZFW,:PD_PROJECT_BZDX,:PD_PROJECT_BZNUM,:PD_PROJECT_BZSTAND_NUM,:PD_PROJECT_BZMONEY,:PD_PROJECT_BZFF_DATE,:PD_PROJECT_SJFF_DATE,:PD_PROJECT_IFFF,:PD_PROJECT_JGYQ,:PD_PROJECT_JGJL,:PD_PROJECT_JG_RESULT,:PD_PROJECT_SERVERPK)"); builder.Append(" RETURNING PD_PROJECT_CODE INTO :R_Auto_No "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_FILENO_ZB", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 0x24), new OracleParameter(":PD_PROJECT_NAME", OracleType.VarChar, 100), new OracleParameter(":PD_YEAR", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_TYPE", OracleType.VarChar, 30), new OracleParameter(":PD_GK_DEPART", OracleType.VarChar, 100), new OracleParameter(":PD_FOUND_XZ", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_IFGS", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_IFGS_BEFORE", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_OPEN_BODY", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_STATUS", OracleType.VarChar, 20), new OracleParameter(":PD_PROJECT_FILENO_JG", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_INPUT_COMPANY", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_INPUT_MAN", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_INPUT_DATE", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_BZYJ", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_BZFW", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_BZDX", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_BZNUM", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_BZSTAND_NUM", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_BZMONEY", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_BZFF_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_SJFF_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_IFFF", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_JGYQ", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_JGJL", OracleType.VarChar, 0xfa0), new OracleParameter(":PD_PROJECT_JG_RESULT", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_SERVERPK", OracleType.VarChar, 100), new OracleParameter(":R_Auto_No", OracleType.Number, 20) }; cmdParms[0].Value = model.PD_PROJECT_FILENO_ZB; cmdParms[1].Value = model.PD_PROJECT_CODE; cmdParms[2].Value = model.PD_PROJECT_NAME; cmdParms[3].Value = model.PD_YEAR; cmdParms[4].Value = model.PD_PROJECT_TYPE; cmdParms[5].Value = model.PD_GK_DEPART; cmdParms[6].Value = model.PD_FOUND_XZ; cmdParms[7].Value = model.PD_PROJECT_IFGS; cmdParms[8].Value = model.PD_PROJECT_IFGS_BEFORE; cmdParms[9].Value = model.PD_PROJECT_OPEN_BODY; cmdParms[10].Value = model.PD_PROJECT_STATUS; cmdParms[11].Value = model.PD_PROJECT_FILENO_JG; cmdParms[12].Value = model.PD_PROJECT_INPUT_COMPANY; cmdParms[13].Value = model.PD_PROJECT_INPUT_MAN; cmdParms[14].Value = model.PD_PROJECT_INPUT_DATE; cmdParms[15].Value = model.PD_PROJECT_BZYJ; cmdParms[0x10].Value = model.PD_PROJECT_BZFW; cmdParms[0x11].Value = model.PD_PROJECT_BZDX; cmdParms[0x12].Value = model.PD_PROJECT_BZNUM; cmdParms[0x13].Value = model.PD_PROJECT_BZSTAND_NUM; cmdParms[20].Value = model.PD_PROJECT_BZMONEY; cmdParms[0x15].Value = model.PD_PROJECT_BZFF_DATE; cmdParms[0x16].Value = model.PD_PROJECT_SJFF_DATE; cmdParms[0x17].Value = model.PD_PROJECT_IFFF; cmdParms[0x18].Value = model.PD_PROJECT_JGYQ; cmdParms[0x19].Value = model.PD_PROJECT_JGJL; cmdParms[0x1a].Value = model.PD_PROJECT_JG_RESULT; cmdParms[0x1b].Value = model.PD_PROJECT_SERVERPK; cmdParms[0x1c].Direction = ParameterDirection.Output; DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); model.PD_PROJECT_CODE = cmdParms[0x1c].Value.ToString(); }
private TB_PROJECT_BZ_Model GetModel(TB_PROJECT_BZ_Model model) { if (model == null) { model = new TB_PROJECT_BZ_Model(); this.txtPD_PROJECT_INPUT_COMPANY.Text = ((UserModel)HttpContext.Current.Session["User"]).Company.pk_corp; this.txtPD_PROJECT_INPUT_MAN.Text = ((UserModel)HttpContext.Current.Session["User"]).UserName; } string str = this.txtPD_PROJECT_FILENO_ZB.Value; string text = this.txtPD_PROJECT_NAME.Text; int num = int.Parse(this.ddlPD_YEAR.SelectedValue); string selectedValue = this.ddlPD_PROJECT_TYPE.SelectedValue; string str4 = this.ddlPD_GK_DEPART.SelectedValue; string str5 = this.ddlPD_FOUND_XZ.SelectedValue; if (PublicDal.PageValidate.IsNumber(this.ddlPD_PROJECT_IFGS.SelectedValue)) { model.PD_PROJECT_IFGS = new int?(int.Parse(this.ddlPD_PROJECT_IFGS.SelectedValue)); } if (PublicDal.PageValidate.IsNumber(this.ddlPD_PROJECT_IFGS_BEFORE.SelectedValue)) { model.PD_PROJECT_IFGS_BEFORE = new int?(int.Parse(this.ddlPD_PROJECT_IFGS_BEFORE.SelectedValue)); } string str6 = this.txtPD_PROJECT_OPEN_BODY.Text; string str7 = this.ddlPD_PROJECT_STATUS.SelectedValue; string str8 = this.txtPD_PROJECT_FILENO_JG.Text; string str9 = this.txtPD_PROJECT_BZYJ.Text; string str10 = this.txtPD_PROJECT_BZFW.Text; string str11 = this.txtPD_PROJECT_BZDX.Text; if (PublicDal.PageValidate.IsNumber(this.txtPD_PROJECT_BZNUM.Text)) { model.PD_PROJECT_BZNUM = new decimal?(decimal.Parse(this.txtPD_PROJECT_BZNUM.Text)); } model.PD_PROJECT_BZSTAND_NUM = this.txtPD_PROJECT_BZSTAND_NUM.Text; if (PublicDal.PageValidate.IsDecimal(this.txtPD_PROJECT_BZMONEY.Text)) { model.PD_PROJECT_BZMONEY = new decimal?(decimal.Parse(this.txtPD_PROJECT_BZMONEY.Text)); } if (PublicDal.PageValidate.IsDateTime(this.txtPD_PROJECT_BZFF_DATE.Text)) { model.PD_PROJECT_BZFF_DATE = new DateTime?(DateTime.Parse(this.txtPD_PROJECT_BZFF_DATE.Text)); } if (PublicDal.PageValidate.IsDateTime(this.txtPD_PROJECT_SJFF_DATE.Text)) { model.PD_PROJECT_SJFF_DATE = new DateTime?(DateTime.Parse(this.txtPD_PROJECT_SJFF_DATE.Text)); } if (PublicDal.PageValidate.IsNumber(this.ddlPD_PROJECT_IFFF.SelectedValue)) { model.PD_PROJECT_IFFF = new int?(int.Parse(this.ddlPD_PROJECT_IFFF.SelectedValue)); } string str12 = this.txtPD_PROJECT_JGYQ.Text; string str13 = this.txtPD_PROJECT_JGJL.Text; string str14 = this.txtPD_PROJECT_JG_RESULT.Text; model.PD_PROJECT_FILENO_ZB = str; model.PD_PROJECT_NAME = text; model.PD_YEAR = new int?(num); model.PD_PROJECT_TYPE = selectedValue; model.PD_GK_DEPART = str4; model.PD_FOUND_XZ = str5; model.PD_PROJECT_OPEN_BODY = str6; model.PD_PROJECT_STATUS = str7; model.PD_PROJECT_FILENO_JG = str8; model.PD_PROJECT_BZYJ = str9; model.PD_PROJECT_BZFW = str10; model.PD_PROJECT_BZDX = str11; model.PD_PROJECT_JGYQ = str12; model.PD_PROJECT_JGJL = str13; model.PD_PROJECT_JG_RESULT = str14; model.PD_PROJECT_INPUT_DATE = DateTime.Now.ToString("yyyy-MM-dd"); model.PD_PROJECT_INPUT_COMPANY = ((UserModel)this.Session["User"]).Company.pk_corp; model.PD_PROJECT_INPUT_MAN = ((UserModel)this.Session["User"]).UserName; return model; }
public bool Update(TB_PROJECT_BZ_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update TB_PROJECT set "); builder.Append("PD_PROJECT_FILENO_ZB=:PD_PROJECT_FILENO_ZB,"); builder.Append("PD_PROJECT_NAME=:PD_PROJECT_NAME,"); builder.Append("PD_YEAR=:PD_YEAR,"); builder.Append("PD_PROJECT_TYPE=:PD_PROJECT_TYPE,"); builder.Append("PD_GK_DEPART=:PD_GK_DEPART,"); builder.Append("PD_FOUND_XZ=:PD_FOUND_XZ,"); builder.Append("PD_PROJECT_IFGS=:PD_PROJECT_IFGS,"); builder.Append("PD_PROJECT_IFGS_BEFORE=:PD_PROJECT_IFGS_BEFORE,"); builder.Append("PD_PROJECT_OPEN_BODY=:PD_PROJECT_OPEN_BODY,"); builder.Append("PD_PROJECT_STATUS=:PD_PROJECT_STATUS,"); builder.Append("PD_PROJECT_FILENO_JG=:PD_PROJECT_FILENO_JG,"); builder.Append("PD_PROJECT_INPUT_COMPANY=:PD_PROJECT_INPUT_COMPANY,"); builder.Append("PD_PROJECT_INPUT_MAN=:PD_PROJECT_INPUT_MAN,"); builder.Append("PD_PROJECT_INPUT_DATE=:PD_PROJECT_INPUT_DATE,"); builder.Append("PD_PROJECT_BZYJ=:PD_PROJECT_BZYJ,"); builder.Append("PD_PROJECT_BZFW=:PD_PROJECT_BZFW,"); builder.Append("PD_PROJECT_BZDX=:PD_PROJECT_BZDX,"); builder.Append("PD_PROJECT_BZNUM=:PD_PROJECT_BZNUM,"); builder.Append("PD_PROJECT_BZSTAND_NUM=:PD_PROJECT_BZSTAND_NUM,"); builder.Append("PD_PROJECT_BZMONEY=:PD_PROJECT_BZMONEY,"); builder.Append("PD_PROJECT_BZFF_DATE=:PD_PROJECT_BZFF_DATE,"); builder.Append("PD_PROJECT_SJFF_DATE=:PD_PROJECT_SJFF_DATE,"); builder.Append("PD_PROJECT_IFFF=:PD_PROJECT_IFFF,"); builder.Append("PD_PROJECT_JGYQ=:PD_PROJECT_JGYQ,"); builder.Append("PD_PROJECT_JGJL=:PD_PROJECT_JGJL,"); builder.Append("PD_PROJECT_JG_RESULT=:PD_PROJECT_JG_RESULT"); builder.Append(" where PD_PROJECT_CODE=:PD_PROJECT_CODE "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_FILENO_ZB", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_NAME", OracleType.VarChar, 100), new OracleParameter(":PD_YEAR", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_TYPE", OracleType.VarChar, 30), new OracleParameter(":PD_GK_DEPART", OracleType.VarChar, 100), new OracleParameter(":PD_FOUND_XZ", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_IFGS", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_IFGS_BEFORE", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_OPEN_BODY", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_STATUS", OracleType.VarChar, 20), new OracleParameter(":PD_PROJECT_FILENO_JG", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_INPUT_COMPANY", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_INPUT_MAN", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_INPUT_DATE", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_BZYJ", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_BZFW", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_BZDX", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_BZNUM", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_BZSTAND_NUM", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_BZMONEY", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_BZFF_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_SJFF_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_IFFF", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_JGYQ", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_JGJL", OracleType.VarChar, 0xfa0), new OracleParameter(":PD_PROJECT_JG_RESULT", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 0x24) }; cmdParms[0].Value = model.PD_PROJECT_FILENO_ZB; cmdParms[1].Value = model.PD_PROJECT_NAME; cmdParms[2].Value = model.PD_YEAR; cmdParms[3].Value = model.PD_PROJECT_TYPE; cmdParms[4].Value = model.PD_GK_DEPART; cmdParms[5].Value = model.PD_FOUND_XZ; cmdParms[6].Value = model.PD_PROJECT_IFGS; cmdParms[7].Value = model.PD_PROJECT_IFGS_BEFORE; cmdParms[8].Value = model.PD_PROJECT_OPEN_BODY; cmdParms[9].Value = model.PD_PROJECT_STATUS; cmdParms[10].Value = model.PD_PROJECT_FILENO_JG; cmdParms[11].Value = model.PD_PROJECT_INPUT_COMPANY; cmdParms[12].Value = model.PD_PROJECT_INPUT_MAN; cmdParms[13].Value = model.PD_PROJECT_INPUT_DATE; cmdParms[14].Value = model.PD_PROJECT_BZYJ; cmdParms[15].Value = model.PD_PROJECT_BZFW; cmdParms[0x10].Value = model.PD_PROJECT_BZDX; cmdParms[0x11].Value = model.PD_PROJECT_BZNUM; cmdParms[0x12].Value = model.PD_PROJECT_BZSTAND_NUM; cmdParms[0x13].Value = model.PD_PROJECT_BZMONEY; cmdParms[20].Value = model.PD_PROJECT_BZFF_DATE; cmdParms[0x15].Value = model.PD_PROJECT_SJFF_DATE; cmdParms[0x16].Value = model.PD_PROJECT_IFFF; cmdParms[0x17].Value = model.PD_PROJECT_JGYQ; cmdParms[0x18].Value = model.PD_PROJECT_JGJL; cmdParms[0x19].Value = model.PD_PROJECT_JG_RESULT; cmdParms[0x1a].Value = model.PD_PROJECT_CODE; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public TB_PROJECT_BZ_Model GetModelName(string PD_PROJECT_CODE) { StringBuilder builder = new StringBuilder(); builder.Append("select op.ShowText PD_PROJECT_FILENO_ZB,PD_PROJECT_FILENO_ZB PD_PROJECT_FILENO_ZB_CODE,PD_PROJECT_CODE,PD_PROJECT_NAME,PD_YEAR,PD_PROJECT_TYPE,PD_GK_DEPART,PD_FOUND_XZ,PD_PROJECT_IFGS,PD_PROJECT_IFGS_BEFORE,PD_PROJECT_OPEN_BODY,PD_PROJECT_STATUS,PD_PROJECT_FILENO_JG,PD_PROJECT_INPUT_COMPANY,PD_PROJECT_INPUT_MAN,PD_PROJECT_INPUT_DATE,PD_PROJECT_BZYJ,PD_PROJECT_BZFW,PD_PROJECT_BZDX,PD_PROJECT_BZNUM,PD_PROJECT_BZSTAND_NUM,PD_PROJECT_BZMONEY,PD_PROJECT_BZFF_DATE,PD_PROJECT_SJFF_DATE,PD_PROJECT_IFFF,PD_PROJECT_JGYQ,PD_PROJECT_JGJL,PD_PROJECT_JG_RESULT"); builder.Append(" from TB_PROJECT t"); builder.Append(" left join open_pd_quotaaddmoney op on trim(op.pd_quota_code)=trim(t.PD_PROJECT_FILENO_ZB) "); builder.Append(" where t.PD_PROJECT_CODE=:PD_PROJECT_CODE "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 50) }; cmdParms[0].Value = PD_PROJECT_CODE; TB_PROJECT_BZ_Model model = new TB_PROJECT_BZ_Model(); DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } model.PD_PROJECT_FILENO_ZB = set.Tables[0].Rows[0]["PD_PROJECT_FILENO_ZB"].ToString(); model.PD_PROJECT_FILENO_ZB_CODE = set.Tables[0].Rows[0]["PD_PROJECT_FILENO_ZB_CODE"].ToString(); model.PD_PROJECT_CODE = set.Tables[0].Rows[0]["PD_PROJECT_CODE"].ToString(); model.PD_PROJECT_NAME = set.Tables[0].Rows[0]["PD_PROJECT_NAME"].ToString(); if (set.Tables[0].Rows[0]["PD_YEAR"].ToString() != "") { model.PD_YEAR = new int?(int.Parse(set.Tables[0].Rows[0]["PD_YEAR"].ToString())); } model.PD_PROJECT_TYPE = set.Tables[0].Rows[0]["PD_PROJECT_TYPE"].ToString(); model.PD_GK_DEPART = set.Tables[0].Rows[0]["PD_GK_DEPART"].ToString(); model.PD_FOUND_XZ = set.Tables[0].Rows[0]["PD_FOUND_XZ"].ToString(); if (set.Tables[0].Rows[0]["PD_PROJECT_IFGS"].ToString() != "") { model.PD_PROJECT_IFGS = new int?(int.Parse(set.Tables[0].Rows[0]["PD_PROJECT_IFGS"].ToString())); } if (set.Tables[0].Rows[0]["PD_PROJECT_IFGS_BEFORE"].ToString() != "") { model.PD_PROJECT_IFGS_BEFORE = new int?(int.Parse(set.Tables[0].Rows[0]["PD_PROJECT_IFGS_BEFORE"].ToString())); } model.PD_PROJECT_OPEN_BODY = set.Tables[0].Rows[0]["PD_PROJECT_OPEN_BODY"].ToString(); model.PD_PROJECT_STATUS = set.Tables[0].Rows[0]["PD_PROJECT_STATUS"].ToString(); model.PD_PROJECT_FILENO_JG = set.Tables[0].Rows[0]["PD_PROJECT_FILENO_JG"].ToString(); model.PD_PROJECT_INPUT_COMPANY = set.Tables[0].Rows[0]["PD_PROJECT_INPUT_COMPANY"].ToString(); model.PD_PROJECT_INPUT_MAN = set.Tables[0].Rows[0]["PD_PROJECT_INPUT_MAN"].ToString(); model.PD_PROJECT_INPUT_DATE = set.Tables[0].Rows[0]["PD_PROJECT_INPUT_DATE"].ToString(); model.PD_PROJECT_BZYJ = set.Tables[0].Rows[0]["PD_PROJECT_BZYJ"].ToString(); model.PD_PROJECT_BZFW = set.Tables[0].Rows[0]["PD_PROJECT_BZFW"].ToString(); model.PD_PROJECT_BZDX = set.Tables[0].Rows[0]["PD_PROJECT_BZDX"].ToString(); if (set.Tables[0].Rows[0]["PD_PROJECT_BZNUM"].ToString() != "") { model.PD_PROJECT_BZNUM = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["PD_PROJECT_BZNUM"].ToString())); } model.PD_PROJECT_BZSTAND_NUM = set.Tables[0].Rows[0]["PD_PROJECT_BZSTAND_NUM"].ToString(); if (set.Tables[0].Rows[0]["PD_PROJECT_BZMONEY"].ToString() != "") { model.PD_PROJECT_BZMONEY = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["PD_PROJECT_BZMONEY"].ToString())); } if (set.Tables[0].Rows[0]["PD_PROJECT_BZFF_DATE"].ToString() != "") { model.PD_PROJECT_BZFF_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_PROJECT_BZFF_DATE"].ToString())); } if (set.Tables[0].Rows[0]["PD_PROJECT_SJFF_DATE"].ToString() != "") { model.PD_PROJECT_SJFF_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_PROJECT_SJFF_DATE"].ToString())); } if (set.Tables[0].Rows[0]["PD_PROJECT_IFFF"].ToString() != "") { model.PD_PROJECT_IFFF = new int?(int.Parse(set.Tables[0].Rows[0]["PD_PROJECT_IFFF"].ToString())); } model.PD_PROJECT_JGYQ = set.Tables[0].Rows[0]["PD_PROJECT_JGYQ"].ToString(); model.PD_PROJECT_JGJL = set.Tables[0].Rows[0]["PD_PROJECT_JGJL"].ToString(); model.PD_PROJECT_JG_RESULT = set.Tables[0].Rows[0]["PD_PROJECT_JG_RESULT"].ToString(); return model; }
public List<TB_PROJECT_BZ_Model> DataTableToList(DataTable dt) { List<TB_PROJECT_BZ_Model> list = new List<TB_PROJECT_BZ_Model>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { TB_PROJECT_BZ_Model item = new TB_PROJECT_BZ_Model { PD_PROJECT_FILENO_ZB = dt.Rows[i]["PD_PROJECT_FILENO_ZB"].ToString(), PD_PROJECT_CODE = dt.Rows[i]["PD_PROJECT_CODE"].ToString(), PD_PROJECT_NAME = dt.Rows[i]["PD_PROJECT_NAME"].ToString() }; if (dt.Rows[i]["PD_YEAR"].ToString() != "") { item.PD_YEAR = new int?(int.Parse(dt.Rows[i]["PD_YEAR"].ToString())); } item.PD_PROJECT_TYPE = dt.Rows[i]["PD_PROJECT_TYPE"].ToString(); item.PD_GK_DEPART = dt.Rows[i]["PD_GK_DEPART"].ToString(); item.PD_FOUND_XZ = dt.Rows[i]["PD_FOUND_XZ"].ToString(); if (dt.Rows[i]["PD_PROJECT_IFGS"].ToString() != "") { item.PD_PROJECT_IFGS = new int?(int.Parse(dt.Rows[i]["PD_PROJECT_IFGS"].ToString())); } if (dt.Rows[i]["PD_PROJECT_IFGS_BEFORE"].ToString() != "") { item.PD_PROJECT_IFGS_BEFORE = new int?(int.Parse(dt.Rows[i]["PD_PROJECT_IFGS_BEFORE"].ToString())); } item.PD_PROJECT_OPEN_BODY = dt.Rows[i]["PD_PROJECT_OPEN_BODY"].ToString(); item.PD_PROJECT_STATUS = dt.Rows[i]["PD_PROJECT_STATUS"].ToString(); item.PD_PROJECT_FILENO_JG = dt.Rows[i]["PD_PROJECT_FILENO_JG"].ToString(); item.PD_PROJECT_INPUT_COMPANY = dt.Rows[i]["PD_PROJECT_INPUT_COMPANY"].ToString(); item.PD_PROJECT_INPUT_MAN = dt.Rows[i]["PD_PROJECT_INPUT_MAN"].ToString(); item.PD_PROJECT_INPUT_DATE = dt.Rows[i]["PD_PROJECT_INPUT_DATE"].ToString(); item.PD_PROJECT_BZYJ = dt.Rows[i]["PD_PROJECT_BZYJ"].ToString(); item.PD_PROJECT_BZFW = dt.Rows[i]["PD_PROJECT_BZFW"].ToString(); item.PD_PROJECT_BZDX = dt.Rows[i]["PD_PROJECT_BZDX"].ToString(); if (dt.Rows[i]["PD_PROJECT_BZNUM"].ToString() != "") { item.PD_PROJECT_BZNUM = new decimal?(decimal.Parse(dt.Rows[i]["PD_PROJECT_BZNUM"].ToString())); } item.PD_PROJECT_BZSTAND_NUM = dt.Rows[i]["PD_PROJECT_BZSTAND_NUM"].ToString(); if (dt.Rows[i]["PD_PROJECT_BZMONEY"].ToString() != "") { item.PD_PROJECT_BZMONEY = new decimal?(decimal.Parse(dt.Rows[i]["PD_PROJECT_BZMONEY"].ToString())); } if (dt.Rows[i]["PD_PROJECT_BZFF_DATE"].ToString() != "") { item.PD_PROJECT_BZFF_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_PROJECT_BZFF_DATE"].ToString())); } if (dt.Rows[i]["PD_PROJECT_SJFF_DATE"].ToString() != "") { item.PD_PROJECT_SJFF_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_PROJECT_SJFF_DATE"].ToString())); } if (dt.Rows[i]["PD_PROJECT_IFFF"].ToString() != "") { item.PD_PROJECT_IFFF = new int?(int.Parse(dt.Rows[i]["PD_PROJECT_IFFF"].ToString())); } item.PD_PROJECT_JGYQ = dt.Rows[i]["PD_PROJECT_JGYQ"].ToString(); item.PD_PROJECT_JGJL = dt.Rows[i]["PD_PROJECT_JGJL"].ToString(); item.PD_PROJECT_JG_RESULT = dt.Rows[i]["PD_PROJECT_JG_RESULT"].ToString(); list.Add(item); } } return list; }
public void Add(TB_PROJECT_BZ_Model model) { this.dal.Add(model); }
public bool Update(TB_PROJECT_BZ_Model model) { return this.dal.Update(model); }