1其他出入庫接口代码超时优化 2.领料单接口优化 3.任务状态类型修改 4.空旷出入库逻辑优化

hudong

2025-06-10 eff4c14d88d9240f908dfd7f482f87b2a92f9d0c

 wms/WMSHelper.cs

@@ -135,7 +135,11 @@
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<TN_Inbound_Order>().Includes(a => a.Details).Where(a => a.S_NO == no).First();
        }

        internal static TN_Supplier GetGYSBMOrder(string no)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<TN_Supplier>().Includes(a => a.Details).Where(a => a.S_GYSBM == no).First();
        }
        internal static TN_ASN_Order GetASNOrder(string no)
        {
            var db = new SqlHelper<object>().GetInstance();
@@ -397,6 +401,50 @@
                            S_LOC_CODE = task.S_END_LOC,
                            S_AREA_CODE = task.S_END_AREA,
                            S_CNTR_CODE = task.S_CNTR_CODE,
                            S_BATCH_NO = item.S_BATCH_NO,
                            S_SERIAL_NO = item.S_SERIAL_NO,
                            //D_PRD_DATE = item.D_PRD_DATE,
                            F_QTY = item.F_QTY
                        };
                        db.Insertable(info).ExecuteCommand();
                    }
                }
            }
            catch (Exception ex)
            {
                LogHelper.Error($"上架记录添加异常 异常信息={ex.Message}", ex);
            }
        }

        internal static void addOnShelves(TN_Outbound_Order task,string cntr_code, int action)
        {
            var db = new SqlHelper<object>().GetInstance();
            var s_action = "";
            if (action == 1)
            {
                s_action = "上架";
            }
            else
            {
                s_action = "下架";
            }
            try
            {
                var itemlist = db.Queryable<CntrItemRel>().Where(a => a.S_CNTR_CODE == cntr_code).ToList();
                if (itemlist.Count > 0)
                {
                    foreach (var item in itemlist)
                    {
                        var info = new TN_OnOff_Shelves
                        {
                            S_NO = task.S_NO,
                            N_ACTION = action,
                            S_ACTION = s_action,
                            S_ITEM_CODE = item.S_ITEM_CODE,
                            S_ITEM_NAME = item.S_ITEM_NAME,
                            S_LOC_CODE = task.S_END_LOC,
                            S_AREA_CODE = task.S_END_AREA,
                            S_CNTR_CODE = cntr_code,
                            S_BATCH_NO = item.S_BATCH_NO,
                            S_SERIAL_NO = item.S_SERIAL_NO,
                            //D_PRD_DATE = item.D_PRD_DATE,
@@ -868,9 +916,19 @@
            //修改作业状态 重新启动
            wmsTask.N_B_STATE = 2;
            WMSHelper.UpdateTaskState(wmsTask);
            WCSHelper.UpdateStorStatus(task.S_CNTR_CODE, 4);
            //WCSHelper.UpdateStorStatus(task.S_CNTR_CODE, 4);
        }
        internal static void Fail(WCSTask task)
        {
            var db = new SqlHelper<object>().GetInstance();
            var wmsTask = db.Queryable<WMSTask>().Where(a => a.S_CODE == task.S_OP_CODE).First();

            //修改作业状态 重新启动
            wmsTask.N_B_STATE = 5;
            wmsTask.S_B_STATE = "取消";
            WMSHelper.UpdateTaskState(wmsTask);
           //WCSHelper.UpdateStorStatus(task.S_CNTR_CODE, 4);
        }
        internal static void EndTn(string S_CNTR_CODE)
        {
            var db = new SqlHelper<object>().GetInstance();
@@ -931,7 +989,7 @@

            return result;
        }

    
        internal static WMSTask GetWmsTaskByCntr(string cntr, bool active = true)
        {
            WMSTask result = null;