1.生产、委外订单新增单据状态字段
2.反审核单据编号+'F'
| | |
| | | |
| | | public string? Btbz { get; set; } |
| | | public string? TypeA { get; set; } |
| | | |
| | | public string? FDocumentStatus { get; set; } |
| | | } |
| | |
| | | public string? SrcSplitSeq { get; set; } //源拆分订单行号 |
| | | public string? TypeA { get; set; } //单据状态 |
| | | |
| | | public string? FDocumentStatus { get; set; } |
| | | |
| | | // public string? FSUPPLIERID { get; set; } // 供应商ID |
| | | } |
| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TYPEA")] |
| | | public string? Typea { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单据状态 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DOCUMENT_STATUS")] |
| | | public string? DocumentStatus { get; set; } |
| | | } |
| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SYNCHRONOUS_DATE")] |
| | | public DateTime? SynchronousDate { get; set; } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 单据状态 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DOCUMENT_STATUS")] |
| | | public string? DocumentStatus { get; set; } |
| | | } |
| | |
| | | return rohInErpRohIn.Type switch |
| | | { |
| | | "2" or "4" or "5" => SaveOrUpdateData(db, mesRohIn, |
| | | mesRohInDatas) |
| | | mesRohInDatas, rohInErpRohIn.Type) |
| | | ? 1 |
| | | : 0, |
| | | "3" => SaveOrUpdateData(db, mesRohIn, |
| | | mesRohInDatas) |
| | | mesRohInDatas, rohInErpRohIn.Type) |
| | | ? 1 |
| | | : 0, //UpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0,//反审核不删除,做update。 |
| | | _ => throw new NotImplementedException( |
| | |
| | | |
| | | // 插入或更新数据的方法 |
| | | private bool SaveOrUpdateData(SqlSugarScope db, MesRohIn mesRohIn, |
| | | List<MesRohInData> mesRohInDatas) |
| | | List<MesRohInData> mesRohInDatas, string type) |
| | | { |
| | | |
| | | if (type == "3") |
| | | { |
| | | mesRohIn.BillNo = mesRohIn.BillNo + "F"; |
| | | } |
| | | |
| | | if (mesRohIn.Guid != null) |
| | | db.Deleteable<MesRohIn>().Where(s => s.Guid == mesRohIn.Guid) |
| | | .ExecuteCommand(); |
| | |
| | | if(type == "3") |
| | | { |
| | | mesRohIn.Typea = "3"; // 新增字段赋值 |
| | | mesRohIn.OrderNo = mesRohIn.OrderNo + "F"; |
| | | } |
| | | |
| | | if (StringUtil.CheckGuid(mesRohIn.Guid)) |
| | |
| | | ReqSrc = erpDto.FReqSrc, |
| | | SrcSplitSeq = erpDto.SrcSplitSeq, |
| | | Typea = erpDto.TypeA, |
| | | DocumentStatus = erpDto.FDocumentStatus |
| | | |
| | | }; |
| | | |
| | | var single = base.GetSingle(it => it.ErpProductionEntryCode == erpDto.FSUBENTRYID); |
| | |
| | | { |
| | | //if (mesSalesOrder.Id != null) base.DeleteById(mesSalesOrder.Id); |
| | | |
| | | if (type == "3") |
| | | { |
| | | mesSalesOrder.BillNo = mesSalesOrder.BillNo + "F"; |
| | | } |
| | | |
| | | if (mesSalesOrder.ErpID != null) |
| | | db.Deleteable<SalesOrder>() |
| | | .Where(s => s.ErpID == mesSalesOrder.ErpID).ExecuteCommand(); |
| | |
| | | if(type == "3") |
| | | { |
| | | mesWomcaa.Typea = "3"; // 新增字段赋值 |
| | | mesWomcaa.Caa001 = mesWomcaa.Caa001 + "F"; |
| | | } |
| | | |
| | | |
| | |
| | | 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); |