/// <summary>
/// 获取第一行第一列
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public object GetScalar(string sql, params SqlParameter[] pars)
{
ExecLogEvent(sql, pars, true);
SqlCommand sqlCommand = new SqlCommand(sql, _sqlConnection);
if (_tran != null)
{
sqlCommand.Transaction = _tran;
}
sqlCommand.CommandTimeout = this.CommandTimeOut;
if (pars != null)
{
sqlCommand.Parameters.AddRange(pars);
}
if (IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(sqlCommand.Parameters);
}
object scalar = sqlCommand.ExecuteScalar();
scalar = (scalar == null ? 0 : scalar);
sqlCommand.Parameters.Clear();
ExecLogEvent(sql, pars, false);
return(scalar);
}
/// <summary>
/// 获取DataReader
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public SqlDataReader GetReader(string sql, params SqlParameter[] pars)
{
ExecLogEvent(sql, pars, true);
SqlCommand sqlCommand = new SqlCommand(sql, _sqlConnection);
sqlCommand.CommandType = CommandType;
sqlCommand.CommandTimeout = this.CommandTimeOut;
if (_tran != null)
{
sqlCommand.Transaction = _tran;
}
if (pars != null)
{
sqlCommand.Parameters.AddRange(pars);
}
if (IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(sqlCommand.Parameters);
}
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
if (IsClearParameters)
{
sqlCommand.Parameters.Clear();
}
ExecLogEvent(sql, pars, false);
return(sqlDataReader);
}
/// <summary>
/// 获取DataSet
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public virtual DataSet GetDataSetAll(string sql, params SqlParameter[] pars)
{
SetCurrentConnection(false);
ExecLogEvent(sql, pars, true);
SqlDataAdapter _sqlDataAdapter = new SqlDataAdapter(sql, _sqlConnection);
if (_tran != null)
{
_sqlDataAdapter.SelectCommand.Transaction = _tran;
}
if (this.IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(_sqlDataAdapter.SelectCommand.Parameters);
}
_sqlDataAdapter.SelectCommand.CommandTimeout = this.CommandTimeOut;
_sqlDataAdapter.SelectCommand.CommandType = this.CommandType;
if (pars != null)
{
_sqlDataAdapter.SelectCommand.Parameters.AddRange(pars);
}
CheckConnect();
DataSet ds = new DataSet();
_sqlDataAdapter.Fill(ds);
if (this.IsClearParameters)
{
_sqlDataAdapter.SelectCommand.Parameters.Clear();
}
ExecLogEvent(sql, pars, false);
return(ds);
}
/// <summary>
/// 执行SQL返回受影响行数
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public virtual int ExecuteCommand(string sql, params SqlParameter[] pars)
{
SetCurrentConnection(true);
ExecLogEvent(sql, pars, true);
SqlCommand sqlCommand = new SqlCommand(sql, _sqlConnection);
sqlCommand.CommandType = this.CommandType;
sqlCommand.CommandTimeout = this.CommandTimeOut;
if (_tran != null)
{
sqlCommand.Transaction = _tran;
}
if (pars != null)
{
sqlCommand.Parameters.AddRange(pars);
}
if (this.IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(sqlCommand.Parameters);
}
CheckConnect();
int count = sqlCommand.ExecuteNonQuery();
if (this.IsClearParameters)
{
sqlCommand.Parameters.Clear();
}
ExecLogEvent(sql, pars, false);
return(count);
}
/// <summary>
/// 获取DataTable
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public DataTable GetDataTable(string sql, params SqlParameter[] pars)
{
ExecLogEvent(sql, pars, true);
SqlDataAdapter _sqlDataAdapter = new SqlDataAdapter(sql, _sqlConnection);
_sqlDataAdapter.SelectCommand.CommandType = CommandType;
_sqlDataAdapter.SelectCommand.Parameters.AddRange(pars);
if (IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(_sqlDataAdapter.SelectCommand.Parameters);
}
_sqlDataAdapter.SelectCommand.CommandTimeout = this.CommandTimeOut;
if (_tran != null)
{
_sqlDataAdapter.SelectCommand.Transaction = _tran;
}
DataTable dt = new DataTable();
_sqlDataAdapter.Fill(dt);
if (IsClearParameters)
{
_sqlDataAdapter.SelectCommand.Parameters.Clear();
}
ExecLogEvent(sql, pars, false);
return(dt);
}
public int ExecuteCommand(string sql, params SqlParameter[] pars)
{
SqlCommand sqlCommand = new SqlCommand(sql, _sqlConnection);
sqlCommand.CommandTimeout = this.CommandTimeOut;
if (_tran != null)
{
sqlCommand.Transaction = _tran;
}
sqlCommand.Parameters.AddRange(pars);
if (IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(sqlCommand.Parameters);
}
int count = sqlCommand.ExecuteNonQuery();
sqlCommand.Parameters.Clear();
return(count);
}
/// <summary>
/// 获取DataSet
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public DataSet GetDataSetAll(string sql, params SqlParameter[] pars)
{
SqlDataAdapter _sqlDataAdapter = new SqlDataAdapter(sql, _sqlConnection);
if (_tran != null)
{
_sqlDataAdapter.SelectCommand.Transaction = _tran;
}
if (IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(_sqlDataAdapter.SelectCommand.Parameters);
}
_sqlDataAdapter.SelectCommand.CommandTimeout = this.CommandTimeOut;
_sqlDataAdapter.SelectCommand.Parameters.AddRange(pars);
DataSet ds = new DataSet();
_sqlDataAdapter.Fill(ds);
_sqlDataAdapter.SelectCommand.Parameters.Clear();
return(ds);
}
/// <summary>
/// 创建一个新的SQL连接
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public virtual SqlCommand CreateSqlCommand(string sql, params SqlParameter[] pars)
{
SqlCommand sqlCommand = new SqlCommand(sql, _sqlConnection);
sqlCommand.CommandType = this.CommandType;
sqlCommand.CommandTimeout = this.CommandTimeOut;
if (_tran != null)
{
sqlCommand.Transaction = _tran;
}
if (pars != null)
{
sqlCommand.Parameters.AddRange(pars);
}
if (this.IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(sqlCommand.Parameters);
}
return(sqlCommand);
}