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));
}
}
