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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
package pwc.taxtech.atms.dao;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.session.RowBounds;
import pwc.taxtech.atms.MyMapper;
import pwc.taxtech.atms.dto.TemplateAndGroupDbDto;
import pwc.taxtech.atms.dto.TemplateUniqDto;
import pwc.taxtech.atms.dto.vatdto.ReportDto;
import pwc.taxtech.atms.entitiy.Template;
import pwc.taxtech.atms.entitiy.TemplateExample;
@Mapper
public interface TemplateMapper extends MyMapper {
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
long countByExample(TemplateExample example);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
int deleteByExample(TemplateExample example);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
int deleteByPrimaryKey(Long id);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
int insert(Template record);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
int insertSelective(Template record);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
List<Template> selectByExampleWithRowbounds(TemplateExample example, RowBounds rowBounds);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
List<Template> selectByExample(TemplateExample example);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
Template selectByPrimaryKey(Long id);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
int updateByExampleSelective(@Param("record") Template record, @Param("example") TemplateExample example);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
int updateByExample(@Param("record") Template record, @Param("example") TemplateExample example);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
int updateByPrimaryKeySelective(Template record);
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table template
*
* @mbg.generated
*/
int updateByPrimaryKey(Template record);
/**
* 获取TemplateUniqDto
* @param serviceTypeID
* @param payTaxType
* @param reportType
* @param indeustryIDs
* @return TemplateUniqDto List
*/
List<TemplateUniqDto> getTemplateUniqDtosByTemplateAndTemplateGroup(Map<String,Object> map);
/**
* 根据templateID获取template 和 templategroup 对象
* @param ID templateID
* @return
*/
TemplateAndGroupDbDto getTemplateAndGroupByID(@Param("ID") String ID);
/**
* 根据模板名称获取模板和模板分组数量
* @param map 模板组ID, 模板ID,模板名称
* @return
*/
long getCountOfTemplateAndGroupByTemplateName(Map<String,Object> map);
/**
* 获取模板的所有报表
* @param map 月份,项目ID,数据库名称,模板组ID
* @return
*/
List<ReportDto> getTemplateLeftJoinReport(Map<String, Object> map);
List<Long> getIDsForExceptTemplate();
}