?? setupcellplace.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>初步設(shè)置報表中要填充數(shù)據(jù)的單位格在報表中的位置</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 addSetup(){
if(checkInputValueIsNull('placeAdd','【位置】')
&& checkInputValueIsExcelCell('placeAdd','您輸入的【位置】格式錯誤，只能由26個大寫英文字母和數(shù)字組成！')
&& checkInputValueIsNull('descriptionAdd','【描述】')
&& checkInputValueIsNull('fieldAdd','【對應(yīng)的字段名】')){
document.getElementById("base").action="setupToXmlAdd";
document.getElementById("base").submit();
}
}
function editSetup(id,id2){
if(checkInputValueIsNull('placeEdit'+id2,'【位置】')
&& checkInputValueIsExcelCell('placeEdit'+id2,'您輸入的【位置】格式錯誤，只能由26個大寫英文字母和數(shù)字組成！')
&& checkInputValueIsNull('descriptionEdit'+id2,'【描述】')
&& checkInputValueIsNull('fieldEdit'+id2,'【對應(yīng)的字段名】')){
var tempStr = document.getElementById(id).value;
document.getElementById("base").action="setupToXmlEdit?only="+tempStr+"&id="+id2;
document.getElementById("base").submit();
}
}
function deleteSetup(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+'】【對應(yīng)的字段名】【'+temp3+'】這條記錄嗎？')){
var tempStr = document.getElementById(id).value;
document.getElementById("base").action="setupToXmlDelete?only="+tempStr+"&id="+id2;
document.getElementById("base").submit();
}
}
</script>
</head>
<body>
<% String formName = request.getParameter("formName"); %>
<h1>【導(dǎo)入模板】-【設(shè)置字段位置】設(shè)置位置</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%">
對應(yīng)的字段名
<input name="fieldEdit<%=j%>" id="fieldEdit<%=j%>" readonly="readonly" style="background-color: #D0D0D0" 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="editSetup('only<%=j%>','<%=j%>')"><img src="images/icn_bt_edit.gif" title="修改" /></a>
<a href="#" onclick="deleteSetup('only<%=j%>','<%=j%>')"><img src="images/icn_bt_delete.gif" title="刪除" /></a>
</td>
</tr>
<%
i+=2;
}
}
%>
<tr>
<td colspan="4">
<hr />
【設(shè)置位置】
<font color="green">設(shè)置excel表單元格需要填充數(shù)據(jù)的位置。</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">
對應(yīng)的字段名
<input name="fieldAdd" id="fieldAdd" type="text" value="" />
</td>
<td class="fm-label" style="text-align:center">
<a href="#" onclick="addSetup()"><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='chooseFormSetup.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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -