futian.liu
2023-12-09 186f6eb07df6934d2e28330ba39dcfce30c0063a
consum-base/src/main/java/com/consum/base/service/FinWarehouseLedgerServiceImpl.java
@@ -34,8 +34,9 @@
        }
        //机构
        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());
        }
        //仓库类型
@@ -141,8 +142,9 @@
        }
        //机构
        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());
        }
        //仓库类型