inquireprintresult.asp

1 除掉了 时间 限制 2 除掉了 人数 限制 改为 500人 原为5人 3 发现一点小缺陷 增加人员的时候没有判断 登陆名是否重复！ 自己写吧~~~：） 4 又 是一点缺陷

		rspoline.movefirst
		k=(Request.QueryString("thepage")-1)*rspara("line")
		rspoline.Move k
		i=1
		for x=(Request.QueryString("thepage")-1)*rspara("line")+1 to (Request.QueryString("thepage")-1)*rspara("line")+rspara("line")
			Response.Write "<tr bgcolor=#FFFFFF>"
			response.write "<td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&i&"</font></td><td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&rspoline("name")&"</font></td><td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&rspoline("model")&"</font></td><td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&rspoline("qty")&"</font></td><td align=right><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif></font></td><td align=right><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif></font></td><td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&rspoline("ExpectedDate")&"</font></td>"
			Response.Write "</tr>"
		i=i+1
		rspoline.movenext
		next
	else
		rspoline.movefirst
		k=(Request.QueryString("thepage")-1)*rspara("line")
		rspoline.Move k
		i=1
		for x=(Request.QueryString("thepage")-1)*rspara("line")+1 to rspoline.RecordCount
			Response.Write "<tr bgcolor=#FFFFFF>"
			response.write "<td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&i&"</font></td><td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&rspoline("name")&"</font></td><td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&rspoline("model")&"</font></td><td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&rspoline("qty")&"</font></td><td align=right><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif></font></td><td align=right><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif></font></td><td align=center><font color=000000 size=2 face=Verdana, Arial, Helvetica, sans-serif>"&rspoline("ExpectedDate")&"</font></td>"
			Response.Write "</tr>"
		i=i+1
		rspoline.movenext
		next
	end if
	
	'判断当前页，输出空白行
	if Request.QueryString("thepage")="" then		
		if i<rspara("line") then
			for x=1 to rspara("line")-i
				Response.Write "<tr><td colspan=8 height=18></td></tr>"
			next
		end if
	elseif Request.QueryString("totalpages")=Request.QueryString("thepage") then
			if rspoline.RecordCount mod rspara("line")<>0 then
				for x=1 to rspara("line")-(rspoline.RecordCount mod rspara("line"))
					Response.Write "<tr><td colspan=8 height=20></td></tr>"
				next
			end if
	end if
	 'response.Write "</font></td>"

 %>
        <%
  rspoline.Close
  set rspoline=nothing
  connorderline.Close 
  set connorderline=nothing
  %>
        <tr>
          <td colspan=7><img src="../images/blackloginbutton.gif" width="595" height="2"></td>
        </tr>
      </table>
          <%if Request.QueryString("thepage")="" or (Request.QueryString("thepage")<>"" and Request.QueryString("thepage")=Request.QueryString("totalpages")) then%>

	  
<table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr valign="bottom" bgcolor="#FFFFFF"> 
          <td height="25"> 
            <div align="right"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">合计：</font></div></td>
          <td width="40%" height="25"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font> 
        </tr>
		<tr>
			<td></td>
			<td height="2"><img src="../images/blackloginbutton.gif" width="100%" height="1"></td></tr>
        <tr valign="bottom" bgcolor="#FFFFFF"> 
          <td height="25"> 
            <div align="right"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">大写：</font></div></td>
          <td width="40%" height="25"><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
        </tr>
		<tr>
			<td></td>
			<td><img src="../images/blackloginbutton.gif" width="100%" height="1"></td></tr>
      </table>
        
      <%end if%>
      <br>
      2、<font color="#000000" size="2"><font face="Verdana, Arial, Helvetica, sans-serif">付款</font><font size="2" face="Verdana, Arial, Helvetica, sans-serif">方式：</font></font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000000"><%=rs("term")%></font></font><br>
      3、<font color="#000000" size="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">运货方式：</font></font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000000"><%=rs("shipvia")%></font></font> 
      <br>
      <font color="#000000"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
      <%if rs("termline")<>"" then response.write replace(rs("termline"),chr(10),"<br>")%>
      </font></font> 
      <table width="100%" border="0" cellpadding="2" cellspacing="0">
        <tr> 
          <td colspan="2" height=30> 
            <!--img src="../images/blackloginbutton.gif" width="100%" height="1"-->
          </td>
        </tr>
        <tr> 
          <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000000"></font></font></td>
        </tr>
        <tr> 
          <td width="50%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000000">供方(章)：</font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><%=rs("account")%></font></font></td>
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000000">需方(章)：<%=rsco("company")%></font></font></td>
        </tr>
        <tr> 
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">地址：<font color="#000000"><%=rs("billaddress")%></font></font></td>
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">地址：<font color="#000000"><%=rsco("address")%></font></font></td>
        </tr>
        <tr> 
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">发货地址：<font color="#000000"><%=rs("shipaddress")%></font></font></td>
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">发货地址：<font color="#000000"><%=rsco("whseaddress")%></font></font></td>
        </tr>
        <tr> 
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">电话：<font color="#000000"><%=rs("phone")%></font></font></td>
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">电话：<font color="#000000"><%=rsco("phone")%></font></font></td>
        </tr>
        <tr> 
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">传真：<font color="#000000"><%=rs("fax")%></font></font></td>
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">传真：<font color="#000000"><%=rsco("fax")%></font></font></td>
        </tr>
        <tr>
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">联系人：<font color="#000000"><%=rs("contact")%></font></font></td>
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">备件人：<font color="#000000"><%=rs("username")%></font></font></td>
        </tr>
        <tr> 
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">开户行：<font color="#000000"><%=rs("accountbank")%></font></font></td>
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">开户行：<font color="#000000"><%=rsco("bank")%></font></font></td>
        </tr>
        <tr> 
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">帐号：<font color="#000000"><%=rs("accountno")%></font></font></td>
          <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">帐号：<font color="#000000"><%=rsco("accountno")%></font></font></td>
        </tr>
      </table>
      <table width="100%" border="0" cellspacing="1" cellpadding="1">
        <tr> 
          <td width="50%" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">税号：<font color="#000000"><%=rs("taxno")%></font></font></td>
          <td width="50%" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">税号：<font color="#000000"><%=rsco("taxno")%></font></font></td>
        </tr>
      </table>
      <script language="JavaScript">window.print();</script>
</td></tr></table>
</body>
</html>
<%
  rs.Close
  set rs=nothing
  conn.Close 
  set conn=nothing
  %>