public ActionResult Edit(int?id, int?page) { //記錄目前頁數,若是空值就給1 TempData["savepage"] = page ?? 1; var av = db.Activities.Find(id ?? 1); ActivityEditViewModel aevm = new ActivityEditViewModel(); List <ActivityProdViewModel> apList = new List <ActivityProdViewModel>(); aevm.ActivityID = av.ActivityID; aevm.ActivityName = av.ActivityName; aevm.BeginDate = av.BeginDate; aevm.EndDate = av.EndDate; aevm.DiscountID = av.DiscountID; aevm.DiscountName = db.DiscountMethods.Find(av.DiscountID).DiscountName; aevm.CreateDate = av.CreateDate; aevm.PhotoID = av.PhotoID; var ap = db.ActivityProducts.Where(x => x.ActivityID == id); List <Product> prod = db.Products.ToList(); List <VW_EW_CategorySM> cateMS = db.VW_EW_CategorySM.ToList(); List <Supplier> suppliers = db.Suppliers.ToList(); List <ProductPhoto> prodPhoto = db.ProductPhotoes.ToList(); foreach (var item in ap) { ActivityProdViewModel apvm = new ActivityProdViewModel(); apvm.ActivityID = item.ActivityID; apvm.ProductID = item.ProductID; var pd = prod.Where(x => x.ProductID == item.ProductID).FirstOrDefault(); apvm.ProductName = pd.ProductName; apvm.CategoryMSName = cateMS.Where(x => x.CategorySID == pd.CategorySID).FirstOrDefault().CategoryName; apvm.SupplierName = suppliers.Where(x => x.SupplierID == pd.SupplierID).FirstOrDefault().SupplierName; if (prodPhoto.Any(x => x.ProductID == item.ProductID && ((x.PhotoID == null ? 0 : x.PhotoID) > 0))) { apvm.PhotoID = (int)prodPhoto.Where(x => x.ProductID == item.ProductID).FirstOrDefault().PhotoID; } //aevm.producstList apList.Add(apvm); } aevm.producstList = apList; ViewBag.datas = db.DiscountMethods; return(View(aevm)); }
public ActionResult Edit(int id) { //活動內容更改 View ActivityEditModel _AEM = new ActivityEditModel(); var _av = db.Activities.Find(id); _AEM.ActivityID = _av.ActivityID; _AEM.ActivityName = _av.ActivityName; _AEM.BeginDate = _av.BeginDate; _AEM.EndDate = _av.EndDate; _AEM.DiscountID = _av.DiscountID; _AEM.DiscountName = db.DiscountMethods.Find(_av.DiscountID).DiscountName; _AEM.CreateDate = _av.CreateDate; //活動商品明細 View List <ActivityProdViewModel> _Listapvm = new List <ActivityProdViewModel>(); var _ap = db.ActivityProducts.Where(W => W.ActivityID == id); List <Product> prod = db.Products.ToList(); List <VW_EW_CategorySM> cateMS = db.VW_EW_CategorySM.ToList(); List <Supplier> suppliers = db.Suppliers.ToList(); List <ProductPhoto> prodPhoto = db.ProductPhotoes.ToList(); foreach (var _data in _ap) { ActivityProdViewModel _apvm = new ActivityProdViewModel(); _apvm.ActivityID = _data.ActivityID; _apvm.ProductID = _data.ProductID; var _pd = db.Products.Where(W => W.ProductID == _data.ProductID).FirstOrDefault(); _apvm.ProductName = _pd.ProductName; _apvm.CategoryMSName = cateMS.Where(x => x.CategorySID == _pd.CategorySID).FirstOrDefault().CategoryName; _apvm.SupplierName = suppliers.Where(x => x.SupplierID == _pd.SupplierID).FirstOrDefault().SupplierName; if (prodPhoto.Any(x => x.ProductID == _data.ProductID && ((x.PhotoID == null ? 0 : x.PhotoID) > 0))) { _apvm.PhotoID = (int)prodPhoto.Where(x => x.ProductID == _data.ProductID).FirstOrDefault().PhotoID; } //aevm.producstList _Listapvm.Add(_apvm); } _AEM.ProdList = _Listapvm; ViewBag.temp = db.DiscountMethods; return(View(_AEM)); }