/// <summary>
/// 根据案件号查询签约信息
/// </summary>
/// <param name="caseNum">案件号</param>
/// <returns>签约信息</returns>
public PublicMortgage Query(string caseNum)
{
var baseaudit = _baseAuditDal.GetbyCaseSataus(caseNum, CaseStatus.PublicMortgage);
//var baseaudit = _baseAuditDal.GetAllBase().AsNoTracking().OrderByDescending(p => p.Version).FirstOrDefault(p => p.NewCaseNum == caseNum && p.CaseStatus == CaseStatus.PublicMortgage);
if (baseaudit.IsNotNull())
{
return(_mortgageDal.GetAll().AsNoTracking().FirstOrDefault(p => p.ID == baseaudit.ID));
}
return(null);
}
/// <summary>
/// 签约-承诺书/联系方式确认书/借条/收据 合并为 四条
/// jira(HEAS-225)
/// </summary>
public void MortgageFileMerge()
{
var mortages = _mortgageDal.GetAll().AsNoTracking().ToList();
mortages.ForEach(m =>
{
m.BaseAudit = null;
m.NoteFile = null;
if (m.NoteFile.IsNotNullOrEmpty() && m.NoteFile.IsNotNullOrWhiteSpace())
{
m.FourFile = FileJoin(m.FourFile, m.NoteFile);
}
if (m.ReceiptFile.IsNotNullOrEmpty() && m.ReceiptFile.IsNotNullOrWhiteSpace())
{
m.FourFile = FileJoin(m.FourFile, m.ContactConfirmFile);
}
if (m.UndertakingFile.IsNotNullOrEmpty() && m.UndertakingFile.IsNotNullOrWhiteSpace())
{
m.FourFile = FileJoin(m.FourFile, m.UndertakingFile);
}
if (m.ContactConfirmFile.IsNotNullOrEmpty() && m.ContactConfirmFile.IsNotNullOrWhiteSpace())
{
m.FourFile = FileJoin(m.FourFile, m.ReceiptFile);
}
});
_mortgageDal.UpdateRange(mortages);
_mortgageDal.AcceptAllChange();
}
/// <summary>
/// 获取签约合同
/// </summary>
/// <param name="audits">审计案件</param>
/// <returns>签约合同</returns>
private IEnumerable <PublicMortgage> GetMortgages(IEnumerable <BaseAudit> audits)
{
var currenStateCase = audits.Where(p => p.CaseStatus == CaseStatus.PublicMortgage);
string[] currentCaseNums = currenStateCase.Select(p => p.NewCaseNum).ToArray();
var publicCases =
audits.Where(p => p.CaseStatus == CaseStatus.PublicMortgage && currentCaseNums.Contains(p.NewCaseNum));
string[] publicCaseIds = publicCases.Select(p => p.ID).ToArray();
return(_mortgageDal.GetAll().Where(p => publicCaseIds.Contains(p.ID)));
}
/// <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 LendingViewModel CastModel(Lending model)
{
BaseAuditDAL bad = new BaseAuditDAL();
MortgageDAL md = new MortgageDAL();
var dicdal = new DictionaryDAL();
var baseaudit = bad.Get(model.ID);
var maxaudit = bad.GetMaxAudit(model.ID);
var minaudit = bad.GetMinAudit(model.ID);
var borrower = maxaudit.RelationPersonAudits.FirstOrDefault(t => t.RelationType == "-PersonType-JieKuanRen");
var mor = md.GetAll().FirstOrDefault(t => t.BaseAudit.NewCaseNum == maxaudit.NewCaseNum);
var baseauditRelaType = "";
var maxauditRelaType = "";
if (baseaudit != null)
{
if (!string.IsNullOrEmpty(baseaudit.OpeningSite))
{
var baseauditRela = baseaudit.RelationPersonAudits.FirstOrDefault(t => t.IdentificationNumber == baseaudit.OpeningSite);
if (baseauditRela != null)
{
baseauditRelaType = baseauditRela.Name + "(" + dicdal.GetText(baseauditRela.RelationType) + ")";
}
}
}
if (maxaudit != null)
{
if (!string.IsNullOrEmpty(maxaudit.OpeningSite))
{
var maxauditRela = maxaudit.RelationPersonAudits.FirstOrDefault(t => t.IdentificationNumber == maxaudit.OpeningSite);
if (maxauditRela != null)
{
maxauditRelaType = maxauditRela.Name + "(" + dicdal.GetText(maxauditRela.RelationType) + ")";
}
}
}
LendingViewModel bcvm = new LendingViewModel();
Com.HSJF.Infrastructure.ExtendTools.ObjectExtend.CopyTo(model, bcvm);
bcvm.CaseNum = baseaudit == null ? maxaudit == null ? "" : maxaudit.NewCaseNum : baseaudit.NewCaseNum;
bcvm.CaseStatus = baseaudit == null ? maxaudit == null ? "" : maxaudit.CaseStatus : baseaudit.CaseStatus;
bcvm.CaseStatusText = baseaudit == null ? maxaudit == null ? "" : Com.HSJF.HEAS.Web.Helper.CaseStatusHelper.GetStatsText(maxaudit.CaseStatus) : Com.HSJF.HEAS.Web.Helper.CaseStatusHelper.GetStatsText(baseaudit.CaseStatus);
bcvm.IsCurrent = baseaudit == null ? false : (baseaudit.CaseStatus == Com.HSJF.Framework.DAL.CaseStatus.Lending) ? true : false;
//[Display(Name = "进件提交日期")]
bcvm.CreateTime = baseaudit == null ? maxaudit == null ? null : maxaudit.CreateTime : baseaudit.CreateTime;
bcvm.Borrower = borrower.Name;
bcvm.ContactNumber = borrower.ContactAudits.FirstOrDefault(t => t.IsDefault) == null ? "" : borrower.ContactAudits.FirstOrDefault(t => t.IsDefault).ContactNumber;
bcvm.BankCard = baseaudit == null ? maxaudit == null ? null : maxaudit.BankCard : baseaudit.BankCard;
bcvm.OpeningBank = baseaudit == null ? maxaudit == null ? null : maxaudit.OpeningBank : baseaudit.OpeningBank;
bcvm.OpeningSite = baseaudit == null ? maxaudit == null ? null : maxaudit.OpeningSite : baseaudit.OpeningSite;
bcvm.OpeningSiteText = baseaudit == null ? maxaudit == null ? null : maxauditRelaType : baseauditRelaType;
bcvm.ContractAmount = mor == null ? null : mor.ContractAmount;
bcvm.SalesID = baseaudit == null ? maxaudit == null ? null : maxaudit.SalesID : baseaudit.SalesID;
// [Display(Name = "服务费") 自动计算=放款金额*服务费率]
bcvm.ServiceCharge = baseaudit == null ? maxaudit == null ? null : mor.ContractAmount * (maxaudit.ServiceChargeRate / 100) : mor.ContractAmount * (baseaudit.ServiceChargeRate / 100);
// [Display(Name = "服务费点数")]
bcvm.ServiceChargeRate = baseaudit == null ? maxaudit == null ? null : maxaudit.ServiceChargeRate : baseaudit.ServiceChargeRate;
// [Display(Name = "客户已支付金额")]
bcvm.Deposit = baseaudit == null ? maxaudit == null ? null : maxaudit.Deposit : baseaudit.Deposit;
// [Display(Name = "客户支付定金日期")]
bcvm.DepositDate = baseaudit == null ? maxaudit == null ? null : maxaudit.DepositDate : baseaudit.DepositDate;
// [Display(Name = "是否为活动期间的优惠利率")]
bcvm.IsActivitieRate = baseaudit == null ? maxaudit == null ? null : maxaudit.IsActivitieRate : baseaudit.IsActivitieRate;
// [Display(Name = "跟单人")]
bcvm.Merchandiser = baseaudit == null ? maxaudit == null ? null : maxaudit.Merchandiser : baseaudit.Merchandiser;
// [Display(Name = "出借人姓名")]
bcvm.LenderName = baseaudit == null ? maxaudit == null ? null : maxaudit.LenderName : baseaudit.LenderName;
// [Display(Name = "保证金")]
bcvm.EarnestMoney = baseaudit == null ? maxaudit == null ? null : maxaudit.EarnestMoney : baseaudit.EarnestMoney;
// [Display(Name = "外访费（下户费）")]
bcvm.OutboundCost = baseaudit == null ? maxaudit == null ? null : maxaudit.OutboundCost : baseaudit.OutboundCost;
// [Display(Name = "代收公证费用")]
bcvm.DebitNotarizationCost = baseaudit == null ? maxaudit == null ? null : maxaudit.DebitNotarizationCost : baseaudit.DebitNotarizationCost;
// [Display(Name = "代收评估费")]
bcvm.DebitEvaluationCost = baseaudit == null ? maxaudit == null ? null : maxaudit.DebitEvaluationCost : baseaudit.DebitEvaluationCost;
// [Display(Name = "代收担保费")]
bcvm.DebitGuaranteeCost = baseaudit == null ? maxaudit == null ? null : maxaudit.DebitGuaranteeCost : baseaudit.DebitGuaranteeCost;
// [Display(Name = "代收保险费")]
bcvm.DebitInsuranceCost = baseaudit == null ? maxaudit == null ? null : maxaudit.DebitInsuranceCost : baseaudit.DebitInsuranceCost;
// [Display(Name = "代收其他")]
bcvm.DebitOtherCost = baseaudit == null ? maxaudit == null ? null : maxaudit.DebitOtherCost : baseaudit.DebitOtherCost;
// [Display(Name = "公司承担的公证费")]
bcvm.LevyNotarizationCost = baseaudit == null ? maxaudit == null ? null : maxaudit.LevyNotarizationCost : baseaudit.LevyNotarizationCost;
// [Display(Name = "公司承担的产调费")]
bcvm.LevyAssetsSurveyCost = baseaudit == null ? maxaudit == null ? null : maxaudit.LevyAssetsSurveyCost : baseaudit.LevyAssetsSurveyCost;
// [Display(Name = "公司承担的信用报告费")]
bcvm.LevyCreditReportCost = baseaudit == null ? maxaudit == null ? null : maxaudit.LevyCreditReportCost : baseaudit.LevyCreditReportCost;
// [Display(Name = "公司承担的其他费用")]
bcvm.LevyOtherCost = baseaudit == null ? maxaudit == null ? null : maxaudit.LevyOtherCost : baseaudit.LevyOtherCost;
// [Display(Name = "案件模式")]
bcvm.CaseMode = baseaudit == null ? maxaudit == null ? null : maxaudit.CaseMode : baseaudit.CaseMode;
// [Display(Name = "第三方平台")]
bcvm.ThirdParty = baseaudit == null ? maxaudit == null ? null : maxaudit.ThirdParty : baseaudit.ThirdParty;
// [Display(Name = "月利息金额")]
bcvm.MonthlyInterest = baseaudit == null ? maxaudit == null ? null : maxaudit.MonthlyInterest : baseaudit.MonthlyInterest;
// [Display(Name = "放款日期")]
bcvm.LendingDate = baseaudit == null ? maxaudit == null ? null : maxaudit.LendingDate : baseaudit.LendingDate;
// [Display(Name = "回款日期")]
bcvm.PaymentDate = baseaudit == null ? maxaudit == null ? null : maxaudit.PaymentDate : baseaudit.PaymentDate;
// [Display(Name = "实收利息（不退客户）")]
bcvm.ActualInterest = baseaudit == null ? maxaudit == null ? null : maxaudit.ActualInterest : baseaudit.ActualInterest;
// [Display(Name = "预收利息（可退客户）")]
bcvm.AdvanceInterest = baseaudit == null ? maxaudit == null ? null : maxaudit.AdvanceInterest : baseaudit.AdvanceInterest;
//审核期限
bcvm.AuditTerm = baseaudit == null ? maxaudit == null ? null : maxaudit.AuditTerm : baseaudit.AuditTerm;
//审核利率
bcvm.AuditRate = baseaudit == null ? maxaudit == null ? null : maxaudit.AuditRate : baseaudit.AuditRate;
//审批金额
bcvm.AuditAmount = baseaudit == null ? maxaudit == null ? null : maxaudit.AuditAmount : baseaudit.AuditAmount;
//第三方审批金额
bcvm.ThirdPartyAuditAmount = baseaudit == null ? maxaudit == null ? null : maxaudit.ThirdPartyAuditAmount : baseaudit.ThirdPartyAuditAmount;
//第三方审批期限
bcvm.ThirdPartyAuditTerm = baseaudit == null ? maxaudit == null ? null : maxaudit.ThirdPartyAuditTerm : baseaudit.ThirdPartyAuditTerm;
//第三方审批利率
bcvm.ThirdPartyAuditRate = baseaudit == null ? maxaudit == null ? null : maxaudit.ThirdPartyAuditRate : baseaudit.ThirdPartyAuditRate;
//客户保证金
bcvm.CustEarnestMoney = baseaudit == null ? maxaudit == null ? null : maxaudit.CustEarnestMoney : baseaudit.CustEarnestMoney;
return(bcvm);
}
