navigate.asp

建造工业系统所需的SQL源代码

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function Myopen(divID){ //根据传递的参数确定显示的层
	divID.style.display='';
	divID.style.left=(screen.width-240)/2;
	divID.style.top=(screen.height-277)/2;
}
</script>
<table width="100%" height="95"  border="0" cellpadding="-2" cellspacing="-2" class="tableBorder_Top">
          <tr valign="top">
            <td height="72" colspan="4"><table width="100%"  border="0" cellpadding="-2" cellspacing="-2" class="tableBorder_Botton">
              <tr>
                <td width="33%" height="67" align="right"><img src="Images/board_title.gif" width="227" height="44"></td>
                <td width="67%" background="Images/banner_bg.gif">&nbsp;</td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td width="10" height="24" background="Images/bg_Navigate.GIF">&nbsp; </td>
			<!--版主登录时显示的导航条-->
			<%If Session("UserName")<>"" And Session("Status")="版主" Then%>
            <td background="Images/bg_Navigate.GIF">
				<a href="User_Manage.asp">用户管理</a> ┊<a href="Add_Topic.asp"> 签写留言</a>
			 ┊ <a href="index.asp">查看留言</a> ┊ <a href="#" onClick="window.location.reload();">刷新页面</a> ┊ <a href="#" onClick="window.location.href='Logout.asp'">注销登录</a> </td>
            <td width="20" background="Images/bg_Navigate.GIF"><img src="Images/index.gif" width="14" height="14"></td>
			<%Else%>
            <td background="Images/bg_Navigate.GIF">
			<%If Session("UserName")="" Then%>
				<a href="register.asp">用户注册</a>
			 <%Else%>
			 	<a href="Add_Topic.asp"> 签写留言</a>
			 <%End If%> ┊
			 <%If Session("UserName")="" Then%>
			<a href="#" onClick="Myopen(User)">用户登录</a>
			 <%Else%>
			 	<a href="#" onClick="window.location.href='Logout.asp'"> 注销用户</a>
			 <%End If%> ┊ <a href="index.asp">查看留言</a> ┊ <a href="#" onClick="window.location.reload();">刷新页面</a> ┊ 
			 <%If Session("UserName")="" Then%>
				<a href="#" onClick="Myopen(Manager)">版主登录</a>
			 <%Else%>
			 	<a href="Modify.asp"> 修改资料</a>
			 <%End If%>  </td>
            <td width="20" background="Images/bg_Navigate.GIF"><img src="Images/index.gif" width="14" height="14"></td>
			<%End If%>
            <td width="80" background="Images/bg_Navigate.GIF"><a href="GoHome.asp">返回首页</a><font color="#FFFFFF"></td>
          </tr>
</table></td>
      </tr>
    </table>
<script language="javascript">
	function clockon(){
		var now=new Date();
		var year=now.getYear();
		var month=now.getMonth();
		var date=now.getDate();
		var day=now.getDay();
		var hour=now.getHours();
		var minu=now.getMinutes();
		var sec=now.getSeconds();
		var week;
		month=month+1;
		if(month<10) month="0"+month;
		if(date<10) date="0"+date;
		if(hour<10) hour="0"+hour;
		if(minu<10) minu="0"+minu;
		if(sec<10) sec="0"+sec;
		switch (day)
		  { case 1:
		        week="星期一";
				break;
			case 2:
		        week="星期二";
				break;
			case 3:
		        week="星期三";
				break;
			case 4:
		        week="星期四";
				break;
			case 5:
		        week="星期五";
				break;
			case 6:
		        week="星期六";
				break;
			default:
		        week="星期日";
				break;
		  }
		var time="";
		time=year+"年"+month+"月"+date+"日 "+week+" "+hour+":"+minu+":"+sec;
		if(document.all){
			bgclock.innerHTML="系统公告：["+time+"]"
		}
		var timer=setTimeout("clockon()",200);
	}  
</script>

      <table width="100%" height="45"  border="0" cellpadding="-2" cellspacing="-2">
        <tr>
          <td>  &nbsp;<img src="Images/speaker.gif" width="20" height="20"></td>
		  <td><div id="bgclock" class="word_grey"></div></td>
		  <td class="word_grey">
		    <div align="right">
		      <%If Session("UserName")<>"" Then
		   Response.Write("[ "&Session("UserName")&" ] 您好！您不想说点什么吗？如果想，请单击“签写留言”。")
		   Else%>
		   您现在是游客身份！若要留言请先注册或登录！
		   <%End If%>
	      </div></td>
		  <td height="25" colspan="2">&nbsp;</td>
        </tr>
        <tr>
          <td width="34">&nbsp;</td>
          <td width="723" height="13" colspan="2"><marquee direction="left" scrollamount="1" scrolldelay="7">
          <img src="Images/dog.gif" width="19" height="18">欢迎来到明日实业留言簿 请留下您的金玉良言！！！</marquee></td>
          <td width="20">&nbsp;</td>
        </tr>
      </table>
