/// <summary>
/// 统计报表
/// </summary>
/// <param name="orderBy"></param>
/// <param name="db"></param>
/// <returns></returns>
public List <ResStatistics_Result> statisticsInfo(string orderBy, JSZX_ResourceEntities db)
{
List <ResStatistics_Result> vs = new List <ResStatistics_Result>();
var query = from t in db.ResStatistics() select t;
//按上传最多
if (orderBy == "1")
{
//上传最多
query = query.OrderByDescending(t => t.allFile);
}
else if (orderBy == "2")
{
//最受好评
query = query.OrderByDescending(t => t.PRAISE_PRE);
}
else if (orderBy == "3")
{
//最多浏览
query = query.OrderByDescending(t => t.VIEW_NUM);
}
else if (orderBy == "4")
{
//最多下载
query = query.OrderByDescending(t => t.DOWNLOAD_NUM);
}
//默认按老师排序
else
{
query = query.OrderBy(t => t.CREATEID);
}
vs = query.ToList();
return(vs);
}