| | |
|---|
| | | var queryable = db.Queryable<Location>() |
|---|
| | | .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE) |
|---|
| | | .LeftJoin<CntrItemDetail>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE) |
|---|
| | | .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode); |
|---|
| | | .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode ); |
|---|
| | | //六位码匹配前六位，其他的全部配置 |
|---|
| | | if (ItemCode.Trim().Length == 6) |
|---|
| | | { |
|---|
| | |
|---|
| | | queryable = db.Queryable<Location>() |
|---|
| | | .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE) |
|---|
| | | .LeftJoin<CntrItemDetail>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE) |
|---|
| | | .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode); |
|---|
| | | .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode ); |
|---|
| | | //六位码匹配前六位，其他的全部配置 |
|---|
| | | if (ItemCode.Trim().Length == 6) |
|---|
| | | { |
|---|
