| | |
| | | DrCk = dto.dr_ck, //调入仓库 |
| | | DcBm = dto.dc_bm, //调出部门 |
| | | DrBm = dto.dr_bm, //调入部门 |
| | | Gys=dto.GYS, //供应商 |
| | | Type2 = "直接调拨单", // |
| | | Remark = dto.bz, |
| | | Erpid = dto.erpid, |
| | |
| | | Remark = dto.bz, |
| | | Erpid = dto.erpid, |
| | | Eid = dto.eid, |
| | | YdLx=dto.YD_lx, |
| | | YdBm=dto.yd_bm, |
| | | DdBm=dto.dd_bm, |
| | | DdLx=dto.dd_lx, |
| | | TzdDh=dto.tzd_dh, |
| | | }; |
| | | |
| | | var existing = Db.Queryable<MesInvItemDbsqItems>().Where(s => s.Erpid == item.Erpid).Single(); |
| | |
| | | |
| | | private bool SaveOrUpdateData(SqlSugarScope db, MesInvItemDbsq head, List<MesInvItemDbsqItems> details) |
| | | { |
| | | // 1. 校验是否存在调拨记录(MesInvItemMoves) |
| | | var hasMaterialOut = db.Queryable<MesInvItemMoves>() |
| | | .Any(x => x.WomdaahbNo == head.BillNo); |
| | | |
| | | if (hasMaterialOut) |
| | | { |
| | | throw new Exception($"MES已有调拨记录,单号:{head.BillNo},不能更新!"); |
| | | } |
| | | |
| | | if (head.Id != null) |
| | | base.DeleteById(head.Id); |
| | | |