/// <summary>
/// 删除会员
/// </summary>
public void User_Del()
{
if (!EX_Admin.Power("user_del", "删除会员"))
{
AjaxNoPower();
return;
}
string id = RequestTool.RequestString("ids");
if (id == "")
{
Response.Write("{\"msg\":\"" + Tag("请选择要删除的信息") + "\"}");
return;
}
if (RequestTool.GetConfigKey("IsDelFalse").ToLower() == "true")
{
List <Lebi_User> users = B_Lebi_User.GetList("id in (lbsql{" + id + "})", "");
foreach (var u in users)
{
u.IsDel = 1;
B_Lebi_User.Update(u);
}
}
else
{
List <Lebi_Order> modellist = B_Lebi_Order.GetList("User_id in (lbsql{" + id + "})", "");
foreach (Lebi_Order model in modellist)
{
B_Lebi_Order.Delete("id = " + model.id + "");
B_Lebi_Order_Log.Delete("Order_id = " + model.id + "");
B_Lebi_Order_Product.Delete("Order_id = " + model.id + "");
}
B_Lebi_User.Delete("id in (lbsql{" + id + "})");
B_Lebi_Message.Delete("User_id_To in (lbsql{" + id + "})");
B_Lebi_User_Answer.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_User_Answer.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_User_BuyMoney.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_User_Card.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_User_Money.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_User_Point.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_User_Product.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_User_Address.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_Supplier.Delete("User_id in (lbsql{" + id + "})");
//B_Lebi_Supplier_ProductType.Delete("Supplier_id in (lbsql{" + id + "})");
//B_Lebi_Supplier_Verified_Log.Delete("Supplier_id in (lbsql{" + id + "})");
B_Lebi_Agent_Area.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_Agent_Money.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_Agent_Product.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_Agent_Product_request.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_Agent_Product_User.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_Bill.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_Cash.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_Comment.Delete("User_id in (lbsql{" + id + "})");
B_Lebi_weixin_qrcode.Delete("User_id in (lbsql{" + id + "})");
}
Log.Add("删除会员", "User", id.ToString(), CurrentAdmin, id.ToString());
Response.Write("{\"msg\":\"OK\"}");
}
/// <summary>
/// 编辑商品代理
/// </summary>
public void ProductAgentUser_Edit()
{
int id = RequestTool.RequestInt("id", 0);
Lebi_Agent_Product_User model = B_Lebi_Agent_Product_User.GetModel(id);
string User_UserName = RequestTool.RequestString("User_UserName");
if (User_UserName == "")
{
Response.Write("{\"msg\":\"" + Tag("用户名不能空") + "\"}");
return;
}
Lebi_User user = B_Lebi_User.GetModel("UserName=lbsql{'" + User_UserName + "'}");
if (user == null)
{
Response.Write("{\"msg\":\"" + Tag("用户不存在") + "\"}");
return;
}
int count = B_Lebi_Agent_Product_User.Counts("User_id=" + user.id + " and id!=" + id + "");
if (count > 0)
{
Response.Write("{\"msg\":\"" + Tag("用户已存在") + "\"}");
return;
}
if (model == null)
{
model = new Lebi_Agent_Product_User();
}
B_Lebi_Agent_Product_User.BindForm(model);
model.User_id = user.id;
if (model.id == 0)
{
//if (!EX_Admin.Power("supplier_group_add", "添加商家分组"))
//{
// AjaxNoPower();
// return;
//}
B_Lebi_Agent_Product_User.Add(model);
id = B_Lebi_Agent_Product_User.GetMaxId();
Log.Add("添加商品代理", "Agent_ProductUser", id.ToString(), CurrentAdmin);
}
else
{
//if (!EX_Admin.Power("supplier_group_edit", "编辑商家分组"))
//{
// AjaxNoPower();
// return;
//}
B_Lebi_Agent_Product_User.Update(model);
//Common.ExecuteSql("update Lebi_Agent_Product set Commission=" + model.Commission + " where User_id=" + model.User_id + "");
Log.Add("编辑商品代理", "Agent_ProductUser", id.ToString(), CurrentAdmin);
}
string result = "{\"msg\":\"OK\", \"id\":\"" + id + "\"}";
Response.Write(result);
}
public Lebi_Agent_Product_User GetAgentUser(int userid)
{
Lebi_Agent_Product_User auser = B_Lebi_Agent_Product_User.GetModel("User_id=" + userid + "");
if (auser == null)
{
auser = new Lebi_Agent_Product_User();
}
return(auser);
}
protected void Page_Load(object sender, EventArgs e)
{
PageSize = RequestTool.getpageSize(25);
key = RequestTool.RequestString("key");
string where = "1=1";
if (key != "")
{
where += " and User_UserName like '%" + key + "%'";
}
models = B_Lebi_Agent_Product_User.GetList(where, "id desc", PageSize, page);
int recordCount = B_Lebi_Agent_Product_User.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&key=" + key, page, PageSize, recordCount);
}
/// <summary>
/// 请求代理一个商品
/// </summary>
public void Product_Request()
{
int id = RequestTool.RequestInt("id");
int oldid = RequestTool.RequestInt("oldid");
Lebi_Agent_Product apro = B_Lebi_Agent_Product.GetModel(id);
if (apro == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
if (apro.User_id > 0)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
Lebi_Agent_Product_User user = B_Lebi_Agent_Product_User.GetModel("User_id=" + CurrentUser.id + "");
if (user == null)
{
user = new Lebi_Agent_Product_User();
}
if (user.Count_product_change - user.Count_product_change_used < 1)
{
//验证是否超过可用的修改次数
Response.Write("{\"msg\":\"" + Tag("无权修改") + "\"}");
return;
}
if (oldid == 0 && B_Lebi_Agent_Product.Counts("User_id=" + CurrentUser.id + "") >= user.Count_Product)
{
//验证是否超过代理商品的上限
Response.Write("{\"msg\":\"" + Tag("不能申请更多商品") + "\"}");
return;
}
Lebi_Agent_Product_request model = B_Lebi_Agent_Product_request.GetModel("User_id=" + CurrentUser.id + " and Product_id=" + apro.Product_id + " and Type_id_AgentProductRequestStatus=370");
if (model != null)
{
Response.Write("{\"msg\":\"" + Tag("不能重复申请") + "\"}");
return;
}
model = new Lebi_Agent_Product_request();
model.Product_id = apro.Product_id;
model.Type_id_AgentProductRequestStatus = 370;
model.User_id = CurrentUser.id;
model.User_UserName = CurrentUser.UserName;
model.Product_id_old = oldid;
B_Lebi_Agent_Product_request.Add(model);
Response.Write("{\"msg\":\"OK\"}");
}
/// <summary>
/// 删除商品代理
/// </summary>
public void ProductAgentUser_Del()
{
string ids = RequestTool.RequestString("ids");
//if (!EX_Admin.Power("supplier_group_del", "删除商家分组"))
//{
// AjaxNoPower();
// return;
//}
if (ids != "")
{
B_Lebi_Agent_Product_User.Delete("id in (lbsql{" + ids + "})");
//取消商品代理绑定
Common.ExecuteSql("update Lebi_Agent_Product set User_id=0,User_UserName='',Commission=0 where User_id in (lbsql{" + ids + "})");
}
Log.Add("删除商品代理级别", "Agent_ProductUser", ids, CurrentAdmin, ids);
Response.Write("{\"msg\":\"OK\"}");
}
protected void Page_Load(object sender, EventArgs e)
{
int id = RequestTool.RequestInt("id", 0);
//if (id == 0)
//{
// if (!EX_Admin.Power("supplier_group_edit", "添加商家分组"))
// {
// WindowNoPower();
// }
//}
//else
//{
// if (!EX_Admin.Power("supplier_group_edit", "编辑商家分组"))
// {
// WindowNoPower();
// }
//}
model = B_Lebi_Agent_Product_User.GetModel(id);
if (model == null)
{
model = new Lebi_Agent_Product_User();
}
}
/// <summary>
/// 余额购买其他内容
/// </summary>
public void BuyOther()
{
int keyid = RequestTool.RequestInt("keyid");
string tablename = RequestTool.RequestSafeString("tablename");
decimal postmoney = RequestTool.RequestDecimal("money");
string paypwd = RequestTool.RequestSafeString("paypwd");
decimal money = 0;
if (EX_User.MD5(paypwd) != CurrentUser.Pay_Password)
{
Response.Write("{\"msg\":\"" + Tag("支付密码错误") + "\"}");
return;
}
if (tablename == "Agent_Product_Level")
{
Lebi_Agent_Product_Level lev = B_Lebi_Agent_Product_Level.GetModel(keyid);
if (lev == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
Lebi_Agent_Product_User user = B_Lebi_Agent_Product_User.GetModel("User_id=" + CurrentUser.id + "");
if (user == null)
{
//新购买的情况
money = lev.Price;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
user = new Lebi_Agent_Product_User();
user.Agent_Product_Level_id = lev.id;
user.Commission = lev.Commission;
user.Count_Product = lev.Count_Product;
user.Count_product_change = lev.Count_product_change;
user.User_id = CurrentUser.id;
user.User_UserName = CurrentUser.UserName;
user.Time_end = System.DateTime.Now.AddYears(lev.Years);
B_Lebi_Agent_Product_User.Add(user);
}
else
{
if (user.Agent_Product_Level_id == lev.id)
{
//续费的情况
money = lev.Price;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
user.Time_end = user.Time_end.AddYears(lev.Years);
B_Lebi_Agent_Product_User.Update(user);
//更新代理商品的过期时间
}
else
{
//升级的情况
Lebi_Agent_Product_Level userlev = B_Lebi_Agent_Product_Level.GetModel(user.Agent_Product_Level_id);
if (userlev.Sort > lev.Sort)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
money = lev.Price - userlev.Price;
if (money < 0)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
user.Agent_Product_Level_id = lev.id;
user.Commission = lev.Commission;
user.Count_Product = lev.Count_Product;
user.Count_product_change = lev.Count_product_change;
B_Lebi_Agent_Product_User.Update(user);
}
}
EX_User.GiveUserCard(CurrentUser, lev.CardOrder_id);//赠送代金券
Money.AddMoney(CurrentUser, 0 - money, 196, null, "", "");
}
else if (tablename == "Agent_Area")
{
Lebi_Agent_Area area = B_Lebi_Agent_Area.GetModel(keyid);
if (area == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
if (area.User_id > 0 && area.User_id != CurrentUser.id)
{
Response.Write("{\"msg\":\"" + Tag("不能代理此区域") + "\"}");
return;
}
money = area.Price;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
if (area.User_id == 0)
{
//新购买的情况
area.User_id = CurrentUser.id;
area.User_UserName = CurrentUser.UserName;
area.Time_end = System.DateTime.Now.AddYears(1);
area.IsFailure = 0;
B_Lebi_Agent_Area.Update(area);
}
else
{
//续费的情况
area.Time_end = area.Time_end.AddYears(1);
area.IsFailure = 0;
B_Lebi_Agent_Area.Update(area);
}
EX_User.GiveUserCard(CurrentUser, area.CardOrder_id);//赠送代金券
Money.AddMoney(CurrentUser, 0 - money, 196, null, "", "");
}
else if (tablename == "suppliermargin")//供应商保证金
{
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel("User_id=" + CurrentUser.id);
if (supplier == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
//新购买的情况
money = supplier.Money_Margin - supplier.Money_Margin_pay;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
supplier.Money_Margin_pay += money;
B_Lebi_Supplier.Update(supplier);
Money.AddMoney(CurrentUser, 0 - money, 197, null, "", "");
}
else if (tablename == "suppliermargin")//供应商保证金
{
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel("User_id=" + CurrentUser.id);
if (supplier == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
money = supplier.Money_Margin - supplier.Money_Margin_pay;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
supplier.Money_Margin_pay += money;
B_Lebi_Supplier.Update(supplier);
Money.AddMoney(CurrentUser, 0 - money, 197, null, "", "");
}
else if (tablename == "supplierservice")//供应商服务费
{
Lebi_Supplier supplier = B_Lebi_Supplier.GetModel("User_id=" + CurrentUser.id);
if (supplier == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
Lebi_Supplier_Group group = B_Lebi_Supplier_Group.GetModel("id=" + supplier.Supplier_Group_id);
if (group == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
money = supplier.Money_Service;
if (money > CurrentUser.Money)
{
Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}");
return;
}
supplier.Time_End = supplier.Time_End.AddDays(group.ServiceDays);
B_Lebi_Supplier.Update(supplier);
Money.AddMoney(CurrentUser, 0 - money, 198, null, "", "");
}
Response.Write("{\"msg\":\"OK\"}");
}
/// <summary>
/// 处理商品代理申请
/// </summary>
public void ProductRequest_Manage()
{
int id = RequestTool.RequestInt("id");
int t = RequestTool.RequestInt("t");
Lebi_Agent_Product_request model = B_Lebi_Agent_Product_request.GetModel(id);
if (model == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
Lebi_Agent_Product pro = B_Lebi_Agent_Product.GetModel("Product_id=" + model.Product_id);
if (pro == null)
{
Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}");
return;
}
Lebi_Agent_Product_User user = B_Lebi_Agent_Product_User.GetModel("User_id=" + model.User_id + "");
if (user == null)
{
Response.Write("{\"msg\":\"" + Tag("此用户无代理资格") + "\"}");
return;
}
if (pro.User_id > 0)
{
Response.Write("{\"msg\":\"" + Tag("其他用户已代理此商品") + "\"}");
return;
}
if (t == 1)
{
if (model.Product_id_old > 0)//替换商品的情况。修改旧数据
{
Lebi_Agent_Product oldpro = B_Lebi_Agent_Product.GetModel("Product_id=" + model.Product_id_old + "");
if (oldpro != null)
{
if (oldpro.User_id != model.User_id)
{
Response.Write("{\"msg\":\"" + Tag("提换商品非此用户代理") + "\"}");
return;
}
oldpro.User_id = 0;
oldpro.User_UserName = "";
B_Lebi_Agent_Product.Update(oldpro);
}
}
model.Type_id_AgentProductRequestStatus = 371;
pro.User_id = model.User_id;
pro.User_UserName = model.User_UserName;
//pro.Commission = user.Commission;
B_Lebi_Agent_Product.Update(pro);
}
else
{
model.Type_id_AgentProductRequestStatus = 372;
}
model.Admin_id = CurrentAdmin.id;
model.Admin_UserName = CurrentAdmin.UserName;
B_Lebi_Agent_Product_request.Update(model);
Log.Add("处理代理商品申请", "Agent_Product", id.ToString(), CurrentAdmin);
Response.Write("{\"msg\":\"OK\"}");
}
