📄 addreportdatalayer.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="com.gs.util.*"%>
<%@ page import="com.gs.control.event.*"%>
<%@page import="java.sql.*"%>
<%
try{
//*****初始化变量
String page_code="";
page_code=request.getParameter("page_code");
String tempQuery = null;
int lineNum=0;
ResultSet rs = null;//结果集合
//*****连接数据库
Connection con = Common.getConnection();
Statement s = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
tempQuery="select * from universal_pageelement_define where page_code='"+page_code+"' and ( unit_code>='80000000' and unit_code<'90000000') order by unit_code";
Debug.println(tempQuery);
rs=s.executeQuery(tempQuery);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="style/webstyle.css" type=text/css rel=stylesheet>
<base target="bottom">
</head>
<body topmargin="0" leftmargin="0">
<DIV id=overDiv style="POSITION: absolute; Z-INDEX: 1"></DIV>
<SCRIPT src="js/overlib.js"></SCRIPT>
<form method="POST" action="<%=request.getContextPath()%>/pageBuilderAction.do" name=form1 target="_blank">
<input type="hidden" name=page_code value="<%=page_code%>">
<input type="hidden" name=mode value="2">
<input type="hidden" name=action value="<%=PageBuilderEvent.pageDefine_saveData%>">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber15">
<tr>
<td width="100%">行列交叉点逻辑: </td>
</tr>
</table>
<table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#86C2FF" width="1000" id="AutoNumber14" name="table1" height="47" cellpadding="0" >
<tr>
<td bgcolor="#CEE7FF" width="6" height="21" align="center"></td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center">编号</td>
<td width="126" height="21" bgcolor="#CEE7FF" align="center">类型</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center">内容</td>
<td width="124" height="21" bgcolor="#CEE7FF" align="center">属性</td>
<td width="54" height="21" bgcolor="#CEE7FF" align="center">对齐</td>
<td width="76" height="21" bgcolor="#CEE7FF" align="center">宽度</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center">高度</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center">字体</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center">文字大小</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center">文字样式</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center">文字颜色</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center" >左边距</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center" >上边距</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center" >输出值说明</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center" >元素输出格式</td>
<td width="111" height="21" bgcolor="#CEE7FF" align="center" >元素输出样式</td>
</tr>
<%while(rs.next()){%>
<tr>
<td width="6" height="1" ><input type='hidden' name='T00' size='15' value="">
</td>
<td width="111" height="1" ><input type='text' name='T02' size='7' onmouseover="drs('编号'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(3))%>">
</td>
<td width="126" height="1" ><select size="1" name='T03' onmouseover="drs('类型'); return true;" onmouseout="nd(); return true;"><option value="1" <%if((PubFunc.toShowForm(rs.getString(4))).equals("1"))out.print("selected");%>>
基本标签</option><option value="2" <%if((PubFunc.toShowForm(rs.getString(4))).equals("2"))out.print("selected");%>>
业务逻辑<option value="3" <%if((PubFunc.toShowForm(rs.getString(4))).equals("3"))out.print("selected");%>>
表示编码值</option><option value="4" <%if((PubFunc.toShowForm(rs.getString(4))).equals("4"))out.print("selected");%>>
页面参数值</option></select>
</td>
<td width="111" height="1" ><input type='text' name='T04' size='18' onmouseover="drs('内容'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(PubFunc.decodeGB(rs.getString(5)))%>">
</td>
<td width="124" height="1" ><select size="1" name="T05" onmouseover="drs('属性'); return true;" onmouseout="nd(); return true;"><option value="1" <%if((PubFunc.toShowForm(rs.getString(6))).equals("1"))out.println("selected");%>>
标签</option><option value="2" <%if((PubFunc.toShowForm(rs.getString(6))).equals("2"))out.println("selected");%>>
文本框</option><option value="4" <%if((PubFunc.toShowForm(rs.getString(6))).equals("4"))out.println("selected");%>>
按钮 </option><option value="3" <%if((PubFunc.toShowForm(rs.getString(6))).equals("3"))out.println("selected");%>>
下拉框</option><option value="5" <%if((PubFunc.toShowForm(rs.getString(6))).equals("5"))out.println("selected");%>>
单选扭</option><option value="6" <%if((PubFunc.toShowForm(rs.getString(6))).equals("6"))out.println("selected");%>>
复选框</option></select>
</td>
<td width="54" height="1" ><select size="1" name="T06" onmouseover="drs('对齐'); return true;" onmouseout="nd(); return true;" ><option value="center" <%if((PubFunc.toShowForm(rs.getString(16))).equals("center"))out.println("selected");%>>居中</option><option value="left" <%if((PubFunc.toShowForm(rs.getString(16))).equals("left"))out.println("selected");%>>居左</option><option value="right" <%if((PubFunc.toShowForm(rs.getString(16))).equals("right"))out.println("selected");%>>居右</option></select>
</td>
<td width="76" height="1" ><input type='text' name='T07' size='4' onmouseover="drs('宽度'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(7))%>">
</td>
<td width="111" height="1" ><input type='text' name='T08' size='4' onmouseover="drs('高度'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(8))%>">
</td>
<td width="111" height="1" ><input type='text' name='T09' size='4' onmouseover="drs('字体'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(PubFunc.decodeGB(rs.getString(9)))%>">
</td>
<td width="111" height="1" ><input type='text' name='T10' size='4' onmouseover="drs('字体大小'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(10))%>">
</td>
<td width="111" height="1" ><input type='text' name='T11' size='4' onmouseover="drs('文字样式'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(11))%>">
</td>
<td width="111" height="1" ><input type='text' name='T12' size='4' onmouseover="drs('文字颜色'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(12))%>">
</td>
<td width="111" height="1" ><input type='text' name='T13' size='4' onmouseover="drs('左边距'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(25))%>">
</td>
<td width="111" height="1" ><input type='text' name='T14' size='4' onmouseover="drs('上边距'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(26))%>">
</td>
<td width="111" height="1" ><input type='text' name='T15' size='14' onmouseover="drs('元素输出值'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(17))%>">
</td>
<td width="111" height="1" >
<select size="1" name='T16' onmouseover="drs('元素输出格式'); return true;" onmouseout="nd(); return true;">
<option value="1" <%if((PubFunc.toShowForm(rs.getString(27))).equals("1"))out.println("selected");%>>普通字符输出</option>
<option value="2" <%if((PubFunc.toShowForm(rs.getString(27))).equals("2"))out.println("selected");%>>大写字符输出</option>
<option value="6" <%if((PubFunc.toShowForm(rs.getString(27))).equals("6"))out.println("selected");%>>大写数字输出</option>
<option value="3" <%if((PubFunc.toShowForm(rs.getString(27))).equals("3"))out.println("selected");%>>钱币数字输出</option>
<option value="4" <%if((PubFunc.toShowForm(rs.getString(27))).equals("4"))out.println("selected");%>>数字日期显示</option>
<option value="5" <%if((PubFunc.toShowForm(rs.getString(27))).equals("5"))out.println("selected");%>>大写日期显示</option>
<option value="7" <%if((PubFunc.toShowForm(rs.getString(27))).equals("7"))out.println("selected");%>>日期转换</option>
</select>
</td>
<td width="111" height="1" ><input type='text' name='T17' size='5' onmouseover="drs('元素输出样式'); return true;" onmouseout="nd(); return true;" value="<%=PubFunc.toShowForm(rs.getString(28))%>">
</td>
</tr>
<%
lineNum++;
}
%>
</table>
<script>
var num=<%=lineNum%>
function check(){
var page_code,code1,type1,input_value,style1,width1,height1,font_type,font_size,font_style,color1,positionLeft,positiontop,output_value,data_type,data_format
if(num>0)
if(document.form1.T00.length>1){
for(var i = 0;num>1&&i<document.form1.T00.length;i++){
page_code=document.form1.page_code.value;
code1=document.form1.T02[i].value;
type1=document.form1.T03[i].value;
input_value=charReplace(document.form1.T04[i].value);
style1=document.form1.T05[i].value;
position=document.form1.T06[i].value;
width1=document.form1.T07[i].value;
height1=document.form1.T08[i].value;
font_type=document.form1.T09[i].value;
font_size=document.form1.T10[i].value;
font_style=document.form1.T11[i].value;
color1=document.form1.T12[i].value;
positionLeft=document.form1.T13[i].value;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -