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++;//行号
}
}