⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 aim.asp

📁 物流管理系统
💻 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">
<title><%=title%></title>
<%
if isempty(session("username")) then
	call closedatabase
	Response.Write "请重新登入!"
	Response.End 
end if 
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
%>
<link rel="stylesheet" type="text/css" href="../data/forum.css">
<script language=vbscript>
<!--
Sub datacheck()
 if isdate(trim(input1.outw_rec_date.value)) = false then
   msgbox "「到达日期」格式不对!", 64, "请输入正确的日期!"
     document.input1.outw_rec_date.focus()
     Exit Sub
  End if  
  
if trim(input1.outw_rec_time.value)=empty then
   msgbox "「到达时间」不得为空白!", 64, "请输入签收时间!"
     document.input1.outw_rec_time.focus()
     Exit Sub
  End if
if isdate(trim(input1.outw_rec_time.value))=false then
   msgbox "「到达时间」格式不对!", 64, "请输入正确的签收时间!"
     document.input1.outw_rec_time.focus()
     Exit Sub
  End if
  if trim(input1.status_now_address.value)=empty then
   msgbox "「目前地点」不得为空白!", 64, "请输入目前地点!"
     document.input1.status_now_address.focus()
     Exit Sub
  End if 
 if trim(input1.status_rec_man.value)=empty then
   msgbox "「填写人」不得为空白!", 64, "请输入填写人!"
     document.input1.status_rec_man.focus()
     Exit Sub
  End if
input1.Submit
End Sub
-->
</script>
</head>
<body topmargin="0"  onload="javascript:self.moveTo(0,0);document.input1.stock_flag.focus();">
<%
arra = split(session("username"),";")
UserCompanyid = arra(0)
flag = arra(1)
User = arra(2)
userno = arra(4)
elink_id = request("id")
if not isnumeric(elink_id) then
	call closedatabase
	Response.Write "<script language=javascript>"
	Response.Write "alert(""id必须为整数!"");history.go(-1);"
	Response.Write "</script>"
	Response.End
end if

if Request.ServerVariables("REQUEST_METHOD")="POST" then
	stock_flag = request("stock_flag")
	if not isnumeric(stock_flag) then
		call closedatabase
		Response.Write "<script language=javascript>"
		Response.Write "alert(""stock_flag必须为整数!"");history.go(-1);"
		Response.Write "</script>"
		Response.End
	end if

	sql = "select elink_outw_id,elink_flag from outward_elink where elink_id = "&elink_id&""
	set rs_out = conn.execute(sql)
	if not rs_out.EOF then
		outw_id = rs_out("elink_outw_id")
		elink_flag = rs_out("elink_flag")
		if elink_flag <> 1 then '该易联单号未签收
				if stock_flag <> 7 then '该单子未签收的时候可以录入相关的未签收信息
					status_now_address = replace(trim(request("status_now_address")),"'","’")
					outw_eta = replace(trim(request("outw_eta")),"'","’")
					status_rec_man = replace(trim(request("status_rec_man")),"'","’")
					outw_beizu = replace(trim(request("outw_beizu")),"'","’")
					outw_rec_date = trim(request("outw_rec_date"))
					outw_rec_date = replace(outw_rec_date,":",":")
					outw_rec_time = trim(request("outw_rec_time"))
					outw_rec_time = replace(outw_rec_time,":",":")
					outw_datetime = outw_rec_date& " "&outw_rec_time
					rs_out.close
					set rs_out = nothing
					if isdate(outw_datetime) = false then
						call closedatabase
						Response.Write "<br><center>到达日期或到达时间格式不对!请重试<br>"
						Response.Write "<a href = ""javascript:history.go(-1)"">后退</a></center>"
						Response.End 
					end if
					if status_now_address = "" then status_now_address = " "
					if outw_eta = "" then outw_eta = " "
					if status_rec_man = "" then status_rec_man = " "
					if outw_beizu = "" then
						if  stock_flag = 2 then
							outw_beizu = "到目的港"
						elseif  stock_flag = 3 then
							outw_beizu = "已派车派送"
						elseif  stock_flag = 4 then
							outw_beizu = "车辆/公路事故"
						elseif  stock_flag=5 then
							outw_beizu = "客人已下班"
						elseif  stock_flag=6 then
							outw_beizu = "客人要求该日派送"
						else
							outw_beizu = "notice"
						end if
					end if
					sql = "insert into outward_status(status_outw_id,status_elink_id,status_beizu,status_rec_man,status_man,status_datetime,status_companyid,status_add_datetime,status_flag,outw_eta,status_now_address) values("&outw_id&","&elink_id&",'"&outw_beizu&"','"&status_rec_man&"','"&User&"','"&outw_datetime&"',"&newcompanyid&",'"&now()&"',"&stock_flag&",'"&outw_eta&"','"&status_now_address&"')"
					conn.execute(sql)
					call closedatabase
					Response.Write "<script language=javascript>"
					Response.Write "window.close();"
					Response.Write "</script>"
					Response.End 
				end if 'if stock_flag <> 7 then ...
		else
			'该易联单号已经签收
			rs_out.close
			set rs_out = nothing
			call closedatabase
			Response.Write "<script language=javascript>"
			Response.Write "alert(""该单子已经签收,请确认!"");opener.location.reload();window.close();"
			Response.Write "</script>"
			Response.End		
		end if
	else
		rs_out.close
		set rs_out = nothing
		call closedatabase
		Response.Write "<script language=javascript>"
		Response.Write "alert(""该易联单号不存在,可能已经被他人删除,请确认!"");opener.location.reload();window.close();"
		Response.Write "</script>"
		Response.End 
	end if


