📄 schedule.asp
字号:
<!--#include file="../title.asp" -->
<meta http-equiv="Content-Language" content="en-us">
<body topmargin="0" leftmargin="0">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%">
<form method="POST" action="schedule_seach.asp">
<p align="center">
<span lang="zh-cn">Seach：<input type="text" name="T1" size="13" value="Ref_No"></span>
<select size="1" name="client">
<%
sql="select * from client"
rs.open sql,conn,1,3
do while not rs.eof
%>
<option value="<%=rs("id")%>"><%=rs("en_name")%></option>
<%
rs.movenext
loop
rs.close
%>
</select>
<input type="submit" value="Go!" name="B1"></p>
</form>
</td>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="900">
<tr align="center">
<td width="140"><span lang="zh-cn">REF NO</span></td>
<td width="60"><span lang="zh-cn">BUYER</span></td>
<td width="60"><span lang="zh-cn">STYLE NO</span></td>
<td width="60"><span lang="zh-cn">PATTERN</span></td>
<td width="60"><span lang="zh-cn">ORDER QTY</span></td>
<td width="60"><span lang="zh-cn">SKETCH</span></td>
<td width="60"><span lang="zh-cn">QUANITY(YDS)</span></td>
<td width="60"><span lang="zh-cn">QUANTITY(KGS)</span></td>
<td width="60"><span lang="zh-cn">UNIT RICE </span></td>
<td width="60"><span lang="zh-cn">AMOUNT US$</span></td>
<td width="60"><span lang="zh-cn">Y/D(Delivery)</span></td>
<td width="60"><span lang="zh-cn">SOLID(Delivery)</span></td>
<td width="60"><span lang="zh-cn">MERCHANDISER</span></td>
</tr>
<%
sql="select * from cloth_info order by ref_no"
rs.open sql,conn,1,3
do while not rs.eof
%>
<tr>
<td width="140"><span lang="zh-cn"><a href="schedule_info.asp?ref_no=<%=rs("ref_no")%>"><%=rs("ref_no")%></span> </td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("buyer")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("style")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("patten")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("order_qty")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("sketch")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("quantity_yds")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("quantity_kgs")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("unit_price")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("amount_us")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("fabric_delivery")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("cloth_delivery")%>"></td>
<td width="60"><input type="text" name="T1" size="8" value="<%=rs("merchandiser")%>"></td>
</tr>
<%
rs.movenext
loop
rs.close
%>
</table>
<!--#include file="../copyright.asp" -->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -