Common/DALBase.cs

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

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

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

namespace Common
{
    /// <summary>
    /// DAL基类
    /// </summary>
    public class DALBase
    {
        private string _connStr;   //数据库联接字符串
        private SqlParameterList _parameterList = new SqlParameterList();   //参数列表
        private static CommandType cmdType = CommandType.StoredProcedure;   //存储过程命令
        private static CommandType cmdTypeSQL = CommandType.Text;           //SQL语句命令，增加于2009-11-25日


        /// <summary>
        /// 根据命令返回数据集
        /// </summary>
        /// <param name="cmdText"></param>
        /// <returns></returns>
        protected DataSet ExecuteDataSet(string cmdText)
        {
            return SqlHelper.ExecuteDataset(this._connStr, cmdType, cmdText, this._parameterList.ToArray());
        }

        /// <summary>
        /// 返回数据表
        /// </summary>
        /// <param name="cmdText"></param>
        /// <returns></returns>
        protected DataTable ExecuteDataTable(string cmdText)
        {
            return SqlHelper.ExecuteDataset(this._connStr, cmdType, cmdText, this._parameterList.ToArray()).Tables[0];
        }

        /// <summary>
        /// 返回数据表
        /// </summary>
        /// <param name="commandType"></param>
        /// <param name="cmdText"></param>
        /// <returns></returns>
        protected DataTable ExecuteDataTable(CommandType commandType, string cmdText)
        {
            return SqlHelper.ExecuteDataset(this._connStr, cmdType, cmdText, this._parameterList.ToArray()).Tables[0];
        }

        /// <summary>
        /// 执行查询
        /// </summary>
        /// <param name="cmdText"></param>
        /// <returns></returns>
        protected int ExecuteNonQuery(string cmdText)
        {
            return SqlHelper.ExecuteNonQuery(this._connStr, cmdType, cmdText, this._parameterList.ToArray());
        }

        /// <summary>
        /// 执行查询