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);
}
