能否帮忙给个教材参考下怎么做~本来我是执行查询按钮,实现数据库查询,数据量大所以需要定时执行
使用timer,以前写过一个网页版简单聊天功能,实现原理是1s中对页面的局部刷新一次,你自己看吧,代码如下:
.aspx文件:
<body>
<form id="form1" runat="server">
<div>
<div>
<a href="HomePage.aspx">首页</a> <a href="UserPage.aspx">个人中心</a><a href="#">退出登录</a>
</div>
<h1>和<%=user2 %>聊天中……</h1><hr />
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
<asp:Panel ID="Panel1" runat="server" BorderStyle="Solid" BorderColor="#66CCFF" BorderWidth="3px" ScrollBars="Vertical" Height="400px" Width="600px">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Timer ID="Timer1" runat="server" OnTick="Timer1_Tick" Interval="1000"></asp:Timer>
<div runat="server" id="div1" style="width:550px; clear:both;">aaaa</div>
</ContentTemplate>
</asp:UpdatePanel>
</asp:Panel>
<asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:TextBox ID="TextBox1" runat="server" Width="550px" MaxLength="40"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="发送" OnClick="Button1_Click" />
</ContentTemplate>
</asp:UpdatePanel>
</div>
</form>
</body>
.cs文件
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using DataBaseConnection;
public partial class UserChat : System.Web.UI.Page
{
public string user1, user2;
protected void Page_Load(object sender, EventArgs e)
{
if(Session["UserName"].ToString().Length == 0) Response.Redirect("HomePage.aspx");
user1=Session["UserName"].ToString();
if (Request.QueryString["uid"]!=null)
user2 = Request.QueryString["uid"].ToString();
else
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('对不起,意外的错误!');window.location='HomePage.aspx';</script>");
Timer1.Enabled = true;
if (!Partone.userExist(user2))
{
Timer1.Enabled = false;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('对方账号不存在!');window.location='HomePage.aspx'</script>");
return;
}
else { Timer1.Enabled = true; }
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!Partone.userExist(user2))
{
Timer1.Enabled = false;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('对方账号不存在!');window.location='HomePage.aspx'</script>");
return;
}
else
{
Timer1.Enabled = true;
}
if (TextBox1.Text.Length == 0) return;
UsersChat.insertChat(user1, user2, TextBox1.Text);
TextBox1.Text = "";
}
protected void Timer1_Tick(object sender, EventArgs e)
{
div1.InnerHtml = "";
DataTable dtb = UsersChat.getChat(user1, user2);
int max = 20;
if (dtb.Rows.Count < max) max = dtb.Rows.Count;
for (int i = max - 1; i >= 0; i--)
{
if (user1.Equals(dtb.Rows[i]["CUser1"].ToString()))
{
string htm1 = "<div style=\"color:#22ff33; font-size:18px; text-align:right\">" + user1 + " " + dtb.Rows[i]["ChatDT"] + "</div>";
string htm2 = "<div style=\"font-size:22px; text-align:right;\">" + dtb.Rows[i]["ChatContent"] + "</div>";
div1.InnerHtml += htm1;
div1.InnerHtml += htm2;
}
else
{
string htm1 = "<div style=\"color:#2233ff; font-size:18px;\">" + user2 + " " + dtb.Rows[i]["ChatDT"] + "</div>";
string htm2 = "<div style=\"font-size:22px;\">" + dtb.Rows[i]["ChatContent"] + "</div>";
div1.InnerHtml += htm1;
div1.InnerHtml += htm2;
}
}
}
}
可以不可以加一个timer事件,根据服务器时间到点触发一个查询,有个设计模式非常适合这个,状态模式(当一个对象的内在状态改变时允许改变其行为,这个对象看起来像是改变了其类)
global.asax中启动一个线程执行查询:http://www.zzzj.com/a/aspnet/20100603111646.html
在Global.ascx.cs中,找到方法Application_Start,在这个方法内定义一个timer事件。
如下:
int time = 1000 * 60 * 60;
System.Timers.Timer myTimer = new System.Timers.Timer(time);
myTimer.Elapsed += new ElapsedEventHandler(myTimer_Elapsed);
myTimer.Enabled = true;
myTimer.AutoReset = true;
其中的myTimer_Elapsed就是需要执行的具体方法