protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
double learnpt = cf.learnPart; //学习币比例
nID = Request.QueryString["uid"].ToString();
int PayMoneyNO = sh.getPayMoneyNO(nID); //申请中
int FenXiangYJ = tj.GetFenXiangYJ(nID); //分享佣金
int PayMoney = sh.getPayMoney(nID); //已提现
int jiangxj = tj.GetSumMoneyByUser(nID); //累计奖学金,分红
int jintie = tj.GetJx(nID); //绩效，津贴
//总金=分享佣金+全球分红+绩效+邀请关注(2016/3/30)
double allmakemoney = FenXiangYJ + jiangxj + jintie + tj.GetAttentionXF(nID);
//当前剩余资金=总金-已提现-已申请-转学习币
double allpri = allmakemoney - PayMoney - PayMoneyNO - tj.GetMoneyToXueBi(nID);
//总学习币=总金的一定比例
double allxxb = tj.Round((allmakemoney) * learnpt, 0);
//可用学习币=总学习币-已使用学习币+转入学习币+首次关注赠送(2016/3/30)
double canxxb = allxxb - sh.getUsedXueXb(nID) + tj.GetXueXibi(nID) + tj.GetAttentionXXB(nID);
//可提现资金=当前剩余资金-总学习币
double canpri = allpri - allxxb;
hidpri.Value = canpri.ToString();
//当前可提现资金=总金-已提现-已申请+全球分红+绩效-学习币
CanGetPri = StringDelHTML.DoublePriceToString(canpri);
}
else
{
Response.Redirect("errors.html");
}
}
private double learnpt = Convert.ToDouble(ConfigurationManager.AppSettings["learnPart"]);//学习币比例
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["pid"] != null && Request.QueryString["pid"].ToString() != "")
{
pID = Request.QueryString["pid"].ToString();
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
nID = Request.QueryString["uid"].ToString();
LogUtil.WriteLog("支付页面，用户=" + nID);
//获取用户openId
//GetUserOpenId();
GetOpenID(nID);
//生成欲支付订单
GetProductPrice();
PayMoney();
//下面这些是求 “可使用学习币”
int PayMoneyNO = sh.getPayMoneyNO(nID); //申请中
int FenXiangYJ = tj.GetFenXiangYJ(nID); //分享佣金
int PayMoneys = sh.getPayMoney(nID); //已提现
int jiangxj = tj.GetSumMoneyByUser(nID); //累计奖学金,分红
int jintie = tj.GetJx(nID); //绩效，津贴
//总金=分享佣金+全球分红+绩效+邀请关注(2016/3/30)
double allmakemoney = FenXiangYJ + jiangxj + jintie + tj.GetAttentionXF(nID);
//当前剩余资金=总金-已提现-已申请
// double allpri = allmakemoney - PayMoneys - PayMoneyNO;
//总学习币=总金的一定比例
double allxxb = tj.Round((allmakemoney) * learnpt, 0);
//可用学习币=总学习币-已使用学习币+转入学习币+首次关注赠送(2016/3/30)
double canxxb = allxxb - sh.getUsedXueXb(nID) + tj.GetXueXibi(nID) + tj.GetAttentionXXB(nID);
//可提现资金=当前剩余资金-总学习币
// double canpri = allpri - allxxb;
//学习币
xuexibi = StringDelHTML.DoublePriceToString(canxxb);
Gwb.Value = xuexibi;
}
else
{
LogUtil.WriteLog("用户ID丢失");
Response.Redirect("errors.html");
}
}
else
{
LogUtil.WriteLog("产品ID丢失");
Response.Redirect("errors.html");
}
}
}
private void getUser1()
{
StringBuilder sb = new StringBuilder();
Dictionary <string, UserInfo> dicPri = HttpRuntime.Cache["Ranking"] as Dictionary <string, UserInfo>;
if (HttpRuntime.Cache["Ranking"] == null)
{
HttpRuntime.Cache.Insert("Ranking", mp.getRadnking());
dicPri = HttpRuntime.Cache["Ranking"] as Dictionary <string, UserInfo>;
//HttpRuntime.Cache与HttpContext.Current.Cache是同一对象,建议使用HttpRuntime.Cache
}
int rows = 0;
foreach (KeyValuePair <string, UserInfo> dic in dicPri)
{
rows++;
while (rows <= 100)//100以内排名
{
string pri = StringDelHTML.DoublePriceToString(dic.Value.price);
string img = dic.Value.pic == "" ? "img/Styl_01.png" : dic.Value.pic;
sb.AppendLine("<dd><a><img src='" + img + "' />");
sb.AppendLine("<h1>昵称：" + dic.Value.nickname + "</h1>");
sb.AppendLine("<h2>" + dic.Value.levelname + "</h2>");
sb.AppendLine("<h2>学分：" + pri + "</h2>");
// sb.AppendLine("<span>" + rows + "</span></a></dd>");
if (!string.IsNullOrEmpty(uID))
{
if (uID.Equals(dic.Key))
{
sb.AppendLine("<span style='color:red;'>我</span></a></dd>");
MyTop = rows.ToString();
}
else
{
sb.AppendLine("<span>" + rows + "</span></a></dd>");
}
}
else
{
sb.AppendLine("<span>" + rows + "</span></a></dd>");
}
break;
}
}
if (string.IsNullOrEmpty(sb.ToString()))
{
sb.Append("<h1 style='text-align: center; margin-top: 20px'>这里什么也没留下 </h1>");
}
class1 = sb.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
double learnpt = cf.learnPart;//学习币比例
nID = Request.QueryString["uid"].ToString();
nid = nID;
int PayMoneyNO = sh.getPayMoneyNO(nID); //申请中
int FenXiangYJ = tj.GetFenXiangYJ(nID); //分享佣金
int PayMoney = sh.getPayMoney(nID); //已提现
int jiangxj = tj.GetSumMoneyByUser(nID); //累计奖学金,分红
int jintie = tj.GetJx(nID); //绩效，津贴
//总金=分享佣金+全球分红+绩效+邀请关注(2016/3/30)
double allmakemoney = FenXiangYJ + jiangxj + jintie + tj.GetAttentionXF(nID);
//当前剩余资金=总金-已提现-已申请-转学习币
double allpri = allmakemoney - PayMoney - PayMoneyNO - tj.GetMoneyToXueBi(nID);
//总学习币=总金的一定比例
double allxxb = tj.Round((allmakemoney) * learnpt, 0);
//可用学习币=总学习币-已使用学习币+转入学习币+首次关注赠送(2016/3/30)
double canxxb = allxxb - sh.getUsedXueXb(nID) + tj.GetXueXibi(nID) + tj.GetAttentionXXB(nID);
//可提现资金=当前剩余资金-总学习币
double canpri = allpri - allxxb;
//学习币
xuexibi = StringDelHTML.DoublePriceToString(canxxb);
//累计奖学金,全球分红
allMoney = StringDelHTML.DoublePriceToString(jiangxj);
//累计分享学分
//leave1Pri = sh.getOneLeavePrice(uID);
//leave2Pri = sh.getTwoLeavePrice(uID);
//leave3Pri = sh.getThreeLeavePrice(uID);
//double price1 = leave1 * (double.Parse(leave1Pri));
//double price2 = leave2 * (double.Parse(leave2Pri));
//double price3 = leave3 * (double.Parse(leave3Pri));
//leave1Pri = StringDelHTML.DoublePriceToString(price1);
//leave2Pri = StringDelHTML.DoublePriceToString(price2);
//leave3Pri = StringDelHTML.DoublePriceToString(price3);
allMypri = StringDelHTML.DoublePriceToString(FenXiangYJ);
//累计津贴
jingtie = StringDelHTML.DoublePriceToString(jintie);
//累计 邀请关注奖励
guanzhu = StringDelHTML.DoublePriceToString(tj.GetAttentionXF(nID));
//当前可提现资金=总金-已提现-已申请+全球分红+绩效-学习币
CanGetPri = StringDelHTML.DoublePriceToString(canpri);
}
else
{
Response.Redirect("errors.html");
}
}
private string getStr(DataTable dt)
{
StringBuilder sb = new StringBuilder();
Dictionary <string, UserInfo> dicPri = new Dictionary <string, UserInfo>();
foreach (DataRow dr in dt.Rows)
{
var id = dr["nID"].ToString();
//leave1Pri = sh.getOneLeavePrice(id);
//leave2Pri = sh.getTwoLeavePrice(id);
//leave3Pri = sh.getThreeLeavePrice(id);
//double price1 = leave1 * (double.Parse(leave1Pri));
//double price2 = leave2 * (double.Parse(leave2Pri));
//double price3 = leave3 * (double.Parse(leave3Pri));
double pri = tj.GetFenXiangYJ(id);
allMypri = StringDelHTML.DoublePriceToString(pri);//累计佣金
UserInfo ui = new UserInfo()
{
nID = dr["nID"].ToString(),
nickname = dr["nickname"].ToString(),
levelname = dr["levelName"].ToString(),
price = pri,
pic = dr["headimgurl"].ToString()
};
dicPri.Add(id, ui);
}
dicPri = dicPri.OrderByDescending(d => d.Value.price).ToDictionary(d => d.Key, d => d.Value);
int rows = 0;
foreach (KeyValuePair <string, UserInfo> dic in dicPri)
{
rows++;
if (rows > 20)
{
break;
}
string pri = StringDelHTML.DoublePriceToString(dic.Value.price);
string img = dic.Value.pic == "" ? "img/Styl_01.png" : dic.Value.pic;
sb.AppendLine("<dd><a><img src='" + img + "' />");
sb.AppendLine("<h1>昵称：" + dic.Value.nickname + "</h1>");
sb.AppendLine("<h2>" + dic.Value.levelname + "</h2>");
sb.AppendLine("<h2>学分：￥" + pri + "</h2>");
sb.AppendLine("<span>" + rows + "</span></a></dd>");
}
if (string.IsNullOrEmpty(sb.ToString()))
{
sb.Append("<h1 style='text-align: center; margin-top: 20px'>这里什么也没留下 </h1>");
}
return(sb.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
nID = Request.QueryString["uid"].ToString();
nid = nID;
OneLeaveUser = sh.getOneLeaveUser(nID);
TwoLeaveUser = sh.getTwoLeaveUser(nID);
ThreeLeaveUser = sh.getThreeLeaveUser(nID);
leave1Pri = sh.getOneLeavePrice(nID);
leave2Pri = sh.getTwoLeavePrice(nID);
leave3Pri = sh.getThreeLeavePrice(nID);
leave1OrderCount = sh.getOneLeaveOrderCount(nID);
leave2OrderCount = sh.getTwoLeaveOrderCount(nID);
leave3OrderCount = sh.getThreeLeaveOrderCount(nID);
allUser = (int.Parse(OneLeaveUser) + int.Parse(TwoLeaveUser) + int.Parse(ThreeLeaveUser)).ToString();
allOrder = (int.Parse(leave1OrderCount) + int.Parse(leave2OrderCount) + int.Parse(leave3OrderCount)).ToString();
soldPri = StringDelHTML.PriceToStringLow(int.Parse(leave1Pri) + int.Parse(leave2Pri) + int.Parse(leave3Pri));
double price1 = leave1 * (double.Parse(leave1Pri));
double price2 = leave2 * (double.Parse(leave2Pri));
double price3 = leave3 * (double.Parse(leave3Pri));
leave1Pri = StringDelHTML.DoublePriceToString(price1);
leave2Pri = StringDelHTML.DoublePriceToString(price2);
leave3Pri = StringDelHTML.DoublePriceToString(price3);
getingPri = StringDelHTML.PriceToStringLow(sh.getPayMoneyNO(nID)); //申请中
allMypri = StringDelHTML.DoublePriceToString(price3 + price2 + price1); //累计佣金
getPri = StringDelHTML.PriceToStringLow(sh.getPayMoney(nID)); //已提现
//当前可提现资金=总金-已提现-已申请
CanGetPri = StringDelHTML.DoublePriceToString((price3 + price2 + price1) - sh.getPayMoney(nID) - sh.getPayMoneyNO(nID));
hidpri.Value = CanGetPri;
}
else
{
Response.Redirect("errors.html");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
//shuilv.Value = System.Configuration.ConfigurationManager.AppSettings["shuifei"];
double learnpt = cf.learnPart;//学习币比例
double shuifei = Convert.ToDouble(cf.shuifei);
nID = Request.QueryString["uid"].ToString();
int PayMoneyNO = sh.getPayMoneyNO(nID); //申请中
int FenXiangYJ = tj.GetFenXiangYJ(nID); //分享佣金
int PayMoney = sh.getPayMoney(nID); //已提现
int jiangxj = tj.GetSumMoneyByUser(nID); //累计奖学金,分红
int jintie = tj.GetJx(nID); //绩效，津贴
//总金=分享佣金+全球分红+绩效+邀请关注(2016/3/30)
double allmakemoney = FenXiangYJ + jiangxj + jintie + tj.GetAttentionXF(nID);
//当前剩余资金=总金-已提现-已申请-转学习币
double allpri = allmakemoney - PayMoney - PayMoneyNO - tj.GetMoneyToXueBi(nID);
//总学习币=总金的一定比例
double allxxb = tj.Round((allmakemoney) * learnpt, 0);
//可用学习币=总学习币-已使用学习币+转入学习币+首次关注赠送(2016/3/30)
double canxxb = allxxb - sh.getUsedXueXb(nID) + tj.GetXueXibi(nID) + tj.GetAttentionXXB(nID);
//可提现资金=当前剩余资金-总学习币
double canpri = allpri - allxxb;
double ks = tj.Round(canpri * shuifei, 0);
CanGetPri = StringDelHTML.DoublePriceToString(canpri);
koushui = StringDelHTML.DoublePriceToString(ks);
shuihou = StringDelHTML.DoublePriceToString(tj.Round(canpri - ks, 0));
hidpri.Value = CanGetPri;
hidshuihou.Value = shuihou;
hidkoushui.Value = koushui;
}
else
{
Response.Redirect("errors.html");
}
}
public string getMonthRadnking(DateTime dtime)
{
string sql = @"select a.nID,a.nickname,a.headimgurl,b.levelName,a.fxslevel from ML_Member a join ML_MemberLevel b
on a.fxslevel=b.nID where a.fxslevel>=3"; //至少得班长级别
DataTable dt = her.ExecuteDataTable(sql);
StringBuilder sb = new StringBuilder();
Dictionary <string, UserInfo> dicPri = new Dictionary <string, UserInfo>();
foreach (DataRow dr in dt.Rows)
{
var id = dr["nID"].ToString();
// leave1Pri = sh.getOneLeavePriceOneMonth(id);
//leave2Pri = sh.getTwoLeavePrice(id);
//leave3Pri = sh.getThreeLeavePrice(id);
double price1 = (double.Parse(sh.getOneLeavePriceOneWeek(id, dtime)));
// double price2 = leave2 * (double.Parse(leave2Pri));
//double price3 = leave3 * (double.Parse(leave3Pri));
allMypri = StringDelHTML.DoublePriceToString(price1);// 当月 1级分销销售累计佣金
UserInfo ui = new UserInfo()
{
nID = dr["nID"].ToString(),
nickname = StringDelHTML.Centers(dr["nickname"].ToString(), 10),
levelname = dr["levelName"].ToString(),
price = price1,
pic = dr["headimgurl"].ToString(),
fxslevel = Convert.ToInt32(dr["fxslevel"])
};
dicPri.Add(id, ui);
}
dicPri = dicPri.OrderByDescending(d => d.Value.price).Where(d => d.Value.price > 0).ToDictionary(d => d.Key, d => d.Value);
int rows = 0;
foreach (KeyValuePair <string, UserInfo> dic in dicPri)
{
rows++;
while (rows <= 15)//100以内排名
{
string pri = StringDelHTML.DoublePriceToString(dic.Value.price);
string img = dic.Value.pic == "" ? "img/Styl_01.png" : dic.Value.pic;
sb.AppendLine("<dd><a><img src='" + img + "' />");
sb.AppendLine("<h1>昵称：" + dic.Value.nickname + "</h1>");
sb.AppendLine("<h2>" + dic.Value.levelname + "</h2>");
sb.AppendLine("<h2>学分：￥" + pri + "</h2>");
if (rows <= cf.xuebaCount)//前30有奖励
{
sb.AppendLine("<span style='color:red'>" + rows + "</span></a></dd>");
}
else
{
sb.AppendLine("<span style='color:black'>" + rows + "</span></a></dd>");
}
break;
}
}
if (string.IsNullOrEmpty(sb.ToString()))
{
sb.Append("<h1 style='text-align: center; margin-top: 20px'>这里什么也没留下 </h1>");
}
return(sb.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["uid"] != null && Request.QueryString["uid"].ToString() != "")
{
nID = Request.QueryString["uid"].ToString();
nid = nID;
OneLeaveUser = sh.getOneLeaveUser(nID);
TwoLeaveUser = sh.getTwoLeaveUser(nID);
ThreeLeaveUser = sh.getThreeLeaveUser(nID);
//leave1Pri = sh.getOneLeavePrice(nID);
//leave2Pri = sh.getTwoLeavePrice(nID);
//leave3Pri = sh.getThreeLeavePrice(nID);
//leave1OrderCount = sh.getOneLeaveOrderCount(nID);
// leave2OrderCount = sh.getTwoLeaveOrderCount(nID);
//leave3OrderCount = sh.getThreeLeaveOrderCount(nID);
allUser = (int.Parse(OneLeaveUser) + int.Parse(TwoLeaveUser) + int.Parse(ThreeLeaveUser)).ToString();
//allOrder = (int.Parse(leave1OrderCount) + int.Parse(leave2OrderCount) + int.Parse(leave3OrderCount)).ToString();
soldPri = StringDelHTML.PriceToStringLow(tj.GetFenXiangYJZJ(nID));
//soldPri = StringDelHTML.PriceToStringLow(int.Parse(leave1Pri) + int.Parse(leave2Pri) + int.Parse(leave3Pri));
//double price1 = leave1 * (double.Parse(leave1Pri));
//double price2 = leave2 * (double.Parse(leave2Pri));
//double price3 = leave3 * (double.Parse(leave3Pri));
//leave1Pri = StringDelHTML.DoublePriceToString(price1);
//leave2Pri = StringDelHTML.DoublePriceToString(price2);
//leave3Pri = StringDelHTML.DoublePriceToString(price3);
double learnpt = cf.learnPart; //学习币比例
int PayMoneyNO = sh.getPayMoneyNO(nID); //申请中
int FenXiangYJ = tj.GetFenXiangYJ(nID); //分享佣金
int PayMoney = sh.getPayMoney(nID); //已提现
int jiangxj = tj.GetSumMoneyByUser(nID); //累计奖学金,分红
int jintie = tj.GetJx(nID); //绩效
//总金=分享佣金+全球分红+绩效+邀请关注(2016/3/30)
double allmakemoney = FenXiangYJ + jiangxj + jintie + tj.GetAttentionXF(nID);
//当前剩余资金=总金-已提现-已申请-转学习币
double allpri = allmakemoney - PayMoney - PayMoneyNO - tj.GetMoneyToXueBi(nID);
//总学习币=总金的一定比例
double allxxb = tj.Round((allmakemoney) * learnpt, 0);
//可用学习币=总学习币-已使用学习币+转入学习币+首次关注赠送(2016/3/30)
double canxxb = allxxb - sh.getUsedXueXb(nID) + tj.GetXueXibi(nID) + tj.GetAttentionXXB(nID);
//可提现资金=当前剩余资金-总学习币
double canpri = allpri - allxxb;
getingPri = StringDelHTML.PriceToStringLow(PayMoneyNO);
//allMypri = StringDelHTML.DoublePriceToString(FenXiangYJ);
allMypri = StringDelHTML.DoublePriceToString(allmakemoney);
getPri = StringDelHTML.PriceToStringLow(PayMoney);
//当前可提现资金=总金-已提现-已申请+全球分红+绩效-金币
CanGetPri = StringDelHTML.DoublePriceToString(canpri);
hidpri.Value = CanGetPri;
}
else
{
Response.Redirect("errors.html");
}
}
}
public Dictionary <string, UserInfo> getRadnking()
{
string sql = @"select a.nID,a.nickname,a.headimgurl,b.levelName,a.fxslevel from ML_Member a join ML_MemberLevel b
on a.fxslevel=b.nID where isJXS=1 ";
DataTable dt = her.ExecuteDataTable(sql);
Dictionary <string, UserInfo> dicPri = new Dictionary <string, UserInfo>();
foreach (DataRow dr in dt.Rows)
{
var id = dr["nID"].ToString();
int FenXiangYJ = tj.GetFenXiangYJ(id); //分享佣金
int jiangxj = tj.GetSumMoneyByUser(id); //累计奖学金,分红
int jintie = tj.GetJx(id); //绩效，津贴
//总金=分享佣金+全球分红+绩效
double allmakemoney = FenXiangYJ + jiangxj + jintie;
allMypri = StringDelHTML.DoublePriceToString(allmakemoney);//累计佣金
UserInfo ui = new UserInfo()
{
nID = dr["nID"].ToString(),
nickname = StringDelHTML.Centers(dr["nickname"].ToString(), 8),
levelname = dr["levelName"].ToString(),
price = allmakemoney,
pic = dr["headimgurl"].ToString(),
fxslevel = Convert.ToInt32(dr["fxslevel"])
};
dicPri.Add(id, ui);
}
dicPri = dicPri.OrderByDescending(d => d.Value.price).ToDictionary(d => d.Key, d => d.Value);
return(dicPri);
//int rows = 0;
//foreach (KeyValuePair<string, UserInfo> dic in dicPri)
//{
// rows++;
// while (rows <= 100)//100以内排名
// {
// string pri = StringDelHTML.DoublePriceToString(dic.Value.price);
// string img = dic.Value.pic == "" ? "img/Styl_01.png" : dic.Value.pic;
// sb.AppendLine("<dd><a><img src='" + img + "' />");
// sb.AppendLine("<h1>昵称：" + dic.Value.nickname + "</h1>");
// sb.AppendLine("<h2>" + dic.Value.levelname + "</h2>");
// sb.AppendLine("<h2>学分：￥" + pri + "</h2>");
// // sb.AppendLine("<span>" + rows + "</span></a></dd>");
// if (!string.IsNullOrEmpty(uID))
// {
// if (uID.Equals(dic.Key))
// {
// sb.AppendLine("<span style='color:red;'>我</span></a></dd>");
// MyTop = rows.ToString();
// }
// else
// {
// sb.AppendLine("<span>" + rows + "</span></a></dd>");
// }
// }
// else
// {
// sb.AppendLine("<span>" + rows + "</span></a></dd>");
// }
// break;
// }
//}
//if (string.IsNullOrEmpty(sb.ToString()))
//{
// sb.Append("<h1 style='text-align: center; margin-top: 20px'>这里什么也没留下 </h1>");
//}
//return sb.ToString();
}
