/// <summary>
        /// 執(zhí)行存儲(chǔ)過(guò)程(返回記錄集)
        /// </summary>
        /// <param name="procName">過(guò)程名</param>
        /// <param name="hashtable">傳入的參數(shù)表</param>
        /// <returns>返回記錄集</returns>
        public DataSet ExecProcedure(string procName, System.Collections.Hashtable hashtable)
        {
            System.Data.DataSet ds = new DataSet();
            com.CommandText = procName;
            com.CommandType = CommandType.StoredProcedure;

            System.Collections.IDictionaryEnumerator ide = hashtable.GetEnumerator();

            while (ide.MoveNext())
            {
                System.Data.SqlClient.SqlParameter p = new System.Data.SqlClient.SqlParameter(ide.Key.ToString(), ide.Value);
                com.Parameters.Add(p);
            }
            try
            {
                System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(com);
                da.Fill(ds);
                da.Dispose();
            }
            catch (Exception ee)
            {
                throw new Exception(ee.Message.ToString());
            }
            finally
            {
                com.Cancel();
            }
            return ds;
        }
        #endregion

        #region 數(shù)據(jù)操作
        /// <summary>
        /// 統(tǒng)計(jì)某表記錄總數(shù)
        /// </summary>
        /// <param name="KeyField">主鍵/索引鍵</param>
        /// <param name="TableName">數(shù)據(jù)庫(kù).用戶名.表名</param>
        /// <param name="Condition">查詢條件</param>
        /// <returns>返回記錄總數(shù)</returns>
        public int GetRecordCount(string keyField, string tableName, string condition)
        {
            int RecordCount = 0;
            string sql = "select count(" + keyField + ") as count from " + tableName + " " + condition;
            System.Data.DataSet ds = GetDataSet(sql);
            if (ds.Tables[0].Rows.Count > 0)
            {
                RecordCount =Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            }
            ds.Clear();
            ds.Dispose();
            return RecordCount;
        }
        /// <summary>
        /// 統(tǒng)計(jì)某表記錄總數(shù)
        /// </summary>
        /// <param name="Field">可重復(fù)的字段</param>
        /// <param name="tableName">數(shù)據(jù)庫(kù).用戶名.表名</param>
        /// <param name="condition">查詢條件</param>
        /// <param name="flag">字段是否主鍵</param>
        /// <returns>返回記錄總數(shù)</returns>
        public int GetRecordCount(string Field, string tableName, string condition, bool flag)
        {
            int RecordCount = 0;
            if (flag)
            {
                RecordCount = GetRecordCount(Field, tableName, condition);
            }
            else
            {
                string sql = "select count(distinct(" + Field + ")) as count from " + tableName + " " + condition;
                System.Data.DataSet ds = GetDataSet(sql);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                }
                ds.Clear();
                ds.Dispose();
            }
            return RecordCount;
        }
        /// <summary>
        /// 統(tǒng)計(jì)某表分頁(yè)總數(shù)
        /// </summary>
        /// <param name="keyField">主鍵/索引鍵</param>
        /// <param name="tableName">表名</param>
        /// <param name="condition">查詢條件</param>
        /// <param name="pageSize">頁(yè)寬</param>
        /// <param name="RecordCount">記錄總數(shù)</param>
        /// <returns>返回分頁(yè)總數(shù)</returns>
        public int GetPageCount(string keyField, string tableName, string condition, int pageSize, int RecordCount)
        {
            int PageCount = 0;
            PageCount = (RecordCount % pageSize) > 0 ? (RecordCount / pageSize) + 1 : RecordCount / pageSize;
            if (PageCount < 1) PageCount = 1;
            return PageCount;
        }
        /// <summary>
        /// 統(tǒng)計(jì)某表分頁(yè)總數(shù)
        /// </summary>
        /// <param name="keyField">主鍵/索引鍵</param>
        /// <param name="tableName">表名</param>
        /// <param name="condition">查詢條件</param>
        /// <param name="pageSize">頁(yè)寬</param>
        /// <returns>返回頁(yè)面總數(shù)</returns>
        public int GetPageCount(string keyField, string tableName, string condition, int pageSize, ref int RecordCount)
        {
            RecordCount = GetRecordCount(keyField, tableName, condition);
            return GetPageCount(keyField, tableName, condition, pageSize, RecordCount);
        }
        /// <summary>
        /// 統(tǒng)計(jì)某表分頁(yè)總數(shù)
        /// </summary>
        /// <param name="Field">可重復(fù)的字段</param>
        /// <param name="tableName">表名</param>
        /// <param name="condition">查詢條件</param>
        /// <param name="pageSize">頁(yè)寬</param>
        /// <param name="flag">是否主鍵</param>
        /// <returns>返回頁(yè)頁(yè)總數(shù)</returns>
        public int GetPageCount(string Field, string tableName, string condition, ref int RecordCount, int pageSize, bool flag)
        {
            RecordCount = GetRecordCount(Field, tableName, condition, flag);
            return GetPageCount(Field, tableName, condition, pageSize, ref RecordCount);
        }
        #endregion

        #region 分頁(yè)函數(shù)
         /// <summary>
        /// 構(gòu)造分頁(yè)查詢SQL語(yǔ)句
        /// </summary>
        /// <param name="KeyField">主鍵</param>
        /// <param name="FieldStr">所有需要查詢的字段(field1,field2...)</param>
        /// <param name="TableName">庫(kù)名.擁有者.表名</param>
        /// <param name="Condition">查詢條件1(where ...)</param>
        /// <param name="Condition2">查詢條件2(order by ...)</param>
        /// <param name="CurrentPage">當(dāng)前頁(yè)號(hào)</param>
        /// <param name="PageSize">頁(yè)寬</param>
        /// <returns>SQL語(yǔ)句</returns>
        public static string JoinPageSQL(string KeyField, string FieldStr, string TableName, string Condition, string Condition2, int CurrentPage, int PageSize)
        {
            string sql = null;
            if (CurrentPage == 1)
            {
                sql = "select top " + CurrentPage * PageSize + " " + FieldStr + " from " + TableName + " " + Condition + " " + Condition2 + " ";
            }
            else
            {
                sql = "select * from (";
                sql += "select top " + CurrentPage * PageSize + " " + FieldStr + " from " + TableName + " " + Condition + " " + Condition2 + ") a ";
                sql += "where " + KeyField + " not in (";
                sql += "select top " + (CurrentPage - 1) * PageSize + " " + KeyField + " from " + TableName + " " + Condition + " " + Condition2 + ")";
            }
            return sql;
        }
        /// <summary>
        /// 構(gòu)造分頁(yè)查詢SQL語(yǔ)句
        /// </summary>
        /// <param name="Field">字段名(非主鍵)</param>
        /// <param name="TableName">庫(kù)名.擁有者.表名</param>
        /// <param name="Condition">查詢條件1(where ...)</param>
        /// <param name="Condition2">查詢條件2(order by ...)</param>
        /// <param name="CurrentPage">當(dāng)前頁(yè)號(hào)</param>
        /// <param name="PageSize">頁(yè)寬</param>
        /// <returns>SQL語(yǔ)句</returns>
        public static string JoinPageSQL(string Field, string TableName, string Condition, string Condition2, int CurrentPage, int PageSize)
        {
            string sql = null;
            if (CurrentPage == 1)
            {
                sql = "select top " + CurrentPage * PageSize + " " + Field + " from " + TableName + " " + Condition + " " + Condition2 + " group by " + Field;
            }
            else
            {
                sql = "select * from (";
                sql += "select top " + CurrentPage * PageSize + " " + Field + " from " + TableName + " " + Condition + " " + Condition2 + " group by " + Field + " ) a ";
                sql += "where " + Field + " not in (";
                sql += "select top " + (CurrentPage - 1) * PageSize + " " + Field + " from " + TableName + " " + Condition + " " + Condition2 + " group by " + Field + ")";
            }
            return sql;
        }
        /// <summary>
        /// 頁(yè)面分頁(yè)顯示功能
        /// </summary>
        /// <param name="Parameters">參數(shù)串(a=1&amp;b=2...)</param>
        /// <param name="RecordCount">記錄總數(shù)</param>
        /// <param name="PageSize">頁(yè)寬</param>
        /// <param name="CurrentPage">當(dāng)前頁(yè)號(hào)</param>
        /// <param name="ShowJump">是否顯示跳轉(zhuǎn)輸入框及按鈕</param>
        /// <param name="Style">樣式(1:上頁(yè)下頁(yè)...,2:1234...)</param>
        /// <returns></returns>
        public static string Paging(string Parameters, int RecordCount, int PageCount, int PageSize, int CurrentPage, bool ShowJump, int Style)
        {
            string str;
            if (RecordCount <= PageSize) return "";
            if (Parameters != "") Parameters += "&";
            if (CurrentPage < 1) CurrentPage = 1;
            if (CurrentPage > PageCount) CurrentPage = PageCount;

            str = "<table align='center'  width=\"100%\"><tr><td align=\"center\">";

            str += "共 " + RecordCount + " 條記錄 頁(yè)次：" + CurrentPage + "/" + PageCount + "頁(yè) ";
            str += PageSize + "條/頁(yè) ";

            if (Style == 1)
            {
                if (CurrentPage == 1)
                    str += "<font color=\"#999999\">首頁(yè) 上頁(yè)</font> ";
                else
                {
                    str += "<a href='?" + Parameters + "page=1'  class=\"link\">首頁(yè)</a> ";
                    str += "<a href='?" + Parameters + "page=" + (CurrentPage - 1) + "'  class=\"link\">上頁(yè)</a> "; ;
                }
                if (CurrentPage == PageCount )
                {
                    str += "<font color=\"#999999\">下頁(yè) 尾頁(yè)</font> ";
                }
                else
                {
                    str += "<a href='?" + Parameters + "page=" + (CurrentPage + 1) + "'  class=\"link\">下頁(yè)</a> ";
                    str += "<a href='?" + Parameters + "page=" + PageCount + "'  class=\"link\">尾頁(yè)</a>  ";
                }
            }
            else if (Style == 2)
            {
                int NumberSize = 10;
                int PageNumber = (CurrentPage - 1) / NumberSize;

                if (PageNumber * NumberSize > 0)
                    str += "<a href='?" + Parameters + "page=" + PageNumber * NumberSize + "' title=上十頁(yè) >[&lt;&lt;]</a>   ";
                int i;
                for (i = PageNumber * NumberSize + 1; i <= (PageNumber + 1) * NumberSize; i++)
                {
                    if (i == CurrentPage)
                        str += "<strong><font color=#ff0000>[" + i + "]</font></strong> ";
                    else
                        str += "<a href='?" + Parameters + "page=" + i + "'>[" + i + "]</a> ";
                    if (i == PageCount) break;
                }
                if (i < RecordCount) str += "<a href='?" + Parameters + "page=" + i + "' title=下十頁(yè)>[&gt;&gt;]</a>  ";
            }
            if (ShowJump)
            {
                str += "";
            }
            str += "</td></tr></table>";
            return str;
        }

        #endregion
    }
}