else '不是未提交的情况
	ref = request("ref")
	sql = "select elink_id,elink_odd,transport_no,elink_dc_id,elink_guest_id,elink_dir_flag from outward_elink where elink_id = "&elink_id&""
	set rs_e = conn.execute(sql)
	if not rs_e.eof then
		elink_odd = rs_e("elink_odd")
		guest_id = rs_e("elink_guest_id")
		dir_flag = rs_e("elink_dir_flag")
		transport_no = rs_e("transport_no")
	
%>
	<form action="aim.asp" method="POST" name="input1">	
<table align=center width=100%  cellspacing='0' cellpadding='0' bordercolorlight='#000000'bordercolordark='#FFFFFF'bgcolor='#DADBFC' border="1">
<tr>
 <td colspan=4 align=center bgcolor=red><b><font color=yellow>在途货物信息填写</font></b></td>
</tr>
<tr>
    <td width="10%">系统编号:</td>
    <td colspan="3" width="90%">
   <%response.write elink_id%></td>
 </tr>
<tr>
    <td width="10%">易联单号:</td>
    <td colspan="3" width="90%">
   <%response.write elink_odd%></td>
 </tr>
   <%
	
	Response.Write "<tr bgcolor=green>"
    Response.Write "<td width=""10%""><b><font color=white> 客户信息:</font></b></td>"
    Response.Write "<td width=""60%"">"
    Response.Write "<b><font color=white> 产品</font></b></td>"
    Response.Write "<td width=""30%"">"
    Response.Write "<b><font colspan=""2"" color=white>&nbsp;数量</font></b></td>"
    Response.Write "</tr>"
	sql = "select * from outward_detail where detail_elink_id = "&elink_id&" and detail_guest_id = "&guest_id&" order by detail_id asc"
	set rs_xx = conn.execute(sql)
	do while not rs_xx.eof 
 
		prod_id = rs_xx("detail_prod_id")
		detail_no = rs_xx("detail_no")
				
		sql = "select * from product where prod_companyid = "&newcompanyid&" and prod_id = "&prod_id&""
		set rs_prod = conn.execute(sql)
		if not rs_prod.eof then
			prod_no = rs_prod("prod_no")
			prod_type = rs_prod("prod_type")
			prod_color = rs_prod("prod_color")
			prod_pinming = rs_prod("prod_pinming")
			prod_weight = rs_prod("prod_weight")
			prod_volume = rs_prod("prod_volume")
			Response.Write "<tr>"
			Response.Write "<td width=""15%"">&nbsp;</td>"
			Response.Write "<td width=""50%"">"
			response.write prod_no &" " & prod_type &" " & prod_color &" " & prod_pinming &" " & prod_weight &" " & prod_volume
			Response.Write "</td>"
			Response.Write "<td colspan=2 width=""40%"">"
			response.write "&nbsp;"&detail_no 
			Response.Write "</td>"
			Response.Write "</td>"		
			Response.Write "</tr>"
	    end if
		rs_prod.close
		set rs_prod = nothing
	rs_xx.movenext
	loop
	rs_xx.close
	set rs_xx = nothing

 	 	sql = "select * from guest where guest_id = "&guest_id&""
		set rs_guest = conn.execute(sql)
		if not rs_guest.eof then
			guest_user = rs_guest("guest_user")
			guest_address = rs_guest("guest_address")
			guest_tel = rs_guest("guest_tel")
			guest_fax = rs_guest("guest_fax")
		end if
		rs_guest.close
		set rs_guest = nothing
		Response.Write "<tr>"
		Response.Write "<td width=""15%""> 客户地址:</td>"
		Response.Write "<td  colspan=""3"" width=""85%"">"
		Response.Write ""& guest_user &" " & guest_address &" " &guest_tel & " " &guest_fax&"</td>"
		Response.Write "</tr>"
		Response.Write "<tr>"
		Response.Write "<td width=""15%""> 分拣件数:</td>"
		Response.Write "<td  colspan=""3"" width=""85%"">"
		if transport_no <> 0 then
			Response.Write transport_no &"&nbsp;</td>"
		else
			Response.Write "&nbsp;</td>"
		end if
		Response.Write "</tr>"

			Response.Write "<tr>"
			Response.Write "<td width=""15%""> 货物状态:</td>"
			Response.Write "<td  colspan=""3"" width=""85%"">"
			
			Response.Write "<select  onchange=""change()""  style=""font-size:9pt;width=100;BORDER-TOP-WIDTH: 1px;BORDER-BOTTOM-WIDTH: 2px;BORDER-LEFT-WIDTH: 1px;BORDER-RIGHT-WIDTH: 2px""  name='stock_flag' size='1' onkeydown=""javascript:if(event.keyCode==13)event.keyCode=9"">"
			if ref = 2 then
				Response.Write "<option value=""2"">到目的港</option>"
			elseif ref = 3 then
	            Response.Write "<option value=""3"">已派车派送</option>"
	        elseif ref = 4 then
		        Response.Write "<option value=""4"">车辆/公路事故</option>"
		    elseif ref = 5 then
		        Response.Write "<option value=""5"">客人已下班</option>"
		    else 
		        Response.Write "<option value=""6"">客人要求该日派送</option>"
		    end if
			Response.Write "</select>"
			Response.Write "</td>"
			Response.Write "</tr>"
			Response.Write "<tr>"
			Response.Write "<td width=""15%""> 到达日期:</td>"
			Response.Write "<td  colspan=""3"" width=""85%"">"
			Response.Write "<input  style=""font-size:9pt;width=200;BORDER-TOP-WIDTH: 1px;BORDER-BOTTOM-WIDTH: 2px;BORDER-LEFT-WIDTH: 1px;BORDER-RIGHT-WIDTH: 2px"" type=textbox name=""outw_rec_date"" value='' maxlength=""30"" onkeydown=""javascript:if(event.keyCode==13)event.keyCode=9"">**(如:2001-11-23)"
			Response.Write "</td>"
			Response.Write "</tr>"
			Response.Write "<tr>"
			Response.Write "<td width=""15%""> 到达时间:</td>"
			Response.Write "<td  colspan=""3"" width=""85%"">"
			Response.Write "<input  style=""font-size:9pt;width=200;BORDER-TOP-WIDTH: 1px;BORDER-BOTTOM-WIDTH: 2px;BORDER-LEFT-WIDTH: 1px;BORDER-RIGHT-WIDTH: 2px"" type=textbox name=""outw_rec_time"" value='' maxlength=""30"" onkeydown=""javascript:if(event.keyCode==13)event.keyCode=9"">**(如:17:00)"
			Response.Write "</td>"
			Response.Write "</tr>"
			Response.Write "<tr>"
			Response.Write "<td width=""15%""> 目前地点:</td>"
			Response.Write "<td  colspan=""3"" width=""85%"">"
			Response.Write "<input  style=""font-size:9pt;width=200;BORDER-TOP-WIDTH: 1px;BORDER-BOTTOM-WIDTH: 2px;BORDER-LEFT-WIDTH: 1px;BORDER-RIGHT-WIDTH: 2px"" type=textbox name=""status_now_address"" value='' maxlength=""30"" onkeydown=""javascript:if(event.keyCode==13)event.keyCode=9"">**"
			Response.Write "</td>"
			Response.Write "</tr>"
			Response.Write "<tr>"
			Response.Write "<td width=""15%""> 预计到达时间:</td>"
			Response.Write "<td  colspan=""3"" width=""85%"">"
			Response.Write "<input  style=""font-size:9pt;width=200;BORDER-TOP-WIDTH: 1px;BORDER-BOTTOM-WIDTH: 2px;BORDER-LEFT-WIDTH: 1px;BORDER-RIGHT-WIDTH: 2px"" type=textbox name=""outw_eta"" value='' maxlength=""30"" onkeydown=""javascript:if(event.keyCode==13)event.keyCode=9"">"
			Response.Write "</td>"
			Response.Write "</tr>"
			Response.Write "<tr>"
			Response.Write "<td width=""15%""> 填写人:</td>"
			Response.Write "<td  colspan=""3"" width=""85%"">"
			Response.Write "<input  style=""font-size:9pt;width=200;BORDER-TOP-WIDTH: 1px;BORDER-BOTTOM-WIDTH: 2px;BORDER-LEFT-WIDTH: 1px;BORDER-RIGHT-WIDTH: 2px"" type=textbox name=""status_rec_man"" value=''  maxlength=10 onkeydown=""javascript:if(event.keyCode==13)event.keyCode=9"">**"
			Response.Write "</td>"
			Response.Write "</tr>"
			Response.Write "<tr>"
			Response.Write "<td width=""15%""> 备注:</td>"
			Response.Write "<td  colspan=""3"" width=""85%"">"
			Response.Write "<input  style=""font-size:9pt;width=200;BORDER-TOP-WIDTH: 1px;BORDER-BOTTOM-WIDTH: 2px;BORDER-LEFT-WIDTH: 1px;BORDER-RIGHT-WIDTH: 2px"" type=textbox name=""outw_beizu"" value=''  maxlength=25 onkeydown=""javascript:if(event.keyCode==13)event.keyCode=9"">"
			Response.Write "</td>"
			Response.Write "</tr>"
			%>
 <input type=hidden name=dir_flag value=<%=dir_flag%>>
  <input type=hidden name=id value=<%=elink_id%>>
  <input type=hidden name=companyid value=<%=newcompanyid%>>
<tr bgcolor=white>
   <td colspan="4"><br><br>
   <center>
   <input class=buttonface type=button  onclick="datacheck()" name=ok value=延误信息提交> 
	</center>
	<br><br>
 </tr>
</table>
<form>
 <%
 else
	Response.Write "<center>该单子可能已经被删除!!!</center>"
 end if
 %>
<br> <p align=center><font size=+3 color=blue><a href='#' onclick="javascript:window.close()">[关闭]</a></font></p> 
<br>
<%
rs_e.close
set rs_e = nothing
call closedatabase
end if 'if is(post) then ... else ...end if
%>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -