DAL/DALHelper.cs

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

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

//如果要从UI中设置数据库，请取消注释下一行，如果从配置中读取，请注释下一行
//#define UISET

using System;
using System.Configuration;
using System.Data;
using System.Data.Common;
using DBUtility;

namespace DAL
{
    public class DALHelper
    {
#if UISET
        public static DbHelper dbHelper;

        /// <summary>
        /// 设置数据库连接
        /// </summary>
        /// <param name="dbType">不区分大小写，可选值：MySql、OleDb、Oracle、SQLite、SqlServer, Ase, DB2,PostgreSql</param>
        /// <param name="connectionString">数据库连接字符串</param>
        public static void SetHelper(string dbType, string connectionString)
        {
            dbHelper = DbHelper.Create(dbType);
            dbHelper.ConnectionString = connectionString;
        }
#else
        public static DbHelper dbHelper = GetHelper("DB");

        /// <summary>
        /// 从Web.config从读取数据库的连接以及数据库类型
        /// </summary>
        private static DbHelper GetHelper(string connectionStringName)
        {
            ConnectionStringSettings connectionSetting = ConfigurationManager.ConnectionStrings[connectionStringName];
            string className = connectionSetting.ProviderName;
            DbHelper db = DbHelper.Create(className);
            db.ConnectionString = connectionSetting.ConnectionString;
            return db;
        }
#endif
        /// <summary>
        /// 对IDataReader读取依次执行事件
        /// </summary>
        public static void ExecuteReaderAction(IDataReader dr, Action<IDataReader> readAction)
        {
            while (dr.Read())
            {
                if (readAction != null) readAction(dr);
            }
        }

        /// <summary>
        /// 对IDataReader读取依次执行事件
        /// </summary>
        public static void ExecuteReaderAction(IDataReader dr, int first, int count, Action<IDataReader> readAction)
        {
            for (int i = 0; i < first; i++)
            {
                if (!dr.Read()) return;