【IT168技术文档】
Wf 不是应用程序，它只是一个架构，由Runtime和宿主来组成的。
要对工作流进行监控可以在工作流内部当它还是Runtime状态时进行操作。也就是说在工作流钝化之前对工作流的数据进行分析。对工作流xml文件进行操作，完全地控制整个工作流的状况。
一、工作流信息的数据库
在钝化之前将工作流的信息记录到数据库中，首先我们先建数据库（WorkflowInfo）再创建相关的表：wfInfo（图1）, TaskInfo（图2）, wf_HistoryList（图3）; 工作流执行时一步一步地把数据记录到相关的表中。
class wfInfoData { public static SqlParameter[] Getwf_Info() { SqlParameter[] spwf_Info = SqlHelper.GetCachedParameters("WFInfodata"); if (spwf_Info == null) { spwf_Info = new SqlParameter[] { new SqlParameter("@WID", SqlDbType.Int,4), new SqlParameter("@WorkflowId", SqlDbType.UniqueIdentifier,16), new SqlParameter("@WorkflowName", SqlDbType.NVarChar,50), new SqlParameter("@ItemName", SqlDbType.NVarChar,50), new SqlParameter("@ListTitle", SqlDbType.NVarChar,50), new SqlParameter("@DisplayName", SqlDbType.NVarChar,50), new SqlParameter("@Created", SqlDbType.DateTime), new SqlParameter("@Investigator", SqlDbType.NVarChar,50), new SqlParameter("@InvCreated", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.NVarChar,50) }; SqlHelper.CacheParameters("WFInfodata", spwf_Info); } return spwf_Info; } /**//// <summary> /// 增加一条数据 /// </summary> /// <param name="info"></param> public static void Addwf_Info(WFInfo info) { using(SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringProfile)) { SqlParameter[] spwf_Info = wfInfoData.Getwf_Info(); spwf_Info[0].Direction = ParameterDirection.Output; spwf_Info[1].Value = info.WorkflowId; spwf_Info[2].Value = info.WorkflowName; spwf_Info[3].Value = info.ItemName; spwf_Info[4].Value = info.ListTitle; spwf_Info[5].Value = info.DisplayName; spwf_Info[6].Value = info.Created; spwf_Info[7].Value = info.Investigator; spwf_Info[8].Value = info.InvCreated; spwf_Info[9].Value = info.Status; SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "ADDwfInfo", spwf_Info); } } } Modul public class WFInfo { public WFInfo() { } Model#region Model private int _wid; private Guid _workflowid; private string _workflowname; private string _itemname; private string _listtitle; private string _displayname; private DateTime _created; private string _investigator; private DateTime _invcreated; private string _status; /**//// <summary> /// /// </summary> public int WID { set { _wid = value; } get { return _wid; } } /**//// <summary> /// 工作流GUID /// </summary> public Guid WorkflowId { set { _workflowid = value; } get { return _workflowid; } } /**//// <summary> /// 工作流名称 /// </summary> public string WorkflowName { set { _workflowname = value; } get { return _workflowname; } } /**//// <summary> /// 表单名称 /// </summary> public string ItemName { set { _itemname = value; } get { return _itemname; } } /**//// <summary> /// 表单库名称 /// </summary> public string ListTitle { set { _listtitle = value; } get { return _listtitle; } } /**//// <summary> /// 申请者 /// </summary> public string DisplayName { set { _displayname = value; } get { return _displayname; } } /**//// <summary> /// 申请时间 /// </summary> public DateTime Created { set { _created = value; } get { return _created; } } /**//// <summary> /// 审批者 /// </summary> public string Investigator { set { _investigator = value; } get { return _investigator; } } /**//// <summary> /// 审批时间 /// </summary> public DateTime InvCreated { set { _invcreated = value; } get { return _invcreated; } } /**//// <summary> /// 工作流状态 /// </summary> public string Status { set { _status = value; } get { return _status; } } /**//// <summary> /// 增加记录 /// </summary> /// <param name="workflowId"></param> /// <param name="workflowName"></param> /// <param name="itemName"></param> /// <param name="listTitle"></param> /// <param name="displayName"></param> /// <param name="created"></param> /// <param name="investigator"></param> /// <param name="invCreated"></param> /// <param name="status"></param> public WFInfo(Guid workflowId, string workflowName, string itemName, string listTitle, string displayName, DateTime created, string investigator, DateTime invCreated, string status) { this.WorkflowId = workflowId; this.WorkflowName = workflowName; this.ItemName = itemName; this.ListTitle = listTitle; this.DisplayName = displayName; this.Created = created; this.Investigator = investigator; this.InvCreated = invCreated; this.Status = status; } public WFInfo(int wID ,Guid workflowId, string workflowName, string itemName, string listTitle, string displayName, DateTime created, string investigator, DateTime invCreated, string status) { this.WID = wID; this.WorkflowId = workflowId; this.WorkflowName = workflowName; this.ItemName = itemName; this.ListTitle = listTitle; this.DisplayName = displayName; this.Created = created; this.Investigator = investigator; this.InvCreated = invCreated; this.Status = status; } #endregion Model } //获取工作流状态 string statu = GetWorkflowStatu(); //记录工作流的基本信息 wfInfoData.Addwf_Info(new WFInfo(workflowProperties.WorkflowId, workflowProperties.Workflow.ParentAssociation.Name,wfItemName, this.listTitle, wfOriginator.DisplayName, applyDate, "",DateTime.Now, statu)); string GetWorkflowStatu() { //获取工作流状态 SPFieldWorkflowStatus statusField = workflowProperties.List.Fields.GetField(workflowProperties.Workflow.ParentAssociation.InternalName) as SPFieldWorkflowStatus; System.Xml.XmlDocument doc = new System.Xml.XmlDocument(); doc.LoadXml(workflowProperties.Workflow.Xml); System.Xml.XmlNode node = doc.SelectSingleNode("Workflow/@Status1"); string statu = statusField.GetFieldValueAsText(node.InnerText); return statu; }
二、数据展现在web页面中
新建ASP.NET Web Site , 创建WFInfo.aspx，WFTaskInfo.aspx，WFHistoryList.aspx页面。
WFInfo.aspx页面中读取数据表wfInfo的值。利用工作流名称，工作流状态进行筛选。
在工作流名称字段中查看工作流的任务信息，和工作流的历史纪录信息。
相关代码如下：
页面初始化：
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GSEGC_LogConnectionString"].ConnectionString)) { SqlDataAdapter da = new SqlDataAdapter("select distinct WorkflowName from wfInfo", conn); DataSet ds = new DataSet(); da.Fill(ds); this.ddlWFName.DataSource = ds; this.ddlWFName.DataTextField = "WorkflowName"; this.ddlWFName.DataValueField = "WorkflowName"; this.ddlWFName.DataBind(); SqlDataAdapter daStatu = new SqlDataAdapter("select distinct Status from wfInfo", conn); DataSet dsStatu = new DataSet(); daStatu.Fill(dsStatu); this.ddlWFStatus.DataSource = dsStatu; this.ddlWFStatus.DataTextField = "Status"; this.ddlWFStatus.DataValueField = "Status"; this.ddlWFStatus.DataBind(); /*SqlDataAdapter daWFId = new SqlDataAdapter("select distinct WorkflowId from wfInfo", conn); DataSet dsWFId = new DataSet(); daWFId.Fill(dsWFId);*/ GetFilterStatus(); } } }
