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