/// <summary>
/// 保存被执行人信息集合
/// </summary>
/// <param name="enforcementPerson"></param>
/// <param name="auditId"></param>
public void SaveEnforcementPerson(BaseAudit baseAudit, BaseAudit newAudit, RelationPersonAudit oldperson, RelationPersonAudit newperson)
{
var entCRList = new List <EnforcementPerson>();
var enforce = baseAudit.EnforcementPersons.Where(t => t.PersonID == oldperson.ID);
if (!enforce.Any())
{
return;
}
foreach (var model in enforce)
{
var entity = new EnforcementPerson();
entity.ID = Guid.NewGuid().ToString();
entity.BaseAuditID = newAudit.ID;
entity.BadNews = model.BadNews;
entity.EnforcementWeb = model.EnforcementWeb;
entity.LawXP = model.LawXP;
entity.ShiXin = model.ShiXin;
entity.TrialRecord = model.TrialRecord;
entity.PersonID = newperson.ID;
entity.Sequence = model.Sequence;
entity.AttachmentFile = model.AttachmentFile;
entCRList.Add(entity); //保存被执行人信息
}
enforcementPersonDAL.AddRange(entCRList);
}
/// <summary>
/// 保存个人资信信息集合
/// </summary>
/// <param name="Collaterals"></param>
/// <param name="auditId"></param>
public void SaveIndividualCredit(BaseAudit baseAudit, BaseAudit newAudit, RelationPersonAudit oldperson, RelationPersonAudit newperson)
{
var indList = new List <IndividualCredit>();
var indiv = baseAudit.IndividualCredits.Where(t => t.PersonID == oldperson.ID);
if (!indiv.Any())
{
return;
}
foreach (var model in indiv)
{
var entity = new IndividualCredit();
entity.ID = Guid.NewGuid().ToString();
entity.BaseAuditID = newAudit.ID;
entity.CreditCard = model.CreditCard;
entity.CreditInfo = model.CreditInfo;
entity.OtherCredit = model.OtherCredit;
entity.OverdueInfo = model.OverdueInfo;
entity.PersonID = newperson.ID;
entity.IndividualFile = SaveFiles(model.IndividualFile, entity.ID, newAudit.ID);
entity.BankFlowFile = SaveFiles(model.BankFlowFile, entity.ID, newAudit.ID);
entity.Sequence = model.Sequence;
indList.Add(entity); //保存个人资信信息
}
individualCreditDAL.AddRange(indList);
}
/// <summary>
/// 关系人相关企业信息集合
/// </summary>
/// <param name="relationEnterprises"></param>
/// <param name="personId"></param>
public IEnumerable <RelationEnterpriseAudit> SaveRelationEnterprises(RelationPersonAudit oldperson, RelationPersonAudit newperson, BaseAudit baseaudit, BaseAudit newaudit)
{
var entList = new List <RelationEnterpriseAudit>();
foreach (var model in oldperson.RelationEnterpriseAudits)
{
RelationEnterpriseAudit entity = new RelationEnterpriseAudit();
entity.ID = Guid.NewGuid().ToString();
entity.PersonID = newperson.ID;
entity.Address = model.Address;
entity.EnterpriseDes = model.EnterpriseDes;
entity.EnterpriseName = model.EnterpriseName;
entity.LegalPerson = model.LegalPerson;
entity.MainBusiness = model.MainBusiness;
entity.RegisteredCapital = model.RegisteredCapital;
entity.RegisterNumber = model.RegisterNumber;
entity.ShareholderDetails = model.ShareholderDetails;
entity.BankFlowFile = SaveFiles(model.BankFlowFile, entity.ID, newaudit.ID);
entity.IndividualFile = SaveFiles(model.IndividualFile, entity.ID, newaudit.ID);
entity.Sequence = model.Sequence;
// 保存企业资信信息集合
SaveEnterpriseCredit(baseaudit, newaudit, model, entity);
// 保存工商税务信息集合
SaveIndustryCommerceTax(baseaudit, newaudit, model, entity);
entList.Add(entity);
}
relationEnterpriseAuditDAL.AddRange(entList);
return(entList);
}
/// <summary>
/// 保存关系人紧急联系人信息集合
/// </summary>
/// <param name="emergencyContacts"></param>
/// <param name="personId"></param>
public IEnumerable <EmergencyContactAudit> SaveEmergencyContacts(RelationPersonAudit oldperson, RelationPersonAudit newperson)
{
var emerList = new List <EmergencyContactAudit>();
foreach (var model in oldperson.EmergencyContactAudits)
{
EmergencyContactAudit entity = new EmergencyContactAudit();
entity.ID = Guid.NewGuid().ToString();
entity.PersonID = newperson.ID;
entity.ContactNumber = model.ContactNumber;
entity.ContactType = model.ContactType;
entity.Name = model.Name;
entity.Sequence = model.Sequence;
emerList.Add(entity);
}
emergencyContactAuditDAL.AddRange(emerList);
return(emerList);
}
/// <summary>
/// 保存关系人地址信息集合
/// </summary>
/// <param name="address"></param>
/// <param name="personId"></param>
public IEnumerable <AddressAudit> SaveAddresses(RelationPersonAudit oldperson, RelationPersonAudit newperson)
{
var addressList = new List <AddressAudit>();
foreach (var model in oldperson.AddressAudits)
{
AddressAudit entity = new AddressAudit();
entity.ID = Guid.NewGuid().ToString();
entity.PersonID = newperson.ID;
entity.AddressInfo = model.AddressInfo;
entity.AddressType = model.AddressType;
entity.IsDefault = model.IsDefault;
entity.Sequence = model.Sequence;
addressList.Add(entity);
}
newperson.AddressAudits = addressList;
addressAuditDAL.AddRange(addressList);
return(addressList);
}
public void SaveRelationPersons <T>(ICollection <RelationPerson> relationPersons, string auditId)
where T : class, new()
{
Type type = typeof(T);
if (type.Equals(typeof(RelationPersonAudit)))
{
RelationPersonAuditDAL rpDAL = new RelationPersonAuditDAL();
foreach (var model in relationPersons)
{
#region 关系人信息集合
RelationPersonAudit rpModel = new RelationPersonAudit()
{
ID = Guid.NewGuid().ToString(),
AuditID = auditId,
RelationType = model.RelationType,
BorrowerRelation = model.BorrowerRelation,
Name = model.Name,
IdentificationType = model.IdentificationType,
IdentificationNumber = model.IdentificationNumber,
ExpiryDate = model.ExpiryDate,
Birthday = model.Birthday,
MaritalStatus = model.MaritalStatus,
SalaryDescription = model.SalaryDescription,
Warranty = model.Warranty,
IsCoBorrower = model.IsCoBorrower,
Sequence = model.Sequence
};
// 上传身份证复印件
rpModel.IdentificationFile = SaveFiles(model.IdentificationFile, rpModel.ID, auditId);
// 上传婚姻证明文件保存
rpModel.MarryFile = SaveFiles(model.MarryFile, rpModel.ID, auditId);
// 上传单身证明文件保存
rpModel.SingleFile = SaveFiles(model.SingleFile, rpModel.ID, auditId);
// 上传出生证明文件保存
rpModel.BirthFile = SaveFiles(model.BirthFile, rpModel.ID, auditId);
// 上传户口本复印件文件保存
rpModel.AccountFile = SaveFiles(model.AccountFile, rpModel.ID, auditId);
// 上传收入证明（受薪水人士）文件保存
rpModel.SalaryPersonFile = SaveFiles(model.SalaryPersonFile, rpModel.ID, auditId);
// 上传收入证明（自雇有执照）文件保存
rpModel.SelfLicenseFile = SaveFiles(model.SelfLicenseFile, rpModel.ID, auditId);
// 上传收入证明（自雇无执照）文件保存
rpModel.SelfNonLicenseFile = SaveFiles(model.SelfNonLicenseFile, rpModel.ID, auditId);
// 银行流水
rpModel.BankFlowFile = SaveFiles(model.BankFlowFile, rpModel.ID, auditId);
// 个人征信
rpModel.IndividualFile = SaveFiles(model.IndividualFile, rpModel.ID, auditId);
// 其他证明
rpModel.OtherFile = SaveFiles(model.OtherFile, rpModel.ID, auditId);
rpDAL.Add(rpModel);
#endregion 关系人信息集合
#region 保存关系人地址信息集合
SaveAddresses <AddressAudit>(model.Addresses, rpModel.ID);
#endregion 保存关系人地址信息集合
#region 保存关系人紧急联系人信息集合
SaveEmergencyContacts <EmergencyContactAudit>(model.EmergencyContacts, rpModel.ID);
#endregion 保存关系人紧急联系人信息集合
#region 保存关系人联系方式信息集合
SaveContacts <ContactAudit>(model.Contacts, rpModel.ID);
#endregion 保存关系人联系方式信息集合
#region 关系人相关企业信息集合
SaveRelationEnterprises <RelationEnterpriseAudit>(model.RelationEnterprises, rpModel.ID, auditId);
#endregion 关系人相关企业信息集合
}
}
else if (type.Equals(typeof(RelationPerson)))
{
RelationPersonDAL rpDAL = new RelationPersonDAL();
foreach (var model in relationPersons)
{
#region 关系人信息集合
RelationPerson rpModel = new RelationPerson()
{
ID = Guid.NewGuid().ToString(),
RelationType = model.RelationType,
BorrowerRelation = model.BorrowerRelation,
Name = model.Name,
IdentificationType = model.IdentificationType,
IdentificationNumber = model.IdentificationNumber,
ExpiryDate = model.ExpiryDate,
Birthday = model.Birthday,
MaritalStatus = model.MaritalStatus,
SalaryDescription = model.SalaryDescription,
Warranty = model.Warranty,
IsCoBorrower = model.IsCoBorrower,
CaseID = auditId,
Sequence = model.Sequence
};
// 上传身份证复印件
rpModel.IdentificationFile = SaveFiles(model.IdentificationFile, rpModel.ID, auditId);
// 上传婚姻证明文件保存
rpModel.MarryFile = SaveFiles(model.MarryFile, rpModel.ID, auditId);
// 上传单身证明文件保存
rpModel.SingleFile = SaveFiles(model.SingleFile, rpModel.ID, auditId);
// 上传出生证明文件保存
rpModel.BirthFile = SaveFiles(model.BirthFile, rpModel.ID, auditId);
// 上传户口本复印件文件保存
rpModel.AccountFile = SaveFiles(model.AccountFile, rpModel.ID, auditId);
// 上传收入证明（受薪水人士）文件保存
rpModel.SalaryPersonFile = SaveFiles(model.SalaryPersonFile, rpModel.ID, auditId);
// 上传收入证明（自雇有执照）文件保存
rpModel.SelfLicenseFile = SaveFiles(model.SelfLicenseFile, rpModel.ID, auditId);
// 上传收入证明（自雇无执照）文件保存
rpModel.SelfNonLicenseFile = SaveFiles(model.SelfNonLicenseFile, rpModel.ID, auditId);
// 银行流水
rpModel.BankFlowFile = SaveFiles(model.BankFlowFile, rpModel.ID, auditId);
// 个人征信
rpModel.IndividualFile = SaveFiles(model.IndividualFile, rpModel.ID, auditId);
// 其他证明
rpModel.OtherFile = SaveFiles(model.OtherFile, rpModel.ID, auditId);
rpDAL.Add(rpModel);
#endregion 关系人信息集合
#region 保存关系人地址信息集合
SaveAddresses <Address>(model.Addresses, rpModel.ID);
#endregion 保存关系人地址信息集合
#region 保存关系人紧急联系人信息集合
SaveEmergencyContacts <EmergencyContact>(model.EmergencyContacts, rpModel.ID);
#endregion 保存关系人紧急联系人信息集合
#region 保存关系人联系方式信息集合
SaveContacts <Contact>(model.Contacts, rpModel.ID);
#endregion 保存关系人联系方式信息集合
#region 关系人相关企业信息集合
SaveRelationEnterprises <RelationEnterprise>(model.RelationEnterprises, rpModel.ID, auditId);
#endregion 关系人相关企业信息集合
}
}
}
/// <summary>
/// 保存关系人信息集合
/// </summary>
/// <param name="RelationPersons"></param>
/// <param name="auditId"></param>
public void SaveRelationPersons(ICollection <RelationPerson> relationPersons, string auditId)
{
RelationPersonAuditDAL rpDAL = new RelationPersonAuditDAL();
foreach (var model in relationPersons)
{
RelationPersonAudit rpModel = new RelationPersonAudit();
#region 关系人信息集合
rpModel.ID = Guid.NewGuid().ToString();
rpModel.AuditID = auditId;
rpModel.RelationType = model.RelationType;
rpModel.BorrowerRelation = model.BorrowerRelation;
rpModel.Name = model.Name;
rpModel.IdentificationType = model.IdentificationType;
rpModel.IdentificationNumber = model.IdentificationNumber;
rpModel.ExpiryDate = model.ExpiryDate;
rpModel.Birthday = model.Birthday;
rpModel.MaritalStatus = model.MaritalStatus;
rpModel.SalaryDescription = model.SalaryDescription;
rpModel.Warranty = model.Warranty;
rpModel.IsCoBorrower = model.IsCoBorrower;
rpModel.Sequence = model.Sequence;
// 上传身份证复印件
rpModel.IdentificationFile = SaveFiles(model.IdentificationFile, rpModel.ID, auditId);
// 上传婚姻证明文件保存
rpModel.MarryFile = SaveFiles(model.MarryFile, rpModel.ID, auditId);
// 上传单身证明文件保存
rpModel.SingleFile = SaveFiles(model.SingleFile, rpModel.ID, auditId);
// 上传出生证明文件保存
rpModel.BirthFile = SaveFiles(model.BirthFile, rpModel.ID, auditId);
// 上传户口本复印件文件保存
rpModel.AccountFile = SaveFiles(model.AccountFile, rpModel.ID, auditId);
// 上传收入证明（受薪水人士）文件保存
rpModel.SalaryPersonFile = SaveFiles(model.SalaryPersonFile, rpModel.ID, auditId);
// 上传收入证明（自雇有执照）文件保存
rpModel.SelfLicenseFile = SaveFiles(model.SelfLicenseFile, rpModel.ID, auditId);
// 上传收入证明（自雇无执照）文件保存
rpModel.SelfNonLicenseFile = SaveFiles(model.SelfNonLicenseFile, rpModel.ID, auditId);
// 银行流水
rpModel.BankFlowFile = SaveFiles(model.BankFlowFile, rpModel.ID, auditId);
// 个人征信
rpModel.IndividualFile = SaveFiles(model.IndividualFile, rpModel.ID, auditId);
// 其他证明
rpModel.OtherFile = SaveFiles(model.OtherFile, rpModel.ID, auditId);
rpDAL.Add(rpModel);
#endregion 关系人信息集合
#region 保存关系人地址信息集合
SaveAddresses(model.Addresses, rpModel.ID);
#endregion 保存关系人地址信息集合
#region 保存关系人紧急联系人信息集合
SaveEmergencyContacts(model.EmergencyContacts, rpModel.ID);
#endregion 保存关系人紧急联系人信息集合
#region 保存关系人联系方式信息集合
SaveContacts(model.Contacts, rpModel.ID);
#endregion 保存关系人联系方式信息集合
#region 关系人相关企业信息集合
SaveRelationEnterprises <RelationEnterpriseAudit>(model.RelationEnterprises, rpModel.ID, auditId);
#endregion 关系人相关企业信息集合
}
}
// todo switch to private method
public IEnumerable <AfterCase> GetAfterCaseByData(DateTime startTime, DateTime?endTime)
{
IQueryable <BaseAudit> baseAudits = GetAllAfterCases().Where(p => p.CreateTime >= startTime);
if (endTime.HasValue)
{
baseAudits = baseAudits.Where(p => p.CreateTime < endTime);
}
baseAudits = baseAudits.OrderBy(p => p.CreateTime);
var afterCases = new List <AfterCase>();
List <Dictionary> dictionaries = _dictionaryBll.QueryByParentKey("-ThirdPlatform").ToList();
foreach (var audit in baseAudits)
{
// 获取借款人
RelationPersonAudit customer = _relationPersonAuditDal.GetAll().Single(p => p.AuditID == audit.ID && p.RelationType == "-PersonType-JieKuanRen");
Lending lendingInfo = audit.NewCaseNum.Contains("HIS") ? _lendingDal.GetHIS(audit.ID) : _lendingDal.Get(audit.ID);
SalesGroup salesGroup = _salesGroupDal.GetAll().Single(p => p.ID == audit.SalesGroupID);
PublicMortgage mortgage = _mortgageBll.Query(audit.NewCaseNum);
var fundDictionary = dictionaries.FirstOrDefault(p => p.Path == audit.ThirdParty);
// 借款人和共同借款人
var debtNames =
_relationPersonAuditDal.GetAll()
.Where(
p =>
p.AuditID == audit.ID &&
(p.RelationType == "-PersonType-JieKuanRen" || p.IsCoBorrower == 1)).Select(p => p.Name);
var afterase = new AfterCase();
afterase.CaseNum = audit.NewCaseNum;
afterase.SalesGrouptId = salesGroup.CompanyCode;
afterase.SalesCompanyName = salesGroup.Company;
afterase.CompanyCode = salesGroup.Company.PadRight(4).Substring(0, 4);
afterase.CustomerId = customer.ID;
afterase.CustomerName = audit.BorrowerName;
afterase.CustomerIdentificationType = customer.IdentificationType;
afterase.CustomerIdentificationNumber = customer.IdentificationNumber;
afterase.AccountName = audit.OpeningSite ?? string.Empty;
afterase.EarnestMoney = audit.CustEarnestMoney.ToString();
afterase.DebtName = string.Join(",", debtNames.ToArray());
afterase.LenderName = audit.LenderName ?? string.Empty;
afterase.LoanTerm = audit.AuditTerm ?? string.Empty;
afterase.LendingDate = lendingInfo.LendTime == null ? "" : lendingInfo.LendTime.ToString();
afterase.PaymentDay = lendingInfo.PaymentDay == null ? "" : lendingInfo.PaymentDay.ToString();
afterase.ContractAmount = audit.NewCaseNum.Contains("HIS") ? lendingInfo.ContractAmount.ToString() : mortgage.ContractAmount.ToString();
afterase.ContractInterestRate = CONTRACT_INTEREST_RATE;
afterase.RealInterestRate = audit.AuditRate > 2M ? audit.AuditRate.ToString() : (audit.AuditRate * 12).ToString(); // 审计利率*12=实际年利率
afterase.ReceiveType = RECEIVE_TYPE;
afterase.FundId = audit.ThirdParty ?? string.Empty;
afterase.FundInterestRate = GetThirdPartyRate(audit);
afterase.FundName = fundDictionary == null ? string.Empty : fundDictionary.Text;
// 债转资金当作自有资金处理
afterase.LoadType = audit.CaseMode == DictionaryType.CaseMode.ZhaiZhuan ? DictionaryType.CaseMode.ZiYouZiJin : audit.CaseMode;
afterase.VirtualAccount = "";
afterase.ContractNum = mortgage.ContractNo;
afterCases.Add(afterase);
}
return(afterCases);
}
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();
}
//public void SavePublic(string id, string newid, string creatUser)
//{
// MortgageDAL mort = new MortgageDAL();
// var morimodel = mort.GetPublic(id);
// if (morimodel == null)
// {
// return;
// }
// var pubMort = new PublicMortgage()
// {
// CreateTime = DateTime.Now,
// ID = newid,
// CreateUser = creatUser,
// ContractFile = morimodel.ContractFile,
// NoteFile = morimodel.NoteFile,
// ReceiptFile = morimodel.ReceiptFile,
// OtherFile = morimodel.OtherFile,
// FourFile = morimodel.FourFile,
// ContractNo = morimodel.ContractNo,
// ContractAmount = morimodel.ContractAmount,
// ContractDate = morimodel.ContractDate,
// ContractPerson = morimodel.ContractPerson,
// UndertakingFile = morimodel.UndertakingFile,
// RepaymentAttorneyFile = morimodel.RepaymentAttorneyFile,
// ContactConfirmFile = morimodel.ContactConfirmFile,
// PowerAttorneyFile = morimodel.PowerAttorneyFile,
// CollectionFile = morimodel.CollectionFile,
// };
// mort.Add(pubMort);
//}
/// <summary>
/// 保存关系人信息集合
/// </summary>
/// <param name="RelationPersons"></param>
/// <param name="auditId"></param>
public IEnumerable <RelationPersonAudit> SaveRelationPersons(BaseAudit baseaudit, BaseAudit newaudit)
{
RelationPersonAuditDAL rpDAL = new RelationPersonAuditDAL();
var personList = new List <RelationPersonAudit>();
foreach (var model in baseaudit.RelationPersonAudits)
{
RelationPersonAudit entity = new RelationPersonAudit();
#region 关系人信息集合
entity.ID = Guid.NewGuid().ToString();
entity.AuditID = newaudit.ID;
entity.Birthday = model.Birthday;
entity.ExpiryDate = model.ExpiryDate;
entity.IdentificationNumber = model.IdentificationNumber;
entity.IdentificationType = model.IdentificationType;
entity.MaritalStatus = model.MaritalStatus;
entity.Name = model.Name;
entity.RelationType = model.RelationType;
entity.SalaryDescription = model.SalaryDescription;
entity.BorrowerRelation = model.BorrowerRelation;
entity.IsCoBorrower = model.IsCoBorrower;
entity.Warranty = model.Warranty;
entity.Sequence = model.Sequence;
// 上传身份证复印件
entity.IdentificationFile = SaveFiles(model.IdentificationFile, entity.ID, newaudit.ID);
// 上传婚姻证明文件保存
entity.MarryFile = SaveFiles(model.MarryFile, entity.ID, newaudit.ID);
// 上传单身证明文件保存
entity.SingleFile = SaveFiles(model.SingleFile, entity.ID, newaudit.ID);
// 上传出生证明文件保存
entity.BirthFile = SaveFiles(model.BirthFile, entity.ID, newaudit.ID);
// 上传户口本复印件文件保存
entity.AccountFile = SaveFiles(model.AccountFile, entity.ID, newaudit.ID);
// 上传收入证明（受薪水人士）文件保存
entity.SalaryPersonFile = SaveFiles(model.SalaryPersonFile, entity.ID, newaudit.ID);
// 上传收入证明（自雇有执照）文件保存
entity.SelfLicenseFile = SaveFiles(model.SelfLicenseFile, entity.ID, newaudit.ID);
// 上传收入证明（自雇无执照）文件保存
entity.SelfNonLicenseFile = SaveFiles(model.SelfNonLicenseFile, entity.ID, newaudit.ID);
// 银行流水
entity.BankFlowFile = SaveFiles(model.BankFlowFile, entity.ID, newaudit.ID);
// 个人征信报告
entity.IndividualFile = SaveFiles(model.IndividualFile, entity.ID, newaudit.ID);
// 其他证明
entity.OtherFile = SaveFiles(model.OtherFile, entity.ID, newaudit.ID);
SaveAddresses(model, entity);
SaveEmergencyContacts(model, entity);
SaveContacts(model, entity);
SaveRelationEnterprises(model, entity, baseaudit, newaudit);
// 保存个人资信信息集合
SaveIndividualCredit(baseaudit, newaudit, model, entity);
// 保存被执行人信息集合
SaveEnforcementPerson(baseaudit, newaudit, model, entity);
personList.Add(entity);
}
relationPersonAuditDAL.AddRange(personList);
return(personList);
}
