layui maysql 分页

 public static string getPageData(this Models.model_For_PageData model)
        {
            int totalcount = DBHelper.GetSingle("select count(0) from(" + model._sql + ")a").ToInt32();
            string sql_withPageNum = @"SELECT * FROM(" + model._sql + @" limit " + (model._pageIndex - 1) * model._pageSize + "," + model._pageSize + ") A";
            DataTable tmp = DBHelper.getDataTable(sql_withPageNum);
            return @"{""code"":""0"",""msg"":"""",""count"":""" + totalcount + @""",""data"":" + JsonConvert.SerializeObject(tmp) + "}";
        }

 

public class model_For_PageData
    {
        private string sql = "";
        /// <summary>
        /// 查询的sql语句
        /// </summary>
        public string _sql { get { return sql; } set { sql = value; } }

        private List<DbParameter> parameters = new List<DbParameter>();
        /// <summary>
        /// 查询的sql语句的参数
        /// </summary>
        public List<DbParameter> _parameters { get { return parameters; } set { parameters = value; } }

        private int pageSize = 10;
        /// <summary>
        /// 每页显示的数据量，默认为10
        /// </summary>
        public int _pageSize { get { return pageSize; } set { pageSize = value; } }

        private int pageIndex = 1;
        /// <summary>
        /// 当前第几页，默认为1
        /// </summary>
        public int _pageIndex { get { return pageIndex; } set { pageIndex = value; } }
    }