From 7c63794aa85ab939308d10a9ad5c1a57c46bbf6f Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周六, 14 12月 2024 14:01:46 +0800
Subject: [PATCH] 222

---
 CC/iWareCC_ASRS/FormCC.cs |  141 +++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 141 insertions(+), 0 deletions(-)

diff --git a/CC/iWareCC_ASRS/FormCC.cs b/CC/iWareCC_ASRS/FormCC.cs
index 36a52a0..bab25df 100644
--- a/CC/iWareCC_ASRS/FormCC.cs
+++ b/CC/iWareCC_ASRS/FormCC.cs
@@ -20,6 +20,7 @@
 using System;
 using System.Collections.Generic;
 using System.Data;
+using System.Data.Entity.Core.Metadata.Edm;
 using System.Drawing;
 using System.Linq;
 using System.Linq.Expressions;
@@ -29,6 +30,7 @@
 using System.Windows.Forms;
 using XiGang.Core.Model;
 using XiGang.Core.Model.ViewModels;
+using static WZ.Useful.Commons.NativeMethods;
 
 
 namespace iWareCC
@@ -1477,6 +1479,145 @@
                     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))
+            {
+                MessageBox.Show("閿欒:" + alertMsg);
+            }
+            else
+            {
+                MessageBox.Show("宸插鐞�");
+            }
+        }
+
+        private void btn1_Click(object sender, EventArgs e)
+        {
+            var taskNo = this.tb_taskNo.Text.Trim();
+
+            var alertMsg = "";
+            using (WmsDBModel wmsDB = new WmsDBModel())
+            {
+                var task = wmsDB.wms_rbline_task.Where(x => x.TaskNo == taskNo && x.RbTaskType == (int)RbTaskTypeEnum.鍏ュ簱浠诲姟 && x.TaskStatus == (int)TaskStatusEnum.宸蹭笅鍙�).FirstOrDefault();
+                if (task == null)
+                {
+                    MessageBox.Show("娌℃壘鍒颁换鍔�");
+                    return;
+                }
+
+                var upiCode = task.Upi;
+                var upiObj = wmsDB.mes_batchOrderUPI_new.Where(x => x.UPI == upiCode).FirstOrDefault();
+                if (upiObj == null)
+                {
+                    MessageBox.Show($"鏍规嵁UPI:{upiCode}娌℃湁鎵惧埌瀵硅薄 ");
+                    return;
+                }
+                //澧炲姞搴撳瓨
+                wms_stock_quan qun = new wms_stock_quan()
+                {
+                    Id = Yitter.IdGenerator.YitIdHelper.NextId(),
+                    Shelf = upiObj.Shelf,
+                    Upi = upiCode,
+                    PlanNo = task.PlanNo,
+                    DetailName = upiObj.DetailName,
+                    OrderId = task.OrderId,
+                    CreateTime = DateTime.Now,
+                    CreateUserName = SysGloble.WCSSystem,
+                    InTime = DateTime.Now,
+                    OperReason = "鍏ュ簱",
+                    PackageCode = task.PackageCode,
+                    Length = task.Length,
+                    Width = task.Width,
+                    Thk = task.Thk,
+                    PlaceCode = task.PlaceCode,
+                    StockStatus = (int)StockStatusEnum.鍦ㄥ簱,
+                    StockStatusName = StockStatusEnum.鍦ㄥ簱.ToString(),
+
+                };
+                wmsDB.wms_stock_quan.Add(qun);
+
+                task.TaskStatus = (int)TaskStatusEnum.宸插畬鎴�;
+                task.FinishedTime = DateTime.Now;
+
+
+                var place = StationHandler.GetPlaceByPlaceCode(task.PlaceCode, wmsDB);
+                place.PlaceStatus = (int)PlaceStatusEnum.姝e父;
+
+
+                WmsRecordUpiProcessHandler.SaveWmsRecordUpiProcess(wmsDB, upiObj, task.PlaceCode, "缂撳瓨鍏ュ簱瀹屾垚:" + task.PlaceCode);
+
+                wmsDB.SaveChanges();
+            }
+            if (!string.IsNullOrEmpty(alertMsg))
+            {
+                MessageBox.Show("閿欒:" + alertMsg);
+            }
+            else
+            {
+                MessageBox.Show("宸插鐞�");
+            }
+        }
+
+        private void button2_Click(object sender, EventArgs e)
+        {
+            //鏇存柊搴撳瓨琛ㄤ腑鐨勬搴忓瓧娈�
+            var alertMsg = "";
+            using (WmsDBModel db = new WmsDBModel())
+            {
+                //鏌ヨ绔嬩綋搴撲腑鐨剈pi鍒楄〃
+                var quanList = db.wms_stock_quan.ToList();
+                var query_quanList = quanList.Select(x => x.Upi).ToList();
+                var upiList = db.mes_batchOrderUPI_new.Where(x => query_quanList.Contains(x.UPI)).ToList();
+                foreach (var item in quanList)
+                {
+                    var _shelf = upiList.Find(x => x.UPI == item.Upi);
+                    item.Shelf = _shelf.Shelf;
+                }
+
+
                 db.SaveChanges();
             }
             if (!string.IsNullOrEmpty(alertMsg))

--
Gitblit v1.9.3