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