listenmessage.aspx.cs

很不错的公文流转系统

using System; 
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Xml ;
using System.Text;
namespace OI.ReFileOperate
{
	/// <summary>
	/// listenmessage 的摘要说明。
	/// </summary>
	public class listenmessage : OI.PageBase 
	{   
		OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
        string userid;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
	
			XmlDocument d = new  System.Xml.XmlDocument();
	   		d.Load (Request.InputStream );
			XmlNode UserID =d.SelectSingleNode ("//Userid"); 
			userid=UserID.InnerText ;
			CreateDataSource(userid);
	        
		}
		private void CreateDataSource(string userid) //从消息表中取出数据,发送给客户端.
		{
		
    		string javascript;
			try
			{
				string str="select m.*,a.username from message m,Accounts_Users a where m.SendUserId=a.userid and m.state=0 and m.ReceiveUserId="+userid ;
				System.Data.DataSet ds=new DataSet ();
				ds=Dbc.getBinding (str,"t");
				str="update message set state=1 where state=0 and   ReceiveUserId="+userid ;
				Dbc.ExecuteSQL (str);
				if (ds.Tables[0].Rows.Count >0)
				{
					string count=ds.Tables[0].Rows.Count.ToString ();
					javascript="{ ;";
					javascript +=" newmessage="+count+";";
					for (int i=0;i<  ds.Tables[0].Rows.Count;i++ )
					{   
						DataRow dr=ds.Tables[0].Rows[i];
					
    					javascript +="Messages ["+i+"]=new message(\""+dr["MessageContent"].ToString () +"\",\""+dr["username"].ToString ()+"\",\""+dr["SendTime"].ToString ()+"\");" ;
					}
					javascript += "currentN=0;document.all.imgmessage.src=\"../images/i.p.new-.gif\"; document.all.totalcount.innerText=Messages.length;document.all.current.innerText=currentN+1; Form1.content.value =Messages[0].Scontent;document.all.Messager.innerText=Messages[0].Ssender;document.all.SendTime.innerText=Messages[0].Ssendertime; }";
				
				}
				else
				{
                    javascript ="";
				}
				//Response.Write (Server.HtmlEncode (javascript)); 
				Response.Write (javascript);
			
			}
			catch 
			{
				Response.Write ("alert('从服务器读取数据失败,请重新偿试.');");
				Response.End ();
			}

		}
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);
		}
		#endregion
	}
}