110,561
社区成员
发帖
与我相关
我的任务
分享
public void UpdateBinFromList(IList<ItemInfo> items)
{
//插入数量
int itemsCount = items.Count;
if (itemsCount <= 0)
{
MessageBox.Show("没有数据");
return;
}
string SQL_UPDATE_depotitem = "INSERT INTO item (wh, zone, bin, num, style) VALUES(:WH,:ZONE,:BIN,0,:STYLE)";
OracleParameter[] parms =
{
new OracleParameter(":WH",OracleType.VarChar,6),
new OracleParameter(":ZONE",OracleType.VarChar,10),
new OracleParameter(":BIN",OracleType.VarChar,5),
new OracleParameter(":STYLE",OracleType.VarChar,20)
};
OracleConnection conn = new OracleConnection(OracleHelper.connectionString);
conn.Open();
OracleTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
int i = 0;
foreach (ItemInfo var in items)
{
parms[0].Value = var.Ware;
parms[1].Value = var.Zone;
parms[2].Value = string.IsNullOrEmpty(var.Bin) ? "" : var.Bin ;
parms[3].Value = var.Style;
i= i+ OracleHelper.ExecuteNonQuery(trans, CommandType.Text, SQL_UPDATE_depotitem, parms);
System.Diagnostics.Debug.WriteLine("插入数: " + i.ToString() + " " + var.Ware + "|" + var.Zone + "|" + var.Bin + "|" + var.Style);
}
trans.Commit();
//System.Diagnostics.Debug.WriteLine(i.ToString());
}
catch (Exception)
{
trans.Rollback();
throw;
}
finally
{
conn.Close();
}
}