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("授权失败");
}
