//用户详细信息 private void GetUserDetailInfo() { // this.UserDetail = new UserBLL().GetUserDetailInfoByProjectId(this.model.Id, this.model.UserId.ToString()); userDetailInfoInfo UserDetail = null; if (model.Type == 9 || model.Type == 26 || model.Type == 40)//车贷 { string strSQL = @"SELECT Id,ProjectID,CarBrand,CarOrigin,CarType,ISNULL(CarPrice,0) AS CarPrice,CarKM,CarIsBigRepair,CarPlace,AddDate,CarDisplacement FROM dbo.UserCarDetailInfo WITH(NOLOCK) WHERE ProjectID=@ProjectId"; Dapper.DynamicParameters par = new Dapper.DynamicParameters(); par.Add("@ProjectId", projectId); mUserCarDetailInfoInfo = PublicConn.QuerySingle <UserCarDetailInfoInfo>(strSQL, ref par); if (mUserCarDetailInfoInfo == null) { mUserCarDetailInfoInfo = new UserCarDetailInfoInfo(); UserDetail = new UserBLL().GetUserDetailInfoByProjectId(projectId.Value, model.UserId.Value.ToString()); mUserCarDetailInfoInfo.CarBrand = UserDetail.CarBrand; mUserCarDetailInfoInfo.CarIsBigRepair = UserDetail.CarIsBigRepair.HasValue ? UserDetail.CarIsBigRepair.Value : false; mUserCarDetailInfoInfo.CarKM = UserDetail.CarKM.HasValue ? UserDetail.CarKM.Value : 0; mUserCarDetailInfoInfo.CarOrigin = UserDetail.CarOrigin; mUserCarDetailInfoInfo.CarPlace = UserDetail.CarOrigin; mUserCarDetailInfoInfo.CarPrice = UserDetail.CarPrice.HasValue ? UserDetail.CarPrice.Value : 0; mUserCarDetailInfoInfo.CarType = UserDetail.CarType; } } else {//房贷 string strSQL = @"SELECT Id,ProjectID,HouseBuyDate,ISNULL(HouseArea,0) AS HouseArea,ISNULL(HousePrice,0) AS HousePrice,ISNULL(HouseYears,0)AS HouseYears,ISNULL(IsHouseRenovation,0) AS IsHouseRenovation,ISNULL(IsHouseLoan,0) AS IsHouseLoan ,ISNULL(HouseLoanAmount,0) AS HouseLoanAmount,ISNULL(HouseLoanYears,0) AS HouseLoanYears,AddDate FROM dbo.UserHouseDetailInfo WITH(NOLOCK) WHERE ProjectID=@ProjectId"; Dapper.DynamicParameters par = new Dapper.DynamicParameters(); par.Add("@ProjectId", projectId); mUserHouseDetailInfoInfo = PublicConn.QuerySingle <UserHouseDetailInfoInfo>(strSQL, ref par); if (mUserHouseDetailInfoInfo == null) { mUserHouseDetailInfoInfo = new UserHouseDetailInfoInfo(); UserDetail = new UserBLL().GetUserDetailInfoByProjectId(projectId.Value, model.UserId.Value.ToString()); mUserHouseDetailInfoInfo.HouseBuyDate = UserDetail.HouseBuyDate.Value; mUserHouseDetailInfoInfo.HouseArea = UserDetail.HouseArea.HasValue ? UserDetail.HouseArea.Value : 0; mUserHouseDetailInfoInfo.HousePrice = UserDetail.HousePrice.HasValue ? UserDetail.HouseArea.Value : 0; mUserHouseDetailInfoInfo.HouseYears = UserDetail.HouseYears.HasValue ? UserDetail.HouseYears.Value : 0; mUserHouseDetailInfoInfo.IsHouseRenovation = UserDetail.IsHouseRenovation.HasValue ? UserDetail.IsHouseRenovation.Value : false; mUserHouseDetailInfoInfo.IsHouseLoan = UserDetail.IsHouseLoan.HasValue ? UserDetail.IsHouseLoan.Value : false; mUserHouseDetailInfoInfo.HouseLoanAmount = UserDetail.HouseLoanAmount.HasValue ? UserDetail.HouseArea.Value : 0; mUserHouseDetailInfoInfo.HouseLoanYears = UserDetail.HouseLoanYears.HasValue ? UserDetail.HouseLoanYears.Value : 0; } } }
protected bool GetData() { UserBLL userbll = new UserBLL(); //获取项目信息 model = bll.GetProjectDetailInfo(projectId.Value); if (model == null) { Response.Redirect(GlobalUtils.WebURL + "/Member/my_account.aspx"); return(false); } userApply = bll.WXGetFQUserApplyInfo(projectId.Value.ToText()); if (userApply != null) { Organization = bll.WXGetOrganizationInfo(userApply.OrgId.HasValue ? userApply.OrgId.Value.ToText() : ""); } else { userApply = new WXFQUserApplyInfo(); } string strFile = string.Format(" oa.OrgTypeId ={0} and (f.UserId IS NULL OR f.UserId = '{1}') ", Organization.OrgTypeId, userApply.ApplyUserId); Dapper.DynamicParameters dyParams = new Dapper.DynamicParameters(); string strSQL = string.Format(@" SELECT DISTINCT AuthName = a.Name, oa.AuthId, a.UploadedStyle,oa.SortOrder FROM fq_OrgAuthSetting oa with(nolock) INNER JOIN fq_AuthSetting a with(nolock) ON oa.AuthId = a.Id INNER JOIN (SELECT AuthId,UserId from dbo.fq_UserAuthFile with(nolock) WHERE (IsDelete IS NULL OR IsDelete = 0) AND IsHiddenInfo =0) f ON a.Id = f.AuthId Where {0} Order by oa.SortOrder asc", strFile); var AuthList = PublicConn.QueryBySql <AuthSet>(strSQL, ref dyParams); for (int i = 0; i < AuthList.Count; i++) { if (i == 0) { AuthHtml = AuthList[i].AuthName; } else { AuthHtml += "、" + AuthList[i].AuthName; } } //是否学生分期 dyParams = new Dapper.DynamicParameters(); dyParams.Add("@ProjectId", model.Id); strSQL = "select isnull(IdentityTypeId,0) as IdentityTypeId from fq_UserApply with(nolock) where ProjectId=@ProjectId"; IdentityTypeId = PublicConn.QuerySingle <int>(strSQL, ref dyParams); if (IdentityTypeId == 1) { //获取学生基本信息 dyParams = new Dapper.DynamicParameters(); dyParams.Add("@UserId", model.UserId); strSQL = "select * from fq_ApplyEducation with(nolock) where UserId=@UserId"; applyEducation = PublicConn.QuerySingle <ApplyEducation>(strSQL, ref dyParams); } else { borrowUserInfo = userbll.GetUserBasicInfoModelById(model.UserId.Value); strSQL = "select * from userDetailInfo with(nolock) where UserId=@UserId"; dyParams = new Dapper.DynamicParameters(); dyParams.Add("@UserId", borrowUserInfo.Id); userDetai = PublicConn.QuerySingle <userDetailInfoInfo>(strSQL, ref dyParams); } //信用档案 creditInfo = CommUtils.GetBorrowerCreditData(model.UserId.Value); //项目展示图 imageList = CommUtils.GetProjectImages(this.projectId.Value); finishProcess = CommUtils.GetProjectProcess(model); SubscribeUserCount = CommUtils.GetSubscribeUserCount(this.projectId.Value); //计算预期收益 PreInterestRate = CommUtils.CalcInvestInterest(model, 10000); EbaoMultiple = int.Parse(Math.Ceiling(model.InterestRate.Value / decimal.Parse("2.5")).ToString()); EbaoInterest = CommUtils.GetEbaoMultipleInterest(model, 10000); preSubscribeList = CommUtils.GetPreSubscribeDetail(model, 10000); return(true); }