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