YjjtSlDataServiceImpl.java 2.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. package com.goldenwater.yjjt.service.impl;
  2. import com.goldenwater.common.utils.DateUtils;
  3. import com.goldenwater.common.utils.StringUtils;
  4. import com.goldenwater.yjjt.domain.YjjtFile;
  5. import com.goldenwater.yjjt.domain.YjjtSlData;
  6. import com.goldenwater.yjjt.mapper.YjjtFileMapper;
  7. import com.goldenwater.yjjt.mapper.YjjtSlDataMapper;
  8. import com.goldenwater.yjjt.service.IYjjtSlDataService;
  9. import org.springframework.stereotype.Service;
  10. import org.springframework.transaction.annotation.Transactional;
  11. import jakarta.annotation.Resource;
  12. import java.text.SimpleDateFormat;
  13. import java.util.List;
  14. @Service("yjjtSlDataService")
  15. public class YjjtSlDataServiceImpl implements IYjjtSlDataService {
  16. @Resource
  17. private YjjtSlDataMapper yjjtSlDataMapper;
  18. @Resource
  19. private YjjtFileMapper yjjtFileMapper;
  20. @Override
  21. public List<YjjtSlData> selectYjjtSlDataList(YjjtSlData yjjtSlData) {
  22. return yjjtSlDataMapper.selectYjjtSlDataList(yjjtSlData);
  23. }
  24. @Override
  25. public YjjtSlData selectYjjtSlDataById(Long id) {
  26. return yjjtSlDataMapper.selectYjjtSlDataById(id);
  27. }
  28. @Override
  29. public int insertYjjtSlData(YjjtSlData yjjtSlData) {
  30. yjjtSlData.setCreateTime(DateUtils.getNowDate());
  31. return yjjtSlDataMapper.insertYjjtSlData(yjjtSlData);
  32. }
  33. @Override
  34. public int updateYjjtSlData(YjjtSlData yjjtSlData) {
  35. yjjtSlData.setUpdateTime(DateUtils.getNowDate());
  36. return yjjtSlDataMapper.updateYjjtSlData(yjjtSlData);
  37. }
  38. @Override
  39. public int deleteYjjtSlDataById(Long id) {
  40. return yjjtSlDataMapper.deleteYjjtSlDataById(id);
  41. }
  42. @Override
  43. public int deleteYjjtSlDataByIds(Long[] ids) {
  44. return yjjtSlDataMapper.deleteYjjtSlDataByIds(ids);
  45. }
  46. @Override
  47. @Transactional
  48. public void importSlData(List<YjjtSlData> dataList) {
  49. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  50. for (YjjtSlData data : dataList) {
  51. String sptStr = sdf.format(data.getSpt());
  52. int count = yjjtSlDataMapper.countByStcdAndSpt(data.getStcd(), sptStr, data.getAddvcd());
  53. if (count > 0) {
  54. yjjtSlDataMapper.updateYjjtSlData(data);
  55. } else {
  56. yjjtSlDataMapper.insertYjjtSlData(data);
  57. }
  58. }
  59. }
  60. }