Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/action/TousseInstanceAction.java =================================================================== diff -u -r31515 -r32804 --- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/action/TousseInstanceAction.java (.../TousseInstanceAction.java) (revision 31515) +++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/action/TousseInstanceAction.java (.../TousseInstanceAction.java) (revision 32804) @@ -1855,5 +1855,19 @@ StrutsResponseUtils.output(false); } } - + /** + * 获取包实例标识牌编号 + */ + public void findIdNumberByTousseInstanceId(){ + try { + Long tousseInstanceId = StrutsParamUtils.getPraramLongValue("tousseInstanceId", null); + String idNumber = tousseInstanceManager.findIdNumberByTousseInstanceId(tousseInstanceId); + JSONObject obj = new JSONObject(); + obj.put("idNumber", idNumber); + StrutsResponseUtils.output(true, obj); + } catch (Exception e) { + e.printStackTrace(); + StrutsResponseUtils.output(false, e.getMessage()); + } + } } \ No newline at end of file Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java =================================================================== diff -u -r32657 -r32804 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 32657) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 32804) @@ -9412,4 +9412,32 @@ return arr; } + @Override + public String findIdNumberByTousseInstanceId(Long tousseInstanceId) { + if(!DatabaseUtil.isPoIdValid(tousseInstanceId)){ + throw new SystemException("tousseInstanceId参数值异常,值为" + tousseInstanceId); + } + String idNumber = null; + ResultSet rs = null; + try { + String sql = String.format("select icd.idNumber from %s icd " + + "join %s ici on icd.id=ici.idCardDefinitionID " + + "join %s ti on ti.idCardInstanceID=ici.id " + + "where ti.id=%s", + IDCardDefinition.class.getSimpleName(), + IDCardInstance.class.getSimpleName(), + TousseInstance.class.getSimpleName(), + tousseInstanceId); + rs = objectDao.executeSql(sql); + while(rs.next()){ + idNumber = rs.getString("idNumber"); + break; + } + } catch (SQLException e) { + e.printStackTrace(); + }finally { + DatabaseUtil.closeResultSetAndStatement(rs); + } + return idNumber; + } } Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManager.java =================================================================== diff -u -r31515 -r32804 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManager.java (.../TousseInstanceManager.java) (revision 31515) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManager.java (.../TousseInstanceManager.java) (revision 32804) @@ -1177,5 +1177,11 @@ */ public JSONArray getTousseInsBarcodeArrBySterilizationRecord(Long id, String barcode); + /** + * 获取包实例标识牌编号 + * @param tousseInstanceId + * @return + */ + public String findIdNumberByTousseInstanceId(Long tousseInstanceId); }