/// <summary> /// 增加廠商借支基本資料 /// </summary> /// <returns></returns> public string addSupplierLoan(FormCollection f) { SYS_USER u = (SYS_USER)Session["user"]; FIN_BANK_LOAN bankloanInfo = new FIN_BANK_LOAN(); if (Request["BL_ID"] != "") { bankloanInfo.BL_ID = Convert.ToInt64(Request["BL_ID"]); } bankloanInfo.BANK_NAME = Request["BANK_NAME"]; bankloanInfo.REMARK = Request["REMARK"]; bankloanInfo.IS_SUPPLIER = "Y"; bankloanInfo.CREATE_ID = u.USER_ID; bankloanInfo.CREATE_DATE = DateTime.Now; if (Request["plans"] != "") { bankloanInfo.PROJECT_ID = Request["plans"]; } ContextService4BankInfo service = new ContextService4BankInfo(); int i = service.addBankLoan(bankloanInfo); if (i > 0) { return("更新成功(" + bankloanInfo.BL_ID + ")!!"); } else { return("更新失敗!!"); } }
/// <summary> /// 增加貸款銀行基本資料 /// </summary> /// <returns></returns> public string addBankLoan(FormCollection f) { SYS_USER u = (SYS_USER)Session["user"]; FIN_BANK_LOAN bankloanInfo = new FIN_BANK_LOAN(); if (Request["BL_ID"] != "") { bankloanInfo.BL_ID = Convert.ToInt64(Request["BL_ID"]); } bankloanInfo.BANK_ID = Request["BANK_ID"]; bankloanInfo.BANK_NAME = Request["BANK_NAME"]; //bankloanInfo.BRANCH_NAME = Request["BRANCH_NAME"]; bankloanInfo.ACCOUNT_NAME = Request["ACCOUNT_NAME"]; //bankloanInfo.ACCOUNT_NO = Request["ACCOUNT_NO"]; bankloanInfo.START_DATE = DateTime.Parse(Request["START_DATE"]); bankloanInfo.DUE_DATE = DateTime.Parse(Request["DUE_DATE"]); bankloanInfo.PERIOD_COUNT = int.Parse(Request["PERIOD_COUNT"]); decimal quota = decimal.Parse(Request["QUOTA"]); bankloanInfo.QUOTA = quota; if (Request["AR_PAYBACK_RATIO"] != "") { bankloanInfo.AR_PAYBACK_RATIO = decimal.Parse(Request["AR_PAYBACK_RATIO"]); } if (Request["CUM_AR_RATIO"] != "") { bankloanInfo.CUM_AR_RATIO = decimal.Parse(Request["CUM_AR_RATIO"]); } if (Request["QUOTA_AVAILABLE_RATIO"] != "") { bankloanInfo.QUOTA_AVAILABLE_RATIO = decimal.Parse(Request["QUOTA_AVAILABLE_RATIO"]); } else { bankloanInfo.QUOTA_AVAILABLE_RATIO = 100; } bankloanInfo.QUOTA_RECYCLABLE = Request["QUOTA_RECYCLABLE"]; bankloanInfo.REMARK = Request["REMARK"]; bankloanInfo.ACCOUNT_NAME = Request["ACCOUNT_NAME"]; if (Request["plans"] != "") { bankloanInfo.PROJECT_ID = Request["plans"]; } bankloanInfo.CREATE_ID = u.USER_ID; bankloanInfo.CREATE_DATE = DateTime.Now; ContextService4BankInfo service = new ContextService4BankInfo(); int i = service.addBankLoan(bankloanInfo); if (i > 0) { return("更新成功(" + bankloanInfo.BL_ID + ")!!"); } else { return("更新失敗!!"); } }
//新增貸款帳戶資料 public int addBankLoan(FIN_BANK_LOAN bankloan) { int i = 0; using (var context = new topmepEntities()) { try { context.FIN_BANK_LOAN.AddOrUpdate(bankloan); i = context.SaveChanges(); logger.Info("new bank loan record=" + bankloan.ACCOUNT_NAME); } catch (Exception ex) { logger.Error(ex.Message + ":StackTrace=" + ex.StackTrace); } } logger.Info("add bankloan count =" + i); return(i); }