public ActionResult AddCar(int id, int Num) { int membersId = Convert.ToInt32(Session["LoginId"]); using (FlowersSIMEntities fs = new FlowersSIMEntities()) { ShoppingCar shop = fs.ShoppingCar.FirstOrDefault(s => s.MembersId == membersId && s.ProductId == id); if (shop != null) { //return Content("<script>alert('您已加入购物车');window.location.href='/Home/Detailed?id=" + id + "'</script>"); return(Json(-1, JsonRequestBehavior.AllowGet)); } else { Product pro = fs.Product.FirstOrDefault(p => p.ProductId == id); ShoppingCar shopcar = new ShoppingCar(); shopcar.MembersId = membersId; shopcar.NowPrice = pro.NowPrice; shopcar.Num = Num; shopcar.Price = pro.NowPrice * Num; shopcar.ProductId = id; fs.ShoppingCar.Add(shopcar); fs.SaveChanges(); return(Json("添加成功", JsonRequestBehavior.AllowGet)); } } }
// GET: /MemberOrders/ public ActionResult Index(string id, int pageIndex = 1) { int ordersId = Convert.ToInt32(id); string name = Session["LoginUser"] as string; if (!int.TryParse(id, out ordersId)) { return(Content("<script>alert('参数不合法!');window.location.href = '/MemberOrders/OrdersIndex'</script>")); } using (FlowersSIMEntities os = new FlowersSIMEntities()) { Members ber = os.Members.FirstOrDefault(b => b.MembersName == name); Orders entity1 = os.Orders.FirstOrDefault(o => o.OrdersId == ordersId); ViewBag.Orders = entity1; string[] productIdString = entity1.ProductIdList.Split(','); int[] productIdArray = Array.ConvertAll(productIdString, int.Parse); if (pageIndex < productIdArray.Length || productIdArray.Length == 1) { GetOrdersList(id); } ////使用EF查询用户列表信息 List <OrderGoods> list = os.OrderGoods.ToList().ToPagedList(pageIndex, 2); //返回视图,顺带传递用户集合到视图中进行显示 return(View(list)); } }
public ActionResult GiveShopCar() { string name = Session["LoginUser"] as string; ArrayList array = new ArrayList(); using (FlowersSIMEntities fs = new FlowersSIMEntities()) { Members member = fs.Members.FirstOrDefault(m => m.MembersName == name); var car = fs.ShoppingCar.Where(c => c.MembersId == member.MembersId); foreach (var item in car) { var pro = fs.Product.Where(p => p.ProductId == item.ProductId).ToList();; foreach (var item1 in pro) { array.Add(item.CarId); array.Add(item1.ProductName); array.Add(item1.Picture1); array.Add(item1.FlowerLanguage); array.Add(item.Price); array.Add(item.Num); array.Add(item.ProductId); } } } return(Json(array, JsonRequestBehavior.AllowGet)); }
private ActionResult MembersSearch(string MembersName, string gender, string phone, int id = 1) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { List <Members> list = fs.Members.ToList(); if (!string.IsNullOrWhiteSpace(MembersName) || !string.IsNullOrWhiteSpace(gender) || !string.IsNullOrWhiteSpace(phone)) { if (!string.IsNullOrWhiteSpace(MembersName)) { list = list.Where(a => a.MembersName.Contains(MembersName)).ToPagedList(1, 100); } ; if (gender != null) { int gender1 = int.Parse(gender); list = list.Where(a => a.Gender == gender1).ToPagedList(1, 100); } if (!string.IsNullOrWhiteSpace(phone)) { list = list.Where(a => a.Phone.Contains(phone)).ToPagedList(1, 100); } ; return(View(list.ToPagedList(1, 10))); } else { return(Content("<script>alert('请输入要查询的内容');window.location.href = '/Manage/MembersManage'</script>")); } } }
public ActionResult Search(string search, int pageIndex = 1) { List <Product> product = new List <Product>(); using (FlowersSIMEntities fs = new FlowersSIMEntities()) { for (int i = 0; i < search.Length; i++) { string s = search[i].ToString(); List <Product> pi = fs.Product.Where(f => f.ProductName.Contains(s)).ToList(); (product as List <Product>).AddRange(pi); } for (int k = 0; k < product.Count(); k++) { for (int k1 = k + 1; k1 < product.Count(); k1++) { if (product[k].ProductId == product[k1].ProductId) { product.RemoveAt(k1); k1--; } } } if (product.Count() == 0) { List <Product> flower = fs.Product.ToList(); (product as List <Product>).AddRange(flower); } return(View(product.ToPagedList(pageIndex, 12))); } }
//商品信息删除 public ActionResult ProductDelete(string id) { int productId; if (!int.TryParse(id, out productId)) { return(Content("<script>alert('参数不合法!');window.location.href = '/Manage/ProductManage'</script>")); } using (FlowersSIMEntities fs = new FlowersSIMEntities()) { Product entity = fs.Product.FirstOrDefault(p => p.ProductId == productId); if (entity != null) { fs.Product.Remove(entity); } if (fs.SaveChanges() > 0) { return(Content("<script>alert('删除成功!');window.location.href = '/Manage/ProductManage'</script>")); } else { return(Content("<script>alert('删除失败!');window.location.href = '/Manage/ProductManage'</script>")); } } }
public ActionResult MembersAdd(Members entity) { ModelState.Remove("MembersId"); if (ModelState.IsValid) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { bool result = fs.Members.Count(m => m.MembersName == entity.MembersName) == 0; if (result) { entity.LoginStatus = 0; fs.Members.Add(entity); if (fs.SaveChanges() > 0) { return(Content("<script language='javascript' type='text/javascript'>alert('增加成功!');window.location.href = '/Manage/MembersManage'</script>")); } else { return(Content("<script>alert('增加失败!');window.location.href = '/Manage/MembersManage'</script>")); } } else { return(Content("<script>alert('该用户名已存在,请重新输入!');window.location.href = '/Manage/MembersAdd'</script>")); } } } return(View(entity)); }
public ActionResult getListCount(string table, int Id, int price, int volume) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { switch (table) { case "Festival": { var pro = fs.Product.Where(p => p.FestivalId == Id).Count(); return(Json(pro, JsonRequestBehavior.AllowGet)); } case "Color": { var pro = fs.Product.Where(p => p.ColorId == Id).Count(); return(Json(pro, JsonRequestBehavior.AllowGet)); } case "FlowerKind": { var pro = fs.Product.Where(p => p.FlowerKindId == Id).Count(); return(Json(pro, JsonRequestBehavior.AllowGet)); } default: { return(Json(table, JsonRequestBehavior.AllowGet)); } } } }
private ActionResult ProductSearch(string productName, string material, string flowerLanguage) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { List <Product> list = fs.Product.ToList(); if (!string.IsNullOrWhiteSpace(productName) || !string.IsNullOrWhiteSpace(material) || !string.IsNullOrWhiteSpace(flowerLanguage)) { if (!string.IsNullOrWhiteSpace(productName)) { list = list.Where(a => a.ProductName.Contains(productName)).ToPagedList(1, 10); } if (!string.IsNullOrWhiteSpace(material)) { list = list.Where(a => a.Material.Contains(material)).ToPagedList(1, 10); } if (!string.IsNullOrWhiteSpace(flowerLanguage)) { list = list.Where(a => a.FlowerLanguage.Contains(flowerLanguage)).ToPagedList(1, 10); } return(View(list.ToPagedList(1, 10))); } else { return(Content("<script>alert('请输入要查询的内容');window.location.href = '/Manage/ProductManage'</script>")); } } }
//用户信息删除 public ActionResult MembersDelete(string id) { int membersId; if (!int.TryParse(id, out membersId)) { return(Content("<script>alert('参数不合法!');window.location.href = '/Manage/MembersManage'</script>")); } using (FlowersSIMEntities fs = new FlowersSIMEntities()) { Members entity = fs.Members.FirstOrDefault(m => m.MembersId == membersId); if (entity != null) { fs.Members.Remove(entity); } if (fs.SaveChanges() > 0) { return(Content("<script>alert('删除成功!');window.location.href = '/Manage/MembersManage'</script>")); } else { return(Content("<script>alert('删除失败!');window.location.href = '/Manage/MembersManage'</script>")); } } }
public ActionResult MenberEdit(Members enty) { using (FlowersSIMEntities dc = new FlowersSIMEntities()) { //2.1 先查询 Members ape = dc.Members.FirstOrDefault(u => u.MembersId == enty.MembersId); //2.2 在数据上下文中修改状态值 if (ape != null) { ape.MembersName = enty.MembersName; ape.MembersPwd = enty.MembersPwd; ape.Phone = enty.Phone; ape.ConfirmPwd = enty.ConfirmPwd; ape.LoginStatus = enty.LoginStatus; } //2.3 保存回数据库中 if (dc.SaveChanges() > 0) { return(Content("<script>alert('修改成功!');window.location.href = '/Personal/Index'</script>")); } else { if (ape != null) { return(Content("<script>alert('没有进行修改!');window.location.href = '/Personal/Index'</script>")); } else { return(Content("<script>alert('修改失败!');window.location.href = '/Personal/Index'</script>")); } } } }
public ActionResult MenberEdit(string id) { int memberId; if (!int.TryParse(id, out memberId)) { return(Content("<script>alert('参数不合法!');window.location.href = '/Personal/Index'</script>")); } //2、退款 using (FlowersSIMEntities dc = new FlowersSIMEntities()) { //2.1 先查询 Members entity = dc.Members.FirstOrDefault(u => u.MembersId == memberId); //2.2 在数据上下文中修改状态值 if (entity != null) { return(View(entity)); } //2.3 保存回数据库中 if (dc.SaveChanges() > 0) { return(Content("<script>alert('修改成功!');window.location.href = '/Personal/Index'</script>")); } else { return(Content("<script>alert('修改失败!');window.location.href = '/Personal/Index'</script>")); } } }
public ActionResult Detailed(int id) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { var flower = fs.Product.Where(p => p.ProductId == id).ToList(); return(View(flower)); } }
public ActionResult GetJson() { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { List <Product> pro = fs.Product.Where(p => p.FestivalId == 4).ToList(); return(Json(pro, JsonRequestBehavior.AllowGet)); } }
private void BindFlowerKind() { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { List <FlowerKind> list = fs.FlowerKind.ToList(); SelectList hclist = new SelectList(list, "FlowerKindId", "FlowerKindName"); ViewBag.FlowerKind = hclist; } }
private void Binfsolor() { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { List <Color> list = fs.Color.ToList(); SelectList yslist = new SelectList(list, "ColorId", "ColorName"); ViewBag.Color = yslist; } }
private void BindFestival() { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { List <Festival> list = fs.Festival.ToList(); SelectList jrlist = new SelectList(list, "FestivalId", "FestivalName"); ViewBag.Festival = jrlist; } }
public ActionResult GetInventory(int id) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { ShoppingCar shop = fs.ShoppingCar.FirstOrDefault(s => s.CarId == id); Product pro = fs.Product.FirstOrDefault(p => p.ProductId == shop.ProductId); return(Json(pro.Inventory, JsonRequestBehavior.AllowGet)); } }
public ActionResult OrdersManage(int pageIndex = 1) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { //使用EF查询用户列表信息 List <Orders> list = fs.Orders.ToList().ToPagedList(pageIndex, 9); //返回视图,顺带传递用户集合到视图中进行显示 return(View(list)); } }
public ActionResult DeleteShopCar(int id) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { ShoppingCar car = fs.ShoppingCar.FirstOrDefault(c => c.CarId == id); fs.ShoppingCar.Remove(car); fs.SaveChanges(); return(Json("删除成功", JsonRequestBehavior.AllowGet)); } }
public ActionResult CheckMembersName(string membersName) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { //在用户表中,查询用户名等于userName参数值的记录的条数,并且与0进行比较。 //如果记录条数为1,此时result为false,如果记录条数为0,此时result为true bool result = fs.Members.Count(m => m.MembersName == membersName) == 0; //返回JSON格式的结果 return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult ProductManage(int pageIndex = 1) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { //使用EF查询用户列表信息 Bind(); List <Product> list = fs.Product.ToList().ToPagedList(pageIndex, 10); //返回视图,顺带传递用户集合到视图中进行显示 return(View(list)); } }
//订单管理的筛选 public ActionResult OrdersFilter(string id) { int ordersFilterId = int.Parse(id); using (FlowersSIMEntities fs = new FlowersSIMEntities()) { List <Orders> list = fs.Orders.ToList(); list = list.Where(a => a.Status == ordersFilterId).ToPagedList(1, 9); return(View("OrdersManage", list.ToPagedList(1, 9))); } }
public ActionResult Index() { string name = Session["LoginUser"] as string; using (FlowersSIMEntities dc = new FlowersSIMEntities()) { Members ad = dc.Members.FirstOrDefault(a => a.MembersName == name); var list = dc.Members.FirstOrDefault(l => l.MembersId == ad.MembersId); return(View(list)); } }
public ActionResult ProductEdit(Product entity) { Bind(); //获取上传图片路径 HttpPostedFileBase file = Request.Files["imgFile"]; var ext = Path.GetExtension(file.FileName); if (ext != "") { string path = "/Image/" + Guid.NewGuid().ToString() + file.FileName; file.SaveAs(Request.MapPath(path)); entity.Picture1 = path; } using (FlowersSIMEntities fs = new FlowersSIMEntities()) { Product model = fs.Product.FirstOrDefault(p => p.ProductId == entity.ProductId); if (model != null) { model.ProductName = entity.ProductName; model.Material = entity.Material; model.Package = entity.Package; model.FlowerLanguage = entity.FlowerLanguage; if (entity.Picture1 != null) { model.Picture1 = entity.Picture1; } model.OriginalPrice = entity.OriginalPrice; model.NowPrice = entity.NowPrice; model.Inventory = entity.Inventory; model.FestivalId = entity.FestivalId; model.ColorId = entity.ColorId; model.FlowerKindId = entity.FlowerKindId; } if (fs.SaveChanges() > 0) { return(Content("<script>alert('修改成功');window.location.href = '/Manage/ProductManage'</script>")); } else { if (model != null) { return(Content("<script>alert('未做任何修改,修改成功');window.location.href = '/Manage/ProductManage'</script>")); } else { return(Content("<script>alert('修改失败');window.location.href = '/Manage/ProductManage'</script>")); } } } }
public ActionResult OrderIndex(int pageIndex = 1) { string name = Session["LoginUser"] as string; using (FlowersSIMEntities os = new FlowersSIMEntities()) { Members ber = os.Members.FirstOrDefault(b => b.MembersName == name); var list = os.Orders.Where(p => p.MembersId == ber.MembersId).ToList().ToPagedList(pageIndex, 4); //var list = os.Orders.Where(o => o.MembersId == ber.MembersId).ToList().ToPagedList(pageIndex, 3); return(View(list)); } }
public ActionResult EditShopCar(int afternum, int id) { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { ShoppingCar car = fs.ShoppingCar.FirstOrDefault(c => c.CarId == id); Product pro = fs.Product.FirstOrDefault(p => p.ProductId == car.ProductId); car.Num = afternum; car.Price = afternum * pro.NowPrice; decimal price = afternum * pro.NowPrice; fs.SaveChanges(); return(Json(price, JsonRequestBehavior.AllowGet)); } }
public ActionResult GiveIndex() { using (FlowersSIMEntities fs = new FlowersSIMEntities()) { ArrayList array = new ArrayList(); List <Product> pro = fs.Product.OrderByDescending(p => p.ProductVolume).ToList();; foreach (var item in pro) { array.Add(item.ProductId); array.Add(item.Picture1); } return(Json(array, JsonRequestBehavior.AllowGet)); } }
public ActionResult SelectCount(int FestivalId, int ColorId, int FlowerKindId) { int Count; using (FlowersSIMEntities fs = new FlowersSIMEntities()) { if (FestivalId == 0 && ColorId == 0 && FlowerKindId == 0) { Count = fs.Product.Count(); return(Json(Count, JsonRequestBehavior.AllowGet)); } return(Json(0, JsonRequestBehavior.AllowGet)); } }
public ActionResult givecolor() { ArrayList array = new ArrayList(); using (FlowersSIMEntities fs = new FlowersSIMEntities()) { List <Color> list = fs.Color.ToList(); foreach (var item in list) { array.Add(item.ColorId); array.Add(item.ColorName); } return(Json(array, JsonRequestBehavior.AllowGet)); } }