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