webform1.aspx.cs

ASP.NET的一些开发实例,有论坛管理系统等

			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_tablename", System.Data.SqlDbType.VarChar, 100, "t_tablename"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_up", System.Data.SqlDbType.VarChar, 50, "t_up"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_dtype", System.Data.SqlDbType.VarChar, 50, "t_dtype"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_width", System.Data.SqlDbType.VarChar, 10, "t_width"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_cssname", System.Data.SqlDbType.VarChar, 30, "t_cssname"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_visible", System.Data.SqlDbType.VarChar, 1, "t_visible"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_order", System.Data.SqlDbType.Int, 4, "t_order"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@remark", System.Data.SqlDbType.VarChar, 100, "remark"));
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = "UPDATE dbo.system_userdd SET p_num = @p_num, m_num = @m_num, t_no = @t_no, t_name" +
				" = @t_name, t_title = @t_title, t_tablename = @t_tablename, t_up = @t_up, t_dtyp" +
				"e = @t_dtype, t_width = @t_width, t_cssname = @t_cssname, t_visible = @t_visible" +
				", t_order = @t_order, remark = @remark WHERE (u_num = @Original_u_num) AND (m_nu" +
				"m = @Original_m_num OR @Original_m_num IS NULL AND m_num IS NULL) AND (p_num = @" +
				"Original_p_num OR @Original_p_num IS NULL AND p_num IS NULL) AND (remark = @Orig" +
				"inal_remark OR @Original_remark IS NULL AND remark IS NULL) AND (t_cssname = @Or" +
				"iginal_t_cssname OR @Original_t_cssname IS NULL AND t_cssname IS NULL) AND (t_dt" +
				"ype = @Original_t_dtype OR @Original_t_dtype IS NULL AND t_dtype IS NULL) AND (t" +
				"_name = @Original_t_name OR @Original_t_name IS NULL AND t_name IS NULL) AND (t_" +
				"no = @Original_t_no OR @Original_t_no IS NULL AND t_no IS NULL) AND (t_order = @" +
				"Original_t_order OR @Original_t_order IS NULL AND t_order IS NULL) AND (t_tablen" +
				"ame = @Original_t_tablename OR @Original_t_tablename IS NULL AND t_tablename IS " +
				"NULL) AND (t_title = @Original_t_title OR @Original_t_title IS NULL AND t_title " +
				"IS NULL) AND (t_up = @Original_t_up OR @Original_t_up IS NULL AND t_up IS NULL) " +
				"AND (t_visible = @Original_t_visible OR @Original_t_visible IS NULL AND t_visibl" +
				"e IS NULL) AND (t_width = @Original_t_width OR @Original_t_width IS NULL AND t_w" +
				"idth IS NULL); SELECT u_num, p_num, m_num, t_no, t_name, t_title, t_tablename, t" +
				"_up, t_dtype, t_width, t_cssname, t_visible, t_order, remark FROM dbo.system_use" +
				"rdd WHERE (u_num = @u_num)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@p_num", System.Data.SqlDbType.VarChar, 10, "p_num"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@m_num", System.Data.SqlDbType.Int, 4, "m_num"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_no", System.Data.SqlDbType.VarChar, 20, "t_no"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_name", System.Data.SqlDbType.VarChar, 50, "t_name"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_title", System.Data.SqlDbType.VarChar, 200, "t_title"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_tablename", System.Data.SqlDbType.VarChar, 100, "t_tablename"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_up", System.Data.SqlDbType.VarChar, 50, "t_up"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_dtype", System.Data.SqlDbType.VarChar, 50, "t_dtype"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_width", System.Data.SqlDbType.VarChar, 10, "t_width"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_cssname", System.Data.SqlDbType.VarChar, 30, "t_cssname"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_visible", System.Data.SqlDbType.VarChar, 1, "t_visible"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@t_order", System.Data.SqlDbType.Int, 4, "t_order"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@remark", System.Data.SqlDbType.VarChar, 100, "remark"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_u_num", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "u_num", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_m_num", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "m_num", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_p_num", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "p_num", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_remark", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "remark", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_cssname", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_cssname", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_dtype", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_dtype", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_name", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_no", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_no", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_order", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_order", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_tablename", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_tablename", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_title", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_title", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_up", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_up", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_visible", System.Data.SqlDbType.VarChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_visible", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_width", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_width", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@u_num", System.Data.SqlDbType.Int, 4, "u_num"));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM dbo.system_userdd WHERE (u_num = @Original_u_num) AND (m_num = @Original_m_num OR @Original_m_num IS NULL AND m_num IS NULL) AND (p_num = @Original_p_num OR @Original_p_num IS NULL AND p_num IS NULL) AND (remark = @Original_remark OR @Original_remark IS NULL AND remark IS NULL) AND (t_cssname = @Original_t_cssname OR @Original_t_cssname IS NULL AND t_cssname IS NULL) AND (t_dtype = @Original_t_dtype OR @Original_t_dtype IS NULL AND t_dtype IS NULL) AND (t_name = @Original_t_name OR @Original_t_name IS NULL AND t_name IS NULL) AND (t_no = @Original_t_no OR @Original_t_no IS NULL AND t_no IS NULL) AND (t_order = @Original_t_order OR @Original_t_order IS NULL AND t_order IS NULL) AND (t_tablename = @Original_t_tablename OR @Original_t_tablename IS NULL AND t_tablename IS NULL) AND (t_title = @Original_t_title OR @Original_t_title IS NULL AND t_title IS NULL) AND (t_up = @Original_t_up OR @Original_t_up IS NULL AND t_up IS NULL) AND (t_visible = @Original_t_visible OR @Original_t_visible IS NULL AND t_visible IS NULL) AND (t_width = @Original_t_width OR @Original_t_width IS NULL AND t_width IS NULL)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_u_num", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "u_num", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_m_num", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "m_num", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_p_num", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "p_num", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_remark", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "remark", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_cssname", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_cssname", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_dtype", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_dtype", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_name", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_no", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_no", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_order", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_order", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_tablename", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_tablename", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_title", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_title", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_up", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_up", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_visible", System.Data.SqlDbType.VarChar, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_visible", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_t_width", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "t_width", System.Data.DataRowVersion.Original, null));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "data source=server-01;initial catalog=whiteforum;password=whiteforum;persist secu" +
				"rity info=True;user id=whiteforum;workstation id=BDSTUDIO-01;packet size=4096";
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}