生产计划平台保存校验流传单号 判断是否已生成生产订单

王 垚

2022-09-05 212f1d3cde3b2a3d30ef39cdde83e553cb7254f8

生产计划平台保存校验流传单号 判断是否已生成生产订单

 MES/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs

@@ -716,6 +716,16 @@
                            var fSpreadBillNoSplit = dayPlanModel.LastOrDefault().FSpreadBillNo.Split('-');
                            fSpreadBillNo = Convert.ToInt32(fSpreadBillNoSplit[fSpreadBillNoSplit.Length - 1]);
                        }
                        var fnallySpreadBillNo = "";
                        for (int i = 1; i < 100; i++)
                        {
                            fnallySpreadBillNo = $"{FSCOrderNo}-{FSRCBILLENTRYSEQ}-{fSpreadBillNo + i}";
                            string yzsql = $"select FID from T_PRD_MO where FBILLNO = '{fnallySpreadBillNo}'";
                            var yzfid = DBServiceHelper.ExecuteScalar<int>(Context, yzsql, 0);
                            if (yzfid == 0)
                                break;
                        }
                        
                        //选单数据 做新增
                        JObject jsonRoot = new JObject();
                        jsonRoot.Add("Creator", "");
@@ -779,7 +789,8 @@
                        JObject jsonFPOOrderEntry = new JObject();
                        jsonFPOOrderEntry.Add("FHMasterDate", date.AddDays(0).ToShortDateString()); ;//主日期
                        jsonFPOOrderEntry.Add("FHQty ", Convert.ToString(current["FT0"])); ;//日计划数量
                        jsonFPOOrderEntry.Add("FSpreadBillNo", $"{FSCOrderNo}-{FSRCBILLENTRYSEQ}-{fSpreadBillNo + 1}"); //流传单号 生产订单号+生产订单明细行号+序号mo0001-1-1

                        jsonFPOOrderEntry.Add("FSpreadBillNo", fnallySpreadBillNo); //流传单号 生产订单号+生产订单明细行号+序号mo0001-1-1
                        Entry.Add(jsonFPOOrderEntry);

                        jsonModel.Add("FEntity", Entry);