public void Add(PD_PROJECT_JGYS_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into PD_PROJECT_JGYS("); builder.Append("PD_PROJECT_CODE,PD_PROJECT_COMPLETE_DATE,PD_PROJECT_YSSQ_DATE,PD_PROJECT_YS_DATE,PD_PROJECT_YS_COMPANY,PD_PROJECT_YS_ZRR,PD_PROJECT_YS_NAME,PD_PROJECT_YS_SUGGEST,PD_PROJECT_YS_RESULT,PD_PROJECT_YS_CONDITION)"); builder.Append(" values ("); builder.Append(":PD_PROJECT_CODE,:PD_PROJECT_COMPLETE_DATE,:PD_PROJECT_YSSQ_DATE,:PD_PROJECT_YS_DATE,:PD_PROJECT_YS_COMPANY,:PD_PROJECT_YS_ZRR,:PD_PROJECT_YS_NAME,:PD_PROJECT_YS_SUGGEST,:PD_PROJECT_YS_RESULT,:PD_PROJECT_YS_CONDITION)"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30), new OracleParameter(":PD_PROJECT_COMPLETE_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YSSQ_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YS_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YS_COMPANY", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_YS_ZRR", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_YS_NAME", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_SUGGEST", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_RESULT", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_CONDITION", OracleType.VarChar, 100) }; cmdParms[0].Value = model.PD_PROJECT_CODE; cmdParms[1].Value = model.PD_PROJECT_COMPLETE_DATE; cmdParms[2].Value = model.PD_PROJECT_YSSQ_DATE; cmdParms[3].Value = model.PD_PROJECT_YS_DATE; cmdParms[4].Value = model.PD_PROJECT_YS_COMPANY; cmdParms[5].Value = model.PD_PROJECT_YS_ZRR; cmdParms[6].Value = model.PD_PROJECT_YS_NAME; cmdParms[7].Value = model.PD_PROJECT_YS_SUGGEST; cmdParms[8].Value = model.PD_PROJECT_YS_RESULT; cmdParms[9].Value = model.PD_PROJECT_YS_CONDITION; DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); }
public List<PD_PROJECT_JGYS_Model> DataTableToList(DataTable dt) { List<PD_PROJECT_JGYS_Model> list = new List<PD_PROJECT_JGYS_Model>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PD_PROJECT_JGYS_Model item = new PD_PROJECT_JGYS_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_COMPLETE_DATE"].ToString() != "") { item.PD_PROJECT_COMPLETE_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_PROJECT_COMPLETE_DATE"].ToString())); } if (dt.Rows[i]["PD_PROJECT_YSSQ_DATE"].ToString() != "") { item.PD_PROJECT_YSSQ_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_PROJECT_YSSQ_DATE"].ToString())); } if (dt.Rows[i]["PD_PROJECT_YS_DATE"].ToString() != "") { item.PD_PROJECT_YS_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_PROJECT_YS_DATE"].ToString())); } item.PD_PROJECT_YS_COMPANY = dt.Rows[i]["PD_PROJECT_YS_COMPANY"].ToString(); item.PD_PROJECT_YS_ZRR = dt.Rows[i]["PD_PROJECT_YS_ZRR"].ToString(); item.PD_PROJECT_YS_NAME = dt.Rows[i]["PD_PROJECT_YS_NAME"].ToString(); item.PD_PROJECT_YS_SUGGEST = dt.Rows[i]["PD_PROJECT_YS_SUGGEST"].ToString(); item.PD_PROJECT_YS_RESULT = dt.Rows[i]["PD_PROJECT_YS_RESULT"].ToString(); item.PD_PROJECT_YS_CONDITION = dt.Rows[i]["PD_PROJECT_YS_CONDITION"].ToString(); list.Add(item); } } return list; }
public PD_PROJECT_JGYS_Model GetModel(string PD_PROJECT_CODE) { StringBuilder builder = new StringBuilder(); builder.Append("select AUTO_NO,PD_PROJECT_CODE,PD_PROJECT_COMPLETE_DATE,PD_PROJECT_YSSQ_DATE,PD_PROJECT_YS_DATE,PD_PROJECT_YS_COMPANY,PD_PROJECT_YS_ZRR,PD_PROJECT_YS_NAME,PD_PROJECT_YS_SUGGEST,PD_PROJECT_YS_RESULT,PD_PROJECT_YS_CONDITION from PD_PROJECT_JGYS "); builder.Append(" where PD_PROJECT_CODE=:PD_PROJECT_CODE "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30) }; cmdParms[0].Value = PD_PROJECT_CODE; PD_PROJECT_JGYS_Model model = new PD_PROJECT_JGYS_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_COMPLETE_DATE"].ToString() != "") { model.PD_PROJECT_COMPLETE_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_PROJECT_COMPLETE_DATE"].ToString())); } if (set.Tables[0].Rows[0]["PD_PROJECT_YSSQ_DATE"].ToString() != "") { model.PD_PROJECT_YSSQ_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_PROJECT_YSSQ_DATE"].ToString())); } if (set.Tables[0].Rows[0]["PD_PROJECT_YS_DATE"].ToString() != "") { model.PD_PROJECT_YS_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_PROJECT_YS_DATE"].ToString())); } model.PD_PROJECT_YS_COMPANY = set.Tables[0].Rows[0]["PD_PROJECT_YS_COMPANY"].ToString(); model.PD_PROJECT_YS_ZRR = set.Tables[0].Rows[0]["PD_PROJECT_YS_ZRR"].ToString(); model.PD_PROJECT_YS_NAME = set.Tables[0].Rows[0]["PD_PROJECT_YS_NAME"].ToString(); model.PD_PROJECT_YS_SUGGEST = set.Tables[0].Rows[0]["PD_PROJECT_YS_SUGGEST"].ToString(); model.PD_PROJECT_YS_RESULT = set.Tables[0].Rows[0]["PD_PROJECT_YS_RESULT"].ToString(); model.PD_PROJECT_YS_CONDITION = set.Tables[0].Rows[0]["PD_PROJECT_YS_CONDITION"].ToString(); return model; }
public bool Update(PD_PROJECT_JGYS_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update PD_PROJECT_JGYS set "); builder.Append("PD_PROJECT_COMPLETE_DATE=:PD_PROJECT_COMPLETE_DATE,"); builder.Append("PD_PROJECT_YSSQ_DATE=:PD_PROJECT_YSSQ_DATE,"); builder.Append("PD_PROJECT_YS_DATE=:PD_PROJECT_YS_DATE,"); builder.Append("PD_PROJECT_YS_COMPANY=:PD_PROJECT_YS_COMPANY,"); builder.Append("PD_PROJECT_YS_ZRR=:PD_PROJECT_YS_ZRR,"); builder.Append("PD_PROJECT_YS_NAME=:PD_PROJECT_YS_NAME,"); builder.Append("PD_PROJECT_YS_SUGGEST=:PD_PROJECT_YS_SUGGEST,"); builder.Append("PD_PROJECT_YS_RESULT=:PD_PROJECT_YS_RESULT,"); builder.Append("PD_PROJECT_YS_CONDITION=:PD_PROJECT_YS_CONDITION"); builder.Append(" where PD_PROJECT_CODE=:PD_PROJECT_CODE "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_COMPLETE_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YSSQ_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YS_DATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_YS_COMPANY", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_YS_ZRR", OracleType.VarChar, 200), new OracleParameter(":PD_PROJECT_YS_NAME", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_SUGGEST", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_RESULT", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_YS_CONDITION", OracleType.VarChar, 100), new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 30) }; cmdParms[0].Value = model.PD_PROJECT_COMPLETE_DATE; cmdParms[1].Value = model.PD_PROJECT_YSSQ_DATE; cmdParms[2].Value = model.PD_PROJECT_YS_DATE; cmdParms[3].Value = model.PD_PROJECT_YS_COMPANY; cmdParms[4].Value = model.PD_PROJECT_YS_ZRR; cmdParms[5].Value = model.PD_PROJECT_YS_NAME; cmdParms[6].Value = model.PD_PROJECT_YS_SUGGEST; cmdParms[7].Value = model.PD_PROJECT_YS_RESULT; cmdParms[8].Value = model.PD_PROJECT_YS_CONDITION; cmdParms[9].Value = model.PD_PROJECT_CODE; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }
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 btnAddSave_Click(object sender, EventArgs e) { 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 str3 = this.txtPD_PROJECT_YS_ZRR.Text; string str4 = this.txtPD_PROJECT_YS_NAME.Text; string str5 = this.txtPD_PROJECT_YS_SUGGEST.Text; string str6 = this.ddlPD_PROJECT_YS_RESULT.SelectedItem.Text; string str7 = 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 = str3, PD_PROJECT_YS_NAME = str4, PD_PROJECT_YS_SUGGEST = str5, PD_PROJECT_YS_RESULT = str6, PD_PROJECT_YS_CONDITION = str7 }; new PD_PROJECT_JGYS_Bll().Add(model); PageShowText.Refurbish("添加成功", this.Page); }
public void Add(PD_PROJECT_JGYS_Model model) { this.dal.Add(model); }
public bool Update(PD_PROJECT_JGYS_Model model) { return this.dal.Update(model); }
private PD_PROJECT_JGYS_Model getModer_jgys(PD_PROJECT_JGYS_Model model, string PD_PROJECT_CODE) { if (model == null) { model = new PD_PROJECT_JGYS_Model(); } model.PD_PROJECT_CODE = PD_PROJECT_CODE; if (PublicDal.PageValidate.IsDateTime(this.txtPD_PROJECT_COMPLETE_DATE.Value)) { model.PD_PROJECT_COMPLETE_DATE = new DateTime?(DateTime.Parse(this.txtPD_PROJECT_COMPLETE_DATE.Value)); } if (PublicDal.PageValidate.IsDateTime(this.txtPD_PROJECT_YSSQ_DATE.Value)) { model.PD_PROJECT_YSSQ_DATE = new DateTime?(DateTime.Parse(this.txtPD_PROJECT_YSSQ_DATE.Value)); } if (PublicDal.PageValidate.IsDateTime(this.txtPD_PROJECT_YS_DATE.Value)) { model.PD_PROJECT_YS_DATE = new DateTime?(DateTime.Parse(this.txtPD_PROJECT_YS_DATE.Value)); } model.PD_PROJECT_YS_COMPANY = this.ddlPD_PROJECT_YS_COMPANY.SelectedValue; model.PD_PROJECT_YS_ZRR = this.txtPD_PROJECT_YS_ZRR.Text; model.PD_PROJECT_YS_NAME = this.txtPD_PROJECT_YS_NAME.Text; model.PD_PROJECT_YS_SUGGEST = this.txtPD_PROJECT_YS_SUGGEST.Text; model.PD_PROJECT_YS_RESULT = this.ddlPD_PROJECT_YS_RESULT.SelectedItem.Text; model.PD_PROJECT_YS_CONDITION = this.txtPD_PROJECT_YS_CONDITION.Text; return model; }