/// <summary> /// SQL语句执行方法。 /// </summary> /// <param name="strSQL"></param> /// <returns></returns> public int ExecuteNonQuery(string strSQL) { int val = 0; OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strSQL; using (OracleConnection conn = OracleConnHelper.getConn()) { cmd.Connection = conn; try { val = cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "提示:", MessageBoxButtons.OK, MessageBoxIcon.Information); throw new Exception(ex.ToString()); } finally { cmd.Dispose(); OracleConnHelper.closeConn(conn); } return(val); } }
/// <summary> /// 存储过程执行方法,传入参数集合。 /// </summary> /// <param name="procName"></param> /// <param name="cmdParms"></param> /// <returns></returns> public int ExecuteNonQuery(string procName, OracleParameter[] cmdParms) { int val = 0; OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; using (OracleConnection conn = OracleConnHelper.getConn()) { CreateCommand(cmd, conn, null, procName, cmdParms); try { val = cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "提示:", MessageBoxButtons.OK, MessageBoxIcon.Information); throw new Exception(ex.ToString()); } finally { cmd.Parameters.Clear(); cmd.Dispose(); OracleConnHelper.closeConn(conn); } return(val); } }
/// <summary> /// /// </summary> /// <param name="procName"></param> /// <param name="cmdParams"></param> /// <returns></returns> public DataTable getDT(string procName, OracleParameter[] cmdParams) { OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; using (OracleConnection conn = OracleConnHelper.getConn()) { CreateCommand(cmd, conn, null, procName, cmdParams); try { OracleDataReader odr = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(odr); return(dt); } catch (Exception ex) { //MessageBox.Show(ex.ToString(), "提示:", MessageBoxButtons.OK, MessageBoxIcon.Information); throw new Exception(ex.ToString()); } finally { cmd.Parameters.Clear(); cmd.Dispose(); OracleConnHelper.closeConn(conn); } } }