| | |
| | | public void ItemScheduler() { |
| | | //log.info("ItemScheduler开始了"); |
| | | if (!erpEnabled) return; |
| | | String sqlItemTB = "select TOP 1000 * from erp_ItemTB where LKName='中扬二期'"; |
| | | String sqlItemTB = "select TOP 1000 * from erp_ItemTB where LKName='高霖立库'"; |
| | | List<ItemTB> itemTBS = erpSqlServer.select(sqlItemTB, ItemTB.class); |
| | | if (itemTBS != null && itemTBS.size() > 0) { |
| | | for (ItemTB itemTB : itemTBS) { |
| | |
| | | */ |
| | | //将数据从主表移动到bak表里 |
| | | private void moveToBak(ItemTB itemTB) { |
| | | erpSqlServer.update("delete from erp_ItemTB where LKName='中扬二期' and ItemId = '" + itemTB.getItemId() + "'"); |
| | | erpSqlServer.update("delete from erp_ItemTB where LKName='高霖立库' and Item_id = '" + itemTB.getItemId() + "'"); |
| | | } |
| | | } |