Пример #1
0
    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()";
            }
        }
    }
Пример #2
0
        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, "')" })));
        }
Пример #3
0
 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;
         }
     }
 }
Пример #4
0
        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, "'" })));
        }