/// <summary> /// 处理商品代理过期 /// </summary> public static void AgentProductEnd() { List <Lebi_Agent_Product_User> users = B_Lebi_Agent_Product_User.GetList("User_id>0 and datediff(d,Time_end,'" + System.DateTime.Now.Date + "')>" + ShopCache.GetBaseConfig().AgentEndDays + "", ""); foreach (Lebi_Agent_Product_User user in users) { //user.IsFailure = 1; B_Lebi_Agent_Product_User.Delete(user.id); //清除代理商品绑定 Common.ExecuteSql("update [Lebi_Agent_Product] set User_id=0,User_UserName='' where User_id=" + user.id + ""); } }
/// <summary> /// 处理商品代理过期 /// </summary> public static void AgentProductEnd() { int d = 0; int.TryParse(ShopCache.GetBaseConfig().AgentEndDays, out d); d = 0 - d; List <Lebi_Agent_Product_User> users = B_Lebi_Agent_Product_User.GetList("User_id>0 and Time_end<'" + System.DateTime.Now.Date.AddDays(d) + "'", ""); foreach (Lebi_Agent_Product_User user in users) { //user.IsFailure = 1; B_Lebi_Agent_Product_User.Delete(user.id); //清除代理商品绑定 Common.ExecuteSql("update [Lebi_Agent_Product] set User_id=0,User_UserName='' where User_id=" + user.id + ""); } }
/// <summary> /// 单品代理佣金 /// </summary> private void AgentProductMoney() { List <Lebi_Order_Product> Products = B_Lebi_Order_Product.GetList("Order_id=" + Order.id + "", ""); if (Products == null) { return; } int pid = 0; decimal money = 0; Lebi_Agent_Product_User auser; foreach (Lebi_Order_Product model in Products) { Lebi_Product pro = B_Lebi_Product.GetModel(model.Product_id); pid = pro.Product_id == 0 ? pro.id : pro.Product_id; Lebi_Agent_Product apro = B_Lebi_Agent_Product.GetModel("Product_id=" + pid + ""); if (apro == null) { continue; } auser = B_Lebi_Agent_Product_User.GetModel("User_id=" + apro.User_id + " and IsFailure=0"); if (auser == null) { continue; } if (auser.Time_end.Date < System.DateTime.Now.Date) { continue; } Lebi_User user = B_Lebi_User.GetModel(apro.User_id); if (user == null) { continue; } money = model.Price * model.Count * auser.Commission / 100; AddMoney(money, user, 392, 0, model.Product_id, pid, pro.Number); } }