mainlist.aspx.cs

1。使用ASP.NET+C# VS.NET 2003制作

			// 
			// sqlUpdateCommand4
			// 
			this.sqlUpdateCommand4.CommandText = @"UPDATE ShortMessage SET UserName = @UserName, Message = @Message, Readed = @Readed, SendUserName = @SendUserName, SendTime = @SendTime, systemmsg = @systemmsg 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); SELECT PKID, UserName, Message, Readed, SendUserName, SendTime, systemmsg FROM ShortMessage WHERE (PKID = @PKID)";
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 50, "UserName"));
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Message", System.Data.SqlDbType.VarChar, 800, "Message"));
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Readed", System.Data.SqlDbType.Bit, 1, "Readed"));
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SendUserName", System.Data.SqlDbType.VarChar, 50, "SendUserName"));
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SendTime", System.Data.SqlDbType.DateTime, 8, "SendTime"));
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@systemmsg", System.Data.SqlDbType.Bit, 1, "systemmsg"));
			this.sqlUpdateCommand4.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.sqlUpdateCommand4.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.sqlUpdateCommand4.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.sqlUpdateCommand4.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.sqlUpdateCommand4.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.sqlUpdateCommand4.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.sqlUpdateCommand4.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));
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PKID", System.Data.SqlDbType.Int, 4, "PKID"));
			// 
			// sqlDeleteCommand4
			// 
			this.sqlDeleteCommand4.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.sqlDeleteCommand4.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.sqlDeleteCommand4.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.sqlDeleteCommand4.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.sqlDeleteCommand4.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.sqlDeleteCommand4.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.sqlDeleteCommand4.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.sqlDeleteCommand4.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));
			// 
			// sqlDataAdapter4
			// 
			this.sqlDataAdapter4.DeleteCommand = this.sqlDeleteCommand4;
			this.sqlDataAdapter4.InsertCommand = this.sqlInsertCommand4;
			this.sqlDataAdapter4.SelectCommand = this.sqlSelectCommand4;
			this.sqlDataAdapter4.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.sqlDataAdapter4.UpdateCommand = this.sqlUpdateCommand4;
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Lb_logon_Click(object sender, System.EventArgs e)
		{
			//转到登录界面
			this.Response.Redirect("Logon.aspx?url="+this.Request.Url.ToString());
		}

		private void LinkButton1_Click(object sender, System.EventArgs e)
		{
			//退出登录
			System.Web.Security.FormsAuthentication.SignOut();
			Session["UserGrade"]=null;
			this.Response.Redirect("main.aspx");
		}

		private void Linkbutton2_Click(object sender, System.EventArgs e)
		{
			//转到注册界面
			//Response.Redirect("Regist.aspx");
			this.Response.Write("<script>window.open('Rules.aspx','shopcar')</script>");
		}

		private void ModifyKind(int X)
		{
			//X=  0：删除帖子 1：普通  3：置顶
			for (int i=0;i<DL_Main.Items.Count;i++ )
			{
				if (((CheckBox)DL_Main.Items[i].FindControl("selected")).Checked==true)
				{
					string s=((System.Web.UI.WebControls.HyperLink)DL_Main.Items[i].FindControl("Hyperlink3")).Text;
					DBOperate.ExcSQL("UPDATE Questions SET kind ="+X.ToString()+" WHERE (Q_ID = "+s+")");
				}
			}
			this.Response.Redirect(this.Request.Url.ToString());
		}

		private void Pith()
		{
			//设为精华
			for (int i=0;i<DL_Main.Items.Count;i++ )
			{
				if (((CheckBox)DL_Main.Items[i].FindControl("selected")).Checked==true)
				{
					string s=((System.Web.UI.WebControls.HyperLink)DL_Main.Items[i].FindControl("Hyperlink3")).Text;
					DBOperate.ExcSQL("UPDATE Questions SET pith=1 WHERE (Q_ID = "+s+")");
				}
			}
			this.Response.Redirect(this.Request.Url.ToString());
		}

		private void MoveQ()
		{
			//修改帖子类别（移贴）
			for (int i=0;i<DL_Main.Items.Count;i++ )
			{
				if (((CheckBox)DL_Main.Items[i].FindControl("selected")).Checked==true)
				{
					string s1=((System.Web.UI.WebControls.HyperLink)DL_Main.Items[i].FindControl("Hyperlink3")).Text;
					string s2=this.DropDownList1.SelectedValue.ToString();
					DBOperate.ExcSQL("update Questions set Questions.SmallClass_ID="+s2+",Questions.BigClass_ID=Small_Class.BigClass_ID from Small_Class,Questions where Small_Class.SmallClass_ID="+s2+"and Questions.Q_ID ="+s1);
				}
			}
			this.Response.Redirect(this.Request.Url.ToString());
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			ModifyKind(0);
		}

		private void DataList1_UpdateCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
		{
			for (int i=0;i<DL_Main.Items.Count;i++ )
			{
				string s=((System.Web.UI.WebControls.Label)e.Item.FindControl("selected")).Text;
				if (s=="true" )
				{
					s="";
				}
			}
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
			ModifyKind(3);
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
			Pith();
		}

		private void Button4_Click(object sender, System.EventArgs e)
		{
			ModifyKind(1);
		}

		private void Button5_Click(object sender, System.EventArgs e)
		{
			try
			{
				int x = System.Convert.ToInt32(TextBox1.Text.ToString());
				string BID,SID;
				if ((Request.QueryString["BID"]==null)||(Request.QueryString["SID"]==null))
				{
					BID="1";
					SID="200";
				}
				else
				{
					BID=Request.QueryString["BID"];
					SID=Request.QueryString["SID"];
				}
				string s=Request.CurrentExecutionFilePath+"?BID="+BID.ToString()+"&SID="+SID.ToString()+"&Page="+Convert.ToString(x);
				this.Response.Redirect(s);
			}
			catch(Exception) 
			{
			}
		}

		private void Linkbutton4_Click(object sender, System.EventArgs e)
		{
			this.Response.Redirect(this.Request.Url.ToString());
		}

		private void BtnMove_Click(object sender, System.EventArgs e)
		{
			MoveQ();
		}
	}
}