NetSkycn.Data/SqlCommandWrapper.cs

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

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

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

namespace NetSkycn.Data
{
    /// <summary>
    /// 对SqlCommand进行了一次封装
    /// </summary>
    public sealed class SqlCommandWrapper:IDisposable
    {
        private string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        private SqlCommand command;
        private int rowsAffected;
        private object[] parameterValues;
        private bool needsParameters = false;
        private char parameterToken;
        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="commandText">查询的存储过程名称或SQL语句</param>
        /// <param name="commandType">指定是存储过程类型还是SQL语句类型</param>
        /// <param name="connectionString">数据库连接字符串</param>
        internal SqlCommandWrapper(string commandText, CommandType commandType, string connectionString)
        {
            parameterToken = '@';
            this.connectionString = connectionString;
            this.Command = CreateCommand(commandText, commandType);
        }
        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="commandText">查询的存储过程名称或SQL语句</param>
        /// <param name="commandType">指定是存储过程类型还是SQL语句类型</param>
        internal SqlCommandWrapper(string commandText, CommandType commandType)
        {
            this.parameterToken = '@';
            this.command = CreateCommand(commandText, commandType);
        }

        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="commandText">查询的存储过程名称或SQL语句</param>
        /// <param name="commandType">指定是存储过程类型还是SQL语句类型</param>
        /// <param name="parameterValues">参数</param>
        internal SqlCommandWrapper(string commandText, CommandType commandType, object[] parameterValues)
            : this(commandText, commandType)
        {
            this.parameterValues = parameterValues;
            if (commandType == CommandType.StoredProcedure)
            {
                needsParameters = true;
            }
        }
        /// <summary>
        /// 构造函数
        /// </summary>