福建佳通-流程优化

杨前锦

2025-07-01 a93b0e99036c24b9bd58c79bf5e7364b1ba28bae

 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();
@@ -293,7 +314,7 @@
            try
            {
                db.BeginTran();
                var count = db.Deleteable<LocCntrRel>().Where(it => it.S_LOC_CODE.Trim() == loc).ExecuteCommand();
                db.Deleteable<LocCntrRel>().Where(it => it.S_LOC_CODE.Trim() == loc).ExecuteCommand();
                location.N_CURRENT_NUM = 0;
                location.N_LOCK_STATE = 0;
                location.S_LOCK_STATE = Location.GetLockStateStr(location.N_LOCK_STATE);