📄 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 + -