public List <Biz.Models.WorkflowHistory> GetWorkflowHistory(WorkflowHistoryDAL workflowHistoryDAL, string listName, int itemID) { List <Biz.Models.WorkflowHistory> workflowHistoryItems = null; try { string queryString = string.Format(@"<Where> <And> <Eq> <FieldRef Name='{0}' /> <Value Type='Text'>{1}</Value> </Eq> <Eq> <FieldRef Name='{2}' /> <Value Type='Number'>{3}</Value> </Eq> </And> </Where>", WorkflowHistoryList.Fields.ListName, listName, WorkflowHistoryList.Fields.CommonItemID, itemID); workflowHistoryItems = workflowHistoryDAL.GetByQuery(queryString); } catch (Exception ex) { ULSLogging.LogError(ex); } return(workflowHistoryItems); }
/// <summary> /// LoadWorkflowHistory /// </summary> /// <param name="workflowHistoryDAL">The WorkflowHistoryDAL object.</param> /// <param name="listName">The list name.</param> /// <param name="itemID">The current item id.</param> public void LoadWorkflowHistory(WorkflowHistoryDAL workflowHistoryDAL, string listName, int itemID) { try { var approvalBaseUserControl = this.Parent as ApprovalBaseUserControl; if (approvalBaseUserControl != null) { if (approvalBaseUserControl.IsVietnameseLanguage) { this.gridViewWorkflowHistory.Columns[1].Visible = true; } else { this.gridViewWorkflowHistory.Columns[0].Visible = true; } } List <Biz.Models.WorkflowHistory> workflowHistoryItems = GetWorkflowHistory(workflowHistoryDAL, listName, itemID); gridViewWorkflowHistory.DataSource = workflowHistoryItems; gridViewWorkflowHistory.DataBind(); } catch (Exception ex) { ULSLogging.LogError(ex); } }
/// <summary> /// LoadWorkflowHistory /// </summary> /// <param name="workflowHistoryDAL">The WorkflowHistoryDAL object.</param> /// <param name="listName">The list name.</param> /// <param name="itemID">The current item id.</param> public void LoadWorkflowHistory(WorkflowHistoryDAL workflowHistoryDAL, string listName, int itemID) { try { var approvalBaseUserControl = this.Parent as ApprovalBaseUserControl; if (approvalBaseUserControl != null) { if (approvalBaseUserControl.IsVietnameseLanguage) { this.gridViewWorkflowHistory.Columns[1].Visible = true; } else { this.gridViewWorkflowHistory.Columns[0].Visible = true; } } List <Biz.Models.WorkflowHistory> workflowHistoryItems = GetWorkflowHistory(workflowHistoryDAL, listName, itemID); string queryString = string.Format(@"<Where> <And> <Eq> <FieldRef Name='{0}' /> <Value Type='Text'>{1}</Value> </Eq> <Eq> <FieldRef Name='{2}' /> <Value Type='Number'>{3}</Value> </Eq> </And> </Where>", WorkflowHistoryList.Fields.ListName, listName, WorkflowHistoryList.Fields.CommonItemID, itemID); SPQuery query = new SPQuery(); query.Query = queryString; query.ViewFieldsOnly = true; query.ViewFields = $@"<FieldRef Name='{WorkflowHistoryList.Fields.Status}' /> <FieldRef Name='{WorkflowHistoryList.Fields.VietnameseStatus}' /> <FieldRef Name='{WorkflowHistoryList.Fields.PostedBy}' /> <FieldRef Name='{WorkflowHistoryList.Fields.CommonDate}' /> <FieldRef Name='{WorkflowHistoryList.Fields.CommonComment}' />"; SPList list = SPContext.Current.Web.GetList(WorkflowHistoryList.Url); SPListItemCollection items = list.GetItems(query); gridViewWorkflowHistory.DataSource = items; gridViewWorkflowHistory.DataBind(); } catch (Exception ex) { ULSLogging.LogError(ex); } }
public FilterTaskManager(string siteUrl) { _taskManagementDAL = new TaskManagementDAL(siteUrl); _workFlowHistory = new WorkflowHistoryDAL(siteUrl); }