📄 firstsetupcellplace.jsp
字号:
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="java.util.ArrayList" %>
<%@ page import="com.glf.reportIE.commons.XmlUtils" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>初步设置报表中要填充数据的单位格在报表中的位置</title>
<link href="./css/reportIE_form.css" rel="stylesheet" type="text/css" media="all" />
<link href="./css/reportIE_main.css" rel="stylesheet" type="text/css" media="all" />
<script language="JavaScript" type="text/javascript" src="js/listview.js"></script>
<script language="JavaScript" type="text/javascript" src="js/validateUtil.js"></script>
<script language="JavaScript" type="text/javascript">
function addFirstSetup(){
if(checkInputValueIsNull('placeAdd','【位置】')
&& checkInputValueIsExcelCell('placeAdd','您输入的【位置】格式错误，只能由26个大写英文字母和数字组成！')
&& checkInputValueIsNull('descriptionAdd','【描述】')
&& checkInputValueIsNull('fieldAdd','【对应的字段名】')){
document.getElementById("base").action="firstSetupToXmlAdd";
document.getElementById("base").submit();
}
}
function editFirstSetup(id,id2){
if(checkInputValueIsNull('placeEdit'+id2,'【位置】')
&& checkInputValueIsExcelCell('placeEdit'+id2,'您输入的【位置】格式错误，只能由26个大写英文字母和数字组成！')
&& checkInputValueIsNull('descriptionEdit'+id2,'【描述】')
&& checkInputValueIsNull('fieldEdit'+id2,'【对应的字段名】')){
var tempStr = document.getElementById(id).value;
document.getElementById("base").action="firstSetupToXmlEdit?only="+tempStr+"&id="+id2;
document.getElementById("base").submit();
}
}
function deleteFirstSetup(id,id2){
var temp1 = document.getElementById('placeEdit'+id2).value;
var temp2 = document.getElementById('descriptionEdit'+id2).value;
var temp3 = document.getElementById('fieldEdit'+id2).value;
if(confirm('您确定要删除【位置】【'+temp1+'】【描述】【'+temp2+'】【对应的字段名】【'+temp3+'】这条记录吗？')){
var tempStr = document.getElementById(id).value;
document.getElementById("base").action="firstSetupToXmlDelete?only="+tempStr+"&id="+id2;
document.getElementById("base").submit();
}
}
</script>
</head>
<body>
<% String formName = request.getParameter("formName");%>
<h1>【后台参数设置】-【初步设置字段位置】设置位置</h1>
<form action="" method="post" name="base" id="base">
<div id="bigform">
<table width="89%" border="0" cellpadding="0" cellspacing="0">
<input type="hidden" name="hiddenFormName" id="hiddenFormName" value="<%=formName %>" />
<tbody id="dynamicArea">
<%
String xmlPath = request.getRealPath("")+"/pages/reportIE/xml/"+formName+".xml";
boolean flag = XmlUtils.fileIsExits(xmlPath);
int j = 0;
if(flag){
ArrayList cellList = XmlUtils.getAllCellValue(xmlPath);
for(int i=0;i<cellList.size();i++){
j++;
%>
<tr onmouseover="setPointer(this, '1', 'over', '#f5f5f5', '#ddecff', '');" onmouseout="setPointer(this, '1', 'out', '#f5f5f5', '#ddecff', '');" onmousedown="setPointer(this, '1', 'click', '#f5f5f5', '#ddecff', '');">
<td class="fm-label" bgcolor="" style="width:25%">
位置
<input name="placeEdit<%=j%>" id="placeEdit<%=j%>" type="text" value="<%=cellList.get(i) %>" />
<input name="only<%=j%>" id="only<%=j%>" type="hidden" value="<%=cellList.get(i) %>" />
</td>
<td class="fm-label" style="width:25%">
描述
<input name="descriptionEdit<%=j%>" id="descriptionEdit<%=j%>" type="text" value="<%=cellList.get(i+1) %>" />
<input name="descriptionEditBase<%=j%>" id="descriptionEditBase<%=j%>" type="hidden" value="<%=cellList.get(i+1) %>" />
</td>
<td class="fm-label" style="width:30%">
对应的字段名
<input name="fieldEdit<%=j%>" id="fieldEdit<%=j%>" type="text" value="<%=cellList.get(i+2) %>" />
<input name="fieldEditBase<%=j%>" id="fieldEditBase<%=j%>" type="hidden" value="<%=cellList.get(i+2) %>" />
</td>
<td class="fm-label" style="text-align:center" style="width:20%">
<a href="#" onclick="editFirstSetup('only<%=j%>','<%=j%>')"><img src="images/icn_bt_edit.gif" title="修改" /></a>
<a href="#" onclick="deleteFirstSetup('only<%=j%>','<%=j%>')"><img src="images/icn_bt_delete.gif" title="删除" /></a>
</td>
</tr>
<%
i+=2;
}
}
%>
<tr>
<td colspan="4">
<hr />
【初步设置位置】
<font color="green">设置excel表单元格需要填充数据的位置。</font>
<hr />
</td>
</tr>
<tr style="height:5px"><td> </td></tr>
<tr id="newTR" style="display: none">
<td class="fm-label">
位置
<input name="placeAdd" id="placeAdd" type="text" value="" />
</td>
<td class="fm-label">
描述
<input name="descriptionAdd" id="descriptionAdd" type="text" value="" />
</td>
<td class="fm-label">
对应的字段名
<input name="fieldAdd" id="fieldAdd" type="text" value="" />
</td>
<td class="fm-label" style="text-align:center">
<a href="#" onclick="addFirstSetup()"><img src="images/icn_bt_new.gif" title="新增" /></a>
</td>
</tr>
</tbody>
</table>
</div>
<div id="bigformbt">
<input name="button" class="fm-reset" value="上一步" type="button" onclick="location.href='chooseFirstSetup.jsp'" />
<input name="addResult" class="fm-submit" value="添加输入栏" type="button" onclick="document.getElementById('errormessage').style.display='none';document.getElementById('newTR').style.display=''" />
</div>
<br />
<%
String errorMessage = (String)request.getAttribute("errorMessage");
if(errorMessage != null && errorMessage.length() > 0)
{
%>
<div id="errormessage">
<h4>请注意</h4>
<div id="warning">
<form>
<fieldset>
<div>
<table border="0" width="100%">
<tr>
<td width="25"><img src="./images/icn_warning_m.gif" align="top" /></td>
<td>
<label >
<span class="tips" id="error" style="color:red" >
<%=errorMessage%>
</span>
</label>
</td>
</tr>
</table>
</div>
</fieldset>
<div id="warningbt"></div>
</form>
</div>
</div>
<%}else{%>
<div id="errormessage"></div>
<%} %>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -