| | |
| | | import com.nanometer.smartlab.exception.AlarmException; |
| | | import com.nanometer.smartlab.exception.BusinessException; |
| | | import com.nanometer.smartlab.exception.ExceptionEnumCode; |
| | | import com.nanometer.smartlab.util.ExcelUtils; |
| | | import com.nanometer.smartlab.util.IDUtils; |
| | | import com.nanometer.smartlab.util.MessageUtil; |
| | | import org.apache.commons.lang.StringUtils; |
| | |
| | | } |
| | | valuesList.add(cellInfo); |
| | | } |
| | | if (valuesList.size() != 4){ |
| | | break; |
| | | } |
| | | |
| | | SysSupplier sysSupplier = new SysSupplier(); |
| | | //这一行有供应商是数据库里的就跳过 |
| | |
| | | |
| | | } |
| | | |
| | | @Override |
| | | public List<Map> exportExcelList(String name) { |
| | | Map<String, String> params = new HashMap<>(); |
| | | params.put("name", name); |
| | | return sysSupplierDao.exportExcelList(params); |
| | | } |
| | | |
| | | @Override |
| | | public void export2Excel(List<Map> list) throws Exception { |
| | | Map<String,String> map = new LinkedHashMap<>(); |
| | | map.put("name", "供应商名"); |
| | | map.put("personName", "联系人"); |
| | | map.put("phone", "电话"); |
| | | map.put("memo", "备注"); |
| | | ExcelUtils.export2Excel(list,"供应商信息",map); |
| | | } |
| | | |
| | | @Override |
| | | public SysSupplier getSysSupplierByName(String name) { |
| | | return sysSupplierDao.getSysSupplierByName(name); |
| | | } |
| | | |
| | | } |