Index: ssts-returngoods/src/main/java/com/forgon/disinfectsystem/returngoodsrecord/service/ReturnGoodsRecordManagerImpl.java =================================================================== diff -u -r12775 -r12776 --- ssts-returngoods/src/main/java/com/forgon/disinfectsystem/returngoodsrecord/service/ReturnGoodsRecordManagerImpl.java (.../ReturnGoodsRecordManagerImpl.java) (revision 12775) +++ ssts-returngoods/src/main/java/com/forgon/disinfectsystem/returngoodsrecord/service/ReturnGoodsRecordManagerImpl.java (.../ReturnGoodsRecordManagerImpl.java) (revision 12776) @@ -285,8 +285,8 @@ Map idToDisposableGoodsBatchStockMap, List returnDiposableGoodsItems){ - Long diposableGoodsID = returnGoodsItem.getDiposableGoodsID(); - DisposableGoods disposableGoods = idToDisposableGoodsMap.get(diposableGoodsID); + Long disposableGoodsID = returnGoodsItem.getDiposableGoodsID(); + DisposableGoods disposableGoods = idToDisposableGoodsMap.get(disposableGoodsID); Long disposableGoodsBatchStockID = returnGoodsItem.getDisposableGoodsBatchStockID(); Double price = returnGoodsItem.getPrice(); if(price == null){ @@ -423,7 +423,7 @@ // 获取并锁定一次性物品相关资源,TODO 加载物品批次待优化 private void lockAndGetDiposableGoodsResources( Long warehouseID, - Set diposableGoodsIDsSet, + Set disposableGoodsIDsSet, Set diposableGoodsStockIDsSet, Set disposableGoodsBatchIDsSet, Set disposableGoodsBatchStockIDsSet, @@ -438,9 +438,9 @@ // 锁定一次性物品 List disposableGoodsList = diposableGoodsManager - .getDisposableGoodsByDisposableGoodsIDs_ForUpdate(diposableGoodsIDsSet); + .getDisposableGoodsByDisposableGoodsIDs_ForUpdate(disposableGoodsIDsSet); if (disposableGoodsList == null - || disposableGoodsList.size() != diposableGoodsIDsSet.size()) { + || disposableGoodsList.size() != disposableGoodsIDsSet.size()) { throw new RuntimeException("某些物品已被删除!"); } for (DisposableGoods disposableGoods : disposableGoodsList) { @@ -465,7 +465,7 @@ // 加载所有的批次定义 String getDisposableGoodsBatchSql = String.format(" where %s ", SqlUtils.getNonStringFieldInCollectionsPredicate( - "po.diposableGoods.id", diposableGoodsIDsSet)); + "po.diposableGoods.id", disposableGoodsIDsSet)); List disposableGoodsBatchs = objectDao.findBySql( DisposableGoodsBatch.class.getSimpleName(), getDisposableGoodsBatchSql); @@ -479,7 +479,7 @@ // String getDisposableGoodsStockSql = // String.format(" where %s and po.warehouseID=%s", // SqlUtils.getStringFieldInCollectionsPredicate("po.disposableGoodsID", - // diposableGoodsIDsSet),warehouseID); + // disposableGoodsIDsSet),warehouseID); // List disposableGoodsStocks = // objectDao.findBySql(DisposableGoodsStock.class.getSimpleName(),getDisposableGoodsStockSql); // if(disposableGoodsStocks != null){ @@ -1163,13 +1163,13 @@ * 的发货项,根据价格分组,算出每个价格对应的数量,返回前台页面,让用户选择价格再退货。 * 限定条件 部门,发货日期(TODO),一次性物品,批次号*/ public List loadDiposableGoodsPriceAmountInfoCanReturned(String warehouseID,String depart, - String diposableGoodsID, String diposableGoodsName, String barcode, + String disposableGoodsID, String diposableGoodsName, String barcode, String batchNumber) { StringBuilder sql = new StringBuilder(); String diposableGoodsSql = null; String batchSql = null; List priceAmountList = new LinkedList(); - if (StringUtils.isNotBlank(diposableGoodsID)) { + if (StringUtils.isNotBlank(disposableGoodsID)) { // TODO diposableGoodsSql = String.format(" and d.name='%s'", diposableGoodsName); @@ -1221,15 +1221,15 @@ return priceAmountList; } // 根据一次性物品ID和部门,找出可以退货的批次 - public String getDisposableGoodsBatchStocksByDisposableGoodsStockIDAndWarehouseDepart(String diposableGoodsID,String warehouseID, + public String getDisposableGoodsBatchStocksByDisposableGoodsStockIDAndWarehouseDepart(String disposableGoodsID,String warehouseID, String depart) { String isNullFunction = DatabaseUtil.getSqlIsNullFunctionName(dbConnection); String sql = String - .format(" where po.id in(select distinct d.disposableGoodsStockID from %s i,%s d" - + " where i.id = d.invoice.id and d.diposableGoodsID='%s' and %s(d.amount,0)>%s(d.returnedAmount,0) and i.warehouseID=%s and i.settleAccountsDepart ='%s')", + .format(" where po.id in(select distinct d.disposableGoodsBatchStockID from %s i,%s d" + + " where i.id = d.invoice.id and d.disposableGoodsID='%s' and %s(d.amount,0)>%s(d.returnedAmount,0) and i.warehouseID=%s and i.settleAccountsDepart ='%s')", Invoice.class.getSimpleName(), DiposableGoodsItem.class.getSimpleName(), - diposableGoodsID, isNullFunction, isNullFunction,warehouseID, + disposableGoodsID, isNullFunction, isNullFunction,warehouseID, depart); List batchStocks = diposableGoodBatchStockManager .getDiposableGoodBatchBySql(sql);