Esempio n. 1
0
        /// <summary>
        /// 分页获取数据
        /// </summary>
        /// <param name="where">条件</param>
        /// <param name="order">排序</param>
        /// <param name="page">当前页数</param>
        /// <param name="pagesize">分页大小</param>
        /// <returns></returns>
        public virtual TabledList <Model.Model> GetModelList(string where, string order, int page, int pagesize)
        {
            string sql = SqlProviders.Current.BuildSelectSQL(ModelType);

            if (!string.IsNullOrWhiteSpace(where))
            {
                sql += " where " + where;
            }
            if (string.IsNullOrWhiteSpace(order))
            {
                order = "ID";
            }
            var countSql    = SqlProviders.Current.CreateCountingSql(sql);
            var rcount      = DataAccessProvider.Current.ExecuteSingle(countSql);
            int recordCount = rcount == null ? 0 : (int)rcount;


            sql = SqlProviders.Current.CreatePagingSql(recordCount, pagesize, page, sql, order);

            var dt = DataAccessProvider.Current.Query(sql);
            var ls = SqlProviders.Current.TableToModelList(ModelType, dt);
            TabledList <Model.Model> tabledList = new TabledList <Model.Model>(ls, ModelType, page, pagesize, recordCount);

            return(tabledList);
        }
Esempio n. 2
0
        public static MvcHtmlString Gird(this HtmlHelper helper, TabledList<Model> tabledList)
        {
            Gird gird = new Gird(tabledList);
            PagedList<Model> pagedlist = new PagedList<Model>(tabledList, tabledList.Page, tabledList.PageSize, tabledList.RecordCount);
            gird.Pagers = helper.Pager(pagedlist, new PagerOptions()
            {
                AutoHide = false,
                ContainerTagName = "span",
                CssClass = "pull-right"
            }).ToHtmlString();

            return new MvcHtmlString(gird.Reader());
        }
Esempio n. 3
0
        public static MvcHtmlString Gird(this HtmlHelper helper, TabledList <Model> tabledList)
        {
            Gird gird = new Gird(tabledList);
            PagedList <Model> pagedlist = new PagedList <Model>(tabledList, tabledList.Page, tabledList.PageSize, tabledList.RecordCount);

            gird.Pagers = helper.Pager(pagedlist, new PagerOptions()
            {
                AutoHide         = false,
                ContainerTagName = "span",
                CssClass         = "pull-right"
            }).ToHtmlString();

            return(new MvcHtmlString(gird.Reader()));
        }
Esempio n. 4
0
 public Gird(TabledList<Model.Model> Source)
 {
     Source.TableID = Guid.NewGuid().ToString();
     this.Source = Source;
 }
Esempio n. 5
0
 public Gird(TabledList <Model.Model> Source)
 {
     Source.TableID = Guid.NewGuid().ToString();
     this.Source    = Source;
 }
Esempio n. 6
0
        /// <summary>
        /// 分页获取数据
        /// </summary>
        /// <param name="where">条件</param>
        /// <param name="order">排序</param>
        /// <param name="page">当前页数</param>
        /// <param name="pagesize">分页大小</param>
        /// <returns></returns>
        public virtual TabledList<Model.Model> GetModelList(string where, string order, int page, int pagesize)
        {
            string sql = SqlProviders.Current.BuildSelectSQL(ModelType);
            if (!string.IsNullOrWhiteSpace(where))
            {
                sql += " where " + where;
            }
            if (string.IsNullOrWhiteSpace(order))
            {

                order = "ID";
            }
            var countSql = SqlProviders.Current.CreateCountingSql(sql);
            var rcount = DataAccessProvider.Current.ExecuteSingle(countSql);
            int recordCount = rcount == null ? 0 : (int)rcount;

            sql = SqlProviders.Current.CreatePagingSql(recordCount, pagesize, page, sql, order);

            var dt = DataAccessProvider.Current.Query(sql);
            var ls = SqlProviders.Current.TableToModelList(ModelType, dt);
            TabledList<Model.Model> tabledList = new TabledList<Model.Model>(ls, ModelType, page, pagesize, recordCount);

            return tabledList;
        }