/// <summary> /// 获取DataSet /// </summary> /// <param name="sql"></param> /// <param name="pars"></param> /// <returns></returns> public DataSet GetDataSetAll(string sql, params SQLiteParameter[] pars) { ExecLogEvent(sql, pars, true); SQLiteDataAdapter _sqlDataAdapter = new SQLiteDataAdapter(sql, _SQLiteConnection); if (_tran != null) { _sqlDataAdapter.SelectCommand.Transaction = _tran; } if (IsGetPageParas) { SqlSugarToolExtensions.RequestParasToSqlParameters(_sqlDataAdapter.SelectCommand.Parameters); } _sqlDataAdapter.SelectCommand.CommandTimeout = this.CommandTimeOut; _sqlDataAdapter.SelectCommand.CommandType = CommandType; if (pars != null) { _sqlDataAdapter.SelectCommand.Parameters.AddRange(pars); } DataSet ds = new DataSet(); _sqlDataAdapter.Fill(ds); if (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 int ExecuteCommand(string sql, params SqliteParameter[] pars) { ExecLogEvent(sql, pars, true); SqliteCommand SqliteCommand = new SqliteCommand(sql, _SqliteConnection); SqliteCommand.CommandType = CommandType; SqliteCommand.CommandTimeout = this.CommandTimeOut; if (_tran != null) { SqliteCommand.Transaction = _tran; } if (pars != null) { SqliteCommand.Parameters.AddRange(pars); } if (IsGetPageParas) { SqlSugarToolExtensions.RequestParasToSqlParameters(SqliteCommand.Parameters); } int count = SqliteCommand.ExecuteNonQuery(); if (IsClearParameters) { SqliteCommand.Parameters.Clear(); } ExecLogEvent(sql, pars, false); return(count); }
/// <summary> /// 获取DataReader /// </summary> /// <param name="sql"></param> /// <param name="pars"></param> /// <returns></returns> public SQLiteDataReader GetReader(string sql, params SQLiteParameter[] pars) { ExecLogEvent(sql, pars, true); SQLiteCommand SQLiteCommand = new SQLiteCommand(sql, _SQLiteConnection); SQLiteCommand.CommandType = CommandType; SQLiteCommand.CommandTimeout = this.CommandTimeOut; if (_tran != null) { SQLiteCommand.Transaction = _tran; } if (pars != null) { SQLiteCommand.Parameters.AddRange(pars); } if (IsGetPageParas) { SqlSugarToolExtensions.RequestParasToSqlParameters(SQLiteCommand.Parameters); } SQLiteDataReader sqlDataReader = SQLiteCommand.ExecuteReader(); if (IsClearParameters) { SQLiteCommand.Parameters.Clear(); } ExecLogEvent(sql, pars, false); return(sqlDataReader); }
/// <summary> /// 获取第一行第一列 /// </summary> /// <param name="sql"></param> /// <param name="pars"></param> /// <returns></returns> public object GetScalar(string sql, params SqliteParameter[] pars) { ExecLogEvent(sql, pars, true); SqliteCommand SqliteCommand = new SqliteCommand(sql, _SqliteConnection); SqliteCommand.CommandType = CommandType; if (_tran != null) { SqliteCommand.Transaction = _tran; } SqliteCommand.CommandTimeout = this.CommandTimeOut; if (pars != null) { SqliteCommand.Parameters.AddRange(pars); } if (IsGetPageParas) { SqlSugarToolExtensions.RequestParasToSqlParameters(SqliteCommand.Parameters); } object scalar = SqliteCommand.ExecuteScalar(); scalar = (scalar == null ? 0 : scalar); if (IsClearParameters) { SqliteCommand.Parameters.Clear(); } ExecLogEvent(sql, pars, false); return(scalar); }