cacheData

 1 <%@ page language="java" import="java.util.*,com.fiberhome.bcs.appprocess.common.util.*"
 2  contentType="application/uixml+xml; charset=UTF-8" pageEncoding="UTF-8"%>
 3 <%@ include file="/client/adapt.jsp"%>
 4 <%@ include file="../Public/utility.jsp"%>
 5 <%
 6 StringBuilder sb=new StringBuilder();
 7 sb.append("{"users":[");
 8 String dbid=request.getSession().getAttribute("dbid").toString();
 9 //缓存用户信息
10 String sql="select dbo.FXT_GetPinYin(a.fullname) as username_py,a.username as userid,a.fullname as username,rtrim(ltrim(a.email)) as email,a.telephone,a.mobilephone,b.duty,b.org,c.xb,c.guid,c.zp,a.orderid "+ 
11             "from sys_user a left join sys_orgmenber b on a.username = b.member "+ 
12             "left join xt_ygda c on a.username = c.XM "+
13             "where b.ispriduty = 1 and a.ison=1 order by a.username";
14 List<TableRow> rows = aa.query(dbid,sql,null);
15 String email="";
16 for (TableRow row : rows){
17     email=row.getField("email","");
18     email=Utility.checkEmail(email)?email:"";
19     sb.append("{")
20        .append(""guid":""+row.getField("guid","")+"",")
21        .append(""userid":""+row.getField("userid","")+"",")
22        .append(""username":""+row.getField("username","")+"",")
23        .append(""username_py":""+row.getField("username_py","")+"",")
24        .append(""org":""+row.getField("org","")+"",")
25        .append(""email":""+email+"",")
26        .append(""telephone":""+row.getField("telephone","")+"",")
27        .append(""mobilephone":""+row.getField("mobilephone","").replaceAll("
", "").replaceAll("
", "").replaceAll("	", "")+"",")
28        .append(""duty":""+row.getField("duty","")+"",")
29        .append(""xb":""+row.getField("xb","")+"",")
30        .append(""zp":""+row.getField("zp","")+"",")
31        .append(""xh":""+row.getField("orderid","")+"",")
32        .append("},");
33 }
34 sb.append("],");
35 //缓存部门信息
36 sb.append(""orgs":[");
37 sql="select orgname,suporg,orgtype,cast(orderid AS VARCHAR) as xh,guid,"+
38       "usercount=(select count(1) from sys_user a left join sys_orgmenber b on a.username=b.member "+
39       "where b.ispriduty = 1 and a.ison=1 and b.org=VXT_SysOrg.orgname) from VXT_SysOrg order by VXT_SysOrg.orgname";
40 rows = aa.query(dbid,sql,null);
41 for (TableRow row : rows){
42     sb.append("{")
43        .append(""orgname":""+row.getField("orgname","").replace("
"," ").replace("
"," ")+"",")
44        .append(""suporg":""+row.getField("suporg","").replace("
"," ").replace("
"," ")+"",")
45        .append(""orgtype":""+row.getField("orgtype","").replace("
"," ").replace("
"," ")+"",")
46        .append(""xh":""+row.getField("xh","")+"",")
47        .append(""usercount":""+row.getField("usercount","")+"",")
48        .append(""guid":""+row.getField("guid","")+"",")
49        .append("},");
50 }
51 sb.append("]}");
52 //System.out.println("cachedata4:"+sb.toString());
53 %>
54 <%=sb.toString()%>