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);
}
}
AbstractSqlHelper
最新推荐文章于 2021-10-12 20:41:07 发布