protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { 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 href=\"" + URL("P_UserPointToMoney", "") + "\"><span>" + Tag("积分转换") + "</span></a>"; key = Rstring("key"); dateFrom = Rstring("dateFrom"); dateTo = Rstring("dateTo"); where = "User_id=" + CurrentUser.id + ""; if (key != "") { where += " and (Remark like lbsql{'%" + key + "%'})"; } if (dateFrom != "" && dateTo != "") { where += " and (datediff(d,Time_Add,'" + dateFrom + "')<=0 and datediff(d,Time_Add,'" + dateTo + "')>=0)"; } user_points = B_Lebi_User_Point.GetList(where, "id desc", PageSize, pageindex); int recordCount = B_Lebi_User_Point.Counts(where); PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage); }
/// <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\"}"); }
protected void Page_Load(object sender, EventArgs e) { id = RequestTool.RequestInt("id", 0); if (id == 0) { if (!EX_Admin.Power("user_point_add", "添加会员积分")) { WindowNoPower(); } } else { if (!EX_Admin.Power("user_point_edit", "编辑会员积分")) { WindowNoPower(); } } int user_id = RequestTool.RequestInt("user_id", 0); model = B_Lebi_User_Point.GetModel(id); if (model == null) { model = new Lebi_User_Point(); model.Type_id_PointStatus = 171; Point = ""; } else { //user_id = model.User_id; Point = model.Point.ToString(); mode = "user"; } Lebi_User user = B_Lebi_User.GetModel(user_id); if (user == null) { User_Name = RequestTool.RequestString("User_Name"); user = B_Lebi_User.GetModel("UserName=lbsql{'" + User_Name + "'}"); } if (user != null) { mode = "user"; User_Name = user.UserName; } user_ids = RequestTool.RequestString("ids"); if (user_ids != "") { users = B_Lebi_User.GetList("id in (lbsql{" + user_ids + "})", "id desc"); mode = "users"; } su = new SearchUser(CurrentAdmin, CurrentLanguage.Code); }
/// <summary> /// 积分转换 /// </summary> public void PointToMoney() { string t = RequestTool.RequestSafeString("t"); if (!CurrentUserLevel.PointToMoney.Contains(t)) { Response.Write("{\"msg\":\"" + Tag("非法提交") + "\"}"); return; } string[] arr = t.Split(':'); if (arr.Length != 2) { Response.Write("{\"msg\":\"" + Tag("非法提交") + "\"}"); return; } if (Convert.ToDecimal(arr[0]) > Convert.ToDecimal(CurrentUser.Point)) { Response.Write("{\"msg\":\"" + Tag("积分不足") + "\"}"); return; } Lebi_User_Money model = new Lebi_User_Money(); model.Money = Convert.ToDecimal(arr[1]); model.Type_id_MoneyStatus = 181; model.Type_id_MoneyType = 194; model.Remark = "积分兑换"; model.Time_Update = DateTime.Now; model.User_id = CurrentUser.id; model.User_RealName = CurrentUser.RealName; model.User_UserName = CurrentUser.UserName; B_Lebi_User_Money.Add(model); Lebi_User_Point pmodel = new Lebi_User_Point(); pmodel.Point = 0 - Convert.ToDecimal(arr[0]); pmodel.Type_id_PointStatus = 171; pmodel.Remark = "积分兑换"; pmodel.Time_Update = DateTime.Now; pmodel.User_id = CurrentUser.id; pmodel.User_RealName = CurrentUser.RealName; pmodel.User_UserName = CurrentUser.UserName; B_Lebi_User_Point.Add(pmodel); CurrentUser.Point = CurrentUser.Point - Convert.ToDecimal(arr[0]); CurrentUser.Money = CurrentUser.Money + Convert.ToDecimal(arr[1]); B_Lebi_User.Update(CurrentUser); //发送短信 //Lebi_User user = B_Lebi_User.GetModel(CurrentUser.id); SMS.SendSMS_balance(CurrentUser); Response.Write("{\"msg\":\"OK\"}"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("userpoint_list", "会员积分列表")) { PageReturnMsg = PageNoPowerMsg(); } PageSize = RequestTool.getpageSize(25); int user_id = RequestTool.RequestInt("user_id", 0); key = RequestTool.RequestString("key"); dateFrom = RequestTool.RequestString("dateFrom"); dateTo = RequestTool.RequestString("dateTo"); status = RequestTool.RequestInt("status", 0); DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); string where = "1=1"; if (user_id > 0) { where += " and User_id=" + user_id; } if (status > 0) { where += " and Type_id_PointStatus=" + status + ""; } if (key != "") { where += " and User_id in (select id from [Lebi_User] where UserName like lbsql{'%" + key + "%'} or RealName like lbsql{'%" + key + "%'})"; } if (dateFrom != "" && dateTo != "") { where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)"; } models = B_Lebi_User_Point.GetList(where, "id desc", PageSize, page); int recordCount = B_Lebi_User_Point.Counts(where); PageString = Pager.GetPaginationString("?page={0}&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&status = " + status, page, PageSize, recordCount); user = B_Lebi_User.GetModel(user_id); if (user == null) { user = new Lebi_User(); user.UserName = Tag("全部会员"); } }
/// <summary> /// 编辑会员积分 /// </summary> public void UserPoint_Edit() { int id = RequestTool.RequestInt("id", 0); SearchUser su = new SearchUser(CurrentAdmin, CurrentLanguage.Code); if (id > 0) { if (!EX_Admin.Power("user_point_edit", "编辑会员积分")) { AjaxNoPower(); return; } Lebi_User_Point model = B_Lebi_User_Point.GetModel(id); Lebi_User user = B_Lebi_User.GetModel(model.User_id); Log.Add("编辑会员积分", "User_Point", id.ToString(), CurrentAdmin, user.UserName); if (user == null) { Response.Write("{\"msg\":\"" + Tag("会员账号不存在") + "\"}"); return; } model.Point = RequestTool.RequestDecimal("Point", 0); model.Type_id_PointStatus = RequestTool.RequestInt("Type_id_PointStatus", 0); model.Admin_UserName = CurrentAdmin.UserName; model.Admin_id = CurrentAdmin.id; model.Remark = RequestTool.RequestString("Remark"); model.Time_Update = DateTime.Now; B_Lebi_User_Point.Update(model); Point.UpdateUserPoint(user); } else { if (!EX_Admin.Power("user_point_add", "添加会员积分")) { AjaxNoPower(); return; } string Mode = RequestTool.RequestString("mode"); string User_Name_To = RequestTool.RequestString("User_Name_To"); string UserLevel_ids = RequestTool.RequestString("UserLevel_ids"); string User_ids = RequestTool.RequestString("User_ids"); string UserName_ids = RequestTool.RequestString("UserName_ids"); if (Mode == "user") { Lebi_User user = B_Lebi_User.GetModel("UserName = lbsql{'" + User_Name_To + "'}"); if (user == null) { Response.Write("{\"msg\":\"" + Tag("会员账号不存在") + "\"}"); return; } Lebi_User_Point model = new Lebi_User_Point(); Log.Add("添加会员积分", "User_Point", id.ToString(), CurrentAdmin, User_Name_To + " ->" + RequestTool.RequestDecimal("Point", 0)); model.Point = RequestTool.RequestDecimal("Point", 0); model.Type_id_PointStatus = RequestTool.RequestInt("Type_id_PointStatus", 0); model.Admin_UserName = CurrentAdmin.UserName; model.Admin_id = CurrentAdmin.id; model.Remark = RequestTool.RequestString("Remark"); model.Time_Update = DateTime.Now; model.User_id = user.id; model.User_RealName = user.RealName; model.User_UserName = user.UserName; B_Lebi_User_Point.Add(model); Point.UpdateUserPoint(user); } else { string where = ""; int i = 0; if (User_ids == "") { where = "1=1 " + su.SQL; Log.Add("添加会员积分", "User_Point", "", CurrentAdmin, su.Description + " ->" + RequestTool.RequestDecimal("Point", 0)); } else { where = "id in (" + User_ids + ")"; Log.Add("添加会员积分", "User_Point", "", CurrentAdmin, UserName_ids + " ->" + RequestTool.RequestDecimal("Point", 0)); } List <Lebi_User> modellist = B_Lebi_User.GetList(where, ""); foreach (Lebi_User user in modellist) { Lebi_User_Point model = new Lebi_User_Point(); model.Point = RequestTool.RequestDecimal("Point", 0); model.Type_id_PointStatus = RequestTool.RequestInt("Type_id_PointStatus", 0); model.Admin_UserName = CurrentAdmin.UserName; model.Admin_id = CurrentAdmin.id; model.Remark = RequestTool.RequestString("Remark"); model.Time_Update = DateTime.Now; model.User_id = user.id; model.User_RealName = user.RealName; model.User_UserName = user.UserName; B_Lebi_User_Point.Add(model); Point.UpdateUserPoint(user); } } } string result = "{\"msg\":\"OK\"}"; Response.Write(result); }