public bool Add(PD_PROJECT_GKGS_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into PD_PROJECT_GKGS("); builder.Append("AUTO_NO,PD_PROJECT_CODE,PD_PROJECT_TYPE,PD_GS_TYPE,PD_GS_STYLE,PD_GS_ZHUTI,PD_GS_DATE,PD_GS_ADDR,PD_GS_FILENAME,PD_GS_FILENAME_SYSTEM,PD_GS_DETAIL,PD_GS_DATE_END)"); builder.Append(" values ("); builder.Append(":AUTO_NO,:PD_PROJECT_CODE,:PD_PROJECT_TYPE,:PD_GS_TYPE,:PD_GS_STYLE,:PD_GS_ZHUTI,:PD_GS_DATE,:PD_GS_ADDR,:PD_GS_FILENAME,:PD_GS_FILENAME_SYSTEM,:PD_GS_DETAIL,:PD_GS_DATE_END)"); builder.Append(" RETURNING AUTO_NO INTO :R_Auto_No "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_CODE", OracleType.NVarChar), new OracleParameter(":PD_PROJECT_TYPE", OracleType.Number, 4), new OracleParameter(":PD_GS_TYPE", OracleType.Number, 4), new OracleParameter(":PD_GS_STYLE", OracleType.NVarChar), new OracleParameter(":PD_GS_ZHUTI", OracleType.NVarChar), new OracleParameter(":PD_GS_DATE", OracleType.DateTime), new OracleParameter(":PD_GS_ADDR", OracleType.NVarChar), new OracleParameter(":PD_GS_FILENAME", OracleType.NVarChar), new OracleParameter(":PD_GS_FILENAME_SYSTEM", OracleType.NVarChar), new OracleParameter(":PD_GS_DETAIL", OracleType.NVarChar), new OracleParameter(":PD_GS_DATE_END", OracleType.DateTime), new OracleParameter(":R_Auto_No", OracleType.Number, 20) }; cmdParms[0].Value = model.AUTO_NO; cmdParms[1].Value = model.PD_PROJECT_CODE; cmdParms[2].Value = model.PD_PROJECT_TYPE; cmdParms[3].Value = model.PD_GS_TYPE; cmdParms[4].Value = model.PD_GS_STYLE; cmdParms[5].Value = model.PD_GS_ZHUTI; cmdParms[6].Value = model.PD_GS_DATE; cmdParms[7].Value = model.PD_GS_ADDR; cmdParms[8].Value = model.PD_GS_FILENAME; cmdParms[9].Value = model.PD_GS_FILENAME_SYSTEM; cmdParms[10].Value = model.PD_GS_DETAIL; cmdParms[11].Value = model.PD_GS_DATE_END; cmdParms[12].Direction = ParameterDirection.Output; int num = DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); model.AUTO_NO = int.Parse(cmdParms[12].Value.ToString()); return (num > 0); }
public List<PD_PROJECT_GKGS_Model> DataTableToList(DataTable dt) { List<PD_PROJECT_GKGS_Model> list = new List<PD_PROJECT_GKGS_Model>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PD_PROJECT_GKGS_Model item = new PD_PROJECT_GKGS_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_TYPE"].ToString() != "") { item.PD_PROJECT_TYPE = new int?(int.Parse(dt.Rows[i]["PD_PROJECT_TYPE"].ToString())); } if (dt.Rows[i]["PD_GS_TYPE"].ToString() != "") { item.PD_GS_TYPE = new int?(int.Parse(dt.Rows[i]["PD_GS_TYPE"].ToString())); } item.PD_GS_STYLE = dt.Rows[i]["PD_GS_STYLE"].ToString(); item.PD_GS_ZHUTI = dt.Rows[i]["PD_GS_ZHUTI"].ToString(); if (dt.Rows[i]["PD_GS_DATE"].ToString() != "") { item.PD_GS_DATE = new DateTime?(DateTime.Parse(dt.Rows[i]["PD_GS_DATE"].ToString())); } item.PD_GS_ADDR = dt.Rows[i]["PD_GS_ADDR"].ToString(); item.PD_GS_FILENAME = dt.Rows[i]["PD_GS_FILENAME"].ToString(); item.PD_GS_FILENAME_SYSTEM = dt.Rows[i]["PD_GS_FILENAME_SYSTEM"].ToString(); item.PD_GS_DETAIL = dt.Rows[i]["PD_GS_DETAIL"].ToString(); list.Add(item); } } return list; }
public bool Add(PD_PROJECT_GKGS_Model model) { return this.dal.Add(model); }
public bool Update(PD_PROJECT_GKGS_Model model) { return this.dal.Update(model); }
public PD_PROJECT_GKGS_Model GetModel(int AUTO_NO) { StringBuilder builder = new StringBuilder(); builder.Append("select AUTO_NO,PD_PROJECT_CODE,PD_PROJECT_TYPE,PD_GS_TYPE,PD_GS_STYLE,PD_GS_ZHUTI,PD_GS_DATE,PD_GS_ADDR,PD_GS_FILENAME,PD_GS_FILENAME_SYSTEM,PD_GS_DETAIL,PD_GS_DATE_END from PD_PROJECT_GKGS "); 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_GKGS_Model model = new PD_PROJECT_GKGS_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_TYPE"].ToString() != "") { model.PD_PROJECT_TYPE = new int?(int.Parse(set.Tables[0].Rows[0]["PD_PROJECT_TYPE"].ToString())); } if (set.Tables[0].Rows[0]["PD_GS_TYPE"].ToString() != "") { model.PD_GS_TYPE = new int?(int.Parse(set.Tables[0].Rows[0]["PD_GS_TYPE"].ToString())); } model.PD_GS_STYLE = set.Tables[0].Rows[0]["PD_GS_STYLE"].ToString(); model.PD_GS_ZHUTI = set.Tables[0].Rows[0]["PD_GS_ZHUTI"].ToString(); if (set.Tables[0].Rows[0]["PD_GS_DATE"].ToString() != "") { model.PD_GS_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_GS_DATE"].ToString())); } model.PD_GS_ADDR = set.Tables[0].Rows[0]["PD_GS_ADDR"].ToString(); model.PD_GS_FILENAME = set.Tables[0].Rows[0]["PD_GS_FILENAME"].ToString(); model.PD_GS_FILENAME_SYSTEM = set.Tables[0].Rows[0]["PD_GS_FILENAME_SYSTEM"].ToString(); model.PD_GS_DETAIL = set.Tables[0].Rows[0]["PD_GS_DETAIL"].ToString(); if (set.Tables[0].Rows[0]["PD_GS_DATE_END"].ToString() != "") { model.PD_GS_DATE_END = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["PD_GS_DATE_END"].ToString())); } return model; }
public bool Update(PD_PROJECT_GKGS_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update PD_PROJECT_GKGS set "); builder.Append("PD_PROJECT_CODE=:PD_PROJECT_CODE,"); builder.Append("PD_PROJECT_TYPE=:PD_PROJECT_TYPE,"); builder.Append("PD_GS_TYPE=:PD_GS_TYPE,"); builder.Append("PD_GS_STYLE=:PD_GS_STYLE,"); builder.Append("PD_GS_ZHUTI=:PD_GS_ZHUTI,"); builder.Append("PD_GS_DATE=:PD_GS_DATE,"); builder.Append("PD_GS_ADDR=:PD_GS_ADDR,"); builder.Append("PD_GS_FILENAME=:PD_GS_FILENAME,"); builder.Append("PD_GS_FILENAME_SYSTEM=:PD_GS_FILENAME_SYSTEM,"); builder.Append("PD_GS_DETAIL=:PD_GS_DETAIL,"); builder.Append("PD_GS_DATE_END=:PD_GS_DATE_END"); builder.Append(" where AUTO_NO=:AUTO_NO "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.NVarChar), new OracleParameter(":PD_PROJECT_TYPE", OracleType.Number, 4), new OracleParameter(":PD_GS_TYPE", OracleType.Number, 4), new OracleParameter(":PD_GS_STYLE", OracleType.NVarChar), new OracleParameter(":PD_GS_ZHUTI", OracleType.NVarChar), new OracleParameter(":PD_GS_DATE", OracleType.DateTime), new OracleParameter(":PD_GS_ADDR", OracleType.NVarChar), new OracleParameter(":PD_GS_FILENAME", OracleType.NVarChar), new OracleParameter(":PD_GS_FILENAME_SYSTEM", OracleType.NVarChar), new OracleParameter(":PD_GS_DETAIL", OracleType.NVarChar), new OracleParameter(":PD_GS_DATE_END", OracleType.DateTime), new OracleParameter(":AUTO_NO", OracleType.Number, 4) }; cmdParms[0].Value = model.PD_PROJECT_CODE; cmdParms[1].Value = model.PD_PROJECT_TYPE; cmdParms[2].Value = model.PD_GS_TYPE; cmdParms[3].Value = model.PD_GS_STYLE; cmdParms[4].Value = model.PD_GS_ZHUTI; cmdParms[5].Value = model.PD_GS_DATE; cmdParms[6].Value = model.PD_GS_ADDR; cmdParms[7].Value = model.PD_GS_FILENAME; cmdParms[8].Value = model.PD_GS_FILENAME_SYSTEM; cmdParms[9].Value = model.PD_GS_DETAIL; cmdParms[10].Value = model.PD_GS_DATE_END; cmdParms[11].Value = model.AUTO_NO; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }
private void Save() { PD_PROJECT_GKGS_Bll bll = new PD_PROJECT_GKGS_Bll(); if (base.Request["doType"] == "add") { if (this.txtPD_PROJECT_CODE.Value != null) { PD_PROJECT_GKGS_Model model = new PD_PROJECT_GKGS_Model(); this.getModel(model); if (bll.Add(model)) { this.AddImgMethod(model); Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + model.PD_PROJECT_CODE, this.Page); } else { Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + base.Request["UpdatePK"].ToString(), this.Page); } } } else if (base.Request["DoType"].ToString() == "update") { if (PublicDal.PageValidate.IsDecimal(this.lblAUTO_NO.Text)) { PD_PROJECT_GKGS_Model model2 = bll.GetModel(int.Parse(this.lblAUTO_NO.Text)); this.getModel(model2); if (bll.Update(model2)) { this.AddImgMethod(model2); Const.DoSuccessNoClose("修改成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + base.Request["UpdatePK"].ToString(), this.Page); } else { Const.DoSuccessNoClose("修改失败", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + base.Request["UpdatePK"].ToString(), this.Page); } } } else if (this.txtPD_PROJECT_CODE.Value != null) { PD_PROJECT_GKGS_Model model3 = new PD_PROJECT_GKGS_Model(); this.getModel(model3); if (bll.Add(model3)) { this.AddImgMethod(model3); Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + model3.PD_PROJECT_CODE, this.Page); } Const.DoSuccessNoClose("添加成功", this.Page.Request.Url.LocalPath + "?doType=look&UpdatePK=" + model3.PD_PROJECT_CODE, this.Page); } }
private void GetQUOTA(PD_PROJECT_GKGS_Model model) { DataSet set = null; DataView defaultView = null; string s = base.Server.UrlDecode(this.FilePostCtr1.getFileName); if ((s != null) && (s.Trim() != "")) { set = new DataSet(); XmlTextReader reader = new XmlTextReader(new StringReader(s)); set.ReadXml(reader); } if ((set != null) && (set.Tables.Count > 0)) { defaultView = set.Tables[0].DefaultView; } if (defaultView != null) { defaultView.RowFilter = " tableID='zxzb_bt' "; if (defaultView.Count > 0) { model.PD_GS_FILENAME = defaultView[0]["FileName"].ToString(); model.PD_GS_FILENAME_SYSTEM = defaultView[0]["FileSysName"].ToString(); } } }
private void getModel(PD_PROJECT_GKGS_Model model) { model.PD_PROJECT_CODE = this.txtPD_PROJECT_CODE.Value; model.PD_GS_ADDR = this.txtPD_GS_ADDR.Value; if (PublicDal.PageValidate.IsDateTime(this.txtPD_GS_DATE.Value)) { model.PD_GS_DATE = new DateTime?(DateTime.Parse(this.txtPD_GS_DATE.Value)); } if (PublicDal.PageValidate.IsDateTime(this.txtPD_GS_DATE_END.Value)) { model.PD_GS_DATE_END = new DateTime?(DateTime.Parse(this.txtPD_GS_DATE_END.Value)); } model.PD_GS_DETAIL = this.txtPD_GS_DETAIL.Value.ToString(); model.PD_GS_STYLE = this.txtPD_GS_STYLE.Value.ToString(); model.PD_GS_TYPE = new int?(Convert.ToInt32(this.txtPD_GS_TYPE.SelectedValue.ToString())); model.PD_GS_ZHUTI = this.txtPD_GS_ZHUTI.Value.ToString(); model.PD_PROJECT_CODE = this.txtPD_PROJECT_CODE.Value.ToString(); this.GetQUOTA(model); }
private void AddImgMethod(PD_PROJECT_GKGS_Model model) { try { str = this.txt_file.Text.ToString(); if (!string.IsNullOrEmpty(str)) { string str2 = ""; string str3 = ""; if (!string.IsNullOrEmpty(str)) { str2 = str.Substring(str.LastIndexOf("||")).Replace("||", ""); str3 = str2; str2 = str2.Substring(0, str2.LastIndexOf(".")); } str = "UserImages/" + str3; DbHelperOra.ExecuteSql(string.Concat(new object[] { "insert into t_photos (fkid, photoname, photopath, remarks, sortid) values ( 'BZssGKGS_", model.AUTO_NO, "', '", str3, "', '", str, "', '", str3, "', 1)" })); } } catch (Exception) { } }