| | |
| | | throw new NotImplementedException("删除失败"); |
| | | break; |
| | | case "4": |
| | | case "5": |
| | | if (!InsertOrUpdateBatch(db, itemGroup.Value)) |
| | | throw new NotImplementedException("同步失败"); |
| | | break; |
| | |
| | | |
| | | private bool InsertItem(SqlSugarScope db, MesItems entity) |
| | | { |
| | | var exists = db.Queryable<MesItems>().Any(e => e.Id == entity.Id); |
| | | var exists = db.Queryable<MesItems>().Any(e => e.Id == entity.Id && e.ItemNo==entity.ItemNo); |
| | | if (exists) |
| | | { |
| | | var result = db.Updateable<MesItems>().ExecuteCommand(); |
| | | var result = db.Updateable(entity).Where(e => e.Id == entity.Id && e.ItemNo == entity.ItemNo).ExecuteCommand(); |
| | | return true; |
| | | } |
| | | else |
| | |
| | | |
| | | private bool InsertOrUpdate(SqlSugarScope db, MesItems entity) |
| | | { |
| | | var exists = db.Queryable<Organize>().Any(e => e.Id == entity.Id); |
| | | var exists = db.Queryable<MesItems>().Any(e => e.Id == entity.Id && e.ItemNo==entity.ItemNo); |
| | | if (exists) |
| | | { |
| | | var update = db.Updateable(entity).ExecuteCommand(); |
| | | var update = db.Updateable(entity).Where(e => e.Id == entity.Id && e.ItemNo == entity.ItemNo).ExecuteCommand(); |
| | | return true; |
| | | } |
| | | else |