28,390
社区成员
发帖
与我相关
我的任务
分享
<%
Set rs=Server.CreateObject("ADODB.Recordset")
Sql="Select * from crtoys where rkcount>ckcount order by id"
rs.Open Sql,Conn,1,1
if rs.eof then
%>
<tr>
<td colspan="5"> 暂时未添加信息</td>
</tr>
<%
else
do while not rs.eof
%>
<tr>
<td>
<%Set rs1=Server.CreateObject("ADODB.Recordset")
Sql="Select * from toys where id="&rs("toyid")
rs1.Open Sql,Conn,1,1
if rs1.eof=false then
response.Write(rs1("toyname"))
end if
%></td>
<td> <%=rs("rkcount")%></td>
<td> <%=rs("rkdate")%></td>
<td> <%=rs("rkry")%></td>
<td> <a href="cktoys_edit.asp?id=<%=rs("id")%>">出库</a>
</td>
</tr>
<%
rs.movenext
loop
end if
%>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
Sql="Select * from kucun order by k_id"
rs.Open Sql,Conn,1,1
if rs.eof then
%>
<tr>
<td colspan="5"> 暂时未添加信息</td>
</tr>
<%
else
do while not rs.eof
%>
<tr>
<td>
<%Set rs1=Server.CreateObject("ADODB.Recordset")
Sql="Select * from info where i_ccode="&rs("k_ccode")
rs1.Open Sql,Conn,1,1
if rs1.eof=false then
response.Write(rs1("i_name"))
end if
%></td>
<td> <%=rs("k_rkamount")%></td>
<td> <%=rs("k_rkdate")%></td>
<td> <%=rs("k_pos")%></td>
<td> <a href="cktoys_edit.asp?id=<%=rs("id")%>">出库</a>
</td>
</tr>
<%
rs.movenext
loop
end if
%>
Sql="Select * from info where i_ccode="&rs("k_ccode")
response.write(sql)
response.end
<%
Set rs=Server.CreateObject("ADODB.Recordset")
Sql="Select * from kucun,info where i_ccode=k_ccode order by k_rkdate"
rs.Open Sql,Conn,1,1
%>