Hl.DataDbHelper/DbHelper.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace Hl.DataDbHelper
{
    /// <summary>
    /// 数据库操作Interface
    /// </summary>
    public abstract class DbHelper
    {
        /// <summary>
        /// 数据库连接字符串
        /// </summary>
        public abstract string ConnectionStr(string name, bool isDefault);

        /// <summary>
        /// 执行查询
        /// </summary>
        public abstract object ExecuteScalar(string connectionString, CommandType cmdType, string cmdText, IDbDataParameter[] parms);

        /// <summary>
        /// 执行查询
        /// </summary>
        public abstract int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, IDbDataParameter[] parms);

        /// <summary>
        /// 查询数据并返回DataSet
        /// </summary>
        public abstract DataSet ExecuteDataSet(string connectionString, CommandType cmdType, string cmdText, IDbDataParameter[] parms);

        #region "预初始化Command"

        /// <summary>
        /// 预初始化Command
        /// </summary>
        public void PrepareCommand(IDbCommand cmd, IDbConnection conn, IDbTransaction trans, CommandType cmdType, string cmdText, IDbDataParameter[] commandParameters)
        {
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            cmd.Connection = conn;
            cmd.CommandText = cmdText;
            cmd.CommandType = cmdType;
            if (commandParameters != null)
            {
                for (int i = 0, j = commandParameters.Length; i < j; i++)
                {
                    cmd.Parameters.Add(commandParameters[i]);
                }
            }
        }

        #endregion
    }

    /// <summary>
    /// 数据库操作SQLServer