/// <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)
{
userlevelid = RequestTool.RequestInt("userlevelid");
userid = RequestTool.RequestInt("userid");
orderid = RequestTool.RequestInt("orderid");
typeid = RequestTool.RequestInt("typeid");
key = RequestTool.RequestString("key");
user = B_Lebi_User.GetModel(userid);
userlevel = B_Lebi_UserLevel.GetModel(userlevelid);
if (user == null)
{
user = new Lebi_User();
}
if (userlevel == null)
{
userlevel = new Lebi_UserLevel();
}
string where = "Product_id=0";
if (key != "")
{
where += " and (Name like '%" + key + "%' or Number like '%" + key + "%' or Code like '%" + key + "%')";
}
if (typeid > 0)
{
string tids = EX_Product.TypeIds(typeid);
where += " and Pro_Type_id in (" + tids + ")";
}
}
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)
{
userlevelid = RequestTool.RequestInt("userlevelid");
userid = RequestTool.RequestInt("userid");
typeid = RequestTool.RequestInt("typeid");
showall = RequestTool.RequestInt("showall");
key = RequestTool.RequestString("key");
user = B_Lebi_User.GetModel(userid);
userlevel = B_Lebi_UserLevel.GetModel(userlevelid);
if (user == null)
{
user = new Lebi_User();
}
if (userlevel == null)
{
userlevel = new Lebi_UserLevel();
}
string where = "Product_id=0 and (IsDel!=1 or IsDel is null)";
if (key != "")
{
where += " and (Name like '%" + key + "%' or Number like '%" + key + "%' or Code like '%" + key + "%')";
}
if (typeid > 0)
{
string tids = EX_Product.TypeIds(typeid);
where += " and Pro_Type_id in (" + tids + ")";
}
PageSize = RequestTool.getpageSize(10);
int recordCount = B_Lebi_Product.Counts(where);
PageString = Pager.GetPaginationStringForJS("reloadproducts({0}," + typeid + ",'" + key + "'," + user.id + "," + userlevel.id + ");", page, PageSize, recordCount);
products = B_Lebi_Product.GetList(where, "", PageSize, page);
}
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");
}
public Lebi_UserLevel GetUserLevel(int id)
{
Lebi_UserLevel pro = B_Lebi_UserLevel.GetModel(id);
if (pro == null)
{
return(new Lebi_UserLevel());
}
return(pro);
}
public string GetlevelName(int id)
{
Lebi_UserLevel model = B_Lebi_UserLevel.GetModel(id);
if (model == null)
{
return("");
}
return(Lang(model.Name));
}
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\"}");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("product_user_price", "商品会员价格"))
{
WindowNoPower();
}
userlevelid = RequestTool.RequestInt("userlevelid");
userid = RequestTool.RequestInt("userid");
productid = RequestTool.RequestInt("productid");
key = RequestTool.RequestString("key");
userlevel = B_Lebi_UserLevel.GetModel(userlevelid);
product = B_Lebi_Product.GetModel(productid);
if (product == null)
{
product = new Lebi_Product();
}
if (userlevel == null)
{
userlevel = new Lebi_UserLevel();
}
string where = "IsAnonymous<>1";
if (key != "")
{
where += " and (UserName like '%" + key + "%' or RealName like '%" + key + "%' or NickName like '%" + key + "%')";
}
if (userlevelid > 0)
{
where += " and UserLevel_id =" + userlevelid + "";
}
PageSize = RequestTool.getpageSize(10);
int recordCount = B_Lebi_User.Counts(where);
PageString = Pager.GetPaginationStringForJS("reloadproducts({0},'" + key + "'," + userlevel.id + ");", page, PageSize, recordCount);
users = B_Lebi_User.GetList(where, "", PageSize, page);
userlevellimit = B_Lebi_Product_Price.GetModel("Product_id=" + product.id + "");
if (userlevellimit == null)
{
userlevellimit = new Lebi_Product_Price();
}
}
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);
}
/// <summary>
/// 编辑会员分组
/// </summary>
public void UserLevel_Edit()
{
int id = RequestTool.RequestInt("id", 0);
Lebi_UserLevel model = B_Lebi_UserLevel.GetModel(id);
if (model == null)
{
model = new Lebi_UserLevel();
}
B_Lebi_UserLevel.SafeBindForm(model);
model.Name = Language.RequestString("Name");
model.PriceName = Language.RequestString("PriceName");
if (model.id == 0)
{
if (!EX_Admin.Power("userlevel_add", "添加会员分组"))
{
AjaxNoPower();
return;
}
B_Lebi_UserLevel.Add(model);
id = B_Lebi_UserLevel.GetMaxId();
Log.Add("添加会员分组", "UserLevel", id.ToString(), CurrentAdmin, Shop.Bussiness.Language.Content(Language.RequestString("Name"), "CN"));
}
else
{
if (!EX_Admin.Power("userlevel_edit", "编辑会员分组"))
{
AjaxNoPower();
return;
}
B_Lebi_UserLevel.Update(model);
Log.Add("编辑会员分组", "UserLevel", id.ToString(), CurrentAdmin, Shop.Bussiness.Language.Content(Language.RequestString("Name"), "CN"));
}
ImageHelper.LebiImagesUsed(model.ImageUrl, "config", id);
string result = "{\"msg\":\"OK\", \"id\":\"" + id + "\"}";
Response.Write(result);
}
protected void Page_Load(object sender, EventArgs e)
{
int id = RequestTool.RequestInt("id", 0);
if (id == 0)
{
if (!EX_Admin.Power("userlevel_add", "添加会员分组"))
{
PageNoPower();
}
}
else
{
if (!EX_Admin.Power("userlevel_edit", "编辑会员分组"))
{
PageNoPower();
}
}
model = B_Lebi_UserLevel.GetModel(id);
if (model == null)
{
model = new Lebi_UserLevel();
}
}
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("授权失败");
}
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>();
}
}
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)
{
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");
}
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");
}
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("授权失败");
}
/// <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 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("授权失败");
}
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("授权失败");
}
/// <summary>
/// 用户注册
/// </summary>
public void User_Reg()
{
string url = "";
bool Checkmobilephone = false;
bool Checkemail = false;
string MobilePhone = RequestTool.RequestSafeString("MobilePhone");
string Email = RequestTool.RequestSafeString("Email");
try
{
Lebi_UserLevel defaultlevel = B_Lebi_UserLevel.GetModel("Grade>0 order by Grade asc");
if (defaultlevel == null)
{
defaultlevel = new Lebi_UserLevel();
}
if (defaultlevel.RegisterType == 0) //关闭注册
{
Response.Write("{\"msg\":\"" + Tag("会员注册已关闭") + "\"}");
return;
}
if (SYS.UserRegCheckedType.Contains("mobilephone"))
{
Checkmobilephone = true;
string MobilePhone_checkcode = RequestTool.RequestSafeString("MobilePhone_checkcode");
try
{
string phonecheckcode = (string)Session["phonecheckcode"];//phonecheckcode
if (phonecheckcode != (MobilePhone + MobilePhone_checkcode))
{
Response.Write("{\"msg\":\"" + Tag("手机验证码错误") + phonecheckcode + "(" + MobilePhone + MobilePhone_checkcode + ")\"}");
return;
}
if (SYS.IsMobilePhoneMutiReg == "0")
{
int phonecount = B_Lebi_User.Counts("MobilePhone=lbsql{'" + MobilePhone + "'} and IsCheckedMobilePhone=1");
if (phonecount > 0)
{
Response.Write("{\"msg\":\"" + Tag("此手机号已经注册") + "\"}");
return;
}
}
}
catch (Exception ex)
{
Response.Write("{\"msg\":\"" + Tag("手机验证码错误") + "" + ex.ToString() + "\"}");
return;
}
}
if (SYS.UserRegCheckedType.Contains("email"))
{
Checkemail = true;
string Email_checkcode = RequestTool.RequestSafeString("Email_checkcode");
try
{
string emailcheckcode = (string)Session["emailcheckcode"];
if (emailcheckcode != (Email + Email_checkcode))
{
Response.Write("{\"msg\":\"" + Tag("邮件验证码错误") + "\"}");
return;
}
int emailcount = B_Lebi_User.Counts("Email=lbsql{'" + Email + "'} and IsCheckedEmail=1");
if (emailcount > 0)
{
Response.Write("{\"msg\":\"" + Tag("此邮箱已经注册") + "\"}");
return;
}
}
catch
{
Response.Write("{\"msg\":\"" + Tag("邮件验证码错误") + "\"}");
return;
}
}
if (SYS.Verifycode_UserRegister == "1")
{
if (Checkemail == false && Checkmobilephone == false)
{
string verifycode = RequestTool.RequestString("verifycode");
if (CurrentCheckCode != verifycode)
{
Response.Write("{\"msg\":\"" + Tag("验证码错误") + "\"}");
return;
}
}
}
string UserName = RequestTool.RequestSafeString("UserName");
string PWD = RequestTool.RequestSafeString("Password");
string token = RequestTool.RequestString("token");
if (UserName == "")
{
Response.Write("{\"msg\":\"" + Tag("请输入用户名") + "\"}");
return;
}
if (PWD == "")
{
Response.Write("{\"msg\":\"" + Tag("请输入密码") + "\"}");
return;
}
//检查用户名存在
int count = B_Lebi_User.Counts("UserName=lbsql{'" + UserName + "'}");
if (count > 0)
{
Response.Write("{\"msg\":\"" + Tag("用户名已注册") + "\"}");
return;
}
var nv = CookieTool.GetCookie("parentuser");
int parentuserid = 0;
if (!string.IsNullOrEmpty(nv.Get("id")))
{
string parentuserid_ = nv.Get("id");
int.TryParse(parentuserid_, out parentuserid);
}
if (parentuserid == 0)
{
parentuserid = RequestTool.RequestInt("parentuserid", 0);
}
if (parentuserid != 0)
{
Lebi_User puser = B_Lebi_User.GetModel("id=" + parentuserid + "");
if (puser != null)
{
if (defaultlevel.RegisterType == 2) //邀请注册
{
Lebi_UserLevel userlevel = B_Lebi_UserLevel.GetModel(puser.UserLevel_id);
if (userlevel != null)
{
if (userlevel.RegisterType == 0) //关闭注册
{
Response.Write("{\"msg\":\"" + Tag("会员注册已关闭") + "\"}");
return;
}
}
}
if (SYS.IsUsedAgent == "1")
{
if (Shop.LebiAPI.Service.Instanse.Check("plugin_agent"))
{
parentuserid = puser.id;
puser.Count_sonuser++;
B_Lebi_User.Update(puser);
}
}
}
}
else
{
if (defaultlevel.RegisterType == 2) //邀请注册
{
Response.Write("{\"msg\":\"" + Tag("请输入邀请码") + "\"}");
return;
}
}
Lebi_User model = new Lebi_User();
B_Lebi_User.SafeBindForm(model);
model.NickName = model.UserName;
model.Password = EX_User.MD5(PWD);
model.UserLevel_id = defaultlevel.id;
model.Time_Reg = DateTime.Now;
model.Time_This = DateTime.Now;
model.Time_Last = DateTime.Now;
model.Count_Login = 1;
model.IP_This = RequestTool.GetClientIP();
model.IP_Last = RequestTool.GetClientIP();
if (Checkemail)
{
model.IsCheckedEmail = 1;
}
if (Checkmobilephone)
{
model.IsCheckedMobilePhone = 1;
}
model.User_id_parent = parentuserid;
if (CurrentSite != null)
{
model.Site_id = CurrentSite.id;
}
if (CurrentLanguage != null)
{
model.Language = CurrentLanguage.Code;
}
model.Area_id = RequestTool.RequestInt("Area_id", 0);
int DefaultUserEndDays = 0;
int.TryParse(SYS.DefaultUserEndDays, out DefaultUserEndDays);
model.Time_End = System.DateTime.Now.AddDays(DefaultUserEndDays);
Lebi_User user = EX_User.UserReg(model, PWD);
try
{
//发送邮件
if (ShopCache.GetBaseConfig().MailSign.ToLower().Contains("zhuce") || ShopCache.GetBaseConfig().AdminMailSign.ToLower().Contains("register"))
{
Shop.Bussiness.Email.SendEmail_newuser(user);
}
//发送短信
if (ShopCache.GetBaseConfig().SMS_sendmode.Contains("SMSTPL_newuser") || ShopCache.GetBaseConfig().SMS_sendmode.Contains("SMSTPL_Admin_newuser"))
{
SMS.SendSMS_newuser(user);
}
}
catch { }
url = RequestTool.RequestString("url").Replace("<", "").Replace(">", "");
if (EX_User.MD5(SYS.InstallCode + url) != token)
{
url = URL("P_Index", "");
}
if (url.ToLower().IndexOf("http") > -1 || url.ToLower().IndexOf(URL("P_Register", "").ToLower()) > -1 || url.ToLower().IndexOf(URL("P_Login", "").ToLower()) > -1 || url == "")
{
url = URL("P_Index", "");
}
Response.Write("{\"msg\":\"OK\",\"url\":\"" + url + "\"}");
}
catch (Exception e)
{
SystemLog.Add("User_Reg-" + e.ToString());
}
}
