C#+JS简单实现定时轮询数据表以及时弹出消息提示窗口(转)

来源：互联网发布：万圣节整人软件编辑：程序博客网时间：2024/05/29 12:08

实现思路:
框架主页 + 弹出的消息显示页面
框架主页内通过js定时执行一隐藏按钮的click事件
    其事件为查询消息表
    如有新消息则在框架页弹出消息提示窗口
消息提示窗口定时自动关闭
    其内有已读和删除及链接按钮
    链接按钮负责刷新框架面的iframe中的src
=====================
相关示例代码如下:
----------------
框架页面HTML部分
----------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="f_Test4.aspx.cs" Inherits="f_Test4" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>框架主页</title>
<script language="javascript" type="text/javascript">
//定时执行按钮事件查看是否有新的消息
function fn_BtnEventOnTime()
{
            document.all.btnhid_RefMsg.click();
        }

        window.onload=function()
{
            window.setInterval("fn_BtnEventOnTime()",20000);
        }

function fn_OpenMsgWindow(varTestID)
{
var paraTestID =escape(varTestID);
            window.open('f_MsgAlert.aspx?&TestIDPara='+paraTestID+'',"","dependent=no,location=no,height=100,width=200,left=0,top=600,");
        }

</script>
</head>
<body>
<form id="form1" runat="server">
<table>
<tr>
<td>TestID</td>
<td>
<asp:TextBox ID="txt_TestID" runat="server"></asp:TextBox>
</td>
<td>TestNote</td>
<td>
<asp:TextBox ID="txt_TestNote" runat="server"></asp:TextBox>
</td>
</tr>
</table>
<%--保存按钮负责写入数据到数据库的f_Test表--%>
<asp:Button ID="btn_Save" runat="server" Text="保存" OnClick="btn_Save_Click" />
<br />
<input id="btnhid_RefMsg" type="button" value="隐藏按钮刷新消息提示"
        runat="server" onserverclick="btnhid_RefMsg_ServerClick"
        style="display:none;" />
<br />
<%--消息窗口链接按钮将显示页面在iframe中--%>
<iframe id="ShowPage" ></iframe>
</form>
</body>
</html>

-------------------
框架页面.cs代码部分
-------------------

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class f_Test4 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{

        }
    }

protected void btn_Save_Click(object sender, EventArgs e)
{
string strCommand1 = " INSERT INTO f_Test(TestID, TestNote , TestState) ";
        strCommand1 += " VALUES( ";
        strCommand1 += " " + this.txt_TestID.Text.Trim() + " ";
        strCommand1 += " ,'" + this.txt_TestNote.Text.Trim() + "' ";
        strCommand1 += " ,'0' ";//消息状态为0 表示为新消息需提示
        strCommand1 += " )";
        DBClass db1 = new DBClass();

if (db1.RunNotSelectSqlCommand(strCommand1))
{
            CommClass.DoAlert(this.Page, "新增保存成功");
        }
else
{
            CommClass.DoAlert(this.Page, "新增保存失败");
        }
    }

protected void btnhid_RefMsg_ServerClick(object sender, EventArgs e)
{
string strCommand = " SELECT TOP 1 TestID FROM f_Test ";
        strCommand += " WHERE TestState='0' ";
        DBClass db = new DBClass();
        DataSet ds = db.RunSelectGetDataSet(strCommand);
if (ds.Tables[0].Rows.Count > 0)
{
string strTestID = ds.Tables[0].Rows[0][0].ToString().Trim();
string strJS = "<script language='javascript' type='text/javascript'>";
            strJS += " fn_OpenMsgWindow('" + strTestID + "'); ";
            strJS += "</script>";
            Page.RegisterStartupScript("winOpenJS", strJS);
        }
    }
}

--------------------------
弹出的消息显示页面HTML部分
--------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="f_MsgAlert.aspx.cs" Inherits="f_MsgAlert" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>消息提示</title>
<script language="javascript">


function openLink()
{
var pageURL = "f_Test1.aspx";
//      window.opener.document.getElementById("txt_TestID").value = "abc";
        window.opener.document.frames("ShowPage").window.location.href = pageURL;
        window.returnValue = '';
        window.opener = null;
        window.close();
    }
</script>
</head>
<body>
<form id="form1" runat="server">
<table>
<tr>
<td>TestID</td>
<td>
<asp:TextBox ID="txt_TestID" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>TestNote</td>
<td>
<asp:TextBox ID="txt_TestNote" runat="server"></asp:TextBox>
</td>
</tr>
</table>
<asp:Button ID="btn_Readed" runat="server" Text="已读" />
<asp:Button ID="btn_Link" runat="server" Text="链接" OnClientClick="openLink();" />
<asp:Button ID="btn_Delete" runat="server" Text="删除" />
</form>
</body>
</html>

-----------------------------
弹出的消息显示页面.cs代码部分
-----------------------------

http://www.cnblogs.com/wuhen/articles/1410872.html

C#+JS简单实现 定时轮询数据表 以及时弹出消息提示窗口(转)

C#+JS简单实现定时轮询数据表以及时弹出消息提示窗口(转)