分頁只調用一個方法

來源:互聯網
上載者:User
一個分頁寫一個對應的方法,只不過是資料庫表名和欄位名不同,這樣太不專業了。於是把資料庫表名和欄位名當參數提出來,調用方法時再輸進去,這樣類中的方法可移植性就好多了。

類中的代碼: /// <summary>
        /// 分頁綁定資料
        /// </summary>
        /// <param name="PageIndex"></param>
        /// <param name="PageSize"></param>
        /// <returns></returns>
        public DataTable ShowPagesea(int PageIndex, int PageSize,string DataTable,string id)
        {
            string sql = "select top " + PageSize + " * from " + DataTable + " where " + id + " Not in (select top " + (PageIndex - 1) * PageSize + " " + id + " from " + DataTable + " order by " + id + " desc) order by " + id + " desc ";
            DataTable dt = sdh.dbODSGetDataTable(sql, DataTable);
            return dt;
        }
        /// <summary>
        /// 判斷總頁數,分10頁
        /// </summary>
        /// <returns>總頁數</returns>
        public int ShowPageCountsea(string DataTable)
        {
            string sql = "select count(*) from " + DataTable + " ";
            int i = Convert.ToInt32(sdh.dbExecuteSql4Value(sql));
            if (i % 10 == 0)
            {
                i = i / 10;
            }
            else
            {
                i = i / 10 + 1;
            }
            return i;
        }

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.