NetSkycn.Data/SqlDatabase.cs

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

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

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

namespace NetSkycn.Data
{
    public sealed class SqlDatabase
    {
        /// <summary>
        /// 构造函数
        /// </summary>
        public SqlDatabase()
        {
        }

        /// <summary>
        /// 生成SqlCommandWrapper实例，此实例执行存储过程
        /// </summary>
        /// <param name="storedProcedureName">存储过程名称</param>
        /// <returns>SqlCommandWrapper实例</returns>
        public SqlCommandWrapper GetStoredProcCommandWrapper(string storedProcedureName)
        {
            return new SqlCommandWrapper(storedProcedureName, CommandType.StoredProcedure);
        }

        public SqlCommandWrapper GetStoredProcCommandWrapper(string storedProcedureName, string connectionString)
        {
            return new SqlCommandWrapper(storedProcedureName, CommandType.StoredProcedure, connectionString);
        }

        /// <summary>
        /// 生成SqlCommandWrapper实例，此实例执行存储过程
        /// </summary>
        /// <param name="storedProcedureName">存储过程名称</param>
        /// <param name="parameterValues">存储过程需要的参数</param>
        /// <returns>SqlCommandWrapper实例</returns>
        public SqlCommandWrapper GetStoredProcCommandWrapper(string storedProcedureName, params object[] parameterValues)
        {
            return new SqlCommandWrapper(storedProcedureName, CommandType.StoredProcedure, parameterValues);
        }
        /// <summary>
        /// 生成SqlCommandWrapper实例，此实例执行存储过程
        /// </summary>
        /// <param name="storedProcedureName">存储过程名称</param>
        /// <param name="connectionString">数据库连接字符串</param>
        /// <param name="parameterValues">存储过程需要的参数</param>
        /// <returns></returns>
        public SqlCommandWrapper GetStoredProcCommandWrapper(string storedProcedureName,string connectionString, params object[] parameterValues)
        {
            return new SqlCommandWrapper(storedProcedureName, CommandType.StoredProcedure, parameterValues,connectionString);
        }

        /// <summary>
        /// 生成SqlCommandWrapper实例，此实例执行SQL语句而非存储过程
        /// </summary>
        /// <param name="query">sql语句</param>
        /// <returns>SqlCommandWrapper实例</returns>
        public SqlCommandWrapper GetSqlStringCommandWrapper(string query)