/// <summary> /// 进件提交审核 /// </summary> /// <param name="caseId">进件ID</param> /// <param name="creatUser">创建人</param> /// <returns></returns> public bool SubmitBaseCase(string caseId, string creatUser) { var baseCase = Get(caseId);//进件信息 if (baseCase != null) { BaseAuditDAL baseAuditDal = new BaseAuditDAL(); #region 审核主表信息 BaseAudit baseAudit = new BaseAudit(); baseAudit.ID = Guid.NewGuid().ToString(); baseAudit.Version = 0; baseAudit.BorrowerName = baseCase.BorrowerName; baseAudit.CaseNum = baseCase.CaseNum; baseAudit.NewCaseNum = baseCase.NewCaseNum; baseAudit.AnnualRate = baseCase.AnnualRate; baseAudit.CaseType = baseCase.CaseType; baseAudit.CreateTime = DateTime.Now; baseAudit.CreateUser = creatUser; baseAudit.LoanAmount = baseCase.LoanAmount; baseAudit.DistrictID = baseCase.DistrictID; baseAudit.SalesGroupID = baseCase.SalesGroupID; baseAudit.SalesID = baseCase.SalesID; baseAudit.CaseStatus = CaseStatus.FirstAudit; baseAudit.Term = baseCase.Term; baseAudit.OpeningBank = baseCase.OpeningBank; baseAudit.OpeningSite = baseCase.OpeningSite; baseAudit.BankCard = baseCase.BankCard; baseAudit.ServiceCharge = baseCase.ServiceCharge; baseAudit.ServiceChargeRate = baseCase.ServiceChargeRate; baseAudit.Deposit = baseCase.Deposit; baseAudit.DepositDate = baseCase.DepositDate; baseAudit.IsActivitieRate = baseCase.IsActivitieRate; baseAudit.PaymentFactor = baseCase.PaymentFactor; //还款来源 baseAudit.Purpose = baseCase.Purpose; //借款用途 baseAuditDal.Add(baseAudit); #endregion 审核主表信息 #region 保存抵押物信息 SaveCollaterals <CollateralAudit>(baseCase.Collaterals, baseAudit.ID); #endregion 保存抵押物信息 #region 保存关系人信息集合 SaveRelationPersons <RelationPersonAudit>(baseCase.RelationPersons, baseAudit.ID); #endregion 保存关系人信息集合 #region 保存介绍人信息集合 SaveIntroducers <IntroducerAudit>(baseCase.Introducers, baseAudit.ID); #endregion 保存介绍人信息集合 baseAuditDal.AcceptAllChange(); return(true); } else { return(false); } }
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(); }