1.冲销出库流程联调 2.冲销入库流程联调 3.普通出库 回调逻辑测试 4.物料凭证表结构修改，逻辑修改

hudong

2025-05-15 f7b58cf11dad9b6acfbe3eab4352d72a57fb7ecf

 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();
@@ -412,6 +416,50 @@
            }
        }

        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,
                            F_QTY = item.F_QTY
                        };
                        db.Insertable(info).ExecuteCommand();
                    }
                }
            }
            catch (Exception ex)
            {
                LogHelper.Error($"上架记录添加异常 异常信息={ex.Message}", ex);
            }
        }

        internal static void AddChange(WCSTask task)
        {
            var db = new SqlHelper<object>().GetInstance();