public SQLiteDataReader GetReader(string sql, params SQLiteParameter[] pars)
{
SQLiteCommand sqlCommand = new SQLiteCommand(sql, _sqlConnection);
sqlCommand.CommandTimeout = this.CommandTimeOut;
if (_tran != null)
{
sqlCommand.Transaction = _tran;
}
if (pars != null)
{
sqlCommand.Parameters.AddRange(pars);
}
if (IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(sqlCommand.Parameters);
}
SQLiteDataReader sqlDataReader = sqlCommand.ExecuteReader();
if (isClearParameters)
{
sqlCommand.Parameters.Clear();
}
return(sqlDataReader);
}
public DataSet GetDataSetAll(string sql, params SQLiteParameter[] pars)
{
SQLiteDataAdapter _sqlDataAdapter = new SQLiteDataAdapter(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);
}
public int ExecuteCommand(string sql, params SQLiteParameter[] pars)
{
SQLiteCommand sqlCommand = new SQLiteCommand(sql, _sqlConnection);
sqlCommand.CommandTimeout = this.CommandTimeOut;
if (_tran != null)
{
sqlCommand.Transaction = _tran;
}
if (pars != null)
{
sqlCommand.Parameters.AddRange(pars);
}
if (IsGetPageParas)
{
SqlSugarToolExtensions.RequestParasToSqlParameters(sqlCommand.Parameters);
}
int count = sqlCommand.ExecuteNonQuery();
sqlCommand.Parameters.Clear();
return(count);
}
public object GetScalar(string sql, params SQLiteParameter[] pars)
{
SQLiteCommand sqlCommand = new SQLiteCommand(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();
return(scalar);
}
