| | |
| | | switch (womErpCaa.Type) |
| | | { |
| | | case "3": |
| | | return UpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0; |
| | | return SaveOrUpdateData(db, mesWomcaa, mesWomcabs,womErpCaa.Type) |
| | | ? 1 |
| | | : 0; |
| | | //return UpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0; //反审核不删除,做update。 |
| | | case "2": |
| | | case "4": |
| | | //kyy 2024-09-13 变更 |
| | | case "5": |
| | | return SaveOrUpdateData(db, mesWomcaa, mesWomcabs) |
| | | return SaveOrUpdateData(db, mesWomcaa, mesWomcabs,womErpCaa.Type) |
| | | ? 1 |
| | | : 0; |
| | | default: |
| | |
| | | } |
| | | |
| | | private bool SaveOrUpdateData(SqlSugarScope db, Womcaa mesWomcaa, |
| | | List<Womcab> mesWomcabs) |
| | | List<Womcab> mesWomcabs, string type) |
| | | { |
| | | if(type == "3" || (mesWomcaa.DocumentStatus != null && mesWomcaa.DocumentStatus != "C")) |
| | | { |
| | | mesWomcaa.Typea = "3"; // 新增字段赋值 |
| | | mesWomcaa.Caa001 = mesWomcaa.Caa001 + "F" + mesWomcaa.Erpid.ToString(); |
| | | } |
| | | |
| | | |
| | | |
| | | if (StringUtil.CheckGuid(mesWomcaa.Guid)) |
| | | base.DeleteById(mesWomcaa.Guid); |
| | | |
| | |
| | | |
| | | if (orUpdate && baOrUpdate) |
| | | { |
| | | db.Ado.ExecuteCommand("exec [dbo].[prc_unit_check] @billno, @ModuleType", |
| | | new { billno = mesWomcaa.Caa001, ModuleType = "生产工单" }); |
| | | |
| | | |
| | | // 调用存储过程更新用料清单 |
| | | db.Ado.ExecuteCommand("exec [dbo].[prc_update_womdab] @outMsg output,@outSum output,@inEdtUserGuid,@inCaaGuid", |
| | | new { |
| | |
| | | private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa, |
| | | List<Womcab> mesWomcabs) |
| | | { |
| | | //throw new NotImplementedException("存在下有单据,不允许反审"); |
| | | |
| | | var decimals = mesWomcabs.Select(s => s.Guid).ToArray(); |
| | | var update = base.DeleteById(mesWomcaa.Guid); |
| | | var insertOrUpdate = db |
| | |
| | | Caa0111 = dto.FPlanFinishDate, /// 预计完工时间备份 |
| | | Typea = dto.TypeA, /// 预计完工时间备份 |
| | | //Typeb = dto.TypeB /// 预计完工时间备份 |
| | | SynchronousDate = DateTime.Now |
| | | SynchronousDate = DateTime.Now, |
| | | DocumentStatus = dto.FDocumentStatus |
| | | }; |
| | | |
| | | var single = base.GetSingle(it => it.Erpid == entity.Erpid); |
| | |
| | | UseRate = Convert.ToDecimal(dto.FUseRate), |
| | | MaterialType = dto.FMaterialType, |
| | | MustQty = Convert.ToDecimal(dto.FMustQty), |
| | | Typeb = dto.TypeB |
| | | Typeb = dto.TypeB, |
| | | F_UNW_QTY_YFSL = dto.F_UNW_QTY_YFSL, |
| | | // Fsaleorderno = dto.FSALEORDERNO, /// 销售订单 |
| | | // |
| | | // CustomerItemNumber = dto.F_XIFG_Text_re5, /// 客户货号 |
| | |
| | | |
| | | var entity = Db.Queryable<Womcab>() |
| | | .Where(s => s.Eid == womcab.Eid).Single(); |
| | | if (entity != null) womcab.Guid = entity.Guid; |
| | | if (entity != null) { |
| | | womcab.Guid = entity.Guid; |
| | | womcab.IS_LOCK = entity.IS_LOCK; |
| | | womcab.IS_LOCK_DATE = entity.IS_LOCK_DATE; |
| | | |
| | | } |
| | | |
| | | womcabList.Add(womcab); |
| | | } |