addreportdatalayer.jsp

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

			positiontop=document.form1.T14[i].value;			
			output_value=charReplace(document.form1.T15[i].value);			
			data_type=document.form1.T16[i].value;
			data_format=document.form1.T17[i].value;					
			str="insert into universal_pageelement_define (code,page_code,unit_code,unit_type,input_value,unit_style,unit_position,unit_width,unit_height,font_type,font_size,font_style,font_color,positionLeft,positiontop,output_value,data_type,data_format,positionlock)values(?,'"+page_code+"','"+code1+"','"+type1+"','"+input_value+"','"+style1+"','"+position+"','"+width1+"','"+height1+"','"+font_type+"','"+font_size+"','"+font_style+"','"+color1+"','"+positionLeft+"','"+positiontop+"','"+output_value+"','"+data_type+"','"+data_format+"','1')";		
			document.form1.T00[i].value=str;	
			//alert(str);	
		}
	}
	else{
			page_code=document.form1.page_code.value;
			code1=document.form1.T02.value;		
			type1=document.form1.T03.value;
			input_value=charReplace(document.form1.T04.value);
			style1=document.form1.T05.value;				
			position=document.form1.T06.value;		
			width1=document.form1.T07.value;
			height1=document.form1.T08.value;		
			font_type=document.form1.T09.value;
			font_size=document.form1.T10.value;
			font_style=document.form1.T11.value;	
			color1=document.form1.T12.value;	
			positionLeft=document.form1.T13.value;
			positiontop=document.form1.T14.value;
			output_value=charReplace(document.form1.T15.value);						
			data_type=document.form1.T16.value;
			data_format=document.form1.T17.value;								
			str="insert into universal_pageelement_define (code,page_code,unit_code,unit_type,input_value,unit_style,unit_position,unit_width,unit_height,font_type,font_size,font_style,font_color,positionLeft,positiontop,output_value,data_type,data_format,positionlock)values(?,'"+page_code+"','"+code1+"','"+type1+"','"+input_value+"','"+style1+"','"+position+"','"+width1+"','"+height1+"','"+font_type+"','"+font_size+"','"+font_style+"','"+color1+"','"+positionLeft+"','"+positiontop+"','"+output_value+"','"+data_type+"','"+data_format+"','1')";		
			document.form1.T00.value=str;			
	}
	
	document.form1.submit();
}

