public ActionResult CategoryList(string id) { int int_id = 0; ViewBag.CategoryNo = id; ViewBag.TypeName = ShopContent.GetTypeName(id); ViewBag.CategoryName = ShopContent.GetCategoryName(id, ref int_id); var model = db.Products .Where(m => m.categoryid == int_id) .OrderBy(m => m.product_no) .ToList(); return(View(model)); }
public ActionResult Edit(int id = 0) { using (ZONYEntities db = new ZONYEntities()) { var models = db.Products.Where(m => m.rowid == id).FirstOrDefault(); //Category DropDownList string str_rowid = "0"; var categoryList = new List <SelectListItem>(); var ageList = new List <SelectListItem>() { new SelectListItem() { Value = "001", Text = "普遍級" }, new SelectListItem() { Value = "002", Text = "保護級" }, new SelectListItem() { Value = "003", Text = "輔導級" }, new SelectListItem() { Value = "004", Text = "限制級" }, }; var ZboxTypeList = new List <SelectListItem>() { new SelectListItem() { Value = "0", Text = "Zbox4" }, new SelectListItem() { Value = "1", Text = "Zbox4/Zbox3" }, }; List <Categorys> clists = db.Categorys.OrderBy(m => m.category_no).ToList(); foreach (var item in clists) { SelectListItem list = new SelectListItem(); list.Value = item.rowid.ToString(); list.Text = ShopContent.GetCategoryName(item.rowid); categoryList.Add(list); if (id == 0) { if (str_rowid == "0") { str_rowid = item.rowid.ToString(); } } } if (models != null) { str_rowid = models.categoryid.ToString(); } //預設選擇哪一筆 categoryList.Where(m => m.Value == str_rowid).First().Selected = true; ViewBag.CategoryList = categoryList; ViewBag.AgeList = ageList; ViewBag.ZboxTypeList = ZboxTypeList; if (id == 0) { Products new_model = new Products(); new_model.size_name = ""; new_model.color_name = ""; new_model.remark = ""; new_model.detail_remark = ""; new_model.publisher = ""; new_model.player_num = ""; new_model.language_view = ""; new_model.language_voice = ""; new_model.start_count = 5; new_model.browse_count = 0; new_model.launchday = DateTime.Today; new_model.bool_istop = false; new_model.bool_issale = true; new_model.bool_iscolor = false; new_model.bool_issize = false; new_model.bool_isgame = false; new_model.bool_ismultiplayer = false; return(View(new_model)); } models.bool_istop = (models.istop == 1); models.bool_issale = (models.issale == 1); models.bool_iscolor = (models.iscolor == 1); models.bool_issize = (models.issize == 1); models.bool_isgame = (models.isgame == 1); models.bool_ismultiplayer = (models.ismultiplayer == 1); return(View(models)); } }
public ActionResult Edit(Products models) { bool status = false; if (ModelState.IsValid) { using (ZONYEntities db = new ZONYEntities()) { int int_cate_id = 0; if (models.rowid > 0) { //Edit var products = db.Products.Where(m => m.rowid == models.rowid).FirstOrDefault(); if (products != null) { int_cate_id = models.categoryid.GetValueOrDefault(); products.product_no = models.product_no; products.product_name = models.product_name; products.product_spec = models.product_spec; products.categoryid = int_cate_id; products.category_name = ShopContent.GetCategoryName(int_cate_id); products.istop = (models.bool_istop) ? 1 : 0; products.issale = (models.bool_issale) ? 1 : 0; products.issize = (models.bool_issize) ? 1 : 0; products.iscolor = (models.bool_iscolor) ? 1 : 0; products.isgame = (models.bool_isgame) ? 1 : 0; products.ismultiplayer = (models.bool_ismultiplayer) ? 1 : 0; products.price = models.price; products.start_count = models.start_count; products.browse_count = models.browse_count; products.vendor_no = UserAccount.UserNo; products.color_name = models.color_name; products.size_name = models.size_name; products.remark = models.remark; products.detail_remark = models.detail_remark; products.publisher = models.publisher; products.language_view = models.language_view; products.language_voice = models.language_voice; products.player_num = models.player_num; } } else { //Save models.vendor_no = UserAccount.UserNo; int_cate_id = models.categoryid.GetValueOrDefault(); models.category_name = ShopContent.GetCategoryName(int_cate_id); models.istop = (models.bool_istop) ? 1 : 0; models.issale = (models.bool_issale) ? 1 : 0; models.issize = (models.bool_issize) ? 1 : 0; models.iscolor = (models.bool_iscolor) ? 1 : 0; models.isgame = (models.bool_isgame) ? 1 : 0; models.ismultiplayer = (models.bool_ismultiplayer) ? 1 : 0; db.Products.Add(models); } db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }