/// <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\"}"); }
/// <summary> /// 计算促销活动 /// </summary> /// <param name="Products">商品信息</param> /// <param name="CurrentUser">购买者</param> /// <param name="shop">供应商,为空表示自营商品</param> /// <param name="basketshop"></param> public static BasketShop SetMoneyAndPoint(Lebi_User CurrentUser, Lebi_UserLevel CurrentUserLevel, BasketShop basketshop) { string pids = "0"; decimal Money_Product_begin = 0; int Count = 0; decimal Weight = 0; //订单总重量 decimal Volume = 0; //订单总体积 int Money_Transport_One = 0; bool IsTransportPriceOne = false; decimal Money_Market = 0; decimal Money_Cut = 0; decimal Money_Give = 0; decimal Point_Free = 0; //赠送积分 decimal Point_Product = 0; //商品获得的积分 decimal Point = 0; //获得的积分总数 decimal Point_Buy = 0; //积分换购所需积分 decimal Money_Product = 0; decimal Money_Property = 0; List <Lebi_User_Product> FreeProducts = new List <Lebi_User_Product>(); List <Lebi_Promotion_Type> PromotionTypes = new List <Lebi_Promotion_Type>(); if (CurrentUserLevel == null) { CurrentUserLevel = B_Lebi_UserLevel.GetModel(CurrentUser.UserLevel_id); } List <Lebi_User_Product> Products = basketshop.Products; Lebi_Supplier shop = basketshop.Shop; foreach (Lebi_User_Product pro in Products) { Lebi_Product product = B_Lebi_Product.GetModel(pro.Product_id); if (product == null) { continue; } pro.Discount = 100; pro.Pointagain = 1; //pro.Product_Price = EX_Product.ProductPrice(product, CurrentUserLevel,pro.count);//单价 if (CurrentUserLevel.MoneyToPoint > 0) { pro.Product_Point = pro.Product_Price * CurrentUserLevel.MoneyToPoint + pro.Product_Point;//单个产品可得的积分 } pids += "," + pro.Product_id; Money_Product_begin = Math.Round(Money_Product_begin + pro.Product_Price * pro.count, 2); Count = Count + pro.count; Money_Market = Money_Market + EX_Product.ProductMarketPrice(product) * pro.count; //兼容分销 2018.3.8 by lebi.kingdge Money_Property = Money_Property + pro.ProPerty_Price * pro.count; Money_Product = Money_Product + pro.Product_Price * pro.count; Weight = Weight + product.Weight * pro.count; Volume = Volume + product.VolumeH * product.VolumeL * product.VolumeW * pro.count; Point_Product = Point_Product + Math.Round(pro.Product_Point * pro.count, 2); Point = Point_Product + Point_Free; //320一般商品321限时抢购322团购323积分换购 if (product.Type_id_ProductType == 323 && product.Time_Expired > System.DateTime.Now) { Point_Buy = Point_Buy + product.Price_Sale * pro.count; } } List <Lebi_Promotion_Type> cps = Promotion.CurrentPromotionType(); if (shop == null) { shop = new Lebi_Supplier(); } foreach (Lebi_Promotion_Type cp in cps) { //检查是否商铺单独促销 if (cp.Type_id_PromotionType == 421) { if (shop.id > 0) { continue; } } if (cp.Type_id_PromotionType == 422) { if (shop.id != cp.Supplier_id) { continue; } } //检查会员组别 if (!("," + cp.UserLevel_ids + ",").Contains("," + CurrentUserLevel.id + ",")) { continue; } bool flag = true; string where = "1=1"; List <Lebi_User_Product> sps = null; foreach (Lebi_Promotion p in Promotion.GetPromotion(cp.id))//只匹配一个条件 { flag = true; if (p.Case804 == "") { p.Case804 = "0"; } if (p.Case805 == "") { p.Case805 = "0"; } //验证订单金额:801 if (p.IsCase801 == 1) { if (Money_Product_begin < p.Case801) { flag = false; continue; } } //验证订单商品数量:802 if (p.IsCase802 == 1) { if (Count < p.Case802) { flag = false; continue; } } //验证商品分类:804 if (p.IsCase804 == 1) { where += " and Pro_Type_id in (" + p.Case804 + ")"; if (B_Lebi_Product.Counts("id in (" + pids + ") and Pro_Type_id in (" + p.Case804 + ")") == 0) { flag = false; continue; } } //验证限制商品:805 if (p.IsCase805 == 1) { where += "and id in (" + p.Case805 + ")"; if (B_Lebi_Product.Counts("id in (" + pids + ") and id in (" + p.Case805 + ")") == 0) { flag = false; continue; } } //验证单品数量:803 if (p.IsCase803 == 1) { string tids = "0"; //取出购物车中,数量大于水平线的商品 foreach (Lebi_User_Product up in Products) { if (up.count >= p.Case803) { tids += "," + up.Product_id; } } if (tids == "0") { flag = false; continue; } where += " and id in (" + tids + ")"; if (B_Lebi_Product.Counts(where) == 0) { flag = false; continue; } } //验证订单内指定商品数量:806 if (p.IsCase806 == 1) { if (p.Case804 == "" && p.Case805 == "")//未设置限制条件的话,直接失败 { flag = false; continue; } int count = 0; //计算购物车中包含商品的总数 foreach (Lebi_User_Product up in Products) { if (("," + p.Case804 + ",").Contains("," + up.Pro_Type_id + ",") || ("," + p.Case805 + ",").Contains("," + up.Product_id + ",")) { count = count + up.count; } } if (count < p.Case806) { flag = false; continue; } } //条件检查结束 if (flag) { //取出验证成功的指定商品 sps = B_Lebi_User_Product.GetList("User_id=" + CurrentUser.id + " and type_id_UserProductType=142 and Product_id in (select id from [Lebi_Product] where " + where + ")", ""); //计算定额运费901 if (p.IsRule901 == 1) { Money_Transport_One = p.Rule901; IsTransportPriceOne = true; } //计算折扣902 if (p.IsRule902 == 1) { foreach (Lebi_User_Product pro in Products) { pro.Discount = pro.Discount * p.Rule902 / 100; } } //计算指定商品折扣903 if (p.IsRule903 == 1) { if (sps != null) { foreach (Lebi_User_Product pro in Products) { foreach (Lebi_User_Product sp in sps) { if (pro.id == sp.id) { pro.Discount = pro.Discount * p.Rule903 / 100; } } } } } //计算减免金额904 if (p.IsRule904 == 1) { Money_Cut = p.Rule904; } //计算返还金额905 if (p.IsRule905 == 1) { Money_Give = p.Rule905; } //计算赠送积分906 if (p.IsRule906 == 1) { Point_Free = p.Rule906; } //计算翻倍积分907 if (p.IsRule907 == 1) { foreach (Lebi_User_Product pro in Products) { pro.Pointagain = pro.Pointagain + p.Rule907; } } //计算指定商品折扣翻倍积分908 if (p.IsRule908 == 1) { if (sps != null) { foreach (Lebi_User_Product pro in Products) { foreach (Lebi_User_Product sp in sps) { if (pro.id == sp.id) { pro.Pointagain = pro.Pointagain + p.Rule908; } } } } } //赠送商品909 if (p.IsRule909 == 1) { //暂时不做 } //赠送指定商品910 if (p.IsRule910 == 1) { if (sps != null) { foreach (Lebi_User_Product sp in sps) { sp.count = p.Rule910; sp.Product_Price = 0; sp.Product_Point = 0; sp.Pointagain = 0; sp.Discount = 0; FreeProducts.Add(sp); } } } //第N个指定商品打折 if (p.IsRule912 == 1 && p.IsCase803 == 1 && p.Case803 > 0) { foreach (Lebi_User_Product pro in Products) { foreach (Lebi_User_Product sp in sps) { if (pro.id == sp.id) { if (pro.count > p.Case803) { int n = sp.count / p.Case803; Money_Cut = Money_Cut + pro.Product_Price * (100 - p.Rule912) / 100 * n; } } } } } //重新计算价格积分, Money_Product = 0; Point_Product = 0; Point = 0; foreach (Lebi_User_Product pro in Products) { Money_Product += Math.Round(pro.Product_Price * pro.count * pro.Discount / 100, 2); Point_Product += Math.Round(pro.Product_Point * pro.count * pro.Pointagain); Point = Point_Product + Point_Free; } break;//验证成功不再验证 } } if (flag) { PromotionTypes.Add(cp); } } basketshop = new BasketShop(); basketshop.FreeProducts = FreeProducts; basketshop.Money_Cut = Money_Cut; basketshop.Money_Give = Money_Give; basketshop.Money_Market = Money_Market; basketshop.Money_Product = Money_Product; basketshop.Money_Product_begin = Money_Product_begin; basketshop.Money_Transport = 0; basketshop.Point = Point; basketshop.Point_Free = Point_Free; basketshop.Point_Buy = Point_Buy; basketshop.Point_Product = Point_Product; basketshop.Products = Products; basketshop.PromotionTypes = PromotionTypes; basketshop.Shop = shop; basketshop.Volume = Volume; basketshop.Weight = Weight; basketshop.IsTransportPriceOne = IsTransportPriceOne; basketshop.Money_Transport_One = Money_Transport_One; basketshop.Count = Count; basketshop.Money_Property = Money_Property; return(basketshop); }
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("参数格式校验错误")); } }
/// <summary> /// 编辑会员资金 /// </summary> public void UserMoney_Edit() { int id = RequestTool.RequestInt("id", 0); SearchUser su = new SearchUser(CurrentAdmin, CurrentLanguage.Code); decimal money = RequestTool.RequestDecimal("Money", 0); int Type_id_MoneyType = RequestTool.RequestInt("Type_id_MoneyType", 0); string Remark = RequestTool.RequestString("Remark"); if (id > 0) { if (!EX_Admin.Power("user_money_edit", "编辑会员资金")) { AjaxNoPower(); return; } Lebi_User_Money model = B_Lebi_User_Money.GetModel(id); Lebi_User user = B_Lebi_User.GetModel(model.User_id); Log.Add("编辑会员资金", "User_Money", id.ToString(), CurrentAdmin, user.UserName); if (user == null) { Response.Write("{\"msg\":\"" + Tag("会员账号不存在") + "\"}"); return; } //model.Type_id_MoneyStatus = RequestTool.RequestInt("Type_id_MoneyStatus", 0); model.Type_id_MoneyType = Type_id_MoneyType; model.Admin_UserName = CurrentAdmin.UserName; model.Admin_id = CurrentAdmin.id; model.Remark = Remark; model.Time_Update = DateTime.Now; B_Lebi_User_Money.Update(model); //EX_User.UpdateUserMoney(user); } else { if (!EX_Admin.Power("user_money_add", "添加会员资金")) { AjaxNoPower(); return; } string Mode = RequestTool.RequestString("mode"); string User_Name_To = RequestTool.RequestString("User_Name_To"); string UserLevel_ids = RequestTool.RequestString("UserLevel_ids"); string User_ids = RequestTool.RequestString("User_ids"); string UserName_ids = RequestTool.RequestString("UserName_ids"); if (Mode == "user") { Lebi_User user = B_Lebi_User.GetModel("UserName = lbsql{'" + User_Name_To + "'}"); if (user == null) { Response.Write("{\"msg\":\"" + Tag("会员账号不存在") + "\"}"); return; } Lebi_User_Money model = new Lebi_User_Money(); Log.Add("添加会员资金", "User_Money", id.ToString(), CurrentAdmin, User_Name_To + " ->" + RequestTool.RequestDecimal("Money", 0)); Money.AddMoney(user, money, Type_id_MoneyType, CurrentAdmin, "", Remark); } else { string where = ""; if (User_ids == "") { where = "1=1 " + su.SQL; Log.Add("添加会员资金", "User_Money", "", CurrentAdmin, su.Description + " ->" + RequestTool.RequestDecimal("Money", 0)); } else { where = "id in (" + User_ids + ")"; Log.Add("添加会员资金", "User_Money", "", CurrentAdmin, UserName_ids + " ->" + RequestTool.RequestDecimal("Money", 0)); } List <Lebi_User> modellist = B_Lebi_User.GetList(where, ""); foreach (Lebi_User user in modellist) { Money.AddMoney(user, money, Type_id_MoneyType, CurrentAdmin, "", Remark); } } } string result = "{\"msg\":\"OK\"}"; Response.Write(result); }
protected virtual void Page_Load(object sender, EventArgs e) { SystemLog.Add("api_weixin"); if (!Check()) { return; } try { //微信推送消息处理 Shop.Platform.Model.weixin.wxmessage wx = Shop.Platform.weixin.Instance.GetWxMessage(); string platform_weixin_subscribe_automsg = ""; string parentuserid = wx.EventKey.Replace("qrscene_", ""); Lebi_User parentuser = B_Lebi_User.GetModel("id=" + parentuserid + ""); if (parentuser == null) { parentuser = new Lebi_User(); } int DT_id = ShopPage.GetDT(); if (DT_id == 0) { BaseConfig bcf = ShopCache.GetBaseConfig(); platform_weixin_subscribe_automsg = bcf.platform_weixin_subscribe_automsg; if (parentuser != null) { DT_id = parentuser.DT_id; } } else { BaseConfig_DT bcf = ShopCache.GetBaseConfig_DT(DT_id); platform_weixin_subscribe_automsg = bcf.platform_weixin_subscribe_automsg; } string res = ""; if (!string.IsNullOrEmpty(wx.EventName) && wx.EventName.Trim() == "subscribe")//未关注情况下扫码的事件推送 { string content = ""; if (!wx.EventKey.Contains("qrscene_")) { content = platform_weixin_subscribe_automsg; res = Shop.Platform.weixin.Instance.sendTextMessage(wx, content); } else { //content = "二维码参数:\n" + wx.EventKey.Replace("qrscene_", ""); //res = Shop.Platform.weixin.Instance.sendTextMessage(wx, content); content = platform_weixin_subscribe_automsg; res = Shop.Platform.weixin.Instance.sendTextMessage(wx, content); parentuserid = wx.EventKey.Replace("qrscene_", ""); Lebi_User user = Shop.Platform.weixin.Instance.GetUserByopenid(wx.FromUserName, DT_id); if (parentuser != null) { if (parentuser.id != user.id && user.User_id_parent == 0) { //生成上下级关系 user = B_Lebi_User.GetModel(user.id); user.User_id_parent = parentuser.id; user.DT_id = DT_id; B_Lebi_User.Update(user); } } } Shop.Platform.weixin.GetInstance(DT_id, null).GetUserByopenid(wx.FromUserName, DT_id); } else if (!string.IsNullOrEmpty(wx.EventName) && wx.EventName.ToLower() == "scan")//已经关注情况下扫码的事件推送 { Lebi_User user = Shop.Platform.weixin.Instance.GetUserByopenid(wx.FromUserName); if (parentuser != null) { if (parentuser.id != user.id && user.User_id_parent == 0) { //生成上下级关系 user = B_Lebi_User.GetModel(user.id); user.User_id_parent = parentuser.id; user.DT_id = DT_id; B_Lebi_User.Update(user); } } //string str = "二维码参数:\n" + wx.EventKey; //res = Shop.Platform.weixin.Instance.sendTextMessage(wx, str); } else if (!string.IsNullOrEmpty(wx.EventName) && wx.EventName.Trim() == "CLICK") { if (wx.EventKey == "HELLO") { res = Shop.Platform.weixin.Instance.sendTextMessage(wx, "你好,欢迎使用公共微信平台!"); } } else { if (wx.MsgType == "text" && wx.Content == "你好") { res = Shop.Platform.weixin.Instance.sendTextMessage(wx, "你好,欢迎使用公共微信平台!"); } //else if (wx.MsgType == "voice") //{ // res = Shop.Platform.weixin.Instance.sendTextMessage(wx, wx.Recognition); //} else { res = Shop.Platform.weixin.Instance.sendTextMessage(wx, "你好,未能识别消息!"); } } Response.Write(res); } catch { } }
/// <summary> /// 重置密码 /// </summary> public void User_resetpwd() { int type = RequestTool.RequestInt("type", 0); string checkcode = RequestTool.RequestString("checkcode"); string email = RequestTool.RequestSafeString("email"); string PWD = RequestTool.RequestSafeString("PWD"); string RPWD = RequestTool.RequestSafeString("RPWD"); string v = RequestTool.RequestSafeString("v"); int id = RequestTool.RequestInt("id", 0); string Answer1 = EX_User.MD5(RequestTool.RequestSafeString("Answer1")); string Answer2 = EX_User.MD5(RequestTool.RequestSafeString("Answer2")); Lebi_User user = B_Lebi_User.GetModel("id=" + id + " and CheckCode = lbsql{'" + v + "'}"); bool flag = true; if (user == null) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } if (type == 0 && user != null) { if (user.CheckCode != checkcode) { Response.Write("{\"msg\":\"" + Tag("参数错误") + "\"}"); return; } } if (type == 1) { int i = 0; List <Lebi_User_Answer> modellists = B_Lebi_User_Answer.GetList("User_id = " + id + "", "id asc"); if (modellists.Count == 0) { Response.Write("{\"msg\":\"" + Tag("没有设置安全问题") + "\"}"); return; } foreach (Lebi_User_Answer modellist in modellists) { if (i == 0 && modellist.Answer != Answer1) { Response.Write("{\"msg\":\"" + Tag("问题答案回答不正确") + "\"}"); return; } if (i == 1 && modellist.Answer != Answer2) { Response.Write("{\"msg\":\"" + Tag("问题答案回答不正确") + "\"}"); return; } i++; } } if (PWD == "") { Response.Write("{\"msg\":\"" + Tag("密码不能为空") + "\"}"); return; } if (PWD != RPWD) { Response.Write("{\"msg\":\"" + Tag("两次输入的密码不一致,请检查") + "\"}"); return; } user.Password = EX_User.MD5(PWD); user.CheckCode = ""; B_Lebi_User.Update(user); Response.Write("{\"msg\":\"OK\"}"); }
/// <summary> /// 编辑会员 /// </summary> public void User_Edit() { if (!EX_Admin.Power("user_edit", "编辑会员")) { AjaxNoPower(); return; } int id = RequestTool.RequestInt("id", 0); int User_id_parent = RequestTool.RequestInt("User_id_parent", 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 && UserName != "") { Response.Write("{\"msg\":\"帐号已存在\"}"); return; } Lebi_User model = B_Lebi_User.GetModel(id); if (model == null) { model = new Lebi_User(); } B_Lebi_User.SafeBindForm(model); if (model.id == 0) { string PWD1 = RequestTool.RequestString("PWD1"); string PWD2 = RequestTool.RequestString("PWD2"); MD5CryptoServiceProvider hashmd5 = new MD5CryptoServiceProvider(); string PWD = BitConverter.ToString(hashmd5.ComputeHash(Encoding.Default.GetBytes(PWD1))).Replace("-", "").ToLower(); if (PWD1 != PWD2) { Response.Write("{\"msg\":\"两次输入的密码不一致\"}"); return; } model.Password = PWD; model.Site_id = ShopCache.GetMainSite().id; B_Lebi_User.Add(model); model.id = B_Lebi_User.GetMaxId(); EX_User.UserRegister(model);//触发事件 } else { //<-{更新会员下级用户数量 by lebi.kingdge 2015-04-09 if (User_id_parent > 0) { int Count_sonuser = B_Lebi_User.Counts("id = " + User_id_parent + ""); string sql = "update [Lebi_User] set Count_sonuser="******" where id=" + User_id_parent + ""; Common.ExecuteSql(sql); } model.Count_sonuser = B_Lebi_User.Counts("User_id_parent = " + id + ""); //}-> B_Lebi_User.Update(model); EX_User.UserInfoEdit(model);//触发编辑用户资料事件 } Log.Add("编辑会员信息", "User", id.ToString(), CurrentAdmin, model.UserName); string result = "{\"msg\":\"OK\", \"id\":\"" + id + "\"}"; Response.Write(result); }
public static Model Info(Lebi_User user) { BaseConfig bc = ShopCache.GetBaseConfig(); Model m = new Model(); decimal Money = 0; string money_ = Common.GetValue("select sum(Money) from Lebi_Agent_Money where User_id=" + user.id + " and Type_id_AgentMoneyStatus=382 and datediff(d,Time_add,'" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')>" + bc.CommissionMoneyDays + ""); decimal.TryParse(money_, out Money); int UserCount = 0; UserCount = B_Lebi_User.Counts("User_id_parent=" + user.id + ""); int UserCountmonth = 0; UserCountmonth = B_Lebi_User.Counts("User_id_parent=" + user.id + " and (datediff(d,Time_Reg,'" + System.DateTime.Now.Date.AddDays(0 - System.DateTime.Now.Day + 1).ToString("yyyy-MM-dd") + "')<=0 and datediff(d,Time_Reg,'" + System.DateTime.Now + "')>=0)"); int UserCountday = 0; UserCountday = B_Lebi_User.Counts("User_id_parent=" + user.id + " and (datediff(d,Time_Reg,'" + System.DateTime.Now.Date.ToString("yyyy-MM-dd") + "')<=0 and datediff(d,Time_Reg,'" + System.DateTime.Now + "')>=0)"); decimal Commission1 = 0; decimal Commission2 = 0; decimal Commission3 = 0; decimal.TryParse(bc.Angent1_Commission, out Commission1); decimal.TryParse(bc.Angent2_Commission, out Commission2); decimal.TryParse(bc.Angent3_Commission, out Commission3); if (user.DT_id == 0) { Lebi_Agent_UserLevel agent_userlevel = B_Lebi_Agent_UserLevel.GetModel("UserLevel_id = " + user.UserLevel_id + ""); if (agent_userlevel != null) { if (agent_userlevel.Angent1_Commission != -1) { Commission1 = agent_userlevel.Angent1_Commission; } if (agent_userlevel.Angent2_Commission != -1) { Commission2 = agent_userlevel.Angent2_Commission; } if (agent_userlevel.Angent3_Commission != -3) { Commission3 = agent_userlevel.Angent3_Commission; } } Lebi_Agent_User agent_user = B_Lebi_Agent_User.GetModel("User_id = " + user.id + ""); if (agent_user != null) { if (agent_user.Angent1_Commission != -1) { Commission1 = agent_user.Angent1_Commission; } if (agent_user.Angent2_Commission != -1) { Commission2 = agent_user.Angent2_Commission; } if (agent_user.Angent3_Commission != -1) { Commission3 = agent_user.Angent3_Commission; } } } else { Lebi_DT_Agent dt_agent = B_Lebi_DT_Agent.GetModel("DT_id = " + user.DT_id + ""); if (dt_agent != null) { if (dt_agent.IsUsedAgent == 1) { Commission1 = dt_agent.Angent1_Commission; Commission2 = dt_agent.Angent2_Commission; Commission3 = dt_agent.Angent3_Commission; } } } m.Money = Money; m.UserCount = UserCount; m.UserCountmonth = UserCountmonth; m.UserCountday = UserCountday; m.Commission1 = Commission1; m.Commission2 = Commission2; m.Commission3 = Commission3; Lebi_UserLevel userlevel = B_Lebi_UserLevel.GetModel(user.UserLevel_id); if (userlevel != null) { if (userlevel.IsUsedAgent == 0) //关闭注册 { m.Commission1 = 0; m.Commission2 = 0; m.Commission3 = 0; } } return(m); }
public static string ReplaceSMSTag(string instr, Lebi_User user, BaseConfig conf) { string language = Language.DefaultLanguage().Code; instr = instr.Replace("{$Domain}", conf.Domain); instr = instr.Replace("{$Time}", DateTime.Now.ToString()); if (user != null) { instr = instr.Replace("{$UserName}", user.UserName); instr = instr.Replace("{$RealName}", user.RealName); instr = instr.Replace("{$UserID}", user.id.ToString()); instr = instr.Replace("{$UserNumber}", user.UserNumber); instr = instr.Replace("{$NickName}", user.NickName); language = user.Language; if (language == "") { user.Language = "CN"; } } else { user = new Lebi_User(); user.Language = "CN"; } string Phone = ""; string Email = ""; string QQ = ""; string Fax = ""; string Name = ""; string Domain = ""; Lebi_Site site = B_Lebi_Site.GetModel(user.Site_id); if (site == null) { site = B_Lebi_Site.GetList("", "Sort desc").FirstOrDefault(); Phone = Language.Content(site.Phone, user.Language); Email = Language.Content(site.Email, user.Language); QQ = Language.Content(site.QQ, user.Language); Fax = Language.Content(site.Fax, user.Language); Name = Language.Content(site.Name, user.Language); Domain = Language.Content(site.Domain, user.Language); } else { Phone = Language.Content(site.Phone, user.Language); Email = Language.Content(site.Email, user.Language); QQ = Language.Content(site.QQ, user.Language); Fax = Language.Content(site.Fax, user.Language); Name = Language.Content(site.Name, user.Language); Domain = Language.Content(site.Domain, user.Language); Lebi_Site mainsite = B_Lebi_Site.GetList("", "Sort desc").FirstOrDefault(); if (Phone == "") { Phone = Language.Content(mainsite.Phone, user.Language); } if (Email == "") { Email = Language.Content(mainsite.Email, user.Language); } if (QQ == "") { QQ = Language.Content(mainsite.QQ, user.Language); } if (Fax == "") { Fax = Language.Content(mainsite.Fax, user.Language); } if (Name == "") { Name = Language.Content(mainsite.Name, user.Language); } if (Domain == "") { Domain = Language.Content(mainsite.Domain, user.Language); } } instr = instr.Replace("{$UserName}", user.UserName); instr = instr.Replace("{$UserID}", user.id.ToString()); //instr = instr.Replace("{$Phone}", Language.Content(conf.Phone, user.Language)); //instr = instr.Replace("{$Email}", Language.Content(conf.Email, user.Language)); //instr = instr.Replace("{$QQ}", Language.Content(conf.QQ, user.Language)); //instr = instr.Replace("{$Fax}", Language.Content(conf.Fax, user.Language)); //instr = instr.Replace("{$SiteName}", Language.Content(conf.Name, user.Language)); //instr = instr.Replace("{$Domain}", conf.Domain); instr = instr.Replace("{$Phone}", Phone); instr = instr.Replace("{$Email}", Email); instr = instr.Replace("{$QQ}", QQ); instr = instr.Replace("{$Fax}", Fax); instr = instr.Replace("{$SiteName}", Name); instr = instr.Replace("{$Domain}", Domain); return(instr); }
/// <summary> /// 订单提交 /// </summary> /// <param name="user"></param> /// <param name="order"></param> public static void SendSMS_ordersubmit(Lebi_User user, Lebi_Order order) { BaseConfig conf = ShopCache.GetBaseConfig(); int IsUserSms = 0; int IsUserSms2 = 0; int IsAdminSms = 0; int IsSupplierSms = 0; if (conf.SMS_sendmode.Contains("SMSTPL_ordersubmit")) { IsUserSms = 1; } if (conf.SMS_sendmode.Contains("SMSTPL_Admin_ordersubmit")) { IsAdminSms = 1; } if (conf.SMS_sendmode.Contains("SMSTPL_orderpickup")) { IsUserSms2 = 1; } if (order.Supplier_id > 0) { if (ShopCache.GetBaseConfig_Supplier(order.Supplier_id).SMS_sendmode.Contains("SMSTPL_Admin_ordersubmit")) { IsSupplierSms = 1; } } if (IsUserSms == 0 && IsUserSms2 == 0 && IsAdminSms == 0 && IsSupplierSms == 0) { return; } if (user.Language == "") { user.Language = Language.Languages().FirstOrDefault().Code; } string list = ""; List <Lebi_Order_Product> pros = B_Lebi_Order_Product.GetList("Order_id=" + order.id + "", ""); foreach (Lebi_Order_Product pro in pros) { list += "" + Language.Tag("商品编号", user.Language) + ":" + pro.Product_Number + ";" + Language.Tag("商品", user.Language) + ":" + Language.Content(pro.Product_Name, user.Language) + ";" + Language.Tag("数量", user.Language) + ":" + pro.Count + ";"; } if (IsUserSms == 1) { string content = Language.Content(conf.SMSTPL_ordersubmit, user.Language); content = ReplaceSMSTag(content, user, conf); content = content.Replace("{$OrderNO}", order.Code); content = content.Replace("{$Money}", Language.FormatMoney(order.Money_Order, order.Currency_Code)); content = content.Replace("{$Order}", list); Send(order.T_MobilePhone, content); } if (IsAdminSms == 1 || IsSupplierSms == 1) { string Admin_content = Language.Content(conf.SMSTPL_Admin_ordersubmit, user.Language); Admin_content = ReplaceSMSTag(Admin_content, user, conf); Admin_content = Admin_content.Replace("{$OrderNO}", order.Code); Admin_content = Admin_content.Replace("{$Money}", Language.FormatMoney(order.Money_Order, order.Currency_Code)); Admin_content = Admin_content.Replace("{$Order}", list); string transport = "order.Transport_Name"; if (order.PickUp_Name != "") { transport += "|" + order.PickUp_Name + "|" + order.PickUp_Date.ToString("yyyy-MM-dd"); } Admin_content = Admin_content.Replace("{$Transport}", transport); if (IsAdminSms == 1) { Send(conf.SMS_reciveno, Admin_content); } if (IsSupplierSms == 1) { BaseConfig_Supplier config_supplier = ShopCache.GetBaseConfig_Supplier(order.Supplier_id); Send(config_supplier.SMS_reciveno, Admin_content); } } if (IsUserSms2 == 1) { string content = Language.Content(conf.SMSTPL_orderpickup, user.Language); content = ReplaceSMSTag(content, user, conf); content = content.Replace("{$OrderNO}", order.Code); content = content.Replace("{$Money}", Language.FormatMoney(order.Money_Order, order.Currency_Code)); content = content.Replace("{$Order}", list); content = content.Replace("{$PickUpStation}", order.PickUp_Name); content = content.Replace("{$PickUpTime}", order.PickUp_Date.ToString("yyyy-MM-dd")); Send(order.T_MobilePhone, content); } }
/// <summary> /// 推广佣金 /// </summary> private void AgentMoney() { //SystemLog.Add("计算佣金orderid" + Order.id + "userid" + OrderUser.User_id_parent); SystemLog.Add("推广佣金-开始"); if (OrderUser.User_id_parent == 0) { return; } //string Money_Product_Profit_ = Common.GetValue("select sum((Price - Price_Cost)*(Count-Count_Return)) from Lebi_Order_Product where Order_id = " + Order.id + ""); string Money_Product_Profit_ = Common.GetValue("select sum((Price - Price_Cost)*Count) from Lebi_Order_Product where Order_id = " + Order.id + ""); decimal Money_Product_Profit = 0; decimal.TryParse(Money_Product_Profit_, out Money_Product_Profit); if (Order.Type_id_OrderType == 212) { Money_Product_Profit = 0 - Money_Product_Profit;//zhangshijia 退货时产生负数佣金 } //处理一级代理 Lebi_User user1 = B_Lebi_User.GetModel(OrderUser.User_id_parent); if (user1 == null) { return; } decimal yongjin1 = 0; //1级佣金比例 decimal yongjin2 = 0; //2级佣金比例 decimal yongjin3 = 0; //3级佣金比例 Lebi_DT_Agent dt_agent = B_Lebi_DT_Agent.GetModel(0); Lebi_User DT_User = new Lebi_User(); Lebi_DT dt = new Lebi_DT(); int CommissionLevel = 3; if (Order.Supplier_id > 0) { Lebi_Supplier supplier = B_Lebi_Supplier.GetModel(Order.Supplier_id); if (supplier.IsSpread == 0) //商家未开启 { SystemLog.Add("推广佣金-商家未开启"); return; } } if (Order.DT_id > 0) { Money_Product_Profit = Order.DT_Money; //如果是分销商,利润为分销商佣金 dt_agent = B_Lebi_DT_Agent.GetModel("DT_id=" + Order.DT_id + ""); dt = B_Lebi_DT.GetModel(Order.DT_id); if (dt != null) { CommissionLevel = dt.CommissionLevel; } DT_User = B_Lebi_User.GetModel(dt.User_id); if (dt_agent.IsUsedAgent == 0) //分销商未开启 { SystemLog.Add("推广佣金-分销商未开启"); return; } // Money_Product_Profit = Order.DT_Money; ///zhangshijia注释,未找到DT_Money来源 //List<Lebi_Order_Product> order_pro = B_Lebi_Order_Product.GetModel(" Order_id = " + Order.id + ""); //foreach (Lebi_Order_Product op in order_pro) //{ //} } yongjin1 = GetAngentCommission1(dt_agent, user1); decimal money = Money_Product_Profit * yongjin1 / 100; if (Order.DT_id > 0) { if (DT_User.Money < money) { SystemLog.Add("推广佣金-分销商[" + DT_User.NickName + "-" + DT_User.id + "]金额不足,一级佣金生成失败"); return; } } AddMoney(money, user1, 391, 0, 0, 0); //SystemLog.Add("计算佣金" + user1.UserName + money.ToString()); if (Order.DT_id > 0) { AddMoney(0 - money, DT_User, 391, 0, 0, 0); } //处理2级代理 Lebi_User user2 = B_Lebi_User.GetModel(user1.User_id_parent); if (user2 == null) { user2 = new Lebi_User(); } else { if (CommissionLevel >= 2) { yongjin2 = GetAngentCommission2(dt_agent, user2); money = Money_Product_Profit * yongjin2 / 100; if (Order.DT_id > 0) { if (DT_User.Money < money) { SystemLog.Add("推广佣金-分销商金额不足,二级佣金生成失败"); return; } } AddMoney(money, user2, 391, 0, 0, 0); if (Order.DT_id > 0) { AddMoney(0 - money, DT_User, 391, 0, 0, 0); } } } //处理3级代理 if (CommissionLevel == 2) { return; } Lebi_User user3 = B_Lebi_User.GetModel(user2.User_id_parent); if (user3 != null) { yongjin3 = GetAngentCommission3(dt_agent, user3); money = Money_Product_Profit * yongjin3 / 100; if (Order.DT_id > 0) { if (DT_User.Money < money) { SystemLog.Add("推广佣金-分销商金额不足,三级佣金生成失败"); return; } } AddMoney(money, user3, 391, 0, 0, 0); if (Order.DT_id > 0) { AddMoney(0 - money, DT_User, 391, 0, 0, 0); } } ////处理条件佣金,佣金历史达到X时,可获得下线,下下线Y%的佣金 //decimal Angent_Commission_require = 0; //decimal.TryParse(bc.Angent_Commission_require, out Angent_Commission_require); //decimal yongjin3 = 0;//条件佣金比例 //decimal.TryParse(bc.Angent_Commission, out yongjin3); //money = Money_Product_Profit * yongjin3 / 100; //if (user1.AgentMoney_history > Angent_Commission_require) // AddMoney(money, user1, 395, 0, 0, 0); //if (user2.AgentMoney_history > Angent_Commission_require) // AddMoney(money, user2, 395, 0, 0, 0); }
public static void Add(string content, Lebi_User user) { Add(content, user, null, null); }
public static void Add(string content, string tablename, string keyid, Lebi_User user, string description) { Add(content, tablename, keyid, user, null, null, description); }
public static void Add(string content, string tablename, string keyid, Lebi_User user) { Add(content, tablename, keyid, user, null, null, ""); }
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("授权失败"); }
protected void Page_Load(object sender, EventArgs e) { if (!EX_Admin.Power("message_list", "站内信列表")) { PageReturnMsg = PageNoPowerMsg(); } lang = RequestTool.RequestString("lang"); key = RequestTool.RequestString("key"); type = RequestTool.RequestString("type"); if (string.IsNullOrEmpty(type)) { type = "0"; } type_id = RequestTool.RequestString("type_id"); dateFrom = RequestTool.RequestString("dateFrom"); dateTo = RequestTool.RequestString("dateTo"); user_id = RequestTool.RequestInt("user_id", 0); if (user_id > 0) { modeluser = B_Lebi_User.GetModel(user_id); if (modeluser == null) { UserName = ""; } else { UserName = modeluser.UserName; } } DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); string where = "Supplier_id = 0"; if (key != "") { where += " and (Title like lbsql{'%" + key + "%'} or User_Name_To like lbsql{'%" + key + "%'} or User_Name_From like lbsql{'%" + key + "%'})"; } if (user_id > 0) { where += " and (User_id_To = " + user_id + " or User_id_From = " + user_id + ")"; } if (lang != "") { where += " and Language = lbsql{'" + lang + "'}"; } if (type == "0") { where += " and User_id_To =0"; } if (type == "1") { where += " and User_id_From =0"; } if (type_id != "") { where += " and Message_Type_id = " + type_id; } if (dateFrom != "" && dateTo != "") { where += " and Time_Add>='" + FormatDate(lbsql_dateFrom) + "' and Time_Add<='" + FormatDate(lbsql_dateTo) + " 23:59:59'"; } models = B_Lebi_Message.GetList(where, "Time_Add desc", PageSize, page); int recordCount = B_Lebi_Message.Counts(where); PageString = Pager.GetPaginationString("?page={0}&user_id=" + user_id + "&type=" + type + "&lang=" + lang + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&type_id=" + type_id + "&key=" + key, page, PageSize, recordCount); }
/// <summary> /// 忘记密码的处理 /// </summary> public void User_forgetpwd() { int type = RequestTool.RequestInt("type", 0); string Email_ = RequestTool.RequestSafeString("Email"); string UserName = RequestTool.RequestSafeString("UserName"); string verifycode = RequestTool.RequestString("verifycode"); if (SYS.Verifycode_ForgetPassword == "1") { if (CurrentCheckCode != verifycode) { Response.Write("{\"msg\":\"" + Tag("验证码错误") + "\"}"); return; } } if (type == 0) { //发送邮件 Lebi_User user = B_Lebi_User.GetModel("Email=lbsql{'" + Email_ + "'}"); if (user == null) { Response.Write("{\"msg\":\"" + Tag("用户不存在") + "\"}"); return; } try { //发送邮件 Email.SendEmail_forgetpwd(user, CurrentTheme); //发送短信 SMS.SendSMS_forgetpwd(user); } catch (Exception ex) { Response.Write("{\"msg\":\"" + ex.Message + "\"}"); } Response.Write("{\"msg\":\"OK\"}"); } else if (type == 1) { Lebi_User user = B_Lebi_User.GetModel("UserName=lbsql{'" + UserName + "'}"); if (user == null) { Response.Write("{\"msg\":\"" + Tag("用户不存在") + "\"}"); return; } Lebi_User_Answer user_answer = B_Lebi_User_Answer.GetModel("User_id= " + user.id); if (user_answer == null) { Response.Write("{\"msg\":\"" + Tag("未设置安全问题") + "\"}"); return; } BaseConfig conf = ShopCache.GetBaseConfig(); user.CheckCode = EX_User.MD5(System.DateTime.Now.ToString() + conf.InstallCode); B_Lebi_User.Update(user); Response.Write("{\"msg\":\"OK\",\"url\":\"" + ThemeUrl.GetURL("P_FindPassword", "", "", user.Language) + "?id=" + user.id + "&v=" + user.CheckCode + "&type=1\"}"); } else if (type == 2) { Lebi_User user = B_Lebi_User.GetModel("UserName=lbsql{'" + UserName + "'}"); if (user == null) { Response.Write("{\"msg\":\"" + Tag("用户不存在") + "\"}"); return; } if (user.MobilePhone == "") { Response.Write("{\"msg\":\"" + Tag("未设置手机号码") + "\"}"); return; } Random Random = new Random(); int RandNum = Random.Next(100000, 999999); user.Password = EX_User.MD5(RandNum.ToString()); B_Lebi_User.Update(user); //发送短信 SMS.SendSMS_newpwd(user, RandNum.ToString()); Response.Write("{\"msg\":\"OK\",\"url\":\"" + ThemeUrl.GetURL("P_Login", "", "", user.Language) + "\"}"); } }
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("授权失败"); }
/// <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()); } }
protected void Page_Load(object sender, EventArgs e) { int order_id = RequestTool.RequestInt("order_id", 0); order = B_Lebi_Order.GetModel(order_id); if (order == null) { Response.Write("ERROR"); Response.End(); return; } Lebi_Language language = B_Lebi_Language.GetModel(order.Language_id); if (order.IsPaid == 1) { Response.Write(Language.Tag("已付款", language.Code)); Response.End(); return; } order.Site_id_pay = CurrentSite.id; order.Language_id = CurrentLanguage.id; Lebi_OnlinePay pay = Shop.Bussiness.Money.GetOnlinePay(order, "weixinpayh5"); if (pay == null) { Log.Add("在线支付接口 weixinpay 配置错误"); return; } Lebi_Currency currendy = B_Lebi_Currency.GetModel(pay.Currency_id); if (pay.FreeFeeRate == 1) { pay.FeeRate = 0; } if (pay.FeeRate > 0) { order.Money_OnlinepayFee = order.Money_Pay * pay.FeeRate / 100; } if (order.OnlinePay_id != pay.id) { order.OnlinePay_id = pay.id; order.OnlinePay_Code = pay.Code; order.OnlinePay = pay.Name; } B_Lebi_Order.Update(order); Lebi_User user = B_Lebi_User.GetModel(order.User_id); if (user == null) { Response.Write("订单错误"); Response.End(); return; } returnurl = URL("P_UserOrderDetails", order.id); TenpayUtil tu = new TenpayUtil(order); appId = tu.appid; timeStamp = TenpayUtil.getTimestamp(); nonceStr = TenpayUtil.getNoncestr(); string order_price = (order.Money_Pay * currendy.ExchangeRate * 100 * (1 + (pay.FeeRate / 100))).ToString("0"); string sp_billno = order.Code + "|" + TenpayUtil.UnixStamp(); shopname = Lang(CurrentSite.Name); string prepayId = order.weixin_prepay_id; //if (prepayId == "" || prepayId == "INVALID_REQUEST") //{ //创建支付应答对象 RequestHandler packageReqHandler = new RequestHandler(Context); //初始化 packageReqHandler.init(); //设置package订单参数 packageReqHandler.setParameter("body", order.Code); //商品信息 127字符 packageReqHandler.setParameter("appid", tu.appid); packageReqHandler.setParameter("mch_id", tu.mch_id); packageReqHandler.setParameter("nonce_str", nonceStr); packageReqHandler.setParameter("openid", user.bind_weixin_id); packageReqHandler.setParameter("out_trade_no", sp_billno); //商家订单号 packageReqHandler.setParameter("spbill_create_ip", RequestTool.GetClientIP()); //Page.Request.UserHostAddress); //用户的公网ip,不是商户服务器IP packageReqHandler.setParameter("total_fee", order_price); //商品金额,以分为单位(money * 100).ToString() packageReqHandler.setParameter("trade_type", "MWEB"); //packageReqHandler.setParameter("notify_url", HttpUtility.UrlEncode(tu.tenpay_notify)); packageReqHandler.setParameter("notify_url", tu.tenpay_notify); //Response.Write("body:" + order.Code + ",appid:" + tu.appid + ",mch_id:" + tu.mch_id + ",nonce_str:" + nonceStr + ",notify_url:" + HttpUtility.UrlEncode(tu.tenpay_notify) + ",openid:" + user.bind_weixin_id + ",out_trade_no:" + sp_billno + ",spbill_create_ip:" + RequestTool.GetClientIP() + ",total_fee:" + order_price + ",key:" + tu.key + ""); string sign = packageReqHandler.createMd5Sign("key", tu.key); packageReqHandler.setParameter("sign", sign); string data = packageReqHandler.parseXML(); string prepayXml = HttpUtil.Send(data, "https://api.mch.weixin.qq.com/pay/unifiedorder"); SystemLog.Add("prepayXml:" + prepayXml); Response.Write("prepayXml:" + prepayXml); //return; //获取预支付ID var xdoc = new XmlDocument(); xdoc.LoadXml(prepayXml); XmlNode xn = xdoc.SelectSingleNode("xml"); XmlNodeList xnl = xn.ChildNodes; //Response.Write("<br/>xml:" + xnl[0].InnerText + "|" + xnl[1].InnerText + "|" + xnl[2].InnerText + "|" + xnl[3].InnerText + "|" + xnl[4].InnerText + "|" + xnl[5].InnerText + "|" + xnl[6].InnerText + "|" + xnl[7].InnerText + "|" + xnl[8].InnerText + ""); if (xnl.Count > 7) { prepayId = xnl[7].InnerText; order.weixin_prepay_id = prepayId; B_Lebi_Order.Update(order); } if (xnl.Count > 9) { string url = xnl[9].InnerText; Response.Redirect(url); } //} }
/// <summary> /// 编辑会员积分 /// </summary> public void UserPoint_Edit() { int id = RequestTool.RequestInt("id", 0); SearchUser su = new SearchUser(CurrentAdmin, CurrentLanguage.Code); if (id > 0) { if (!EX_Admin.Power("user_point_edit", "编辑会员积分")) { AjaxNoPower(); return; } Lebi_User_Point model = B_Lebi_User_Point.GetModel(id); Lebi_User user = B_Lebi_User.GetModel(model.User_id); Log.Add("编辑会员积分", "User_Point", id.ToString(), CurrentAdmin, user.UserName); if (user == null) { Response.Write("{\"msg\":\"" + Tag("会员账号不存在") + "\"}"); return; } model.Point = RequestTool.RequestDecimal("Point", 0); model.Type_id_PointStatus = RequestTool.RequestInt("Type_id_PointStatus", 0); model.Admin_UserName = CurrentAdmin.UserName; model.Admin_id = CurrentAdmin.id; model.Remark = RequestTool.RequestString("Remark"); model.Time_Update = DateTime.Now; B_Lebi_User_Point.Update(model); Point.UpdateUserPoint(user); } else { if (!EX_Admin.Power("user_point_add", "添加会员积分")) { AjaxNoPower(); return; } string Mode = RequestTool.RequestString("mode"); string User_Name_To = RequestTool.RequestString("User_Name_To"); string UserLevel_ids = RequestTool.RequestString("UserLevel_ids"); string User_ids = RequestTool.RequestString("User_ids"); string UserName_ids = RequestTool.RequestString("UserName_ids"); if (Mode == "user") { Lebi_User user = B_Lebi_User.GetModel("UserName = lbsql{'" + User_Name_To + "'}"); if (user == null) { Response.Write("{\"msg\":\"" + Tag("会员账号不存在") + "\"}"); return; } Log.Add("添加会员积分", "User_Point", id.ToString(), CurrentAdmin, User_Name_To + " ->" + RequestTool.RequestDecimal("Point", 0)); Point.AddPoint(user, RequestTool.RequestDecimal("Point", 0), RequestTool.RequestInt("Type_id_PointStatus", 0), CurrentAdmin, RequestTool.RequestSafeString("Remark")); } else { string where = ""; int i = 0; if (User_ids == "") { Response.Write("{\"msg\":\"" + Tag("没有选择任何数据") + "\"}"); return; where = "1=1 " + su.SQL; Log.Add("添加会员积分", "User_Point", "", CurrentAdmin, su.Description + " ->" + RequestTool.RequestDecimal("Point", 0)); } else { where = "id in (" + User_ids + ")"; Log.Add("添加会员积分", "User_Point", "", CurrentAdmin, UserName_ids + " ->" + RequestTool.RequestDecimal("Point", 0)); } List <Lebi_User> modellist = B_Lebi_User.GetList(where, ""); foreach (Lebi_User user in modellist) { Point.AddPoint(user, RequestTool.RequestDecimal("Point", 0), RequestTool.RequestInt("Type_id_PointStatus", 0), CurrentAdmin, RequestTool.RequestSafeString("Remark")); } } } string result = "{\"msg\":\"OK\"}"; Response.Write(result); }
protected void Page_Load(object sender, EventArgs e) { if (!Power("supplier_message", "站内信")) { PageReturnMsg = PageNoPowerMsg(); } PageSize = 20; lang = RequestTool.RequestString("lang"); key = RequestTool.RequestString("key"); type = RequestTool.RequestString("type"); type_id = RequestTool.RequestString("type_id"); dateFrom = RequestTool.RequestString("dateFrom"); dateTo = RequestTool.RequestString("dateTo"); user_id = RequestTool.RequestInt("user_id", 0); if (user_id > 0) { modeluser = B_Lebi_User.GetModel(user_id); if (modeluser == null) { UserName = ""; } else { UserName = modeluser.UserName; } } DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom"); DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo"); string where = "Supplier_id = " + CurrentSupplier.id + ""; if (key != "") { where += " and (Title like lbsql{'%" + key + "%'} or User_Name_To like lbsql{'%" + key + "%'} or User_Name_From like lbsql{'%" + key + "%'})"; } if (user_id > 0) { where += " and (User_id_To = " + user_id + " or User_id_From = " + user_id + ")"; } if (lang != "") { where += " and Language = lbsql{'" + lang + "'}"; } if (type == "1") { where += " and User_id_To =0"; } if (type == "0") { where += " and User_id_From =0"; } if (type_id != "") { where += " and Message_Type_id = " + type_id; } 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_Message.GetList(where, "Time_Add desc", PageSize, page); int recordCount = B_Lebi_Message.Counts(where); PageString = Shop.Bussiness.Pager.GetPaginationString("?page={0}&user_id=" + user_id + "&type=" + type + "&lang=" + lang + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "&type_id=" + type_id + "&key=" + key, page, PageSize, recordCount); }
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 + ""; //} 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_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> /// <param name="user"></param> /// <param name="money"></param> /// <param name="type"></param> /// <param name="admin"></param> /// <param name="description"></param> /// <param name="remark"></param> /// <param name="fanxian">是否包含返现款消费</param> public static void AddMoney(Lebi_User user, decimal money, int type, Lebi_Administrator admin, string description, string remark, bool fanxian = true) { AddMoney(user, money, type, null, admin, description, remark, fanxian); }
/// <summary> /// 返回用户商品List /// </summary> /// <param name="t"></param> /// <returns></returns> public static List <Lebi_User_Product> UserProduct(Lebi_User CurrentUser, int t) { return(EX_User.UserProduct(CurrentUser, t)); }
/// <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"); string res = ""; StringBuilder sb; if (code != "") { try { sb = new StringBuilder(); sb.Append("?grant_type=authorization_code"); sb.Append("&client_id=" + appid); sb.Append("&client_secret=" + appkey); sb.Append("&code=" + code); string uri = reurnurl + "?backurl=" + ENBackuri(back); uri = System.Web.HttpUtility.UrlEncode(uri); sb.Append("&redirect_uri=" + uri); res = PostAPI("oauth/access_token", sb.ToString()); res = res + "&"; string access_token = RegexTool.GetRegValue(res, "access_token=(.*?)&"); JavaScriptSerializer jss = new JavaScriptSerializer(); //获取uid sb = new StringBuilder(); sb.Append("?access_token=" + access_token); res = GetAPI("me", sb.ToString()); Model.Facebook.userinfo model = jss.Deserialize <Model.Facebook.userinfo>(res); string uid = model.id; //return uid; string where = "bind_facebook_id='" + uid + "'"; //if (DT_id > 0) //{ // where += " and DT_id =" + DT_id + ""; //} Shop.Model.Lebi_User user = B_Lebi_User.GetModel(where); Lebi_User CurrentUser = EX_User.CurrentUser(); if (model == null) { model = new Model.Facebook.userinfo(); } if (model.picture == null) { model.picture = new Model.Facebook.userinfo.picture_(); } if (model.picture.data == null) { model.picture.data = new Model.Facebook.userinfo.picture_.data_(); model.picture.data.url = ""; } string username = model.last_name + model.first_name; if (CurrentUser.id > 0)//已经登录 { if (IsLogin == 0) { if (user != null) { if (CurrentUser.id != user.id) { return("已绑定其它帐号"); } } } CurrentUser.bind_facebook_id = uid; CurrentUser.bind_facebook_nickname = username; CurrentUser.bind_facebook_token = access_token; if (CurrentUser.Face == "") { CurrentUser.Face = model.picture.data.url;//头像 } B_Lebi_User.Update(CurrentUser); } else { if (user == null) { Lebi_UserLevel defaultlevel = B_Lebi_UserLevel.GetModel("Grade>0 order by Grade asc"); if (defaultlevel == null) { defaultlevel = new Lebi_UserLevel(); } if (defaultlevel.RegisterType == 0) //关闭注册 { return("会员注册已关闭"); } user = new Lebi_User(); user.bind_facebook_id = uid; user.bind_facebook_nickname = username; user.bind_facebook_token = access_token; user.Face = model.picture.data.url; user.NickName = username; user.UserName = "******" + uid; user.Password = EX_User.MD5(uid); user.Language = Language.CurrentLanguage().Code; user.Sex = model.gender == "female" ? "女" : "男"; user.UserLevel_id = B_Lebi_UserLevel.GetList("Grade>0", "Grade asc").FirstOrDefault().id; user.IsPlatformAccount = 1; if (CurrentSite != null) { user.Site_id = CurrentSite.id; } B_Lebi_User.Add(user); user.id = B_Lebi_User.GetMaxId(); EX_User.LoginOK(user); } else { user.bind_facebook_id = uid; user.bind_facebook_nickname = username; user.bind_facebook_token = access_token; if (user.Face == "") { user.Face = model.picture.data.url; } //user.Sex = model.gender == "female" ? "女" : "男"; B_Lebi_User.Update(user); EX_User.LoginOK(user); } } return("OK"); } catch { return("授权失败"); } } return("授权失败"); }
public 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); } }
/// <summary> /// 编辑商家 /// </summary> public void User_Edit() { if (!EX_Admin.Power("supplier_user_edit", "编辑商家")) { AjaxNoPower(); return; } int id = RequestTool.RequestInt("id", 0); string UserName = RequestTool.RequestString("UserName"); int Level_id = RequestTool.RequestInt("Level_id", 0); int IsCash = RequestTool.RequestInt("IsCash", 0); int IsSupplierTransport = RequestTool.RequestInt("IsSupplierTransport", 0); Lebi_User user = new Lebi_User(); if (UserName != "") { user = B_Lebi_User.GetModel("UserName=lbsql{'" + UserName + "'}"); if (user == null) { Response.Write("{\"msg\":\"帐号不存在\"}"); return; } string where = "User_id='" + user.id + "'"; if (id > 0) { where += " and id!=" + id + ""; } int count = B_Lebi_Supplier.Counts(where); if (count > 0) { Response.Write("{\"msg\":\"此帐号已注册\"}"); return; } } if (IsCash == 1 && IsSupplierTransport == 0) { Response.Write("{\"msg\":\"独立收款的商家必须独立发货\"}"); return; } Lebi_Supplier model = B_Lebi_Supplier.GetModel(id); //model.IsCash = 0; //model.IsSupplierTransport = 0; if (model == null) { model = new Lebi_Supplier(); } B_Lebi_Supplier.SafeBindForm(model); model.Name = Language.RequestString("Name"); model.Description = Language.RequestString("Description"); model.ClassName = Language.RequestString("ClassName"); model.SEO_Title = Language.RequestString("SEO_Title"); model.SEO_Keywords = Language.RequestString("SEO_Keywords"); model.SEO_Description = Language.RequestString("SEO_Description"); model.Supplier_Group_id = Level_id; if (model.id == 0) { Lebi_Supplier_Group group = B_Lebi_Supplier_Group.GetModel(Level_id); if (group != null) { model.Supplier_Group_id = group.id; model.Money_Service = group.ServicePrice; model.Money_Margin = group.MarginPrice; model.BillingDays = group.BillingDays; } model.User_id = user.id; model.UserName = user.UserName; B_Lebi_Supplier.Add(model); model.id = B_Lebi_Supplier.GetMaxId(); } else { if (IsSupplierTransport != model.IsSupplierTransport) { string sql = "update [Lebi_Order_Product] set IsSupplierTransport=" + model.IsSupplierTransport + " where Supplier_id=" + id + ""; Common.ExecuteSql(sql); string sql2 = "update [Lebi_Product] set IsSupplierTransport=" + model.IsSupplierTransport + " where Supplier_id=" + id + ""; Common.ExecuteSql(sql2); } user = B_Lebi_User.GetModel(model.User_id); B_Lebi_Supplier.Update(model); } if (model.Type_id_SupplierStatus == 442) { try { Lebi_Supplier_User suser = B_Lebi_Supplier_User.GetModel("User_id=" + model.User_id + " and Supplier_id=" + model.id + ""); if (suser == null) { suser = new Lebi_Supplier_User(); suser.RemarkName = user.RealName; if (suser.RemarkName == "") { suser.RemarkName = user.UserName; } suser.Supplier_id = model.id; suser.User_id = model.User_id; suser.Type_id_SupplierUserStatus = 9011; B_Lebi_Supplier_User.Add(suser); } else { suser.Supplier_id = model.id; suser.User_id = model.User_id; suser.Type_id_SupplierUserStatus = 9011; B_Lebi_Supplier_User.Update(suser); } } catch { } } if (model.Domain != "") { ThemeUrl.CreateURLRewrite_shop(); } if (model.Type_id_SupplierStatus == 444) //如果状态冻结 商品全部冻结 by lebi.kingdge 2015-02-09 { string sql = "update [Lebi_Product] set Type_id_ProductStatus=103 where Supplier_id=" + id + ""; Common.ExecuteSql(sql); } Log.Add("编辑商家信息", "Supplier_User", id.ToString(), CurrentAdmin, model.UserName); string result = "{\"msg\":\"OK\", \"id\":\"" + model.id + "\"}"; Response.Write(result); }
/// <summary> /// 供应商登录 /// </summary> public void User_Login() { string msg = ""; string userName = RequestTool.RequestSafeString("userName"); string UserPWD = RequestTool.RequestSafeString("UserPWD"); string code = RequestTool.RequestString("code"); string logintype = RequestTool.RequestString("logintype", "supplier"); int saveusername = RequestTool.RequestInt("saveusername", 0); string loginerror = "false"; string Ststus = ""; if (SYS.Verifycode_SupplierLogin == "1") { try { loginerror = (string)HttpContext.Current.Session["loginerror"]; } catch { loginerror = "false"; } if (loginerror == "true") { if (CurrentCheckCode != code) { Response.Write(Language.Tag("验证码错误", CurrentLanguage.Code)); return; } } } //UserPWD = EX_Supplier.MD5(UserPWD); if (EX_User.UserLogin(userName, UserPWD)) { Lebi_User CurrentUser = B_Lebi_User.GetModel("UserName=lbsql{'" + userName + "'}"); if (EX_Supplier.Login(CurrentUser, logintype, 0, out msg)) { if (saveusername == 1) { Shop.Tools.CookieTool.SetCookieString("SupplierUserName", userName, 60 * 24); Shop.Tools.CookieTool.SetCookieString("saveusername", "1", 60 * 24); } else { Shop.Tools.CookieTool.SetCookieString("SupplierUserName", "", -1); Shop.Tools.CookieTool.SetCookieString("saveusername", "", -1); } Log.Add("登陆系统", "Login", CurrentUser.id.ToString(), CurrentUser.UserName); Response.Write("OK"); return; } else { Ststus = Language.Tag("未审核", CurrentLanguage.Code); Lebi_Supplier_User model_supplier_user = B_Lebi_Supplier_User.GetList("User_id = " + CurrentUser.id + "", "").FirstOrDefault(); if (model_supplier_user != null) { switch (model_supplier_user.Type_id_SupplierUserStatus) { case 9010: Ststus = Language.Tag("未审核", CurrentLanguage.Code); break; case 9012: Ststus = Language.Tag("已停用", CurrentLanguage.Code); break; } } msg = Language.Tag("账号状态异常:", CurrentLanguage.Code) + Ststus; } } else { msg = Language.Tag("用户名或密码错误", CurrentLanguage.Code); if (SYS.Verifycode_SupplierLogin == "1") { HttpContext.Current.Session["loginerror"] = "true"; } Log.Add("登陆系统", "Login", "", CurrentUser, "[" + userName + "]用户名或密码错误"); } Response.Write(msg); }