function addline(){
	var i=0;	
	var str="";
	var numstr=0;	
	num++;
	AutoNumber14.insertRow(num);
	for(i=0;i<17;i++)AutoNumber14.rows(num).insertCell();
	AutoNumber14.rows(num).cells(0).innerHTML ="<input type='hidden' name='T00' size='15'>";	
	AutoNumber14.rows(num).cells(1).innerHTML ="<input type='text' name='T02' size='7' value="+'80010001'+" onmouseover=\"drs('编号'); return true;\" onmouseout=\"nd(); return true;\">";
	AutoNumber14.rows(num).cells(2).innerHTML ="<select size='1' name='T03' onmouseover=\"drs('类型'); return true;\" onmouseout=\"nd(); return true;\"><option value='1' selected>基本标签</option><option value='2'>业务逻辑</option><option value='3'>表示编码值</option><option value='4'>页面参数值</option></select>";
	AutoNumber14.rows(num).cells(3).innerHTML ="<input type='text' name='T04' size='18' onmouseover=\"drs('内容'); return true;\" onmouseout=\"nd(); return true;\">";
	AutoNumber14.rows(num).cells(4).innerHTML ="<select size='1' name='T05' onmouseover=\"drs('属性'); return true;\" onmouseout=\"nd(); return true;\"><option value='1' selected>标签</option><option value='2'>文本框</option><option value='4'>按钮 </option><option value='3'>下拉框</option><option value='5'>单选扭</option><option value='6'>复选框</option></select>";
	AutoNumber14.rows(num).cells(5).innerHTML ="<select size='1' name='T06' onmouseover=\"drs('对齐'); return true;\" onmouseout=\"nd(); return true;\" ><option value='center'>居中</option><option value='left'>居左</option><option value='right'>居右</option></select>";
	AutoNumber14.rows(num).cells(6).innerHTML ="<input type='text' name='T07' size='4' onmouseover=\"drs('宽度'); return true;\" onmouseout=\"nd(); return true;\" value=0>";
	AutoNumber14.rows(num).cells(7).innerHTML ="<input type='text' name='T08' size='4' onmouseover=\"drs('高度'); return true;\" onmouseout=\"nd(); return true;\">";
	AutoNumber14.rows(num).cells(8).innerHTML ="<input type='text' name='T09' size='4' onmouseover=\"drs('字体'); return true;\" onmouseout=\"nd(); return true;\">";
	AutoNumber14.rows(num).cells(9).innerHTML ="<input type='text' name='T10' size='4' onmouseover=\"drs('字体大小'); return true;\" onmouseout=\"nd(); return true;\">";
	AutoNumber14.rows(num).cells(10).innerHTML ="<input type='text' name='T11' size='4' onmouseover=\"drs('文字样式'); return true;\" onmouseout=\"nd(); return true;\">";
	AutoNumber14.rows(num).cells(11).innerHTML ="<input type='text' name='T12' size='4' onmouseover=\"drs('文字颜色'); return true;\" onmouseout=\"nd(); return true;\">";	
	AutoNumber14.rows(num).cells(12).innerHTML ="<input type='text' name='T13' size='4' onmouseover=\"drs('左边距'); return true;\" onmouseout=\"nd(); return true;\">";
	AutoNumber14.rows(num).cells(13).innerHTML ="<input type='text' name='T14' size='4' onmouseover=\"drs('上边距'); return true;\" onmouseout=\"nd(); return true;\">";	
	AutoNumber14.rows(num).cells(14).innerHTML ="<input type='text' name='T15' size='14' onmouseover=\"drs('元素输出值'); return true;\" onmouseout=\"nd(); return true;\">";
	AutoNumber14.rows(num).cells(15).innerHTML ="<select size='1' name='T16' onmouseover=\"drs('元素输出格式'); return true;\" onmouseout=\"nd(); return true;\" ><option value='1'>普通字符输出</option><option value='2'>大写字符输出</option><option value='6'>大写数字输出</option><option value='3'>钱币数字输出</option><option value='4'>数字日期显示</option><option value='5'>大写日期显示</option><option value='7'>日期转换</option></select>";
	AutoNumber14.rows(num).cells(16).innerHTML ="<input type='text' name='T17' size='5' onmouseover=\"drs('元素输出样式'); return true;\" onmouseout=\"nd(); return true;\">";	
	
	//校验上一行			
	if(num>1)
	if(document.form1.T08[num-2].checked){
		//换行
		numstr=Math.round((document.form1.T02[num-2].value).substr(0,4))+1;			
		if(numstr<10)str="000"+numstr;
		if(numstr>9&&numstr<100)str="00"+numstr;
		if(numstr>99&&numstr<1000)str="0"+numstr;
		if(numstr>999&&numstr<10000)str=""+numstr;
		document.form1.T02[num-1].value=str+"0001";
	}
	else{
		//不换行
		numstr=Math.round((document.form1.T02[num-2].value).substr(4,9))+1;			
		if(numstr<10)str="000"+numstr;
		if(numstr>9&&numstr<100)str="00"+numstr;
		if(numstr>99&&numstr<1000)str="0"+numstr;
		if(numstr>999&&numstr<10000)str=""+numstr;
		document.form1.T02[num-1].value=(document.form1.T02[num-2].value).substr(0,4)+str;
	}	
}
function delline(){
	if(num<1)alert("没有可删除的对象！");
	else
	{
		AutoNumber14.deleteRow(num);
		num--;
	}
}
function viwe(){
	document.form2.action="<%=request.getContextPath()%>/pageBuilderAction.do?action=1001&page_code=<%=page_code%>"+parent.parent.header.form1.strParment.value;	
	document.form2.submit();	
}
function delldata(){
	document.form1.action="delldata.jsp?page_code=<%=page_code%>";
	document.form1.submit();
}

previous_index=1;   
   
function over_change(index,src,clrOver){   
		if (!src.contains(event.fromElement))    
	 		{    
	 		src.style.cursor = 'hand';   
	 		src.bgColor = clrOver;   
	 		}   
}   
   
function out_change(index,src,clrIn){   
		if (!src.contains(event.toElement))   
			{   
			src.style.cursor = 'default';   
			src.bgColor = clrIn;   
			}   
}   

function charReplace(tempstr){
	var i,temp,str;	
	var num;	
	str="";
	for(i=0;i<tempstr.length;i++){
		if(tempstr.substring(i,i+1)=="'")
			str=str+"''";
		else
			str=str+tempstr.substring(i,i+1);
	}
	return str;
}
</script>
<center>
<p><input type="button" value="添加行" name="B1" onclick='addline();'>&nbsp;&nbsp;<input type="button" value="删除行" name="B2" onclick='delline();'><p><input type="button" value="保存" name="B3" onclick='check();'>&nbsp;&nbsp;<input type="button" value="预览" name="B3" onclick='viwe();'>
</p>
</form>
<form method="POST" action="" name=form2 target="_blank">
</form>
</body>
</html>

<%
    rs.close();
    con.close();
}catch(Exception ex){
	Debug.println("addreportDatalayer.jsp exception:"+ex.getMessage());
}%>