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

📄 setomronpolist.asp

📁 1 除掉了 时间 限制 2 除掉了 人数 限制 改为 500人 原为5人 3 发现一点小缺陷 增加人员的时候没有判断 登陆名是否重复! 自己写吧~~~:) 4 又 是一点缺陷
💻 ASP
字号:
<SCRIPT language='javascript'>window.resizeTo(350,250);window.focus()</SCRIPT>
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
Dim objcheck
Set objcheck=Server.CreateObject("SmartSales.CheckFunction")
objcheck.CheckUserFunction "po","edit"
set objcheck=nothing

	set conn=server.CreateObject("adodb.connection")
	conn.open connstring

	
if  Request("Mod") = "save" then
	if  Request("Mod2") = "ready" then
			sql="update omronpolist set status='ready',printqty='"&request("strprintqty")&"' where SLIP号码= '"&request("SLIPno")&"' and 货号='"&request("productcode")&"'"
	elseif Request("Mod2") = "continue" then
			sql="update omronpolist set status=null  where SLIP号码= '"&request("SLIPno")&"' and 货号='"&request("productcode")&"'"	
	elseif Request("Mod2") = "complete" then
			sql="update omronpolist set status='complete',printqty='0', 可提数量='"&request("strpodeliveryqty")&"',已提数量='"&request("strdeliveryqty")&"' where SLIP号码= '"&request("SLIPno")&"' and 货号='"&request("productcode")&"'"	
	elseif Request("Mod2") = "descriptions" then
			sql="update omronpolist set descriptions='"&request("descriptions")&"' where SLIP号码= '"&request("SLIPno")&"' and 货号='"&request("productcode")&"'"	
	elseif Request("Mod2") = "edit" then
			sql="update omronpolist set 可提数量='"&request("podeliveryqty")&"' ,已提数量='"&request("deliveryqty")&"' where SLIP号码= '"&request("SLIPno")&"' and 货号='"&request("productcode")&"'"	
	end if
			conn.execute(sql)
%>
	<script language=javascript>
		window.opener.location.reload();
		window.close();
	</script>		
<%
else
	sql="select * from omronpolist where SLIP号码= '"&request("SLIPno")&"' and 货号='"&request("productcode")&"'"
	set rs=conn.execute(sql)
	model=rs("型号")
	slipno=rs("SLIP号码")
	poqty=rs("订货数量")
	podeliveryqty=rs("可提数量")
	deliveryqty=rs("已提数量")
	descriptions=rs("descriptions")
	if rs("printqty")<>"" then printqty=rs("printqty") else printqty=0
	
	if rs.eof then
		response.write "记录没有找到"
		response.end
	end if

end if
%>
<title>omronpolist</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<Link href="../global.css" rel=stylesheet type=text/css>
<Script Language="javascript" >
function dosub()
{
	if (isNaN(form1.printqty.value)||parseInt(form1.printqty.value) <= 0 || form1.printqty.value==''){
		alert('输入的待提数量不正确!');
		form1.printqty.focus();
		return;
		}
	if (parseInt(form1.printqty.value) > parseInt(form1.podeliveryqty.value)){
		alert('待提数量不能超过可提数量!');
		form1.printqty.focus();
		return;
		}
	form1.Mod.value = "save";
	form1.Mod2.value = "ready";
	form1.strprintqty.value = (parseInt(form1.printqty.value));
	form1.submit();
}
function dosub2()
{
	form1.Mod.value = "save";
	form1.Mod2.value = "complete";
	form1.strpodeliveryqty.value = (parseInt(form1.strpodeliveryqty.value)-parseInt(form1.strprintqty.value));
	form1.strdeliveryqty.value = (parseInt(form1.strdeliveryqty.value)+parseInt(form1.strprintqty.value));
	form1.submit();
}
function dosub3()
{
	form1.Mod.value = "save";
	form1.Mod2.value = "continue";
	form1.submit();
}
function dosub4()
{
	form1.Mod.value = "save";
	form1.Mod2.value = "descriptions";
	form1.submit();
}
function dosub5()
{
	if (parseInt(form1.deliveryqty.value)+parseInt(form1.podeliveryqty.value) > parseInt(form1.poqty.value)){
		alert('可提数量加已提数量不能超过订货数量!');
		form1.podeliveryqty.focus();
		return;
		}
		
	form1.Mod.value = "save";
	form1.Mod2.value = "edit";
	form1.submit();
}
</Script>
</head>
<body bgcolor="#FFFFFF" text="#000000" >
<form method="post"  id=form1 name=form1 action="">
  <input type=hidden name="Mod" >
  <input type=hidden name="Mod2" >
  <input type=hidden name="strprintqty" value="<%=printqty%>">
  <input type=hidden name="strpodeliveryqty" value="<%=podeliveryqty%>">
  <input type=hidden name="strdeliveryqty" value="<%=deliveryqty%>">
