中间表代码提交

ZY

2024-07-18 666181924a7deee3cc2b927949cac6b6d88a41c9

 src/main/java/com/zy/third/erp/task/ERPItemScheduler.java

@@ -9,6 +9,9 @@

import java.util.List;

/**
 * 物料档案
 */
@Component
public class ERPItemScheduler {
    @Value("${erp.enabled}")
@@ -28,7 +31,7 @@
//        List<ItemTB> itemTBS = erpSqlServer.select(selectALL, ItemTB.class);
//        List<ItemTB> itemTBS = erpSqlServer.selectAll(ItemTB.class);

        String sqlItemTB = "select * from erp_ItemTB where LKName='中扬'";
        String sqlItemTB = "select * from erp_ItemTB where LKName='中扬二期'";
        List<ItemTB> itemTBS = erpSqlServer.select(sqlItemTB, ItemTB.class);
        if (itemTBS != null && itemTBS.size() > 0) {
            for (ItemTB itemTB : itemTBS) {
@@ -56,7 +59,7 @@
//        BeanUtils.copyProperties(itemTB, itemTBBak);
//        itemTBBak.setDelDate(new Date());
//        erpItemTBBakMapper.insert(itemTBBak);
        erpSqlServer.update("delete from erp_ItemTB where LKName='中扬' and ItemId = '" + itemTB.getItemId() + "'");
        erpSqlServer.update("delete from erp_ItemTB where LKName='中扬二期' and ItemId = '" + itemTB.getItemId() + "'");
//        erpItemTBMapper.delete(new EntityWrapper<ItemTB>()
//                .eq("ItemId",itemTB.getItemID()));
    }