//获取用户信用档案
private void GetBorrowerData()
{
userCreditInfo = bll.WXGetUserCreditInfo(model.UserId.Value);
//特殊处理
Guid tempBorrowUserId = Guid.Parse("73810E55-E2D4-4F40-8FF9-F0A23F909A75");
if (borrowerUserInfo.Id == tempBorrowUserId)
{
Guid tempProjectId = Guid.Parse("EA7A69C1-38B4-4073-A69D-CFBE2944B4E3");
ProjectDetailInfo tempProjectModel = bll.GetProjectDetailInfo(tempProjectId);
userCreditInfo.DueOutPAndI = userCreditInfo.DueOutPAndI - ((tempProjectModel.TotalAmount ?? 0) + (tempProjectModel.TotalInterest ?? 0) - (tempProjectModel.RefundInterest ?? 0) - (tempProjectModel.RefundCaptital ?? 0));
//LogHelper.WriteLog("待还本息特殊处理", "", tempProjectModel.TotalAmount.Value.ToString());
BusinessDll.NetLog.WriteTraceLogHandler("待还本息特殊处理", tempProjectModel.TotalAmount.Value.ToString(), "触屏版");
}
}
//获取用户信用档案
private void GetBorrowerData()
{
userCreditInfo = bll.WXGetUserCreditInfo(model.UserId.Value);
//特殊处理
Guid tempBorrowUserId = Guid.Parse("73810E55-E2D4-4F40-8FF9-F0A23F909A75");
if (borrowerUserInfo.Id == tempBorrowUserId)
{
Guid tempProjectId = Guid.Parse("EA7A69C1-38B4-4073-A69D-CFBE2944B4E3");
ProjectDetailInfo tempProjectModel = bll.GetProjectDetailInfo(tempProjectId);
userCreditInfo.DueOutPAndI = userCreditInfo.DueOutPAndI - ((tempProjectModel.TotalAmount ?? 0) + (tempProjectModel.TotalInterest ?? 0) - (tempProjectModel.RefundInterest ?? 0) - (tempProjectModel.RefundCaptital ?? 0));
//LogHelper.WriteLog("待还本息特殊处理", "", tempProjectModel.TotalAmount.Value.ToString());
// SysLogHelper.WriteTraceLog("待还本息特殊处理", tempProjectModel.TotalAmount.Value.ToString());
}
string sql = @" SELECT @prepaymentTime=count(CASE WHEN IsRepayAdvance=1 THEN 1 ELSE NULL END ),
@sumTime=count(CASE WHEN Status=6 THEN 1 ELSE NULL END )
FROM Project (NOLOCK) where Type=6 and UserId=@userId ;
SELECT @OverdueCount=COUNT(0) FROM (SELECT ProjectId,periods FROM dbo.OverDueRecord with(nolock) WHERE PublisherUserId=@userId and isnull(IsHide,0)=0 GROUP BY ProjectId,periods)t;
select @OverdueAdvanceTime=COUNT(0) from (SELECT DISTINCT m_Period,m_ProjectId FROM dbo.t_AdvanceDetail(NOLOCK) where m_BorrowUserid=@UserId ) A;
SELECT @TotalOverdue=(ISNULL(SUM(ActualCost),0)+ISNULL(SUM(ActualInterest),0)) FROM dbo.OverDueRecord(NOLOCK) WHERE PublisherUserId=@userId AND IsBorrow=0 and isnull(IsHide,0)=0 ";
var dyParams = new Dapper.DynamicParameters();
dyParams.Add("@userId", model.UserId);
dyParams.Add("@prepaymentTime", 0, DbType.Int32, ParameterDirection.Output, 20);
dyParams.Add("@sumTime", 0, DbType.Int32, ParameterDirection.Output, 20);
dyParams.Add("@OverdueCount", 0, DbType.Int32, ParameterDirection.Output, 20);
dyParams.Add("@OverdueAdvanceTime", 0, DbType.Int32, ParameterDirection.Output, 20);
dyParams.Add("@TotalOverdue", 0, DbType.Decimal, ParameterDirection.Output, 20);
PublicConn.ExecuteTD(PublicConn.DBWriteType.Read, sql, ref dyParams);
PrepaymentTime = dyParams.Get <int>("@prepaymentTime");
int sumTime = dyParams.Get <int>("@sumTime");
OnTimepayTime = sumTime - PrepaymentTime;
overdueNum = dyParams.Get <int>("@OverdueCount");
OverdueAdvanceTime = dyParams.Get <int>("@OverdueAdvanceTime");
TotalOverdue = dyParams.Get <decimal>("@TotalOverdue");
//垫付次数大于逾期次数，显示逾期次数，否则是逾期垫付次数。
if (overdueNum < OverdueAdvanceTime)
{
OverdueAdvanceTime = overdueNum;
}
#region 会员等级 2016-04-16
string strSQL = @"declare @PreNetWorth numeric(18, 2)=0
SELECT @PreNetWorth=ISNULL(PreNetWorth,0) FROM dbo.MUserVipInfo WITH(NOLOCK) WHERE UserId=@UserId
SELECT Level FROM dbo.MVipLevel WITH(NOLOCK) WHERE MinNetWorth<=@PreNetWorth AND MaxNetWorth>@PreNetWorth ";
string level = string.Empty;
DynamicParameters whereParams = new DynamicParameters();
whereParams.Add("@UserId", this.model.UserId);
level = PublicConn.QueryVipSingle <string>(strSQL, ref whereParams);
if (DateTime.Now < DateTime.Parse("2018-01-01 02:00:00") && level == "9")
{
level = "8";
}
VipLevel = "V" + (level ?? "1");//会员等级
#endregion
string sqlText = @"select a.FullName,a.image from UserInEnterpriseProject_ZC u left join AssureOrganization a
on u.EnterpriseUserId=a.UserId where ProjectId=@projectId";
var para = new DynamicParameters();
para.Add("@projectId", model.Id);
assureModel = PublicConn.QuerySingle <AssureOrganizationInfo>(sqlText, ref para);
}
//获取用户信用档案
private void GetBorrowerData()
{
userCreditInfo = bll.WXGetUserCreditInfo(model.UserId.Value);
}
