危废处理合同信息管理系统 - 数据查询和导出

<p>/**</p>
<ul>
<li>危废处理合同内容：信息</li>
<li>@param page 分页对象</li>
<li>@param mapData</li>
<li>@return
<em>/
public List&lt;Map&lt;String, Object&gt;&gt; dataGrid(Map&lt;String, Object&gt; mapData) {
String content=content(mapData);
String sql = &quot; SELECT top &quot; + mapData.get(&quot;pageSize&quot;) + &quot; * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY a.id desc) AS RowNumber,a.</em> FROM yhpc_contract a WHERE S3=0 &quot; + content + &quot; ) &quot;
+ &quot; as s WHERE  RowNumber &gt; &quot; + mapData.get(&quot;pageSize&quot;) + &quot;*(&quot; + mapData.get(&quot;pageNo&quot;) + &quot;-1) &quot;;
List&lt;Map&lt;String, Object&gt;&gt; list=findBySql(sql, null,Map.class);
return list;
}</li>
</ul>
<p>/**</p>
<ul>
<li>查询条件</li>
<li>@param mapData</li>
<li>@return
*/
public String content(Map&lt;String, Object&gt; mapData) {
String content=&quot;&quot;;
if(mapData.get(&quot;qyname&quot;)!=null&amp;&amp;mapData.get(&quot;qyname&quot;)!=&quot;&quot;){
content = content +&quot; AND a.qyname like '%&quot; + mapData.get(&quot;qyname&quot;) + &quot;%' &quot;;
}
if(mapData.get(&quot;m1&quot;)!=null&amp;&amp;mapData.get(&quot;m1&quot;)!=&quot;&quot;){
content = content +&quot; AND a.m1 = '&quot; + mapData.get(&quot;m1&quot;) + &quot;' &quot;;
}
if(mapData.get(&quot;m2&quot;)!=null&amp;&amp;mapData.get(&quot;m2&quot;)!=&quot;&quot;){
content = content +&quot; AND a.m2 = '&quot; + mapData.get(&quot;m2&quot;) + &quot;' &quot;;
}
if(mapData.get(&quot;qyid&quot;)!=null&amp;&amp;mapData.get(&quot;qyid&quot;)!=&quot;&quot;){
content = content +&quot; AND a.qyid = &quot; + mapData.get(&quot;qyid&quot;) + &quot; &quot;;
}
if(mapData.get(&quot;m3&quot;)!=null&amp;&amp;mapData.get(&quot;m3&quot;)!=&quot;&quot;){
content = content +&quot; AND a.m3 like '%&quot; + mapData.get(&quot;m3&quot;) + &quot;%' &quot;;
}
if(mapData.get(&quot;m4&quot;)!=null&amp;&amp;mapData.get(&quot;m4&quot;)!=&quot;&quot;){
content = content +&quot; AND a.m4 like '%&quot; + mapData.get(&quot;m4&quot;) + &quot;%' &quot;;
}
if(mapData.get(&quot;m5&quot;)!=null&amp;&amp;mapData.get(&quot;m5&quot;)!=&quot;&quot;){
content = content +&quot; AND a.m5 = '&quot; + mapData.get(&quot;m5&quot;) + &quot;' &quot;;
}
if(mapData.get(&quot;m6&quot;)!=null&amp;&amp;mapData.get(&quot;m6&quot;)!=&quot;&quot;){
content = content +&quot; AND a.m6 = '&quot; + mapData.get(&quot;m6&quot;) + &quot;' &quot;;
}
if(mapData.get(&quot;m7&quot;)!=null&amp;&amp;mapData.get(&quot;m7&quot;)!=&quot;&quot;){
content = content +&quot; AND a.m7 = '&quot; + mapData.get(&quot;m7&quot;) + &quot;' &quot;;
}
return content;</li>
</ul>
<p>}</p>
<p>/**</p>
<ul>
<li>分页统计</li>
<li>@param mapData</li>
<li>@return
<em>/
public int getTotalCount(Map&lt;String, Object&gt; mapData) {
String content=content(mapData);
String sql=&quot; SELECT COUNT(</em>) sum  FROM yhpc_contract a WHERE S3=0 &quot; + content;
List<Object> list=findBySql(sql);
return (int) list.get(0);
}</li>
</ul>
<p>/**</p>
<ul>
<li>删除</li>
<li>@param id
*/
public void deleteInfo(Long id) {
String sql=&quot; UPDATE yhpc_contract SET S3=1 WHERE ID=&quot; + id;
updateBySql(sql);
}</li>
</ul>
<p>/**</p>
<ul>
<li>根据id查找危废处理合同信息</li>
<li>@param id</li>
<li>@return
<em>/
public Map&lt;String,Object&gt; findById(Long id) {
String sql = &quot;SELECT a.</em> FROM yhpc_contract a WHERE a.S3=0 AND a.ID=&quot; + id;
List&lt;Map&lt;String,Object&gt;&gt; list=findBySql(sql, null,Map.class);
return list.get(0);
}</li>
</ul>
<p>/**</p>
<ul>
<li>根据id查找危废处理合同信息</li>
<li>@param id</li>
<li>@return
<em>/
public YHPC_ContractEntity find(Long id) {
String sql = &quot;SELECT a.</em> FROM yhpc_contract a WHERE a.S3=0 AND a.ID=&quot; + id;
List&lt;YHPC_ContractEntity&gt; list=findBySql(sql, null,YHPC_ContractEntity.class);
return list.get(0);
}</li>
</ul>
<p>/**</p>
<ul>
<li>导出</li>
<li>@param response</li>
<li>@param mapData
*/
public void exportExcel(HttpServletResponse response, Map&lt;String, Object&gt; mapData) {
String fileName=&quot;危废处理合同信息表.xls&quot;;
List&lt;Map&lt;String, Object&gt;&gt; list=getExport(mapData);
String[] title=mapData.get(&quot;coltext&quot;).toString().split(&quot;,&quot;);
String[] keys=mapData.get(&quot;colval&quot;).toString().split(&quot;,&quot;);
new ExportExcel(fileName, title, keys, list, response);
}</li>
</ul>
<p>/**</p>
<ul>
<li>导出</li>
<li>@param mapData</li>
<li>@return
<em>/
public List&lt;Map&lt;String, Object&gt;&gt; getExport(Map&lt;String, Object&gt; mapData) {
String content=content(mapData);
String sql=&quot;SELECT a.</em> FROM yhpc_contract a WHERE S3=0 &quot; + content + &quot; ORDER BY a.id desc&quot;;
List&lt;Map&lt;String, Object&gt;&gt; list=findBySql(sql, null,Map.class);
return list;
}</li>
</ul>
<p>/**</p>
<ul>
<li>删除</li>
<li>@param parseLong
*/
public void deleteInfoByQyid(long id) {
String sql=&quot; UPDATE yhpc_contract SET S3=1 WHERE qyid=&quot; + id;
updateBySql(sql);
}</li>
</ul>
<p>/**</p>
<ul>
<li>根据企业id查找危废处理合同信息</li>
<li>@param qyid</li>
<li>@return
<em>/
public Map&lt;String, Object&gt; findByQyid(Long qyid) {
String sql = &quot;SELECT a.</em> FROM yhpc_contract a WHERE a.S3=0 AND a.QYID=&quot; + qyid;
List&lt;Map&lt;String,Object&gt;&gt; list=findBySql(sql, null,Map.class);
if(list.size()&gt;0){
return list.get(0);
}
return null;
}</li>
</ul>
<p>}</p>