<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>出貨資料頁面</title>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
</head>

<body>
<table width="80%" border="0" align="left" cellpadding="0" cellspacing="1">
  <tr> 
    <td height="30" colspan="6" bgcolor="#CEFFCE"><font color="#006600" size="4"><strong>水果出貨管理</strong></font></td>
  </tr>
  <tr> 
    <td width="10%" height="25"><font size="3">訂單編號</font></td>
    <td width="10%" height="25"><font size="3">訂購人編號</font></td>
    <td width="10%" height="25"><font size="3">訂購人姓名</font></td>
    <td width="10%" height="25"><font size="3">下單日期</font></td>
    <td width="10%" height="25"><font size="3">連絡電話</font></td>
    <td width="10%" height="25"><font size="3">出貨地址</font></td>
  </tr>
<%
		set DBC = Server.CreateObject("ADODB.Connection") 
		CnString ="Provider=SQLOLEDB.1;Server=203.95.191.21;Database=fruit_hv;UID=sa;PWD="
        DBC.Open  CnString
		query = "SELECT member.mid,m_name,phone,order_num,order_date,pro_address FROM member join orders on member.mid=orders.mid"
	 	Set rs = DBC.Execute(query)
	 	while not rs.EOF
%>
<%
'		set conn = Server.CreateObject("ADODB.Connection") 
'		conn.Open "hv"	
'	 	query = "SELECT member.mid,m_name,phone,order_num,order_date,pro_address FROM member join orders on member.mid=orders.mid"
'	 	Set rs = conn.Execute(query)
'	 	while not rs.EOF
%>
  <tr> 
    <td width="10%" height="25" bgcolor="#CEFFCE"><font size="3"><%=rs("order_num")%></font></td>
    <td width="10%" height="25" bgcolor="#CEFFCE"><font size="3"><%=rs("mid")%></font></td>
    <td width="10%" height="25" bgcolor="#CEFFCE"><font size="3"><%=rs("m_name")%></font></td>
    <td width="10%" height="25" bgcolor="#CEFFCE"><font size="3"><%=rs("order_date")%></font></td>
    <td width="10%" height="25" bgcolor="#CEFFCE"><font size="3"><%=rs("phone")%></font></td>
    <td width="10%" height="25" bgcolor="#CEFFCE"><font size="3"><%=rs("pro_address")%></font></td>
      </tr>
  <%
		rs.MoveNext
		wend
%>
</table>
<div align="center"></div>
</body>
</html>
