/// <summary>
/// 返回查询结果集的处理
/// </summary>
/// <param name="sqlKey">为Resources file 中的ＳＱＬ语句的关键字</param>
/// <param name="parames">SQL语句参数</param>
/// <param name="myDataSetGet">DataSet参数</param>
/// <param name="tableName">传入的DataSet表名</param>
/// <returns></returns>
private DataSet DataSetDisposal(string sqlKey, string[] parames, DataSet myDataSetGet, string tableName)
{
string commandText = "";
OracleConnection conn = (OracleConnection)getConnection();
try
{
conn.Open();
//获得commandText
commandText = ResourceBundle.GetSQL(sqlKey);
if (commandText == "")
{
throw new ArgumentNullException("commandText");
}
if (parames != null)
{
commandText = paraSQL(commandText, parames);
}
OracleCommand cmd = CreateCommand(commandText, conn);
OracleDataAdapter myAdapter = CreateAdapter(cmd);
//填充数据集
if (tableName == "")
{
myAdapter.Fill(myDataSetGet, "myInvoke");
}
else
{
myAdapter.Fill(myDataSetGet, tableName);
}
}
catch (Exception ex)
{
// ZeroWireLog.WriteLog(ex);
// throws new ZeroWireExcepton (ex);
throw (ex);
}
finally
{
conn.Close();
}
return(myDataSetGet);
}
//
/// <summary>
/// 查询处理
/// </summary>
/// <param name="sqlKey">为Resources file 中的ＳＱＬ语句的关键字</param>
/// <param name="parames">SQL语句参数</param>
/// <returns></returns>
//
private object QueryDisposal(string sqlKey, string[] parames)
{
DataSet myDataSetGet = new DataSet();
DataTable MyTable = new DataTable();
object result = null;
string commandText = "";
//获得连接对象
OracleConnection conn = (OracleConnection)getConnection();
try
{
conn.Open();
//获得commandText
commandText = ResourceBundle.GetSQL(sqlKey);
if (commandText == "")
{
throw new ArgumentNullException("commandText");
}
if (parames != null)
{
commandText = paraSQL(commandText, parames);
}
OracleCommand cmd = CreateCommand(commandText, conn);
OracleDataAdapter myAdapter = CreateAdapter(cmd);
myAdapter.Fill(myDataSetGet, "myInvoke");
MyTable = myDataSetGet.Tables[0];
result = (object)MyTable.Rows[0][0];
}
catch (Exception ex)
{
// ZeroWireLog.WriteLog(ex);
// throws new ZeroWireExcepton (ex);
throw (ex);
}
finally
{
conn.Close();
}
return(result);
}
//
/// <summary>
/// 非查询语句的处理
/// </summary>
/// <param name="sqlKey">为Resources file 中的ＳＱＬ语句的关键字</param>
/// <param name="parames">传入的SQL语句参数</param>
/// <returns></returns>
//
private int nonQueryDisposal(string sqlKey, string[] parames)
{
string commandText = "";
OracleConnection conn = null;
OracleCommand cmd = null;
//记录行数
int rows = 0;
//得到sql语句
commandText = ResourceBundle.GetSQL(sqlKey);
if (commandText == "")
{
throw new ArgumentNullException("commandText");
}
try
{
//得到了解
conn = (OracleConnection)getConnection();
//打开连接
conn.Open();
if (parames != null)
{
commandText = paraSQL(commandText, parames);
}
cmd = CreateCommand(commandText, conn);
rows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
finally
{
conn.Close();
}
return(rows);
}
/// <summary>
/// 获得SQL语句，用于测试用
/// </summary>
/// <param name="sqlKey">为Resources file 中的ＳＱＬ语句的关键字</param>
/// <param name="parames">传入的sql语句的参数</param>
/// <returns></returns>
public string getCommandText(string sqlKey, string[] parames)
{
string commandText = "";
if (sqlKey == "")
{
throw new ArgumentNullException("sqlKey");
}
try
{
commandText = ResourceBundle.GetSQL(sqlKey);
if (parames != null)
{
commandText = paraSQL(commandText, parames);
}
}
catch (Exception ex)
{
throw (ex);
}
return(commandText);
}
//
/// <summary>
/// 返回数据集查询的事务处理
/// </summary>
/// <param name="transaction">事务</param>
/// <param name="sqlKey">为Resources file 中的ＳＱＬ语句的关键字</param>
/// <param name="parames">SQL语句参数</param>
/// <returns></returns>
//
private DataSet transDataSetDisposal(OracleTransaction transaction, string sqlKey, string[] parames)
{
string commandText = "";
DataSet myDataSetGet = new DataSet();
try
{
IDbCommand cmd = CreateCommand();
commandText = ResourceBundle.GetSQL(sqlKey);
if (commandText == "")
{
throw new ArgumentNullException("commandText");
}
if (parames != null)
{
commandText = paraSQL(commandText, parames);
}
cmd.CommandText = commandText;
if (transaction.Connection == null)
{
throw new ArgumentNullException("transaction.Connection");
}
cmd.Connection = transaction.Connection;
//获得cmd的Transaction
cmd.Transaction = transaction;
OracleDataAdapter myAdapter = CreateAdapter((OracleCommand)cmd);
//填充数据集
myAdapter.Fill(myDataSetGet, "myInvoke");
}
catch (Exception ex)
{
// ZeroWireLog.WriteLog(ex);
// throws new ZeroWireExcepton (ex);
throw (ex);
}
return(myDataSetGet);
}
//
/// <summary>
/// 非查询语句的事务处理
/// </summary>
/// <param name="transaction">事务</param>
/// <param name="sqlKey">为Resources file 中的ＳＱＬ语句的关键字</param>
/// <param name="parames">SQL语句参数</param>
/// <returns></returns>
//
private int TransNonQueryDisposal(OracleTransaction transaction, string sqlKey, string[] parames)
{
string commandText = "";
int rows = 0;
if (transaction.Connection == null)
{
throw new ArgumentNullException("transaction.Connection");
}
IDbCommand cmd = CreateCommand();
//获得commandText
commandText = ResourceBundle.GetSQL(sqlKey);
if (commandText == "")
{
throw new ArgumentNullException("commandText");
}
try
{
if (parames != null)
{
commandText = paraSQL(commandText, parames);
}
//给cmd赋相应的值
cmd.CommandText = commandText;
cmd.Connection = transaction.Connection;
cmd.Transaction = transaction;
rows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
return(rows);
}