shortmsg.aspx.cs

勇敢者论坛全部源代码。 支持SQL2000/Access数据库

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;

namespace doughty_cn
{
	/// <summary>
	/// ShortMsg 的摘要说明。
	/// </summary>
	public partial class ShortMsg : System.Web.UI.Page
	{
		protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		protected System.Data.SqlClient.SqlCommand sqlInsertCommand1;
		protected System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
		protected System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
		protected System.Data.SqlClient.SqlConnection sqlConnection1;
		protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
		protected System.Data.DataView dataView1;
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if ((User.Identity.Name==null)||(User.Identity.Name==""))
			{
				this.Response.Redirect("Logon.aspx?url="+this.Request.Url.ToString());
			}
			string sql;
			if (Request.QueryString["READ"]=="1") 
				sql="SELECT PKID, UserName, Message, Readed, SendUserName, SendTime, systemmsg FROM ShortMessage where systemmsg=1 or UserName='"+User.Identity.Name+"' order by SendTime DESC";
			else
				sql="SELECT PKID, UserName, Message, Readed, SendUserName, SendTime, systemmsg FROM ShortMessage where systemmsg=1 or (Readed=0 and UserName='"+User.Identity.Name+"') order by SendTime DESC";
			DL_ShortMsg.DataSource=DBOperate.SelectFormForum(sql);
			DBOperate.ExcSQL("UPDATE ShortMessage SET Readed = 1 WHERE (UserName ='"+User.Identity.Name+"')");
			Page.DataBind();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
			this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
			this.dataView1 = new System.Data.DataView();
			((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT PKID, UserName, Message, Readed, SendUserName, SendTime, systemmsg FROM Sh" +
				"ortMessage";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=GAS;packet size=4096;user id=sa;data source=localhost;persist secu" +
				"rity info=True;initial catalog=doughty_forum;password=123";
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = @"INSERT INTO ShortMessage(UserName, Message, Readed, SendUserName, SendTime, systemmsg) VALUES (@UserName, @Message, @Readed, @SendUserName, @SendTime, @systemmsg); SELECT PKID, UserName, Message, Readed, SendUserName, SendTime, systemmsg FROM ShortMessage WHERE (PKID = @@IDENTITY)";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 50, "UserName"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Message", System.Data.SqlDbType.VarChar, 800, "Message"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Readed", System.Data.SqlDbType.Bit, 1, "Readed"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SendUserName", System.Data.SqlDbType.VarChar, 50, "SendUserName"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SendTime", System.Data.SqlDbType.DateTime, 8, "SendTime"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@systemmsg", System.Data.SqlDbType.Bit, 1, "systemmsg"));
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = "UPDATE ShortMessage SET Readed = 1 WHERE (UserName = @UserName)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserName", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM ShortMessage WHERE (PKID = @Original_PKID) AND (Message = @Original_Message OR @Original_Message IS NULL AND Message IS NULL) AND (Readed = @Original_Readed OR @Original_Readed IS NULL AND Readed IS NULL) AND (SendTime = @Original_SendTime OR @Original_SendTime IS NULL AND SendTime IS NULL) AND (SendUserName = @Original_SendUserName OR @Original_SendUserName IS NULL AND SendUserName IS NULL) AND (UserName = @Original_UserName OR @Original_UserName IS NULL AND UserName IS NULL) AND (systemmsg = @Original_systemmsg OR @Original_systemmsg IS NULL AND systemmsg IS NULL)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_PKID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PKID", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Message", System.Data.SqlDbType.VarChar, 800, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Message", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Readed", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Readed", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_SendTime", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SendTime", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_SendUserName", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SendUserName", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserName", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserName", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_systemmsg", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "systemmsg", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "ShortMessage", new System.Data.Common.DataColumnMapping[] {
																																																					  new System.Data.Common.DataColumnMapping("PKID", "PKID"),
																																																					  new System.Data.Common.DataColumnMapping("UserName", "UserName"),
																																																					  new System.Data.Common.DataColumnMapping("Message", "Message"),
																																																					  new System.Data.Common.DataColumnMapping("Readed", "Readed"),
																																																					  new System.Data.Common.DataColumnMapping("SendUserName", "SendUserName"),
																																																					  new System.Data.Common.DataColumnMapping("SendTime", "SendTime"),
																																																					  new System.Data.Common.DataColumnMapping("systemmsg", "systemmsg")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();

		}
		#endregion
	}
}