public DayStatisticsBll() { _baseAuditDal = new BaseAuditDAL(); _salesGroupDal = new SalesGroupDAL(); _mortgageDal = new MortgageDAL(); _log = new LogManagerExtend(); _baseCaseDal = new BaseCaseDAL(); _lendingDal = new LendingDAL(); }
public AfterCaseController() { _auditDal = new BaseAuditDAL(); _salesGroupDal = new SalesGroupDAL(); _relationPersonAuditDal = new RelationPersonAuditDAL(); _lendingDal = new LendingDAL(); _mortgageBll = new MortgageBll(); _dictionaryBll = new DictionaryBLL(); symm = new SymmCrypto(_Key, _IV); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult GetCaseDetails(string id) { var response = new BaseResponse <CaseAllDetailsViewModel>(); var ch = new AuditController.AuditHelper(); var baseAuditDal = new BaseAuditDAL(); var lendal = new LendingDAL(); var dicdal = new DictionaryDAL(); var sales = new SalesManDAL(); var lendvm = new LendingViewModel(); var mortgagevm = new PublicMortgageViewModel(); var mortgageBll = new MortgageBll(); var caseallmodel = new CaseAllDetailsViewModel(); var baseauditvm = ch.FindByID(id, CurrentUser); if (baseauditvm != null) { var ahp = new AuditHisHelper(); var list = baseAuditDal.GetListByCaseNum(baseauditvm.CaseNum); baseauditvm.AuditHistory = ahp.GetHistory(list); } var mort = mortgageBll.QueryById(id); if (mort != null) { mortgagevm = mortgagevm.CastModel(mort); mortgagevm.ContractFileName = GetFiles(mortgagevm.ContractFile); mortgagevm.OtherFileName = GetFiles(mortgagevm.OtherFile); mortgagevm.FourFileName = GetFiles(mortgagevm.FourFile); mortgagevm.RepaymentAttorneyFileName = GetFiles(mortgagevm.RepaymentAttorneyFile); mortgagevm.PowerAttorneyFileName = GetFiles(mortgagevm.PowerAttorneyFile); mortgagevm.CollectionFileName = GetFiles(mortgagevm.CollectionFile); } var lend = lendal.Get(id); if (lend != null) { lendvm = lendvm.CastModel(lend); lendvm.LendFileName = GetFiles(lendvm.LendFile); lendvm.IsActivitieRateText = dicdal.GetText(lendvm.IsActivitieRate.ToString()); lendvm.CaseModeText = dicdal.GetText(lendvm.CaseMode); lendvm.ThirdPartyText = dicdal.GetText(lendvm.ThirdParty); lendvm.AuditTermText = dicdal.GetText(lendvm.AuditTerm); lendvm.SalesIDText = sales.FindBySalesID(lendvm.SalesID) == null ? null : sales.FindBySalesID(lendvm.SalesID).Name; } caseallmodel.Baseauditvm = baseauditvm; caseallmodel.Mortgagevm = mortgagevm; caseallmodel.Lendingvm = lendvm; response.Status = "Success"; response.Data = caseallmodel; return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult RejectLending(string id) { var lendingDal = new LendingDAL(); var response = new BaseResponse <LendingViewModel>(); if (lendingDal.RejectCase(id, CurrentUser)) { response.Status = StatusEnum.Success.ToString(); } else { response.Status = "Failed"; } return(Json(response, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 放款只读页面 /// </summary> /// <returns></returns> public ActionResult ReadonlyLending(string id) { LendingDAL led = new LendingDAL(); var lem = led.GetAuthorizeAndSelf(id, CurrentUser); var morvm = new LendingViewModel(); if (lem != null) { morvm = morvm.CastModel(lem); } else { BaseAuditDAL bad = new BaseAuditDAL(); MortgageDAL md = new MortgageDAL(); var audit = bad.GetMaxAuditAuthorizeAndSelf(id, CurrentUser); if (audit == null) { RedirectToAction("Failed", "Home"); } var mor = md.GetAll().FirstOrDefault(t => t.BaseAudit.CaseNum == audit.CaseNum); if (mor == null) { RedirectToAction("Failed", "Home"); } var borrower = audit.RelationPersonAudits.FirstOrDefault(t => t.RelationType == "-PersonType-JieKuanRen"); if (borrower == null) { RedirectToAction("Failed", "Home"); } lem = new Lending(); //lem.Borrower = borrower.Name; //lem.ContactNumber = borrower.ContactAudits.FirstOrDefault(t => t.IsDefault) == null ? "" : borrower.ContactAudits.FirstOrDefault(t => t.IsDefault).ContactNumber; //lem.BorrowNumber = audit.BankCard; //lem.OpeningBank = audit.OpeningBank; //lem.ContractAmount = mor.ContractAmount; lem.ID = id; morvm = morvm.CastModel(lem); } ViewBag.ID = id; return(View(morvm)); }
public ActionResult GetPageIndex(LendingCriteriaRequest request) { BaseAuditDAL bd = new BaseAuditDAL(); LendingDAL ld = new LendingDAL(); int total = 0; request.PageSize = request.PageSize == 0 ? 10 : request.PageSize; request.PageIndex = request.PageIndex == 0 ? 1 : request.PageIndex; var modellist = ld.GetAllAuthorizeAndSelf(request.StartDate, request.EndDate, CurrentUser); if (!string.IsNullOrEmpty(request.CaseStatus)) { modellist = modellist.Where(t => t.CaseStatus == request.CaseStatus); } if (!string.IsNullOrEmpty(request.BorrowerName) && !string.IsNullOrWhiteSpace(request.BorrowerName)) { modellist = modellist.Where(t => t.BorrowerName.Contains(request.BorrowerName)); } if (!string.IsNullOrEmpty(request.CaseNum) && !string.IsNullOrWhiteSpace(request.CaseNum)) { modellist = modellist.Where(t => t.NewCaseNum.Contains(request.CaseNum)); } if (request.SalesGroupId.IsNotNullOrWhiteSpace() && request.SalesGroupId.IsNotNullOrEmpty()) { modellist = modellist.Where(t => t.SalesGroupID == request.SalesGroupId); } IEnumerable <BaseAudit> pageList = bd.GetAllPage(modellist, out total, request.PageSize, request.PageIndex, request.Order, request.Sort); var response = new PageResponseViewModel <LendingPageViewModel>(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.Total = total; response.TotalPage = (int)Math.Ceiling((decimal)response.Total / response.PageSize); response.Data = Map(pageList.ToList()); return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult GetLending(string id) { LendingDAL bd = new LendingDAL(); DictionaryDAL dicdal = new DictionaryDAL(); SalesManDAL Sales = new SalesManDAL(); BaseResponse <LendingViewModel> br = new BaseResponse <LendingViewModel>(); var mor = bd.Get(id); var morvm = new LendingViewModel(); if (mor != null) { morvm = morvm.CastModel(mor); morvm.LendFileName = GetFiles(morvm.LendFile); morvm.Introducer = GetIntroducer(id); morvm.IsActivitieRateText = dicdal.GetText(morvm.IsActivitieRate.ToString()); morvm.CaseModeText = dicdal.GetText(morvm.CaseMode); morvm.ThirdPartyText = dicdal.GetText(morvm.ThirdParty); morvm.AuditTermText = dicdal.GetText(morvm.AuditTerm); morvm.SalesIDText = Sales.FindBySalesID(morvm.SalesID) == null ? null : Sales.FindBySalesID(morvm.SalesID).Name; } else { mor = new Lending(); mor.ID = id; morvm = morvm.CastModel(mor); morvm.Introducer = GetIntroducer(id); morvm.IsActivitieRateText = dicdal.GetText(morvm.IsActivitieRate.ToString()); morvm.CaseModeText = dicdal.GetText(morvm.CaseMode); morvm.ThirdPartyText = dicdal.GetText(morvm.ThirdParty); morvm.AuditTermText = dicdal.GetText(morvm.AuditTerm); morvm.SalesIDText = Sales.FindBySalesID(morvm.SalesID) == null ? null : Sales.FindBySalesID(morvm.SalesID).Name; } br.Data = morvm; br.Status = "Success"; return(Json(br, JsonRequestBehavior.AllowGet)); }
public ActionResult SubmitLending(LendingViewModel model) { var response = new BaseResponse <LendingViewModel>(); var relationPersonauditDal = new RelationPersonAuditDAL(); var baseAuditDal = new BaseAuditDAL(); //var relationstatebll = new RelationStateBLL(); #region 验证 List <ErrorMessage> em = new List <ErrorMessage>(); if (!ModelState.IsValid) { foreach (var e in ModelState.Keys) { if (ModelState[e].Errors.Any()) { if (e.Contains("FileName")) { continue; } if (string.IsNullOrEmpty(ModelState[e].Errors[0].ErrorMessage)) { continue; } var error = new ErrorMessage(); error.Key = e; error.Message = ModelState[e].Errors[0].ErrorMessage; em.Add(error); } } } if (em.Any()) { response.Status = "Failed"; response.Message = em.ToArray(); response.Data = null; return(Json(response, JsonRequestBehavior.AllowGet)); } #endregion 验证 var baseaduit = baseAuditDal.GetAuthorizeAndSelf(model.ID, CurrentUser); if (baseaduit == null && baseaduit.CaseStatus != CaseStatus.Lending) { response.Status = "Failed"; return(Json(response, JsonRequestBehavior.AllowGet)); } var db = new Lending(); LendingDAL bd = new LendingDAL(); db = model.CastDB(model); // 合同文件 db.LendFile = SaveFiles(model.LendFile, model.ID, model.ID); //IEnumerable<RelationPersonAudit> relationPersonList = relationPersonauditDal.FindByCaseID(baseaduit.ID).ToList(); //if (relationPersonList != null && relationPersonList.Any()) //{ // foreach (var item in relationPersonList) // { // var relationbllModel = new RelationStateBLLModel() // { // Number = item.IdentificationNumber, // Desc = "Bind" // }; // relationstatebll.UpdateLockRelationState(relationbllModel); // } //} var pushResult = PushToHats(model.CaseNum); if (pushResult.IsSuccess) { bd.SubmitCase(db, CurrentUser.UserName, model.Description); bd.AcceptAllChange(); response.Status = "Success"; } else { response.Status = StatusEnum.Failed.ToString(); if (pushResult.Message.IsNullOrWhiteSpace() || pushResult.Message.IsNullOrWhiteSpace()) { response.Message = new ErrorMessage[] { new ErrorMessage("", "推送失败") }; } else { response.Message = new ErrorMessage[] { new ErrorMessage("", pushResult.Message) }; } } return(Json(response)); }
public void InsertHisCase() { var migDAL = new MigTDAL(); var personDAL = new RelationPersonAuditDAL(); var salesGroupDAL = new SalesGroupDAL(); var miglist = migDAL.GetAll(); if (miglist.Any()) { var salesGroups = salesGroupDAL.GetAll().ToList(); int i = 1; foreach (var mig in miglist) { var audit = new BaseAudit(); audit.ID = Guid.NewGuid().ToString(); audit.CaseNum = i.ToString("d6"); audit.BorrowerName = mig.CO2; audit.BankCard = mig.CO30; // 所属分公司名称 新的案件编号 switch (mig.CO4) { case "北京泓申": audit.SalesGroupID = salesGroups.First(x => x.Name == "北京泓申投资管理有限公司").ID; audit.DistrictID = salesGroups.First(x => x.Name == "北京泓申投资管理有限公司").DistrictID; audit.SalesID = "bff3003c-bfcb-4c34-898d-c9799db56e68"; break; case "诚驰": audit.SalesGroupID = salesGroups.First(x => x.Name == "上海诚驰泓申投资管理有限公司").ID; audit.DistrictID = salesGroups.First(x => x.Name == "上海诚驰泓申投资管理有限公司").DistrictID; audit.SalesID = "0d17d335-6c79-4130-82d5-16173c142911"; break; case "上海泓申": audit.SalesGroupID = salesGroups.First(x => x.Name == "上海泓申投资管理有限公司").ID; audit.DistrictID = salesGroups.First(x => x.Name == "上海泓申投资管理有限公司").DistrictID; audit.SalesID = "34965801-2ba7-4a80-a40b-7aff4f5c36a7"; break; case "铉宇": audit.SalesGroupID = salesGroups.First(x => x.Name == "上海铉宇金融信息服务有限公司").ID; audit.DistrictID = salesGroups.First(x => x.Name == "上海铉宇金融信息服务有限公司").DistrictID; audit.SalesID = "f68acef9-b478-4ab0-ac43-ccaf6bf77988"; break; case "银携": audit.SalesGroupID = salesGroups.First(x => x.Name == "上海银携投资管理有限公司").ID; audit.DistrictID = salesGroups.First(x => x.Name == "上海银携投资管理有限公司").DistrictID; audit.SalesID = "028bcc6f-dc7d-4994-9f2e-196b5cf974ad"; break; default: audit.NewCaseNum = "HIS" + "-" + audit.CaseNum; break; } audit.EarnestMoney = string.IsNullOrEmpty(mig.CO7) ? (decimal?)null : Convert.ToDecimal(mig.CO7); audit.LenderName = mig.CO8; audit.NewCaseNum = "HIS" + "-" + audit.CaseNum; // 客户贷款期数 switch (mig.CO9) { case "1": audit.Term = "-LoanTerm-1M"; break; case "2": audit.Term = "-LoanTerm-2M"; break; case "3": audit.Term = "-LoanTerm-3M"; break; case "4": audit.Term = "-LoanTerm-4M"; break; case "5": audit.Term = "-LoanTerm-5M"; break; case "6": audit.Term = "-LoanTerm-6M"; break; case "12": audit.Term = "-LoanTerm-12M"; break; case "24": audit.Term = "-LoanTerm-24M"; break; default: audit.Term = "-LoanTerm-2M"; break; break; } audit.AuditTerm = audit.Term; audit.LendingDate = string.IsNullOrEmpty(mig.CO10) ? default(DateTime?) : Convert.ToDateTime(mig.CO10); audit.PaymentDate = string.IsNullOrEmpty(mig.CO11) ? default(DateTime?) : Convert.ToDateTime(mig.CO11); audit.LoanAmount = string.IsNullOrEmpty(mig.CO13) ? default(decimal?) : Convert.ToDecimal(mig.CO13); audit.AuditAmount = audit.LoanAmount; audit.AnnualRate = string.IsNullOrEmpty(mig.CO14) ? null : (decimal?)Convert.ToDecimal(mig.CO14); audit.AuditRate = audit.AnnualRate; // 资金方名称 switch (mig.CO18) { case "点融": audit.ThirdParty = "-ThirdPlatform-DianRong"; break; case "聚财猫": audit.ThirdParty = "-ThirdPlatform-JuCaiMao"; break; case "米缸": audit.ThirdParty = "-ThirdPlatform-MiGang"; break; case "诺亚": audit.ThirdParty = "-ThirdPlatform-NuoYa"; break; case "挖财": audit.ThirdParty = "-ThirdPlatform-WaCai"; break; default: break; } audit.ThirdPartyAuditRate = string.IsNullOrEmpty(mig.CO19) ? null : (decimal?)Convert.ToDecimal(mig.CO19); audit.ThirdPartyAuditAmount = string.IsNullOrEmpty(mig.CO28) ? null : (decimal?)Convert.ToDecimal(mig.CO28); switch (mig.CO27) { case "1": audit.ThirdPartyAuditTerm = "-LoanTerm-1M"; break; case "2": audit.ThirdPartyAuditTerm = "-LoanTerm-2M"; break; case "3": audit.ThirdPartyAuditTerm = "-LoanTerm-3M"; break; case "4": audit.ThirdPartyAuditTerm = "-LoanTerm-4M"; break; case "5": audit.ThirdPartyAuditTerm = "-LoanTerm-5M"; break; case "6": audit.ThirdPartyAuditTerm = "-LoanTerm-6M"; break; case "12": audit.ThirdPartyAuditTerm = "-LoanTerm-12M"; break; case "24": audit.ThirdPartyAuditTerm = "-LoanTerm-24M"; break; default: break; } // 贷款模式 switch (mig.CO20) { case "居间": audit.CaseMode = "-CaseMode-JuJian"; break; case "债转": audit.CaseMode = "-CaseMode-ZhaiZhuan"; break; default: audit.CaseMode = "-CaseMode-ZiYouZiJin"; break; } audit.OpeningBank = mig.CO23; audit.BankCard = mig.CO26; audit.CaseDetail = mig.CO30; audit.CreateTime = DateTime.Now; audit.CreateUser = "******"; audit.CaseStatus = "After"; var person = new RelationPersonAudit(); person.ID = Guid.NewGuid().ToString(); person.AuditID = audit.ID; person.Name = mig.CO2; person.RelationType = "-PersonType-JieKuanRen"; switch (mig.CO5) { case "香港居民身份证": person.IdentificationType = "-DocType-HongKong"; break; case "身份证": person.IdentificationType = "-DocType-IDCard"; break; case "台湾同胞来往内地通行证": person.IdentificationType = "-DocType-Taiwan"; break; default: person.IdentificationType = "-DocType-Passport"; break; } person.IdentificationNumber = mig.CO6; personDAL.Add(person); var lend = new Com.HSJF.Framework.EntityFramework.Model.Lending.Lending(); var lenddal = new LendingDAL(); lend.ID = audit.ID; lend.Borrower = audit.BorrowerName; //lend.ContactNumber = mig.CO0; lend.ContractAmount = audit.AuditAmount; lend.CreateTime = DateTime.Now.ToShortDateString(); lend.CreateUser = "******"; lend.CustomerName = audit.BorrowerName; lend.LendTime = audit.LendingDate; lend.PaymentDay = string.IsNullOrEmpty(mig.CO12) ? default(int?) : Convert.ToInt32(mig.CO12); lenddal.Add(lend); _baseAuditDal.Add(audit); mig.Status = audit.NewCaseNum; migDAL.Update(mig); i++; } } _baseAuditDal.AcceptAllChange(); migDAL.AcceptAllChange(); }
private FinishedCaseViewModel Map(BaseAudit baseAudit) { var borrow = baseAudit.RelationPersonAudits.FirstOrDefault(t => t.RelationType == "-PersonType-JieKuanRen"); var firstContacter = borrow.IfNotNull(p => p.ContactAudits.FirstOrDefault(t => t.IsDefault)); var lendCase = new LendingDAL().Get(baseAudit.ID); var mortgage = new MortgageDAL().GetAll().Single(p => p.BaseAudit.CaseNum == baseAudit.CaseNum); var dictionaryDal = new DictionaryDAL(); var finishedCase = new FinishedCaseViewModel(); lendCase.CopyTo(finishedCase); finishedCase.ID = baseAudit.ID; finishedCase.CaseNum = baseAudit.CaseNum; finishedCase.CaseStatusText = CaseStatusHelper.GetBigStatusText(baseAudit.CaseStatus); finishedCase.IsCurrent = baseAudit.CaseStatus == CaseStatus.FinishCase; finishedCase.Borrower = borrow.IsNotNull() ? borrow.Name : ""; finishedCase.ContactNumber = firstContacter.IsNotNull() ? firstContacter.ContactNumber : ""; finishedCase.BankCard = baseAudit.BankCard; finishedCase.OpeningBank = baseAudit.OpeningBank; finishedCase.OpeningSite = baseAudit.OpeningSite; finishedCase.ContractAmount = mortgage.ContractAmount; finishedCase.SalesID = baseAudit.SalesID; finishedCase.SalesIDText = new SalesManDAL().FindBySalesID(baseAudit.SalesID).Name; finishedCase.Description = baseAudit.Description; finishedCase.CreateTime = baseAudit.CreateTime; finishedCase.ServiceCharge = baseAudit.ServiceCharge; finishedCase.ServiceChargeRate = baseAudit.ServiceChargeRate; finishedCase.Deposit = baseAudit.Deposit; finishedCase.DepositDate = baseAudit.DepositDate; finishedCase.IsActivitieRate = baseAudit.IsActivitieRate; finishedCase.IsActivitieRateText = dictionaryDal.GetText(baseAudit.IsActivitieRate.ToString()); finishedCase.Introducer = GetIntroducer(baseAudit); finishedCase.Merchandiser = baseAudit.Merchandiser; finishedCase.LenderName = baseAudit.LenderName; finishedCase.EarnestMoney = baseAudit.EarnestMoney; finishedCase.OutboundCost = baseAudit.OutboundCost; finishedCase.DebitNotarizationCost = baseAudit.DebitNotarizationCost; finishedCase.DebitEvaluationCost = baseAudit.DebitEvaluationCost; finishedCase.DebitGuaranteeCost = baseAudit.DebitGuaranteeCost; finishedCase.DebitInsuranceCost = baseAudit.DebitInsuranceCost; finishedCase.DebitOtherCost = baseAudit.DebitOtherCost; finishedCase.LevyNotarizationCost = baseAudit.LevyNotarizationCost; finishedCase.LevyAssetsSurveyCost = baseAudit.LevyAssetsSurveyCost; finishedCase.LevyCreditReportCost = baseAudit.LevyCreditReportCost; finishedCase.LevyOtherCost = baseAudit.LevyOtherCost; finishedCase.CaseMode = baseAudit.CaseMode; finishedCase.CaseModeText = dictionaryDal.GetText(baseAudit.CaseMode); finishedCase.ThirdParty = baseAudit.ThirdParty; finishedCase.ThirdPartyText = dictionaryDal.GetText(baseAudit.ThirdParty); finishedCase.MonthlyInterest = baseAudit.MonthlyInterest; finishedCase.LendingDate = baseAudit.LendingDate; finishedCase.PaymentDate = baseAudit.PaymentDate; finishedCase.ActualInterest = baseAudit.ActualInterest; finishedCase.AdvanceInterest = baseAudit.AdvanceInterest; finishedCase.AuditTerm = baseAudit.AuditTerm; finishedCase.AuditTermText = dictionaryDal.GetText(baseAudit.AuditTerm); finishedCase.AuditRate = baseAudit.AuditRate; finishedCase.LendFileName = GetFiles(finishedCase.LendFile); return(finishedCase); }