public List<PD_FOUND_OUT_Model> DataTableToList(DataTable dt) { List<PD_FOUND_OUT_Model> list = new List<PD_FOUND_OUT_Model>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PD_FOUND_OUT_Model item = new PD_FOUND_OUT_Model(); if (dt.Rows[i]["AUTO_NO"].ToString() != "") { item.AUTO_NO = int.Parse(dt.Rows[i]["AUTO_NO"].ToString()); } if (dt.Rows[i]["PD_YEAR"].ToString() != "") { item.PD_YEAR = new int?(int.Parse(dt.Rows[i]["PD_YEAR"].ToString())); } if (dt.Rows[i]["PD_FOUND_DATE"].ToString() != "") { item.PD_FOUND_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_FOUND_DATE"].ToString())); } if (dt.Rows[i]["PD_IF_HAVE"].ToString() != "") { item.PD_IF_HAVE = new int?(int.Parse(dt.Rows[i]["PD_IF_HAVE"].ToString())); } item.PD_PROJECT_CODE = dt.Rows[i]["PD_PROJECT_CODE"].ToString(); item.PD_PROJECT_NAME = dt.Rows[i]["PD_PROJECT_NAME"].ToString(); item.PD_CONTRACT_TYPE = dt.Rows[i]["PD_CONTRACT_TYPE"].ToString(); item.PD_CONTRACT_COMPANY = dt.Rows[i]["PD_CONTRACT_COMPANY"].ToString(); item.PD_FOUND_COMPANY = dt.Rows[i]["PD_FOUND_COMPANY"].ToString(); if (dt.Rows[i]["PD_CONTRACT_MONEY"].ToString() != "") { item.PD_CONTRACT_MONEY = new decimal?(int.Parse(dt.Rows[i]["PD_CONTRACT_MONEY"].ToString())); } item.PD_FOUND_SOURCES = dt.Rows[i]["资金来源"].ToString(); item.PD_FOUND_TYPE = dt.Rows[i]["PD_FOUND_TYPE"].ToString(); item.PD_FOUND_STYLE = dt.Rows[i]["PD_FOUND_STYLE"].ToString(); item.PD_FOUND_ACC_TYPE = dt.Rows[i]["PD_FOUND_ACC_TYPE"].ToString(); item.PD_FOUND_VOUNO = dt.Rows[i]["PD_FOUND_VOUNO"].ToString(); if (dt.Rows[i]["PD_FOUND_MONEY"].ToString() != "") { item.PD_FOUND_MONEY = new decimal?(int.Parse(dt.Rows[i]["PD_FOUND_MONEY"].ToString())); } if (dt.Rows[i]["PD_FOUND_MONEY_TOTAL"].ToString() != "") { item.PD_FOUND_MONEY_TOTAL = new decimal?(int.Parse(dt.Rows[i]["PD_FOUND_MONEY_TOTAL"].ToString())); } item.PD_FOUND_MONEY_WCL = dt.Rows[i]["PD_FOUND_MONEY_WCL"].ToString(); item.PD_FOUND_FILENAME = dt.Rows[i]["PD_FOUND_FILENAME"].ToString(); item.PD_FOUND_SYS_FILENAME = dt.Rows[i]["PD_FOUND_SYS_FILENAME"].ToString(); item.PD_PROJ_STATUS = dt.Rows[i]["PD_PROJ_STATUS"].ToString(); item.PD_PROJ_LAST_AUDIT_STATUS = dt.Rows[i]["PD_PROJ_LAST_AUDIT_STATUS"].ToString(); if (dt.Rows[i]["PD_IS_RETURN"].ToString() != "") { item.PD_IS_RETURN = new int?(int.Parse(dt.Rows[i]["PD_IS_RETURN"].ToString())); } list.Add(item); } } return list; }
public bool Update(PD_FOUND_OUT_Model model) { return this.dal.Update(model); }
public void Add(PD_FOUND_OUT_Model model) { this.dal.Add(model); }
private PD_FOUND_OUT_Model GetModel(PD_FOUND_OUT_Model model) { if (model == null) { model = new PD_FOUND_OUT_Model(); PD_FOUND_OUT_Bll bll = new PD_FOUND_OUT_Bll(); decimal num = bll.getProjectJSZJE(this.txtPD_PROJECT_CODE.Text); DateTime? nullable = null; if (PublicDal.PageValidate.IsDateTime(this.txtPD_FOUND_DATE.Text)) { nullable = new DateTime?(DateTime.Parse(this.txtPD_FOUND_DATE.Text)); } decimal num2 = bll.getLJMoney(this.txtPD_PROJECT_CODE.Text, -1L, nullable) + decimal.Parse(this.txtPD_FOUND_MONEY.Text); model.PD_FOUND_MONEY_TOTAL = new decimal?(num2); model.PD_FOUND_MONEY_WCL = ((model.PD_FOUND_MONEY_TOTAL.Value / num) * 100M).ToString("0.00"); } else { PD_FOUND_OUT_Bll bll2 = new PD_FOUND_OUT_Bll(); decimal num3 = bll2.getProjectJSZJE(this.txtPD_PROJECT_CODE.Text); DateTime? nullable2 = null; if (PublicDal.PageValidate.IsDateTime(this.txtPD_FOUND_DATE.Text)) { nullable2 = new DateTime?(DateTime.Parse(this.txtPD_FOUND_DATE.Text)); } decimal num4 = bll2.getLJMoney(this.txtPD_PROJECT_CODE.Text, model.AUTO_NO, nullable2) + decimal.Parse(this.txtPD_FOUND_MONEY.Text); model.PD_FOUND_MONEY_TOTAL = new decimal?(num4); model.PD_FOUND_MONEY_WCL = ((model.PD_FOUND_MONEY_TOTAL.Value / num3) * 100M).ToString("0.00"); } if (PublicDal.PageValidate.IsInt(this.ddlPD_YEAR.SelectedValue)) { model.PD_YEAR = new int?(int.Parse(this.ddlPD_YEAR.SelectedValue)); } if (PublicDal.PageValidate.IsInt(this.ddlmonth.SelectedValue)) { model.PD_PZ_MONTH = new int?(int.Parse(this.ddlmonth.SelectedValue)); } if (PublicDal.PageValidate.IsDateTime(this.txtPD_FOUND_DATE.Text)) { model.PD_FOUND_DATE = new DateTime?(DateTime.Parse(this.txtPD_FOUND_DATE.Text)); } if (PublicDal.PageValidate.IsInt(this.ddlPD_IF_HAVE.SelectedValue)) { model.PD_IF_HAVE = new int?(int.Parse(this.ddlPD_IF_HAVE.SelectedValue)); } model.PD_PROJECT_CODE = this.txtPD_PROJECT_CODE.Text; model.PD_PROJECT_NAME = this.txtPD_PROJECT_NAME.Text; model.PD_CONTRACT_COMPANY = this.txtPD_CONTRACT_COMPANY.Text; model.PD_FOUND_COMPANY = this.txtPD_FOUND_COMPANY.Text; if (PublicDal.PageValidate.IsDecimal(this.txtPD_CONTRACT_MONEY.Text)) { model.PD_CONTRACT_MONEY = new decimal?(decimal.Parse(this.txtPD_CONTRACT_MONEY.Text)); } model.PD_FOUND_SOURCES = this.ddlPD_FOUND_SOURCES.SelectedValue; model.PD_FOUND_TYPE = this.ddlPD_FOUND_TYPE.SelectedValue; model.PD_FOUND_STYLE = this.ddlPD_FOUND_STYLE.SelectedValue; model.PD_FOUND_ACC_TYPE = this.txtPD_FOUND_ACC_TYPE.Text; model.PD_FOUND_VOUNO = this.txtPD_FOUND_VOUNO.Text; if (PublicDal.PageValidate.IsDecimal(this.txtPD_FOUND_MONEY.Text)) { model.PD_FOUND_MONEY = new decimal?(decimal.Parse(this.txtPD_FOUND_MONEY.Text)); } model.PD_FOUND_FILENAME = this.txtPD_FOUND_FILENAME.Text; model.PD_FOUND_SYS_FILENAME = this.txtPD_FOUND_SYS_FILENAME.Text; model.PD_PROJECT_CONTRACT = this.txtPD_PROJECT_CONTRACT.Text; model.PD_CONTRACT_TYPE = this.ddlPD_CONTRACT_TYPE.SelectedValue; model.PD_CONTRACT_NO = this.txtPD_PROJECT_CONTRACT.Text; model.PD_PZ_YEAR = new int?(int.Parse(this.ddlyear.SelectedValue)); return model; }