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