protected void GetBorrowUserInfo() { if (ProjectId != null && ProjectId != Guid.Empty) { string sql = @"select b.Id as UserId, b.Birthday, b.TelNo, b.sex, b.AddDate, b.NickName, b.BankCity, b.CreditRatingName,b.UserTypeId,b.RealName, a.Type as ProjectType from Project a inner join UserBasicInfo b with(nolock) on b.Id=a.UserId where a.Id=@projectId "; Dapper.DynamicParameters dyParams = new Dapper.DynamicParameters(); dyParams.Add("@projectId", ProjectId); borrowerUserInfo = PublicConn.QuerySingle <BorrowUserInfo>(sql, ref dyParams); if (borrowerUserInfo == null) { borrowerUserInfo = new BorrowUserInfo(); } string phone = borrowerUserInfo.TelNo.ToText(); if (!phone.IsEmpty()) { if (phone.Length > 11) { phone = phone.Left(11); } } borrowerUserInfo.TelNo = phone; SimpleUserExt userBasicInfo_Ext = null; dyParams = new Dapper.DynamicParameters(); dyParams.Add("@userid", borrowerUserInfo.UserId); sql = @"select Marriage,Graduation,IsHasChildren, IsHaveHouse,IsHaveCar,Address from t_UserBasicInfo_Ext with(nolock) where UserId=@userid"; userBasicInfo_Ext = PublicConn.QuerySingle <SimpleUserExt>(sql, ref dyParams); if (userBasicInfo_Ext != null) { borrowerUserInfo.Marriage = userBasicInfo_Ext.Marriage; borrowerUserInfo.Graduation = userBasicInfo_Ext.Graduation; if (userBasicInfo_Ext.IsHasChildren == true) { borrowerUserInfo.IsHasChildren = "有"; } else { borrowerUserInfo.IsHasChildren = "否"; } borrowerUserInfo.IsHasHouse = userBasicInfo_Ext.IsHaveHouse ? "有" : "无"; if (borrowerUserInfo.BankCity.IsEmpty()) { borrowerUserInfo.BankCity = StringHandler.MaskStarPre3(userBasicInfo_Ext.Address); } } //是否项目集标的 if (borrowerUserInfo.ProjectType.ToString().IsIn("24", "25", "27", "28", "29", "31", "33")) { Fq_ItemSetsProjectInfo fq_ItemSetsProjectInfo = new fq_ItemSetsProjectBLL().GetFqItemSetsProjectInfoByPorjectId(ProjectId); if (fq_ItemSetsProjectInfo != null) { borrowerUserInfo.BankCity = StringHandler.MaskStartPre(Tool.WebFormHandler.CutString(fq_ItemSetsProjectInfo.Address, 6), 3); borrowerUserInfo.Industry = StringHandler.MaskStartPre(fq_ItemSetsProjectInfo.CompanyIndustryTypeId, 6); borrowerUserInfo.Salary = fq_ItemSetsProjectInfo.MonthlyIncome + "元"; borrowerUserInfo.IsHasHouse = fq_ItemSetsProjectInfo.IsHaveHouse ? "有" : "无"; borrowerUserInfo.Graduation = fq_ItemSetsProjectInfo.Education; borrowerUserInfo.Marriage = fq_ItemSetsProjectInfo.MarrayStatus ? "已婚" : "未婚"; } } if (borrowerUserInfo.ProjectType >= 39) { sql = "select ext from dbo.Project_Common where ProjectId=@ProjectId"; dyParams = new Dapper.DynamicParameters(); dyParams.Add("@ProjectId", ProjectId); string ext = PublicConn.QuerySingle <string>(sql, ref dyParams); if (ext.IsNotEmpty()) { var borrowExtInfo = JsonConvert.DeserializeObject <BorrowExtInfo>(ext); if (borrowExtInfo != null) { borrowerUserInfo.Marriage = borrowExtInfo.marriage; borrowerUserInfo.Graduation = borrowExtInfo.education; borrowerUserInfo.IsHasHouse = borrowExtInfo.housingSituation.IsEmpty() ? "无" : borrowExtInfo.housingSituation; borrowerUserInfo.BankCity = borrowExtInfo.city; } } } //查询借款人合规表信息 string strSQL = "select * from BorrowerComplianceInfo with(nolock) where ProjectId=@projectId"; dyParams = new Dapper.DynamicParameters(); dyParams.Add("@projectId", ProjectId); PageBorrowerComplianceInfo compInfo = PublicConn.QuerySingle <PageBorrowerComplianceInfo>(strSQL, ref dyParams); if (compInfo != null) { borrowerUserInfo.IsShowExt = "1"; borrowerUserInfo.Industry = compInfo.Trade; if (compInfo.CompanyName.IsNotEmpty()) { borrowerUserInfo.RealName = StringHandler.MaskStartPre(compInfo.CompanyName, 1); } borrowerUserInfo.Salary = compInfo.IncomePerMonth.ToText() == "" ? "无" : compInfo.IncomePerMonth; borrowerUserInfo.CurrentDebts = compInfo.CurrentDebt.IsEmpty() ? "无" : compInfo.CurrentDebt; borrowerUserInfo.OtherBorrow = compInfo.OtherPlatformsBorrow.IsEmpty() ? "无" : compInfo.OverdueSituation; borrowerUserInfo.CreditOverDue = compInfo.OverdueSituation.IsEmpty() ? "无" : compInfo.OtherPlatformsBorrow; borrowerUserInfo.RegAmount = compInfo.RegisteredCapital.IsEmpty() ? "无" : compInfo.RegisteredCapital; borrowerUserInfo.RegAddress = compInfo.RegisteredAddress.IsEmpty() ? "无" : StringHandler.MaskStartPre(compInfo.RegisteredAddress, 6); borrowerUserInfo.RegDate = compInfo.EstablishedTime.ToString("yyyy年MM月dd日"); borrowerUserInfo.LegalName = compInfo.LegalPerson.IsEmpty() ? "无" : StringHandler.MaskStartPre(compInfo.LegalPerson, 1); } } else { borrowerUserInfo = new BorrowUserInfo(); } }