?? baobiao_in_view.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-->
<!-- #include file=../data/flag.inc-->
<%
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>
<link rel=stylesheet type=text/css href=../data/forum.css>
</head>
<%
start_year = Request.Form("start_year")
start_month = Request.Form("start_month")
start_day = Request.Form("start_day")
end_year = Request.Form("end_year")
end_month = Request.Form("end_month")
end_day = Request.Form("end_day")
start_date = start_year&"-"&start_month&"-"&start_day
end_date = end_year&"-"&end_month&"-"&end_day
smallinput = request("dc_id")
if smallinput = "" then
smallinput = 0
else
smallinput = replace(smallinput,"'","’")
end if
biglocation = request("biglocation")
if biglocation = "" then
biglocation = 0
else
biglocation = replace(biglocation,"'","’")
end if
sia = trim(request("sia"))
sia = replace(sia,"'","’")
oddsia = request("oddsia")
smalllocation = request("smalllocation")
if smalllocation = "" then
smalllocation = 0
else
smalllocation = replace(smalllocation,"'","’")
end if
prod_type2 = trim(request("prod_type"))
prod_type2 = replace(prod_type2,"'","’")
prod_danwei = trim(request("prod_danwei"))
prod_danwei = replace(prod_danwei,"'","’")
inwa_stat = trim(request("inwa_stat"))
inwa_stat = replace(inwa_stat,"'","’")
%>
<body topmargin="0">
<%
Showtitle(title)
%>
<form name="form1" method="post" action="baobiao_in_view_print.asp" target=_blank>
<div align="center">
<table width=100% align=center border='1' cellspacing='0' bordercolordark='#000000' bordercolorlight='#DADBFC' bordercolor='#000000'>
<tr>
<td width="24" rowspan="2"><div align="center">No.</div></td>
<td width="42" rowspan="2"><div align="center">
<p>進倉編號SIA</p></div>
</td>
<td height="30" colspan="10"><div align="center">貨物信息</div></td>
<td height="30" colspan="3"><div align="center">運輸信息</div></td>
<td colspan="2"><div align="center">時間信息</div></td>
<td width="60" rowspan="2" colspan="2"><div align="center">備注</div></td>
</tr>
<tr>
<td width="33" height="50"><div align="center">貨<br>
名</div></td>
<td width="23" height="50"><div align="center">單<br>
位</div></td>
<td width="17" height="50"><div align="center">重<br>
量</div></td>
<td width="33" height="50"><div align="center">尺<br>碼</div></td>
<td width="19" height="50"><div align="center">數<br>
量</div></td>
<td width="25" height="50"><div align="center">物品號</div></td>
<td width="36" height="50"><div align="center">上下車金額元</div></td>
<td width="32" height="50"><div align="center">管理員</div></td>
<td width="25" height="50"><div align="center">貨物情況</div></td>
<td width="53" height="50"><div align="center">庫位</div></td>
<td width="45" height="50"><div align="center">送貨地區</div></td>
<td width="48" height="50"><div align="center">送貨車牌（拆箱箱號）</div></td>
<td width="50" height="50"><div align="center">裝箱箱號（提貨車號）</div></td>
<td width="53" height="50"><div align="center">入庫日期</div></td>
<td width="50" height="50"><div align="center">出庫日期</div></td>
</tr>
<%
sql = "select * from inward,dc,inward_detail,product "
sql = sql + " where inward.inwa_dc_id = dc.dc_id "
sql = sql + "and inward.inwa_id = inward_detail.idetail_inwa_id "
sql = sql + "and inward_detail.idetail_prod_id = product.prod_id "
sql = sql + " and inward.inwa_companyid = "&newcompanyid&" and inward.inwa_date >= #"&start_date&"# and inward.inwa_date <= #"&end_date&"# "
if smallinput <> 0 then
sql = sql + " and inward.inwa_dc_id = "&smallinput&" "
else
if flag > 3 then
sql = sql + " and inward.inwa_dc_id in ("&dcservice&") "
end if
end if
if biglocation <> 0 and smalllocation = 0 then
sql = sql + " and product.prod_flag = "&biglocation&" "
end if
if clng(oddsia) = 1 then
if smalllocation <> 0 then
sql = sql + " and inward_detail.idetail_prod_id = "&smalllocation&" "
end if
elseif clng(oddsia) = 2 then
if prod_type2 <> "" then
sql = sql + " and product.prod_type = '"&prod_type2&"' "
end if
if prod_danwei <> "" then
sql = sql + " and product.prod_danwei = '"&prod_danwei&"' "
end if
end if
if sia <> "" then
sql = sql + " and inward.inwa_sia like '%"&sia&"%' "
end if
sql = sql + " order by inward.inwa_id asc"
'Response.Write sql
'Response.End
set rs_tongzhi = server.CreateObject("adodb.recordset")
rs_tongzhi.Open sql,conn,1,2
if not rs_tongzhi.eof then
i = 1
do while not rs_tongzhi.eof
%>
<tr>
<td width="24"><%=i%></td>
<td width="42">
<div align="center"><a href="#" onclick="javascript:window.open('ruku_record_info.asp?id=<%=rs_tongzhi("inwa_id")%>&companyid=<%=newcompanyid%>','hamier899e','height=500,width=500,scrollbars')"><font color=navy><%Response.Write rs_tongzhi("inwa_sia")%></font></a></div>
</td>
<td><%response.write rs_tongzhi("prod_pinming")%></td>
<td><%response.write rs_tongzhi("prod_danwei")%></td>
<td><%
prod_danweiwe = trim(rs_tongzhi("prod_weight"))
if prod_danweiwe = "" then
response.write " "
else
response.write prod_danweiwe
end if
inwa_dc_id = rs_tongzhi("inwa_dc_id")
%></td>
<td><%response.write rs_tongzhi("prod_tiji")%></td>
<td width="19"><div align="center"><%response.write rs_tongzhi("idetail_no")%></div></td>
<td width="25"><div align="center"><%response.write rs_tongzhi("prod_no")%></div></td>
<td><div align="center"><%response.write rs_tongzhi("prod_danjia")%></div></td>
<td><%response.write rs_tongzhi("inwa_contact")%></td>
<td width="25"><div align="center">
<%response.write rs_tongzhi("inwa_stat")%>
</div></td>
<%
sql = "select * from dc where dc_id = "&inwa_dc_id&""
'Response.Write sql
'Response.End
set rs_dc = conn.execute(sql)
if not rs_dc.eof then
dc_name = rs_dc("dc_name")
end if
rs_dc.close
set rs_dc = nothing
%>
<td width="53"><div align="center">
<%response.write dc_name %>
</div></td>
<td width="45"><div align="center">
<%response.write rs_tongzhi("inwa_sendto")%>
</div></td>
<td width="48"><div align="center">
<%response.write rs_tongzhi("inwa_sendno")%>
</div></td>
<td width="50"><div align="center">
<%response.write rs_tongzhi("inwa_getno")%>
</div></td>
<td width="53">
<%response.write rs_tongzhi("inwa_fact_date")%>
</td>
<td width="50">
<%response.write rs_tongzhi("inwa_outdate")%>
</td>
<td width="60"><div align="center">
<%response.write rs_tongzhi("inwa_ser_beizu")%>
</div></td>
<td width="23" align="center"><input type="checkbox" name="<%=i%>" value="<%=rs_tongzhi("idetail_id")%>" checked></td>
</tr>
<%
i = i + 1
rs_tongzhi.movenext
loop
end if
%>
<tr>
<td width="24"><div align="center">總計</div></td>
<td width="42"> </td>
<td> </td>
<td> </td>
<td width="17"> </td>
<td width="33"> </td>
<td> </td>
<td> </td>
<td> </td>
<td width="32"> </td>
<td width="25"> </td>
<td width="53"> </td>
<td width="45"> </td>
<td width="48"> </td>
<td width="50"> </td>
<td width="53"> </td>
<td width="50"> </td>
<td width="60"> </td>
<td> </td>
</tr>
</table>
<input type="hidden" name="no" value="<%=rs_tongzhi.recordcount%>">
<input type="hidden" name="companyid" value="<%=newcompanyid%>">
<%
if rs_tongzhi.recordcount > 0 then
%>
<input class=buttonface type="submit" name="ok" value="打印選擇項">
<input class=buttonface type="reset" name="ok" value="重設">
<%
end if
rs_tongzhi.Close
set rs_tongzhi = nothing
call closedatabase
%>
<input class=buttonface type="button" name="ok" value="返回" onclick="javascript:history.go(-1)">
</form>
</div>
<!--#include file=../data/copyright.asp-->
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -