public static object[] BatchInsert(OracleTransaction trans, string cmdString, OracleParameter[][] Params, string sqlGetNewKey)
{
OracleCommand command = new OracleCommand(cmdString, trans.Connection, trans);
command.Prepare();
object[] objArray = new object[Params.Length];
int num = 0;
foreach (OracleParameter[] parameterArray in Params)
{
foreach (OracleParameter parameter in parameterArray)
{
command.Parameters.Add(parameter);
}
command.ExecuteNonQuery();
objArray[num++] = ExecuteScalar(trans, sqlGetNewKey, null);
}
return objArray;
}
{
OracleCommand command = new OracleCommand(cmdString, trans.Connection, trans);
command.Prepare();
object[] objArray = new object[Params.Length];
int num = 0;
foreach (OracleParameter[] parameterArray in Params)
{
foreach (OracleParameter parameter in parameterArray)
{
command.Parameters.Add(parameter);
}
command.ExecuteNonQuery();
objArray[num++] = ExecuteScalar(trans, sqlGetNewKey, null);
}
return objArray;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货