| | |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public SysSupplier getSysSupplier(String id) { |
| | | public SysSupplier getSysSupplier(Long id) { |
| | | try { |
| | | return this.sysSupplierDao.getSysSupplier(id); |
| | | } catch (DataAccessException e) { |
| | |
| | | } |
| | | |
| | | @Override |
| | | public String getSysSupplierId(String name, String groupId) { |
| | | public Long getSysSupplierId(String name, Long groupId) { |
| | | try { |
| | | return this.sysSupplierDao.getSysSupplierId(name, groupId); |
| | | } catch (DataAccessException e) { |
| | |
| | | } |
| | | |
| | | @Override |
| | | public String getSysSupplierIdByname(String name) { |
| | | public Long getSysSupplierIdByname(String name) { |
| | | try { |
| | | return this.sysSupplierDao.getSysSupplierIdByname(name); |
| | | } catch (DataAccessException e) { |
| | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public SysSupplier insertSysSupplier(SysSupplier sysSupplier) { |
| | | try { |
| | | if (sysSupplier.getId() == null) { |
| | | sysSupplier.setId(IDUtils.uuid()); |
| | | } |
| | | // if (sysSupplier.getId() == null) { |
| | | // sysSupplier.setId(IDUtils.uuid()); |
| | | // } |
| | | this.sysSupplierDao.insertSysSupplier(sysSupplier); |
| | | return sysSupplier; |
| | | } catch (DuplicateKeyException ex) { |
| | |
| | | return false; |
| | | } |
| | | |
| | | List<String> ids = new ArrayList<String>(); |
| | | List<Long> ids = new ArrayList<Long>(); |
| | | for (SysSupplier sysSupplier : sysSupplierList) { |
| | | ids.add(sysSupplier.getId()); |
| | | } |
| | |
| | | public void importSupplier(FileUploadEvent event) throws Exception { |
| | | |
| | | List<SysSupplier> list = sysSupplierDao.getSysSupplierList(new HashMap()); |
| | | Map<String, String> supplierMap = new HashMap(); |
| | | Map<String, Long> supplierMap = new HashMap(); |
| | | list.forEach(supplier -> { |
| | | supplierMap.put(supplier.getName(), supplier.getId()); |
| | | }); |
| | |
| | | } |
| | | valuesList.add(cellInfo); |
| | | } |
| | | if (valuesList.size() != 4){ |
| | | break; |
| | | } |
| | | |
| | | SysSupplier sysSupplier = new SysSupplier(); |
| | | //这一行有供应商是数据库里的就跳过 |
| | |
| | | continue; |
| | | } |
| | | |
| | | sysSupplier.setId(IDUtils.uuid()); |
| | | // sysSupplier.setId(IDUtils.uuid()); |
| | | sysSupplier.setName(valuesList.get(0)); |
| | | sysSupplier.setPersonName(valuesList.get(1)); |
| | | sysSupplier.setPhone(valuesList.get(2)); |
| | |
| | | ExcelUtils.export2Excel(list,"供应商信息",map); |
| | | } |
| | | |
| | | @Override |
| | | public SysSupplier getSysSupplierByName(String name) { |
| | | return sysSupplierDao.getSysSupplierByName(name); |
| | | } |
| | | |
| | | } |