HrmOrgGroupOperation.jsp
6.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
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
149
150
151
152
153
154
155
156
157
158
159
160
<%@ page import="weaver.conn.RecordSet"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="HrmOrgGroupComInfo" class="weaver.hrm.orggroup.HrmOrgGroupComInfo" scope="page" />
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%!
private String onDelete( RecordSet RecordSet,HttpServletRequest request,User user)
{
String returnString = "";
int orgGroupId=Util.getIntValue(request.getParameter("orgGroupId"),0);
try {
//是否关联机构、部门
String isRelatedString="";
RecordSet.executeSql("select 1 from HrmOrgGroupRelated where orgGroupId=" + orgGroupId);
if(RecordSet.next()){
isRelatedString+="<br>"+SystemEnv.getHtmlLabelName(24682,user.getLanguage());
}
//是否被文档子目录的默认共享(与文档创建人无关)调用
String docSecCategoryString="";
int secCategoryIdIndex=0;
int mainCategoryId=0;
String mainCategoryName="";
int subCategoryId=0;
String subCategoryName="";
int secCategoryId=0;
String secCategoryName="";
StringBuffer sb=new StringBuffer();
sb.append(" select a.id as secCategoryId,a.categoryName as secCategoryName,b.id as subCategoryId,b.categoryName as subCategoryName,c.id as mainCategoryId,c.categoryName as mainCategoryName ")
.append(" from DocSecCategory a,DocSubCategory b,DocMainCategory c ")
.append(" where a.subCategoryId = b.id ")
.append(" and b.mainCategoryId = c.id ")
.append(" and exists(select 1 from DocSecCategoryShare where shareType=6 and orgGroupId="+orgGroupId+" and a.id=DocSecCategoryShare.secCategoryId) ")
.append(" order by c.categoryOrder asc,b.subOrder asc,a.secOrder asc ")
;
RecordSet.executeSql(sb.toString());
int secCategoryIdNum=RecordSet.getCounts();
while(RecordSet.next()&&secCategoryIdIndex<10){
secCategoryIdIndex++;
mainCategoryName=Util.null2String(RecordSet.getString("mainCategoryName"));
subCategoryName=Util.null2String(RecordSet.getString("subCategoryName"));
secCategoryName=Util.null2String(RecordSet.getString("secCategoryName"));
docSecCategoryString+="<br>"+"/"+mainCategoryName+"/"+subCategoryName+"/"+secCategoryName;
}
if(secCategoryIdNum>10){
docSecCategoryString+="<br>……"+SystemEnv.getHtmlLabelName(358,user.getLanguage())+secCategoryIdNum+SystemEnv.getHtmlLabelName(24683,user.getLanguage());
}
//判断该群组是否被文档共享调用
String docString="";
int docIdIndex=0;
int docId=0;
String docSubject=null;
RecordSet.executeSql("select id,docSubject from DocDetail where exists(select 1 from DocShare where shareType=6 and orgGroupId="+orgGroupId+" and docId=DocDetail.id) order by id desc ");
int docIdNum=RecordSet.getCounts();
while(RecordSet.next()&&docIdIndex<10){
docIdIndex++;
docId = Util.getIntValue(RecordSet.getString("id"),0);
docSubject = Util.null2String(RecordSet.getString("docSubject"));
docString+="<br>"+docSubject+"（"+docId+"）";
}
if(docIdNum>10){
docString+="<br>……"+SystemEnv.getHtmlLabelName(358,user.getLanguage())+docIdNum+SystemEnv.getHtmlLabelName(24683,user.getLanguage());
}
if(!isRelatedString.equals("")){
returnString+="<br><br>"+isRelatedString;
}
if(!docSecCategoryString.equals("")){
returnString+="<br><br>"+SystemEnv.getHtmlLabelName(24684,user.getLanguage())+"："+docSecCategoryString+"<br>"+SystemEnv.getHtmlLabelName(24685,user.getLanguage());
}
if(!docString.equals("")){
returnString+="<br><br>"+SystemEnv.getHtmlLabelName(24686,user.getLanguage())+"："+docString+"<br>"+SystemEnv.getHtmlLabelName(24685,user.getLanguage());
}
if(!returnString.equals("")&&returnString.length()>8){
returnString=returnString.substring(8);
}
} catch (Exception e) {
}
return returnString;
}
%>
<%
if(!HrmUserVarify.checkUserRight("GroupsSet:Maintenance", user)){
response.sendRedirect("/notice/noright.jsp");
return;
}
String operation = Util.null2String(request.getParameter("operation"));
if(operation.equals("AddSave")){
int id = 0;
String orgGroupName=Util.null2String(request.getParameter("orgGroupName"));
orgGroupName=Util.toHtml100(orgGroupName);
String orgGroupDesc=Util.null2String(request.getParameter("orgGroupDesc"));
orgGroupDesc=Util.toHtml100(orgGroupDesc);
double showOrder=Util.getDoubleValue(request.getParameter("showOrder"),0);
RecordSet.executeSql(" insert into HrmOrgGroup(orgGroupName,orgGroupDesc,showOrder,isDelete) values('"+orgGroupName+"','"+orgGroupDesc+"',"+showOrder+",'0') ");
RecordSet.executeSql("select max(id) from HrmOrgGroup where orgGroupName='"+orgGroupName+"' and showOrder="+showOrder);
if(RecordSet.next()){
id=Util.getIntValue(RecordSet.getString(1),0);
}
HrmOrgGroupComInfo.removeHrmOrgGroupCache();
/*
if(id<=0){
out.write("<script>try{opener._table.reLoad();window.close();}catch(e){}</script>");
}else{
response.sendRedirect("HrmOrgGroupEdit.jsp?isclose=1&id="+id);
}*/
response.sendRedirect("HrmOrgGroupEdit.jsp?isclose=1&id="+id);
}else if(operation.equals("EditSave")){
int id = Util.getIntValue(request.getParameter("id"),0);
String orgGroupName=Util.null2String(request.getParameter("orgGroupName"));
orgGroupName=Util.toHtml100(orgGroupName);
String orgGroupDesc=Util.null2String(request.getParameter("orgGroupDesc"));
orgGroupDesc=Util.toHtml100(orgGroupDesc);
double showOrder=Util.getDoubleValue(request.getParameter("showOrder"),0);
RecordSet.executeSql("update HrmOrgGroup set orgGroupName='"+orgGroupName+"',orgGroupDesc='"+orgGroupDesc+"',showOrder="+showOrder+" where id = "+id);
HrmOrgGroupComInfo.removeHrmOrgGroupCache();
response.sendRedirect("HrmOrgGroupEdit.jsp?isclose=1&id="+id);
//out.write("<script>try{opener._table.reLoad();window.close();}catch(e){}</script>");
}else if(operation.equals("delete")){
int id = Util.getIntValue(request.getParameter("id"),0);
String returnString = onDelete(RecordSet, request, user);
if(returnString.equals("")){
RecordSet.executeSql("update HrmOrgGroup set isDelete='1' where id = "+id);
HrmOrgGroupComInfo.removeHrmOrgGroupCache();
response.sendRedirect("HrmOrgGroupList.jsp?isclose=1&id="+id);
}else{
out.write("<script>try{window.top.Dialog.alert("+returnString+")}catch(e){}</script>");
response.sendRedirect("HrmOrgGroupList.jsp?isclose=1&id="+id);
}
//out.write("<script>try{opener._table.reLoad();window.close();}catch(e){}</script>");
}
%>
<!-- <input type="button" name="Submit2" value="<%=SystemEnv.getHtmlLabelName(236,user.getLanguage())%>" onClick="javascript:history.go(-1)"> -->