Core/DBObject.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using DataObject.Param;
using DataObject.Dele;

namespace DataObject.Core
{
    /// <summary>
    /// mssql数据访问层
    /// </summary>
    public class DBObject : DBBase
    {
        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="constring">连接数据库字符串</param>
        public DBObject(string constring)
        {
            Connection = new SqlConnection(constring);
        }

        /// <summary>
        /// 代理操作数据
        /// </summary>
        private delegate void Operate(SqlDataReader dataReader);

        /// <summary>
        /// 设置数据库执行体（存储过程/脚本）
        /// </summary>
        /// <param name="storedProcName">存储过程名称</param>
        /// <param name="comType">执行类型</param>
        /// <param name="parameters">参数</param>
        /// <returns>执行命令</returns>
        private SqlCommand BuildQueryCommand(string storedProcName,CommandType comType, params IDataParameter[] parameters)
        {
            SqlCommand command = new SqlCommand(storedProcName, Connection as SqlConnection) { CommandType = comType, CommandTimeout = Timeout };
            if (parameters != null) command.Parameters.AddRange(parameters);
            return command;
        }

        /// <summary>
        /// 设置数据库执行体（存储过程）
        /// </summary>
        /// <param name="storedProcName">存储过程名称</param>
        /// <param name="parameters">参数</param>
        /// <returns>执行命令</returns>
        private SqlCommand BuildQueryCommand(string storedProcName, params IDataParameter[] parameters) {
            return BuildQueryCommand(storedProcName, CommandType.StoredProcedure, parameters);
        }

        /// <summary>
        /// 数据库执行体（存储过程/脚本），增加返回值
        /// </summary>
        /// <param name="storedProcName">存储过程名</param>
        /// <param name="comType">执行体命令类型</param>
        /// <param name="parameters">参数</param>
        /// <returns>执行命令</returns>
        private SqlCommand BuildIntCommand(string storedProcName, CommandType comType, params IDataParameter[] parameters)
        {