| | |
| | | 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> |
| | |
| | | }); |
| | | } |
| | | 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(); |