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