public Object[][][] getStoAndBatchSelectItems(Long samInvId){ //这个方法用不到啦,可以直接从中间表页面带过去。
Map<String, Object> params = new HashMap<String, Object>();
String hql = "select sampleInventory from SampleInventory sampleInventory " +
"where sampleInventory.id = :samInvId " +
"and sampleInventory.quantity > :quantity ";//只要库存不为0,肯定有入库记录。
params.put("samInvId", samInvId);
params.put("quantity", new BigDecimal(0));
@SuppressWarnings("unchecked")
List<SampleInventory> result =(List<SampleInventory>)sampleInventoryDao.query(hql, params);
if (result.isEmpty()) {
return new Object[0][0][0];
}
Object[][] selectStorages = new Object[result.size()][2];
Object[][] selectBatches = new Object[result.size()][2];
SampleInventory inventory = null;
for (int i = 0; i < result.size(); i++) {
inventory = result.get(i);
selectStorages[i] = new Object[] {
inventory.getStorage().getId(),
inventory.getStorage().getStorageName()};
selectBatches[i] = new Object[] {
inventory.getSampleOriginal().getId(),
inventory.getSampleOriginal().getBatch()
};
}
Object[][][] returnValue = new Object[2][result.size()][2];
returnValue[0] = selectStorages;
returnValue[1] = selectBatches;
return returnValue;
}
三维数组的应用
最新推荐文章于 2024-08-03 16:16:49 发布