Linq分页

来源：互联网发布：数据挖掘十大算法书评编辑：程序博客网时间：2024/05/20 02:29
       public void GetCollegeList(HttpContext context)        {            try            {                int pageSize = CF.ToInt(context.Request.QueryString["pageSize"], 0);                int pageIndex = CF.ToInt(context.Request.QueryString["pageIndex"], 0);                 string keywords = context.Request.QueryString["k"];                IQueryable<DLX_CollegeInfo> msgQuery;                if (!string.IsNullOrEmpty(keywords))                {                    msgQuery = from e in _dataContext.DLX_CollegeInfo                               where e.Title.Contains(keywords)                               select e;                }                else                {                    msgQuery = from e in _dataContext.DLX_CollegeInfo                               select e;                }                int totalCount = msgQuery.Count();                List<DLX_CollegeInfo> msgList;                msgList = msgQuery.OrderByDescending(e => e.CreateTime).Skip(pageSize * pageIndex).Take(pageSize).ToList();                if (msgList != null && msgList.Count > 0)                {                    object[] msgObj = new object[msgList.Count];                    for (int i = 0; i < msgList.Count; i++)                    {                        DLX_CollegeInfo msgEntity = msgList[i];                        msgObj[i] = new                        {                            Id = msgEntity.Id,                            Title = msgEntity.Title,                            Content =CF.SubHtmlContentByLength(Convert.ToString( msgEntity.Content), 20),                            ImageUrl = msgEntity.ImageUrl,                            CreateUser = msgEntity.CreateUser,                            CreateTime = msgEntity.CreateTime.ToString("yyyy/MM/dd")                        };                    }                    var resJsonObj = new                    {                        status = "S",                        TotalCount = totalCount,                        CollegeList = msgObj                    };                    context.Response.Write(JsonConvert.SerializeObject(resJsonObj));                }                else                {                    var resJsonObjE = new                    {                        status = "E"                    };                    context.Response.Write(JsonConvert.SerializeObject(resJsonObjE));                }            }            catch (Exception ex)            {                LogHelper.Fatal("GetCollegeList Error", ex);                var resJsonObjE = new                {                    status = "F",                    message = ex.Message                };                context.Response.Write(JsonConvert.SerializeObject(resJsonObjE));            }        }
0 0