| | |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.service; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using MES.Service.util; |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.service.BasicData; |
| | |
| | | } |
| | | else |
| | | { |
| | | mesId = GetSeqUtil.GetSeq("SEQ_ITEMS_ID"); |
| | | var entity = new MesLinkU9 |
| | | { |
| | | CreateDate = DateTime.Now, |
| | |
| | | OrgId = erpDetail.FUseOrgId, |
| | | TableType = "MES_ITEMS" |
| | | }; |
| | | mesId = Db.Insertable(entity).ExecuteReturnIdentity(); |
| | | Db.Insertable(entity).ExecuteCommand(); |
| | | } |
| | | |
| | | var items = new MesItems |
| | |
| | | CreateDate = DateTime.Now, |
| | | Company = "1000", |
| | | Factory = "1000", |
| | | WarehouseKeeper = item.WarehouseKeeper, |
| | | Merchandiser = item.Merchandiser |
| | | }; |
| | | list.Add(items); |
| | | } |
| | |
| | | { |
| | | DeleteItem(db, listItem); |
| | | |
| | | var insert = db.Insertable(listItem).IgnoreColumns(true) |
| | | var insert = db.Insertable(listItem).PageSize(1).IgnoreColumnsNull() |
| | | .ExecuteCommand(); |
| | | return insert > 0; |
| | | } |