map 用法。



List<ProductSoldReport4Person> productSoldReport4Persons = ProductInfoService
.findMySoldReport4Down(param);

Map<String, List<ProductSoldReport4Person>> param5 =new LinkedHashMap<String, List<ProductSoldReport4Person>>();

for (ProductSoldReport4Person person : productSoldReport4Persons) {
List<ProductSoldReport4Person> list = param5.get(person.getStoreUserId());
if (list==null) {
list=new ArrayList<ProductSoldReport4Person>();
}
list.add(person);
param5.put(person.getStoreUserId(), list);
}

for (String key : param5.keySet()) {  

List<ProductSoldReport4Person> listProductSoldReport4Persons = param5.get(key);
ProductSoldReport4Person productSoldReport4Person =  listProductSoldReport4Persons.get(0);
HSSFRow rowHead = sheet.createRow( no++);
rowHead.createCell(0);
rowHead.getCell( 0).setCellValue(HlpUtils.isEmpty(productSoldReport4Person.getStoreUserName())? "[未分类]:":productSoldReport4Person.getStoreUserName()+":");
for (int i = 0; i < listProductSoldReport4Persons.size(); i++) {
ProductSoldReport4Person productSoldReport4Person2 =  listProductSoldReport4Persons.get(i);
HSSFRow row = sheet.createRow( no);
for (int j = 0; j < 7; j++) {
row.createCell(j);
try {
CellStyle cs = row1.getCell(j).getCellStyle();
row.getCell(j).setCellStyle(cs);
} catch (Exception e) {
e.printStackTrace();
}
}


row.getCell( 0).setCellValue(i+1);
switch (reportType) {
case 1:
row.getCell( 1).setCellValue( productSoldReport4Person2.getYyyyMMdd() );
break;
case 2:
row.getCell( 1).setCellValue( productSoldReport4Person2.getYyyyMM());
break;
case 3:
row.getCell( 1).setCellValue( productSoldReport4Person2.getYyyy() );
break;
}
row.getCell( 2).setCellValue(  productSoldReport4Person2.getProductName());
row.getCell( 3).setCellValue(  productSoldReport4Person2.getSoldCount());
row.getCell( 4).setCellValue(  productSoldReport4Person2.getSoldMoney());
row.getCell( 5).setCellValue(  productSoldReport4Person2.getSoldCountByCard() );
row.getCell( 6).setCellValue(  productSoldReport4Person2.getSoldMoneyByCard());
no++;//行号
}
 
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值