杭氧测试流程

pengmn

2025-05-28 382c009ba2bb04374468e9584f262d6682841d9b

 HH.WCS.Mobox3.HangYang/wms/ContainerHelper.cs

@@ -138,19 +138,6 @@

            return res;
        }
        /// <summary>
        /// TN_ContainerHelper.test("4L天然水箱装6入", 50, "335ml东方树叶15入", 30);
        /// </summary>
        /// <param name="item1"></param>
        /// <param name="qty1"></param>
        /// <param name="item2"></param>
        /// <param name="qty2"></param>
        //internal static void test(string item1, int qty1, string item2, int qty2) {
        //    var db = new SqlHelper<object>().GetInstance();
        //    var cntr = db.Queryable<TN_Container>().Includes(a => a.CntrItemRelList).
        //        Where(a => a.CntrItemRelList.Count(b => b.S_ITEM_CODE == item1 && int.Parse(b.F_QTY) > qty1) > 0
        //        && a.CntrItemRelList.Count(b => b.S_ITEM_CODE == item2 && int.Parse(b.F_QTY) > qty2) > 0).First();
        //}

        /// <summary>
        /// 判断容器是否有物料信息
@@ -574,6 +561,27 @@
            return res;
        }

        /// <summary>
        /// 修改容器物料表入库时间
        /// </summary>
        /// <param name="trayCode">托盘号</param>
        /// <returns></returns>
        internal static bool UpdateCntrItem(string trayCode)
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
            var model = db.Queryable<CntrItemDetail>().Where(a => a.S_CNTR_CODE == trayCode).ToList();
            foreach (var item in model)
            {
                if (item.T_INBOUND_TIME == null)
                {
                    item.T_INBOUND_TIME = DateTime.Now;
                    res = db.Updateable(item).UpdateColumns(it => new { it.T_INBOUND_TIME }).ExecuteCommand() > 0;
                }
            }
            return res;
        }


        /// <summary>
        /// 查询被标记的托盘