/// <summary>
/// 添加收货地址
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult AddAddress(string jsonstr)
{
//将传过来的字符串转换为数组
string[] msg = jsonstr.Split(',');
//实例化一个新的购物车类
tbl_AddressInfo tbadd = new tbl_AddressInfo();
tbadd.address_name = msg[0];
tbadd.address_telephone = msg[1];
tbadd.address_detail = "重庆市重庆市沙坪坝区" + msg[2];
tbadd.userid = Convert.ToInt32(Session["userid"]);
tbadd.address_isDel = 0;
tbadd.address_isDefault = 0;
//使用EF
SportsDBEntities sde = new SportsDBEntities();
//添加
sde.Entry(tbadd).State = System.Data.EntityState.Added;
int count = sde.SaveChanges();
Response.Write(count);
Response.End();
return(View());
}
/// <summary>
/// 修改个人信息
/// </summary>
/// <param name="userdt"></param>
/// <returns></returns>
public ActionResult UpdataPersonal(string jsonstrt)
{
//获取登陆用户的id
int id = Convert.ToInt32(Session["userid"]);
//分割字符串
string[] strarr = jsonstrt.Split(',');
//创建数据库对象
SportsDBEntities sde = new SportsDBEntities();
//进行修改
UserInfo_detail tblist = sde.UserInfo_detail.Where(a => a.userid == id).FirstOrDefault();
tblist.username = strarr[0];
tblist.user_nickname = strarr[1];
tblist.user_sex = strarr[2];
tblist.user_idcard = strarr[3];
tblist.user_email = strarr[4];
tblist.user_telphone = strarr[5];
//保存修改数据
//UserInfo_detail ud = sde.UserInfo_detail.Add(tblist);
int count = sde.SaveChanges();
Response.Write(count);
Response.End();
return(RedirectToAction("Information"));
}
/// <summary>
/// 我的收货地址
/// </summary>
/// <returns></returns>
public ActionResult Address()
{
//使用EF
SportsDBEntities sde = new SportsDBEntities();
//通过session取出用户id
int userId = Convert.ToInt32(Session["userid"]);
//通过id查询用户地址
List <tbl_AddressInfo> talist = sde.tbl_AddressInfo.Where(a => a.userid == userId).ToList();
//查询所有省份
List <tbl_province> tplist = sde.tbl_province.ToList();
ViewData["tplist"] = tplist;
//根据省市的id查询所有城市
List <tbl_city> cplist = sde.tbl_city.Where(a => a.pro_id == 4).ToList();
ViewData["cplist"] = cplist;
//根据城市的id查询所有城镇
List <tbl_county> coplist = sde.tbl_county.Where(a => a.city_id == 2).ToList();
ViewData["coplist"] = coplist;
return(View(talist));
}
/// <summary>
/// 购物车结算跳转到确认订单页面
/// </summary>
/// <param name="id"></param>
/// <param name="num"></param>
/// <returns></returns>
public JsonResult ShoPay(string id, string num)
{
//将传送过来的只转换为数组
string[] shopid = id.Split(',');
string[] shopnum = num.Split(',');
SportsDBEntities sde = new SportsDBEntities();
//保存对象的内容
List <ShopManagement> slist = new List <ShopManagement>();
//进行每一个的修改
for (int i = 0; i < shopid.Length - 1; i++)
{
int cartId = Convert.ToInt32(shopid[i]);
ShopManagement s = sde.ShopManagement.Where(a => a.cart_id == cartId).FirstOrDefault();
//添加数据到订单
add_deil(s, cartId);
s.cart_quantity = Convert.ToInt32(shopnum[i]); //修改
sde.SaveChanges(); //执行数据库修改
slist.Add(s);
}
//用户编号
int uid = Convert.ToInt32(Session["uid"]);
//查询用户的默认地址
List <tbl_AddressInfo> tbladdrss = sde.tbl_AddressInfo.Where(a => a.userid == uid).ToList();
Session["Address"] = tbladdrss; //收货地址
Session["slist"] = slist; //物品信息
return(Json(1));
}
/// <summary>
/// 查询用户详情
/// </summary>
/// <returns></returns>
public JsonResult Log()
{
if (Session["name"] == null)
{
return(Json(0));
}
else
{
//获取用户id
int uid = Convert.ToInt32(Session["uid"]);
SportsDBEntities sde = new SportsDBEntities();
//查询详细
UserInfo_detail ud = sde.UserInfo_detail.Where(a => a.detailId == uid).FirstOrDefault();
//存储详细信息
Session["detail"] = ud;
if (ud != null)
{
return(Json(1));
}
else
{
return(Json(123456789));
}
}
}
/// <summary>
/// 忘记密码
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public JsonResult update_Login(string user)
{
string[] u = user.Split(',');
//获取用户帐号
string username = u[0];
//电话号码
string phone = u[1];
//验证码
string yzm = u[2];
//新密码
string password = u[3];
//判断输入的是否为空字符串
if (string.IsNullOrEmpty(username) && string.IsNullOrEmpty(password))
{
Response.Write("用户名或密码不能为空或空的字符串");
Response.End();
}
//验证码
else if (yzm != Session["yzm"].ToString())
{
Response.Write("验证码错误！");
Response.End();
}
else
{
SportsDBEntities sde = new SportsDBEntities();
//查询该帐号是否存在
UserInfo count = sde.UserInfo.Where(a => a.name == username).FirstOrDefault();
//用户id
int id = count.userid;
//查询该帐号id的详细信息
var udcount = sde.UserInfo_detail.Where(a => a.userid == id).ToList();
if (string.IsNullOrEmpty(udcount[0].user_telphone))
{
Response.Write("手机号与帐号个人信息不符，修改失败！");
Response.End();
}
else
{
count.user_password = password;
if (sde.SaveChanges() > 0)
{
return(Json(1));
}
}
}
return(Json(-1));
}
/// <summary>
/// 删除收货地址
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public JsonResult DeleteAddress(int Id)
{
//使用EF
SportsDBEntities sde = new SportsDBEntities();
//删除收货地址
int i = sde.Database.ExecuteSqlCommand("delete from tbl_AddressInfo where address_Id={0}", Id);
return(Json(i));
}
/// <summary>
/// 移除购物车单个商品
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public JsonResult DeleteCart(int id)
{
//使用EF
SportsDBEntities sde = new SportsDBEntities();
//删除购物车
int i = sde.Database.ExecuteSqlCommand("delete from ShopManagement where cart_id={0}", id);
return(Json(i));
}
/// <summary>
/// 将物品添加到购物车中
/// </summary>
/// <param name="GoodsMsg"></param>
/// <returns></returns>
public ActionResult GoodsShop(string GoodsMsg)
{
//将传过来的字符串转换为数组
string[] msg = GoodsMsg.Split(',');
if (Session["name"] == null)
{
Response.Write(99);
Response.End();
return(View());
}
SportsDBEntities sde = new SportsDBEntities(); //使用EF
int uid = Convert.ToInt32(Session["uid"]); //用户编号
int gid = Convert.ToInt32(msg[0]); //商品编号
string CodeNumber = msg[4]; //尺寸
string color = msg[3]; //颜色
int sid = Convert.ToInt32(msg[7]); //商店id
ShopManagement smm = sde.ShopManagement.Where(a => a.userid == uid && a.GoodsInfo_ID == gid && a.StoreInfo_ID == sid && a.cart_color == color && a.cart_CodeNumber == CodeNumber).FirstOrDefault();
if (smm != null)
{
int num = Convert.ToInt32(msg[6]); //数量
smm.cart_quantity = num + smm.cart_quantity; //修改数量
int count = sde.SaveChanges(); //执行数据库的修改
Response.Write(count);
Response.End();
return(View());
}
else
{
//实例化一个新的购物车类
ShopManagement sm = new ShopManagement();
sm.cart_addtime = DateTime.Now;
sm.GoodsInfo_ID = Convert.ToInt32(msg[0]);
sm.cart_remark = msg[1];
sm.cart_photo = msg[2];
sm.cart_color = msg[3];
sm.cart_CodeNumber = msg[4];
sm.userid = Convert.ToInt32(Session["uid"]);
sm.StoreInfo_ID = Convert.ToInt32(msg[7]);
sm.cart_price = Convert.ToDecimal(msg[5]);
sm.cart_quantity = Convert.ToInt32(msg[6]);
//添加
sde.Entry(sm).State = System.Data.EntityState.Added;
int count = sde.SaveChanges();
Response.Write(count);
Response.End();
return(View());
}
}
/// <summary>
/// 购物车结算加入待付款
/// </summary>
/// <param name="s"></param>
/// <param name="num"></param>
public void add_deil(ShopManagement s, int num)
{
SportsDBEntities sde = new SportsDBEntities();
//生成不重复的订单编号
string str = Guid.NewGuid().ToString().Replace("-", "");
//总价
decimal?money = num * s.cart_price;
//用户编号
int uid = Convert.ToInt32(Session["uid"]);
//添加订单表
OrderBySeller obs = new OrderBySeller();
obs.order_createTime = DateTime.Now;
obs.order_status = 1;
obs.orderdetails_status = -1;
obs.order_cost = money;
obs.userid = uid;
obs.GoodsInfo_ID = s.GoodsInfo_ID;
obs.order_no = str;
obs.order_paytime = DateTime.Now;
sde.Entry(obs).State = System.Data.EntityState.Added;//执行添加操作
sde.SaveChanges();
//查询当前的订单编号
OrderBySeller os = sde.OrderBySeller.Where(a => a.order_no == str).FirstOrDefault();
//当前订单编号
int orderId = Convert.ToInt32(os.order_id);
//添加订单详情表
tbl_orderdetailsInfo tod = new tbl_orderdetailsInfo();
tod.orderdetails_totalprice = money;
tod.orderdetails_quantity = num;
tod.cart_color = s.cart_color;
tod.cart_CodeNumber = s.cart_CodeNumber;
tod.cart_photo = s.cart_photo;
tod.cart_remark = s.cart_remark;
tod.orderdetails_unitprice = s.cart_price;
tod.GoodsInfo_id = s.GoodsInfo_ID;
tod.order_id = orderId;
tod.orderdetails_price = money;
tod.StoreInfo_ID = s.StoreInfo_ID;
tod.UserInfo_id = uid;
//添加操作
sde.Entry(tod).State = System.Data.EntityState.Added;
//数据库执行操作返回状态
sde.SaveChanges();
}
/// <summary>
/// 邮箱注册
/// </summary>
/// <returns></returns>
public JsonResult CostomersUserEmail_Register(string user)
{
string[] us = user.Split(','); //将获取到的string 转换为数组
string Email = us[0]; //帐号
string password = us[1]; //密码
if (!string.IsNullOrEmpty(user))
{
SportsDBEntities sde = new SportsDBEntities();
if (!Email.Contains("@") && Email.LastIndexOf('@') < 3)
{
Response.Write("格式不正确!必须存在@");
Response.End();
}
else if (Email.Length < 7 && Email.Length > 17)
{
Response.Write("格式不正确!帐号位数7-17位之间");
Response.End();
}
else
{
//查询是否已经存在当前帐号
var count = sde.UserInfo.Where(a => a.name == Email).ToList();
if (count.Count > 0)
{
Response.Write("用户名已注册!");
Response.End();
}
else
{
UserInfo u = new UserInfo();
u.name = Email;
u.user_password = password;
u.user_createTime = DateTime.Now;
u.user_status = 0;
u.store_id = 0;
//执行添加操作
sde.Entry(u).State = System.Data.EntityState.Added;
//确认添加操作
if (sde.SaveChanges() > 0)
{
return(Json(1));
}
}
}
}
return(Json(-1));
}
/// <summary>
/// 手机登录注册
/// </summary>
/// <param name="phone"></param>
/// <param name="password"></param>
/// <param name="code"></param>
/// <returns></returns>
public JsonResult CostomersUserPhone_Register(string user)
{
string[] us = user.Split(',');
string phone = us[0]; //帐号
string password = us[1]; //密码
string code = us[2]; //用户输入的验证码
if (!string.IsNullOrEmpty(user))
{
SportsDBEntities sde = new SportsDBEntities();
//获取发送的验证码
string s = Session["yzm"].ToString();
//查询是否已经存在当前帐号
var count = sde.UserInfo.Where(a => a.name == phone).ToList();
if (count.Count > 0)
{
Response.Write("用户名已注册!");
Response.End();
}
else if (s != code)
{
Response.Write("验证码错误!");
Response.End();
}
else
{
UserInfo u = new UserInfo();
u.name = phone;
u.user_password = password;
u.user_createTime = DateTime.Now;
u.user_status = 0;
u.store_id = 0;
//执行添加操作
sde.Entry(u).State = System.Data.EntityState.Added;
if (sde.SaveChanges() > 0)
{
//return RedirectToAction("Index", "Login");
return(Json(1));
}
}
}
return(Json(-1));
}
/// <summary>
/// 添加订单与订单详情(立即付款)
/// </summary>
/// <param name="msg"></param>
/// <param name="uid"></param>
/// <param name="money"></param>
/// <param name="num"></param>
public void Add_dd(string[] msg, int uid, Decimal?money, int num)
{
SportsDBEntities sde = new SportsDBEntities();
string str = Guid.NewGuid().ToString().Replace("-", "");
//添加订单表
OrderBySeller obs = new OrderBySeller();
obs.order_createTime = DateTime.Now;
obs.order_status = 1;
obs.orderdetails_status = 0;
obs.order_cost = money;
obs.userid = uid;
obs.GoodsInfo_ID = Convert.ToInt32(msg[0]);
obs.order_no = str;
obs.order_paytime = DateTime.Now;
sde.Entry(obs).State = System.Data.EntityState.Added;//执行添加操作
sde.SaveChanges();
//查询当前的订单编号
OrderBySeller os = sde.OrderBySeller.Where(a => a.order_no == str).FirstOrDefault();
//当前订单编号
int orderId = Convert.ToInt32(os.order_id);
//添加订单详情表
tbl_orderdetailsInfo tod = new tbl_orderdetailsInfo();
tod.orderdetails_totalprice = money;
tod.orderdetails_quantity = num;
tod.cart_color = msg[3];
tod.cart_CodeNumber = msg[4];
tod.cart_photo = msg[2];
tod.cart_remark = msg[1];
tod.orderdetails_unitprice = Convert.ToDecimal(msg[5]);
tod.GoodsInfo_id = Convert.ToInt32(msg[0]);
tod.order_id = orderId;
tod.orderdetails_price = money;
tod.StoreInfo_ID = Convert.ToInt32(msg[7]);
tod.UserInfo_id = Convert.ToInt32(Session["uid"]);
//添加操作
sde.Entry(tod).State = System.Data.EntityState.Added;
//数据库执行操作返回状态
sde.SaveChanges();
}
/// <summary>
/// 个人信息
/// </summary>
/// <returns></returns>
public ActionResult Information()
{
//实例化一个数据库对象
SportsDBEntities se = new SportsDBEntities();
//获取登陆账号的信息
UserInfo user = Session["UserInfo"] as UserInfo;
//存储登陆用户的id
Session["userid"] = user.userid;
//创建一个集合存放数据
List <UserInfo_detail> udlist = se.UserInfo_detail.Where(a => a.userid == user.userid).ToList();
return(View(udlist));
}
/// <summary>
/// 删除多个商品
/// </summary>
/// <returns></returns>
public JsonResult DeleteCartAll(string id)
{
string[] aid = id.Split(',');
SportsDBEntities sde = new SportsDBEntities();
for (int i = 0; i < aid.Length - 1; i++)
{
int cartid = Convert.ToInt32(aid[i]);
ShopManagement sm = new ShopManagement();
sm.cart_id = cartid;
sde.Entry(sm).State = System.Data.EntityState.Deleted;
}
int count = sde.SaveChanges();
return(Json(count));
}
//
// GET: /Home/
/// <summary>
/// 首页
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
SportsDBEntities sport = new SportsDBEntities();
//List<GoodsInfo> Glist = sport.GoodsInfo.ToList();
List <GoodsInfo> Glist = sport.GoodsInfo.Where(a => a.GoodsType_ID == 1).Take(8).ToList();
List <GoodsInfo> Klist = sport.GoodsInfo.Where(a => a.GoodsType_ID == 2).OrderBy(a => a.Id).Take(16).ToList();
ViewData["Klist"] = Klist;
List <GoodsInfo> Tlist = sport.GoodsInfo.Where(a => a.GoodsType_ID == 3).OrderBy(a => a.Id).Take(23).ToList();
ViewData["Tlist"] = Tlist;
List <GoodsInfo> Xlist = sport.GoodsInfo.Where(a => a.GoodsType_ID == 4).OrderBy(a => a.Id).Take(32).ToList();
ViewData["Xlist"] = Xlist;
List <GoodsInfo> QClist = sport.GoodsInfo.Where(a => a.GoodsType_ID == 5).OrderBy(a => a.Id).Take(40).ToList();
ViewData["QClist"] = QClist;
List <GoodsInfo> Qlist = sport.GoodsInfo.Where(a => a.GoodsType_ID == 6).OrderBy(a => a.Id).Take(48).ToList();
ViewData["Qlist"] = Qlist;
if (Session["UserInfo"] != null)
{
SportsDBEntities sde = new SportsDBEntities();
//获得登陆的账号信息
UserInfo ulist = Session["UserInfo"] as UserInfo;
int uid = Convert.ToInt32(Session["uid"]);//用户id
}
return(View(Glist));
}
/// <summary>
/// 初始化获取购物车的物品
/// </summary>
/// <returns></returns>
public ActionResult ShopCart()
{
if (Session["name"] == null)
{
Response.Redirect("../Login/Index?Cart=shopcart");
}
//使用ef
SportsDBEntities sde = new SportsDBEntities();
//获取用户信息
UserInfo user = Session["UserInfo"] as UserInfo;
//查询当前登录用户的购物车
List <ShopManagement> shopcart = sde.ShopManagement.Where(a => a.userid == user.userid).ToList();
//存储购物车
Session["shopcart"] = shopcart;
return(View());
}
/// <summary>
/// 订单信息
/// </summary>
/// <returns></returns>
public ActionResult Order()
{
//获取登陆用户id
int userid = Convert.ToInt32(Session["userid"]);
//使用EF
SportsDBEntities sde = new SportsDBEntities();
//查询所有详细订单信息
List <tbl_orderdetailsInfo> otlist = sde.tbl_orderdetailsInfo.Where(a => a.UserInfo_id == userid).ToList();
ViewData["otlist"] = otlist;
int?orderid = otlist[0].order_id;
//根据id查询订单的订单号与时间
OrderBySeller olist = sde.OrderBySeller.Where(a => a.order_id == orderid).FirstOrDefault();
ViewData["olist"] = olist;
return(View(otlist));
}
/// <summary>
/// 立即购买付款
/// </summary>
/// <param name="shopId"></param>
/// <param name="num"></param>
/// <param name="GoodsMsg"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public JsonResult ShopYes(int shopId, int num, string GoodsMsg, string pwd)
{
string[] msg = GoodsMsg.Split(',');
SportsDBEntities sde = new SportsDBEntities();
//查询商品的信息
GoodsInfo gd = sde.GoodsInfo.Where(a => a.Id == shopId).FirstOrDefault();
//获取商品的价格
decimal?money = gd.Goods_price * num;
decimal?user_money = Convert.ToDecimal(Session["money"]);
if (money > user_money)
{
return(Json(0));
}
else
{
//用户id
int uid = Convert.ToInt32(Session["uid"]);
//添加订单的信息
Add_dd(msg, uid, money, num);
//余额
decimal?price = user_money - money;
//修改
UserInfo_detail detail = sde.UserInfo_detail.Where(a => a.userid == uid).FirstOrDefault();
detail.user_money = price;
//获取返回的受影响的个数
int count = sde.SaveChanges();
return(Json(count));
}
}
/// <summary>
///
/// </summary>
/// <param name="monet"></param>
/// <returns></returns>
public JsonResult getMoney(string monet)
{
SportsDBEntities sde = new SportsDBEntities();
//得到登录的用户编号
int uid = Convert.ToInt32(Session["uid"]);
Decimal money = Convert.ToDecimal(monet);
UserInfo_detail ud = sde.UserInfo_detail.Where(a => a.userid == uid).FirstOrDefault();
Decimal?gg = Convert.ToDecimal(ud.user_money) - money;
if (gg < 0)
{
return(Json(2));
}
else
{
ud.user_money = gg;
int count = sde.SaveChanges();
return(Json(count));
}
}
/// <summary>
/// 商品详细信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult GoodsDetail(int id)
{
SportsDBEntities sport = new SportsDBEntities();
//获取商品基本信息
List <GoodsInfo> glist = sport.GoodsInfo.Where(a => a.Id == id).ToList();
ViewData["glist"] = glist;
//获取商品的详情信息
List <GoodsE> GEList = sport.GoodsE.Where(a => a.GoodsInfo_Id == id).ToList();
ViewData["GElsit"] = GEList;
//获取图片
List <GoodsImg> gimglist = sport.GoodsImg.Where(a => a.Goods_id == id).ToList();
ViewData["gimglist"] = gimglist;
return(View());
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public ActionResult ShopUser_Login(string user)
{
object carts = Session["url"];
string cart = "";
if (carts != null)
{
cart = carts.ToString();
}
int shopid = Convert.ToInt32(Session["shopid"]);
//将前台传来的字符串转化为数组
string[] userpass = user.Split(',');
//得到用户名
string username = userpass[0];
//得到密码
string pasaword = userpass[1];
SportsDBEntities sde = new SportsDBEntities();
//查询
UserInfo ulist = sde.UserInfo.Where(a => a.name == username && a.user_password == pasaword).FirstOrDefault();
//判断
if (ulist != null)
{
//用户基本信息
Session["UserInfo"] = ulist;
//获取用户的id
int uid = ulist.userid;
Session["uid"] = uid;
//查询当前登录用户的购物车
List <ShopManagement> shopcart = sde.ShopManagement.Where(a => a.userid == uid).ToList();
//购物车件数
Session["scart"] = shopcart.Count;
//查询获取详细信息
UserInfo_detail ud = sde.UserInfo_detail.Where(a => a.userid == uid).FirstOrDefault();
//添加或查询详细信息
select_detail(ud, ulist, uid);
if (cart == "shopcart")
{
return(Json(new { type = 2 }));
}
else if (shopid != 0)
{
return(Json(new { type = 1, data = shopid }));
}
else
{
Response.Write(2);
Response.End();
}
}
else
{
Response.Write(1);
Response.End();
}
return(View());
}
/// <summary>
/// 查询详细
/// </summary>
/// <param name="ud"></param>
/// <param name="ulist"></param>
/// <param name="uid"></param>
public void select_detail(UserInfo_detail ud, UserInfo ulist, int uid)
{
SportsDBEntities sde = new SportsDBEntities();
if (ud != null)
{
//获取用户的昵称
string name = ud.user_nickname;
//存储昵称
Session["name"] = name;
//存储用户余额
Session["money"] = ud.user_money;
//存储用户名
Session["username"] = ud.username;
//存储用户id
Session["userid"] = ud.userid;
//头像
Session["photo"] = ud.user_photo;
}
else
{
//判断手机还是邮箱登陆
if (ulist.name.Contains("@"))
{
//存入数据
UserInfo_detail udd = new UserInfo_detail();
udd.userid = uid;
udd.user_email = ulist.name;
udd.user_nickname = ulist.name;
//执行添加操作
sde.Entry(udd).State = System.Data.EntityState.Added;
sde.SaveChanges();
}
else
{
//存入数据
UserInfo_detail udd = new UserInfo_detail();
udd.userid = uid;
udd.user_photo = ulist.name;
udd.user_nickname = ulist.name;
//执行添加操作
sde.Entry(udd).State = System.Data.EntityState.Added;
sde.SaveChanges();
}
//获取用户的昵称
string name = ulist.name;
//存储昵称
Session["name"] = name;
//默认头像
Session["photo"] = "1.jpg";
}
}
