public String updateLoanTransactionItem(FormCollection form)
{
log.Info("form:" + form.Count);
string msg = "更新成功!!";
FIN_LOAN_TRANACTION item = new FIN_LOAN_TRANACTION();
item.BL_ID = Int64.Parse(form["blId"]);
item.TID = Int64.Parse(form["tid"]);
item.TRANSACTION_TYPE = int.Parse(form["transaction_type"]);
item.PERIOD = int.Parse(form["Period"]);
if (int.Parse(form["transaction_type"]) == -1)
{
item.EVENT_DATE = Convert.ToDateTime(form.Get("event_date"));
}
if (int.Parse(form["transaction_type"]) == 1)
{
item.PAYBACK_DATE = Convert.ToDateTime(form.Get("payback_date"));
}
if (int.Parse(form["transaction_type"]) == -1)
{
try
{
item.AMOUNT = decimal.Parse(form["amount"]);
}
catch (Exception ex)
{
log.Error(item.AMOUNT + " not paid amount:" + ex.Message);
}
}
else
{
try
{
item.AMOUNT = decimal.Parse(form["payback_amt"]);
}
catch (Exception ex)
{
log.Error(item.AMOUNT + " not paid amount:" + ex.Message);
}
}
item.REMARK = form["remark"];
item.VA_FORM_ID = form["formid"];
item.CREATE_ID = form["create_id"];
item.CREATE_DATE = Convert.ToDateTime(form.Get("create_date"));
SYS_USER loginUser = (SYS_USER)Session["user"];
item.MODIFY_ID = loginUser.USER_ID;
item.MODIFY_DATE = DateTime.Now;
ContextService4BankInfo service = new ContextService4BankInfo();
int i = 0;
i = service.updateLoanTransactionItem(item);
if (i == 0)
{
msg = service.message;
}
return(msg);
}
public int updateLoanTransactionItem(FIN_LOAN_TRANACTION item)
{
int i = 0;
using (var context = new topmepEntities())
{
try
{
context.FIN_LOAN_TRANACTION.AddOrUpdate(item);
i = context.SaveChanges();
}
catch (Exception e)
{
logger.Error("update loan transaction item fail:" + e.ToString());
logger.Error(e.StackTrace);
message = e.Message;
}
}
return(i);
}
/// <summary>
/// 增加借還款紀錄
/// </summary>
public void addBankLoanTransaction()
{
log.Info("bl_id=" + Request["bl_id"]);
long blid = long.Parse(Request["bl_id"]);
int period = int.Parse(Request["period"]);
string[] formKeys = Request.Form.AllKeys;
List <FIN_LOAN_TRANACTION> lstLoanTransaction = new List <FIN_LOAN_TRANACTION>();
List <string> lstFormKey = new List <string>();
for (int i = 0; i < formKeys.Length; i++)
{
log.Debug("key=" + formKeys[i]);
if (formKeys[i].StartsWith("EVENT_DATE"))
{
lstFormKey.Add(formKeys[i]);
}
}
//處理借款紀錄
SYS_USER u = (SYS_USER)Session["user"];
decimal totalAmt = 0;
foreach (string key in lstFormKey)
{
string[] keyAry = key.Split('.');
//借款記錄
if (Request["LOAN_AMOUNT." + keyAry[1]].Trim() != "")
{
FIN_LOAN_TRANACTION loanTransaction = new FIN_LOAN_TRANACTION();
loanTransaction.BL_ID = blid;
loanTransaction.PERIOD = period + 1;
loanTransaction.EVENT_DATE = DateTime.Parse(Request["EVENT_DATE." + keyAry[1]]);
loanTransaction.TRANSACTION_TYPE = -1;
loanTransaction.AMOUNT = decimal.Parse(Request["LOAN_AMOUNT." + keyAry[1]]);
loanTransaction.REMARK = Request["REMARK." + keyAry[1]].Trim();
log.Info("Event Date=" + loanTransaction.EVENT_DATE + ",Loan Amount=" + loanTransaction.AMOUNT);
loanTransaction.CREATE_ID = u.USER_ID;
loanTransaction.CREATE_DATE = DateTime.Now;
if (Request["supplier"] == "Y")
{
lstLoanTransaction.Add(loanTransaction);
}
else
{
if (decimal.Parse(Request["available_quota"]) >= (decimal.Parse(Request["LOAN_AMOUNT." + keyAry[1]])))
{
lstLoanTransaction.Add(loanTransaction);
}
}
totalAmt = totalAmt + decimal.Parse(Request["LOAN_AMOUNT." + keyAry[1]]);
period++;
}
//還款記錄
if (Request["PAYBACK_LOAN_AMOUNT." + keyAry[1]].Trim() != "")
{
FIN_LOAN_TRANACTION loanTransaction = new FIN_LOAN_TRANACTION();
loanTransaction.BL_ID = blid;
loanTransaction.PERIOD = period + 1;
loanTransaction.PAYBACK_DATE = DateTime.Parse(Request["EVENT_DATE." + keyAry[1]]);
loanTransaction.TRANSACTION_TYPE = 1;
loanTransaction.AMOUNT = decimal.Parse(Request["PAYBACK_LOAN_AMOUNT." + keyAry[1]]);
loanTransaction.REMARK = Request["REMARK." + keyAry[1]].Trim();
log.Info("PAYBACK_DATE=" + loanTransaction.PAYBACK_DATE + ",PayBack Amount=" + loanTransaction.AMOUNT);
loanTransaction.CREATE_ID = u.USER_ID;
loanTransaction.CREATE_DATE = DateTime.Now;
lstLoanTransaction.Add(loanTransaction);
period++;
}
}
if (lstLoanTransaction.Count > 0)
{
ContextService4BankInfo service = new ContextService4BankInfo();
service.addBankLoanTransaction(lstLoanTransaction);
}
Response.Redirect("/BankInfo/BankLoanTransaction?BL_ID=" + Request["bl_id"]);
}
