📄 复件 addreportdataline.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page
import="java.util.*,
com.gs.util.*,
java.sql.*,
com.gs.control.event.*"
%>
<%
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);
Statement s = con.createStatement();
tempQuery="select * from universal_pageelement_define where page_code='"+page_code+"' and unit_code<'70000000' order by unit_code";
//System.out.println("tempQuery="+tempQuery);
//PreparedStatement s = con.prepareStatement(tempQuery);
//rs=s.executeQuery();
rs=s.executeQuery(PubFunc.encodeGB(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="1">
<input type="hidden" name=action value="<%=PageBuilderEvent.pageDefine_saveData%>">
<table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#86C2FF" width="1000" id="AutoNumber14" name="table1" height="31" cellpadding="0" >
<%
int ii = 0;
while(rs.next()){
String s_code = PubFunc.toShowForm(rs.getString(3));
String s_type = PubFunc.toShowForm(rs.getString(4));
String s_content = PubFunc.toShowForm(rs.getString(5));
String s_property = PubFunc.toShowForm(rs.getString(6));
String a_align = PubFunc.toShowForm(rs.getString(16));
// String s_rows = PubFunc.toShowForm(rs.getString("unit_rowcolendpoint"));
String s_rows = "";
//String s_ = PubFunc.toShowForm(rs.getString(14));
String s_colspan = "";
%>
<tr>
<td width="6" height="12" >
</td>
<td width="6" height="12" ><input type='hidden' name='T00' size='15' value="">
</td>
<td width="111" height="12" ><!--编号--><input type='text' name='T02' size='8' value="<%=s_code%>">
</td>
<td width="126" height="12" ><!--类型--><select size="1" name='T03' style="width:60"><option value="1" <%if(s_type.equals("1"))out.println("selected");%>>基本标签</option><option value="2" <%if(s_type.equals("2"))out.println("selected");%>>业务逻辑</option><option value="3" <%if(s_type.equals("3"))out.println("selected");%>>表示编码</option><option value="4" <%if(s_type.equals("4"))out.println("selected");%>>页面参数</option></select>
</td>
<td width="111" height="12" ><!--内容--><input type='text' name='T04' size='21' value="<%=s_content%>" title="<%=s_content%>">
</td>
<td width="124" height="12"><!--属性--><select size="1" name="T05" style="width:60"><option value="1" <%if(s_property.equals("1"))out.println("selected");%>>标签</option><option value="2" <%if(s_property.equals("2"))out.println("selected");%>>文本框</option><option value="4" <%if(s_property.equals("4"))out.println("selected");%>>按钮 </option><option value="3" <%if(s_property.equals("3"))out.println("selected");%>>下拉框</option><option value="7" <%if(s_property.equals("7"))out.println("selected");%>>编码下拉</option><option value="5" <%if(s_property.equals("5"))out.println("selected");%>>单选扭</option><option value="8" <%if(s_property.equals("8"))out.println("selected");%>>默认单选</option><option value="9" <%if(s_property.equals("9"))out.println("selected");%>>换行单选</option><option value="6" <%if(s_property.equals("6"))out.println("selected");%>>复选框</option><option value="10" <%if(s_property.equals("10"))out.println("selected");%>>大文本</option><option value="11" <%if(s_property.equals("11"))out.println("selected");%>>日期输入</option><option value="12" <%if(s_property.equals("12"))out.println("selected");%>>隐含变量</option></select>
</td>
<td width="76" height="12" ><!--跨行--><input type='text' name='T06' size='2' value="<%=s_rows%>">
</td>
<td width="76" height="12" ><!--跨列--><input type='text' name='T07' size='2' value="<%=s_colspan%>">
</td>
<td width="38" height="12" ><!--行结束--><input type="checkbox" name="T08" value="1" <%if((PubFunc.toShowForm(rs.getString(15))).equals("1"))out.println("checked");%>>
</td>
<td width="54" height="12" ><!--对齐--><select size="1" name="T09" style="width:50"><option value="center" <%if(a_align.equals("center"))out.println("selected");%>>居中</option><option value="left" <%if(a_align.equals("left"))out.println("selected");%>>居左</option><option value="right" <%if(a_align.equals("right"))out.println("selected");%>>居右</option><option value="top" <%if(a_align.equals("top"))out.println("selected");%>>居上</option><option value="bottom" <%if(a_align.equals("bottom"))out.println("selected");%>>居下</option></select>
</td>
<td width="76" height="12" ><!--宽度--><input type='text' name='T10' size='4' value="<%=PubFunc.toShowForm(rs.getString(7))%>">
</td>
<td width="111" height="12" ><!--高度--><input type='text' name='T11' size='4' value="<%=PubFunc.toShowForm(rs.getString(8))%>">
</td>
<td width="111" height="12" ><!--字体--><input type='text' name='T12' size='4' value="<%=PubFunc.toShowForm(rs.getString(9))%>">
</td>
<td width="111" height="12" ><!--字体大小--><input type='text' name='T13' size='4' value="<%=PubFunc.toShowForm(rs.getString(10))%>">
</td>
<td width="111" height="12" ><!--文字样式--><input type='text' name='T14' size='4' value="<%=PubFunc.toShowForm(rs.getString(11))%>" title="<%=PubFunc.toShowForm(rs.getString(11))%>">
</td>
<td width="111" height="12" ><!--文字颜色--><input type='text' name='T15' size='4' value="<%=PubFunc.toShowForm(rs.getString(12))%>">
</td>
<td width="111" height="12" ><!--是否可修改--><input type="checkbox" name="T16" value="1" <%if((PubFunc.toShowForm(rs.getString(30))).equals("1"))out.println("checked");%>>
</td>
<td width="111" height="12" ><!--class--><input type='text' name='T18' size='4' value="<%=PubFunc.toShowForm(rs.getString(29))%>" title="<%=PubFunc.toShowForm(rs.getString(29))%>">
</td>
<td width="111" height="12" ><!--元素输出值--><input type='text' name='T19' size='4' value="<%=PubFunc.toShowForm(rs.getString(17))%>" title="<%=PubFunc.toShowForm(rs.getString(17))%>">
</td>
<td width="80" height="12" ><!--左边线--><input type="checkbox" name="T20" value="1" <%if((PubFunc.toShowForm(rs.getString(18))).equals("1"))out.println("checked");%>>
</td>
<td width="40" height="12" ><!--右边线--><input type="checkbox" name="T21" value="1" <%if((PubFunc.toShowForm(rs.getString(19))).equals("1"))out.println("checked");%>>
</td>
<td width="39" height="12" ><!--上边线--><input type="checkbox" name="T22" value="1" <%if((PubFunc.toShowForm(rs.getString(20))).equals("1"))out.println("checked");%>>
</td>
<td width="41" height="12" ><!--下边线--><input type="checkbox" name="T23" value="1" <%if((PubFunc.toShowForm(rs.getString(21))).equals("1"))out.println("checked");%>>
</td>
<td width="41" height="12" ><!--元素输出格式-->
<select size='1' name='T24' style="width:60"><option value=''>请选择</option>
<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>
<option value="8" <%if((PubFunc.toShowForm(rs.getString(27))).equals("8"))out.println("selected");%>>保留位</option>
<option value="9" <%if((PubFunc.toShowForm(rs.getString(27))).equals("9"))out.println("selected");%>>格式输出</option>
</select>
</td>
<td width="111" height="12" ><!--输出样式--><input type='text' name='T25' size='4' value="<%=PubFunc.toShowForm(rs.getString(28))%>" title="<%=PubFunc.toShowForm(rs.getString(28))%>">
</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,rowspan1,colspan1,rowcolendpoint,change_sign,change_num_logic,position,border_haveno_sign,output_value,left_haveno_sign,left_startend_sign,right_haveno_sign,right_startend_sign,top_haveno_sign,top_startend_sign,bottom_haveno_sign,bottom_startend_sign,class_style,data_type,data_format
if(num>0)
if(document.form1.T00.length>1){
for(var i = 0;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;
rowspan1=document.form1.T06[i].value;
colspan1=document.form1.T07[i].value;
if(document.form1.T08[i].checked)rowcolendpoint="1"; else rowcolendpoint="0";
position=document.form1.T09[i].value;
width1=document.form1.T10[i].value;
height1=document.form1.T11[i].value;
font_type=document.form1.T12[i].value;
font_size=document.form1.T13[i].value;
font_style=document.form1.T14[i].value;
color1=document.form1.T15[i].value;
if(document.form1.T16[i].checked)change_sign="1"; else change_sign="0";
class_style=document.form1.T18[i].value;
output_value=charReplace(document.form1.T19[i].value);
data_type=document.form1.T24[i].value;
data_format=document.form1.T25[i].value;
if(document.form1.T20[i].checked)left_haveno_sign="1"; else left_haveno_sign="0";
if(document.form1.T21[i].checked)right_haveno_sign="1"; else right_haveno_sign="0";
if(document.form1.T22[i].checked)top_haveno_sign="1"; else top_haveno_sign="0";
if(document.form1.T23[i].checked)bottom_haveno_sign="1"; else bottom_haveno_sign="0";
str="insert into universal_pageelement_define (code,page_code,unit_code,unit_type,input_value,unit_style,unit_width,unit_height,font_type,font_size,font_style,font_color,unit_rowspan,unit_colspan,unit_rowcolendpoint,edit_item,unit_position,unit_class,output_value,left_haveno_sign,right_haveno_sign,top_haveno_sign,bottom_haveno_sign,data_type,data_format)values(?,'"+page_code+"','"+code1+"','"+type1+"','"+input_value+"','"+style1+"','"+width1+"','"+height1+"','"+font_type+"','"+font_size+"','"+font_style+"','"+color1+"','"+rowspan1+"','"+colspan1+"','"+rowcolendpoint+"','"+change_sign+"','"+position+"','"+class_style+"','"+output_value+"','"+left_haveno_sign+"','"+right_haveno_sign+"','"+top_haveno_sign+"','"+bottom_haveno_sign+"','"+data_type+"','"+data_format+"')";
document.form1.T00[i].value=str;
}
}
else{
page_code=document.form1.page_code.value;
code1=document.form1.T02.value;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -