AbstractSqlHelper

来源：互联网发布：川商邮币卡软件下载编辑：程序博客网时间：2024/05/15 04:36
using System;using System.Collections.Generic;using System.Data.SqlClient;using System.Linq;using System.Text;using System.Data;using System.Data.Common;using System.Configuration;namespace TSMS.Common{ //定义一个抽象类    public abstract class AbstractSqlHelper    {           private SqlConnection conn = null;//初始化一个sql连接        /// <summary>        /// 获取连接字符串并打开        /// </summary>        public void GetConnection()        {   //private static string conStr = ConfigurationManager.ConnectionStrings["sqlstr"].ConnectionString;            string strCon = ConfigurationManager.ConnectionStrings["sqlstr"].ConnectionString;            conn = new SqlConnection(strCon);            conn.Open();            if (conn.State!=ConnectionState.Open)            {                conn.Close();                conn.Dispose();            }        }        /// <summary>        /// 关闭连接        /// </summary>        public void CloseConnection()        {            if (conn!=null)            {                conn.Close();                conn.Dispose();            }        }        /// <summary>        /// 设置需要执行的存储过程或语句        /// </summary>        /// <param name="sql"></param>        /// <param name="cmdtype"></param>        /// <param name="pars"></param>        /// <returns></returns>        #region 设置需要执行的存储过程或语句        public SqlCommand GetCommand(string sql, CommandType cmdtype, params SqlParameter[] pars)        {            GetConnection();            SqlCommand cmd = conn.CreateCommand();            cmd.CommandType = cmdtype;            cmd.CommandText = sql;            if (pars != null)            {                cmd.Parameters.AddRange(pars);            }            return cmd;        }        public SqlCommand GetCommand(string sql, CommandType cmdtype, List<SqlParameter> pars)        {            GetConnection();            SqlCommand cmd = conn.CreateCommand();            cmd.CommandType = cmdtype;            cmd.CommandText = sql;            foreach (SqlParameter s in pars)            {                cmd.Parameters.Add(s);            }            return cmd;        }         #endregion        /// <summary>        /// 执行非查询        /// </summary>        /// <param name="sql"></param>        /// <param name="cmdtype"></param>        /// <param name="parameters"></param>        /// <returns></returns>        public abstract bool ExecuteNonQurey(string sql, CommandType cmdtype, params SqlParameter[] parameters);        /// <summary>        /// 查询表通过参数        /// </summary>        /// <param name="sql"></param>        /// <param name="cmdtype"></param>        /// <param name="parameters"></param>        /// <returns>DataSet</returns>        public abstract DataSet GetDataSet(string sql, CommandType cmdtype, params SqlParameter[] parameters);        /// <summary>        /// 查询表通过list泛型集合        /// </summary>        /// <param name="sql"></param>        /// <param name="cmdtype"></param>        /// <param name="list"></param>        /// <returns></returns>        public abstract DataSet GetDataSet(string sql, CommandType cmdtype, List<SqlParameter> list);        /// <summary>        ///  查询表通过参数        /// </summary>        /// <param name="sql"></param>        /// <param name="cmdtype"></param>        /// <param name="parameters"></param>        /// <returns>DataTable</returns>        public abstract DataTable GetDataTable(string sql, CommandType cmdtype, params SqlParameter[] parameters);        public abstract object GetSingleData(string sql, CommandType cmdtype, params SqlParameter[] parameters);        public abstract SqlDataReader GetDataReader(string sql,CommandType cmdtype,params SqlParameter[] parameters);        }}
0 0