dbhelpers.cs

不错的 漂亮分类源代码 很又用

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

namespace JohnTree.Library
{
    public class DbHelpers : DBConfig
    {
        #region Helpers

        public IDataReader GetReader( CommandType commandType, string sql )
        {
            return SqlHelper.ExecuteReader(ConnectionString, commandType, sql);
        }

        public IDataReader GetReader( CommandType commandType, string sql, SqlParameter[] p )
        {
            return SqlHelper.ExecuteReader(ConnectionString, commandType, sql, p);
        }

        public DataSet GetDataset( CommandType commandType, string sql )
        {
            return SqlHelper.ExecuteDataset(ConnectionString, commandType, sql);
        }

        public DataSet GetDataset( CommandType commandType, string sql, SqlParameter[] p )
        {
            return SqlHelper.ExecuteDataset(ConnectionString, commandType, sql, p);
        }

        public int NonQueryInt( CommandType commandType, string sql )
        {
            return SqlHelper.ExecuteNonQuery(ConnectionString, commandType, sql);
        }

        public int NonQueryInt( CommandType commandType, string sql, SqlParameter[] p )
        {
            return SqlHelper.ExecuteNonQuery(ConnectionString, commandType, sql, p);
        }

        public bool NonQueryBool( CommandType commandType, string sql )
        {
            return NonQueryInt(commandType, sql) > 0;
        }

        public bool NonQueryBool( CommandType commandType, string sql, SqlParameter[] p )
        {
            return NonQueryInt(commandType, sql, p) > 0;
        }

        public object NonQueryScalar( CommandType commandType, string sql )
        {
            return SqlHelper.ExecuteScalar(ConnectionString, commandType, sql);
        }

        public object NonQueryScalar( CommandType commandType, string sql, SqlParameter[] p )
        {
            return SqlHelper.ExecuteScalar(ConnectionString, commandType, sql, p);
        }

        #endregion
    }
}