11

jinxin

2025-06-23 5c4192f0b813d72a427eaca183d08d42046f1b41

 C#/HH.WCS.Mobox3.WeiLi/api/ApiHelper.cs

@@ -71,11 +71,15 @@
                        info.S_ITEM_NAME = a.itemName;
                        info.S_IS_MANAGE = a.isManage;
                        info.S_IS_MANAGEDATE = a.isManageDate;
                        db.Updateable<TN_Material>(info).UpdateColumns(it => new { it.S_ITEM_NAME, it.S_IS_MANAGE, it.S_IS_MANAGEDATE }).ExecuteCommand();
                        info.S_UOM = a.unit;
                        db.Updateable<TN_Material>(info).UpdateColumns(it => new { it.S_ITEM_NAME, it.S_IS_MANAGE, it.S_IS_MANAGEDATE,it.S_UOM }).ExecuteCommand();


                        db.Updateable<CntrItemRel>().SetColumns(it => new CntrItemRel() { S_ITEM_NAME = a.itemName , S_UOM = a.unit }).Where(it=>it.S_ITEM_CODE==a.itemCode).ExecuteCommand();
                    }
                    else
                    {
                        db.Insertable(new TN_Material { S_ITEM_CODE = a.itemCode, S_ITEM_NAME = a.itemName, S_IS_MANAGE = a.isManage, S_IS_MANAGEDATE = a.isManageDate }).ExecuteCommand();
                        db.Insertable(new TN_Material { S_ITEM_CODE = a.itemCode, S_ITEM_NAME = a.itemName, S_IS_MANAGE = a.isManage, S_IS_MANAGEDATE = a.isManageDate, S_UOM = a.unit }).ExecuteCommand();
                    }
                    //db.Updateable<TN_Material>().SetColumns(it => new TN_Material() { S_ITEM_NAME = a.itemName }).Where(it => it.S_ITEM_CODE == a.itemCode).ExecuteCommand();
                    //db.Updateable<WHInventory>().SetColumns(it => new WHInventory() { S_ITEM_NAME = a.itemName }).Where(it => it.S_ITEM_CODE == a.itemCode).ExecuteCommand();
@@ -1433,6 +1437,7 @@
                            S_BATCH_NO = a.batchNo,
                            S_OWNER = a.factoryCode,
                            S_ERP_WH_CODE = a.stockLoc,
                            S_UOM=itemName.S_UOM,
                            F_QTY = a.qty,
                            S_SUPPLIER_NO = a.vendorCode,
                            S_SERIAL_NO = a.serialNo,
@@ -3166,6 +3171,7 @@
                                            S_ITEM_NAME = itemName.S_ITEM_NAME,
                                            S_ITEM_CODE = a.itemCode,
                                            S_BATCH_NO = a.batchNo,
                                            S_UOM=itemName.S_UOM,
                                            S_BS_NO=a.inWorkNo,
                                            S_OWNER = a.factoryCode,
                                            S_ERP_WH_CODE = a.stockLocation,
@@ -3371,6 +3377,7 @@
                                        S_CNTR_CODE = model.cntrNo,
                                        S_WU = a.rowID,
                                        S_ITEM_NAME = itemName.S_ITEM_NAME,
                                        S_UOM = itemName.S_UOM,
                                        S_ITEM_CODE = a.itemCode,
                                        S_BATCH_NO = a.batchNo,
                                        S_OWNER = a.factoryCode,
@@ -3516,6 +3523,7 @@
                                            {
                                                S_CNTR_CODE = cntr,
                                                S_ITEM_NAME = itemName.S_ITEM_NAME,
                                                S_UOM = itemName.S_UOM,
                                                S_ITEM_CODE = a.itemCode,
                                                S_BATCH_NO = a.batchNo,
                                                S_OWNER = a.factoryCode,
@@ -3580,6 +3588,7 @@
                                                {
                                                    S_CNTR_CODE = cntr,
                                                    S_ITEM_NAME = itemName.S_ITEM_NAME,
                                                    S_UOM = itemName.S_UOM,
                                                    S_ITEM_CODE = it.itemCode,
                                                    S_BATCH_NO = it.batchNo,
                                                    S_OWNER = it.factoryCode,