public ActionResult Index() { ViewBag.IsFirstPage = true; ViewBag.BodyClass = "index"; ViewBag.Cur = new string[] { "", "", "", "", "", "", "", "", "", "", "" }; #region getSid Int a_ProductKind c = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> hResult = c.SearchMaster(new q_ProductKind() { s_Series = 12 }, 1); //get 新進商品 int[] s_kinds = hResult.SearchData.Select(x => x.ID).ToArray(); #endregion a_ProductData t = new a_ProductData() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductData> r = t.SearchMaster(new q_ProductData() { s_IsSecond = true, s_IsOpen = true, s_Kinds = s_kinds }, 1); return(View(r.SearchData.AsEnumerable())); }
public ActionResult Products_new2(int?sid, int?kid, int?page) { ViewBag.BodyClass = "Products new"; ViewBag.Cur = new string[] { "", "", "", "", "", "", "", "", "", "", "", "" }; String[] Series = { "", "屏風系列", "辦公桌系列", "會議桌系列", "檔案櫃系列", "主管辦公桌系列", "辦公椅系列", "沙發系列", "", "", "其他商品", "造型椅 / 吧檯椅" }; if (sid == null) { sid = 1; } ViewBag.Cur[Convert.ToInt32(sid)] = "current"; ViewBag.Nur = Convert.ToInt32(sid); ViewBag.Series = Series[Convert.ToInt32(sid)]; a_ProductKind t = new a_ProductKind() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductKind> r = t.SearchMaster(new q_ProductKind() { s_ID = kid }, 1); ViewBag.kind = r.SearchData.First().Name; a_ProductData p = new a_ProductData() { Connection = getSQLConnection(), logPlamInfo = plamInfo }; RunQueryPackage <m_ProductData> pr = p.SearchMaster(new q_ProductData() { s_IsOpen = true, s_IsSecond = false, s_Kind = kid }, 1); if (pr.SearchData.Any()) { int?kind_id = r.SearchData.First().ID; var getid = p.SearchMaster(new q_ProductData() { s_Kind = kind_id }, 0); if (pr.SearchData.Count() == 1 && getid.SearchData.Any()) { //如果此種類(kid)只有一項就直接跳到product_second3去顯示 int id = getid.SearchData.First().ID; Response.Redirect("~/Products/Products_new3/" + id + "?sid=" + sid); } } page = page == null ? 1 : page; int totalpage = pr.SearchData.Count() / 9; int mod = pr.SearchData.Count() % 9; if (mod != 0) { totalpage++; } int getTotalPage = totalpage; var getProduct = pr.SearchData.Skip(9 * ((int)page - 1)).Take(9); ViewBag.nextPage = getTotalPage > page ? page + 1 : page; ViewBag.prvePage = page <= 1 ? 1 : page - 1; if (r.SearchData.Count() >= 1 && r.SearchData.Count() <= 9) { ViewBag.totalPage = 1; } else { ViewBag.totalPage = getTotalPage; } ViewBag.page = page; ViewBag.sid = sid; return(View(getProduct.AsEnumerable())); }