Index: ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/SupplyRoomControlManagerImpl.java =================================================================== diff -u -r14817 -r14823 --- ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/SupplyRoomControlManagerImpl.java (.../SupplyRoomControlManagerImpl.java) (revision 14817) +++ ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/SupplyRoomControlManagerImpl.java (.../SupplyRoomControlManagerImpl.java) (revision 14823) @@ -120,7 +120,7 @@ "ip.departCoding as \"departCoding\",ip.applicationTime as \"applicationTime\"," + "ip.submitTime as \"submitTime\",ip.printTime as \"printTime\"," + "ip.serialNumber as \"serialNumber\",ip.settleAccountsDepart as \"settleAccountsDepart\"," + - "ip.remark as \"remark\",ip.applicant as \"applicant\",po.diposable as \"diposable\"" + dressing1; + "replace(ip.remark,'\"',' ') as \"remark\",ip.applicant as \"applicant\",po.diposable as \"diposable\"" + dressing1; String whereSql = " from TousseItem po,invoicePlan ip left join RecyclingRecord rr" +" on rr.recyclingApplication_id = ip.id where po.RecyclingApplication_id = ip.id "