//成长值 private string GrowUp(DBMA1DataContext dbma1, string userSN, decimal currentGroupValue) { //vip等级设置 A029 a029 = dbma1.A029s.First(); //当前vip等级及奖励率 string vipLevel = string.Empty; decimal rewardRate; if (currentGroupValue < a029.vip1_originateValue) { vipLevel = "0"; rewardRate = 0; } else if (currentGroupValue < a029.vip2_originateValue) { vipLevel = "1"; rewardRate = a029.vip1_rewardRate; } else if (currentGroupValue < a029.vip3_originateValue) { vipLevel = "2"; rewardRate = a029.vip2_rewardRate; } else if (currentGroupValue < a029.vip4_originateValue) { vipLevel = "3"; rewardRate = a029.vip3_rewardRate; } else if (currentGroupValue < a029.vip5_originateValue) { vipLevel = "4"; rewardRate = a029.vip4_rewardRate; } else if (currentGroupValue < a029.vip6_originateValue) { vipLevel = "5"; rewardRate = a029.vip5_rewardRate; } else if (currentGroupValue < a029.vip7_originateValue) { vipLevel = "6"; rewardRate = a029.vip6_rewardRate; } else { vipLevel = "7"; rewardRate = a029.vip7_rewardRate; } var GrowUpInfo = new { Leval = vipLevel, Award = rewardRate }; return(C101.FC10107(GrowUpInfo)); }
public static decimal FC20152(DBMA1DataContext dbma1, string userSN) { //vip等级设置 A029 a029 = dbma1.A029s.First(); string a029Str = C101.FC10107(a029); //当前成长值 decimal currentGroupValue = Convert.ToInt32(dbma1.F006s.Where(c => c.userSN == userSN).Sum(c => c.groupUpValue)); //当前vip等级及奖励率 decimal rewardRate; if (currentGroupValue < a029.vip1_originateValue) { rewardRate = 0; } else if (currentGroupValue < a029.vip2_originateValue) { rewardRate = a029.vip1_rewardRate; } else if (currentGroupValue < a029.vip3_originateValue) { rewardRate = a029.vip2_rewardRate; } else if (currentGroupValue < a029.vip4_originateValue) { rewardRate = a029.vip3_rewardRate; } else if (currentGroupValue < a029.vip5_originateValue) { rewardRate = a029.vip4_rewardRate; } else if (currentGroupValue < a029.vip6_originateValue) { rewardRate = a029.vip5_rewardRate; } else if (currentGroupValue < a029.vip7_originateValue) { rewardRate = a029.vip6_rewardRate; } else { rewardRate = a029.vip7_rewardRate; } return(rewardRate); }
public string FP90101() { //判断是否登录 if (session["userSN"] == null) { return("notLogin"); } string userSN = session["userSN"].ToString(); using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { A029 a029 = dbma1.A029s.First(); //当前成长值 decimal currentGroupValue = Convert.ToInt32(dbma1.F006s.Where(c => c.userSN == userSN).Sum(c => c.groupUpValue)); //当前vip等级及奖励率 string vipLevel = string.Empty; decimal rewardRate; if (currentGroupValue < a029.vip1_originateValue) { vipLevel = "0"; rewardRate = 0; } else if (currentGroupValue < a029.vip2_originateValue) { vipLevel = "1"; rewardRate = a029.vip1_rewardRate; } else if (currentGroupValue < a029.vip3_originateValue) { vipLevel = "2"; rewardRate = a029.vip2_rewardRate; } else if (currentGroupValue < a029.vip4_originateValue) { vipLevel = "3"; rewardRate = a029.vip3_rewardRate; } else if (currentGroupValue < a029.vip5_originateValue) { vipLevel = "4"; rewardRate = a029.vip4_rewardRate; } else if (currentGroupValue < a029.vip6_originateValue) { vipLevel = "5"; rewardRate = a029.vip5_rewardRate; } else if (currentGroupValue < a029.vip7_originateValue) { vipLevel = "6"; rewardRate = a029.vip6_rewardRate; } else { vipLevel = "7"; rewardRate = a029.vip7_rewardRate; } //账户预约 decimal balanceV = dbma1.F000s.Where(c => c.userSN == userSN).First().balance; string name = dbma1.U000s.Where(c => c.userSN == userSN).First().name; return(string.Format("{{\"vipLevel\":\"{0}\",\"vipRate\":\"{1}\",\"balance\":\"{2}\",\"name\":\"{3}\",\"userSN\":\"{4}\"}}", vipLevel, rewardRate, balanceV, name, userSN)); } }
public string FP70101() { //判断是否登录 if (session["userSN"] == null) { return("notLogin"); } string userSN = session["userSN"].ToString(); using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { //用户名 string userName = dbma1.U000s.Where(c => c.userSN == userSN).First().name; //vip等级设置 A029 a029 = dbma1.A029s.First(); string a029Str = C101.FC10107(a029); //当前成长值 decimal currentGroupValue = Convert.ToInt32(dbma1.F006s.Where(c => c.userSN == userSN).Sum(c => c.groupUpValue)); //当前vip等级及奖励率 string vipLevel = string.Empty; decimal rewardRate; if (currentGroupValue < a029.vip1_originateValue) { vipLevel = "0"; rewardRate = 0; } else if (currentGroupValue < a029.vip2_originateValue) { vipLevel = "1"; rewardRate = a029.vip1_rewardRate; } else if (currentGroupValue < a029.vip3_originateValue) { vipLevel = "2"; rewardRate = a029.vip2_rewardRate; } else if (currentGroupValue < a029.vip4_originateValue) { vipLevel = "3"; rewardRate = a029.vip3_rewardRate; } else if (currentGroupValue < a029.vip5_originateValue) { vipLevel = "4"; rewardRate = a029.vip4_rewardRate; } else if (currentGroupValue < a029.vip6_originateValue) { vipLevel = "5"; rewardRate = a029.vip5_rewardRate; } else if (currentGroupValue < a029.vip7_originateValue) { vipLevel = "6"; rewardRate = a029.vip6_rewardRate; } else { vipLevel = "7"; rewardRate = a029.vip7_rewardRate; } //已奖励的V币 int rewardV = Convert.ToInt32 ( (from c in dbma1.F004s where c.userSN == userSN && c.rewardType == "充值奖励" select c.rewardAmount).Sum() ); return(string.Format("{{\"userName\":\"{0}\",\"vipConfig\":{1},\"currentGroupValue\":\"{2}\",\"vipLevel\":\"{3}\",\"rewardRate\":\"{4}\",\"rewardV\":\"{5}\",\"userSN\":\"{6}\"}}", userName, a029Str, currentGroupValue, vipLevel, rewardRate, rewardV, userSN)); } }