protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("oftenbuy_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"); type = RequestTool.RequestInt("type", 0); if (type == 0) { type = 144; } 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 (type > 0) { where += " and Type_id_UserProductType=" + type + ""; } if (key != "") { where += " and Product_id in (select id from Lebi_Product where Name 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_Product.GetList(where, "id desc", PageSize, page); int recordCount = B_Lebi_User_Product.Counts(where); PageString = Pager.GetPaginationString("?page={0}&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&type = " + type, page, PageSize, recordCount); user = B_Lebi_User.GetModel(user_id); if (user == null) { user = new Lebi_User(); user.UserName = Tag("全部会员"); } }
/// <summary> /// 修改密码 /// </summary> public void SetPassword() { string PWD = RequestTool.RequestSafeString("Password"); string PWD1 = RequestTool.RequestSafeString("Password1"); string PWD2 = RequestTool.RequestSafeString("Password2"); PWD = EX_User.MD5(PWD); if (PWD != CurrentUser.Password && CurrentUser.Password != "") { Response.Write("{\"msg\":\"" + Tag("原始密码错误") + "\"}"); return; } CurrentUser.Password = EX_User.MD5(PWD1); B_Lebi_User.Update(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 Time_Add>='" + FormatDate(lbsql_dateFrom) + "' and Time_Add<='" + FormatDate(lbsql_dateTo) + " 23:59:59'"; } 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("全部会员"); } }
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"); }
/// <summary> /// 设置收货人 /// </summary> public void Address_Set() { int id = RequestTool.RequestInt("address_id", 0); Lebi_User_Address model = B_Lebi_User_Address.GetModel("User_id=" + CurrentUser.id + " and id = " + id); if (model != null) { if (model.User_id == CurrentUser.id) { CurrentUser.User_Address_id = model.id; B_Lebi_User.Update(CurrentUser); Response.Write("{\"msg\":\"OK\",\"id\":\"" + id + "\"}"); return; } } Response.Write("{\"msg" + Tag("参数错误") + "\"}"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("sms_write", "发送手机短信")) { WindowNoPower(); } User_Name = RequestTool.RequestString("User_Name"); ids = RequestTool.RequestString("ids"); if (ids != "") { user = B_Lebi_User.GetList("id in (lbsql{" + ids + "})", "id desc"); if (user != null) { } } su = new SearchUser(CurrentAdmin, CurrentLanguage.Code); }
/// <summary> /// 发送手机短信 /// </summary> public void SMS_Write() { if (!EX_Admin.Power("sms_write", "发送手机短信")) { AjaxNoPower(); return; } int Mode = RequestTool.RequestInt("Mode", 0); string Content = RequestTool.RequestString("Content"); string PhoneNO = RequestTool.RequestString("PhoneNO"); string User_ids = RequestTool.RequestString("User_ids"); SearchUser su = new SearchUser(CurrentAdmin, CurrentLanguage.Code); string where = ""; if (PhoneNO != "") { SMS.SendSMS_custom(Content, PhoneNO); } else { if (User_ids != "") { where = "id in (lbsql{" + User_ids + "})"; } else { where = "1=1 " + su.SQL; } //int i = 0; List <Lebi_User> modellist = B_Lebi_User.GetList(where, ""); if (modellist.Count == 0) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } foreach (Lebi_User user in modellist) { SMS.SendSMS_custom(Content, user.MobilePhone); } } Log.Add("发送手机短信", "Message", "", CurrentAdmin, su.Description); //} Response.Write("{\"msg\":\"OK\"}"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("usermoney_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"); type = RequestTool.RequestInt("type", 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 (type > 0) { where += " and Type_id_MoneyType=" + type + ""; } if (key != "") { where += " and (User_UserName like lbsql{'%" + key + "%'} or User_RealName like lbsql{'%" + key + "%'} or Remark like lbsql{'%" + key + "%'} or Order_PayNo like lbsql{'%" + key + "%'})"; } if (dateFrom != "" && dateTo != "") { where += " and Time_Add>='" + FormatDate(lbsql_dateFrom) + "' and Time_Add<='" + FormatDate(lbsql_dateTo) + " 23:59:59'"; } models = B_Lebi_User_Money.GetList(where, "id desc", PageSize, page); int recordCount = B_Lebi_User_Money.Counts(where); PageString = Pager.GetPaginationString("?page={0}&key=" + key + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&user_id=" + user_id + "&type=" + type, page, PageSize, recordCount); user = B_Lebi_User.GetModel(user_id); if (user == null) { user = new Lebi_User(); user.UserName = Tag("全部会员"); } }
/// <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\"}"); }
/// <summary> /// 发送手机验证码 /// </summary> public void GetPhoneCheckCode() { string phone = RequestTool.RequestSafeString("phone"); CurrentUser.MobilePhone = phone; CurrentUser.Language = CurrentLanguage.Code; string mcode = RequestTool.RequestString("m"); try { int phonecount = B_Lebi_User.Counts("MobilePhone=lbsql{'" + phone + "'} and IsCheckedMobilePhone=1"); if (phonecount > 0) { Response.Write("{\"msg\":\"" + Tag("此手机号已经注册") + "\"}"); return; } int Count = 0; string Count_ = CookieTool.GetCookie("GetPhoneCheckCode_" + CurrentUser.MobilePhone).Get("Count"); int.TryParse(Count_, out Count); if (Count > 5) { Response.Write("{\"msg\":\"" + Tag("已超出当日使用次数") + "\"}"); return; } string servermcode = Session["mcode"] == null ? "1" : (string)Session["mcode"]; if (servermcode != mcode || servermcode == "") { Response.Write("{\"msg\":\"" + Tag("发送失败,请刷新页面后重试") + "" + servermcode + "\"}"); return; } SMS.SendSMS_checkcode(CurrentUser); Count++; NameValueCollection nvs = new NameValueCollection(); nvs.Add("Count", Count.ToString()); CookieTool.WriteCookie("GetPhoneCheckCode_" + CurrentUser.MobilePhone, nvs, 1); Response.Write("{\"msg\":\"OK\"}"); } catch { Response.Write("{\"msg\":\"" + Tag("发送失败,请联系客服") + "\"}"); } }
/// <summary> /// 发送邮件验证码 /// </summary> public void GetEmailCheckCode() { string email = RequestTool.RequestSafeString("email"); CurrentUser.Email = email; CurrentUser.Language = CurrentLanguage.Code; string mcode = RequestTool.RequestString("m"); try { int emailcount = B_Lebi_User.Counts("Email=lbsql{'" + email + "'} and IsCheckedEmail=1"); if (emailcount > 0) { Response.Write("{\"msg\":\"" + Tag("此邮箱已经注册") + "\"}"); return; } int Count = 0; string Count_ = CookieTool.GetCookie("GetEmailCheckCode_" + CurrentUser.Email).Get("Count"); int.TryParse(Count_, out Count); if (Count > 5) { Response.Write("{\"msg\":\"" + Tag("已超出当日使用次数") + "\"}"); return; } string servermcode = Session["mcode"] == null ? "" : (string)Session["mcode"]; if (servermcode != mcode || servermcode == "") { Response.Write("{\"msg\":\"" + Tag("发送失败,请刷新页面后重试") + "\"}"); return; } Email.SendEmail_checkcode(CurrentUser); Count++; NameValueCollection nvs = new NameValueCollection(); nvs.Add("Count", Count.ToString()); CookieTool.WriteCookie("GetEmailCheckCode_" + CurrentUser.Email, nvs, 1); Response.Write("{\"msg\":\"OK\"}"); } catch { Response.Write("{\"msg\":\"" + Tag("发送失败,请联系客服") + "\"}"); } }
/// <summary> /// 编辑区域代理-代理人 /// </summary> public void AreaAgentUser_Edit() { int id = RequestTool.RequestInt("id", 0); Lebi_Agent_Area model = B_Lebi_Agent_Area.GetModel(id); if (model == null) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } string User_UserName = RequestTool.RequestString("User_UserName"); if (User_UserName == "") { Response.Write("{\"msg\":\"" + Tag("用户名不能空") + "\"}"); return; } Lebi_User user = B_Lebi_User.GetModel("UserName=lbsql{'" + User_UserName + "'}"); if (user == null) { Response.Write("{\"msg\":\"" + Tag("用户不存在") + "\"}"); return; } if (model.Time_end > System.DateTime.Now.Date && model.User_id != user.id) { Response.Write("{\"msg\":\"" + Tag("其他代理还未到期") + "\"}"); return; } if (model == null) { model = new Lebi_Agent_Area(); } B_Lebi_Agent_Area.BindForm(model); model.User_id = user.id; B_Lebi_Agent_Area.Update(model); Log.Add("绑定区域代理", "Agent_Area", id.ToString(), CurrentAdmin, model.User_UserName + "[" + model.Area_id + "]"); string result = "{\"msg\":\"OK\", \"id\":\"" + id + "\"}"; Response.Write(result); }
/// <summary> /// 发送站内信 /// </summary> public void Message_Write() { if (CurrentUser.id > 0)//已经登录 { int id = RequestTool.RequestInt("id", 0); int Message_Type_id = RequestTool.RequestInt("Message_Type_id", 0); string Title = RequestTool.RequestSafeString("Title"); string Content = RequestTool.RequestSafeString("Content"); Lebi_Message model = new Lebi_Message(); if (id != 0) { Lebi_Message mes = B_Lebi_Message.GetModel(id); if (mes == null) { Response.Write("{\"msg\":\"" + Tag("回复信息不存在") + "\"}"); return; } else { model.Message_Type_id = mes.Message_Type_id; } } model.Title = Title; model.Content = Content; model.User_id_From = CurrentUser.id; model.User_Name_From = CurrentUser.UserName; model.User_id_To = 0; model.User_Name_To = "管理员"; model.IsRead = 0; model.IsSystem = 0; model.Time_Add = System.DateTime.Now; model.Language = CurrentLanguage.Code; model.IP = RequestTool.GetClientIP(); B_Lebi_Message.Add(model); //发送邮件 Lebi_User user = B_Lebi_User.GetModel(CurrentUser.id); Email.SendEmail_message(user, model); //发送短信 SMS.SendSMS_message(user, model); Response.Write("{\"msg\":\"OK\"}"); } }
protected void Page_Load(object sender, EventArgs e) { int id = RequestTool.RequestInt("id", 0); if (!EX_Admin.Power("user_edit", "编辑会员")) { PageNoPower(); } user = B_Lebi_User.GetModel(id); if (user == null) { PageError(); } int AdminLogin = 1; //管理员登录标识 by Lebi.Kingdge 2017-6-23 if (EX_User.UserLogin(user.UserName, user.Password, user.DT_id, false, AdminLogin)) { Response.Redirect(Shop.Bussiness.ThemeUrl.GetURL("P_UserCenter", "", "", CurrentLanguage.Code)); } }
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(); } }
/// <summary> /// 发表商品咨询 /// </summary> public void Ask_Write() { int id = RequestTool.RequestInt("id", 0); int Product_id = 0; Lebi_Product product = B_Lebi_Product.GetModel(id); if (product != null) { Product_id = product.Product_id; } Lebi_Comment model = new Lebi_Comment(); model.TableName = "Product_Ask"; model.Keyid = id; model.Admin_UserName = "******"; model.Admin_id = 0; model.User_id = CurrentUser.id; model.User_UserName = CurrentUser.UserName; model.Content = RequestTool.RequestSafeString("Content"); model.Star = 0; model.Parentid = 0; model.Status = 282; //283已回复 model.Time_Add = System.DateTime.Now; model.Language_Code = CurrentLanguage.Code; model.Product_id = Product_id; model.IsRead = 1; model.Supplier_id = product.Supplier_id; if (!Comment.CheckSafeWord(model.Content)) { Response.Write("{\"msg\":\"" + Tag("内容中包含敏感词") + "\"}"); return; } B_Lebi_Comment.Add(model); //发送邮件 Lebi_User user = B_Lebi_User.GetModel(CurrentUser.id); Email.SendEmail_ask(user, model); //发送短信 SMS.SendSMS_ask(user, model); Response.Write("{\"msg\":\"OK\"}"); }
public void CheckUserName() { int id = RequestTool.RequestInt("id", 0); string UserName = RequestTool.RequestString("UserName"); string where = "UserName=lbsql{'" + UserName + "'}"; if (id > 0) { where += " and id!=" + id + ""; } int count = B_Lebi_User.Counts(where); if (count > 0) { Response.Write("{\"msg\":\"NO\"}"); } else { Response.Write("{\"msg\":\"OK\"}"); } }
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode) { id = RequestTool.RequestInt("id", 0); v = RequestTool.RequestString("v"); type = RequestTool.RequestInt("type", 0); LoadTheme(themecode, siteid, languagecode, pcode); path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("Ê×Ò³") + "\"><span>" + Tag("Ê×Ò³") + "</span></a><em class=\"home\">»</em><a class=\"text\"><span>" + Tag("Íü¼ÇÃÜÂë") + "</span></a>"; Lebi_User user = B_Lebi_User.GetModel("id=" + id + " and CheckCode = lbsql{'" + v + "'}"); if (user == null) { id = 0; type = 0; } user_answers = B_Lebi_User_Answer.GetList("User_id=" + id + "", "id asc", 20, 1); if (user_answers.Count == 0) { id = 0; type = 0; } EX_User.CheckForgetPWD(CurrentTheme, CurrentLanguage, type); }
/// <summary> /// 添加/编辑收货人信息 /// </summary> public void Address_Edit() { int id = RequestTool.RequestInt("id", 0); Lebi_User_Address model = B_Lebi_User_Address.GetModel("User_id=" + CurrentUser.id + " and id = " + id); if (model == null) { model = new Lebi_User_Address(); model = B_Lebi_User_Address.SafeBindForm(model); model.User_id = CurrentUser.id; B_Lebi_User_Address.Add(model); id = B_Lebi_User_Address.GetMaxId("User_id=" + CurrentUser.id + ""); } else { model = B_Lebi_User_Address.SafeBindForm(model); B_Lebi_User_Address.Update(model); } CurrentUser.User_Address_id = id; B_Lebi_User.Update(CurrentUser); Response.Write("{\"msg\":\"OK\",\"id\":\"" + id + "\"}"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("product_user_limit", "商品会员权限")) { WindowNoPower(); } 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); }
/// <summary> /// 删除收货人信息 /// </summary> public void Address_Del() { string id = RequestTool.RequestSafeString("id"); if (id == "") { Response.Write("{\"msg\":\"" + Tag("请选择要删除的信息") + "\"}"); return; } B_Lebi_User_Address.Delete("User_id = " + CurrentUser.id + " and id in (lbsql{" + id + "})"); Lebi_User_Address model = B_Lebi_User_Address.GetModel("User_id = " + CurrentUser.id + " and id = " + CurrentUser.User_Address_id + ""); if (model == null) { Lebi_User_Address models = B_Lebi_User_Address.GetModel("User_id = " + CurrentUser.id + ""); if (models != null) { CurrentUser.User_Address_id = B_Lebi_User_Address.GetMaxId("User_id=" + CurrentUser.id + ""); } B_Lebi_User.Update(CurrentUser); } Response.Write("{\"msg\":\"OK\"}"); }
/// <summary> /// 验证微信是否已经授权-登陆账号 /// </summary> public void wechatlogin() { string cid = CookieTool.GetCookieString("qrcodeid"); int id = 0; if (cid != "") { int.TryParse(cid, out id); Lebi_weixin_qrcode model = B_Lebi_weixin_qrcode.GetModel(id); if (model != null) { if (model.User_id > 0) { //CookieTool.SetCookieString("qrcodeid", "0", -1); CookieTool.DeleteCookie("qrcodeid"); Lebi_User user = B_Lebi_User.GetModel(model.User_id); EX_User.LoginOK(user); Response.Write("{\"msg\":\"OK\"}"); return; } } } Response.Write("{\"msg\":\"NO\"}"); }
/// <summary> /// 修改个人资料 /// </summary> public void User_Info() { bool Checkmobilephone = false; bool Checkemail = false; string MobilePhone = RequestTool.RequestSafeString("MobilePhone"); string Email = RequestTool.RequestSafeString("Email"); if (SYS.UserRegCheckedType.Contains("mobilephone")) { if (CurrentUser.MobilePhone != MobilePhone) { Checkmobilephone = true; string MobilePhone_checkcode = RequestTool.RequestSafeString("MobilePhone_checkcode"); try { string phonecheckcode = (string)Session["phonecheckcode"]; if (phonecheckcode != (MobilePhone + MobilePhone_checkcode)) { Response.Write("{\"msg\":\"" + Tag("手机验证码错误") + "\"}"); 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 { Response.Write("{\"msg\":\"" + Tag("手机验证码错误") + "\"}"); return; } } } if (SYS.UserRegCheckedType.Contains("email")) { if (CurrentUser.Email != 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; } } } B_Lebi_User.SafeBindForm(CurrentUser); if (Checkemail) { CurrentUser.IsCheckedEmail = 1; } if (Checkmobilephone) { CurrentUser.IsCheckedMobilePhone = 1; } B_Lebi_User.Update(CurrentUser); EX_User.UserInfoEdit(CurrentUser);//触发编辑用户资料事件 Response.Write("{\"msg\":\"OK\"}"); }
/// <summary> /// 生成新订单 /// </summary> public void order_save() { if (CurrentUserLevel.BuyRight != 1) { Response.Write("{\"msg\":\"" + Tag("您所在的分组不允许下单") + "\"}"); return; } int pay_id = RequestTool.RequestInt("pay_id", 0); int sid = RequestTool.RequestInt("sid", 0);//结算供应商ID int onlinepay_id = RequestTool.RequestInt("onlinepay_id", 0); decimal Money_UserCut = RequestTool.RequestDecimal("Money_UserCut", 0); int usermoneytype = RequestTool.RequestInt("usermoneytype", 0); string Pay_Password = RequestTool.RequestSafeString("Pay_Password"); Lebi_PickUp pick = null; DateTime pickdate = System.DateTime.Now; if (usermoneytype == 3) { if (Pay_Password == "") { Response.Write("{\"msg\":\"" + Tag("请输入支付密码") + "\"}"); return; } else { if (EX_User.MD5(Pay_Password) != CurrentUser.Pay_Password) { Response.Write("{\"msg\":\"" + Tag("支付密码不正确") + "\"}"); return; } } if (Money_UserCut > 0 && Money_UserCut > CurrentUser.Money) { Response.Write("{\"msg\":\"" + Tag("余额不足") + "\"}"); return; } } Lebi_Pay pay = B_Lebi_Pay.GetModel(pay_id); if (pay == null) { Response.Write("{\"msg\":\"" + Tag("请设置付款方式") + "\"}"); return; } Basket basket = new Basket(sid); int CustomOfflineMoney = RequestTool.RequestInt("CustomOfflineMoney" + pay.id, 0); decimal OfflineMoney = RequestTool.RequestDecimal("OfflineMoney" + pay.id, 0); if (CustomOfflineMoney == 1) { if (pay.Code != "OfflinePay" && pay.Code != "OnlinePay") { //订单如果选择了线下支付,并且非货到付款 if (OfflineMoney < basket.Money_Product) { Response.Write("{\"msg\":\"" + Tag("打款金额不能少于订单金额") + "\"}"); return; } } } if (pay.Code == "OnlinePay") { Lebi_OnlinePay onpay = B_Lebi_OnlinePay.GetModel(onlinepay_id); if (onpay == null) { Response.Write("{\"msg\":\"" + Tag("请设置付款方式") + "\"}"); return; } } if (basket.Products.Count == 0) { Response.Write("{\"msg\":\"" + Tag("购物车为空") + "\"}"); return; } foreach (Lebi_User_Product up in basket.Products) { if (up.count < 1) { Response.Write("{\"msg\":\"" + Tag("购物车异常") + "\"}"); return; } } if (basket.Point_Buy > 0 && (basket.Point_Buy > CurrentUser.Point)) { Response.Write("{\"msg\":\"" + Tag("积分不足") + "\"}"); return; } int ProductCount = 0; foreach (Lebi_User_Product up in basket.Products) { Lebi_Product pro = B_Lebi_Product.GetModel(up.Product_id); if (pro.Type_id_ProductType != 323) { ProductCount += up.count; } //<-{ 判断是否上架状态 by lebi.kingdge 2015-02-10 if (pro.Type_id_ProductStatus != 101) { Response.Write("{\"msg\":\"" + Lang(pro.Name) + " " + Tag("该商品已经下架") + "\"}"); return; } //}-> if (pro.Type_id_ProductType != 324) { int levelcount = ProductLevelCount(pro); if (up.count < levelcount) { Response.Write("{\"msg\":\"" + Lang(pro.Name) + " " + Tag("起订量") + " " + levelcount + "\"}"); return; } } if (pro.Type_id_ProductType != 320 && pro.Time_Expired > System.DateTime.Now) { if (pro.Count_Limit < up.count && pro.Count_Limit > 0) { Response.Write("{\"msg\":\"" + Tag("购买数量大于限购数量") + "\"}"); return; } } if (SYS.IsNullStockSale != "1") { if (pro.Count_Stock - pro.Count_Freeze < up.count && pro.Type_id_ProductType != 324) { Response.Write("{\"msg\":\"" + Lang(pro.Name) + "" + Tag("库存不足") + "\"}"); return; } } } //验证当前分组允许的最低订单提交金额 if (CurrentUserLevel.OrderSubmit > 0) { if (basket.Money_Product < CurrentUserLevel.OrderSubmit) { Response.Write("{\"msg\":\"" + Tag("单笔订单最低金额为:") + FormatMoney(CurrentUserLevel.OrderSubmit) + "\"}"); return; } } //验证当前分组允许的最低订单提交数量 if (CurrentUserLevel.OrderSubmitCount > 0 && ProductCount > 0) { if (ProductCount < CurrentUserLevel.OrderSubmitCount) { Response.Write("{\"msg\":\"" + Tag("单笔订单最低数量为:") + CurrentUserLevel.OrderSubmitCount + "\"}"); return; } } Lebi_User_Address shouhuo = B_Lebi_User_Address.GetModel(CurrentUser.User_Address_id); if (shouhuo == null) { Response.Write("{\"msg\":\"" + Tag("未设置收获地址") + "\"}"); return; } if (CurrentUser.Transport_Price_id == "") { Response.Write("{\"msg\":\"" + Tag("运费设置错误") + "\"}"); return; } foreach (BasketShop shop in basket.Shops) { Lebi_Transport_Price tprice = B_Lebi_Transport_Price.GetModel("id in (lbsql{" + CurrentUser.Transport_Price_id + "}) and Supplier_id=" + shop.Shop.id + ""); if (tprice == null) { Response.Write("{\"msg\":\"" + Tag("运费设置错误") + "\"}"); return; } Lebi_Transport transport = B_Lebi_Transport.GetModel(tprice.Transport_id); if (tprice == null) { Response.Write("{\"msg\":\"" + Tag("运费设置错误") + "\"}"); return; } //检查运费设置是否正确 if (!EX_Area.CheckAreaPrice(tprice, shouhuo.Area_id)) { Response.Write("{\"msg\":\"" + Tag("运费设置错误") + "\"}"); return; } if (transport.Type_id_TransportType == 332)//自提检查 { int pickup_id = RequestTool.RequestInt("pickup_id" + shop.Shop.id); string pickdate_ = RequestTool.RequestString("pickupdate_" + pickup_id); try { pickdate = Convert.ToDateTime(pickdate_); } catch { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } pick = B_Lebi_PickUp.GetModel(pickup_id); if (pick == null) { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } if (pick.IsCanWeekend == 0 && (pickdate.DayOfWeek == DayOfWeek.Saturday || pickdate.DayOfWeek == DayOfWeek.Sunday)) { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } if (System.DateTime.Now.Date.AddDays(pick.BeginDays) > pickdate) { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } string NoServiceDays = pick.NoServiceDays.TrimStart('0').Replace(".0", "."); string nowday = pickdate.ToString("M.d"); if (("," + NoServiceDays + ",").Contains("," + nowday + ",")) { Response.Write("{\"msg\":\"" + Tag("配送方式设置错误") + "\"}"); return; } } } //检查代金券 string pay312 = RequestTool.RequestSafeString("pay312"); if (pay312 != "") { List <Lebi_Card> cs = B_Lebi_Card.GetList("User_id=" + CurrentUser.id + " and id in (lbsql{" + pay312 + "})", "id asc"); int flag = cs.FirstOrDefault().IsCanOtherUse; if (flag == 0 && cs.Count > 1) { Response.Write("{\"msg\":\"" + Tag("代金券异常") + "\"}"); return; } foreach (Lebi_Card c in cs) { if (flag != c.IsCanOtherUse) { Response.Write("{\"msg\":\"" + Tag("代金券异常") + "\"}"); return; } if (!Basket.CheckCard(basket, c)) { Response.Write("{\"msg\":\"" + Tag("代金券异常") + "\"}"); return; } } } //检查代金券结束 //检查发票信息 int billtype_id = RequestTool.RequestInt("billtype_id", 0); Lebi_BillType billtype = B_Lebi_BillType.GetModel(billtype_id); if (ShopCache.GetBaseConfig().BillFlag == "1") { if (billtype == null) { Response.Write("{\"msg\":\"" + Tag("请设置发票内容") + "\"}"); return; } } CurrentUser.Pay_id = pay.id; CurrentUser.OnlinePay_id = onlinepay_id; Lebi_Order ordergroup; List <Lebi_Order> orders = Shop.Bussiness.Order.CreateOrder(CurrentUser, basket, shouhuo, billtype, CurrentCurrency, CurrentSite, CurrentLanguage, out ordergroup); CurrentUser.Count_Order = CurrentUser.Count_Order + orders.Count; B_Lebi_User.Update(CurrentUser); List <Lebi_Order> ordermodel = B_Lebi_Order.GetList("User_id=" + CurrentUser.id + "", "id desc"); ordergroup = ordermodel.FirstOrDefault(); if (OfflineMoney == 0) { OfflineMoney = ordergroup.Money_Order; } string remark = RequestTool.RequestSafeString("remark"); ordergroup.Remark_User = remark; bool needupdate = false; if (remark != "") { Lebi_Comment model = new Lebi_Comment(); model.Content = remark; model.Keyid = ordergroup.id; model.TableName = "Order"; model.User_id = CurrentUser.id; model.User_UserName = CurrentUser.UserName; B_Lebi_Comment.Add(model); needupdate = true; } if (pick != null) { ordergroup.PickUp_Date = pickdate; ordergroup.PickUp_id = pick.id; ordergroup.PickUp_Name = pick.Name; needupdate = true; } if (needupdate) { B_Lebi_Order.Update(ordergroup); } if (pay.Code != "OfflinePay" && pay.Code != "OnlinePay") { //订单如果选择了线下支付,并且非货到付款 //生成一笔充值单 //OfflineMoney Lebi_Currency DefaultCurrency = B_Lebi_Currency.GetModel("IsDefault=1"); if (DefaultCurrency == null) { DefaultCurrency = B_Lebi_Currency.GetList("", "Sort desc").FirstOrDefault(); } Lebi_Order order = new Lebi_Order(); order.Code = "M" + Shop.Bussiness.Order.CreateOrderCode(); order.Money_Order = OfflineMoney; order.Money_Pay = OfflineMoney; order.User_id = CurrentUser.id; order.User_UserName = CurrentUser.UserName; order.IsPaid = 0; order.Currency_Code = ordergroup.Currency_Code; order.Currency_ExchangeRate = ordergroup.Currency_ExchangeRate; order.Currency_id = ordergroup.Currency_id; order.Currency_Msige = ordergroup.Currency_Msige; order.Type_id_OrderType = 214; order.Pay_id = pay.id; order.Pay = pay.Name; order.Site_id = CurrentSite.id; order.Language_id = CurrentLanguage.id; order.Remark_Admin = ""; order.Order_id = ordergroup.id; B_Lebi_Order.Add(order); } //if (orders.Count == 1) // ordergroup = orders.FirstOrDefault(); //Shop.Bussiness.Order.SupplierOrder(order);//根据商品供应商分单 Response.Write("{\"msg\":\"OK\",\"id\":\"" + ordergroup.id + "\"}"); return; }
/// <summary> /// 生成退货单 /// </summary> public void torder_save() { int order_id = RequestTool.RequestInt("order_id", 0); string opid = RequestTool.RequestSafeString("opid"); if (opid == "") { Response.Write("{\"msg\":\"" + Tag("未选择任何商品") + "\"}"); return; } int count = 0; Lebi_Order order = B_Lebi_Order.GetModel(order_id); if (order == null) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } if (order.User_id != CurrentUser.id) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } List <Lebi_Order_Product> ops = B_Lebi_Order_Product.GetList("id in (lbsql{" + opid + "}) and Order_id=" + order.id + "", ""); foreach (Lebi_Order_Product op in ops) { int rcount = RequestTool.RequestInt("product_" + op.id, 0); if (rcount > (op.Count_Received - op.Count_Return)) { Response.Write("{\"msg\":\"" + Tag("退货数量不能大于收货数量") + "\"}"); return; } if (rcount < 1) { Response.Write("{\"msg\":\"" + Tag("退货数量不能小于1") + "\"}"); return; } count = count + rcount; } if (count == 0) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } //CurrentUser.Count_Order = CurrentUser.Count_Order + 1; //B_Lebi_User.Update(CurrentUser); //foreach (Lebi_Order_Product op in ops) //{ // op.Count_Return = op.Count_Return + RequestTool.RequestInt("product_" + op.id, 0); // B_Lebi_Order_Product.Update(op); //} Lebi_Order model = new Lebi_Order(); model.Order_id = order.id; model.User_id = CurrentUser.id; model.User_UserName = CurrentUser.UserName; model.T_Name = order.T_Name; model.T_Address = order.T_Address; model.T_Area_id = order.T_Area_id; model.T_MobilePhone = order.T_MobilePhone; model.T_Phone = order.T_Phone; model.T_Postalcode = order.T_Postalcode; model.Weight = 0; model.Money_Product = 0; model.Type_id_OrderType = 212; model.Code = Shop.Bussiness.Order.CreateOrderCode(); model.Supplier_id = order.Supplier_id; model.Site_id = CurrentSite.id; model.Language_id = CurrentLanguage.id; B_Lebi_Order.Add(model); model.id = B_Lebi_Order.GetMaxId(); foreach (Lebi_Order_Product op in ops) { count = RequestTool.RequestInt("product_" + op.id, 0); op.Count_Return = op.Count_Return + count; B_Lebi_Order_Product.Update(op); op.Count = count; op.Count_Shipped = 0; op.Count_Received = 0; op.Order_Code = model.Code; op.Order_id = model.id; op.Money = op.Price * op.Count; B_Lebi_Order_Product.Add(op); model.Money_Product = model.Money_Product + (op.Price - op.Money_Give_one - op.Money_Card312_one) * count; model.Weight = model.Weight + op.Weight * count; model.Volume = model.Weight + op.Volume * count; model.Point = model.Point + op.Point_Give_one; } model.Money_Product = 0 - model.Money_Product; model.Money_Order = model.Money_Product; model.Money_Pay = model.Money_Product; model.Money_Give = 0 - model.Money_Order; model.Point = 0 - model.Point; B_Lebi_Order.Update(model); //处理留言 Lebi_Comment com = new Lebi_Comment(); com.Content = RequestTool.RequestSafeString("say"); com.Keyid = model.id; com.TableName = "Order"; com.User_id = CurrentUser.id; com.User_UserName = CurrentUser.UserName; B_Lebi_Comment.Add(com); Lebi_User user = B_Lebi_User.GetModel(CurrentUser.id); Lebi_Order ordermodel = B_Lebi_Order.GetModel("Order_id=" + order_id + ""); //发送邮件 if (ShopCache.GetBaseConfig().MailSign.ToLower().Contains("dingdantijiao") || ShopCache.GetBaseConfig().AdminMailSign.ToLower().Contains("ordersubmit")) { Email.SendEmail_ordersubmit(user, ordermodel); } //发送短信 if (ShopCache.GetBaseConfig().SMS_sendmode.Contains("SMSTPL_ordersubmit") || ShopCache.GetBaseConfig().SMS_sendmode.Contains("SMSTPL_Admin_ordersubmit")) { SMS.SendSMS_ordersubmit(user, order); } Response.Write("{\"msg\":\"OK\"}"); }
protected void Page_Load(object sender, EventArgs e) { //创建ResponseHandler实例 ResponseHandler resHandler = new ResponseHandler(Context); //判断签名 try { //string return_code = RequestTool.RequestString("return_code");//SUCCESS/FAIL此字段是通信标识,非交易标识,交易是否成功需要查看 result_code 来判断 //string return_msg = RequestTool.RequestString("return_msg");//返回信息,如非空,为错误原因/签名失败/参数格式校验错误 //string appid = RequestTool.RequestString("appid"); //string mch_id = RequestTool.RequestString("mch_id"); //string nonce_str = RequestTool.RequestString("nonce_str"); //string sign = RequestTool.RequestString("sign"); //string result_code = RequestTool.RequestString("result_code");//业务结果SUCCESS/FAIL //string error_code = RequestTool.RequestString("error_code"); //string error_code_des = RequestTool.RequestString("error_code_des"); //string openid = RequestTool.RequestString("openid"); //string trade_type = RequestTool.RequestString("trade_type");//交易类型 //string bank_type = RequestTool.RequestString("bank_type");//out_trade_no //string total_fee = RequestTool.RequestString("total_fee"); //string out_trade_no = RequestTool.RequestString("out_trade_no"); //string attach = RequestTool.RequestString("attach");//商家数据包,原样返回 //string time_end = RequestTool.RequestString("time_end"); //string transaction_id = RequestTool.RequestString("transaction_id");//微信支付单号 #region 协议参数===================================== //--------------协议参数-------------------------------------------------------- //SUCCESS/FAIL此字段是通信标识,非交易标识,交易是否成功需要查 string return_code = resHandler.getParameter("return_code"); //返回信息,如非空,为错误原因签名失败参数格式校验错误 string return_msg = resHandler.getParameter("return_msg"); //微信分配的公众账号 ID string appid = resHandler.getParameter("appid"); //以下字段在 return_code 为 SUCCESS 的时候有返回-------------------------------- //微信支付分配的商户号 string mch_id = resHandler.getParameter("mch_id"); //微信支付分配的终端设备号 string device_info = resHandler.getParameter("device_info"); //微信分配的公众账号 ID string nonce_str = resHandler.getParameter("nonce_str"); //业务结果 SUCCESS/FAIL string result_code = resHandler.getParameter("result_code"); //错误代码 string err_code = resHandler.getParameter("err_code"); //结果信息描述 string err_code_des = resHandler.getParameter("err_code_des"); //以下字段在 return_code 和 result_code 都为 SUCCESS 的时候有返回--------------- //-------------业务参数--------------------------------------------------------- //用户在商户 appid 下的唯一标识 string openid = resHandler.getParameter("openid"); //用户是否关注公众账号,Y-关注,N-未关注,仅在公众账号类型支付有效 string is_subscribe = resHandler.getParameter("is_subscribe"); //JSAPI、NATIVE、MICROPAY、APP string trade_type = resHandler.getParameter("trade_type"); //银行类型,采用字符串类型的银行标识 string bank_type = resHandler.getParameter("bank_type"); //订单总金额,单位为分 string total_fee = resHandler.getParameter("total_fee"); //货币类型,符合 ISO 4217 标准的三位字母代码,默认人民币:CNY string fee_type = resHandler.getParameter("fee_type"); //微信支付订单号 string transaction_id = resHandler.getParameter("transaction_id"); //商户系统的订单号,与请求一致。 string out_trade_no = resHandler.getParameter("out_trade_no"); //商家数据包,原样返回 string attach = resHandler.getParameter("attach"); //支 付 完 成 时 间 , 格 式 为yyyyMMddhhmmss,如 2009 年12 月27日 9点 10分 10 秒表示为 20091227091010。时区为 GMT+8 beijing。该时间取自微信支付服务器 string time_end = resHandler.getParameter("time_end"); #endregion SystemLog.Add("JSAPI微信支付回调payNotifyUrl"); Lebi_Order order = B_Lebi_Order.GetModel("Code=lbsql{'" + out_trade_no + "'}"); if (order == null) { Response.Write("系统错误"); SystemLog.Add("JSAPI微信支付-订单号" + out_trade_no + "不存在"); Response.End(); return; } TenpayUtil tu = new TenpayUtil(order); //SystemLog.Add(return_code + "|||" + result_code + "|||" + openid + "|||" + mch_id + "|||" + out_trade_no); if (return_code == "SUCCESS" && result_code == "SUCCESS") { Lebi_User user = B_Lebi_User.GetModel(order.User_id); Lebi_OnlinePay pay = B_Lebi_OnlinePay.GetModel("Code='weixinpay' and ','+Language_ids+',' like '%," + order.Language_id + ",%'"); if (pay == null) { Log.Add("在线支付接口 weixinpay 配置错误"); SystemLog.Add("JSAPI微信支付-接口配置错误"); return; } //if (user.bind_weixin_id == openid && pay.UserName == mch_id) //{ Order.OnlinePaySuccess(out_trade_no, transaction_id, false); Response.Write(paysuccess()); return; //} } SystemLog.Add("JSAPI微信支付-签名失败"); Response.Write(payerror("签名失败")); } catch (Exception ex) { SystemLog.Add("JSAPI微信支付-参数格式校验错误[" + ex.ToString() + "]"); Response.Write(payerror("参数格式校验错误")); } }
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> /// 订单发货通知-不更新库存 /// </summary> public void mSndGoods() { //OrderID 订单编号 //OrderNO 原始订单编号 //CustomerID 客户网名 //SndStyle 发货方式 //BillID 货运单号 //SndDate 发货时间 string OrderID = RequestTool.RequestString("OrderID"); string OrderNO = RequestTool.RequestString("OrderNO"); string CustomerID = RequestTool.RequestString("CustomerID"); string SndStyle = RequestTool.RequestString("SndStyle"); string BillID = RequestTool.RequestString("BillID"); string SndDate = RequestTool.RequestString("SndDate"); Lebi_Order model = B_Lebi_Order.GetModel("Code=lbsql{'" + OrderNO + "'}"); Lebi_Language_Code lang = Language.DefaultLanguage(); string res = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n"; if (model == null) { res += "<rsp><result>0</result><cause>无此单号</cause></rsp>"; Response.Write(res); return; } Lebi_Transport tran = B_Lebi_Transport.GetModel("[Name]=lbsql{'" + SndStyle + "'}"); if (tran == null) { tran = new Lebi_Transport(); } Lebi_Transport_Order torder = new Lebi_Transport_Order(); torder.Code = BillID; torder.Order_id = model.id; torder.T_Address = model.T_Address; torder.T_Email = model.T_Email; torder.T_MobilePhone = model.T_MobilePhone; torder.T_Name = model.T_Name; torder.T_Phone = model.T_Phone; torder.Transport_Code = tran == null ? model.Transport_Code : tran.Code; torder.Transport_id = tran == null ? model.Transport_id : tran.id; torder.Transport_Name = tran == null ? model.Transport_Name : tran.Name; torder.User_id = model.User_id; List <TransportProduct> tps = new List <TransportProduct>(); TransportProduct tp; List <Lebi_Order_Product> pros = B_Lebi_Order_Product.GetList("Order_id=" + model.id + "", ""); bool isfahuo_all = true; foreach (Lebi_Order_Product pro in pros) { tp = new TransportProduct(); tp.Count = pro.Count; tp.ImageBig = pro.ImageBig; tp.ImageMedium = pro.ImageMedium; tp.ImageOriginal = pro.ImageOriginal; tp.ImageSmall = pro.ImageSmall; tp.Product_Number = pro.Product_Number; tp.Product_id = pro.Product_id; tp.Product_Name = pro.Product_Name; tps.Add(tp); pro.Count_Shipped = pro.Count; B_Lebi_Order_Product.Update(pro); //更新库存 Lebi_Product product = B_Lebi_Product.GetModel(pro.Product_id); EX_Product.ProductStock_Change(product, (0 - pro.Count), 302, model); } JavaScriptSerializer jss = new JavaScriptSerializer(); torder.Product = jss.Serialize(tps); torder.Type_id_TransportOrderStatus = 220;//默认状态:在途 B_Lebi_Transport_Order.Add(torder); model.IsShipped = 1; model.IsShipped_All = isfahuo_all ? 1 : 0; model.Time_Shipped = System.DateTime.Now;; B_Lebi_Order.Update(model); Log.Add("订单发货-网站管家", "Order", model.id.ToString()); //发送邮件 if (ShopCache.GetBaseConfig().MailSign.ToLower().Contains("dingdanfahuo")) { Lebi_User user = B_Lebi_User.GetModel(model.User_id); Email.SendEmail_ordershipping(user, model, torder); } res += "<rsp><result>1</result></rsp>"; Response.Write(res); Log.Add("订单编号:" + OrderNO + "--" + res, "网店管家同步发货", ""); }
public static string package = ""; //进行支付需要的包 protected void Page_Load(object sender, EventArgs e) { Lebi_OnlinePay pay = B_Lebi_OnlinePay.GetModel("Code='weixinpay'"); if (pay == null) { Log.Add("在线支付接口 weixinpay 配置错误"); return; } Shop.Bussiness.Site site = new Shop.Bussiness.Site(); B_BaseConfig bconfig = new B_BaseConfig(); BaseConfig SYS = bconfig.LoadConfig(); partnerid = pay.UserName; partnerkey = pay.UserKey; appid = SYS.platform_weixin_id; appsecret = SYS.platform_weixin_secret; appkey = ""; notify_url = "http://" + RequestTool.GetRequestDomain() + site.WebPath + "/onlinepay/weixinpay.aspx"; Lebi_Currency currendy = B_Lebi_Currency.GetModel(pay.Currency_id); int order_id = RequestTool.RequestInt("order_id", 0); Lebi_Order order = B_Lebi_Order.GetModel(order_id); if (order == null) { Response.Write("订单错误"); Response.End(); return; } string order_price = (order.Money_Pay * currendy.ExchangeRate * 100).ToString(); string sp_billno = order.Code; Lebi_User user = B_Lebi_User.GetModel(order.User_id); if (user == null) { Response.Write("订单错误"); Response.End(); return; } /////////////////////////////////////////////////////////////////////////////////////////////// //当前时间 yyyyMMdd string date = DateTime.Now.ToString("yyyyMMdd"); if (null == sp_billno) { //生成订单10位序列号,此处用时间和随机数生成,商户根据自己调整,保证唯一 sp_billno = DateTime.Now.ToString("HHmmss") + TenpayUtil.BuildRandomStr(4); } else { sp_billno = Request["order_no"]; } sp_billno = partnerid + sp_billno; //创建支付应答对象 var packageReqHandler = new RequestHandler(Context); //初始化 packageReqHandler.init(); timeStamp = TenpayUtil.getTimestamp(); nonceStr = TenpayUtil.getNoncestr(); //设置package订单参数 packageReqHandler.setParameter("body", "test"); //商品信息 127字符 packageReqHandler.setParameter("appid", user.bind_weixin_id); packageReqHandler.setParameter("mch_id", mchid); packageReqHandler.setParameter("nonce_str", nonceStr.ToLower()); packageReqHandler.setParameter("notify_url", notify_url); packageReqHandler.setParameter("openid", "openid"); packageReqHandler.setParameter("out_trade_no", sp_billno); //商家订单号 packageReqHandler.setParameter("spbill_create_ip", Page.Request.UserHostAddress); //用户的公网ip,不是商户服务器IP packageReqHandler.setParameter("total_fee", "1"); //商品金额,以分为单位(money * 100).ToString() packageReqHandler.setParameter("trade_type", "JSAPI"); //获取package包 sign = packageReqHandler.CreateMd5Sign("key", appkey); WriteFile(Server.MapPath("") + "\\Log.txt", sign); packageReqHandler.setParameter("sign", sign); string data = packageReqHandler.parseXML(); WriteFile(Server.MapPath("") + "\\Log.txt", data); string prepayXml = HttpUtil.Send(data, "https://api.mch.weixin.qq.com/pay/unifiedorder"); WriteFile(Server.MapPath("") + "\\Log.txt", prepayXml); //获取预支付ID var xdoc = new XmlDocument(); xdoc.LoadXml(prepayXml); XmlNode xn = xdoc.SelectSingleNode("xml"); XmlNodeList xnl = xn.ChildNodes; if (xnl.Count > 7) { prepayId = xnl[7].InnerText; package = string.Format("prepay_id={0}", prepayId); WriteFile(Server.MapPath("") + "\\Log.txt", package); } //设置支付参数 var paySignReqHandler = new RequestHandler(Context); paySignReqHandler.setParameter("appId", appId); paySignReqHandler.setParameter("timeStamp", timeStamp); paySignReqHandler.setParameter("nonceStr", nonceStr); paySignReqHandler.setParameter("package", package); paySignReqHandler.setParameter("signType", "MD5"); paySign = paySignReqHandler.CreateMd5Sign("key", appkey); WriteFile(Server.MapPath("") + "\\Log.txt", paySign); }
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("授权失败"); }