/// <summary> /// 分页查询 /// </summary> /// <param name="sqls">SQL语句</param> /// <param name="pageIndexs">当前页</param> /// <param name="PageSize">每页显示数量</param> /// <param name="pageCount">总条数</param> /// <returns></returns> public List <JMP.MDL.jmp_app_report> SelectList(string sqls, int pageIndexs, int PageSize, out int pageCount) { string sql = string.Format(sqls); SqlParameter[] s = new[] { new SqlParameter("@sqlstr", sql.ToString()), new SqlParameter("@pageIndex", pageIndexs), new SqlParameter("@pageSize", PageSize) }; SqlDataReader reader = DbHelperSQLTotal.RunProcedure("page", s); pageCount = 0; if (reader.NextResult()) { while (reader.Read()) { pageCount = Convert.ToInt32(reader[0].ToString()); } if (reader.NextResult()) { if (reader.HasRows) { dt.Load(reader); } } } reader.Close(); return(DbHelperSQLTotal.ToList <JMP.MDL.jmp_app_report>(dt)); }