| | |
| | | private bool SaveOrUpdateDataWw(SqlSugarScope db, Womcaa mesWomcaa, |
| | | List<Womcab> mesWomcabss) |
| | | { |
| | | //扫码不允许删除 |
| | | var hasMaterialOut = db.Queryable<MesInvItemOuts>() |
| | | .Any(x => x.WorkNo == mesWomcaa.Caa001); |
| | | |
| | | if (hasMaterialOut) |
| | | { |
| | | throw new Exception($"MES有领料记录,单号:{mesWomcaa.Caa001},不能更新!"); |
| | | } |
| | | if (mesWomcaa.Id != null) base.DeleteById(mesWomcaa.Id); |
| | | |
| | | if (mesWomcabss.Count > 0) |
| | |
| | | private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa, |
| | | List<Womcab> mesWomcabs) |
| | | { |
| | | //扫码不允许删除 |
| | | var hasMaterialOut = db.Queryable<MesInvItemOuts>() |
| | | .Any(x => x.WorkNo == mesWomcaa.Caa001); |
| | | |
| | | if (hasMaterialOut) |
| | | { |
| | | throw new Exception($"MES有领料记录,单号:{mesWomcaa.Caa001},不能更新!"); |
| | | } |
| | | var decimals = mesWomcabs.Select(s => s.Id).ToArray(); |
| | | var update = base.DeleteById(mesWomcaa.Id); |
| | | var insertOrUpdate = db |
| | |
| | | //PrdOrg = dto.erP_SCZZ, |
| | | //TrustOrg = dto.erP_WTZZ, |
| | | TbTime = DateTime.Now, |
| | | JaBs = "0" |
| | | JaBs = 0 |
| | | }; |
| | | if (dto.Type == "5") |
| | | entity.IsXg = 1; |
| | |
| | | |
| | | if (dto.FStatus == "6" || dto.FStatus == "7") |
| | | { |
| | | entity.JaBs = "1"; |
| | | entity.JaBs =1; |
| | | entity.JaTime = DateTime.Now; |
| | | } |
| | | |
| | |
| | | Cab006 = Convert.ToDecimal(dto.FNeedQty), |
| | | Cab007 = Convert.ToDecimal(dto.FPickedQty), |
| | | Cab009 = dto.FUnitID, |
| | | Cab014 = dto.FIsKeyItem, |
| | | Cab014 = Convert.ToInt32(dto.FIsKeyItem), |
| | | Pid = Convert.ToDecimal(dto.PID), |
| | | Eid = Convert.ToDecimal(dto.PID), |
| | | PositionNo = dto.FPositionNO, |
| | |
| | | SupplyType = dto.FSupplyType, |
| | | Numerator = Convert.ToDecimal(dto.FNumerator), |
| | | Denominator = Convert.ToDecimal(dto.FDenominator), |
| | | SCRAPQTY = Convert.ToDecimal(dto.FFixScrapQty), |
| | | SCRAPRATE = Convert.ToDecimal(dto.FScrapRate) |
| | | Scrapqty = Convert.ToDecimal(dto.FFixScrapQty), |
| | | Scraprate = Convert.ToDecimal(dto.FScrapRate) |
| | | //SalesOrder = dto.FXSHTBH, |
| | | }; |
| | | |