110,561
社区成员
发帖
与我相关
我的任务
分享
message = "";
OracleConnection conn = new OracleConnection(_tableCfg.DbService.OracleConnString);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
try
{
//string sql = "update newsadmin.BOND_TD_DANALYSIS_TMP set AIdays = 0 where bondcode = '1080176' and texch = 'CNIBEX' and tdate = date'2012-01-10'";
cmd.CommandText = sqlBulkContent.cmd;
cmd.ArrayBindCount = sqlBulkContent.RowCount;
foreach (FieldCfg fieldCfg in _tableCfg.FieldCfgs)
{
string key = fieldCfg.TargetItem;
OracleParameter param = new OracleParameter(key, sqlBulkContent.paramTypeDict[key]);
param.Direction = ParameterDirection.Input;
param.Value = sqlBulkContent.paramDict[key].ToArray();
cmd.Parameters.Add(param);
}
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
message = ex.ToString();
}
finally
{
conn.Close();
}
return sqlBulkContent.RowCount;