/// <summary> /// 会员数据 /// </summary> /// <param name="lang"></param> /// <returns></returns> public string CreateTree() { string str = ""; List <Lebi_UserLevel> types = B_Lebi_UserLevel.GetList("", "Grade asc"); string WebPath = RequestTool.GetConfigKey("WebPath").Trim().TrimEnd('/'); WebPath = WebPath + "/theme/system/systempage/admin/images/"; string showids = LB.Tools.CookieTool.GetCookieString("showUserLevelids").Replace("%2C", ","); string image = ""; foreach (Lebi_UserLevel t in types) { if (!string.IsNullOrEmpty(RequestTool.GetConfigKey("SystemAdmin").Trim())) { str += "<li><a href=\"javascript:void(0)\" onclick=\"searchproduct(" + t.id + ")\">" + Lang(t.Name) + "</a></li>"; } else { image = WebPath + "plus.gif"; str += "<tr class=\"list\" name=\"tr" + t.id + "\" id=\"tr" + t.id + "\">"; str += "<td><img src=\"" + image + "\" name=\"imgu" + t.id + "\" id=\"imgu" + t.id + "\" style=\"cursor: pointer; text-align: center; vertical-align:absmiddle\" />"; str += "<a href=\"javascript:void(0)\" onclick=\"searchproduct(" + t.id + ")\">" + Lang(t.Name) + " </a></td></tr>"; } } return(str); }
protected void Page_Load(object sender, EventArgs e) { int id = RequestTool.RequestInt("id", 0); if (id == 0) { if (!EX_Admin.Power("promotion_add", "添加促销活动")) { PageNoPower(); } } else { if (!EX_Admin.Power("promotion_edit", "编辑促销活动")) { PageNoPower(); } } model = B_Lebi_Promotion_Type.GetModel(id); if (model == null) { model = new Lebi_Promotion_Type(); model.Type_id_PromotionStatus = 240; model.Type_id_PromotionType = 421; } userlevels = B_Lebi_UserLevel.GetList("", "Grade desc"); }
protected void Page_Load(object sender, EventArgs e) { id = RequestTool.RequestInt("id", 0); if (id == 0) { if (!Power("supplier_product_add", "添加商品")) { PageReturnMsg = PageNoPowerMsg(); } addflag = true; } else { if (!Power("supplier_product_edit", "编辑商品")) { PageReturnMsg = PageNoPowerMsg(); } } action = RequestTool.RequestInt("action", 1); model = B_Lebi_Product.GetModel("(IsDel!=1 or IsDel is null) and Supplier_id = " + CurrentSupplier.id + " and id = " + id + ""); if (model == null) { model = new Lebi_Product(); Lebi_Product modellast = B_Lebi_Product.GetModel("(IsDel!=1 or IsDel is null) and Supplier_id = " + CurrentSupplier.id + " order by Time_Edit desc,id desc"); if (modellast != null) { model.Pro_Type_id = modellast.Pro_Type_id; } } if (model.Images != "") { if (model.Images.Substring(model.Images.Length - 1, 1) == "@") { model.Images = model.Images.Substring(0, model.Images.Length - 1); } if (model.Images.Substring(0, 1) != "@") { model.Images = "@" + model.Images; } } wap = Ishavewap(); StepPrices = EX_Product.StepPrice(model.StepPrice); if (StepPrices == null) { StepPrices = new List <ProductStepPrice>(); } UserLevelPrices = EX_Product.UserLevelPrice(model.UserLevelPrice); if (UserLevelPrices == null) { UserLevelPrices = new List <ProductUserLevelPrice>(); } UserLevelCounts = EX_Product.UserLevelCount(model.UserLevelCount); if (UserLevelCounts == null) { UserLevelCounts = new List <ProductUserLevelCount>(); } userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("statis_userlevel", "分组统计")) { PageReturnMsg = PageNoPowerMsg(); } models = B_Lebi_UserLevel.GetList("Grade > 0", "Grade asc"); }
protected void Page_Load(object sender, EventArgs e) { Random Random = new Random(); randnum = RequestTool.RequestInt("randnum", 0); id = RequestTool.RequestInt("id", 0); if (id == 0 || (id > 0 && randnum > 0)) { if (!EX_Admin.Power("product_add", "添加商品")) { PageNoPower(); } } else { if (!EX_Admin.Power("product_edit", "编辑商品")) { PageNoPower(); } } action = RequestTool.RequestInt("action", 1); model = B_Lebi_Product.GetModel(id); if (model == null) { model = new Lebi_Product(); model.Type_id_ProductType = 320; } wap = Ishavewap(); StepPrices = EX_Product.StepPrice(model.StepPrice); if (StepPrices == null) { StepPrices = new List <ProductStepPrice>(); } UserLevelPrices = EX_Product.UserLevelPrice(model.UserLevelPrice); if (UserLevelPrices == null) { UserLevelPrices = new List <ProductUserLevelPrice>(); } UserLevelCounts = EX_Product.UserLevelCount(model.UserLevelCount); if (UserLevelCounts == null) { UserLevelCounts = new List <ProductUserLevelCount>(); } userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); if (model.IsCombo == 1) { comboProducts = B_Lebi_Product_Combo.GetList("Product_id=" + model.id + "", ""); } else { comboProducts = new List <Lebi_Product_Combo>(); } }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("agent_config", "代理-参数设置")) { PageReturnMsg = PageNoPowerMsg(); } PageSize = RequestTool.getpageSize(25); string where = "Grade > 0"; models = B_Lebi_UserLevel.GetList(where, "Grade asc", PageSize, page); int recordCount = B_Lebi_UserLevel.Counts(where); PageString = Pager.GetPaginationString("?page={0}", page, PageSize, recordCount); }
public string userlevels_checkbox(string name, string ids, string ex = "") { string str = ""; List <Lebi_UserLevel> ms = B_Lebi_UserLevel.GetList("", "Grade asc"); foreach (Lebi_UserLevel m in ms) { string sel = ""; if (("," + ids + ",").Contains("," + m.id + ",")) { sel = "checked"; } str += "<label><input type=\"checkbox\" name=\"" + name + "\" value=\"" + m.id + "\" " + sel + " " + ex + ">" + Lang(m.Name) + "</label> "; } return(str); }
protected void Page_Load(object sender, EventArgs e) { int id = RequestTool.RequestInt("id", 0); model = B_Lebi_User.GetModel(id); if (model == null) { if (!EX_Admin.Power("user_add", "添加会员")) { PageReturnMsg = PageNoPowerMsg(); } model = new Lebi_User(); model.Sex = "男"; if (SYS.IsOpenUserEnd == "1") { int days = 365; try { int.TryParse(SYS.DefaultUserEndDays, out days); } catch { } model.Time_End = DateTime.Now.AddDays(days); } } else { if (!EX_Admin.Power("user_edit", "编辑会员")) { PageReturnMsg = PageNoPowerMsg(); } if (domain3admin && CurrentAdmin.Site_ids != "") { if (!("," + CurrentAdmin.Site_ids + ",").Contains("," + model.Site_id + ",")) { PageError(); return; } } } leaves = B_Lebi_UserLevel.GetList("1=1", "Grade asc"); }
protected void Page_Load(object sender, EventArgs e) { Random Random = new Random(); randnum = RequestTool.RequestInt("randnum", 0); id = RequestTool.RequestInt("id", 0); if (id == 0 || (id > 0 && randnum > 0)) { if (!Power("supplier_product_add", "添加商品")) { PageNoPower(); } } else { if (!Power("supplier_product_edit", "编辑商品")) { PageNoPower(); } } action = RequestTool.RequestInt("action", 1); model = B_Lebi_Product.GetModel("Supplier_id = " + CurrentSupplier.id + " and (IsDel!=1 or IsDel is null) and id = " + id); if (model == null) { model = new Lebi_Product(); model.Type_id_ProductType = 320; } wap = Ishavewap(); StepPrices = EX_Product.StepPrice(model.StepPrice); if (StepPrices == null) { StepPrices = new List <ProductStepPrice>(); } UserLevelPrices = EX_Product.UserLevelPrice(model.UserLevelPrice); if (UserLevelPrices == null) { UserLevelPrices = new List <ProductUserLevelPrice>(); } UserLevelCounts = EX_Product.UserLevelCount(model.UserLevelCount); if (UserLevelCounts == null) { UserLevelCounts = new List <ProductUserLevelCount>(); } userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); }
/// <summary> /// 删除会员分组 /// </summary> public void UserLevel_Del() { int id = RequestTool.RequestInt("id", 0); if (!EX_Admin.Power("userlevel_del", "删除会员分组")) { AjaxNoPower(); return; } //Lebi_Page model = B_Lebi_Page.GetModel(id); // if (model == null) //{ // Response.Write("{\"msg\":\"" + Tag("参数错误") +"\"}"); // return; //} //<-{删除会员分组,等级更新为上一等级 by kingdge int UserLevel_id = 1; Lebi_UserLevel model = B_Lebi_UserLevel.GetModel(id); if (model == null) { UserLevel_id = 1; } else { UserLevel_id = model.id; } Common.ExecuteSql("Update Lebi_User set UserLevel_id = " + UserLevel_id + " where UserLevel_id = " + id + ""); //}-> List <Lebi_UserLevel> ls = B_Lebi_UserLevel.GetList("id in (lbsql{" + id + "})", ""); foreach (var l in ls) { int count = B_Lebi_User.Counts("(IsDel!=1 or IsDel is null) and UserLevel_id=" + l.id + ""); if (count > 0) { Response.Write("{\"msg\":\"分组下存在账号,不能删除\"}"); return; } } B_Lebi_UserLevel.Delete("id in (lbsql{" + id + "})"); Log.Add("删除会员分组", "UserLevel", id.ToString(), CurrentAdmin, id.ToString()); Response.Write("{\"msg\":\"OK\"}"); }
public string userlevel(string ids) { if (ids == "") { return(""); } string str = ""; List <Lebi_UserLevel> ls = B_Lebi_UserLevel.GetList("id in (lbsql{" + ids + "})", ""); foreach (Lebi_UserLevel l in ls) { if (str == "") { str = Lang(l.Name); } else { str += "," + Lang(l.Name); } } return(str); }
public string Login(string back, int IsLogin = 1, int DT_id = 0) { string code = RequestTool.RequestString("code"); string res = ""; StringBuilder sb; if (code != "") { try { sb = new StringBuilder(); sb.Append("?grant_type=authorization_code"); sb.Append("&client_id=" + appid); sb.Append("&client_secret=" + appkey); sb.Append("&code=" + code); string uri = reurnurl + "?backurl=" + ENBackuri(back); uri = System.Web.HttpUtility.UrlEncode(uri); sb.Append("&redirect_uri=" + uri); res = PostAPI("oauth/access_token", sb.ToString()); res = res + "&"; string access_token = RegexTool.GetRegValue(res, "access_token=(.*?)&"); JavaScriptSerializer jss = new JavaScriptSerializer(); //获取uid sb = new StringBuilder(); sb.Append("?access_token=" + access_token); res = GetAPI("me", sb.ToString()); Model.Facebook.userinfo model = jss.Deserialize <Model.Facebook.userinfo>(res); string uid = model.id; //return uid; string where = "bind_facebook_id='" + uid + "'"; //if (DT_id > 0) //{ // where += " and DT_id =" + DT_id + ""; //} Shop.Model.Lebi_User user = B_Lebi_User.GetModel(where); Lebi_User CurrentUser = EX_User.CurrentUser(); if (model == null) { model = new Model.Facebook.userinfo(); } if (model.picture == null) { model.picture = new Model.Facebook.userinfo.picture_(); } if (model.picture.data == null) { model.picture.data = new Model.Facebook.userinfo.picture_.data_(); model.picture.data.url = ""; } string username = model.last_name + model.first_name; if (CurrentUser.id > 0)//已经登录 { if (IsLogin == 0) { if (user != null) { if (CurrentUser.id != user.id) { return("已绑定其它帐号"); } } } CurrentUser.bind_facebook_id = uid; CurrentUser.bind_facebook_nickname = username; CurrentUser.bind_facebook_token = access_token; if (CurrentUser.Face == "") { CurrentUser.Face = model.picture.data.url;//头像 } B_Lebi_User.Update(CurrentUser); } else { if (user == null) { Lebi_UserLevel defaultlevel = B_Lebi_UserLevel.GetModel("Grade>0 order by Grade asc"); if (defaultlevel == null) { defaultlevel = new Lebi_UserLevel(); } if (defaultlevel.RegisterType == 0) //关闭注册 { return("会员注册已关闭"); } user = new Lebi_User(); user.bind_facebook_id = uid; user.bind_facebook_nickname = username; user.bind_facebook_token = access_token; user.Face = model.picture.data.url; user.NickName = username; user.UserName = "******" + uid; user.Password = EX_User.MD5(uid); user.Language = Language.CurrentLanguage().Code; user.Sex = model.gender == "female" ? "女" : "男"; user.UserLevel_id = B_Lebi_UserLevel.GetList("Grade>0", "Grade asc").FirstOrDefault().id; user.IsPlatformAccount = 1; if (CurrentSite != null) { user.Site_id = CurrentSite.id; } B_Lebi_User.Add(user); user.id = B_Lebi_User.GetMaxId(); EX_User.LoginOK(user); } else { user.bind_facebook_id = uid; user.bind_facebook_nickname = username; user.bind_facebook_token = access_token; if (user.Face == "") { user.Face = model.picture.data.url; } //user.Sex = model.gender == "female" ? "女" : "男"; B_Lebi_User.Update(user); EX_User.LoginOK(user); } } return("OK"); } catch { return("授权失败"); } } return("授权失败"); }
public string Login(string back, int IsLogin = 1) { string code = RequestTool.RequestString("code"); if (code != "") { try { StringBuilder sb = new StringBuilder(); sb.Append("?grant_type=authorization_code"); sb.Append("&client_id=" + appid); sb.Append("&client_secret=" + appkey); sb.Append("&code=" + code); string uri = reurnurl + "?backurl=" + ENBackuri(back); uri = System.Web.HttpUtility.UrlEncode(uri); sb.Append("&redirect_uri=" + uri); string res = PostAPI("token", sb.ToString()); JavaScriptSerializer jss = new JavaScriptSerializer(); Model.Taobao.token token = jss.Deserialize <Model.Taobao.token>(res); string access_token = token.access_token; string uid = token.taobao_user_id; string username = token.taobao_user_nick; //获取详细个人信息 sb = new StringBuilder(); sb.Append("&access_token=" + access_token); res = GetAPI("taobao.user.buyer.get", sb.ToString(), false); Model.Taobao.userinfo model = jss.Deserialize <Model.Taobao.userinfo>(res); if (model == null) { model = new Model.Taobao.userinfo(); } if (model.user_buyer_get_response == null) { model.user_buyer_get_response = new Model.Taobao.userinfo.user_buyer_get_response_(); } if (model.user_buyer_get_response.user == null) { model.user_buyer_get_response.user = new Model.Taobao.userinfo.user_buyer_get_response_.user_(); model.user_buyer_get_response.user.sex = "m"; model.user_buyer_get_response.user.avatar = ""; } if (model.user_buyer_get_response.user.location == null) { model.user_buyer_get_response.user.location = new Model.Taobao.userinfo.user_buyer_get_response_.user_.location_(); } string where = "bind_taobao_id='" + uid + "'"; //if (DT_id > 0) //{ // where += " and DT_id =" + DT_id + ""; //} Lebi_User user = B_Lebi_User.GetModel(where); Lebi_User CurrentUser = EX_User.CurrentUser(); if (CurrentUser.id > 0)//已经登录 { if (IsLogin == 0) { if (user != null) { if (CurrentUser.id != user.id) { return("已绑定其它帐号"); } } } CurrentUser.bind_taobao_id = uid; CurrentUser.bind_taobao_nickname = username; CurrentUser.bind_taobao_token = access_token; if (CurrentUser.Face == "") { CurrentUser.Face = model.user_buyer_get_response.user.avatar;//头像 } CurrentUser.DT_id = DT_id; B_Lebi_User.Update(CurrentUser); } else { if (user == null) { Lebi_UserLevel defaultlevel = B_Lebi_UserLevel.GetModel("Grade>0 order by Grade asc"); if (defaultlevel == null) { defaultlevel = new Lebi_UserLevel(); } if (defaultlevel.RegisterType == 0) //关闭注册 { return("会员注册已关闭"); } user = new Lebi_User(); user.bind_taobao_id = uid; user.bind_taobao_nickname = username; user.bind_taobao_token = access_token; user.UserName = "******" + uid; user.NickName = username; user.Password = EX_User.MD5(uid); user.Language = Language.CurrentLanguage().Code; user.Sex = model.user_buyer_get_response.user.sex == "f" ? "女" : "男"; user.Face = model.user_buyer_get_response.user.avatar;//头像 user.UserLevel_id = B_Lebi_UserLevel.GetList("Grade>0", "Grade asc").FirstOrDefault().id; user.IsPlatformAccount = 1; if (CurrentSite != null) { user.Site_id = CurrentSite.id; } user.DT_id = DT_id; B_Lebi_User.Add(user); user.id = B_Lebi_User.GetMaxId(); EX_User.LoginOK(user); } else { user.bind_taobao_id = uid; user.bind_taobao_nickname = username; user.bind_taobao_token = access_token; if (user.Face == "") { user.Face = model.user_buyer_get_response.user.avatar;//头像 } //user.Sex = model.user_buyer_get_response.user.sex == "f" ? "女" : "男"; user.DT_id = DT_id; B_Lebi_User.Update(user); EX_User.LoginOK(user); } } return("OK"); } catch { return("授权失败"); } } return("授权失败"); }
protected void Page_Load(object sender, EventArgs e) { Random Random = new Random(); t = RequestTool.RequestString("t"); id = RequestTool.RequestInt("id", 0); model = B_Lebi_Product.GetModel(id); int Type_id_ProductType = RequestTool.RequestInt("Type_id_ProductType", 320); if (id == 0 || (id > 0 && t == "copy")) { if (!EX_Admin.Power("product_add", "添加商品")) { PageReturnMsg = PageNoPowerMsg(); } ////如果添加商品时随机数小于9位数 重定向生成随机数 防止破坏已有数据 //if (randnum.ToString().Length < 9) //{ // Response.Redirect(site.AdminPath + "/product/product_edit.aspx?id=" + id + "&t=" + t + "&randnum=" + Random.Next(100000000, 999999999)); // Response.End(); // return; //} } else { if (!EX_Admin.Power("product_edit", "编辑商品")) { PageReturnMsg = PageNoPowerMsg(); } if (site.SiteCount > 1 && CurrentAdmin.Site_ids != "" && model.Site_ids != "") { string[] psids = model.Site_ids.Split(','); bool flag = false; foreach (string pdis in psids) { if (("," + CurrentAdmin.Site_ids + ",").Contains("," + pdis + ",")) { flag = true; } } if (!flag) { PageReturnMsg = PageErrorMsg(); } } } action = RequestTool.RequestInt("action", 1); if (model == null) { model = new Lebi_Product(); model.Site_ids = site.Sitesid(); model.Type_id_ProductType = Type_id_ProductType; Lebi_Product modellast = B_Lebi_Product.GetModel("Type_id_ProductType = " + Type_id_ProductType + " and Supplier_id = 0 order by Time_Edit desc,id desc"); if (modellast != null) { model.Pro_Type_id = modellast.Pro_Type_id; } } else { if (t == "copy") { model.id = 0; } } if (model.Images != "") { if (model.Images.Substring(model.Images.Length - 1, 1) == "@") { model.Images = model.Images.Substring(0, model.Images.Length - 1); } if (model.Images.Substring(0, 1) != "@") { model.Images = "@" + model.Images; } } StepPrices = EX_Product.StepPrice(model.StepPrice); if (StepPrices == null) { StepPrices = new List <ProductStepPrice>(); } UserLevelPrices = EX_Product.UserLevelPrice(model.UserLevelPrice); if (UserLevelPrices == null) { UserLevelPrices = new List <ProductUserLevelPrice>(); } UserLevelCounts = EX_Product.UserLevelCount(model.UserLevelCount); if (UserLevelCounts == null) { UserLevelCounts = new List <ProductUserLevelCount>(); } userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); wap = Ishavewap(); if (model.IsCombo == 1) { comboProducts = B_Lebi_Product_Combo.GetList("Product_id=" + model.id + "", ""); } else { comboProducts = new List <Lebi_Product_Combo>(); } }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("product_batch_edit", "批量编辑")) { PageReturnMsg = PageNoPowerMsg(); } PageSize = RequestTool.getpageSize(25); key = RequestTool.RequestString("key"); Pro_Type_id = RequestTool.RequestString("Pro_Type_id"); status = RequestTool.RequestInt("status", 0); brand = RequestTool.RequestInt("brand", 0); tag = RequestTool.RequestInt("tag", 0); dateFrom = RequestTool.RequestString("dateFrom"); dateTo = RequestTool.RequestString("dateTo"); OrderBy = RequestTool.RequestString("OrderBy"); lang = RequestTool.RequestString("lang"); DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); Type_id_ProductType = RequestTool.RequestInt("Type_id_ProductType", 320); if (lang == "") { lang = "CN"; } string where = "Product_id=0"; if (Pro_Type_id != "") { where += " and Pro_Type_id in (" + Shop.Bussiness.EX_Product.Categoryid(Pro_Type_id) + ")"; } if (status > 0) { where += " and Type_id_ProductStatus=" + status + ""; } if (Type_id_ProductType > 0) { where += " and Type_id_ProductType=" + Type_id_ProductType + ""; } if (tag > 0) { if (DataBase.DBType == "sqlserver") { where += " and Charindex('" + tag + "',Pro_Tag_id)>0"; } if (DataBase.DBType == "access") { where += " and Instr(Pro_Tag_id,'" + tag + "')>0"; } } if (brand > 0) { where += " and Brand_id=" + brand + ""; } if (key != "") { where += " and (Name like lbsql{'%" + key + "%'} or Number 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)"; } if (CurrentAdmin.Pro_Type_ids != "") { string[] ids = CurrentAdmin.Pro_Type_ids.Split(','); string sonwhere = ""; foreach (string id in ids) { sonwhere += " or Path like '%," + id + ",%'"; } sonwhere = "select id from Lebi_Pro_Type where id in (" + CurrentAdmin.Pro_Type_ids + ")" + sonwhere; where += " and Pro_Type_id in (" + sonwhere + ")"; } if (OrderBy == "StatusDesc") { orderstr = " Type_id_ProductStatus desc"; } else if (OrderBy == "StatusAsc") { orderstr = " Type_id_ProductStatus asc"; } else if (OrderBy == "ViewsDesc") { orderstr = " Count_Views desc"; } else if (OrderBy == "ViewsAsc") { orderstr = " Count_Views asc"; } else if (OrderBy == "SalesDesc") { orderstr = " Count_Sales desc"; } else if (OrderBy == "SalesAsc") { orderstr = " Count_Sales asc"; } else if (OrderBy == "CountDesc") { orderstr = " Count_Stock desc"; } else if (OrderBy == "CountAsc") { orderstr = " Count_Stock asc"; } else if (OrderBy == "Price_CostDesc") { orderstr = " Price_Cost desc"; } else if (OrderBy == "Price_CostAsc") { orderstr = " Price_Cost asc"; } else if (OrderBy == "PriceDesc") { orderstr = " Price desc"; } else if (OrderBy == "PriceAsc") { orderstr = " Price asc"; } else if (OrderBy == "FreezeDesc") { orderstr = " Count_Freeze desc"; } else if (OrderBy == "FreezeAsc") { orderstr = " Count_Freeze asc"; } else if (OrderBy == "SortDesc") { orderstr = " Sort desc"; } else if (OrderBy == "SortAsc") { orderstr = " Sort asc"; } else { orderstr = " id desc"; } SQLDataAccess.SQLPara sp = new SQLDataAccess.SQLPara(where, orderstr, "*"); models = B_Lebi_Product.GetList(sp, PageSize, page); int recordCount = B_Lebi_Product.Counts(sp); PageString = Pager.GetPaginationString("?page={0}&brand=" + brand + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&key=" + key + "&lang=" + lang + "&OrderBy=" + OrderBy + "&Pro_Type_id=" + Pro_Type_id + "&status=" + status + "&Type_id_ProductType=" + Type_id_ProductType + "&tag=" + tag, page, PageSize, recordCount); userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("product_batch_edit", "批量编辑")) { PageReturnMsg = PageNoPowerMsg(); } PageSize = RequestTool.getpageSize(25); key = RequestTool.RequestString("key"); Pro_Type_id = RequestTool.RequestString("Pro_Type_id"); status = RequestTool.RequestInt("status", 0); brand = RequestTool.RequestInt("brand", 0); tag = RequestTool.RequestInt("tag", 0); dateFrom = RequestTool.RequestString("dateFrom"); dateTo = RequestTool.RequestString("dateTo"); OrderBy = RequestTool.RequestString("OrderBy"); lang = RequestTool.RequestString("lang"); DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); Type_id_ProductType = RequestTool.RequestInt("Type_id_ProductType", 320); if (lang == "") { lang = "CN"; } string where = "Product_id=0 and (IsDel!=1 or IsDel is null)"; if (Pro_Type_id != "") { where += " and Pro_Type_id in (" + Shop.Bussiness.EX_Product.Categoryid(Pro_Type_id) + ")"; } if (status > 0) { where += " and Type_id_ProductStatus=" + status + ""; } if (Type_id_ProductType > 0) { where += " and Type_id_ProductType=" + Type_id_ProductType + ""; } if (tag > 0) { if (LB.DataAccess.DB.BaseUtilsInstance.DBType == "sqlserver") { where += " and Charindex('" + tag + "',Pro_Tag_id)>0"; } else if (LB.DataAccess.DB.BaseUtilsInstance.DBType == "access") { where += " and Instr(Pro_Tag_id,'" + tag + "')>0"; } else if (LB.DataAccess.DB.BaseUtilsInstance.DBType == "mysql") { where += " and Instr(Pro_Tag_id,'" + tag + "')>0"; } } if (brand > 0) { where += " and Brand_id=" + brand + ""; } if (key != "") { where += " and (Name like lbsql{'%" + key + "%'} or Number like lbsql{'%" + key + "%'})"; } if (dateFrom != "" && dateTo != "") { where += " and Time_Add>='" + FormatDate(lbsql_dateFrom) + "' and Time_Add<='" + FormatDate(lbsql_dateTo) + " 23:59:59'"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Site_ids)) { string[] arr = EX_Admin.Project().Site_ids.Split(','); string sonwhere = ""; foreach (string sid in arr) { if (sonwhere == "") { sonwhere = "','+Site_ids+',' like '%," + sid + ",%'"; } else { sonwhere += " or ','+Site_ids+',' like '%," + sid + ",%'"; } } where += " and (" + sonwhere + " or Site_ids='')"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Pro_Type_ids)) { string[] ids = EX_Admin.Project().Pro_Type_ids.Split(','); string sonwhere = ""; foreach (string id in ids) { sonwhere += " or Path like '%," + id + ",%'"; } sonwhere = "select id from Lebi_Pro_Type where id in (" + EX_Admin.Project().Pro_Type_ids + ")" + sonwhere; where += " and (Pro_Type_id in (" + sonwhere + ") or Pro_Type_id=0)"; } if (!string.IsNullOrEmpty(EX_Admin.Project().Supplier_ids)) { where += " and (Supplier_id in (" + EX_Admin.Project().Supplier_ids + "))"; } //if (!string.IsNullOrEmpty(OrderBy)) //{ // if (OrderBy.Contains("Desc")) // { // orderstr = " " + OrderBy.Substring(0, OrderBy.Length - 4) + " desc"; // } // else // { // orderstr = " " + OrderBy.Substring(0, OrderBy.Length - 3) + " asc"; // } //} //else //{ // orderstr = " id desc"; //} if (OrderBy == "StatusDesc") { orderstr = " Type_id_ProductStatus desc"; } else if (OrderBy == "StatusAsc") { orderstr = " Type_id_ProductStatus asc"; } else if (OrderBy == "ViewsDesc") { orderstr = " Count_Views desc"; } else if (OrderBy == "ViewsAsc") { orderstr = " Count_Views asc"; } else if (OrderBy == "SalesDesc") { orderstr = " Count_Sales desc"; } else if (OrderBy == "SalesAsc") { orderstr = " Count_Sales asc"; } else if (OrderBy == "CountDesc") { orderstr = " Count_Stock desc"; } else if (OrderBy == "CountAsc") { orderstr = " Count_Stock asc"; } else if (OrderBy == "Price_MarketDesc") { orderstr = " Price_Market desc"; } else if (OrderBy == "Price_MarketAsc") { orderstr = " Price_Market asc"; } else if (OrderBy == "Price_CostDesc") { orderstr = " Price_Cost desc"; } else if (OrderBy == "Price_CostAsc") { orderstr = " Price_Cost asc"; } else if (OrderBy == "PriceDesc") { orderstr = " Price desc"; } else if (OrderBy == "PriceAsc") { orderstr = " Price asc"; } else if (OrderBy == "FreezeDesc") { orderstr = " Count_Freeze desc"; } else if (OrderBy == "FreezeAsc") { orderstr = " Count_Freeze asc"; } else if (OrderBy == "SortDesc") { orderstr = " Sort desc"; } else if (OrderBy == "SortAsc") { orderstr = " Sort asc"; } else { orderstr = " id desc"; } LB.DataAccess.SQLPara sp = new LB.DataAccess.SQLPara(where, orderstr, "*"); models = B_Lebi_Product.GetList(sp, PageSize, page); int recordCount = B_Lebi_Product.Counts(sp); PageString = Pager.GetPaginationString("?page={0}&brand=" + brand + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&key=" + key + "&lang=" + lang + "&OrderBy=" + OrderBy + "&Pro_Type_id=" + Pro_Type_id + "&status=" + status + "&Type_id_ProductType=" + Type_id_ProductType + "&tag=" + tag, page, PageSize, recordCount); userlevels = B_Lebi_UserLevel.GetList("", "Grade asc"); }
public string Login(string back, int IsLogin = 1) { string code = RequestTool.RequestString("code"); if (code != "") { try { StringBuilder sb = new StringBuilder(); sb.Append("?grant_type=authorization_code"); sb.Append("&client_id=" + appid); sb.Append("&client_secret=" + appkey); sb.Append("&code=" + code); string uri = reurnurl + "?backurl=" + ENBackuri(back); uri = System.Web.HttpUtility.UrlEncode(uri); sb.Append("&redirect_uri=" + uri); string res = PostAPI("oauth2/access_token", sb.ToString()); JavaScriptSerializer jss = new JavaScriptSerializer(); Model.Weibo.token token = jss.Deserialize <Model.Weibo.token>(res); string access_token = token.access_token; //获取uid sb = new StringBuilder(); sb.Append("?access_token=" + access_token); res = PostAPI("oauth2/get_token_info", sb.ToString()); Model.Weibo.tokeninfo tokeninfo = jss.Deserialize <Model.Weibo.tokeninfo>(res); string uid = tokeninfo.uid; //获取用户资料 sb = new StringBuilder(); sb.Append("?access_token=" + access_token); sb.Append("&uid=" + uid); res = GetAPI("2/users/show.json", sb.ToString()); Model.Weibo.userinfo model = jss.Deserialize <Model.Weibo.userinfo>(res); string where = "bind_weibo_id='" + uid + "'"; //if (DT_id > 0) //{ // where += " and DT_id =" + DT_id + ""; //} Shop.Model.Lebi_User user = B_Lebi_User.GetModel(where); Lebi_User CurrentUser = EX_User.CurrentUser(); if (CurrentUser.id > 0)//已经登录 { if (IsLogin == 0) { if (user != null) { if (CurrentUser.id != user.id) { return("已绑定其它帐号"); } } } CurrentUser.bind_weibo_id = uid; CurrentUser.bind_weibo_nickname = model.screen_name; CurrentUser.bind_weibo_token = access_token; if (CurrentUser.Face == "") { CurrentUser.Face = model.profile_image_url;//头像 50*50 } CurrentUser.DT_id = DT_id; B_Lebi_User.Update(CurrentUser); } else { if (user == null) { Lebi_UserLevel defaultlevel = B_Lebi_UserLevel.GetModel("Grade>0 order by Grade asc"); if (defaultlevel == null) { defaultlevel = new Lebi_UserLevel(); } if (defaultlevel.RegisterType == 0) //关闭注册 { return("会员注册已关闭"); } user = new Lebi_User(); user.bind_weibo_id = uid; user.bind_weibo_nickname = model.screen_name; user.bind_weibo_token = access_token; user.Face = model.profile_image_url;//头像 50*50 user.NickName = model.screen_name; user.UserName = "******" + uid; user.Password = EX_User.MD5(uid); user.Language = Language.CurrentLanguage().Code; user.Sex = model.gender == "f" ? "女" : "男"; user.UserLevel_id = B_Lebi_UserLevel.GetList("Grade>0", "Grade asc").FirstOrDefault().id; user.IsPlatformAccount = 1; if (CurrentSite != null) { user.Site_id = CurrentSite.id; } user.DT_id = DT_id; B_Lebi_User.Add(user); user.id = B_Lebi_User.GetMaxId(); EX_User.LoginOK(user); } else { user.bind_weibo_id = uid; user.bind_weibo_nickname = model.screen_name; user.bind_weibo_token = access_token; if (user.Face == "") { user.Face = model.profile_image_url;//头像 } //user.Sex = model.gender == "f" ? "女" : "男"; user.DT_id = DT_id; B_Lebi_User.Update(user); EX_User.LoginOK(user); } } return("OK"); } catch { return("授权失败"); } } return("授权失败"); }
public string Login(string back, int IsLogin = 1, int DT_id = 0) { string code = RequestTool.RequestString("code"); if (code != "") { try { StringBuilder sb = new StringBuilder(); sb.Append("?grant_type=authorization_code"); sb.Append("&client_id=" + appid); sb.Append("&client_secret=" + appkey); sb.Append("&code=" + code); string uri = reurnurl + "?backurl=" + back; uri = System.Web.HttpUtility.UrlEncode(uri); sb.Append("&redirect_uri=" + uri); string res = API("oauth2.0/token", sb.ToString()); res = res + "&"; string access_token = RegexTool.GetRegValue(res, "access_token=(.*?)&"); //获取openid sb = new StringBuilder(); sb.Append("?access_token=" + access_token); res = API("oauth2.0/me", sb.ToString()); string openid = RegexTool.GetRegValue(res, "openid\":\"(.*?)\"}"); //获取用户资料 sb = new StringBuilder(); sb.Append("?access_token=" + access_token); sb.Append("&oauth_consumer_key=" + appid); sb.Append("&openid=" + openid); res = API("user/get_user_info", sb.ToString()); JavaScriptSerializer jss = new JavaScriptSerializer(); Model.QQ.userinfo model = jss.Deserialize <Model.QQ.userinfo>(res); string where = "bind_qq_id='" + openid + "'"; //if (DT_id > 0) //{ // where += " and DT_id =" + DT_id + ""; //} Lebi_User user = B_Lebi_User.GetModel(where); Lebi_User CurrentUser = EX_User.CurrentUser(); if (CurrentUser.id > 0)//已经登录 { if (IsLogin == 0) { if (user != null) { if (CurrentUser.id != user.id) { return("已绑定其它帐号"); } } } CurrentUser.bind_qq_id = openid; CurrentUser.bind_qq_nickname = model.nickname; CurrentUser.bind_qq_token = access_token; if (CurrentUser.Face == "") { CurrentUser.Face = model.figureurl_qq_1;//头像 } CurrentUser.DT_id = DT_id; B_Lebi_User.Update(CurrentUser); } else { if (user == null) { Lebi_UserLevel defaultlevel = B_Lebi_UserLevel.GetModel("Grade>0 order by Grade asc"); if (defaultlevel == null) { defaultlevel = new Lebi_UserLevel(); } if (defaultlevel.RegisterType == 0) //关闭注册 { return("会员注册已关闭"); } user = new Lebi_User(); user.bind_qq_id = openid; user.bind_qq_nickname = model.nickname; user.bind_qq_token = access_token; user.Face = model.figureurl_qq_1;//头像 user.UserName = "******" + openid; user.NickName = model.nickname; user.Password = EX_User.MD5(openid); user.Language = Language.CurrentLanguage().Code; user.Sex = model.gender; user.UserLevel_id = B_Lebi_UserLevel.GetList("Grade>0", "Grade asc").FirstOrDefault().id; user.IsPlatformAccount = 1; if (CurrentSite != null) { user.Site_id = CurrentSite.id; } user.DT_id = DT_id; B_Lebi_User.Add(user); user.id = B_Lebi_User.GetMaxId(); EX_User.LoginOK(user); } else { user.bind_qq_id = openid; user.bind_qq_nickname = model.nickname; user.bind_qq_token = access_token; if (user.Face == "") { user.Face = model.figureurl_qq_1;//头像 } //user.Sex = model.gender; user.DT_id = DT_id; B_Lebi_User.Update(user); EX_User.LoginOK(user); } } return("OK"); } catch { return("授权失败"); } } return("授权失败"); }
/// <summary> /// 微信登录 /// https://api.weixin.qq.com/sns/oauth2/access_token?appid=APPID&secret=SECRET&code=CODE&grant_type=authorization_code /// </summary> /// <param name="back"></param> /// <returns></returns> public string Login(string back, int IsLogin = 1) { string code = RequestTool.RequestString("code"); if (code != "") { try { string uri = reurnurl + "?backurl=" + ENBackuri(back); int userid = 0; uri = System.Web.HttpUtility.UrlEncode(uri); string res = Post("https://api.weixin.qq.com/sns/oauth2/access_token?appid=" + appid + "&secret=" + appkey + "&code=" + code + "&grant_type=authorization_code"); JavaScriptSerializer jss = new JavaScriptSerializer(); Model.weixin.tokeninfo tokeninfo = jss.Deserialize <Model.weixin.tokeninfo>(res); string uid = tokeninfo.openid; //SystemLog.Add(uid); //获取用户资料 //https://api.weixin.qq.com/sns/userinfo?access_token=ACCESS_TOKEN&openid=OPENID&lang=zh_CN res = Post("https://api.weixin.qq.com/sns/userinfo?access_token=" + tokeninfo.access_token + "&openid=" + uid + "&lang=zh_CN"); Model.weixin.userinfo model = jss.Deserialize <Model.weixin.userinfo>(res); string where = "bind_weixin_id='" + uid + "' and bind_weixin_id!=''"; //if (DT_id > 0) //{ // where += " and DT_id =" + DT_id + ""; //} Lebi_User user = B_Lebi_User.GetModel(where); Lebi_User CurrentUser = null; string qrcodeid_ = RegexTool.GetRegValue((back + "&"), @"qrcodeid=(\d*)&"); int qrid = 0; int.TryParse(qrcodeid_, out qrid); if (qrid > 0) { //扫描二维码授权绑定当前账号 Lebi_weixin_qrcode qcode = B_Lebi_weixin_qrcode.GetModel(qrid); CurrentUser = B_Lebi_User.GetModel(qcode.User_id); if (IsLogin == 0) { if (user != null && CurrentUser != null) { return("已绑定其它帐号"); } } } if (user == null) { Lebi_UserLevel defaultlevel = B_Lebi_UserLevel.GetModel("Grade>0 order by Grade asc"); if (defaultlevel == null) { defaultlevel = new Lebi_UserLevel(); } if (defaultlevel.RegisterType == 0) //关闭注册 { return("会员注册已关闭"); } if (CurrentUser == null) { user = new Lebi_User(); user.bind_weixin_id = uid; user.bind_weixin_nickname = model.nickname; user.bind_weixin_token = tokeninfo.access_token; try { user.Face = DownLoadImage(model.headimgurl); } catch { user.Face = model.headimgurl; } user.NickName = model.nickname; user.UserName = "******" + uid; user.Password = EX_User.MD5(uid); user.Language = Language.CurrentLanguage().Code; user.Sex = model.sex == "2" ? "女" : "男"; user.UserLevel_id = B_Lebi_UserLevel.GetList("Grade>0", "Grade asc").FirstOrDefault().id; user.IsPlatformAccount = 1; //B_Lebi_User.Add(user); //user.id = B_Lebi_User.GetMaxId(); //userid = user.id; user.DT_id = DT_id; EX_User.UserReg(user); } else { CurrentUser.bind_weixin_id = uid; CurrentUser.bind_weixin_nickname = model.nickname; CurrentUser.bind_weixin_token = tokeninfo.access_token; try { CurrentUser.Face = DownLoadImage(model.headimgurl); } catch { CurrentUser.Face = model.headimgurl; } //CurrentUser.Face = model.headimgurl;//头像 50*50 if (CurrentUser.NickName == "") { CurrentUser.NickName = model.nickname; } CurrentUser.DT_id = DT_id; //B_Lebi_User.Update(CurrentUser); EX_User.LoginOK(CurrentUser, 0); userid = CurrentUser.id; } } else { user.bind_weixin_id = uid; user.bind_weixin_nickname = model.nickname; user.bind_weixin_token = tokeninfo.access_token;; try { user.Face = DownLoadImage(model.headimgurl); } catch (Exception ex) { user.Face = ""; LB.Tools.TxtLog.Add(ex.Message); } if (user.NickName == "") { user.NickName = model.nickname; } user.DT_id = DT_id; //user.Sex = model.gender == "f" ? "女" : "男"; //B_Lebi_User.Update(user); EX_User.LoginOK(user, 0); userid = user.id; } if (qrid > 0) { //扫描二维码登录 Lebi_weixin_qrcode qcode = B_Lebi_weixin_qrcode.GetModel(qrid); qcode.User_id = userid; B_Lebi_weixin_qrcode.Update(qcode); //Log.Add(back); } return("OK"); } catch (Exception ex) { LB.Tools.TxtLog.Add(ex.Message); return("授权失败" + ex.Message); } } return("授权失败"); }
public Lebi_User GetUserByopenid(string openid, int DT_id = 0) { string res = Get("https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + Token + "&openid=" + openid + "&lang=zh_CN"); JavaScriptSerializer jss = new JavaScriptSerializer(); Model.weixin.userinfo model = jss.Deserialize <Model.weixin.userinfo>(res); Lebi_User user = B_Lebi_User.GetModel("UserName='******'"); if (user == null) { user = new Lebi_User(); user.bind_weixin_id = openid; user.bind_weixin_nickname = model.nickname; //user.bind_weixin_token = tokeninfo.access_token; try { user.Face = DownLoadImage(model.headimgurl); } catch { user.Face = model.headimgurl; } user.NickName = model.nickname; user.UserName = "******" + openid; user.Password = EX_User.MD5(openid); user.Language = Language.CurrentLanguage().Code; user.Sex = model.sex == "2" ? "女" : "男"; user.UserLevel_id = B_Lebi_UserLevel.GetList("Grade>0", "Grade asc").FirstOrDefault().id; user.IsPlatformAccount = 1; if (CurrentSite != null) { user.Site_id = CurrentSite.id; } user.DT_id = DT_id; //B_Lebi_User.Add(user); //user.id = B_Lebi_User.GetMaxId(); //userid = user.id; return(EX_User.UserReg(user)); } else { user.bind_weixin_id = openid; user.bind_weixin_nickname = model.nickname; //user.bind_weixin_token = tokeninfo.access_token; ; //if (user.Face == "") //{ try { user.Face = DownLoadImage(model.headimgurl); } catch { user.Face = model.headimgurl; } //} if (user.NickName == "") { user.NickName = model.nickname; } //user.Sex = model.gender == "f" ? "女" : "男"; user.DT_id = DT_id; B_Lebi_User.Update(user); EX_User.LoginOK(user, 0); return(user); } }
public string Login(string back, int IsLogin = 1) { string code = RequestTool.RequestString("code"); string res = ""; StringBuilder sb; if (code != "") { sb = new StringBuilder(); sb.Append("?grant_type=authorization_code"); sb.Append("&client_id=" + appid); sb.Append("&client_secret=" + appkey); sb.Append("&code=" + code); sb.Append("&redirect_uri=" + reurnurl); //res = APIURL("oauth/access_token", sb.ToString()); res = PostAPI("oauth/access_token", sb.ToString()); //access_token= //CAAGUzrOw7 //AMBADkwUNj //HkI9FwLPHD //fUamZCSBH1 //NbSFsKVVjF //D2QfmP0aXT //FtMTY8e8d5 //yse93demVg //YwCfEWXApj //ZAsGqt3ugg //YiHSmFQeN2 //EOwFindWuw //R9QHiTlAwr //kmuTmr1Qs4 //mwtSAZC15m //wTpLWvZCaj //OkVC1zlTZB //B5gjRZBmCm //C2j&expires=5183999 //HttpContext.Current.Response.Redirect(res); res = res + "&"; string access_token = RegexTool.GetRegValue(res, "access_token=(.*?)&"); JavaScriptSerializer jss = new JavaScriptSerializer(); //获取uid sb = new StringBuilder(); sb.Append("?access_token=" + access_token); res = GetAPI("me", sb.ToString()); Model.Facebook.userinfo model = jss.Deserialize <Model.Facebook.userinfo>(res); string uid = model.id; //return uid; Lebi_User user = B_Lebi_User.GetModel("bind_facebook_id='" + uid + "'"); if (model == null) { model = new Model.Facebook.userinfo(); } if (model.picture == null) { model.picture = new Model.Facebook.userinfo.picture_(); } if (model.picture.data == null) { model.picture.data = new Model.Facebook.userinfo.picture_.data_(); model.picture.data.url = ""; } string username = model.last_name + model.first_name; if (user == null) { Lebi_UserLevel defaultlevel = B_Lebi_UserLevel.GetModel("Grade>0 order by Grade asc"); if (defaultlevel == null) { defaultlevel = new Lebi_UserLevel(); } if (defaultlevel.RegisterType == 0) //关闭注册 { return("会员注册已关闭"); } user = new Lebi_User(); user.bind_facebook_id = uid; user.bind_facebook_nickname = username; user.bind_facebook_token = access_token; user.Face = model.picture.data.url; user.UserName = username; user.Password = EX_User.MD5(uid); user.Language = Language.CurrentLanguage().Code; user.Sex = model.gender == "female" ? "女" : "男"; user.UserLevel_id = B_Lebi_UserLevel.GetList("Grade>0", "Grade asc").FirstOrDefault().id; user.IsPlatformAccount = 1; if (CurrentSite != null) { user.Site_id = CurrentSite.id; } user.DT_id = DT_id; B_Lebi_User.Add(user); user.id = B_Lebi_User.GetMaxId(); EX_User.LoginOK(user); } else { user.bind_facebook_id = uid; user.bind_facebook_nickname = username; user.bind_facebook_token = access_token; user.Face = model.picture.data.url; user.Sex = model.gender == "female" ? "女" : "男"; user.UserName = username; user.DT_id = DT_id; B_Lebi_User.Update(user); EX_User.LoginOK(user); } return("OK"); } return("授权失败"); }