//根据SQL返回数据的值，如果为空返回的是null
private string[,] FnGetValue(string sql, string[,] arrValue)
{
string strSql = sql;
int m = arrValue.GetLength(0);
int n = arrValue.GetLength(1);
string[,] arrDetails = new string[m, n];
System.Data.OracleClient.OracleConnection oraConn =
new System.Data.OracleClient.OracleConnection(
ConfigurationManager.ConnectionStrings["oraConnectionString"].ConnectionString);
System.Data.OracleClient.OracleCommand oraComm = new System.Data.OracleClient.OracleCommand(strSql, oraConn);
oraConn.Open();
System.Data.OracleClient.OracleDataReader oraData = oraComm.ExecuteReader();
//读取相关数据
for (int i = 0; i < m; i++)
{
if (oraData.Read())
{
for (int j = 0; j < n; j++)
{
arrDetails[i, j] = oraData.IsDBNull(j) ? null : oraData.GetValue(j).ToString();
}
}
else
{
break;
}
}
oraData.Close();
oraComm.Cancel();
oraConn.Close();
oraData.Dispose();
oraComm.Dispose();
oraConn.Dispose();
// arrReturn = fnSetLeftingArr(arrDetails);
return arrDetails;
}
public override void Cancel()
{
cmd.Cancel();
}