NetSkycn.Data/OleDatabase.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace NetSkycn.Data
{
    public sealed class OleDatabase
    {
        public OleDatabase()
        {
        }
        /// <summary>
        /// 生成OleCommandWrapper实例
        /// </summary>
        /// <param name="commandText">要执行的SQL语句</param>
        /// <returns></returns>
        public OleCommandWrapper GetOleCommandWrapper(string commandText)
        {
            return new OleCommandWrapper(commandText);
        }
        /// <summary>
        /// 生成OleCommandWrapper实例
        /// </summary>
        /// <param name="commandText">要执行的SQL语句</param>
        /// <param name="connectionString">数据库连接字符串</param>
        /// <returns></returns>
        public OleCommandWrapper GetOleCommandWrapper(string commandText,string connectionString)
        {
            return new OleCommandWrapper(commandText, connectionString);
        }

        /// <summary>
        /// 执行不带参数的存储过程,返回受影响的行数
        /// </summary>
        /// <param name="cmd">OleCommandWrapper的实例</param>
        /// <returns>受影响的行数</returns>
        public int ExecuteNonQuery(OleCommandWrapper cmd)
        {
            using (cmd)
            {
                if (cmd.Command.Connection.State != ConnectionState.Open)
                {
                    cmd.Command.Connection.Open();
                }
                cmd.RowsAffected = cmd.Command.ExecuteNonQuery();
                return cmd.RowsAffected;
            }
        }

        /// <summary>
        /// 返回一个查询的结果集
        /// </summary>
        /// <param name="cmd">OleCommandWrapper的实例</param>
        /// <returns>以DataTable的形式返回这个结果集</returns>
        public DataTable GetDataTable(OleCommandWrapper cmd)
        {
            using (cmd)
            {