excelAjaxData.jsp
5.38 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
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.hrm.User"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="org.json.JSONObject" %>
<%@ page import="net.sf.json.JSONArray"%>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="ExcelLayoutManager" class="weaver.formmode.exceldesign.ExcelLayoutManager" scope="page" />
<jsp:useBean id="HtmlLayoutOperate" class="weaver.formmode.exceldesign.HtmlLayoutOperate" scope="page" />
<jsp:useBean id="FormatFieldValue" class="weaver.formmode.exceldesign.FormatFieldValue" scope="page" />
<jsp:useBean id="FinancialElement" class="weaver.workflow.field.FinancialElement" scope="page" />
<jsp:useBean id="DetailRowMergeManager" class="weaver.formmode.exceldesign.DetailRowMergeManager" scope="page" />
<%
User user = HrmUserVarify.getUser(request, response);
%>
<%@ include file="/formmode/checkright4setting.jsp" %>
<%
String src=Util.null2String(request.getParameter("src"));
if("getMainFields".equals(src)){
String isecme = Util.null2String(request.getParameter("isecme"));
JSONObject json = new org.json.JSONObject();
if("1".equals(isecme)){
json = new com.api.ecme.excel.ExcelLayoutManager(request,user).getMainFields();
}else{
ExcelLayoutManager.setRequest(request);
json =ExcelLayoutManager.getMainFields();
}
out.print(json);
}else if("getDetailFields".equals(src)){
String isecme = Util.null2String(request.getParameter("isecme"));
JSONObject json = new org.json.JSONObject();
if("1".equals(isecme)){
json = new com.api.ecme.excel.ExcelLayoutManager(request,user).getDetailFields();
}else{
ExcelLayoutManager.setRequest(request);
json = ExcelLayoutManager.getDetailFields();
}
out.print(json);
}else if("getDetailFieldsCanSort".equals(src)){
ExcelLayoutManager.setRequest(request);
JSONObject json = new org.json.JSONObject();
json = ExcelLayoutManager.getDetailFieldsCanSort();
out.print(json);
}
else if("formatToDate".equals(src)){
String formatVal=FormatFieldValue.FormatToDate(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("formatPattern"),-1));
out.print(formatVal);
}else if("formatToTime".equals(src)){
String formatVal=FormatFieldValue.FormatToTime(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("formatPattern"),-1));
out.print(formatVal);
}else if("formatToPercent".equals(src)){
String formatVal=FormatFieldValue.FormatToPercent(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("decimals"),-1));
out.print(formatVal);
}else if("formatToScience".equals(src)){
String formatVal=FormatFieldValue.FormatToScience(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("decimals"),-1));
out.print(formatVal);
}else if("formatToSpecial".equals(src)){
String formatVal=FormatFieldValue.FormatToSpecial(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("formatPattern"),-1));
out.print(formatVal);
}else if("formatToMoneyUpper".equals(src)){
String formatVal=FormatFieldValue.FormatToMoneyUpper(Util.null2String(request.getParameter("realVal")));
out.print(formatVal);
}else if("transFinancialVal".equals(src)){
String fieldval=request.getParameter("fieldval");
char[] valArr=FinancialElement.getValCharArr(fieldval);
out.print(new String(valArr));
}else if("getHistoryLayout".equals(src)){
String modeid = Util.null2String(request.getParameter("modeid"));
int layouttype = Util.getIntValue(request.getParameter("layouttype"));
int languageid = Util.getIntValue(request.getParameter("languageid"));
List historylist = HtmlLayoutOperate.getHistoryLayout(modeid, layouttype, languageid);
JSONArray result = new net.sf.json.JSONArray();
out.print(result.fromObject(historylist));
}else if("deleteLayout".equals(src)){
int layoutid = Util.getIntValue(request.getParameter("layoutid"));
String isecme = Util.null2String(request.getParameter("isecme"));
String result = "";
if(isecme.equals("1")){
result = new com.api.ecme.excel.HtmlLayoutOperate(request,user).deleteLayout(layoutid);
}else{
result = HtmlLayoutOperate.deleteLayout(layoutid);
}
out.print(result);
}else if("setLayoutToActive".equals(src)){
int modeid = Util.getIntValue(request.getParameter("modeid"));
int layouttype = Util.getIntValue(request.getParameter("layouttype"));
int layoutid = Util.getIntValue(request.getParameter("layoutid"));
String isecme = Util.null2String(request.getParameter("isecme"));
int categoryid = Util.getIntValue(request.getParameter("categoryid"));
int feaid = Util.getIntValue(request.getParameter("feaid"));
String result = "";
if("1".equals(isecme)){
result = new com.api.ecme.excel.HtmlLayoutOperate(request,user).setLayoutToActive(modeid,layouttype, layoutid,categoryid, feaid);
}else{
result = HtmlLayoutOperate.setLayoutToActive(modeid,layouttype, layoutid);
}
out.print(result);
}else if("saveChooseLayout".equals(src)){
HtmlLayoutOperate.setRequest(request);
String result = HtmlLayoutOperate.saveLayout_choose();
out.print(result);
}else if("saveDetailMergeInfo".equals(src)){
int layoutid = Util.getIntValue(request.getParameter("layoutid"));
int groupid = Util.getIntValue(request.getParameter("groupid"));
String mergeFields = Util.null2String(request.getParameter("mergeFields"));
out.print(DetailRowMergeManager.saveMergeInfo(layoutid, groupid, mergeFields));
}
%>