/// <summary> /// 获取用户待办事项 /// </summary> /// <param name="searchDto"></param> /// <returns></returns> public async Task <Page <UserWorkFlowDto> > GetUserTodoListAsync(WorkFlowTodoSearchDto searchDto) { Page <UserWorkFlowDto> page = new Page <UserWorkFlowDto>() { PageIndex = searchDto.PageIndex, PageSize = searchDto.PageSize }; string sql = $@"SELECT wf.`FlowId`,wf.`FlowName`,ins.`InstanceId`,ins.`Code` AS InstanceCode,ins.`IsFinish`,ins.`Status`,ins.`CreateTime`, ins.`CreateUserName` AS UserName ,ff.`FormName`,ff.`FormType`,ff.`FormUrl`,wif.`FormData` FROM `wf_workflow_instance` ins INNER JOIN `wf_workflow` wf ON wf.`FlowId`=ins.`FlowId` INNER JOIN `wf_workflow_form` ff ON ff.`FormId`=wf.`FormId` INNER JOIN `wf_workflow_instance_form` wif ON wif.`InstanceId`=ins.`InstanceId` WHERE ins.`MakerList` LIKE '%{searchDto.UserId},%' ORDER BY ins.`CreateTime` DESC LIMIT {(searchDto.PageIndex - 1) * searchDto.PageSize},{searchDto.PageSize}"; string countsql = $@"SELECT COUNT(1) FROM `wf_workflow_instance` ins INNER JOIN `wf_workflow` wf ON wf.`FlowId`= ins.`FlowId` INNER JOIN `wf_workflow_form` ff ON ff.`FormId`=wf.`FormId` INNER JOIN `wf_workflow_instance_form` wif ON wif.`InstanceId`=ins.`InstanceId` WHERE ins.`MakerList` LIKE '%{searchDto.UserId},%' ORDER BY ins.`CreateTime` DESC"; page.Items = await this.Connection.QueryAsync <UserWorkFlowDto>(sql); page.TotalItems = await this.Connection.ExecuteScalarAsync <int>(countsql); return(page); }
public async Task <Page <UserWorkFlowDto> > GetUserTodoListAsync(WorkFlowTodoSearchDto searchDto) { var uri = API.WorkFlowInstance.GetUserTodoListAsync(_baseUrl, searchDto); var responseString = await _apiClient.GetStringAsync(uri); return(responseString.ToObject <Page <UserWorkFlowDto> >()); }
public async Task <Page <UserWorkFlowDto> > HomeTodoList() { WorkFlowTodoSearchDto searchDto = new WorkFlowTodoSearchDto { PageIndex = 1, PageSize = 10, UserId = UserIdentity.UserId.ToString() }; var page = await _workFlowInstanceService.GetUserTodoListAsync(searchDto); return(page); }
public async Task <IActionResult> TodoList(int pageIndex = 1, int pageSize = 10) { WorkFlowTodoSearchDto searchDto = new WorkFlowTodoSearchDto { PageIndex = pageIndex, PageSize = pageSize, UserId = UserIdentity.UserId.ToString() }; var page = await _workFlowInstanceService.GetUserTodoListAsync(searchDto); return(View(page)); }
public static string GetUserTodoListAsync(string baseUri, WorkFlowTodoSearchDto searchDto) => $"{baseUri}/WorkFlowInstance/GetUserTodoListAsync?{searchDto.ToUrlParam()}";
public async Task <Page <UserWorkFlowDto> > GetUserTodoListAsync([FromQuery] WorkFlowTodoSearchDto searchDto) { return(await _workFlowInstanceService.GetUserTodoListAsync(searchDto)); }