protected void btnConfirm_Click(object sender, EventArgs e) { FundAppInfo fundAppInfo = new FundAppInfo(); fundAppInfo.PrjCode = this.PrjCode; fundAppInfo.FundAppUser = this.Session["yhdm"].ToString(); fundAppInfo.FundAppDate = Convert.ToDateTime(this.txtDate.Text.Trim()); fundAppInfo.FundNum = Convert.ToDecimal(this.txtMoney.Text.Trim()); fundAppInfo.Content = this.txtContent.Text.Trim(); fundAppInfo.GuidFlow = this.GuidFlow; if (this.OpType == "Add") { if (this.fac.insFundRecord(fundAppInfo)) { this.JS.Text = "alert('保存借款申请记录成功!');window.returnValue = true;window.close()"; return; } } else { if (this.OpType == "Mod" && this.fac.updFundRecord(fundAppInfo)) { this.JS.Text = "alert('更新借款申请记录成功!');window.returnValue = true;window.close()"; } } }
public bool insFundRecord(FundAppInfo fai) { string str = ""; object obj2 = str + "insert into EPM_Fund_Application (PrjCode,FundAppUser,FundAppDate,FundNum,Content) values ("; object obj3 = string.Concat(new object[] { obj2, "'", fai.PrjCode, "','", fai.FundAppUser, "','", fai.FundAppDate, "'," }); return(publicDbOpClass.NonQuerySqlString(string.Concat(new object[] { obj3, "cast('", fai.FundNum, "' as decimal(18,2)),'", fai.Content, "')" }))); }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { this.txtDate.Text = DateTime.Today.Date.ToString(); this.PrjCode = new Guid(base.Request.QueryString["PrjCode"].ToString()); this.OpType = base.Request.QueryString["op"].ToString(); if (this.OpType == "Mod") { this.GuidFlow = new Guid(base.Request.QueryString["id"].ToString()); FundAppInfo fundAppInfo = new FundAppInfo(); fundAppInfo = this.fac.getOnePrjAppRecord(this.GuidFlow); this.txtDate.Text = fundAppInfo.FundAppDate.Date.ToString(); this.txtMoney.Text = fundAppInfo.FundNum.ToString(); this.txtContent.Text = fundAppInfo.Content; } } }
public bool updFundRecord(FundAppInfo fai) { object obj2 = string.Concat(new object[] { "update EPM_Fund_Application set FundNum = cast('", fai.FundNum, "' as decimal(18,2)),Content = '", fai.Content, "' where " }); return(publicDbOpClass.NonQuerySqlString(string.Concat(new object[] { obj2, " GuidFlow = '", fai.GuidFlow, "'" }))); }