| | |
| | | } |
| | | //机构 |
| | | if (param.getAgencyId() != null) { |
| | | sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId"); |
| | | paramts.put("lengthAgencyId", param.getAgencyId()); |
| | | // sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId"); |
| | | sql.append(" and ware.AGENCY_ID = :agencyId"); |
| | | // paramts.put("lengthAgencyId", param.getAgencyId()); |
| | | paramts.put("agencyId", param.getAgencyId()); |
| | | } |
| | | //仓库类型 |
| | |
| | | } |
| | | //机构 |
| | | if (param.getAgencyId() != null) { |
| | | sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId"); |
| | | paramts.put("lengthAgencyId", param.getAgencyId()); |
| | | // sql.append(" and left(ware.AGENCY_ID, length(:lengthAgencyId)) = :agencyId"); |
| | | sql.append(" and ware.AGENCY_ID = :agencyId"); |
| | | // paramts.put("lengthAgencyId", param.getAgencyId()); |
| | | paramts.put("agencyId", param.getAgencyId()); |
| | | } |
| | | //仓库类型 |