protected void btnUpdate_Click(object sender, EventArgs e) { if (this.FormCheck()) { try { // string sqlCheck = string.Format("select count(*) from Out_BankFlow where ReferenceNumber='{0}' and ProNo='{1}' AND ID<>{2}", //lblReferenceNumber.Text, txtProNo.Text, Request["Id"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sqlCheck)) > 0) // { // base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('流水号[{0}],单据号[{1}],已经存在!');</script>", lblReferenceNumber.Text, txtProNo.Text)); // return; // } Out_BankFlow model = getModel(); if (this.outBankSer.Update(model)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('修改成功!');</script>"); } else { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('修改失败!');</script>"); } } catch (Exception ex) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('" + ex.Message + "!');</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { if (base.Request["Id"] != null) { this.btnAdd.Visible = false; Out_BankFlow model = this.outBankSer.GetModel(Convert.ToInt32(base.Request["Id"])); this.lblNumber.Text = model.Number; this.lblReferenceNumber.Text = model.ReferenceNumber; this.ddlOutType.Text = model.OutType; this.txtProNo.Text = model.ProNo; this.txtOutTotal.Text = model.OutTotal.ToString(); this.txtRemark.Text = model.Remark; } else { lblReferenceNumber.Text = Request["TransactionReferenceNumber"].ToString(); this.btnUpdate.Visible = false; } BankFlowService bandFlowSer = new BankFlowService(); var list = bandFlowSer.GetListArray(string.Format("TransactionReferenceNumber='{0}'", lblReferenceNumber.Text)); if (list.Count > 0) { lblInPayeeName.Text = list[0].InPayeeName; lblTradeAmount.Text = System.Math.Abs(list[0].TradeAmount).ToString(); lblTime.Text = list[0].TransactionDate.ToString(); string sql = string.Format("select ISNULL(SUM(OutTotal),0) AS SUMOutTotal FROM Out_BankFlow where ReferenceNumber='{0}'", lblReferenceNumber.Text); //if (base.Request["Id"] != null) //{ // sql += " and id<>" + Request["Id"]; //} var total = Convert.ToDecimal(DBHelp.ExeScalar(sql)); lblLastTotal.Text = (System.Math.Abs(list[0].TradeAmount) - total).ToString(); var outList = outBankSer.GetListArray(string.Format(" ReferenceNumber='{0}'", lblReferenceNumber.Text)); var time = Convert.ToDateTime(lblTime.Text); foreach (var m in outList) { m.Time = time; } gvLiuShui.DataSource = outList; gvLiuShui.DataBind(); } } }
public Out_BankFlow getModel() { string Number = this.lblNumber.Text; string ReferenceNumber = this.lblReferenceNumber.Text; string outType = this.ddlOutType.Text; string ProNo = this.txtProNo.Text.Trim(); decimal OutTotal = decimal.Parse(this.txtOutTotal.Text); string Remark = this.txtRemark.Text; Out_BankFlow model = new Out_BankFlow(); model.Number = Number; model.ReferenceNumber = ReferenceNumber; model.OutType = outType; model.ProNo = ProNo; model.OutTotal = OutTotal; model.Remark = Remark; if (Request["Id"] != null) { model.Id = Convert.ToInt32(Request["Id"]); } return(model); }