62,046
社区成员
发帖
与我相关
我的任务
分享
str1 = HttpUtility.UrlDecode(Request.QueryString["sort"].ToString());
switch (str1)
{
case "idasc":
sort = "p.ICBC_ProductId";
break;
case "pubdatedesc":
sort = "p.StartDate descending";//时间降序
break;
case "pubdateasc":
sort = "p.StartDate";//时间升序
break;
case "dpriceasc":
sort = "p.DetailPrice";价格升序
break;
case "dpricedesc":
sort = "p.DetailPrice descending";价格降序
break;
default:
break;
}
public List<ViewICBCProduct> GetProducts(string cp, string sort)
{
using (DavidnileDataContext datacontext = new DavidnileDataContext())
{
var productlist = from p in datacontext.ViewICBCProduct where p.ClassProduct == cp orderby sort descending select p;
return productlist.ToList();
}