/// <summary> /// 提交借款申请 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool SubmitLoanApply(MemberLoanAuditParameter model) { string sqlstr = $@"insert into MemberLoanAudit(MemberID,ApplyAmount,LoanTerm,LoanMethod) values({model.MemberID},{model.ApplyAmount},{model.LoanTerm},{model.LoanMethod})"; int result = DbHelper.ExecuteSqlCommandScalar(sqlstr, new DbParameter[] { }); return(result > 0); }
public ActionResult Loan(MemberLoanAuditViewModel model) { MemberLoanAuditParameter paramModel = new MemberLoanAuditParameter(); paramModel.ApplyAmount = model.ApplyAmount; paramModel.LoanMethod = model.LoanMethod; paramModel.LoanTerm = model.LoanTerm; paramModel.MemberID = CommonHelper.CurrentUser.MemberID; bool result = _loanMemberService.SubmitLoanApply(paramModel); if (result) { return(Redirect("/UserLoan/Index")); } return(RedirectToAction("Loan")); }
public JsonResult <dynamic> SubmitLoanApply(MemberLoanAuditParameter model) { decimal AvailableAmount = _loanMemberService.GetMemberLoanDetail(model.MemberID).AvailableAmount; decimal AuditAmount = _loanMemberService.GetTotalAuditAmountByMemberID(model.MemberID); if (model.ApplyAmount + AuditAmount > AvailableAmount) { return new JsonResult <dynamic> { status = false, Message = "借款额度超过可借额度" } } ; bool flag = _loanMemberService.SubmitLoanApply(model); return(new JsonResult <dynamic> { status = flag, Message = flag == true ? "提交申请成功" : "提交申请失败" }); } }