?? chukutongzhi.asp
字號:
<%@language=vbscript%>
<%
response.buffer=true
Response.Expires = 0
Response.CacheControl = "Private"
%>
<!-- #include file=../data/username.inc-->
<!-- #include file=../data/connect.asp-->
<!--#include file=../data/myPrg.asp-->
<%
newcompanyid = request("companyid")
if newcompanyid = "" then
call closedatabase
Response.Write "<script language=javascript>"
Response.Write "alert(""請先選擇公司再做此步操作！"");"
Response.write "history.go(-1);"
Response.Write "</script>"
Response.End
elseif not isnumeric(newcompanyid) then
call closedatabase
Response.Write "<script language=javascript>"
Response.Write "alert(""companyid必須為整數！"");history.go(-1);"
Response.Write "</script>"
Response.End
else
newcompanyid = cint(newcompanyid)
end if
%>
<%'On Error Resume Next%>
<%const title="庫存報告"%>
<html>
<head>
<title><%=title%></title>
<meta http-equiv="Content-Type"content="text/html; charset=gb_2312-80">
<link rel=stylesheet type=text/css href=../data/forum.css>
</head>
<body topmargin="0">
<div align=center><font size=4>出庫通知書</font></div><br>
<%
outward_id = trim(request("id"))
if outward_id = "" then
call closedatabase
Response.End
elseif not isnumeric(outward_id) then
call closedatabase
Response.Write "<script language=javascript>"
Response.Write "alert(""id必須為整數！"");history.go(-1);"
Response.Write "</script>"
Response.End
else
outward_id = clng(outward_id)
end if
sql = "select * from outward where outw_id = "&outward_id&" and outw_companyid = "&newcompanyid&""
set rs_tongzhi = server.CreateObject("adodb.recordset")
rs_tongzhi.Open sql,conn,3,2
if not rs_tongzhi.eof then
outw_sra = rs_tongzhi("outw_sra")
dc_id = rs_tongzhi("outw_dc_id")
sql = "select dc_code,dc_name from dc where dc_id = "&dc_id&""
set rs_dc = conn.execute(sql)
if not rs_dc.eof then
dc_code = rs_dc("dc_code")
dc_name = rs_dc("dc_name")
end if
rs_dc.close
set rs_dc = nothing
%>
<div align="center">
<p align="left">致RDC/EDC： <%Response.Write "<font size=3><b>"&dc_name&"</b></font>"%> 日期：<%Response.Write date()%> </p>
<table width=100% align=center border='1' cellspacing='0' bordercolordark='#000000' bordercolorlight='#DADBFC' bordercolor='#000000'>
<tr>
<td rowspan="2" width="32">
<div align="center">No.</div>
</td>
<td rowspan="2" width="88">
<div align="center">Stock Release Advice NO</div>
</td>
<td colspan="4">
<div align="center">貨品信息</div>
</td>
<td colspan="4">
<div align="center">收貨人信息</div>
</td>
<td colspan="2">
<div align="center">發運信息</div>
</td>
<td rowspan="2" width="85">
<div align="center">備注</div>
</td>
</tr>
<tr>
<td width="57">
<div align="center">型號</div>
</td>
<td width="57">
<div align="center">顏色</div>
</td>
<td width="58">
<div align="center">數量</div>
</td>
<td width="65">
<div align="center">商品號</div>
</td>
<td width="68">
<div align="center">收貨人</div>
</td>
<td width="73">
<div align="center">聯系電話</div>
</td>
<td width="67">
<div align="center">派送地址</div>
</td>
<td width="71">
<div align="center">身份證號</div>
</td>
<td width="67">
<div align="center">運輸方式</div>
</td>
<td width="79">
<div align="center">要求到達時間</div>
</td>
</tr>
<%
i = 0
sql = "select * from outward_detail left outer join detail_info on detail_info.info_detail_id = outward_detail.detail_id where outward_detail.detail_outw_id = "&outward_id&""
'Response.Write sql
'Response.End
set rs_det = server.CreateObject("adodb.recordset")
rs_det.Open sql,conn,1,1
do while not rs_det.EOF
prod_id = rs_det("detail_prod_id")
detail_no = rs_det("detail_no")
info_type = rs_det("info_type")
info_yuji_time = rs_det("info_yuji_time")
guest_id = rs_det("detail_guest_id")
sql = "select prod_type,prod_color,prod_no from product where prod_id = "&prod_id&""
set rs_prod = conn.execute(sql)
if not rs_prod.eof then
prod_type = rs_prod("prod_type")
prod_color = rs_prod("prod_color")
prod_no = rs_prod("prod_no")
end if
rs_prod.close
set rs_prod = nothing
i = i + 1
%>
<tr>
<td width="30">
<div align="center"><%=i%></div>
</td>
<td width="83">
<div align="center"><%Response.Write outw_sra%></div>
</td>
<td width="48">
<div align="center"><%Response.Write prod_type%></div>
</td>
<td width="48">
<div align="center"><%Response.Write prod_color%></div>
</td>
<td width="49">
<div align="center"><%Response.Write detail_no%></div>
</td>
<td width="55">
<div align="center"><%Response.Write prod_no%></div>
</td>
<%
sql = "select guest_user,guest_tel,guest_address,guest_idcard,guest_id from guest where guest_id = "&guest_id&""
set rs_comp = conn.execute(sql)
if not rs_comp.eof then
guest_user = trim(rs_comp("guest_user"))
guest_tel = trim(rs_comp("guest_tel"))
guest_address = trim(rs_comp("guest_address"))
guest_idcard = trim(rs_comp("guest_idcard"))
end if
rs_comp.close
set rs_comp = nothing
%>
<td width="65">
<div align="center">
<%
if guest_user <> "" then
Response.Write guest_user
else
Response.Write " "
end if
%></div>
</td>
<td width="67">
<div align="center">
<%
if guest_tel <> "" then
Response.Write guest_tel
else
Response.Write " "
end if
%></div>
</td>
<td width="64">
<div align="center">
<%
if guest_address <> "" then
Response.Write guest_address
else
Response.Write " "
end if
%></div>
</td>
<td width="154">
<div align="center">
<%
if guest_idcard <> "" then
Response.Write guest_idcard
else
Response.Write " "
end if
%></div>
</td>
<td width="42">
<div align="center"><%Response.Write info_type&" "%></div>
</td>
<td width="60">
<div align="center"><%Response.Write info_yuji_time&" "%></div>
</td>
<%
if i = 1 then
%> <td rowspan="<%=rs_det.recordcount%>">
<div align="center"> </div>
</td>
<%
end if
%>
</tr>
<%
rs_det.MoveNext
loop
end if
rs_det.Close
set rs_det = nothing
rs_tongzhi.Close
set rs_tongzhi = nothing
%>
<tr>
<td width="24"><div align="center">總計</div></td>
<td width="97"> </td>
<td> </td>
<td> </td>
<td width="25"> </td>
<td width="49"> </td>
<td> </td>
<td> </td>
<td> </td>
<td width="38"> </td>
<td width="97"> </td>
<td width="35"> </td>
<td width="52"> </td>
</tr>
</table>
<%
call closedatabase
%>
<p align="left"> </p>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -