玄铁剑

static void CreateTrackingProfile()
            {
            TrackingProfile profile = new TrackingProfile();
            ActivityTrackPoint trackPoint = new ActivityTrackPoint();
            // Track CodeActivity activities only.
            ActivityTrackingLocation location = new ActivityTrackingLocation
            (typeof(System.Workflow.Activities.CodeActivity));
            // Add all activity tracking events.
            foreach (ActivityExecutionStatus s in
            Enum.GetValues(typeof(ActivityExecutionStatus)))
            {
            location.ExecutionStatusEvents.Add(s);
            }
            trackPoint.MatchingLocations.Add(location);
            profile.ActivityTrackPoints.Add(trackPoint);
            profile.Version = new Version("1.0.0.0");
            WorkflowTrackPoint wtp = new WorkflowTrackPoint();
            WorkflowTrackingLocation wtl = new WorkflowTrackingLocation();
            // Add all workflow tracking events.
            foreach (TrackingWorkflowEvent s in
            Enum.GetValues(typeof(TrackingWorkflowEvent)))
            {
            wtl.Events.Add(s);
            }
            wtp.MatchingLocation = wtl;
            profile.WorkflowTrackPoints.Add(wtp);
            // Serialize tracking profile and save to SQL.
            TrackingProfileSerializer serializer = new TrackingProfileSerializer();
            StringWriter writer = new StringWriter(new StringBuilder(),
            CultureInfo.InvariantCulture);
            serializer.Serialize(writer, profile);
            InsertTrackingProfile(writer.ToString());
            }

static void InsertTrackingProfile(string profile)
            {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "dbo.UpdateTrackingProfile";
            cmd.Connection = new SqlConnection(Program.connectionString);
            try
            {
            cmd.Parameters.Clear();
            SqlParameter typFullName = new SqlParameter();
            typFullName.ParameterName = "@TypeFullName";
            typFullName.SqlDbType = SqlDbType.NVarChar;
            typFullName.SqlValue = typeof(SimpleWorkflow).ToString();
            cmd.Parameters.Add(typFullName);
            SqlParameter assemblyFullName = new SqlParameter();
            assemblyFullName.ParameterName = "@AssemblyFullName";
            assemblyFullName.SqlDbType = SqlDbType.NVarChar;
            assemblyFullName.SqlValue = typeof(SimpleWorkflow).Assembly.FullName;
            cmd.Parameters.Add(assemblyFullName);
            SqlParameter versionId = new SqlParameter();
            versionId.ParameterName = "@Version";
            versionId.SqlDbType = SqlDbType.VarChar;
            // The version ID must match the tracking profile version
            // number.
            versionId.SqlValue = "1.0.0.0";
            cmd.Parameters.Add(versionId);
            SqlParameter trackingProfile = new SqlParameter();
            trackingProfile.ParameterName = "@TrackingProfileXml";
            trackingProfile.SqlDbType = SqlDbType.NVarChar;
            trackingProfile.SqlValue = profile;
            cmd.Parameters.Add(trackingProfile);
            cmd.Connection.Open();
            cmd.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
            Console.WriteLine(e.Message);
            Console.WriteLine("The Tracking Profile was not inserted. " +
            "if you want to add a new Tracking Profile, modify the version " +
            "string in the profile by specifying a higher version number.");
            return;
            }
            finally
            {
            if ((null != cmd) && (null != cmd.Connection) &&
            (ConnectionState.Closed != cmd.Connection.State))
            cmd.Connection.Close();
            }
            }