分页方法

        //2010/03/30 添加
        public DataSet Universal_infolist(string tablename, string wherestr, string oid, string oway, int pagesize, int pageindex, ref int recordcount)
        {
            SqlParameter[] commandParameters = new SqlParameter[]{new SqlParameter("@tablename",tablename),new SqlParameter("@wherestr",wherestr),new SqlParameter("@oid",oid),new SqlParameter("@oway",oway),
                new SqlParameter("@pagesize",pagesize),new SqlParameter("@pageindex",pageindex),new SqlParameter("@recordcount",recordcount) };
            DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringKy,CommandType.StoredProcedure,"Universal_Infolist", commandParameters);
            recordcount = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
            return ds;
        }

        //2011/02/15 添加
        public DataSet Universal_infolist_1(string tablename, string wherestr, string oid, string oway, int pagesize, int pageindex, ref int recordcount)
        {
            SqlParameter[] commandParameters = new SqlParameter[]{new SqlParameter("@tablename",tablename),new SqlParameter("@wherestr",wherestr),new SqlParameter("@oid",oid),new SqlParameter("@oway",oway),
                new SqlParameter("@pagesize",pagesize),new SqlParameter("@pageindex",pageindex),new SqlParameter("@recordcount",recordcount) };
            DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Universal_Infolist_1", commandParameters);
            recordcount = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
            return ds;
        }