/// <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> /// <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> /// <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> /// <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="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> /// <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> /// <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> /// <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)); }
/// <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="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"; } }