| | |
| | | if (UpdateDepotStatus(db, entity.DepotId, "B")) return 1; |
| | | |
| | | break; |
| | | case "2": |
| | | if (InsertDepot(db, entity)) return 1; |
| | | |
| | | break; |
| | | case "3": |
| | | if (DeleteDepot(db, entity.DepotId)) return 1; |
| | | |
| | | break; |
| | | case "2": |
| | | case "4": |
| | | if (InsertOrUpdate(db, entity)) return 1; |
| | | |
| | |
| | | // 删除仓库的方法 |
| | | private bool DeleteDepot(SqlSugarScope db, decimal depotId) |
| | | { |
| | | var deleteById = db.Deleteable<MesDepots>().In(depotId) |
| | | .ExecuteCommand(); |
| | | var deleteById = db.Deleteable<MesDepots>() |
| | | .Where(s => s.DepotId == depotId).ExecuteCommand(); |
| | | if (deleteById > 0) |
| | | return true; |
| | | |
| | |
| | | "B")) // 批量禁用仓库 |
| | | throw new NotImplementedException("禁用失败"); |
| | | break; |
| | | case "2": |
| | | if (!InsertDepotBatch(db, |
| | | depotsGroup.Value)) // 批量插入仓库 |
| | | throw new NotImplementedException("插入失败"); |
| | | break; |
| | | case "3": |
| | | if (!DeleteDepotBatch(db, |
| | | depotsGroup.Value)) // 批量删除仓库 |
| | | throw new NotImplementedException("删除失败"); |
| | | break; |
| | | case "2": |
| | | case "4": |
| | | if (!InsertOrUpdateBatch(db, |
| | | depotsGroup.Value)) // 批量插入或更新仓库 |
| | |
| | | { |
| | | var ids = depotList.Select(it => it.DepotId).ToArray(); |
| | | var deleteByIds = |
| | | db.Deleteable<MesDepots>().In(ids).ExecuteCommand(); |
| | | db.Deleteable<MesDepots>() |
| | | .Where(s => ids.Contains(s.DepotId)).ExecuteCommand(); |
| | | if (deleteByIds > 0) |
| | | return true; |
| | | |
| | |
| | | private bool InsertOrUpdateBatch(SqlSugarScope db, |
| | | List<MesDepots> depotList) |
| | | { |
| | | foreach (var entity in depotList) |
| | | if (!InsertOrUpdate(db, entity)) |
| | | return false; |
| | | |
| | | return true; |
| | | return depotList.All(entity => InsertOrUpdate(db, entity)); |
| | | } |
| | | } |