zmc
2023-11-23 3ba74e7692143fd6dcf4dd885f80f95dfef8387e
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
package com.flightfeather.monitor.service.impl;
 
import com.flightfeather.monitor.domain.ds1.entity.DustSiteInfo;
import com.flightfeather.monitor.domain.ds1.mapper.DustSiteInfoMapper;
import com.flightfeather.monitor.service.DustSiteInfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import tk.mybatis.mapper.entity.Example;
 
import java.util.List;
 
@Service
public class DustSiteInfoServiceImpl implements DustSiteInfoService {
 
    @Autowired
    private DustSiteInfoMapper dustSiteInfoMapper;
    @Override
    public List<DustSiteInfo> querySiteInfoBymnCode(String mnCode) {
 
        Example example = new Example(DustSiteInfo.class);
        example.createCriteria().andEqualTo("mnCode",mnCode);
        List<DustSiteInfo> list  = dustSiteInfoMapper.selectByExample(example);
        return list;
    }
 
    @Override
    public List<DustSiteInfo> queryAllDutyCompany() {
        Example example = new Example(DustSiteInfo.class);
        example.setDistinct(true);
        example.selectProperties("dutyCompany");
        List<DustSiteInfo> list  = dustSiteInfoMapper.selectByExample(example);
        return list;
    }
 
    @Override
    public List<DustSiteInfo> queryStreet(String street) {
        Example example = new Example(DustSiteInfo.class);
        example.setDistinct(true);
        example.selectProperties("address");
        example.createCriteria().andLike("address","%"+street+"%");
        List<DustSiteInfo> list  = dustSiteInfoMapper.selectByExample(example);
        return list;
    }
 
    @Override
    public List<DustSiteInfo> queryMncodeBySiteName(String siteName) {
        Example example = new Example(DustSiteInfo.class);
        example.createCriteria().andEqualTo("name",siteName);
        List<DustSiteInfo> list  = dustSiteInfoMapper.selectByExample(example);
        return list;
    }
 
 
 
}