deptFieldOperation.jsp
5.97 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
<%@ page import="weaver.general.Util,
weaver.docs.docs.FieldParam,
java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@page import="weaver.hrm.definedfield.HrmDeptFieldManager"%>
<%@page import="weaver.conn.RecordSetTrans"%>
<%@page import="weaver.matrix.MatrixUtil"%>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="HrmFieldComInfo" class="weaver.hrm.definedfield.HrmFieldComInfo" scope="page" />
<jsp:useBean id="CptFieldManager" class="weaver.cpt.util.CptFieldManager" scope="page" />
<jsp:useBean id="LabelComInfo" class="weaver.systeminfo.label.LabelComInfo" scope="page" />
<%
String method = Util.null2String(request.getParameter("method"));
int scopeId = Util.getIntValue(request.getParameter("scopeId"),0);
HrmDeptFieldManager hfm = new HrmDeptFieldManager(scopeId);
if(method.equals("add")||method.equals("edit")){
String[] fieldlabel = request.getParameterValues("fieldlabel");
String[] fieldid = request.getParameterValues("fieldid");
String[] fieldname = request.getParameterValues("fieldname");//字段名
String[] fieldhtmltype = request.getParameterValues("fieldhtmltype");
String[] type = request.getParameterValues("type");
String[] flength = request.getParameterValues("flength");
String[] groupid = request.getParameterValues("groupid");//分组id
String[] isuse = request.getParameterValues("isuse");
String[] ismand = request.getParameterValues("ismand");
String[] filedorder = request.getParameterValues("filedorder");
String[] selectitemid = request.getParameterValues("selectitemid");
String[] selectitemvalue = request.getParameterValues("selectitemvalue");
String[] definebroswerType = request.getParameterValues("definebroswerType");
int temId = -1;
int selectIndex = 0;
for(int i=0; i<fieldid.length ; i++){
//需要改名称
String labelname = fieldlabel[i];
int lableid = 0;
boolean newlabel=false;
RecordSetTrans RecordSetTrans=new RecordSetTrans();
RecordSetTrans.setAutoCommit(false);
String mysql=""+
" select distinct t2.indexid from HtmlLabelInfo t2 where "+
" exists (select 1 from HtmlLabelInfo t1 where t1.indexid=t2.indexid and t1.labelname='"+labelname+"' and t1.languageid=7) "+
" and exists (select 1 from HtmlLabelInfo t1 where t1.indexid=t2.indexid and t1.labelname='"+labelname+"' and t1.languageid=8) "+
" and exists (select 1 from HtmlLabelInfo t1 where t1.indexid=t2.indexid and t1.labelname='"+labelname+"' and t1.languageid=9) " ;
RecordSetTrans.executeSql(mysql);
if(newlabel=(!RecordSetTrans.next())){
lableid = CptFieldManager.getNewIndexId(RecordSetTrans);
RecordSetTrans.executeSql("delete from HtmlLabelIndex where id="+lableid);
RecordSetTrans.executeSql("delete from HtmlLabelInfo where indexid="+lableid);
RecordSetTrans.executeSql("INSERT INTO HtmlLabelIndex values("+lableid+",'"+labelname+"')");
RecordSetTrans.executeSql("INSERT INTO HtmlLabelInfo values("+lableid+",'"+labelname+"',7)");//中文
RecordSetTrans.executeSql("INSERT INTO HtmlLabelInfo values("+lableid+",'"+labelname+"',8)");//英文
RecordSetTrans.executeSql("INSERT INTO HtmlLabelInfo values("+lableid+",'"+labelname+"',9)");//繁体
}else{
lableid=RecordSetTrans.getInt("indexid");
}
RecordSetTrans.commit();
if(newlabel)LabelComInfo.addLabeInfoCache(""+lableid);//更新缓存
if(Util.null2String(fieldid[i]).length()==0){
FieldParam fp = new FieldParam();
if(fieldhtmltype[i].equals("1")){
fp.setSimpleText(Util.getIntValue(type[i],-1),flength[i]);
}else if(fieldhtmltype[i].equals("2")){
fp.setText();
}else if(fieldhtmltype[i].equals("3")){
fp.setBrowser(Util.getIntValue(type[i],-1));
}else if(fieldhtmltype[i].equals("4")){
fp.setCheck();
}else if(fieldhtmltype[i].equals("5")){
fp.setSelect();
}else if(fieldhtmltype[i].equals("6")){
fp.setAttach();
}else{
continue;
}
temId = hfm.addField(fieldname[i], fp.getFielddbtype(), fieldhtmltype[i], type[i], ""+lableid, filedorder[i], ismand[i], isuse[i], groupid[i],definebroswerType[i]);
}else{
//只允许更改显示属性，数据库层面的不允许修改
temId = Integer.parseInt(fieldid[i]);
hfm.editField(fieldid[i], ""+lableid, filedorder[i], ismand[i], isuse[i], groupid[i],definebroswerType[i]);
}
if(fieldhtmltype[i].equals("5")){
ArrayList temItemValue = new ArrayList();
ArrayList temItemName = new ArrayList();
for(;selectIndex<selectitemid.length;selectIndex++){
if(selectitemid[selectIndex].equals("--")){
selectIndex++;
break;
}
temItemValue.add(selectitemid[selectIndex]);
temItemName.add(selectitemvalue[selectIndex]);
}
hfm.checkSelectField(temId, temItemValue, temItemName);
}
}
HrmFieldComInfo.removeFieldCache();
//同步部门数据到矩阵
MatrixUtil.sysDepartmentData();
response.sendRedirect("editDeptFieldBatch.jsp");
return;
}else if(method.equals("delete")){
String delfieldids = request.getParameter("delfieldids");
String[] fieldid = delfieldids == null || delfieldids.length() == 0 ? null : delfieldids.split(",") ;
for(int i=0;fieldid!=null&&i<fieldid.length;i++){
hfm.deleteFields(fieldid[i]);
}
out.print("1");
//同步部门数据到矩阵
MatrixUtil.sysDepartmentData();
//response.sendRedirect("editDeptFieldBatch.jsp");
//return;
}
%>