linq分页查询

internal static Votes.Model.Page.PageInfo<T> GetPageData(int pageIndex, int pageSize, Func<T, bool> sqlWhere, Func<T, object> orderBy) {
            using (DataContext db = new DataContext(Votes.Common.Utility.Util.ConnectionString())) {
                //System.IO.StreamWriter sw = new System.IO.StreamWriter(System.Web.HttpContext.Current.Server.MapPath("~/log.txt"), true);
                //db.Log = sw;
                var query = from data in db.GetTable<T>() select data;

                //if (sqlWhere != null) {
                //    query.Where(sqlWhere);
                //}
                //if (orderBy != null) {
                //    query.OrderByDescending(orderBy);
                //}
                var list = query.Where(sqlWhere == null ? new Func<T, bool>(l => 1 == 1) : sqlWhere).OrderByDescending(orderBy == null ? new Func<T, object>(l => l) : orderBy);

                Votes.Model.Page.PageInfo<T> page = new Votes.Model.Page.PageInfo<T>();
                page.TotalRecord = list.Count();//这里算总记录数时候 跟踪数据库发现sql语句没有带where条件
                page.PageIndex = pageIndex;
                page.PageSize = pageSize;
                page.PageCount = (int)Math.Ceiling((page.TotalRecord + 0.0) / pageSize);
                page.DataSource = list.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList();//这里也是
                //sw.Dispose();
                //sw.Close();
//总共执行2条sql语句 都木有带条件 到底应该怎么写呢？
                return page;
             }
        }

该回复于2011-12-21 11:55:21被管理员删除