<script language="javascript">
function mycheck(myform,tool){
if (myform.UID.value=="")
{alert("请输入"+tool+"！");myform.UID.focus();return;}
if(myform.PWD.value=="")
{alert("请输入密码！");myform.PWD.focus();return;}
myform.submit();
}
</script>
<!--应用层设计用户登录表单页面开始-->
<div id="User" style="position:absolute;width:240px; height:139px;display:none;">
<table width="240" height="139"  border="0" align="center" cellpadding="-2" cellspacing="-2">
  <tr>
    <td height="139" align="center"><form name="form_U" method="post" action="Login.asp">
        <table width="220" height="115" bgcolor="#FFFFFF" border="0" align="center" cellpadding="-2" cellspacing="-2" class="tableBorder">
          <tr align="center" valign="middle">
            <td height="24" colspan="2" background="Images/bg_Login.GIF"><font color="#505875">=== 用户登录 === </font> </td>
          </tr>
          <tr>
            <td width="61" height="27" align="right" valign="middle">用户名：</td>
            <td width="157" valign="middle"><input name="UID" type="text" maxlength="20"></td>
          </tr>
          <tr>
            <td height="27" align="right" valign="middle">密 &nbsp;码：</td>
            <td valign="middle"><input name="PWD" type="password"  maxlength="20" onKeyDown="if(event.keyCode==13) mycheck(form_U,'用户名')"></td>
          </tr>
          <tr align="center" valign="middle">
            <td height="27" colspan="2"><input name="Submit" type="button" class="btn_grey" value="登录" onClick="mycheck(form_U,'用户名')">
&nbsp;
            <input name="Submit2" type="button" class="btn_grey" value="关闭" onClick="javascript:User.style.display='none';"></td>
          </tr>
        </table>
    </form></td>
  </tr>
</table>
</div>
<!--应用层设计用户登录表单页面结束-->
<!--应用层设计版主登录表单页面开始-->
<div id="Manager" style="position:absolute;width:240px; height:139px;display:none;">
<table width="240" height="139"  border="0" align="center" cellpadding="-2" cellspacing="-2">
  <tr>
    <td height="139" align="center"><form name="form_M" method="post" action="Login_M.asp">
        <table width="220" height="115" bgcolor="#FFFFFF" border="0" align="center" cellpadding="-2" cellspacing="-2" class="tableBorder">
          <tr align="center" valign="middle">
            <td height="24" colspan="2" background="Images/bg_Login.GIF"><font color="#505875">=== 版主登录 === </font> </td>
          </tr>
          <tr>
            <td width="67" height="27" align="right" valign="middle">版主名称：</td>
            <td width="151" valign="middle"><input name="UID" type="text" maxlength="20"></td>
          </tr>
          <tr>
            <td height="27" align="right" valign="middle">密&nbsp;&nbsp; &nbsp;码：</td>
            <td valign="middle"><input name="PWD" type="password"  maxlength="20" onKeyDown="if(event.keyCode==13) mycheck(form_M,'版主名称')"></td>
          </tr>
          <tr align="center" valign="middle">
            <td height="27" colspan="2"><input name="Submit" type="button" class="btn_grey" value="登录" onClick="mycheck(form_M,'版主名称')">
&nbsp;
            <input name="Submit2" type="button" class="btn_grey" value="关闭" onClick="javascript:Manager.style.display='none';"></td>
          </tr>
        </table>
    </form></td>
  </tr>
</table>
</div>
<!--应用层设计版主登录表单页面结束-->
<!--以下代码用于控制用户输入的用户名或密码错误后返回到该页面仍存在登录入口-->
<%If Session("HS")="User" Then%>
<script language="javascript">
	User.style.display='';
	User.style.left=(screen.width-240)/2;
	User.style.top=(screen.height-277)/2;
</script>
<%
Session("HS")=""
End If
%>
<!--以下代码用于控制版主输入的版主名或密码错误后返回到该页面仍存在登录入口-->
<%If Session("HS")="Manager" Then %>
<script language="javascript">
	Manager.style.display='';
	Manager.style.left=(screen.width-240)/2;
	Manager.style.top=(screen.height-277)/2;
</script>
<%
Session("HS")=""
End If
%>