📄 inventoryreservedetail.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
sysid=1
Dim objcheck
Set objcheck=Server.CreateObject("SmartSales.CheckFunction")
objcheck.CheckUserFunction "orderreserve","read"
set objcheck=nothing
dim conn
dim rs
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.Open connstring
sql="select * from v_orderreserve where sysaccountid='"&sysid&"' and productid='"&request("productid")&"' and status='保留同意'"
'Response.Write sql
rs.Open sql,conn,1,1
if not rs.eof then
set productcode=rs("productcode")
set model=rs("model")
set qty=rs("qty")
set username=rs("username")
set createdate=rs("createdate")
set ordernum=rs("ordernum")
set orderid=rs("orderid")
set reservedate=rs("reservedate")
set lineid=rs("orderlineid")
else
productcode=getfieldvalue("product","productid",cint(request("productid")),"productcode")
model=getfieldvalue("product","productid",cint(request("productid")),"model")
end if
%>
<html>
<head>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>库存保留</title>
</head>
<body leftmargin="10" rightmargin="10" topmargin="10">
<table align=center width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25"><strong><font class=title>型号:<%=model%></font></strong> </td>
<td align="right">货号：<%=productcode%></td>
</tr>
<tr >
<td height="16" colspan="2" background="../images/title.gif"> </td>
</tr>
<tr>
<td height=4 colspan="2"></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#DECFAD">
<tr bgcolor="efefef">
<td width="20%" align=center height="22">保留人</td>
<td width="20%" align=center>保留日期</td>
<td width="20%" align=center>保留数量</td>
<td width="20%" align=center>保留到日期</td>
<td width="20%" align=center>保留合同</td>
</tr>
<%
if not rs.EOF then
i=1:do while not rs.EOF
%>
<tr bgcolor="#FFFFFF">
<td align=center height="22"><%=username%></td>
<td align=center><%=year(createdate)%>-<%=month(createdate)%>-<%=day(createdate)%></td>
<td align=center><%=qty%></td>
<td align=center><%if reservedate-date()<0 then%><font color=red><%=reservedate%></font><%else%><%=reservedate%><%end if%></td>
<td align=center><%=ordernum%></td>
</tr>
<%
i=i+1
rs.MoveNext
loop
else
%>
<tr bgcolor="#FFFFFF">
<td align=left height="22" colspan=5 class=title>无保留</td>
</tr>
</table>
<%
end if
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -