Webapi+Dapper+Layui多表分页查询

//使用之前先引入Dapper

       //js的URL请求接口
        public HttpResponseMessage GetList()
        {
            HttpContext context = HttpContext.Current;
            var pagesize = Convert.ToInt32(context.Request.QueryString["limit"].ToString());
            var pageindex = Convert.ToInt32(context.Request.QueryString["page"].ToString());
            DataDAL dal= new DataDAL ();
            int count = 0;
            var list = dal.GetTable(pageindex, pagesize,  out count);
            if (list != null && list.Count > 0)
            {
                return SuccNo.SuccListReturn(list, count);
            }
            else
            {
                return SuccNo.NoListReturn();
            }
        }

//使用dapper自带的方法传参
        public List<实体类> LoadData(int pageindex, int pagesize,  out int totlecount)
        {
            var file = "theser,A_Id,A_Name,A_Grade,A_FatherId,A_IsFather,A_IsChild,url,Icon,R_Name";//列名
            var files = "a.theser,a.A_Id,A_Name,A_Grade,A_FatherId,A_IsFather,A_IsChild,url,Icon,R_Name";//联表后的列名
            var tablename = "tb_U_Authority a,[tb_U_Role] b"; //表名
            var where = "a.A_Id=b.A_Id"; //条件
            var orderby = "A_IsFather DESC"; //排序

            var data = DbHelper.GetPageList<Table>(file,files, tablename, where, orderby, pageindex, pagesize, out totlecount);//查询数据
            var listdata = data.ToList();
            return listdata;
        }