/// <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);
}
}
}