public WfClientProcessCurrentInfoPageQueryResult QueryProcesses(WfClientProcessQueryCondition condition, int startRowIndex, int maximumRows, string orderBy, int totalCount)
{
condition.NullCheck("condition");
OperationContext.Current.FillContextToOguServiceContext();
WfProcessQueryCondition serverCondition = null;
WfClientProcessQueryConditionConverter.Instance.ClientToServer(condition, ref serverCondition);
if (orderBy.IsNullOrEmpty())
{
orderBy = "START_TIME DESC";
}
ConnectiveSqlClauseCollection connective = serverCondition.ToSqlBuilder();
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem("COMMITTED", "1");
builder.AppendTenantCode();
connective.Add(builder);
QueryCondition qc = new QueryCondition(startRowIndex, maximumRows,
ORMapping.GetSelectFieldsNameSql <WfProcessCurrentInfo>(),
ORMapping.GetMappingInfo(typeof(WfProcessCurrentInfo)).TableName,
orderBy);
qc.WhereClause += connective.ToSqlString(TSqlBuilder.Instance);
return(QueryProcessInfo(qc, totalCount));
}
public WfProcessQueryCondition ClientToServer(WfClientProcessQueryCondition client, ref WfProcessQueryCondition server)
{
client.NullCheck("client");
if (server == null)
{
server = new WfProcessQueryCondition();
}
server.ApplicationName = client.ApplicationName;
server.ProgramName = client.ProgramName;
server.ProcessName = client.ProcessName;
server.AssigneeExceptionFilterType = client.AssigneeExceptionFilterType.ToAssigneeExceptionFilterType();
server.AssigneesSelectType = client.AssigneesSelectType.ToAssigneesFilterType();
server.AssigneesUserName = client.AssigneesUserName;
server.BeginStartTime = client.BeginStartTime;
server.EndStartTime = client.EndStartTime;
server.ProcessStatus = client.ProcessStatus;
server.DepartmentName = client.DepartmentName;
server.ProcessCreatorID = client.ProcessCreatorID;
server.ProcessCreatorName = client.ProcessCreatorName;
foreach (WfClientUser user in client.CurrentAssignees)
{
server.CurrentAssignees.Add((IUser)(user.ToOguObject()));
}
return(server);
}
