/// <summary> /// 根据流程类型获取所有流程 /// </summary> /// <param name="input"></param> /// <returns></returns> public Task <IEnumerable <WorkflowProcessGetOutput> > GetWorkflow(WorkflowProcessGetInput input) { StringBuilder sql = new StringBuilder("SELECT * FROM Workflow_Process "); if (input.Type != null) { sql.Append(" WHERE Type=@type"); } sql.Append(" ORDER BY Type"); return(SqlMapperUtil.SqlWithParams <WorkflowProcessGetOutput>(sql.ToString(), new { type = input.Type })); }
/// <summary> /// 根据流程类型获取所有流程 /// </summary> /// <param name="input"></param> /// <returns></returns> public async Task <IEnumerable <WorkflowProcessGetOutput> > GetWorkflow(WorkflowProcessGetInput input) { var workflows = (await _processRepository.GetWorkflow(input)).ToList(); var list = new List <FilterDefinition <SystemDictionary> > { Builders <SystemDictionary> .Filter.Lt("CreateTime", DateTime.Now) }; var filter = Builders <SystemDictionary> .Filter.And(list); var dic = (await _dictionaryMongoDbRepository.GetAllEnumerableAsync(filter)).ToList(); foreach (var workflow in workflows) { var type = dic.FirstOrDefault(f => f.DictionaryId == workflow.Type); if (type != null) { workflow.TypeName = type.Name; } } return(workflows); }