From 75ca84b7570d7a6a805c27164c3f17c1f2158423 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周五, 13 12月 2024 08:34:26 +0800 Subject: [PATCH] 111 --- CC/iWareCC_ASRS/FormCC.cs | 43 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 43 insertions(+), 0 deletions(-) diff --git a/CC/iWareCC_ASRS/FormCC.cs b/CC/iWareCC_ASRS/FormCC.cs index 36a52a0..0960ab9 100644 --- a/CC/iWareCC_ASRS/FormCC.cs +++ b/CC/iWareCC_ASRS/FormCC.cs @@ -1477,6 +1477,49 @@ item.UpiStatus = (int)UpiStatusEnum.鍒濆; } + //娓呯┖闃熷垪鏁版嵁 + var list = db.mes_upi_linequeue.ToList(); + db.mes_upi_linequeue.RemoveRange(list); + + db.SaveChanges(); + } + if (!string.IsNullOrEmpty(alertMsg)) + { + MessageBox.Show("閿欒:" + alertMsg); + } + else + { + MessageBox.Show("宸插鐞�"); + } + } + + private void button1_Click(object sender, EventArgs e) + { + + + var alertMsg = ""; + using (WmsDBModel db = new WmsDBModel()) + { + //鏌ヨ绔嬩綋搴撲腑鐨剈pi鍒楄〃 + var quanList = db.wms_stock_quan.ToList().Select(x => x.Upi).ToList(); + var upiList = db.mes_batchOrderUPI_new.Where(x => !quanList.Contains(x.UPI)).ToList(); + foreach (var item in upiList) + { + item.AreaCode = (int)AreaCodeEnum.鏃犲尯鍩�; + item.UpiStatus = (int)UpiStatusEnum.鍒濆; + } + + var packageCodeList = upiList.Select(x => x.PackageCode).ToList(); + var pList = db.mes_package_gather.Where(x => packageCodeList.Contains(x.PackageCode)).ToList(); + foreach (var item in pList) + { + item.AreaCode = (int)AreaCodeEnum.鏃犲尯鍩�; + item.UpiStatus = (int)UpiStatusEnum.鍒濆; + } + //娓呯┖闃熷垪鏁版嵁 + var list = db.mes_upi_linequeue.ToList(); + db.mes_upi_linequeue.RemoveRange(list); + db.SaveChanges(); } if (!string.IsNullOrEmpty(alertMsg)) -- Gitblit v1.9.3