<font class=title>型号:<%=model%></font><br><font size=2 color="330000"><b>SLIP号码:<%=slipno%></b></font>
<%if request("method")="dt0" then%>
<table align="center" border='2' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#C0C0C0' width='100%' bordercolorlight='#CCCCCC' bordercolordark='#808080'>
	<tr><td width="100%"align="left">
	<table border=0 cellpadding=0 cellspacing=0 style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%">
    <tr height=40  bgcolor='#FFE6FF'> 
      <td colspan=2 align="center"><font color="ff0000"><b>※确信添加为待提订单吗?</b></font></td>
    </tr>
    <tr height=30  bgcolor='#DDFFD7'> 
      <td width="40%" align="right">可提数量:</td>
      <td><input type=text name="podeliveryqty" size=8 value="<%=podeliveryqty%>" readonly></td>
    </tr>
    <tr height=30  bgcolor='#FDFFD7'> 
      <td width="40%" align="right">待提数量:</td>
      <td><input type=text name="printqty" size=8 value="<%=podeliveryqty%>"></td>
    </tr>
    <tr> 
      <td height=30 colspan="2" align="center">
	    <a onclick="return dosub()"><img src="../images/button_confirm.gif" style="cursor:hand"></a>&nbsp;	
        <img src="../images/button_cancel.gif" style="cursor:hand" border=0 language=javascript onclick="window.close();"> </td>
    </tr>
	</table></td></tr></table>
<%elseif request("method")="dt1" then%>
<table align="center" border='2' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#C0C0C0' width='100%' bordercolorlight='#CCCCCC' bordercolordark='#808080'>
	<tr><td width="100%"align="left">
	<table border=0 cellpadding=0 cellspacing=0 style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%">
    <tr height=60  bgcolor='#FDFFD7'> 
      <td colspan=2 align="center"><font color="660000"><b>※确信该订单已完成吗?</b></font></td>
    </tr>
    <tr> 
      <td height=30 colspan="2" align="center">
	    <a onclick="return dosub2()"><img src="../images/button_confirm.gif" style="cursor:hand"></a>&nbsp;	
        <img src="../images/button_cancel.gif" style="cursor:hand" border=0 language=javascript onclick="window.close();">&nbsp;</td>	
    </tr>
	</table></td></tr></table>  
<%elseif request("method")="dt2" then%>
<table align="center" border='2' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#C0C0C0' width='100%' bordercolorlight='#CCCCCC' bordercolordark='#808080'>
	<tr><td width="100%"align="left">
	<table border=0 cellpadding=0 cellspacing=0 style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%">
    <tr height=60  bgcolor='#FFE6FF'> 
            <td colspan=2 align="center"><font color="ff0000"><b>※要继续提货吗?</b></font></td>
    </tr>
    <tr> 
      <td height=30 colspan="2" align="center">
	    <a onclick="return dosub3()"><img src="../images/button_continue.gif" style="cursor:hand"></a>&nbsp;
        <img src="../images/button_cancel.gif" style="cursor:hand" border=0 language=javascript onclick="window.close();"></td>	
    </tr>
	</table></td></tr></table> 
<%elseif request("method")="desp" then%>
<table align="center" border='2' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#C0C0C0' width='100%' bordercolorlight='#CCCCCC' bordercolordark='#808080'>
	<tr><td width="100%"align="left">
	<table border=0 cellpadding=0 cellspacing=0 style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%">
    <tr height=60  bgcolor='#FDFFD7'> 
      <td width="20%" align="right">描述:</td>
      <td><textarea name=descriptions cols="20" rows="4"><%=descriptions%></textarea></td>
    </tr>
    <tr> 
    <tr> 
      <td height=30 colspan="2" align="center">
	    <a onclick="return dosub4()"><img src="../images/button_confirm.gif" style="cursor:hand"></a>&nbsp;	
        <img src="../images/button_cancel.gif" style="cursor:hand" border=0 language=javascript onclick="window.close();">&nbsp;</td>	
    </tr>
	</table></td></tr></table>
<%elseif request("method")="edit" then%>
<table align="center" border='2' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#C0C0C0' width='100%' bordercolorlight='#CCCCCC' bordercolordark='#808080'>
	<tr><td width="100%"align="left">
	<table border=0 cellpadding=0 cellspacing=0 style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%">
    <tr bgcolor='#FFFFFF'> 
      <td align="CENTER" colspan="2"><font color="#990000" size=2><strong>※编辑细目</strong></font></td>
    </tr>
    <tr height=30  bgcolor='#FFE6FF'> 
      <td width="40%" align="right">订货数量:</td>
      <td><%=poqty%><input type=hidden name="poqty" value="<%=poqty%>" size=8 readonly></td>
    </tr>
    <tr height=30  bgcolor='#FDFFD7'> 
            <td width="40%" align="right">已提数量:</td>
      <td><input type=text name="deliveryqty" value="<%=deliveryqty%>" size=8></td>
    </tr>
    <tr height=30 bgcolor="#E6FDFF"> 
       <td width="40%" align="right">可提数量:</td>
      <td><input type=text name="podeliveryqty" value="<%=podeliveryqty%>" size=8></td>
    </tr>
    <tr> 
      <td height=30 colspan="2" align="center">
	    <a onclick="return dosub5()"><img src="../images/button_confirm.gif" style="cursor:hand"></a>&nbsp;	
        <img src="../images/button_cancel.gif" style="cursor:hand" border=0 language=javascript onclick="window.close();"></td>
    </tr>
	</table></td></tr></table> 
<%end if%>
</form>
</body>
</html>

⌨️ 快捷键说明

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