From 648f4270f4f56c5ca284dbcfa650de05e46a7052 Mon Sep 17 00:00:00 2001
From: cjs <2216046164@qq.com>
Date: 星期三, 16 七月 2025 17:20:59 +0800
Subject: [PATCH] 11111

---
 HH.WCS.Mobox3.NongFuLinZhi/process/TaskProcess.cs |   66 +++++++++++++++------------------
 1 files changed, 30 insertions(+), 36 deletions(-)

diff --git a/HH.WCS.Mobox3.NongFuLinZhi/process/TaskProcess.cs b/HH.WCS.Mobox3.NongFuLinZhi/process/TaskProcess.cs
index 5659dd1..28101f5 100644
--- a/HH.WCS.Mobox3.NongFuLinZhi/process/TaskProcess.cs
+++ b/HH.WCS.Mobox3.NongFuLinZhi/process/TaskProcess.cs
@@ -43,6 +43,12 @@
                 Console.WriteLine($"浠诲姟{mst.S_CODE} 璐т綅{mst.S_END_LOC}鍗歌揣瀹屾垚锛岀粓鐐圭粦瀹氬鍣▄mst.S_CNTR_CODE}");
                 LogHelper.Info($"浠诲姟{mst.S_CODE} 璐т綅{mst.S_END_LOC}鍗歌揣瀹屾垚锛岀粓鐐圭粦瀹氬鍣▄mst.S_CNTR_CODE}");
                 LocationHelper.BindingLoc(mst.S_END_LOC, mst.S_CNTR_CODE.Split(',').ToList(),mst.S_TYPE);
+                if (mst.S_TYPE.Contains("婊℃墭涓婄嚎"))
+                {
+                    //瑙g粦鐗╂枡
+                    new SqlHelper<object>().GetInstance().Deleteable<CntrItemRel>().Where(a => mst.S_CNTR_CODE.Contains(a.S_CNTR_CODE)).ExecuteCommand();
+                    new SqlHelper<object>().GetInstance().Updateable<Container>().SetColumns(a => a.N_DETAIL_COUNT == 0).Where(a => mst.S_CNTR_CODE.Contains(a.S_CODE)).ExecuteCommand();
+                }
             }
 
         }
@@ -1359,7 +1365,7 @@
                                                     else
                                                     {
                                                         //鏌ヨ鍚庨潰褰撳墠璐т綅鍚庝竴涓�-                                                        result = db.Queryable<Location>().Where(b => b.S_AREA_CODE == a.S_AREA_CODE && b.N_ROW == a.N_ROW && b.N_COL > a.N_COL && a.N_CURRENT_NUM < a.N_CAPACITY && b.S_LOCK_STATE == "鏃�).OrderBy(b => b.N_COL).First();
+                                                        result = db.Queryable<Location>().Where(b => b.S_AREA_CODE == a.S_AREA_CODE && b.N_ROW == a.N_ROW && b.N_COL > a.N_COL && b.N_CURRENT_NUM < b.N_CAPACITY && b.S_LOCK_STATE == "鏃�).OrderBy(b => b.N_COL).First();
                                                     }
                                                     if (result != null)
                                                     {
@@ -1471,7 +1477,7 @@
                                         LogHelper.Info($"鍑哄簱绠楁硶04:褰撳墠璐т綅缁戝畾鐨勬墭鐩樼爜涓猴細{cntrInfo.S_CNTR_CODE}");
                                         string endItemCode = "";
                                         var itemInfo = db.Queryable<CntrItemRel>().Where(b => b.S_CNTR_CODE == cntrInfo.S_CNTR_CODE).First();
-                                        if (itemInfo != null && itemInfo.S_ITEM_CODE == itemCode)
+                                        if (itemInfo != null)
                                         {
                                             endItemCode = itemInfo.S_ITEM_CODE;
                                         }
@@ -1940,24 +1946,7 @@
                     {
                         var cir = new LocCntrRel { S_LOC_CODE = loc, S_CNTR_CODE = cntrCode, S_SRC = deviceName };
                         if (db.Insertable<LocCntrRel>(cir).ExecuteCommand() > 0) LogHelper.Info($"璐т綅瀹瑰櫒琛ㄧ粦瀹氭垚鍔燂紝璐т綅鍙凤細{loc}锛屾墭鐩樺彿锛歿cntrCode}");
-                        var Con = db.Queryable<Container>().Where(a => a.S_CODE == cntrCode).First();
-                        if(Con == null)
-                        {
-                            int detallCount = 0;
-                            if (!string.IsNullOrEmpty(itemCode))
-                            {
-                                detallCount = 1;
-                            }
-                            if(db.Insertable<Container>(new Container
-                            {
-                                S_CODE = cntrCode,
-                                N_TYPE = 1,
-                                N_DETAIL_COUNT = detallCount
-                            }).ExecuteCommand() > 0)
-                            {
-                                LogHelper.Info($"瀹瑰櫒琛ㄧ粦瀹氭垚鍔燂紝鎵樼洏鍙凤細{cntrCode}");
-                            }
-                        }
+                        
                         if (!string.IsNullOrEmpty(itemCode))
                         {
                             BindCntrItem(cntrCode, itemCode, batchNo, itemlayer, itemName);
@@ -1984,6 +1973,26 @@
             try
             {
                 db.BeginTran();
+
+                var Con = db.Queryable<Container>().Where(a => a.S_CODE == trayCode).First();
+                if (Con == null)
+                {
+                    int detallCount = 1;
+                    if (db.Insertable<Container>(new Container
+                    {
+                        S_CODE = trayCode,
+                        N_TYPE = 1,
+                        N_DETAIL_COUNT = detallCount
+                    }).ExecuteCommand() > 0)
+                    {
+                        LogHelper.Info($"瀹瑰櫒琛ㄧ粦瀹氭垚鍔燂紝鎵樼洏鍙凤細{trayCode}");
+                    }
+                }
+                else
+                {
+                    Con.N_DETAIL_COUNT = 1;
+                    db.Updateable(Con).UpdateColumns(a => new { a.N_DETAIL_COUNT }).ExecuteCommand();
+                }
                 //db.Updateable(cntr).UpdateColumns(it => new { it.S_DEST }).ExecuteCommand();
                 //1.灏嗗師鏈夊鍣ㄧ墿鏂欎俊鎭垹闄�                 //db.Deleteable<CntrItemRel>().Where(it => it.S_CNTR_CODE == cntr.S_CNTR_CODE.Trim()).ExecuteCommand();
@@ -2542,23 +2551,8 @@
             var op = WMSHelper.GetWmsTask(TN_Task.S_OP_CODE);
             if (op != null)
             {
-                if (op.N_B_STATE == 0)
-                {
                     //绛夊緟鐩存帴淇敼鐘舵�涓哄彇娑�-                    op.N_B_STATE = 3;
-                }
-                else if (op.N_B_STATE == 1)
-                {
-                    if (WCSHelper.CheckActionRecordExist(TN_Task.S_CODE, 4))
-                    {
-                        op.N_B_STATE = 2;
-                    }
-                    else
-                    {
-                        op.N_B_STATE = 3;
-                    }
-                }
-                
+                op.N_B_STATE = 2;
                 WMSHelper.UpdateTaskState(op);
             }
             NDCApi.CancelOrder(TN_Task.S_CODE.Trim());

--
Gitblit v1.9.1