多条件分页存储过程PageCommon写法

public static PageList<T> GetStudentInfos<T>(ParamModel model)
        {
            SqlParameter[] prms = new SqlParameter[7];
            prms[0] = new SqlParameter("@tableName", model.TableName);
            prms[1] = new SqlParameter("@indexCol", model.IndexCol);
            prms[2] = new SqlParameter("@pageSize", model.PageSize);
            prms[3] = new SqlParameter("@pageIndex", model.PageIndex);
            prms[4] = new SqlParameter("@orderCol", model.OrderCol);
            prms[5] = new SqlParameter("@where", model.StrWhere);
            prms[6] = new SqlParameter("@columns", model.Columns);

            DataSet ds = DbHelperSQL.ExecuteDataset(DbHelperSQL.ConnB2c, CommandType.StoredProcedure, "p_paging", prms);

            var list = JsonConvert.DeserializeObject<List<T>>(JsonConvert.SerializeObject(ds.Tables[0]));

            PageList<T> pagelist = new PageList<T>();

            pagelist.listData = list;
            pagelist.TotalCount = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
            return pagelist;

        }

原文地址:https://www.cnblogs.com/jcy1/p/9524139.html