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