public IActionResult GetProjectDetailInfo(int id)
{
ProjectDetailInfo projectDetailInfo = new ProjectDetailInfo();
Entity.ProjectInfo projectInfo = _projectInfoService.Queryable().Where(x => x.id == id).First();
List <HeatStep> heatSteps = _heatStepService.Queryable().Where(x => x.project_id == projectInfo.id).ToList();
List <TmSig> tmSigs = _tmSigService.Queryable().Where(x => x.project_id == projectInfo.id).ToList();
List <Pid> pids = _pidService.Queryable().Where(x => x.project_id == projectInfo.id).ToList();
var ParentType = typeof(Entity.ProjectInfo);
var Properties = ParentType.GetProperties();
foreach (var Propertie in Properties)
{
//循环遍历属性
if (Propertie.CanRead && Propertie.CanWrite)
{
//进行属性拷贝
Propertie.SetValue(projectDetailInfo, Propertie.GetValue(projectInfo, null), null);
}
}
projectDetailInfo.heatStep1 = heatSteps[0];
projectDetailInfo.heatStep2 = heatSteps[1];
projectDetailInfo.heatStep3 = heatSteps[2];
projectDetailInfo.heatStep4 = heatSteps[3];
projectDetailInfo.tmSig1 = tmSigs[0];
projectDetailInfo.tmSig2 = tmSigs[1];
projectDetailInfo.tmSig3 = tmSigs[2];
projectDetailInfo.tmSig4 = tmSigs[3];
projectDetailInfo.pid1 = pids[0];
projectDetailInfo.pid2 = pids[1];
return(Json(projectDetailInfo));
}
private void GetContractInfo(string key)
{
string contactno = this.key;
this.submodel = new SubscribeBLL().GetSubscribeInfoContractNo(contactno);
if (submodel.AddDate < Convert.ToDateTime("2016-3-11"))
{
companyName = "广东俊特团贷网络信息服务股份有限公司";
}
else
{
companyName = "东莞团贷网互联网科技服务有限公司";
}
this.subBasicModel = userbll.GetUserBasicInfoModelById(submodel.SubscribeUserId.Value); //基本信息
this.proModel = projectbll.GetProjectDetailInfo(submodel.ProjectId.Value); //标信息
this.publisherModel = userbll.GetUserBasicInfoModelById(proModel.UserId.Value);
var Params = new Dapper.DynamicParameters();
Params.Add("@ProjectId", proModel.Id);
string selSQL = @"select * from fq_ItemSetsProject with(nolock) where ProjectId=@ProjectId";
itemProjectInfo = PublicConn.QuerySingle <Fq_ItemSetsProjectInfo>(selSQL, ref Params);
RepaymentTypeDesc = ToolStatus.ConvertRepaymentType(proModel.RepaymentType.Value);
if (WebUserAuth.UserId == publisherModel.Id)
{
this.subBasicModel.RealName = StringHandler.MaskStartPre(subBasicModel.RealName, 1); //出借人
this.subBasicModel.IdentityCard = StringHandler.MaskCardNo(subBasicModel.IdentityCard); //出借人身份证号
}
else
{
this.itemProjectInfo.RealName = StringHandler.MaskStartPre(itemProjectInfo.RealName, 1); //借款人
this.itemProjectInfo.IdentityCard = StringHandler.MaskCardNo(itemProjectInfo.IdentityCard); //出借人身份证号
}
UserEnterpriseInfo userEnterprise = new Common.Contract().GetBorrowerGuaranteeEnterprise(proModel.UserId.Value, proModel.AddDate.Value, proModel.Type.Value);
if (userEnterprise != null)
{
assureModel = new Common.Contract().GetAssureOrganizationByUserId(userEnterprise.UserId);
}
else
{
int gid = 0;
int.TryParse(proModel.Guarantors, out gid);
assureModel = new Common.Contract().GetAssureOrganizationById(gid);
if (gid == 1 && DateTime.Now < DateTime.Parse("2013-11-27"))
{
assureModel.FullName = "东莞市俊特团贷网络信息服务有限公司";
}
}
//印章小图片
if (assureModel != null)
{
this.assureModel.image = this.GetSmallImage(this.assureModel.image);
}
}
public IActionResult UpdateProjectInfo([FromBody] ProjectDetailInfo projectDetailInfo)
{
bool res = false;
Entity.ProjectInfo projectInfo = projectDetailInfo;
List <HeatStep> heatSteps = new List <HeatStep>();
heatSteps.Add(projectDetailInfo.heatStep1);
heatSteps.Add(projectDetailInfo.heatStep2);
heatSteps.Add(projectDetailInfo.heatStep3);
heatSteps.Add(projectDetailInfo.heatStep4);
List <TmSig> tmSigs = new List <TmSig>();
tmSigs.Add(projectDetailInfo.tmSig1);
tmSigs.Add(projectDetailInfo.tmSig2);
tmSigs.Add(projectDetailInfo.tmSig3);
tmSigs.Add(projectDetailInfo.tmSig4);
List <Pid> pids = new List <Pid>();
pids.Add(projectDetailInfo.pid1);
pids.Add(projectDetailInfo.pid2);
res = _projectInfoService.Update(projectInfo);
res &= _heatStepService.Update(heatSteps);
res &= _tmSigService.Update(tmSigs);
res &= _pidService.Update(pids);
return(Json(res));
}
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);
}
this.SubscribeUserCount = TuanDai.WXApiWeb.Common.WXInvest.WXGetSubscribeUserCount(this.projectId.Value);
#region 获取担保公司
UserEnterpriseInfo userEnterprise = GetBorrowerGuaranteeEnterprise(this.model.UserId.Value, model.AddDate.Value);
if (userEnterprise != null)
{
string sql = "select NickName from UserBasicInfo with(nolock) where id=@enterpriseuserid";
DynamicParameters args = new DynamicParameters();
args.Add("@enterpriseuserid", userEnterprise.UserId);
this.EnterpriseName = PublicConn.QuerySingle <string>(sql, ref args);
}
else
{
if (model.Guarantors != null && model.Guarantors != "")
{
this.EnterpriseName = BusinessDll.business.GetAssureNameById(int.Parse(model.Guarantors.ToString()));
}
}
#endregion
return(true);
}
protected bool GetData()
{
UserBLL userbll = new UserBLL();
//获取项目信息
model = bll.GetProjectDetailInfo(projectId.Value);
if (model == null || !(model.Type == 48))
{
Response.Redirect(GlobalUtils.WebURL + "/Member/my_account.aspx");
return(false);
}
var dyParams = new DynamicParameters();
dyParams.Add("@userid", model.UserId);
string strSQL = "select * from UserBasicInfo with(nolock) where Id=@userid";
borrowUserInfo = PublicConn.QuerySingle <UserBasicInfoInfo>(strSQL, ref dyParams);
dyParams = new DynamicParameters();
dyParams.Add("@ProjectId", model.Id);
strSQL = string.Empty;
strSQL = @"select top 1 ext from Project_Common with(nolock) where ProjectId=@ProjectId";
string ext = PublicConn.QuerySingle <string>(strSQL, ref dyParams);
if (!string.IsNullOrEmpty(ext))
{
UserInfoExt = JsonConvert.DeserializeObject <ProjectUserInfoExt>(ext);
}
if (UserInfoExt == null)
{
UserInfoExt = new ProjectUserInfoExt();
}
dyParams = new DynamicParameters();
dyParams.Add("@ProjectId", model.Id);
strSQL = string.Empty;
strSQL = @"select * from BorrowerComplianceInfo with(nolock) where ProjectId=@ProjectId";
comInfo = PublicConn.QuerySingle <BorrowerComplianceInfo>(strSQL, ref dyParams);
if (comInfo == null)
{
comInfo = new BorrowerComplianceInfo();
}
//信用档案
creditInfo = CommUtils.GetBorrowerCreditData(model.UserId.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);
}
protected void Page_Load(object sender, EventArgs e)
{
SubscribeId = WEBRequest.GetGuid("SubscribeId", "");
ProjectId = WEBRequest.GetGuid("ProjectId", "");
tab = WEBRequest.GetQueryString("tab");
if (!IsPostBack)
{
projectInfo = projectBll.GetProjectDetailInfo(ProjectId);
if (projectInfo.Type == 18)
{
//私募宝
ProjectSMBLL projectSmbll = new ProjectSMBLL();
projectSmb = projectSmbll.GetProjectSMModel(projectInfo.Id);
simubaoCurve = projectBll.GetSimubaoCurve(UserId, SubscribeId);
}
subscribeInfo = projectBll.WXGetSubscribeInfo(SubscribeId);
TenderMode = WXConverter.GetTenderModeString(subscribeInfo.TenderMode);
if (projectInfo.Type == 23)
{
ProjectXMBBLL xmbbll = new ProjectXMBBLL();
if (subscribeInfo.Status.Value.ToString().IsIn("3", "4"))
{
xmbReturn = xmbbll.GetXMBReturnDetail(subscribeInfo.SubscribeId);
xmbDSInterest = xmbReturn.ReturnAmount - xmbReturn.Amount;
xmbHoldDay = xmbReturn.HoldDay;
xmbDeadRate = xmbReturn.InterestRate;
}
else
{
Tuple <int, decimal, decimal, string> tupleObj = BusinessDll.Invest.GetXMBProjectFloatRate(ProjectId, subscribeInfo.AddDate.Value, subscribeInfo.Amount ?? 0);
xmbHoldDay = tupleObj.Item1;
xmbDeadRate = tupleObj.Item2;
xmbDSInterest = tupleObj.Item3;
}
rateRangeList = xmbbll.GetXMBRateContrastInfo(ProjectId);
}
Status = WXConverter.GetSubscribeStatusString(projectInfo.Type, subscribeInfo.Status, subscribeInfo.IsBorrow);
BindList();
//当为分期宝时
if (projectInfo != null && (projectInfo.Type ?? 0) == 15)
{
FQUserApplyInfo = projectBll.WXGetFQUserApplyInfo(ProjectId.ToString());
}
}
}
private void GetContractInfo(string key)
{
string contactno = key;
this.submodel = new SubscribeBLL().GetSubscribeInfoContractNo(contactno);
if (submodel.AddDate < Convert.ToDateTime("2016-3-11"))
{
companyName = "广东俊特团贷网络信息服务股份有限公司";
}
else
{
companyName = "东莞团贷网互联网科技服务有限公司";
}
this.subBasicModel = userbll.GetUserBasicInfoModelById(submodel.SubscribeUserId.Value); //投资人信息
this.proModel = projectbll.GetProjectDetailInfo(submodel.ProjectId.Value);
this.publisherModel = userbll.GetUserBasicInfoModelById(proModel.UserId.Value); //借款人信息
WebSettingInfo gylSet = new WebSettingBLL().GetWebSettingInfo("75F593E2-40FF-4777-A6F8-4ED54D39FF70");
if (gylSet.Param2Value.IsEmpty())
{
gylSet.Param2Value = "2017-02-10";
}
if (proModel.AddDate >= DateTime.Parse(gylSet.Param2Value))
{
DanBaoCompany = "东莞市志诚非融资性担保有限公司";
DanBaoImage = "http://image.tuandai.com/User/UserUpload/201508/20150825145522_3283.png";
}
//印章小图片
//this.AssureModel.image = new Common.Contract().GetSmallImage(this.AssureModel.image);
RepaymentTypeDesc = this.GetRepaymentTypeDesc(proModel.RepaymentType ?? 0);
if (WebUserAuth.UserId == publisherModel.Id)
{
this.subBasicModel.RealName = StringHandler.MaskStartPre(subBasicModel.RealName, 1); //出借人
this.subBasicModel.IdentityCard = StringHandler.MaskCardNo(subBasicModel.IdentityCard); //出借人身份证号
}
else
{
this.publisherModel.RealName = StringHandler.MaskStartPre(publisherModel.RealName, 1); //借款 人
this.publisherModel.IdentityCard = StringHandler.MaskCardNo(publisherModel.IdentityCard); //借款人身份证号
}
}
private void GetContractInfo(string key)
{
string contactno = this.key;
this.submodel = new SubscribeBLL().GetSubscribeInfoContractNo(contactno);
if (submodel.AddDate < Convert.ToDateTime("2016-3-11"))
{
companyName = "广东俊特团贷网络信息服务股份有限公司";
}
else
{
companyName = "东莞团贷网互联网科技服务有限公司";
}
this.proModel = projectbll.GetProjectDetailInfo(submodel.ProjectId.Value);
this.subBasicModel = userbll.GetUserBasicInfoModelById(submodel.SubscribeUserId.Value);//获取承接人信息
string strSQL = " Select top 1 * From t_SubScribeTransfer with(nolock) Where m_Id=@m_Id ";
var dyParams = new Dapper.DynamicParameters();
dyParams.Add("@m_Id", submodel.TranId);
t_SubScribeTransferInfo mSubScribeTransfer = PublicConn.QuerySingle <t_SubScribeTransferInfo>(strSQL, ref dyParams);
mSubscribe = new SubscribeBLL().GetSubscribeById(mSubScribeTransfer.m_FromSubscribeId);
if (this.mSubscribe.SubscribeUserId != WebUserAuth.UserId && this.submodel.SubscribeUserId != WebUserAuth.UserId)
{
HttpContext.Current.Response.Write("对不起，您没有权限查看此合同。");
HttpContext.Current.Response.End();
}
this.publisherModel = userbll.GetUserBasicInfoModelById(mSubscribe.SubscribeUserId.Value);//获取转让人信息
this.borrowModel = userbll.GetUserBasicInfoModelById(proModel.UserId.Value);
if (WebUserAuth.UserId == publisherModel.Id)
{
this.subBasicModel.RealName = StringHandler.MaskStartPre(subBasicModel.RealName, 1); //出借人
this.subBasicModel.IdentityCard = StringHandler.MaskCardNo(subBasicModel.IdentityCard); //出借人身份证号
}
else
{
this.publisherModel.RealName = StringHandler.MaskStartPre(publisherModel.RealName, 1); //借款 人
this.publisherModel.IdentityCard = StringHandler.MaskCardNo(publisherModel.IdentityCard); //借款人身份证号
}
}
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);
}
borrowUserInfo = userbll.GetUserBasicInfoModelById(model.UserId.Value);
this.GetBorrowerData();
WXProjectExpandInfo proExpend = bll.WXGetProjectExpandInfo(projectId.Value.ToText());
if (proExpend != null)
{
lever = proExpend.Lever ?? 0;
}
SubscribeUserCount = GetSubscribeUserCount();
return(true);
}
protected bool GetData()
{
UserBLL userbll = new UserBLL();
//获取项目信息
model = bll.GetProjectDetailInfo(projectId.Value);
if (model == null || !(model.Type == 24) && !(model.Type == 25) && !(model.Type == 42))
{
Response.Redirect(GlobalUtils.WebURL + "/Member/my_account.aspx");
return(false);
}
string strSQL = @"select b.id,b.ShortName, ProjectDesc,OrgDecription from dbo.fq_ItemSetsProject a with(nolock)
INNER JOIN dbo.fq_OrganizationExtend b ON a.OrgId=b.OrgId AND b.ProjectType=@ProjectType
WHERE projectid = @projectid OR CHARINDEX(@projectid,OldProjectID)>0";
DynamicParameters dyParams = new DynamicParameters();
dyParams.Add("@projectid", model.Id.ToString());
dyParams.Add("@ProjectType", model.Type);
organization = PublicConn.QuerySingle <Organizations>(strSQL, ref dyParams);
if (organization == null)
{
organization = new Organizations();
}
dyParams = new DynamicParameters();
dyParams.Add("@ProjectId", model.Id);
strSQL = string.Format("SELECT * FROM dbo.fq_ItemSetsProject with(nolock) WHERE ProjectId=@ProjectId OR CHARINDEX('{0}',OldProjectID)>0", model.Id);
fq_ItemSetsProjectInfo = PublicConn.QuerySingle <Fq_ItemSetsProjectInfo>(strSQL, ref dyParams);
//信用档案
creditInfo = CommUtils.GetBorrowerCreditData(model.UserId.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);
regulaSet = new WebSettingBLL().GetWebSettingInfo("293A1C07-1D90-4D22-ADD4-39E6735DAC06");
InterestModel = TuanDai.PortalSystem.Redis.ProjectRedis.GetProjectInterestMode(model.Type.Value, model.RepaymentType.Value);
//截标时间为NULL时候取审核时间 +5 天
if (model.TenderDate == null)
{
model.TenderDate = Convert.ToDateTime(model.AuditDate == null ? model.AddDate : model.AuditDate).AddDays(5);
}
else
{
model.TenderDate = model.TenderDate;
}
if (model.AuditDate == null)
{
model.TenderStartDate = model.AddDate;
}
else
{
model.TenderStartDate = model.AuditDate;
}
return(true);
}
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);
}
if (model.Type.Value != 32)
{
Response.Redirect(GlobalUtils.WebURL + "/Member/my_account.aspx");
return(false);
}
DynamicParameters dyParams;
string sql = "";
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);
regulaSet = new WebSettingBLL().GetWebSettingInfo("293A1C07-1D90-4D22-ADD4-39E6735DAC06");
InterestModel = TuanDai.PortalSystem.Redis.ProjectRedis.GetProjectInterestMode(model.Type.Value, model.RepaymentType.Value);
//截标时间为NULL时候取审核时间 +5 天
if (model.TenderDate == null)
{
model.TenderDate = Convert.ToDateTime(model.AuditDate == null ? model.AddDate : model.AuditDate).AddDays(5);
}
else
{
model.TenderDate = model.TenderDate;
}
if (model.AuditDate == null)
{
model.TenderStartDate = model.AddDate;
}
else
{
model.TenderStartDate = model.AuditDate;
}
sql = "select RiskAssessment,FundUse,RepaymentAssure from project_xd with(nolock) where ProjectId=@ProjectId";
Dapper.DynamicParameters Parprojectxd = new Dapper.DynamicParameters();
Parprojectxd.Add("@ProjectId", projectId);
projectXDInfo = PublicConn.QuerySingle <Project_xdInfo>(sql, ref Parprojectxd);
if (projectXDInfo == null)
{
projectXDInfo = new Project_xdInfo();
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
var idStr = WEBRequest.GetString("projectid");
if (!string.IsNullOrEmpty(idStr))
{
projectId = Guid.Parse(idStr);
}
else
{
Response.Redirect("/pages/invest/invest_list.aspx");
}
InvestType = WEBRequest.GetString("investType");
var payMoneyStr = WEBRequest.GetString("payMoney");
if (!string.IsNullOrEmpty(payMoneyStr))
{
PayMoney = decimal.Parse(payMoneyStr);
}
else
{
Response.Redirect("/pages/invest/invest_list.aspx");
}
ProfitMoney = WEBRequest.GetString("profitMoney");
ProfitMoney = ProfitMoney.Replace("￥", "");
try
{
if (ProfitMoney.ToText() != "" && !ProfitMoney.Contains("~"))
{
//获取团币系数
NewVipUserInfo UserVipModel = GetNewVipUserInfo(WebUserAuth.UserId.Value);
decimal tuanBiXiShu = 0;
if (UserVipModel != null)
{
tuanBiXiShu = UserVipModel.TuanBiCoefficient;
}
TuanBi = Math.Floor(tuanBiXiShu * decimal.Parse(ProfitMoney)).ToString();
}
}
catch
{
TuanBi = "0";
}
IsWeFQB = false;
if (InvestType == "project")
{
#region 散标投资
string sql = "select count(0) from Project with(nolock) where id=@id";
Dapper.DynamicParameters para = new Dapper.DynamicParameters();
para.Add("@id", projectId);
var count = PublicConn.QuerySingle <int>(sql, ref para);
if (count > 0)
{
FinishUrl = "/pages/invest/detail.aspx?id=" + projectId;
sql = "SELECT top 1 s.Id FROM dbo.Project p WITH(NOLOCK) INNER JOIN dbo.Subscribe s WITH(NOLOCK) ON p.Id = s.ProjectId WHERE p.Id=@id AND s.SubscribeUserId=@userid ORDER BY s.AddDate DESC";
para = new Dapper.DynamicParameters();
para.Add("@id", projectId);
para.Add("@userid", WebUserAuth.UserId.Value);
var subscribeId = PublicConn.QuerySingleWrite <Guid>(sql, ref para);
InvestUrl =
"/Member/Repayment/my_return_details.aspx?SubscribeId=" + subscribeId + "&ProjectId=" + projectId + "&tab=Inprogress";
GoOnUrl = "/pages/invest/invest_list.aspx";
projectInfo = new ProjectBLL().GetProjectDetailInfo(projectId);
if (projectInfo.Type == 6 || projectInfo.Type == 19 || projectInfo.Type == 20 || projectInfo.Type == 21 || projectInfo.Type == 17)
{
TuanBi = TuanBi;
}
else
{
TuanBi = Math.Floor(decimal.Parse(TuanBi) / projectInfo.Deadline ?? 1).ToString();
}
}
else
{
FinishUrl = "/pages/invest/zqzr_detail.aspx?projectid=" + projectId;
sql = "SELECT top 1 t.m_Title,s.Id FROM dbo.t_SubScribeTransfer t WITH(NOLOCK) INNER JOIN dbo.Subscribe s WITH(NOLOCK) ON t.m_Id = s.TranId WHERE t.m_Id=@id AND s.SubscribeUserId=@userid ORDER BY s.TranDate DESC";
para = new Dapper.DynamicParameters();
para.Add("@id", projectId);
para.Add("@userid", WebUserAuth.UserId.Value);
var tModel = PublicConn.QuerySingleWrite <TranModel>(sql, ref para);
if (tModel != null)
{
InvestUrl =
"/Member/Repayment/my_debt_carry_detail.aspx?SubscribeId=" + tModel.Id + "&Title=" + tModel.m_Title + "&projectid=78ab9bb8-1b12-4574-9326-cbba119956d4&tab=Inprogress";
}
else
{
InvestUrl = "/Member/Repayment/my_return_list.aspx";
}
GoOnUrl = "/pages/invest/debt_list.aspx";
TuanBi = "0";
}
#endregion
}
else
{
#region We计划
//product = new WeProductBLL().GetWeProductInfo(projectId);
if (GlobalUtils.IsRedis && GlobalUtils.IsWePlanRedis)
{
string err = string.Empty;
var weRedisInfo = TuanDai.RedisApi.Client.WePlanRedis.GetWePlanRedisByProductIdJson(projectId,
out err, TdConfig.ApplicationName);
if (weRedisInfo != null)
{
product = JsonConvert.DeserializeObject <WeProductDetailInfo>(weRedisInfo);
}
if (product == null || !string.IsNullOrEmpty(err))
{
product = new WeProductBLL().GetWeProductInfo(projectId);
}
}
else
{
product = new WeProductBLL().GetWeProductInfo(projectId);
}
var cookieUrl = CookieHelper.GetCookie("Anniversary4"); //HttpContext.Current.Request.Cookies["Anniversary4"];
if (!string.IsNullOrEmpty(cookieUrl))
{
activityUrl = cookieUrl;
//删除cookie Anniversary4
if (product.TypeWord.ToLower().Contains("p") || product.TypeWord.ToLower().Contains("q") || product.TypeWord.ToLower().Contains("r"))
{
CookieHelper.ClearCookie("Anniversary4");
}
}
string sql = "select count(0) from we_product with(nolock) where id=@id and iswefqb = 1";
Dapper.DynamicParameters para = new Dapper.DynamicParameters();
para.Add("@id", projectId);
var count = PublicConn.QuerySingle <int>(sql, ref para);
sql = "select top 1 o.id from we_product p with(nolock) inner join we_order o with(nolock) on p.id=o.productid where p.id=@id and o.userid=@userid order by OrderDate desc";
para = new Dapper.DynamicParameters();
para.Add("@id", projectId);
para.Add("@userid", WebUserAuth.UserId.Value);
var orderId = PublicConn.QuerySingleWrite <Guid>(sql, ref para);
if (count > 0)
{
IsWeFQB = true;
FinishUrl = "/pages/invest/WE/WeFqb_detail.aspx?id=" + projectId;
InvestUrl = "/Member/Repayment/Wefqb_project.aspx?weorderid=" + orderId + "&tab=Inprogress";
}
else
{
FinishUrl = "/pages/invest/WE/WE_detail.aspx?id=" + projectId;
InvestUrl =
"/Member/Repayment/We_project.aspx?weorderid=" + orderId + "&tab=Inprogress";
}
GoOnUrl = "/pages/invest/WE/WE_list.aspx";
if (product != null && (product.TuandaiCashRate ?? 0) > 0)
{
if (product.CashLimitAmount == 0 || PayMoney >= product.CashLimitAmount)
{
FXAmount = PayMoney * product.TuandaiCashRate.Value / 100;
}
}
if (product != null)
{
if (product.DeadType == 1)
{
TuanBi = Math.Floor(decimal.Parse(TuanBi) / product.Deadline ?? 1).ToString();
}
else
{
TuanBi = Math.Floor(decimal.Parse(TuanBi)).ToString();
}
}
#endregion
}
//计算红包状态
QueryPrizeUseStatus();
}
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);
}
borrowerUserInfo = userbll.GetUserBasicInfoModelById(model.UserId.Value);
borrowerUserInfoExt = userbll.GetUserBasicInfoExtInfo(model.UserId.Value);
this.GetBorrowerData();
InterestRateNum1 = ToolStatus.DeleteZero(model.InterestRate.Value).Split('.')[0];
InterestRateNum2 = ToolStatus.DeleteZero(model.InterestRate.Value).Contains(".") ? ToolStatus.DeleteZero(model.InterestRate.Value).Split('.')[1] : string.Empty;
if (model.Status != 3 && model.Status != 6)
{
RemainMoney = (int.Parse(ToolStatus.diff(model.TotalShares ?? 0, model.CastedShares ?? 0)) * decimal.Parse(ToolStatus.DeleteZero(model.LowerUnit.Value))).ToString("N2");
}
else
{
RemainMoney = "0";
}
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);
List <SubscribeTotalInfo> repaylist = new SubscribeBLL().GetRepaymentInfo(this.projectId.Value);
if (repaylist != null && repaylist.Count > 0)
{
foreach (SubscribeTotalInfo item in repaylist)
{
switch (item.status)
{
case 1:
repayedAmount = SafeConvert.ToDecimal(item.Amount) + SafeConvert.ToDecimal(item.InterestAmount);
break;
case 2:
overdueAmount = SafeConvert.ToDecimal(item.Amount) + SafeConvert.ToDecimal(item.InterestAmount);
break;
case 3:
duerepayAmount = SafeConvert.ToDecimal(item.Amount) + SafeConvert.ToDecimal(item.InterestAmount);
break;
}
}
}
string jzsql = "select isnull(AvgNetAssets,0) from VipMonthlyNetAssets with(nolock) where UserId=@UserId and ReportDate=@ReportDate";
var dyParamJZ = new Dapper.DynamicParameters();
dyParamJZ.Add("@UserId", model.UserId.Value);
dyParamJZ.Add("@ReportDate", DateTime.Now.AddMonths(-1).ToString("yyyy-MM-01"));
this.monthJZ = TuanDai.DB.TuanDaiDB.QueryFirstOrDefault <decimal>(TdConfig.ApplicationName, TdConfig.DBReportWrite, jzsql, ref dyParamJZ);
regulaSet = new WebSettingBLL().GetWebSettingInfo("293A1C07-1D90-4D22-ADD4-39E6735DAC06");
InterestModel = TuanDai.PortalSystem.Redis.ProjectRedis.GetProjectInterestMode(model.Type.Value, model.RepaymentType.Value);
// 截标时间为NULL时候取审核时间 +4 天
if (model.TenderDate == null)
{
WebSettingInfo set = new WebSettingBLL().GetWebSettingInfo("3F902315-6986-44FF-9F00-9D420C07FCDA");
if (model.AddDate >= Convert.ToDateTime(set.Param4Value))
{
model.TenderDate = Convert.ToDateTime(model.AuditDate == null ? model.AddDate : model.AuditDate).AddDays(2);
}
else
{
model.TenderDate = Convert.ToDateTime(model.AuditDate == null ? model.AddDate : model.AuditDate).AddDays(4);
}
}
if (model.AuditDate == null)
{
model.TenderStartDate = model.AddDate;
}
else
{
model.TenderStartDate = model.AuditDate;
}
return(true);
}