杨前锦
2025-06-13 b7308bba3d7ffad271ce7fc7a93c8c45d76be87d
HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/LocationHelper.cs
@@ -112,6 +112,19 @@
            return db.Queryable<Location>().Where(a => a.S_AREA_CODE.Trim() == areaCode && a.N_CURRENT_NUM == 0 && a.N_LOCK_STATE == 0 && a.C_ENABLE == "Y").First();
        }
        internal static bool checkAreaExistCntr(List<string> areaCodes ,string cntrCode)
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<Location>()
                    .LeftJoin<LocCntrRel>((a,b) => a.S_CODE == b.S_LOC_CODE)
                    .Where((a, b) => areaCodes.Contains(a.S_AREA_CODE.Trim())
                                && a.N_CURRENT_NUM == 0
                                && a.N_LOCK_STATE == 0
                                && a.C_ENABLE == "Y"
                                && b.S_CNTR_CODE == cntrCode
                                ).Count() > 0;
        }
        /// <summary>
        ///获取所有货位扩展信息 
        /// </summary>
@@ -150,8 +163,16 @@
                });
            }
            return result;
        }
        internal static LocCntrRel GetLocCntrByCntr(string cntrCode)
        {
            var result = new List<LocCntrRel>();
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<LocCntrRel>().Where(a => a.S_CNTR_CODE.Trim() == cntrCode).OrderBy(a => a.T_CREATE).First();
        }
        internal static List<LocCntrRel> GetLocCntrRel(string loc) {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();