非空判断
String value;
switch (j) {
case 0:
value = StringUtils.isEmpty(excel2.getVoucherNumberNew()) ? "" : excel2.getVoucherNumberNew();
break;
case 1:
value = StringUtils.isEmpty(excel2.getExchangeName()) ? "" : excel2.getExchangeName();
break;
case 2:
value = StringUtils.isEmpty(excel2.getBankDeposit()) ? "" : excel2.getBankDeposit();
break;
case 3:
value = StringUtils.isEmpty(excel2.getBankAccountNumber()) ? "" : excel2.getBankAccountNumber();
break;
default:
value = "";
break;
}
return value;
增加其他判断
String value = "";
if(j==0){
if (!StringUtils.isEmpty(excel3.getType())) {
if (excel3.getType().equals("P")) {
value="采购";
} else {
value="销售";
}
}
}
switch (j) {
case 0:
break;
case 1:
value = StringUtils.isEmpty(excel3.getGoodsTypeName()) ? "" : excel3.getGoodsTypeName();
break;
case 2:
value = StringUtils.isEmpty(excel3.getGoodsNo()) ? "" : excel3.getGoodsNo();
break;
case 3:
value = StringUtils.isEmpty(excel3.getMaterialNumber()) ? "" : excel3.getMaterialNumber();
break;
default:
value = "";
break;
}
return value;