?? type.asp
字號:
<%@ LANGUAGE="VBSCRIPT" %>
<% response.buffer=true %>
<%const title="倉庫物品類別分類程序"%>
<!-- #include file=opendb.inc-->
<!--#include file=myPrg.asp-->
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft FrontPage 3.0" CHARSET="GB2312">
<title><%=title%></title>
<link rel="stylesheet" type="text/css" href="forum.css">
</head>
<body topmargin="0">
<%
CheckLogin
Showtitle(title)
getStorage(session("storage"))
%>
<%
if request.querystring("prnt")="" then
session("prnt")=0
else
session("prnt")=request.querystring("prnt")
end if
gettypepath
response.write "<hr size=1>"
' 列出類別目錄
sql="select * from type where parent_id="&session("prnt")&" and in_storage="&session("storage")
rs.open sql,conn,3,2
if not rs.eof then
do while not rs.eof
sql="select count(*) as num_count from stock where type_id="&rs("type_id")
rs2.open sql,conn
pzs=rs2("num_count")
rs2.close
sql="select count(*) as num_count from type where parent_id="&rs("type_id")
rs2.open sql,conn
lbs=rs2("num_count")
rs2.close
if lbs=0 then
show_lbs=""
else
show_lbs="(<font color=green>"&lbs&"</font>)"
end if
response.write "<font color=green><li><a href=type.asp?prnt="&rs("type_id") &">"&rs("type_name")&"</a> </font>(<font color=red>"&pzs&"</font>)"&show_lbs&"</li></font>"
rs.movenext
loop
else
response.write "<li>沒有下級類別 "
' [ <a href=type.asp?prnt="&session("prnt")&">查看該類明細</a> ]</li>"
end if
rs.close
%>
<hr size=1>
<table border='0' width='100%' bordercolorlight='#c0c0c0' cellspacing='1' bordercolordark='#FFFFFF' height='26'>
<%
gettype(session("prnt"))
' <tr bgcolor='#ff bc bc'><td colspan=9>
sql="select * from stock where type_id="&session("prnt")&" order by name"
rs.open sql,conn
if not rs.eof then
response.write " <tr bgcolor='#0000A0'>"
response.write " <td nowrap align=center ><font color=white>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -