FnaBudgetfeeTypeViewAjax.jsp
2.64 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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@page import="weaver.fna.general.FnaCommon"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@ page import="weaver.general.*"%>
<%@ page import="java.util.*" %>
<%@ page import="java.net.*" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
String checkid = Util.null2String(request.getParameter("checkid"));
String str = "";
//验证
if(!checkid.equals("")){
ArrayList list = Util.TokenizerString(checkid, ",");
if(list!=null && list.size()>0){
List<String> allSupSubjectIds_list = new ArrayList<String>();
List<String> list_cond_list = FnaCommon.initData1(list);
int list_cond_list_len = list_cond_list.size();
for(int i=0;i<list_cond_list_len;i++){
String list_cond = list_cond_list.get(i);
String sql = "select a.id, a.allSupSubjectIds from FnaBudgetfeeType a where a.id in ("+list_cond+")";
rs.executeQuery(sql);
while(rs.next()){
String allSupSubjectIds = Util.null2String(rs.getString("allSupSubjectIds")).trim();
//new BaseBean().writeLog("allSupSubjectIds="+allSupSubjectIds);
allSupSubjectIds_list.add(allSupSubjectIds);
}
}
int allSupSubjectIds_list_len = allSupSubjectIds_list.size();
List<String> allSubjectIds_list = new ArrayList<String>();
for(int i=0;i<allSupSubjectIds_list_len;i++){
String allSupSubjectIds = allSupSubjectIds_list.get(i);
String sql = "select a.id from FnaBudgetfeeType a where a.allSupSubjectIds like '"+StringEscapeUtils.escapeSql(allSupSubjectIds)+"%'";
rs.executeQuery(sql);
while(rs.next()){
String subjectId = Util.null2String(rs.getString("id")).trim();
if(!allSubjectIds_list.contains(subjectId)){
//new BaseBean().writeLog("subjectId="+subjectId);
allSubjectIds_list.add(subjectId);
}
}
}
List<String> allSubjectIds_list_cond_list = FnaCommon.initData1(allSubjectIds_list);
int allSubjectIds_list_cond_list_len = allSubjectIds_list_cond_list.size();
for(int i=0;i<allSubjectIds_list_cond_list_len;i++){
String allSubjectIds_list_cond = allSubjectIds_list_cond_list.get(i);
//new BaseBean().writeLog("allSubjectIds_list_cond="+allSubjectIds_list_cond);
String sql = "SELECT count(*) cnt \n" +
" from FnaBudgetInfo a \n" +
" join FnaBudgetInfoDetail b on a.id = b.budgetinfoid \n" +
" where b.budgetaccount <> 0\n" +
" and a.status = 1 \n" +
" and b.budgettypeid in ("+allSubjectIds_list_cond+")";
//new BaseBean().writeLog("sql="+sql);
rs.executeQuery(sql);
if(rs.next() && rs.getInt("cnt") > 0){
str = "1";
break;
}
}
}
}
out.print(str);
%>