ProjectNoErpService.java
1.65 KB
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
package com.huaheng.pc.config.projectNo.service;
import java.text.SimpleDateFormat;
import java.time.Instant;
import java.time.temporal.ChronoUnit;
import java.util.Date;
import java.util.List;
import javax.annotation.Resource;
import com.huaheng.pc.config.material.domain.MaterialErp;
import com.huaheng.pc.config.projectNo.domain.ProjectNoErp;
import com.huaheng.pc.config.projectNo.mapper.ProjectNoErpMapper;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.huaheng.framework.aspectj.lang.annotation.Ds;
import com.huaheng.framework.aspectj.lang.constant.DataSourceName;
import com.huaheng.pc.config.address.domain.Address;
import com.huaheng.pc.config.supplier.domain.SupplierErp;
import com.huaheng.pc.config.supplier.mapper.SupplierErpMapper;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
@Service
public class ProjectNoErpService extends ServiceImpl<ProjectNoErpMapper, ProjectNoErp>{
/**
* 查找erp数据库的项目名称
* @return
*/
@Ds(name= DataSourceName.SLAVE)
@Transactional(propagation = Propagation.REQUIRES_NEW)
public List<ProjectNoErp> getErpProjectNos(List<String> codes){
QueryWrapper<ProjectNoErp> queryWrapper = new QueryWrapper<>();
queryWrapper.in("PJAB001", codes);
queryWrapper.isNotNull("PJABL003");
queryWrapper.select(" PJAB001 ,PJABL003 ,PJAB014");
List<ProjectNoErp> projectNoErps = this.list(queryWrapper);
return projectNoErps;
}
}