public List<PD_PROJECT_APPRAISE_Model> DataTableToList(DataTable dt) { List<PD_PROJECT_APPRAISE_Model> list = new List<PD_PROJECT_APPRAISE_Model>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PD_PROJECT_APPRAISE_Model item = new PD_PROJECT_APPRAISE_Model(); if (dt.Rows[i]["AUTO_NO"].ToString() != "") { item.AUTO_NO = int.Parse(dt.Rows[i]["AUTO_NO"].ToString()); } item.PD_PROJECT_CODE = dt.Rows[i]["PD_PROJECT_CODE"].ToString(); if (dt.Rows[i]["PD_PROJECT_APP_DATE"].ToString() != "") { item.PD_PROJECT_APP_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_PROJECT_APP_DATE"].ToString())); } item.PD_PROJECT_APP_COMPANY = dt.Rows[i]["PD_PROJECT_APP_COMPANY"].ToString(); item.PD_PROJECT_APP_COMPANY_LIST = dt.Rows[i]["PD_PROJECT_APP_COMPANY_LIST"].ToString(); item.PD_PROJECT_APP_MAN_LIST = dt.Rows[i]["PD_PROJECT_APP_MAN_LIST"].ToString(); item.PD_PROJECT_APPRAISE_FILENO = dt.Rows[i]["PD_PROJECT_APPRAISE_FILENO"].ToString(); list.Add(item); } } return list; }
public void Add(PD_PROJECT_APPRAISE_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into PD_PROJECT_APPRAISE("); builder.Append("AUTO_NO,PD_PROJECT_CODE,PD_PROJECT_APP_DATE,PD_PROJECT_APP_COMPANY,PD_PROJECT_APP_COMPANY_LIST,PD_PROJECT_APP_MAN_LIST,PD_PROJECT_APPRAISE_FILENO)"); builder.Append(" values ("); builder.Append(":AUTO_NO,:PD_PROJECT_CODE,:PD_PROJECT_APP_DATE,:PD_PROJECT_APP_COMPANY,:PD_PROJECT_APP_COMPANY_LIST,:PD_PROJECT_APP_MAN_LIST,:PD_PROJECT_APPRAISE_FILENO)"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30), new OracleParameter(":PD_PROJECT_APP_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_APP_COMPANY", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_APP_COMPANY_LIST", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_APP_MAN_LIST", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_APPRAISE_FILENO", OracleType.VarChar, 100) }; cmdParms[0].Value = model.AUTO_NO; cmdParms[1].Value = model.PD_PROJECT_CODE; cmdParms[2].Value = model.PD_PROJECT_APP_DATE; cmdParms[3].Value = model.PD_PROJECT_APP_COMPANY; cmdParms[4].Value = model.PD_PROJECT_APP_COMPANY_LIST; cmdParms[5].Value = model.PD_PROJECT_APP_MAN_LIST; cmdParms[6].Value = model.PD_PROJECT_APPRAISE_FILENO; DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); }
private void UpdateDateJGYS(string PD_OROHECT_CODE) { string strErr = ""; if (!this.Panduan_JGYS(ref strErr)) { this.hy_File(null, strErr); } else { string text = this.lblPD_PROJECT_CODE.Text; DateTime time = DateTime.Parse(this.txtPD_PROJECT_COMPLETE_DATE.Value); DateTime time2 = DateTime.Parse(this.txtPD_PROJECT_YSSQ_DATE.Value); DateTime time3 = DateTime.Parse(this.txtPD_PROJECT_YS_DATE.Value); string selectedValue = this.ddlPD_PROJECT_YS_COMPANY.SelectedValue; string str4 = this.txtPD_PROJECT_YS_ZRR.Text; string str5 = this.txtPD_PROJECT_YS_NAME.Text; string str6 = this.txtPD_PROJECT_YS_SUGGEST.Text; string str7 = this.ddlPD_PROJECT_YS_RESULT.SelectedItem.Text; string str8 = this.txtPD_PROJECT_YS_CONDITION.Text; PD_PROJECT_JGYS_Model model = new PD_PROJECT_JGYS_Model { PD_PROJECT_CODE = text, PD_PROJECT_COMPLETE_DATE = new DateTime?(time), PD_PROJECT_YSSQ_DATE = new DateTime?(time2), PD_PROJECT_YS_DATE = new DateTime?(time3), PD_PROJECT_YS_COMPANY = selectedValue, PD_PROJECT_YS_ZRR = str4, PD_PROJECT_YS_NAME = str5, PD_PROJECT_YS_SUGGEST = str6, PD_PROJECT_YS_RESULT = str7, PD_PROJECT_YS_CONDITION = str8 }; PD_PROJECT_APPRAISE_Model model2 = new PD_PROJECT_APPRAISE_Model(); string str9 = this.txtAUTO_NO_APPRAISE.Text; string str10 = this.txtPD_PROJECT_APP_COMPANY.Text; string str11 = this.txtPD_PROJECT_APP_COMPANY_LIST.Text; string str12 = this.txtPD_PROJECT_APP_MAN_LIST.Text; string str13 = this.txtPD_PROJECT_APPRAISE_FILENO.Text; if (!PublicDal.PageValidate.IsNumber(str9)) { str9 = "-1"; } model2.AUTO_NO = int.Parse(str9); model2.PD_PROJECT_CODE = text; model2.PD_PROJECT_APP_COMPANY = str10; model2.PD_PROJECT_APP_COMPANY_LIST = str11; model2.PD_PROJECT_APP_MAN_LIST = str12; model2.PD_PROJECT_APPRAISE_FILENO = str13; PD_PROJECT_JGYS_Bll bll = new PD_PROJECT_JGYS_Bll(); if (bll.Exists(text)) { bll.Update(model); } else { bll.Add(model); } PD_PROJECT_APPRAISE_Bll bll2 = new PD_PROJECT_APPRAISE_Bll(); if (bll2.Exists(text)) { bll2.Update(model2); } else { bll2.Add(model2); } this.UpdateDateXMPJ(PD_OROHECT_CODE); PageShowText.Refurbish("修改成功", this.Page); } }
private void CreateData_JGYS() { string strErr = ""; if (!this.Panduan_JGYS(ref strErr)) { this.hy_File(null, strErr); } else { string text = this.lblPD_PROJECT_CODE.Text; DateTime time = DateTime.Parse(this.txtPD_PROJECT_COMPLETE_DATE.Value); DateTime time2 = DateTime.Parse(this.txtPD_PROJECT_YSSQ_DATE.Value); DateTime time3 = DateTime.Parse(this.txtPD_PROJECT_YS_DATE.Value); string selectedValue = this.ddlPD_PROJECT_YS_COMPANY.SelectedValue; string str4 = this.txtPD_PROJECT_YS_ZRR.Text; string str5 = this.txtPD_PROJECT_YS_NAME.Text; string str6 = this.txtPD_PROJECT_YS_SUGGEST.Text; string str7 = this.ddlPD_PROJECT_YS_RESULT.SelectedItem.Text; string str8 = this.txtPD_PROJECT_YS_CONDITION.Text; PD_PROJECT_JGYS_Model model = new PD_PROJECT_JGYS_Model { PD_PROJECT_CODE = text, PD_PROJECT_COMPLETE_DATE = new DateTime?(time), PD_PROJECT_YSSQ_DATE = new DateTime?(time2), PD_PROJECT_YS_DATE = new DateTime?(time3), PD_PROJECT_YS_COMPANY = selectedValue, PD_PROJECT_YS_ZRR = str4, PD_PROJECT_YS_NAME = str5, PD_PROJECT_YS_SUGGEST = str6, PD_PROJECT_YS_RESULT = str7, PD_PROJECT_YS_CONDITION = str8 }; PD_PROJECT_APPRAISE_Model model2 = new PD_PROJECT_APPRAISE_Model(); string str9 = this.txtAUTO_NO_APPRAISE.Text; string str10 = this.txtPD_PROJECT_APP_COMPANY.Text; string str11 = this.txtPD_PROJECT_APP_COMPANY_LIST.Text; string str12 = this.txtPD_PROJECT_APP_MAN_LIST.Text; string str13 = this.txtPD_PROJECT_APPRAISE_FILENO.Text; if (!PublicDal.PageValidate.IsNumber(str9)) { str9 = "-1"; } model2.AUTO_NO = int.Parse(str9); model2.PD_PROJECT_CODE = text; model2.PD_PROJECT_APP_COMPANY = str10; model2.PD_PROJECT_APP_COMPANY_LIST = str11; model2.PD_PROJECT_APP_MAN_LIST = str12; model2.PD_PROJECT_APPRAISE_FILENO = str13; new PD_PROJECT_JGYS_Bll().Add(model); new PD_PROJECT_APPRAISE_Bll().Add(model2); this.UpdateDateXMPJ(""); Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?UpdatePK=" + model.PD_PROJECT_CODE, this.Page); } }
protected void btnSave_PingJia_Click(object sender, EventArgs e) { if (this.Panduan_PingJia()) { int num = int.Parse(this.lblAUTO_NO_JGYS.Text); string text = this.lblPD_PROJECT_CODE.Text; DateTime time = DateTime.Parse(this.txtPD_PROJECT_APP_DATE.Value); string str2 = this.txtPD_PROJECT_APP_COMPANY.Text; string str3 = this.txtPD_PROJECT_APP_COMPANY_LIST.Text; string str4 = this.txtPD_PROJECT_APP_MAN_LIST.Text; string str5 = this.txtPD_PROJECT_APPRAISE_FILENO.Text; PD_PROJECT_APPRAISE_Model model = new PD_PROJECT_APPRAISE_Model { AUTO_NO = num, PD_PROJECT_CODE = text, PD_PROJECT_APP_DATE = new DateTime?(time), PD_PROJECT_APP_COMPANY = str2, PD_PROJECT_APP_COMPANY_LIST = str3, PD_PROJECT_APP_MAN_LIST = str4, PD_PROJECT_APPRAISE_FILENO = str5 }; new PD_PROJECT_APPRAISE_Bll().Add(model); } }
public PD_PROJECT_APPRAISE_Model GetModel(int AUTO_NO) { StringBuilder builder = new StringBuilder(); builder.Append("select AUTO_NO,PD_PROJECT_CODE,PD_PROJECT_APP_DATE,PD_PROJECT_APP_COMPANY,PD_PROJECT_APP_COMPANY_LIST,PD_PROJECT_APP_MAN_LIST,PD_PROJECT_APPRAISE_FILENO from PD_PROJECT_APPRAISE "); builder.Append(" where AUTO_NO=:AUTO_NO "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Number, 4) }; cmdParms[0].Value = AUTO_NO; PD_PROJECT_APPRAISE_Model model = new PD_PROJECT_APPRAISE_Model(); DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if (set.Tables[0].Rows[0]["AUTO_NO"].ToString() != "") { model.AUTO_NO = int.Parse(set.Tables[0].Rows[0]["AUTO_NO"].ToString()); } model.PD_PROJECT_CODE = set.Tables[0].Rows[0]["PD_PROJECT_CODE"].ToString(); if (set.Tables[0].Rows[0]["PD_PROJECT_APP_DATE"].ToString() != "") { model.PD_PROJECT_APP_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_PROJECT_APP_DATE"].ToString())); } model.PD_PROJECT_APP_COMPANY = set.Tables[0].Rows[0]["PD_PROJECT_APP_COMPANY"].ToString(); model.PD_PROJECT_APP_COMPANY_LIST = set.Tables[0].Rows[0]["PD_PROJECT_APP_COMPANY_LIST"].ToString(); model.PD_PROJECT_APP_MAN_LIST = set.Tables[0].Rows[0]["PD_PROJECT_APP_MAN_LIST"].ToString(); model.PD_PROJECT_APPRAISE_FILENO = set.Tables[0].Rows[0]["PD_PROJECT_APPRAISE_FILENO"].ToString(); return model; }
public bool Update(PD_PROJECT_APPRAISE_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update PD_PROJECT_APPRAISE set "); builder.Append("PD_PROJECT_CODE=:PD_PROJECT_CODE,"); builder.Append("PD_PROJECT_APP_DATE=:PD_PROJECT_APP_DATE,"); builder.Append("PD_PROJECT_APP_COMPANY=:PD_PROJECT_APP_COMPANY,"); builder.Append("PD_PROJECT_APP_COMPANY_LIST=:PD_PROJECT_APP_COMPANY_LIST,"); builder.Append("PD_PROJECT_APP_MAN_LIST=:PD_PROJECT_APP_MAN_LIST,"); builder.Append("PD_PROJECT_APPRAISE_FILENO=:PD_PROJECT_APPRAISE_FILENO"); builder.Append(" where AUTO_NO=:AUTO_NO "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30), new OracleParameter(":PD_PROJECT_APP_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_APP_COMPANY", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_APP_COMPANY_LIST", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_APP_MAN_LIST", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_APPRAISE_FILENO", OracleType.VarChar, 100), new OracleParameter(":AUTO_NO", OracleType.Number, 4) }; cmdParms[0].Value = model.PD_PROJECT_CODE; cmdParms[1].Value = model.PD_PROJECT_APP_DATE; cmdParms[2].Value = model.PD_PROJECT_APP_COMPANY; cmdParms[3].Value = model.PD_PROJECT_APP_COMPANY_LIST; cmdParms[4].Value = model.PD_PROJECT_APP_MAN_LIST; cmdParms[5].Value = model.PD_PROJECT_APPRAISE_FILENO; cmdParms[6].Value = model.AUTO_NO; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public void Add(PD_PROJECT_APPRAISE_Model model) { this.dal.Add(model); }
public bool Update(PD_PROJECT_APPRAISE_Model model) { return this.dal.Update(model); }
private PD_PROJECT_APPRAISE_Model getModer_jgys_pj(PD_PROJECT_APPRAISE_Model APPRAISE_Model, string PD_PROJECT_CODE) { if (APPRAISE_Model == null) { APPRAISE_Model = new PD_PROJECT_APPRAISE_Model(); } string text = this.txtAUTO_NO_APPRAISE.Text; if (!PublicDal.PageValidate.IsNumber(text)) { text = "-1"; } APPRAISE_Model.AUTO_NO = int.Parse(text); if (PublicDal.PageValidate.IsDateTime(this.txtPD_PROJECT_APP_DATE.Value)) { APPRAISE_Model.PD_PROJECT_APP_DATE = new DateTime?(DateTime.Parse(this.txtPD_PROJECT_APP_DATE.Value)); } APPRAISE_Model.PD_PROJECT_CODE = PD_PROJECT_CODE; APPRAISE_Model.PD_PROJECT_APP_COMPANY = this.txtPD_PROJECT_APP_COMPANY.Text; APPRAISE_Model.PD_PROJECT_APP_COMPANY_LIST = this.txtPD_PROJECT_APP_COMPANY_LIST.Text; APPRAISE_Model.PD_PROJECT_APP_MAN_LIST = this.txtPD_PROJECT_APP_MAN_LIST.Text; APPRAISE_Model.PD_PROJECT_APPRAISE_FILENO = this.txtPD_PROJECT_APPRAISE_FILENO.Text; return APPRAISE_Model; }