public ActionResult content(int id) { var lang = System.Threading.Thread.CurrentThread.CurrentCulture.Name; db0 = getDB0(); var menus = (IEnumerable <CategoryL1Data>)ViewBag.CategoryStroe; int main_category_id = 0; int sub_category_id = 0; string main_category_name = ""; string sub_category_name = ""; int main_category_count = 0; int sub_category_count = 0; var item = db0.Product.Find(id); var get_category_l1 = item.Product_Category_L1; var get_category_l2 = item.Product_Category_L2; main_category_id = get_category_l1.product_category_l1_id; sub_category_id = get_category_l2.product_category_l2_id; main_category_name = get_category_l1.l1_name; sub_category_name = get_category_l2.l2_name; ViewBag.main_category_id = main_category_id; ViewBag.sub_category_id = sub_category_id; ViewBag.CategoryStroe = menus; main_category_count = db0.Product.Where(x => x.l1_id == main_category_id).Count(); sub_category_count = db0.Product.Where(x => x.l2_id == sub_category_id).Count(); CategoryStroe categoryStroe = new CategoryStroe(); categoryStroe.categoryL1Data = menus; categoryStroe.now_category_l1 = main_category_id; categoryStroe.now_category_l2 = sub_category_id; ProductContent md = new ProductContent(); md.product = item; md.menuStroe = categoryStroe; md.name_category_l1 = main_category_name; md.name_category_l2 = sub_category_name; md.count_category_l1 = main_category_count; md.count_category_l2 = sub_category_count; md.src = ImgSrc("Active", "ProductData", item.product_id, "img1", "origin"); md.fileSrcs = GetFiles(id.ToString(), "File1", "Active", "ProductData"); return(View(md)); }
public ActionResult list(int?id, int?id2) { var lang = System.Threading.Thread.CurrentThread.CurrentCulture.Name; db0 = getDB0(); var menus = (IEnumerable <CategoryL1Data>)ViewBag.CategoryStroe; //取得Menu 第一項目 int main_category_id = 0; int sub_category_id = 0; string main_category_name = ""; string sub_category_name = ""; int main_category_count = 0; int sub_category_count = 0; if (id == null) { var main_category = menus.FirstOrDefault(); var sub_category = menus.FirstOrDefault().categoryL2Data.FirstOrDefault(); main_category_id = main_category.id; main_category_name = main_category.name; sub_category_name = sub_category.name; sub_category_id = sub_category.id; } else { main_category_id = (int)id; var find_category_l1 = menus.First(x => x.id == main_category_id); main_category_name = find_category_l1.name; if (id2 == null) { var find_category_l2 = find_category_l1.categoryL2Data.FirstOrDefault(); sub_category_id = find_category_l2.id; sub_category_name = find_category_l2.name; } else { var find_category_l2 = find_category_l1.categoryL2Data.FirstOrDefault(x => x.id == id2); sub_category_id = find_category_l2.id; sub_category_name = find_category_l2.name; } } ViewBag.main_category_id = main_category_id; ViewBag.sub_category_id = sub_category_id; ViewBag.CategoryStroe = menus; main_category_count = db0.Product.Where(x => x.l1_id == main_category_id & !x.i_Hide).Count(); sub_category_count = db0.Product.Where(x => x.l2_id == sub_category_id & !x.i_Hide).Count(); CategoryStroe categoryStroe = new CategoryStroe(); categoryStroe.categoryL1Data = menus; categoryStroe.now_category_l1 = main_category_id; categoryStroe.now_category_l2 = sub_category_id; var items = db0 .Product .Where(x => x.i_Lang == lang && x.l1_id == main_category_id && x.l2_id == sub_category_id & !x.i_Hide) .OrderBy(x => x.modal) .Select(x => new ProductIntro() { product_id = x.product_id, modal = x.modal, standard = x.standard, category_l2_name = x.Product_Category_L2.l2_name }).ToList(); foreach (var item in items) { item.src = ImgSrc("Active", "ProductData", item.product_id, "img1", "origin"); } ProductList md = new ProductList(); md.products = items; md.menuStroe = categoryStroe; md.name_category_l1 = main_category_name; md.name_category_l2 = sub_category_name; md.count_category_l1 = main_category_count; md.count_category_l2 = sub_category_count; return(View(md)); }