?? add_unit.jsp
字號:
<%@ page errorPage="err.jsp" %>
<%@ page contentType="text/html;charset=gb2312"%>
<%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""
|| session.getAttribute("scope")==null || !session.getAttribute("scope").equals("input_y"))
{
//response.sendRedirect("index.jsp");
out.println("<script language=javascript>window.top.location.href='index.jsp'</script>");
}
%>
<%@ page language="java" import="java.sql.*"%>
<%@ page language="java" import="java.util.*"%>
<jsp:useBean id="sqlbean" scope="page" class="qqhr.sql_data"/>
<jsp:useBean id="transcode" scope="page" class="qqhr.TransFormat"/>
<jsp:useBean id="pager" scope="page" class="qqhr.page" />
<%
String year;
year = request.getParameter("year");
request.setAttribute("year",year); // added later!
/* if(request.getParameter("year")==null || request.getParameter("year")=="")
{
year = (String)session.getAttribute("year");
}
else
{
year = request.getParameter("year");
}
*/
int mon= Calendar.getInstance().getTime().getMonth();
mon++;
String bm0 = null,unit0=null,newunit=null,second=null,third0=null,insertsql=null,kind=null,selectsql=null;
int parent0 = 0,child0 = 0;
/*String action=request.getParameter("action");
//out.print("<script language='javascript'>alert('action:"+action+"')</script>");
if(action!=null && action!="")
{
if(action.equals("save"))
{
bm0=transcode.GB2unicode(request.getParameter("bm0"));//取得編碼
second=transcode.GB2unicode(request.getParameter("second0"));//取得二級新單位
if(request.getParameter("unit0")!=null && request.getParameter("unit0")!="")
{
//parent0=Integer.valueOf(request.getParameterNames()).intValue();
unit0=transcode.GB2unicode(request.getParameter("unit0"));
selectsql="select id,kind from y031 where dw='"+unit0+"' and type=0 and year='"+year+"'";
ResultSet rs=sqlbean.executeQuery(selectsql);
if(rs.next())
{
parent0=rs.getInt("id");
kind=rs.getString("kind");
}
rs.close();
selectsql=null;
}//end if
// out.print("<script language='javascript'>alert('parent0:"+parent0+"')</script>");
if(request.getParameter("newunit")!=null && request.getParameter("newunit")!="")
{
newunit=transcode.GB2unicode(request.getParameter("newunit"));
out.print("<script language='javascript'>alert('newunit:"+newunit+"')</script>");
selectsql="select id,kind from y031 where dw='"+newunit+"' and type=0 and year='"+year+"'";
ResultSet rs=sqlbean.executeQuery(selectsql);
if(rs.next())
{
child0=rs.getInt("id");
kind=rs.getString("kind");
}
rs.close();
selectsql=null;
}//end if
out.print("<script language='javascript'>alert('newunit:"+newunit+" kind:"+kind+" child0:"+child0+"')</script>");
if(request.getParameter("third0")!=null && request.getParameter("third0")!="")
{
third0=transcode.GB2unicode(request.getParameter("third0"));
}
out.print("<script language='javascript'>alert('unti:"+unit0+" child0:"+child0+" bm0:"+bm0+" third0:"+third0+" kind:"+kind+" year:"+year+"')</script>");
if (third0!=null)
{
insertsql="insert into y031 (parent,bm,dw,kind,type,year)"+
"values("+child0+",'"+bm0+"','"+third0+"','"+kind+"',"+0+",'"+year+"')";
int n=sqlbean.executeInsert(insertsql);
if(n<0)
sqlbean.executeError("insert");
out.print("<script language='javascript'>alert('添加新單位成功！')</script>");
}
else
{
insertsql="insert into y031 (parent,bm,dw,kind,type,year)"+
"values("+parent0+",'"+bm0+"','"+second+"','"+kind+"',"+0+",'"+year+"')";
int n=sqlbean.executeInsert(insertsql);
if(n<0)
sqlbean.executeError("insert");
out.print("<script language='javascript'>alert('添加新單位成功！')</script>");
}
}
}*/
%>
<HTML>
<HEAD>
<title></title>
<link href="sun/css/css_ns6up.css" rel="stylesheet" type="text/css">
<link href="style/style.css" rel="stylesheet" />
<style type=text/css>
a:link {
color: #336699;
text-decoration: none;
}
a:visited {
color: #336699;
text-decoration: none;
}
a:hover {
color: #FF9900;
text-decoration: underline;
}
a:active {
color: #FF9900;
text-decoration: none;
}
body {
background-image: url(images/bg_main_white.jpg);
background-repeat: no-repeat;background-attachment:fixed;background-position:100%
}
</style>
<style type="text/css">
div.DataGrid
{
overflow: auto;
height: 400;
width: auto;
}
</style>
<SCRIPT LANGUAGE="JavaScript">
var ii=1;
var flag=0;//標記下拉框的狀態
function SelectAll()
{
var len=document.Form1.elements.length;
var i;
for (i=0;i<len;i++)
{
if (document.Form1.elements[i].type=="checkbox")
{
document.Form1.elements[i].checked=true;
}
}
}
function UnSelectAll()
{
var len=document.Form1.elements.length;
var i;
for (i=0;i<len;i++)
{
if (document.Form1.elements[i].type=="checkbox")
{
document.Form1.elements[i].checked=false;
}
}
}
function chkChs()
{
var HSC = document.getElementsByName('check');
var HSClen = HSC.length;
var HSCYN;
var i;
HSCYN=false;
for (i = 0;i< HSClen;i++)
{
if (HSC[i].checked==true)
{
HSCYN = true;
break;
}
}
if(!HSCYN)
{
alert("必須選中所添加的項目后才能進入添加下一步！");
return false;
}
return true;
}
function popsweb(inform,selected)
{
if(flag==1)
{
document.Form1.newunit.options.length=0;//清空列表框
//inform.newunit.innerHTML="";//清空列表框
for(var i=0;i< inform.alls.options.length ;i++)
{
if(inform.alls.options[i].name==selected)
{
var opt=new Option(inform.alls.options[i].value,inform.alls.options[i].value,true,true);
inform.newunit.options[inform.newunit.options.length] = opt;
}
}
}
}
function fixupFirstRow(tab)
{
var div = tab.parentNode;
if(div.className.toLowerCase() == "datagrid")
{
tab.rows[0].style.zIndex = "1";
tab.rows[0].style.position = "relative";
div.onscroll = function()
{
var tr = tab.rows[0];
tr.style.top = this.scrollTop - (this.scrollTop==0 ? 1 : 2);
}
}
}
window.onload = function()
{
var tab = document.getElementById("content");
if(tab) fixupFirstRow(tab);
}
function addrow()
{
// document.all['sjxxlist'].style.visibility='hidden';
var newTR = mb0.cloneNode(true);
newTR.id="mb"+ii;
ii++;
// newTR.ch.id = newTR.ch.id + "2";
mb0.parentNode.insertAdjacentElement("beforeEnd",newTR);
RowReset();
}
function hidden()
{
if(flag==0)
{
document.Form1.newunit.style.visibility="visible";
document.Form1.third0.style.visibility="visible";
document.Form1.second0.style.visibility="hidden";
flag=1;
}
else
{
document.Form1.newunit.style.visibility="hidden";
document.Form1.third0.style.visibility="hidden";
document.Form1.second0.style.visibility="visible";
flag=0;
}
}
</script>
</HEAD>
<body MS_POSITIONING="FlowLayout" style="background-color:transparent" >
<form name="Form1" method="post" action="y03_add_unit_next.jsp?action=save&year=<%=year%>" onSubmit="return chkChs();">
<table width="860" height="197" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="860" align="left" valign="top"><table class="Tbl" width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<caption class="TblTtlTxt">
添加單位科目
</caption>
<tr>
<td height="32" valign="middle" class="TblActTd"> <img src="sun/images/masthead/status_icon.gif" width="16" height="16"> 各欄不能為空! </td>
<td valign="middle" class="TblActTd"><span class="TblColHdr3">
<select name='alls' style="display:none;" >
<%
String allsql="select parent,dw from y031 where type=0 ";
ResultSet rs1=sqlbean.executeQuery(allsql);
while(rs1.next()){
int parent=rs1.getInt("parent");
String dw1=rs1.getString("dw");
%>
<option name='<%=parent %>' value='<%=dw1 %>'><%=dw1 %></option>
<%
parent=0;
dw1=null;
}
rs1.close();%>
</select>
</span></td>
</tr>
</table>
<table class="Tbl" width="100%" border="0" cellpadding="0" cellspacing="0" id="content">
<!--DWLayoutTable-->
<tr>
<td width="50" height="24" valign="middle" class="TblColHdr1" scope="col"><span class="TblHdrTxt"> <a href="#" name="check_all" title="全選" onClick="javascript:SelectAll();"><img name="SelectAllImage" src="sun/images/table/check_all.gif" alt="全選" border="0" height="13" width="15" /></a> <a href="#" name="uncheck_all" title="取消全選" onClick="javascript:UnSelectAll();"><img name="UnSelectAllImage" src="sun/images/table/uncheck_all.gif" alt="取消全選" border="0" height="13" width="15" /></a></span></td>
<td width="160" height="24" align="center" valign="middle" class="TblColHdr1" scope="col"><span class="TblHdrTxt">單位編碼</span></td>
<td width="160" height="24" align="center" valign="middle" class="TblColHdr1" scope="col"><span class="TblHdrTxt">一級科目</span></td>
<td width="335" height="24" align="center" valign="middle" class="TblColHdr1" scope="col"><span class="TblHdrTxt">二級科目</span></td>
<td width="156" valign="middle" align="center" class="TblColHdr" scope="col"><span class="TblHdrTxt">三級單位科目</span></td>
</tr>
<tr id="mb0">
<td height="24" valign="top"align="center" class="TblColHdr3"> <input type="checkbox" name="check" checked='checked' value="0"></td>
<td height="24" align="center" valign="top" class="TblColHdr3">
<input type="text" name="bm0" size=15> </td>
<td height="24" valign="top" class="TblColHdr3"><label>
<select name="unit0" id="unit0" onChange="popsweb(document.Form1,this.options[selectedIndex].name)" >
<%
String sql="select id ,dw from y031 where parent=0 and type=0";
ResultSet rs=sqlbean.executeQuery(sql);
while(rs.next())
{
int id=rs.getInt("id");
String dw0=rs.getString("dw");
%>
<option name='<%=id %>' ><%=dw0 %></option>
<%
id=0;
dw0=null;
}
rs.close();
%>
</select>
</label> </td>
<td align="left" valign="top"><label>
<input type="checkbox" name="checkbox" value="checkbox" onclick="hidden()" >
</label>
<select name="newunit" id='newunit' style="visibility:hidden" width='200' >
<option ></option>
</select>
<label>
<input name="second0" type="text" id="second0">
</label></td>
<td align="center"valign="top"><label>
<input name="third0" type="text" style="visibility:hidden" id="third0">
</label> </td>
</tr>
</table>
</tr>
<tr>
<td height="30" align="center">
<input name="next" type="submit" class="Btn1" id="next" onFocus="javascript: if (this.disabled==0) this.className='Btn1Hov'" onBlur="javascript: if (this.disabled==0) this.className='Btn1'" onMouseOver="javascript: if (this.disabled==0) this.className='Btn1Hov'" onMouseOut="javascript: if (this.disabled==0) this.className='Btn1'" value="下一步" />
<input name="cancel" type="button" class="Btn1" id="cancel" onClick="javascript:window.location.href='y03.jsp'" onFocus="javascript: if (this.disabled==0) this.className='Btn1Hov'" onBlur="javascript: if (this.disabled==0) this.className='Btn1'" onMouseOver="javascript: if (this.disabled==0) this.className='Btn1Hov'" onMouseOut="javascript: if (this.disabled==0) this.className='Btn1'" value="取 消" /></td></tr>
</table>
</form>
</body>
</HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -