public override int ExecuteNonQuery(CommandType commandType, string commandText, ParameterCollection commandParameters) { int num = 0; using (OracleCommand command = new OracleCommand()) { this.PrepareCommand(command, commandType, commandText, commandParameters); num = command.ExecuteNonQuery(); command.Parameters.Clear(); } return num; }
public override IDataReader ExecuteReader(CommandType commandType, string commandText, ParameterCollection commandParameters) { OracleDataReader reader = null; using (OracleCommand command = new OracleCommand()) { this.PrepareCommand(command, commandType, commandText, commandParameters); reader = command.ExecuteReader(); command.Parameters.Clear(); } return reader; }
public override DataSet ExecuteDataset(CommandType commandType, string commandText, ParameterCollection commandParameters, string tableName) { DataSet dataSet = null; using (OracleCommand command = new OracleCommand()) { this.PrepareCommand(command, commandType, commandText, commandParameters); using (OracleDataAdapter adapter = new OracleDataAdapter(command)) { dataSet = new DataSet(); if (object.Equals(tableName, null) || (tableName.Length < 1)) { adapter.Fill(dataSet); } else { adapter.Fill(dataSet, tableName); } command.Parameters.Clear(); } } return dataSet; }
public override object ExecuteScalar(CommandType commandType, string commandText, ParameterCollection commandParameters) { object obj2 = null; using (OracleCommand command = new OracleCommand()) { this.PrepareCommand(command, commandType, commandText, commandParameters); obj2 = command.ExecuteScalar(); command.Parameters.Clear(); } return obj2; }
private void PrepareCommand(OracleCommand cmd, CommandType commandType, string commandText, ParameterCollection commandParameters) { cmd.CommandType = commandType; cmd.CommandText = commandText; cmd.Connection = this._oracle._CON; cmd.Transaction = this._oracle._Trans; if ((commandParameters != null) && (commandParameters.Count > 0)) { for (int i = 0; i < commandParameters.Count; i++) { commandParameters[i].InitRealParameter(DataBaseType.Oracle); OracleParameter realParameter = commandParameters[i].RealParameter as OracleParameter; if (realParameter.DbType == DbType.String) { realParameter.OracleType = OracleType.VarChar; } cmd.Parameters.Add(realParameter); } } }
public override XmlReader ExecuteXmlReader(CommandType commandType, string commandText, ParameterCollection commandParameters) { return null; }
public DataTable Query(CommandType commandType, string commandText, ParameterCollection commandParameters) { DataTable table = null; DataTable table2; using (OracleCommand command = new OracleCommand()) { this.PrepareCommand(command, commandType, commandText, commandParameters); using (OracleDataAdapter adapter = new OracleDataAdapter(command)) { using (DataSet set = new DataSet()) { adapter.Fill(set); if (set.Tables.Count > 0) { table = set.Tables[0].Copy(); } } table2 = table; } } return table2; }
public override DataSet ExecuteDataset(string _tablename, string _showfield, string _sqlwhere, int _showcount, ParameterCollection _commandParameters) { string commandText = "select top " + _showcount.ToString() + " " + _showfield + " from " + _tablename + " where " + _sqlwhere; return this.ExecuteDataset(CommandType.Text, commandText, _commandParameters, null); }
public override int ExecuteNonQuery(CommandType commandType, string commandText, ParameterCollection commandParameters) { return this.ExecuteNonQuery(commandType, commandText, commandParameters); }
public override DataSet ExecuteDataset(CommandType commandType, string commandText, ParameterCollection commandParameters, string tableName) { return this.ExecuteDataset(commandType, commandText, commandParameters, tableName); }
public override object ExecuteScalar(CommandType commandType, string commandText, ParameterCollection commandParameters) { return this.ExecuteScalar(commandType, commandText, commandParameters); }
public override IDataReader ExecuteReader(CommandType commandType, string commandText, ParameterCollection commandParameters) { return this.ExecuteReader(commandType, commandText, commandParameters); }
private void PrepareCommand(OleDbCommand cmd, CommandType commandType, string commandText, ParameterCollection commandParameters) { cmd.CommandType = commandType; cmd.CommandText = commandText; cmd.Connection = this._oledb._CON; cmd.Transaction = this._oledb._Trans; if ((commandParameters != null) && (commandParameters.Count > 0)) { for (int i = 0; i < commandParameters.Count; i++) { commandParameters[i].InitRealParameter(DataBaseType.OleDB); cmd.Parameters.Add(commandParameters[i].RealParameter as OleDbParameter); } } }
public bool WriteLog(DataBase db) { if (Popedoms.Trim() != "") { int num = 0; string[] strArray = Popedoms.Split(",".ToCharArray()); for (int i = 0; i < strArray.Length; i++) { if (strArray[i].Trim() == this.FunctionId.Trim()) { num = 1; break; } } if (num != 0) { string commandText = "insert into " + GetAccessType.DataBaseName + "Qx_syslog(webuser,type,nrstring,logip,nrstringdata,logtable,logtablekey,logtableid,logdelyy,webusername) values('" + this.UserId + "','" + this.FunctionId + "','" + this.FunctionName + "','" + this.LogIp + "',"; ParameterCollection commandParameters = new ParameterCollection(1); commandText = commandText + ":nrstringdata,"; commandParameters.Add(":nrstringdata", this.functiondata, MyDataType.UInt16, ParameterDirection.Input); commandText = commandText + "'" + this.LogTable + "','" + this.LogTableKey + "','" + this.LogTableId + "','" + this.LogCause + "','" + this.UserName + "')"; try { db.ExecuteNonQuery(CommandType.Text, commandText, commandParameters); } catch (Exception) { throw new LogException("写入日志失败!"); } } } return true; }