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);
         }
     }
 }
Beispiel #14
0
 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;
 }