<!--#include file="db.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="refresh" content="10">

<title>PDA服务器<%=Request.ServerVariables("LOCAL_ADDR")%>....</title>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
a:link {
	text-decoration: none;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.STYLE4 {	color: #FFFFFF;
	font-family: Geneva, Arial, Helvetica, sans-serif;
}
.STYLE5 {font-size: 24px}
-->
</style>
</head>

<body>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
   <tr>
     <th height="30" colspan="2" bgcolor="#333" scope="col"><div align="center"><span class="STYLE4">商贸通移动版服务器端</span></div></th>
   </tr>
   <tr>
     <td width="50%" height="30" valign="top">
	 <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="20%" height="35" background="img/bj35.png"><div align="center"><a href="vale.asp">积分管理</a></div></td>
    <td width="20%" height="35" background="img/bj35.png">&nbsp;</td>
    <td width="20%" height="35" background="img/bj35.png">&nbsp;</td>
    <td width="20%" height="35" background="img/bj35.png">&nbsp;</td>
    <td width="20%" height="35" background="img/bj35.png">&nbsp;</td>
  </tr>
</table>
</td>
     <td width="50%" height="35" rowspan="2">
<form id="form1" name="form1" method="post" action="web.asp?ac=c">
<table width="100%"  height="30" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td height="35" colspan="2" background="img/bj35.png">供应商对货单：</td>
    </tr>
  <tr>
    <td width="90%" height="50">
      <label>
        <input name="key" type="text" id="key" style=" width:100%;height:30px;" autofocus="autofocus" align="right" autocomplete="off"/>
      </label></td>
		<td width="5%">
	  <INPUT type=image height="30" width="30" src="img/BUSCA.png" border=0 name="Submit" onClick="this.form.submit()" autocomplete="off" /></td>
  </tr>
  <tr>
    <td height="20">&nbsp;</td>
    <td height="20">&nbsp;</td>
  </tr>
</table>
</form>

</form>
<% 

if request.QueryString("ac")="c" and request.Form("key")<>"" then
sql = "select * from albaranproveedor,proveedor where albaranproveedor.DocumentoNo = '"& request.Form("key") &"' and albaranproveedor.bloqueado<>1 and albaranproveedor.empresaid=proveedor.empresaid  order by albaranproveedor.DocumentoNo desc"
end if
if request.Form("key")="" then
sql =  "select * from albaranproveedor,proveedor where albaranproveedor.bloqueado<>1 and albaranproveedor.empresaid=proveedor.empresaid order by albaranproveedor.DocumentoNo desc "
end if
conn.open Str
set rs = conn.execute(sql)
 %>
 <table width="90%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td  height="30" bgcolor="#cccccc"><div align="center">编号<br /><span class="STYLE14">CODIGO BARRA</span></div></td>
    <td bgcolor="#cccccc"><div align="center">供货商<br />
        <span class="STYLE14">Proveedor</span></div></td>
    <td  height="30" bgcolor="#cccccc"><div align="center">总价<br />
      <span class="STYLE14">TOTAL</span></div></td>
	<td width="50"  height="30" bgcolor="#cccccc"><div align="center">操作<br /><span class="STYLE14">OBRA</span></div></td>
   </tr>
 
<%
       while not rs.eof
   %>
  
  <tr>
    <td height="35"  background="img/bj35.png"><div align="center"><%= rs("DocumentoNo") %></div></td>
    <td height="35"  background="img/bj35.png"><div align="center"><%= rs("nombrecn")&rs("nombrees") %></div></td>
    <td height="35"  background="img/bj35.png"><div align="center"><%= formatnumber(rs("Total"),2,-1,-1,0) %></div></td>
	<td width="50"  height="35" background="img/bj35.png"><div align="center"><span class="STYLE1"></span><a href="alpweb.asp?ac=check&DocumentoNo=<%= rs("DocumentoNo") %>&proveedor=<%= rs("nombrecn")&rs("nombrees") %>" target="_blank"/><img src="img/dz.png" width="20" height="20" /></div>	  </td>
   </tr>
  
<% 
  rs.movenext
  wend
  rs.close
  conn.close
  set rs=nothing 

%>
</table>	 </td>
   </tr>
   <tr>
     <td valign="top">
	 
	 <h1>PDA服务器运行中....<br />
  服务器IP:<span class="STYLE1"><%=Request.ServerVariables("LOCAL_ADDR")%></span><br/>
  服务器端口:<span class="STYLE1"><%=Request.ServerVariables("SERVER_PORT")%></span></h1>


<p>
	 </td>
   </tr>
   <tr>
     <td width="50%">&nbsp;</td>
     <td width="50%">&nbsp;</td>
   </tr>
</table>
</body>


</html>
