public void Add(MESS_BACK_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into MESS_BACK("); builder.Append("MES_ID,MES_COMPANY,MES_DEPT,MES_MAN,MES_DATE,MES_KUNAN,MES_JIANYI,MES_XZYJ,MES_PZ,MES_TITLE,MES_FLAG,MES_SHCOMPANY,MES_SHDEPT,MES_SHMAN,MES_SHDATE,PD_NOW_SERVERPK,PD_PROJECT_CODE,PD_QUOTA_DEPART,PD_YEAR,PD_BASE_FKLX,MES_YWGSYJ,MES_XCJYJ)"); builder.Append(" values ("); builder.Append(":MES_ID,:MES_COMPANY,:MES_DEPT,:MES_MAN,:MES_DATE,:MES_KUNAN,:MES_JIANYI,:MES_XZYJ,:MES_PZ,:MES_TITLE,:MES_FLAG,:MES_SHCOMPANY,:MES_SHDEPT,:MES_SHMAN,:MES_SHDATE,:PD_NOW_SERVERPK,:PD_PROJECT_CODE,:PD_QUOTA_DEPART,:PD_YEAR,:PD_BASE_FKLX,:MES_YWGSYJ,:MES_XCJYJ)"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":MES_ID", OracleType.VarChar, 30), new OracleParameter(":MES_COMPANY", OracleType.VarChar, 50), new OracleParameter(":MES_DEPT", OracleType.VarChar, 50), new OracleParameter(":MES_MAN", OracleType.VarChar, 50), new OracleParameter(":MES_DATE", OracleType.DateTime), new OracleParameter(":MES_KUNAN", OracleType.VarChar, 100), new OracleParameter(":MES_JIANYI", OracleType.VarChar, 100), new OracleParameter(":MES_XZYJ", OracleType.VarChar, 100), new OracleParameter(":MES_PZ", OracleType.VarChar, 200), new OracleParameter(":MES_TITLE", OracleType.VarChar, 100), new OracleParameter(":MES_FLAG", OracleType.Char, 1), new OracleParameter(":MES_SHCOMPANY", OracleType.VarChar, 50), new OracleParameter(":MES_SHDEPT", OracleType.VarChar, 50), new OracleParameter(":MES_SHMAN", OracleType.VarChar, 50), new OracleParameter(":MES_SHDATE", OracleType.DateTime), new OracleParameter(":PD_NOW_SERVERPK", OracleType.VarChar, 50), new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_DEPART", OracleType.VarChar, 50), new OracleParameter(":PD_YEAR", OracleType.VarChar, 6), new OracleParameter(":PD_BASE_FKLX", OracleType.VarChar, 10), new OracleParameter(":MES_YWGSYJ", OracleType.VarChar, 0xff), new OracleParameter(":MES_XCJYJ", OracleType.VarChar, 0xff) }; cmdParms[0].Value = model.MES_ID; cmdParms[1].Value = model.MES_COMPANY; cmdParms[2].Value = model.MES_DEPT; cmdParms[3].Value = model.MES_MAN; cmdParms[4].Value = model.MES_DATE; cmdParms[5].Value = model.MES_KUNAN; cmdParms[6].Value = model.MES_JIANYI; cmdParms[7].Value = model.MES_XZYJ; cmdParms[8].Value = model.MES_PZ; cmdParms[9].Value = model.MES_TITLE; cmdParms[10].Value = model.MES_FLAG; cmdParms[11].Value = model.MES_SHCOMPANY; cmdParms[12].Value = model.MES_SHDEPT; cmdParms[13].Value = model.MES_SHMAN; cmdParms[14].Value = model.MES_SHDATE; cmdParms[15].Value = model.PD_NOW_SERVERPK; cmdParms[0x10].Value = model.PD_PROJECT_CODE; cmdParms[0x11].Value = model.PD_QUOTA_DEPART; cmdParms[0x12].Value = model.PD_YEAR; cmdParms[0x13].Value = model.PD_BASE_FKLX; cmdParms[20].Value = model.MES_YWGSYJ; cmdParms[0x15].Value = model.MES_XCJYJ; DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); }
public MESS_BACK_Model GetModel(string MES_ID) { StringBuilder builder = new StringBuilder(); builder.Append("select MES_ID,MES_COMPANY,MES_DEPT,MES_MAN,MES_DATE,MES_KUNAN,MES_JIANYI,MES_XZYJ,MES_PZ,MES_TITLE,MES_FLAG,MES_SHCOMPANY,MES_SHDEPT,MES_SHMAN,MES_SHDATE,PD_NOW_SERVERPK,t.PD_PROJECT_CODE,PD_QUOTA_DEPART,t.PD_YEAR,PD_PROJECT_NAME,PD_BASE_FKLX,comp.name MES_COMPANY_NAME,MES_YWGSYJ,MES_XCJYJ"); builder.Append(" from MESS_BACK t "); builder.Append(" left join tb_project pro on pro.PD_PROJECT_CODE=t.PD_PROJECT_CODE"); builder.Append(" left join db_company comp on trim(comp.pk_corp)=trim(t.MES_COMPANY)"); builder.Append(" where MES_ID=:MES_ID "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":MES_ID", OracleType.VarChar, 50) }; cmdParms[0].Value = MES_ID; MESS_BACK_Model model = new MESS_BACK_Model(); DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } model.MES_ID = set.Tables[0].Rows[0]["MES_ID"].ToString(); model.MES_COMPANY = set.Tables[0].Rows[0]["MES_COMPANY"].ToString(); model.MES_COMPANY_NAME = set.Tables[0].Rows[0]["MES_COMPANY_NAME"].ToString(); model.MES_DEPT = set.Tables[0].Rows[0]["MES_DEPT"].ToString(); model.MES_MAN = set.Tables[0].Rows[0]["MES_MAN"].ToString(); if (set.Tables[0].Rows[0]["MES_DATE"].ToString() != "") { model.MES_DATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["MES_DATE"].ToString())); } model.MES_KUNAN = set.Tables[0].Rows[0]["MES_KUNAN"].ToString(); model.MES_JIANYI = set.Tables[0].Rows[0]["MES_JIANYI"].ToString(); model.MES_XZYJ = set.Tables[0].Rows[0]["MES_XZYJ"].ToString(); model.MES_PZ = set.Tables[0].Rows[0]["MES_PZ"].ToString(); model.MES_TITLE = set.Tables[0].Rows[0]["MES_TITLE"].ToString(); model.MES_FLAG = set.Tables[0].Rows[0]["MES_FLAG"].ToString(); model.MES_SHCOMPANY = set.Tables[0].Rows[0]["MES_SHCOMPANY"].ToString(); model.MES_SHDEPT = set.Tables[0].Rows[0]["MES_SHDEPT"].ToString(); model.MES_SHMAN = set.Tables[0].Rows[0]["MES_SHMAN"].ToString(); model.PD_NOW_SERVERPK = set.Tables[0].Rows[0]["PD_NOW_SERVERPK"].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(); model.PD_QUOTA_DEPART = set.Tables[0].Rows[0]["PD_QUOTA_DEPART"].ToString(); model.PD_YEAR = set.Tables[0].Rows[0]["PD_YEAR"].ToString(); model.PD_BASE_FKLX = set.Tables[0].Rows[0]["PD_BASE_FKLX"].ToString(); model.MES_YWGSYJ = set.Tables[0].Rows[0]["MES_YWGSYJ"].ToString(); model.MES_XCJYJ = set.Tables[0].Rows[0]["MES_XCJYJ"].ToString(); if (set.Tables[0].Rows[0]["MES_SHDATE"].ToString() != "") { model.MES_SHDATE = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["MES_SHDATE"].ToString())); } return model; }
public bool Update(MESS_BACK_Model model) { return this.dal.Update(model); }
public bool Update(MESS_BACK_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update MESS_BACK set "); builder.Append("MES_COMPANY=:MES_COMPANY,"); builder.Append("MES_DEPT=:MES_DEPT,"); builder.Append("MES_MAN=:MES_MAN,"); builder.Append("MES_DATE=:MES_DATE,"); builder.Append("MES_KUNAN=:MES_KUNAN,"); builder.Append("MES_JIANYI=:MES_JIANYI,"); builder.Append("MES_XZYJ=:MES_XZYJ,"); builder.Append("MES_PZ=:MES_PZ,"); builder.Append("MES_TITLE=:MES_TITLE,"); builder.Append("MES_FLAG=:MES_FLAG,"); builder.Append("MES_SHCOMPANY=:MES_SHCOMPANY,"); builder.Append("MES_SHDEPT=:MES_SHDEPT,"); builder.Append("MES_SHMAN=:MES_SHMAN,"); builder.Append("MES_SHDATE=:MES_SHDATE,"); builder.Append("PD_PROJECT_CODE=:PD_PROJECT_CODE,"); builder.Append("PD_QUOTA_DEPART=:PD_QUOTA_DEPART,"); builder.Append("PD_YEAR=:PD_YEAR,"); builder.Append("PD_BASE_FKLX=:PD_BASE_FKLX,"); builder.Append("MES_YWGSYJ=:MES_YWGSYJ,"); builder.Append("MES_XCJYJ=:MES_XCJYJ"); builder.Append(" where MES_ID=:MES_ID "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":MES_COMPANY", OracleType.VarChar, 50), new OracleParameter(":MES_DEPT", OracleType.VarChar, 50), new OracleParameter(":MES_MAN", OracleType.VarChar, 50), new OracleParameter(":MES_DATE", OracleType.DateTime), new OracleParameter(":MES_KUNAN", OracleType.VarChar, 100), new OracleParameter(":MES_JIANYI", OracleType.VarChar, 100), new OracleParameter(":MES_XZYJ", OracleType.VarChar, 100), new OracleParameter(":MES_PZ", OracleType.VarChar, 200), new OracleParameter(":MES_TITLE", OracleType.VarChar, 100), new OracleParameter(":MES_FLAG", OracleType.Char, 1), new OracleParameter(":MES_SHCOMPANY", OracleType.VarChar, 50), new OracleParameter(":MES_SHDEPT", OracleType.VarChar, 50), new OracleParameter(":MES_SHMAN", OracleType.VarChar, 50), new OracleParameter(":MES_SHDATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_CODE", OracleType.VarChar, 50), new OracleParameter(":PD_QUOTA_DEPART", OracleType.VarChar, 50), new OracleParameter(":PD_YEAR", OracleType.VarChar, 4), new OracleParameter(":PD_BASE_FKLX", OracleType.VarChar, 10), new OracleParameter(":MES_YWGSYJ", OracleType.VarChar, 0xff), new OracleParameter(":MES_XCJYJ", OracleType.VarChar, 0xff), new OracleParameter(":MES_ID", OracleType.VarChar, 30) }; cmdParms[0].Value = model.MES_COMPANY; cmdParms[1].Value = model.MES_DEPT; cmdParms[2].Value = model.MES_MAN; cmdParms[3].Value = model.MES_DATE; cmdParms[4].Value = model.MES_KUNAN; cmdParms[5].Value = model.MES_JIANYI; cmdParms[6].Value = model.MES_XZYJ; cmdParms[7].Value = model.MES_PZ; cmdParms[8].Value = model.MES_TITLE; cmdParms[9].Value = model.MES_FLAG; cmdParms[10].Value = model.MES_SHCOMPANY; cmdParms[11].Value = model.MES_SHDEPT; cmdParms[12].Value = model.MES_SHMAN; cmdParms[13].Value = model.MES_SHDATE; cmdParms[14].Value = model.PD_PROJECT_CODE; cmdParms[15].Value = model.PD_QUOTA_DEPART; cmdParms[0x10].Value = model.PD_YEAR; cmdParms[0x11].Value = model.PD_BASE_FKLX; cmdParms[0x12].Value = model.MES_YWGSYJ; cmdParms[0x13].Value = model.MES_XCJYJ; cmdParms[20].Value = model.MES_ID; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public void Add(MESS_BACK_Model model) { this.dal.Add(model); }
public void addupdate() { MESS_BACK_Model model = new MESS_BACK_Model { MES_COMPANY = ((UserModel)this.Session["User"]).Company.pk_corp, MES_DATE = new DateTime?(DateTime.Now), MES_DEPT = ((UserModel)this.Session["User"]).Branch.BranchPK, MES_FLAG = "0", MES_ID = DateTime.Now.ToString("yyyyMMddhhmmss"), MES_JIANYI = this.areajianyi.Value, MES_KUNAN = this.areakn.Value, MES_MAN = ((UserModel)this.Session["User"]).UserName, MES_PZ = this.areapz.Value, MES_SHCOMPANY = "", MES_SHDATE = new DateTime?(DateTime.Now), MES_SHDEPT = "", MES_SHMAN = "", MES_TITLE = "", MES_XZYJ = this.areaxzyj.Value, MES_YWGSYJ = this.ywgsyj.Value, MES_XCJYJ = this.xcjyj.Value, PD_PROJECT_CODE = this.txtPD_PROJECT_CODE.Value, PD_QUOTA_DEPART = this.ddlPD_QUOTA_DEPART.SelectedValue, PD_YEAR = this.ddlPD_YEAR.SelectedValue, PD_NOW_SERVERPK = PublicDal.SetCreateServiceStream(this.Page), PD_BASE_FKLX = this.ddl_BASE_FKLX.SelectedValue }; this.B_mesback.Add(model); Const.DoSuccessNoClose("新增完毕!点确定即将进入编辑页面。", "messbackoper.aspx?PK=" + base.Request["PK"] + "&reload=MainAddUpdate&strTitle=" + base.Server.UrlEncode(this.Master.strTitle.Trim()), this.Page); }
private void shenhe() { MESS_BACK_Model model = new MESS_BACK_Model(); model = this.B_mesback.GetModel(base.Request["PK"]); MESS_BACK_Model model2 = new MESS_BACK_Model { MES_COMPANY = model.MES_COMPANY, MES_DATE = model.MES_DATE, MES_DEPT = model.MES_DEPT, MES_FLAG = "1", MES_ID = base.Request["PK"].ToString(), MES_JIANYI = this.areajianyi.Value, MES_KUNAN = this.areakn.Value, MES_MAN = model.MES_MAN, MES_PZ = this.areapz.Value, MES_SHCOMPANY = ((UserModel)this.Session["User"]).Company.pk_corp, MES_SHDATE = new DateTime?(DateTime.Now), MES_SHDEPT = ((UserModel)this.Session["User"]).Branch.BranchPK, MES_SHMAN = ((UserModel)this.Session["User"]).UserName, MES_TITLE = "", MES_XZYJ = this.areaxzyj.Value, MES_YWGSYJ = this.ywgsyj.Value, MES_XCJYJ = this.xcjyj.Value, PD_PROJECT_CODE = this.txtPD_PROJECT_CODE.Value, PD_QUOTA_DEPART = this.ddlPD_QUOTA_DEPART.SelectedValue, PD_YEAR = this.ddlPD_YEAR.SelectedValue }; this.B_mesback.Update(model2); Const.AddSuccess(1, base.Request["reload"].ToString(), this.Page); }
protected void Page_Load(object sender, EventArgs e) { this.Master.ButtonsPushDown = new ButtonsHandler(this.Buttons); if (base.Request["strTitle"] != null) { this.Master.strTitle = base.Request["strTitle"]; } if (!base.IsPostBack) { if (this.Session["user"] == null) { Const.GoLoginPath_OpenWindow(this.Page); } else { this.Bind(); string userName = ((UserModel)this.Session["User"]).UserName; string power = ((UserModel)this.Session["User"]).Power; ButtonsModel model = null; this.ListPageLoad(this.Page, out model, base.Request["PK"]); this.SetTxtEnabled(); if ((base.Request["PK"] != null) && (base.Request["PK"] != "")) { model.IfPrintNote = true; model.IbtPrintNoteText = "打印"; try { MESS_BACK_Model model2 = new MESS_BACK_Model(); model2 = this.B_mesback.GetModel(base.Request["PK"]); this.txtcompany.Text = model2.MES_COMPANY_NAME; this.txtdate.Text = model2.MES_DATE.ToString(); this.Textdept.Text = model2.MES_DEPT; this.areajianyi.Value = model2.MES_JIANYI; this.areakn.Value = model2.MES_KUNAN; this.txtman.Text = model2.MES_MAN; this.areapz.Value = model2.MES_PZ; this.txtshcompany.Text = model2.MES_SHCOMPANY; this.txtshdate.Text = model2.MES_SHDATE.ToString(); this.txtshdepart.Text = model2.MES_SHDEPT; this.txtshman.Text = model2.MES_SHMAN; this.areaxzyj.Value = model2.MES_XZYJ; this.txtPD_PROJECT_CODE.Value = model2.PD_PROJECT_CODE; this.txtProjectName.Value = model2.PD_PROJECT_NAME; this.ddlPD_QUOTA_DEPART.SelectedValue = model2.PD_QUOTA_DEPART; this.ddlPD_YEAR.SelectedValue = model2.PD_YEAR; this.ddl_BASE_FKLX.SelectedValue = model2.PD_BASE_FKLX; this.ywgsyj.Value = model2.MES_YWGSYJ; this.xcjyj.Value = model2.MES_XCJYJ; } catch (Exception exception) { this.el = new ExceptionLog.ExceptionLog(); this.el.ErrClassName = base.GetType().ToString(); this.el.ErrMessage = exception.Message.ToString(); this.el.ErrMethod = "Page_Load()"; this.el.WriteExceptionLog(true); Const.OpenErrorPage("获取数据失败,请联系管理员!", this.Page); } finally { if (this.dbo != null) { this.dbo.Close(); } } } else { this.txtcompany.Text = ((UserModel)this.Session["User"]).Company.Name; this.txtdate.Text = DateTime.Now.ToString("yyyy-MM-dd"); this.txtman.Text = ((UserModel)this.Session["User"]).UserName; this.Textdept.Text = ((UserModel)this.Session["User"]).Branch.Name; } this.Master.LBTitle = "字典设置 - 新增数据字典——表信息"; this.Master.TitlePic = "~/images/页标题/修改税费项目.jpg"; this.Master.btModel = model; } } }
private void ShowInfo(string backid) { MESS_BACK_Model model = new MESS_BACK_Model(); model = this.B_mesback.GetModel(backid); this.year.Text = DateTime.Now.Year.ToString(); this.company.Text = model.MES_COMPANY_NAME; this.createdate.Text = !model.MES_DATE.HasValue ? "" : Convert.ToDateTime(model.MES_DATE).ToString("yyyy年MM月dd日"); this.project_name.Text = model.PD_PROJECT_NAME; this.backobj.Text = this.getFkName(model.PD_QUOTA_DEPART); this.knwt.Text = model.MES_KUNAN; this.gzjy.Text = model.MES_JIANYI; this.xzfyj.Text = model.MES_XZYJ; }