mainlist.aspx.cs

一个C#写的WEB论坛

			this.sqlDeleteCommand4 = new System.Data.SqlClient.SqlCommand();
			this.sqlDataAdapter4 = new System.Data.SqlClient.SqlDataAdapter();
			// 
			// sqlSelectCommand2
			// 
			this.sqlSelectCommand2.CommandText = "SELECT PKID, Bigclass_ID, Smallclass_ID, ManagerName FROM Managers";
			this.sqlSelectCommand2.Connection = this.sqlConnection2;
			// 
			// sqlConnection2
			// 
			this.sqlConnection2.ConnectionString = "workstation id=GAS;packet size=4096;user id=sa;data source=localhost;persist secu" +
				"rity info=True;initial catalog=doughty_cn;password=123";
			// 
			// sqlInsertCommand2
			// 
			this.sqlInsertCommand2.CommandText = "INSERT INTO Managers(Bigclass_ID, Smallclass_ID, ManagerName) VALUES (@Bigclass_I" +
				"D, @Smallclass_ID, @ManagerName); SELECT PKID, Bigclass_ID, Smallclass_ID, Manag" +
				"erName FROM Managers WHERE (PKID = @@IDENTITY)";
			this.sqlInsertCommand2.Connection = this.sqlConnection2;
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Bigclass_ID", System.Data.SqlDbType.Int, 4, "Bigclass_ID"));
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Smallclass_ID", System.Data.SqlDbType.Int, 4, "Smallclass_ID"));
			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ManagerName", System.Data.SqlDbType.VarChar, 50, "ManagerName"));
			// 
			// sqlUpdateCommand2
			// 
			this.sqlUpdateCommand2.CommandText = @"UPDATE Managers SET Bigclass_ID = @Bigclass_ID, Smallclass_ID = @Smallclass_ID, ManagerName = @ManagerName WHERE (PKID = @Original_PKID) AND (Bigclass_ID = @Original_Bigclass_ID OR @Original_Bigclass_ID IS NULL AND Bigclass_ID IS NULL) AND (ManagerName = @Original_ManagerName OR @Original_ManagerName IS NULL AND ManagerName IS NULL) AND (Smallclass_ID = @Original_Smallclass_ID OR @Original_Smallclass_ID IS NULL AND Smallclass_ID IS NULL); SELECT PKID, Bigclass_ID, Smallclass_ID, ManagerName FROM Managers WHERE (PKID = @PKID)";
			this.sqlUpdateCommand2.Connection = this.sqlConnection2;
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Bigclass_ID", System.Data.SqlDbType.Int, 4, "Bigclass_ID"));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Smallclass_ID", System.Data.SqlDbType.Int, 4, "Smallclass_ID"));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ManagerName", System.Data.SqlDbType.VarChar, 50, "ManagerName"));
			this.sqlUpdateCommand2.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.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Bigclass_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Bigclass_ID", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ManagerName", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ManagerName", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Smallclass_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Smallclass_ID", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PKID", System.Data.SqlDbType.Int, 4, "PKID"));
			// 
			// sqlDeleteCommand2
			// 
			this.sqlDeleteCommand2.CommandText = @"DELETE FROM Managers WHERE (PKID = @Original_PKID) AND (Bigclass_ID = @Original_Bigclass_ID OR @Original_Bigclass_ID IS NULL AND Bigclass_ID IS NULL) AND (ManagerName = @Original_ManagerName OR @Original_ManagerName IS NULL AND ManagerName IS NULL) AND (Smallclass_ID = @Original_Smallclass_ID OR @Original_Smallclass_ID IS NULL AND Smallclass_ID IS NULL)";
			this.sqlDeleteCommand2.Connection = this.sqlConnection2;
			this.sqlDeleteCommand2.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.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Bigclass_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Bigclass_ID", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ManagerName", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ManagerName", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Smallclass_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Smallclass_ID", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDataAdapter2
			// 
			this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand2;
			this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2;
			this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;
			this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "Managers", new System.Data.Common.DataColumnMapping[] {
																																																				  new System.Data.Common.DataColumnMapping("PKID", "PKID"),
																																																				  new System.Data.Common.DataColumnMapping("Bigclass_ID", "Bigclass_ID"),
																																																				  new System.Data.Common.DataColumnMapping("Smallclass_ID", "Smallclass_ID"),
																																																				  new System.Data.Common.DataColumnMapping("ManagerName", "ManagerName")})});
			this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand2;
			// 
			// sqlSelectCommand4
			// 
			this.sqlSelectCommand4.CommandText = "SELECT COUNT(*) AS co FROM ShortMessage WHERE (systemmsg = 0) AND (Readed = 0) AN" +
				"D (UserName = @UserName)";
			this.sqlSelectCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 50, "UserName"));
			// 
			// sqlInsertCommand4
			// 
			this.sqlInsertCommand4.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.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 50, "UserName"));
			this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Message", System.Data.SqlDbType.VarChar, 800, "Message"));
			this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Readed", System.Data.SqlDbType.Bit, 1, "Readed"));
			this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SendUserName", System.Data.SqlDbType.VarChar, 50, "SendUserName"));
			this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SendTime", System.Data.SqlDbType.DateTime, 8, "SendTime"));
			this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@systemmsg", System.Data.SqlDbType.Bit, 1, "systemmsg"));
			// 
			// 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;

		}
		#endregion

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

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

		protected 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());
		}

		protected 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="";
				}
			}
		}

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

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

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

		protected 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) 
			{
			}
		}

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

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