| | |
| | | |
| | | 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(entity).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<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 update = db.Updateable(entity).ExecuteCommand(); |
| | | var update = db.Updateable(entity).Where(e => e.Id == entity.Id && e.ItemNo == entity.ItemNo).ExecuteCommand(); |
| | | return true; |
| | | } |
| | | else |