private NewVipUserInfo GetNewVipUserInfo(Guid userId)
{
//p_GetUserLevelInfo
string strSQL = @"SELECT a.[Level], a.LevelName,b.TuanBiCoefficient FROM dbo.MUserVipInfo a with(nolock)
left join MVipLevel b with(nolock) on b.Level=a.Level
where UserId=@UserId ";
DynamicParameters dyParams = new DynamicParameters();
dyParams.Add("@UserId", userId);
NewVipUserInfo vipUserInfo = PublicConn.QueryVipSingle <NewVipUserInfo>(strSQL, ref dyParams);
if (vipUserInfo == null)
{
vipUserInfo = new NewVipUserInfo();
vipUserInfo.Level = 1;
vipUserInfo.LevelName = "投资学徒";
}
return(vipUserInfo);
}
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();
}