62,046
社区成员
发帖
与我相关
我的任务
分享xmlhttp为什么取不到最新数据
<script language="javascript">
//自动取数据
function expands()
{
debugger;
var ChildTreeUrl = "Refresh.aspx?Yhbh=<%=userName%>";
var sResult = removeHtmlCode(getURLText(ChildTreeUrl));
//var sResult = parseInt(removeHtmlCode(getURLText(ChildTreeUrl)));
//if(sResult>0)
//{
//alert("您还有"+sResult+"条记录要审批!!");
//}
document.all["Label1"].innerText="";
document.all["Label1"].innerText=sResult;
setTimeout("expands()","15000"); //五分钟刷新一次
}
function getURLText(URL)
{
var http=new ActiveXObject("Microsoft.XMLHTTP");
http.open("get",URL,false,"","");
http.setRequestHeader("CONTENT-TYPE","text/html; Charset=gb2312");
http.send();
if (http.status!=200) {
http=null;
return "";
}
var webStr=http.responseText;
http=null;
return webStr;
}
function removeHtmlCode(sNodeDataHtml)
{
var sNodeData=sNodeDataHtml;
var s1 = sNodeDataHtml.indexOf('<!--Start-->');
s1 = s1 + ('<!--Start-->').length;
var s2 = sNodeDataHtml.indexOf("<!--End-->");
sNodeData = sNodeData.substring(s1,s2); // 取子字符串。
return sNodeData;
}
expands();
</script>
<%@ Page language="c#" Codebehind="Refresh.aspx.cs" AutoEventWireup="false" Inherits="localhost.Refresh" enableViewState="False"%>
<HTML>
<HEAD>
<title>Refresh</title>
<meta http-equiv="Expires" content="0">
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="Pragma" content="no-cache">
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body>
<form id="Form1" method="post" runat="server">
<FONT face="宋体"></FONT>
<!--Start--><%=MyWork_Sl%><!--End-->
</form>
</body>
</HTML>
.cs
MyWork_Sl="";
PublicFunc = new PublicFunc();
MainConn = PublicFunc.GetSqlConn(System.Configuration.ConfigurationSettings.AppSettings["SQLLinkString"]);
Shr_Gh=Request.QueryString["Yhbh"].ToString();
My_dataSet=new DataSet();
My_dataSet=PublicFunc.GetSqlDataSet(MainConn,"select Id,WDID,BGDBH from v_GZL_MY_Work where SHR='"+Shr_Gh+"'");
for (int i=0;i<My_dataSet.Tables[0].Rows.Count;i++)
{
MyWork_Sl+=My_dataSet.Tables[0].Rows[i][0].ToString()+My_dataSet.Tables[0].Rows[i][1].ToString()+My_dataSet.Tables[0].Rows[i][2].ToString();
}
//自动取数据
function expands()
{
debugger;
var ChildTreeUrl = "Refresh.aspx?Yhbh=<%=userName%>";
var sResult = removeHtmlCode(getURLText(ChildTreeUrl));
//var sResult = parseInt(removeHtmlCode(getURLText(ChildTreeUrl)));
//if(sResult>0)
//{
//alert("您还有"+sResult+"条记录要审批!!");
//}
document.all["Label1"].innerText="";
document.all["Label1"].innerText=sResult;
setTimeout("expands()","15000"); //五分钟刷新一次
}
function getURLText(URL)
{
var http=new ActiveXObject("Microsoft.XMLHTTP");
http.open("get",URL,false,"","");
http.setRequestHeader("CONTENT-TYPE","text/html; Charset=gb2312");
http.send();
if (http.status!=200) {
http=null;
return "";
}
var webStr=http.responseText;
http=null;
return webStr;
}
function removeHtmlCode(sNodeDataHtml)
{
var sNodeData=sNodeDataHtml;
var s1 = sNodeDataHtml.indexOf('<!--Start-->');
s1 = s1 + ('<!--Start-->').length;
var s2 = sNodeDataHtml.indexOf("<!--End-->");
sNodeData = sNodeData.substring(s1,s2); // 取子字符串。
return sNodeData;
}
expands();
</script>
<%@ Page language="c#" Codebehind="Refresh.aspx.cs" AutoEventWireup="false" Inherits="localhost.Refresh" enableViewState="False"%>
<HTML>
<HEAD>
<title>Refresh</title>
<meta http-equiv="Expires" content="0">
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="Pragma" content="no-cache">
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body>
<form id="Form1" method="post" runat="server">
<FONT face="宋体"></FONT>
<!--Start--><%=MyWork_Sl%><!--End-->
</form>
</body>
</HTML>
.cs
MyWork_Sl="";
PublicFunc = new PublicFunc();
MainConn = PublicFunc.GetSqlConn(System.Configuration.ConfigurationSettings.AppSettings["SQLLinkString"]);
Shr_Gh=Request.QueryString["Yhbh"].ToString();
My_dataSet=new DataSet();
My_dataSet=PublicFunc.GetSqlDataSet(MainConn,"select Id,WDID,BGDBH from v_GZL_MY_Work where SHR='"+Shr_Gh+"'");
for (int i=0;i<My_dataSet.Tables[0].Rows.Count;i++)
{
MyWork_Sl+=My_dataSet.Tables[0].Rows[i][0].ToString()+My_dataSet.Tables[0].Rows[i][1].ToString()+My_dataSet.Tables[0].Rows[i][2].ToString();
}
...全文
请发表友善的回复…
发表回复
