📄 dx_topic.asp

📁 功能介绍： 1、产品入库
💻 ASP
字号:
<html>
<head>
<!--#include file="Inc/Config.asp"-->
<!--#include file="inc/Dx_admin_check.asp"-->
<title>库存报警</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Css/style.css" rel="stylesheet" type="text/css">
<style>
body {
	background-color:#FFFFFF;
}
</style>
</HEAD>

<BODY>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">
<tr>
<td><img src="images/r_1.gif" alt="" /></td>
<td width="100%" background="images/r_0.gif">
  <table cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td>&nbsp;库存报警</td>
	  <td align="right">&nbsp;</td>
    </tr>
  </table>
</td>
<td><img src="images/r_2.gif" alt="" /></td>
</tr>
<tr>
<td></td>
<td>
<table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1" width="100%">
      <tr align="center">
	    <td class="category" height="30">品名</td>
		<td class="category">存放仓库</td>
		<td class="category">库存数量</td>
      </tr>
<%
sql="select * from [Product_to_ToDepot] where dx_ToDepot_now_count<"&TopicNum&" and dx_ToDepot_now_count<>dx_ToDepot_buy_count"
rs.open sql,conn,1,1
if not rs.eof then
max_size=10
rs.pagesize=max_size
	page_now=1
	if trim(request.QueryString("page"))<>"" then
    page_now=cint(trim(request.QueryString("page")))
	end if
if page_now>rs.pagecount or page_now<0 then
   page_now=1
end if
rs.absolutepage=page_now
   i=1
while (not rs.eof) and i<max_size+1
%>
	  <tr onMouseOver="this.className='highlight'" onMouseOut="this.className=''">
	    <td align=center height=25><%=rs("dx_product_model")%></td>
		<td align=center><%=rs("dx_Depot_name")%></td>
		<td align=center>余<font color=#ff0000><%=rs("dx_ToDepot_now_count")%></font> | 共(<%=rs("dx_ToDepot_buy_count")%>)</td>
	  </tr>
<%
rs.movenext
i=i+1
wend
%>
        <tr class="category">
          <td colspan="3" align="right">
		<select name="select" 
		onChange="javascript:window.location='Dx_depot.asp?page='+this.options[this.selectedIndex].value;">
<%
for page=1 To rs.pagecount
%>
<option <%if page_now=page then%>selected="selected"<%end if%> value="<%=page%>">第<%=page%>页</option>
<%
next
%>
        </select> 
		  </td>
          </tr>
<%
else
%>  
      <tr onMouseOver="this.className='highlight'" onMouseOut="this.className=''">
	    <td align=center height=25 colspan="3" style="color:#ff0000">没有产品报警</td>
	  </tr>
<%
end if
rs.close
%>	  
</table>	
</td>
<td></td>
</tr>
<tr>
<td><img src="images/r_4.gif" alt="" /></td>
<td></td>
<td><img src="images/r_3.gif" alt="" /></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -