?? inward_2.asp
字號:
<%@ LANGUAGE="VBScript"%>
<%
response.buffer=true
Response.Expires = 0
Response.CacheControl = "Private"
%>
<%const title="入庫操作"%>
<!-- #include file=../data/username.inc-->
<!-- #include file=../data/connect.asp-->
<!--#include file=../data/myPrg.asp-->
<html>
<head>
<meta http-equiv="Content-Type"content="text/html; charset=gb_2312-80">
<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0">
<title><%=title%></title>
<link rel=stylesheet type=text/css href=../data/forum.css>
<script language=vbscript>
<!--
Sub datacheck()
if trim(input1.smalllocation.value)=empty then
msgbox "「物品編號」必須選擇！", 64, "請選擇物品編號!"
document.input1.smalllocation.focus()
Exit Sub
End if
if input1.inwa_no.value=empty then
msgbox "「數量」不得為空白！", 64, "請輸入數量!"
document.input1.inwa_no.focus()
Exit Sub
End if
if not isNumeric(trim(input1.inwa_no.value)) then
msgbox "請檢查數量的正確性！（要為數字）！", 64, "請輸入數量!"
document.input1.inwa_no.focus()
Exit Sub
end if
if trim(input1.inwa_no.value) <= 0 then
msgbox "請檢查數量的正確性！（要為大于0）！", 64, "請輸入數量!"
document.input1.inwa_no.focus()
Exit Sub
End if
input1.Submit
End Sub
-->
</script>
<%
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
'id為INWARD表中的INWA_ID
'若想更改信息的顯示方式,換成數據庫的信息而不用COOKIES,則將對應的信息賦予相應的變量
id = request("id")
if not isnumeric(id) then
call closedatabase
Response.Write "<script language=javascript>"
Response.Write "alert(""id必須為整數！"");history.go(-1);"
Response.Write "</script>"
Response.End
end if
sql = "select prod_id,prod_no,prod_type,prod_danwei,prod_flag from product where prod_companyid = "&newcompanyid&" and prod_disabled = 0 and prod_dir_flag = 0 order by prod_no asc"
set rs10 = conn.execute(sql)
%>
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
count = 0
do while not rs10.eof
%>
subcat[<%=count%>] = new Array("<%response.write trim(rs10("prod_no"))&" " & rs10("prod_type") & " "&rs10("prod_danwei")%>","<%= trim(rs10("prod_flag"))%>","<%= trim(rs10("prod_id"))%>");
<%
count = count + 1
rs10.movenext
loop
rs10.close
set rs10=nothing
%>
onecount=<%=count%>;
function changelocation(locationid)
{
document.input1.smalllocation.length = 0;
var locationid=locationid;
var i;
document.input1.smalllocation.options[0] = new Option('========物品編號========','');
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.input1.smalllocation.options[document.input1.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script>
</head>
<body topmargin="0" onload="javascript:document.input1.dc_id.focus()">
<%
Showtitle(title)
arra = split(session("username"),";")
UserCompanyid = arra(0)
flag = arra(1)
User = arra(2)
userno = arra(4)
if flag = 4 then
FlagUser = session("flag")
'該錄入人員的客服的DC和PROD
dim dcservice,prodservice
dcservice = ""
prodservice = ""
dim dcFlag,prodFlag
dcFlag = false
prodFlag = false
for ver=0 to userno
if clng(newcompanyid) = clng(FlagUser(ver,9)) then
if instr(dcservice,FlagUser(ver,0)) < 1 then
if dcFlag = true then
dcservice = dcservice &","& FlagUser(ver,0)
else
dcservice = dcservice & FlagUser(ver,0)
dcFlag = true
end if
end if
if instr(prodservice,FlagUser(ver,1)) < 1 then
if prodFlag = true then
prodservice = prodservice &","& FlagUser(ver,1)
else
prodservice = prodservice & FlagUser(ver,1)
prodFlag = true
end if
end if
end if
next
elseif flag > 4 then
call closedatabase
Response.End
end if
dim inwa_dc_cookies,inwa_prod_cookies,inwa_inwa_rec_date_cookies,inwa_rec_time_cookies
dim inwa_rec_man_cookies,inwa_rec_idcard_cookies,inwa_beizu_cookies
dim inwa_date_cookies,inwa_sia_cookies,inwa_type_cookies
dim inwa_yuji_time_cookies,inwa_contact_cookies
inwa_dc_cookies = trim(Request.Cookies("inwa_dc_id"))
inwa_prod_cookies = trim(Request.Cookies("inwa_prod_id"))
inwa_date_cookies = trim(Request.Cookies("inwa_date"))
inwa_sia_cookies = trim(Request.Cookies("inwa_sia"))
inwa_type_cookies = trim(Request.Cookies("inwa_type"))
inwa_yuji_time_cookies = trim(Request.Cookies("inwa_yuji_time"))
inwa_contact_cookies = trim(Request.Cookies("inwa_contact"))
inwa_rec_date_cookies = trim(Request.Cookies("inwa_rec_date"))
inwa_rec_time_cookies = trim(Request.Cookies("inwa_rec_time"))
inwa_rec_man_cookies = trim(Request.Cookies("inwa_rec_man"))
inwa_rec_idcard_cookies = trim(Request.Cookies("inwa_rec_idcard"))
inwa_beizu_cookies = trim(Request.Cookies("inwa_beizu"))
inwa_flag_cookies = trim(Request.Cookies("inwa_flag"))
database = trim(request("database"))
'判斷是否是追加記錄
'如果DATABASE不為空,則須從數據庫中將對應的信息取出讓錄入員參考是否
'DATABASE的變量
'1 從SAVE_INWARD.ASP中得到(在"?"參數之后)
'2 從SAVE_INWARD_2.ASP中得到
if database <> "" then
sql = "select * from inward where inwa_id = "&id&""
set rs_inward = conn.execute(sql)
if not rs_inward.eof then
inwa_dc_cookies = trim(rs_inward("inwa_dc_id"))
sql = "select max(idetail_prod_id) as prod from inward_detail where idetail_inwa_id = "&id&""
set rs_max = conn.execute(sql)
if not rs_max.eof then
inwa_prod_cookies = rs_max("prod")
else
inward_prod_cookies = ""
end if
rs_max.close
set rs_max = nothing
inwa_date_cookies = trim(rs_inward("inwa_date"))
inwa_sia_cookies = trim(rs_inward("inwa_sia"))
inwa_type_cookies = trim(rs_inward("inwa_type"))
inwa_yuji_time_cookies = trim(rs_inward("inwa_yuji_time"))
inwa_contact_cookies = trim(rs_inward("inwa_contact"))
inwa_beizu_cookies = trim(rs_inward("inwa_ser_beizu"))
inwa_flag_cookies = trim(rs_inward("inwa_flag"))
rs_inward.close
set rs_inward = nothing
else
rs_inward.close
set rs_inward = nothing
call closedatabase
Response.Write "<script language=javascript>"
Response.Write "alert(""該記錄已經被刪除!"");"
Response.Write "</script>"
Response.End
end if
end if
%>
<form action="save_inward_2.asp" method="POST" name="input1">
<p align=center><font color=red>請在以下的表格中填入相關的數據</font>
<p>
<table align=center border=0>
<tr>
<td nowrap align=right><font color=blue>進倉編號SIA：</td>
<td>
<%
Response.Write inwa_sia_cookies
%>
</td>
</tr>
<%
direct = request("direct")
if direct <> "" then
inwa_take_address = Request.Cookies("take_address")
inwa_line_no = trim(Request.Cookies("line_no"))
if inwa_line_no = "" then inwa_line_no = " "
inwa_take_no = trim(Request.Cookies("take_no"))
if inwa_take_no = "" then inwa_take_no = " "
%>
<%end if%>
<tr>
<td nowrap align=right><font color=blue>進 倉 日 期：</td>
<td>
<%
Response.Write inwa_date_cookies
%>
</td>
</tr>
<tr>
<td nowrap align=right><font color=blue>倉 庫 信 息：</td>
<td>
<%
response.write " <select class='smallinput' name='dc_id' size='1' onkeydown=""javascript:if(event.keyCode==13)event.keyCode=9"">"
if flag = 4 then
sql="select dc_id,dc_code,dc_name from dc where dc_disabled = 0 and dc_companyid = "&newcompanyid&" and dc_id in ("&dcservice&") order by dc_code asc"
elseif flag < 4 then
sql = "select dc_id,dc_code,dc_name from dc where dc_disabled = 0 and dc_companyid = "&newcompanyid&" order by dc_code asc"
elseif flag > 4 then
call closedatabase
Response.End
end if
'Response.Write sql
set rs = server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
if not rs.eof then
rs.movefirst
do while not rs.eof
'if prod_id = rs("prod_id") then
' response.write "<option value='"+CStr(rs("prod_id"))+"' selected>"+rs("prod_no")+" "+rs("prod_type")+" "+rs("prod_danwei")+"</option>"+chr(13)+chr(10)
'else
if cstr(inwa_dc_cookies) = cstr(rs("dc_id")) then
response.write "<option value='"+CStr(rs("dc_id"))+"'>"+rs("dc_code")+" "+rs("dc_name")+" </option>"+chr(13)+chr(10)
end if
'end if
rs.movenext
loop
else
response.write "<option value='0'>沒有DC編號</option>"+chr(13)+chr(10)
end if
rs.close
set rs = nothing
response.write " </select>"
'response.write " ( 共 <font color=red>"&ntotal&"</font> 個 ) "
%>
</td>
</tr>
<tr>
<td nowrap align=right><font color=blue>貨 物 類 別：</td>
<td>
<select name="biglocation" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9" onChange="javascript:changelocation(document.input1.biglocation.options[document.input1.biglocation.selectedIndex].value)">
<%
if flag = 4 then
sql = "select id,type_name from prod_type where type_companyid = "&newcompanyid&" and id in ("&prodservice&") order by id asc"
elseif flag < 4 then
sql = "select id,type_name from prod_type where type_companyid = "&newcompanyid&" order by id asc"
else
call closedatabase
Response.Write "操作無效!"
Response.End
end if
'Response.Write sql
'Response.End
set rs10 = conn.Execute (sql)
do while not rs10.eof
if inwa_prod_cookies = cstr(rs10("id")) then
Response.Write "<option value='"&trim(rs10("id"))&"' selected >"&trim(rs10("type_name"))&"</option>"+chr(13)+chr(10)
else
Response.Write "<option value='"&trim(rs10("id"))&"'>"&trim(rs10("type_name"))&"</option>"+chr(13)+chr(10)
end if
rs10.movenext
loop
rs10.close
set rs10 = nothing
%>
</select>
</td>
</tr>
<tr>
<td nowrap align=right><font color=blue>貨 物 編 號：</td>
<td>
<select name="smalllocation" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<option selected value="">========貨物編號========</option>
</select>
</td>
</tr>
<tr>
<td nowrap align=right><font color=blue>數 量：</td>
<td><input class=smallInput type=textbox name="inwa_no" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9" value=''>**</td>
</tr>
<tr>
<td>
<td><br>
<input type=hidden name=direct value="<%=direct%>">
<input type=hidden name=database value="<%=database%>">
<input type=hidden name=id value="<%=id%>">
<input type=hidden name=companyid value="<%=newcompanyid%>">
<input class=buttonface type=button onclick="datacheck()" name=ok value=" 確 定 ">
</tr>
</table>
</form>
<%
%>
<!--#include file=../data/copyright.asp-->
<script LANGUAGE="javascript">
changelocation(document.input1.biglocation.options[document.input1.biglocation.selectedIndex].value);
</script>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -