1. /// <summary>
   
2. /// 执行SQL语句，返回影响的记录数
   
3. /// </summary>
   
4. /// <param name="SQLString">SQL语句</param>
   
5. /// <returns>影响的记录数</returns>
   
6. public static int ExecuteSql(string SQLString,params OracleParameter[] cmdParms)
   
7. {
   
8. using (OracleConnection connection = new OracleConnection(connectionString))
   
9. {
   
10. using (OracleCommand cmd = new OracleCommand())
    
11. {
    
12. try
    
13. {
    
14. PrepareCommand(cmd, connection, null,SQLString, cmdParms);
    
15. int rows=cmd.ExecuteNonQuery();
    
16. cmd.Parameters.Clear();
    
17. return rows;
    
18. }
    
19. catch(System.Data.OracleClient.OracleException E)
    
20. {
    
21. throw new Exception(E.Message);
    
22. }
    
23. }
    
24. }
    
25. }
    

复制代码

1. /// <summary>
   
2. /// 执行SQL语句，返回影响的记录数
   
3. /// </summary>
   
4. /// <param name="SQLString">SQL语句</param>
   
5. /// <returns>影响的记录数</returns>
   
6. public static int ExecuteSql(string SQLString,params OracleParameter[] cmdParms)
   
7. {
   
8. using (OracleConnection connection = new OracleConnection(connectionString))
   
9. {
   
10. using (OracleCommand cmd = new OracleCommand())
    
11. {
    
12. try
    
13. {
    
14. PrepareCommand(cmd, connection, null,SQLString, cmdParms);
    
15. int rows=cmd.ExecuteNonQuery();
    
16. cmd.Parameters.Clear();
    
17. return rows;
    
18. }
    
19. catch(System.Data.OracleClient.OracleException E)
    
20. {
    
21. throw new Exception(E.Message);
    
22. }
    
23. }
    
24. }
    
25. }
    

复制代码