📄 updatedata.asp

📁 一个比较完整的企业erp系统
💻 ASP
字号:
<%@language="vbscript" codepage="936"%>
<%response.buffer = true%>
<%
 Server.ScriptTimeout = 999
 Public HOME_PATH:HOME_PATH = "../"
 Response.Expires = -1
 Response.ExpiresAbsolute = Now() - 1
 Response.cachecontrol = "no-cache"
%>
<!--#include file="../db.asp"-->
<!--#include file="../inc/function.asp"-->
<%
 Public title:title = "更新数据"
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title><%=title%></title><%
  if isLogin = false then
     Response.Write viewinfo("Logingo","","")
	 Response.end
  end if
%><meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="Generator" content="EditPlus">
<meta name="Author" content="">
<meta name="Keywords" content="">
<meta name="Description" content="">
<link href="<%=HOME_PATH%>css/style01.css" rel="stylesheet" type="text/css">
</head>
<body style = 'background-color:buttonface;margin:0px;border-style:none;' onload="fakeProgress(0,sb)">
<%   
     dim mtypeid_
     mtypeid_ = trim(Request("mtypeid"))
     if not isNumber(mtypeid_,"int",0) = 0 then 
	   SQLmtypeid = " where mtypeid = " & mtypeid_ & "" 
	   mtypeName = SelectZD("select mTypeName from mtype where mtypeid = " & mtypeid_ & "","未知")
	 else 
	   SQLmtypeid = ""
	   mtypeName = "全部"
	 end if
	 SQL = "select outhowed , stockid from stock" & SQLmtypeid
	 'Response.Write SQL
     Rs.Open(SQL),Conn,1,3
	    if not Rs.eof then
		   thisCount = Rs.RecordCount
		   for i_update = 1 to Rs.RecordCount
		       if Rs.eof then exit for
		       Rs("outhowed") = SelectZD("select Sum(outHow) from salelist where stockid = " & Rs("stockid") & "",0)
			   Rs.update
			   Rs.movenext
		   next
		end if
		Rs.Close
%>

<script type='text/javascript'>
<!--
if(document.body.clientWidth>0) {
   window.opener = null ;
   window.close() ;
}
var BW = <%=isNumber(Request.QueryString("W"),"int",0)%>;
var BH = <%=isNumber(Request.QueryString("H"),"int",0)%>;
var ie5 = (document.all && document.getElementsByTagName);
var step = 0;
function setSB(v, el, inforEl, message) {
  if (ie5 || document.readyState == "complete") {
      filterEl = el.children[0];
      valueEl = el.children[1];

      if (filterEl.style.pixelWidth > 0) {
          var filterBackup = filterEl.style.filter;
          filterEl.style.filter = "";
          filterEl.style.filter = filterBackup;
      }

  filterEl.style.width = v + "%";
  valueEl.innerHTML = v + "%";
  inforEl.innerHTML = message;
 }
}

function setSBByStep(v, el, inforEl, message) {
if (ie5 || document.readyState == "complete") {
step = step + v;
filterEl = el.children[0];
valueEl = el.children[1];

if (filterEl.style.pixelWidth > 0) {
var filterBackup = filterEl.style.filter;
filterEl.style.filter = "";
filterEl.style.filter = filterBackup;
}

filterEl.style.width = step + "%";
valueEl.innerHTML = step + "%"
inforEl.innerHTML = message;
}
}

function fakeProgress(v, el) {
   if (v >= 100) {
       setSB(v, el, infor, "<span style = 'color:red;'><span style = 'color:blue;'><%=mtypeName%></span>类别更新完毕．请关闭对话框…</span>");
   }else{

       setSB(v, el, infor, "正在更新<span style = 'color:blue;'><%=mtypeName%></span>类别数据．请稍候…");
       window.setTimeout("fakeProgress(" + (v + 1) + ", document.all['" + el.id + "'])", 20);
   }
}

//-->
</script>

<div style = 'text-align:center;'>
<script language="JavaScript">
<!--
document.write("<div style = 'width:"+BW+";height:"+BH+";padding-top:"+(BH-50)/2+"px;'>");
document.write("<div id='sb' style='border-right: buttonhighlight 1px solid; border-top:buttonshadow 1px solid; background: navy; width: "+(BW-30)+"px;border-left:solid 1px buttonshadow; border-bottom:buttonhighlight 1px solid; height: 14px; text-align: left'>");
document.write("<div id='sbchild1' style=\"filter: alpha(opacity=0, finishopacity=80, style=1, startx=0, starty=0, finishx=100, finishy=0); overflow: hidden; width: 100%; position: absolute; height: 12px\">") ;
document.write("<div style=\"background: #000000; width: 100% ;\"></div>") ;
document.write("</div>") ; 
document.write("<div style=\"font-size: 10px; width: "+(BW-30)+"px; color: white; font-family: arial; position: absolute; height: 14px; text-align: center\"></div>") ;
document.write("</div>") ;
document.write("<div id='infor' style=\"font-size: 12px; width: 100%; color: #000000; font-family: arial; position: relative; height: 14px; text-align: center;padding:3px;\"></div>") ;
document.write("</div>") ;
//-->
</script>
    
<script language="JavaScript">
<!--
var w = 'returnValue';
window.returnValue = w ;
//-->
</script>
     
	
    
  
  

</div>



</body>
</html>
⌨️ 快捷键说明

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