public static int UserCountmonth(Lebi_User user) { int UserCountmonth = 0; UserCountmonth = B_Lebi_User.Counts("User_id_parent=" + user.id + " and Time_Reg>'" + System.DateTime.Now.Date.AddDays(0 - System.DateTime.Now.Day).ToString("yyyy-MM-dd") + "'"); return(UserCountmonth); }
public static int UserCountday(Lebi_User user) { int UserCountday = 0; UserCountday = B_Lebi_User.Counts("User_id_parent=" + user.id + " and Time_Reg>'" + System.DateTime.Now.Date.ToString("yyyy-MM-dd") + "'"); return(UserCountday); }
public static int UserCount(Lebi_User user) { int UserCount = 0; UserCount = B_Lebi_User.Counts("User_id_parent=" + user.id + ""); return(UserCount); }
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { if (!Shop.Bussiness.B_API.Check("plugin_agent")) { Response.Write(Tag("权限不足")); Response.End(); } if (CurrentUser.id == 0) { Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + "")); } LoadTheme(themecode, siteid, languagecode, pcode); path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a class=\"text\"><span>" + Tag("推广佣金") + "</span></a>"; string money_ = Common.GetValue("select sum(Money) from Lebi_Agent_Money where User_id=" + CurrentUser.id + " and Type_id_AgentMoneyStatus=382 and datediff(d,Time_add,'" + System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "')>" + SYS.CommissionMoneyDays + ""); decimal.TryParse(money_, out money); UserCount = B_Lebi_User.Counts("User_id_parent=" + CurrentUser.id + ""); UserCountmonth = B_Lebi_User.Counts("User_id_parent=" + CurrentUser.id + " and Time_Reg>'" + System.DateTime.Now.Date.AddDays(0 - System.DateTime.Now.Day).ToString("yyyy-MM-dd") + "'"); UserCountday = B_Lebi_User.Counts("User_id_parent=" + CurrentUser.id + " and Time_Reg>'" + System.DateTime.Now.Date.ToString("yyyy-MM-dd") + "'"); }
public static Model Info(Lebi_User user) { BaseConfig bc = ShopCache.GetBaseConfig(); Model m = new Model(); decimal Money = 0; string money_ = Common.GetValue("select sum(Money) from Lebi_Agent_Money where User_id=" + user.id + " and Type_id_AgentMoneyStatus=382 and datediff(d,Time_add,'" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')>" + bc.CommissionMoneyDays + ""); decimal.TryParse(money_, out Money); int UserCount = 0; UserCount = B_Lebi_User.Counts("User_id_parent=" + user.id + ""); int UserCountmonth = 0; UserCountmonth = B_Lebi_User.Counts("User_id_parent=" + user.id + " and (datediff(d,Time_Reg,'" + System.DateTime.Now.Date.AddDays(0 - System.DateTime.Now.Day + 1).ToString("yyyy-MM-dd") + "')<=0 and datediff(d,Time_Reg,'" + System.DateTime.Now + "')>=0)"); int UserCountday = 0; UserCountday = B_Lebi_User.Counts("User_id_parent=" + user.id + " and (datediff(d,Time_Reg,'" + System.DateTime.Now.Date.ToString("yyyy-MM-dd") + "')<=0 and datediff(d,Time_Reg,'" + System.DateTime.Now + "')>=0)"); decimal Commission1 = 0; decimal Commission2 = 0; decimal Commission3 = 0; decimal.TryParse(bc.Angent1_Commission, out Commission1); decimal.TryParse(bc.Angent2_Commission, out Commission2); decimal.TryParse(bc.Angent3_Commission, out Commission3); if (user.DT_id == 0) { Lebi_Agent_UserLevel agent_userlevel = B_Lebi_Agent_UserLevel.GetModel("UserLevel_id = " + user.UserLevel_id + ""); if (agent_userlevel != null) { if (agent_userlevel.Angent1_Commission != -1) { Commission1 = agent_userlevel.Angent1_Commission; } if (agent_userlevel.Angent2_Commission != -1) { Commission2 = agent_userlevel.Angent2_Commission; } if (agent_userlevel.Angent3_Commission != -3) { Commission3 = agent_userlevel.Angent3_Commission; } } Lebi_Agent_User agent_user = B_Lebi_Agent_User.GetModel("User_id = " + user.id + ""); if (agent_user != null) { if (agent_user.Angent1_Commission != -1) { Commission1 = agent_user.Angent1_Commission; } if (agent_user.Angent2_Commission != -1) { Commission2 = agent_user.Angent2_Commission; } if (agent_user.Angent3_Commission != -1) { Commission3 = agent_user.Angent3_Commission; } } } else { Lebi_DT_Agent dt_agent = B_Lebi_DT_Agent.GetModel("DT_id = " + user.DT_id + ""); if (dt_agent != null) { if (dt_agent.IsUsedAgent == 1) { Commission1 = dt_agent.Angent1_Commission; Commission2 = dt_agent.Angent2_Commission; Commission3 = dt_agent.Angent3_Commission; } } } m.Money = Money; m.UserCount = UserCount; m.UserCountmonth = UserCountmonth; m.UserCountday = UserCountday; m.Commission1 = Commission1; m.Commission2 = Commission2; m.Commission3 = Commission3; Lebi_UserLevel userlevel = B_Lebi_UserLevel.GetModel(user.UserLevel_id); if (userlevel != null) { if (userlevel.IsUsedAgent == 0) //关闭注册 { m.Commission1 = 0; m.Commission2 = 0; m.Commission3 = 0; } } return(m); }