public ActionResult register(A_UserLogin emp) { LaTuErEntities db = new LaTuErEntities(); db.A_UserLogin.Add(emp); int rs = db.SaveChanges(); if (emp != null) { return(RedirectToAction("Login", "Login")); } return(RedirectToAction("register")); }
public ActionResult Login(string txt_id, string txt_pwd) { LaTuErEntities db = new LaTuErEntities(); var emp = db.A_UserLogin .Where(c => c.UserPhone == txt_id && c.UserPwd == txt_pwd) .FirstOrDefault(); if (emp != null) { Session["UserId"] = emp.UserId; //保存用户ID return(RedirectToAction("Index", "Home")); } return(RedirectToAction("Login")); }
public JsonResult Load() { //查询商品 LaTuErEntities db = new LaTuErEntities(); var list = db.E_Commodity.ToList() .Select(c => new { CommodityId = c.CommodityId, Tradename = c.Tradename, Price = c.Price, Image = c.Image, Commodityclassification = c.Commodityclassification, Contactnumber = c.Contactnumber, }).ToList(); return(Json(list, JsonRequestBehavior.AllowGet)); }
public JsonResult UserOrder() { int UserID = Convert.ToInt32(Session["UserID"]); LaTuErEntities db = new LaTuErEntities(); var list = from p in db.J_OrderXX join s in db.E_Commodity on p.CommodityId equals s.CommodityId where p.UserId == UserID select new { p.OrderId, s.Tradename, s.Price, s.Image }; return(Json(list, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 商品详情 /// </summary> /// <returns></returns> public JsonResult Load() { int id = Convert.ToInt32(TempData["id"]); LaTuErEntities db = new LaTuErEntities(); var list = from p in db.E_Commodity join s in db.F_Commoditypictures on p.CommodityId equals s.CommodityId where p.CommodityId == id select new { CommodityId = p.CommodityId, Tradename = p.Tradename, Price = p.Price, CommodityDescription = p.CommodityDescription, Mastergraph = s.Mastergraph }; return(Json(list, JsonRequestBehavior.AllowGet)); }
public JsonResult Add(int id, int count) { int UserID = Convert.ToInt32(Session["UserID"]); LaTuErEntities db = new LaTuErEntities(); var cart = new ShoppingCart { UserId = UserID, CommodityId = id, Quantityofcommodities = count }; db.ShoppingCarts.Add(cart); int rs = db.SaveChanges(); var obj = new { msg = "添加失败", code = 201 }; if (rs > 0) { obj = new { msg = "添加成功", code = 200 }; } return(Json(obj)); }
public JsonResult Load() { //订单 LaTuErEntities db = new LaTuErEntities(); var list = db.J_OrderXX.ToList() .Select(c => new { OrderxxId = c.OrderId, CommodityId = c.A_UserLogin.UserName, Tradename = c.Tradename, Ordertime = DateTime.Now.ToString("yyyy-MM-dd"), PaymentmethodId = c.PaymentmethodId, Itempricing = c.Itempricing, Commoditypictures = c.Commoditypictures, UserId = c.UserId, Quantityofcommodities = c.Quantityofcommodities, Orderstatus = c.Orderstatus, OrderId = c.OrderId }).ToList(); return(Json(list, JsonRequestBehavior.AllowGet)); }