public CommodityRes GetSearchList(int index, int size, string search, int?sales = null, string orderStr = null) { CommodityRes r = new CommodityRes(); string key = ""; bool desc = true; switch (orderStr) { case "salesDesc": key = "sales"; desc = true; break; case "price": key = "maxPrice"; desc = false; break; case "priceDesc": key = "maxPrice"; desc = true; break; case "starsDesc": key = "stars"; desc = true; break; case "createTimeDesc": key = "createTime"; desc = true; break; } Commodity_Stageprice_View c = new Commodity_Stageprice_View(); c.Name = search; c.Introduce = search; c.Content = search; c.Sales = sales; c.IsDelete = false; var count = Commodity_Stageprice_ViewOper.Instance.SelectCountForSearchList(c, null, null); var listComm = Commodity_Stageprice_ViewOper.Instance.SelectByPageForSearchList(key, index * size, size, desc, c); List <CommodityListRes> commList = new List <CommodityListRes>(); foreach (var item in listComm) { var res = new CommodityListRes(item); commList.Add(res); } var pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.ListData = commList; r.index = (int)index; r.pages = (int)pages; return(r); }
/// <summary> /// 根据条件筛选商品 /// </summary> /// <param name="ids"></param> /// <returns></returns> public CommodityRes GetCommList(int index, int size, List <int> ids = null, int?sales = null, string orderStr = null) { CommodityRes r = new CommodityRes(); if (ids != null) { Commodity_Stageprice_View c = new Commodity_Stageprice_View(); c.Id = 1; c.IsDelete = false; if (sales != null) { c.Sales = 1; } string key = ""; bool desc = true; switch (orderStr) { case "salesDesc": key = "sales"; desc = true; break; case "price": key = "maxPrice"; desc = false; break; case "priceDesc": key = "maxPrice"; desc = true; break; case "starsDesc": key = "stars"; desc = true; break; case "createTimeDesc": key = "createTime"; desc = true; break; } //CommodityspviewOper.Instance.SelectByPageForCommList(key, 0, 9, desc, c, null, null, ids, sales); var count = Commodity_Stageprice_ViewOper.Instance.SelectCountForCommList(c, null, null, ids, sales); var listComm = Commodity_Stageprice_ViewOper.Instance.SelectByPageForCommList(key, index * size, size, desc, c, null, null, ids, sales); List <CommodityListRes> commList = new List <CommodityListRes>(); foreach (var item in listComm) { var res = new CommodityListRes(item); commList.Add(res); } var pages = count / size; //总页数 pages = pages * size == count ? pages : pages + 1; r.ListData = commList; r.index = index; r.pages = pages; return(r); } return(null); }