App_Code/DDL/D.DBUtility.EN/AccessHelper.cs

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

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

namespace D.DBUtility.EN
{
    using System;
    using System.Collections;
    using System.Data;
    using System.Data.OleDb;
    using System.Configuration;

    public abstract class AccessHelper
    {
        public static readonly string connectionString = ConfigurationManager.ConnectionStrings["DBEN"].ConnectionString;
        private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());

        protected AccessHelper()
        {
        }

        public static void CacheParameters(string cacheKey, params OleDbParameter[] commandParameters)
        {
            parmCache[cacheKey] = commandParameters;
        }

        public static DataTable ExecuteDataTable(string cmdText, string tableName, params OleDbParameter[] commandParameters)
        {
            DataTable dataTable = new DataTable(tableName);
            OleDbDataAdapter adapter = new OleDbDataAdapter();
            OleDbCommand cmd = new OleDbCommand();
            adapter.SelectCommand = cmd;
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                PrepareCommand(cmd, connection, null, CommandType.Text, cmdText, commandParameters);
                adapter.Fill(dataTable);
                cmd.Parameters.Clear();
                return dataTable;
            }
        }

        public static int ExecuteNonQuery(string cmdText, params OleDbParameter[] commandParameters)
        {
            OleDbCommand cmd = new OleDbCommand();
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                PrepareCommand(cmd, connection, null, CommandType.Text, cmdText, commandParameters);
                int num = cmd.ExecuteNonQuery();
                cmd.Parameters.Clear();
                return num;
            }
        }

        public static OleDbDataReader ExecuteReader(string cmdText, params OleDbParameter[] commandParameters)
        {
            OleDbDataReader reader2;
            OleDbCommand cmd = new OleDbCommand();
            OleDbConnection conn = new OleDbConnection(connectionString);
            try
            {
                PrepareCommand(cmd, conn, null, CommandType.Text, cmdText, commandParameters);
                OleDbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                cmd.Parameters.Clear();
                reader2 = reader;