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