/// <summary> /// 根据字段列表,条件,排序,每页记录数,页码(从1开始),分页读取记录 /// </summary> /// <param name="columslist">字段列表,如:Id,姓名,性别,年龄</param> /// <param name="strWhere">条件,如:年龄>12 and 性别='女'</param> /// <param name="filedOrder">排序,如: Id desc </param> /// <param name="PageSize">每页记录数,如:30</param> /// <param name="PageIndex">页码,如:2</param> /// <returns></returns> public DataSet GetListByPageColumns(string columslist, string strWhere, string orderby, int PageSize, int PageIndex) { string strsql = DbHelperMySQL.GetListByPageColumns(columslist, strWhere, orderby, PageSize, PageIndex, "zt_cpruku"); return DbHelperMySQL.Query(strsql); }
/// <summary> /// 根据字段列表,条件,排序,每页记录数,页码(从1开始),分页读取记录 /// </summary> /// <param name="columslist">字段列表,如:Id,姓名,性别,年龄</param> /// <param name="strWhere">条件,如:年龄>12 and 性别='女'</param> /// <param name="filedOrder">排序,如: Id desc </param> /// <param name="PageSize">每页记录数,如:30</param> /// <param name="PageIndex">页码,如:2</param> /// <returns></returns> public DataSet GetListByPageColumns(string columslist, string strWhere, string orderby, int PageSize, int PageIndex) { string strsql = DbHelperMySQL.GetListByPageColumns(columslist, strWhere, orderby, PageSize, PageIndex, "tb_navigation"); return(DbHelperMySQL.Query(strsql)); }