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); }