/// <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);
}
}
