/// <summary> /// 获取我的收藏列表(含分页) /// </summary> /// <param name="userId">用户ID</param> /// <param name="like">模糊条件</param> /// <param name="orderBy">排序条件</param> /// <param name="pagesize">每页条数</param> /// <param name="pagecurrent">当前页</param> /// <param name="db"></param> /// <returns></returns> public List <MyCollectionByLike_Result> GetMyCollectList(string userId, string like, string orderBy, int pagesize, int pagecurrent, JSZX_ResourceEntities db) { List <MyCollectionByLike_Result> models = new List <MyCollectionByLike_Result>(); try { DateTime dt = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); var query = from t in db.MyCollectionByLike(like, dt) select t; //此用户的收藏资源 query = query.Where(t => t.MyUserID.Equals(userId)); //按收藏时间倒序 if (orderBy == "0") { query = query.OrderByDescending(t => t.CreateTime).OrderByDescending(t => t.num); } if (orderBy == "1") { //评价次数 query = query.OrderByDescending(t => t.REVIEW_NUM).OrderByDescending(t => t.num); } else if (orderBy == "2") { //最受好评 query = query.OrderByDescending(t => t.GRADE).OrderByDescending(t => t.num); } else if (orderBy == "3") { //最多浏览 query = query.OrderByDescending(t => t.PAGE_VIEW_NUM).OrderByDescending(t => t.num); } else if (orderBy == "4") { //最多下载 query = query.OrderByDescending(t => t.DOWNLOAD_NUM).OrderByDescending(t => t.num); } //默认按收藏时间倒序 else { query = query.OrderByDescending(t => t.CreateTime).OrderByDescending(t => t.num); } //获取当前页的数据 models = query.Skip((pagecurrent - 1) * pagesize).Take(pagesize).ToList(); } catch (Exception ex) { clsLog.ErrorLog("ResourceList", "GetMyCollectList", "Error! " + ex.Message); } return(models); }
/// <summary> /// 获取我的收藏总数 /// </summary> /// <param name="userId">用户ID</param> /// <param name="like">模糊条件</param> /// <param name="db"></param> /// <returns></returns> public int GetMyCollectCount(string userId, string like, JSZX_ResourceEntities db) { int ret = 0; try { DateTime dt = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd")); var query = from t in db.MyCollectionByLike(like, dt) select t; //此用户的收藏资源 query = query.Where(t => t.MyUserID.Equals(userId)); ret = query.Count(); } catch (Exception ex) { clsLog.ErrorLog("ResourceList", "GetMyCollectCount", "Error! " + ex.Message); } return(ret); }