public async Task <PageResultModel <BillDto> > GetBills(PageSearchCommonModel pageSearch)
{
var departmentIds = new List <int> {
pageSearch.DepartmentId
};
var warden = await _placeWardenRepository.GetQueryable().Include(a => a.Place).FirstOrDefaultAsync(a => a.UserId == pageSearch.UserId);
if (warden != null)
{
departmentIds.Add(warden.Place.DepartmentId);
}
var queryable = _exchangeListRepository.GetQueryable().Include(a => a.CreateUser).Where(a => departmentIds.Contains(a.DepartmentId));
if (!string.IsNullOrWhiteSpace(pageSearch.Keywords))
{
queryable = queryable.Where(a =>
a.ListNo.Contains(pageSearch.Keywords) || a.ObjectName.Contains(pageSearch.Keywords) ||
a.ExchangeUserName.Contains(pageSearch.Keywords));
}
var pageResult = new PageResultModel <ExchangeList>
{
Rows = await queryable.OrderByDescending(a => a.Id).Skip(pageSearch.Skip).Take(pageSearch.Take).ToListAsync(),
Total = await queryable.CountAsync()
};
return(Mapper.Map <PageResultModel <BillDto> >(pageResult));
}
public async Task <IActionResult> SearchCancelLetters(int draw, int start, int length)
{
var placeId = await _placeAppService.GetPlaceId(CurrentUser.UserId);
var pageSearchDto = new PageSearchCommonModel
{
DepartmentId = CurrentUser.DepartmentId,
Keywords = Request.Query["letterNo"],
Take = length,
Skip = start,
PlaceId = placeId
};
var pageReslut = string.IsNullOrWhiteSpace(pageSearchDto.Keywords) ? new PageResultModel <LetterCancelListDto> {
Rows = new List <LetterCancelListDto>()
} : await _letterAppService.GetCancelLettersForSearch(pageSearchDto);
var json = new
{
draw,
recordsTotal = pageReslut.Total,
recordsFiltered = pageReslut.Total,
data = pageReslut.Rows
};
return(Json(json));
}
public async Task <PageResultModel <Letter> > GetBackLettersForSearch(PageSearchCommonModel pageSearchModel)
{
var query = _dbContext.Letters.Include(a => a.SendDepartment).Include(a => a.ReceiveDepartment).Include(a => a.CreateUser).Where(a => a.ReceiveDepartmentId == pageSearchModel.DepartmentId && a.BarcodeNo.Contains(pageSearchModel.Keywords));
return(new PageResultModel <Letter>
{
Rows = await query.OrderByDescending(a => a.Id).Skip(pageSearchModel.Skip).Take(pageSearchModel.Take).OrderByDescending(a => a.Id).ToListAsync(),
Total = await query.CountAsync()
});
}
public async Task <PageResultModel <Letter> > GetTodaySendLetters(PageSearchCommonModel pageSearchModel)
{
var query = _dbContext.Letters.Include(a => a.SendDepartment).Include(a => a.ReceiveDepartment).Include(a => a.CreateUser).Where(a =>
(a.LetterType == EnumLetterType.发信 || a.LetterType == EnumLetterType.内交换) && a.SendDepartmentId == pageSearchModel.DepartmentId && a.CreateTime.Date == DateTime.Now.Date);
return(new PageResultModel <Letter>
{
Rows = await query.OrderByDescending(a => a.Id).Skip(pageSearchModel.Skip).Take(pageSearchModel.Take).ToListAsync(),
Total = await query.CountAsync()
});
}
public async Task <PageResultModel <Group> > GetPagingAysnc(PageSearchCommonModel pageSearchModel)
{
var query = _dbContext.Groups.Include(a => a.CreateUser).Include(a => a.UpdateUser).Where(a => true);
if (!string.IsNullOrWhiteSpace(pageSearchModel.Keywords))
{
query = query.Where(a => a.Name.Contains(pageSearchModel.Keywords));
}
return(new PageResultModel <Group>
{
Rows = await query.OrderByDescending(a => a.Id).Skip(pageSearchModel.Skip).Take(pageSearchModel.Take).ToListAsync(),
Total = await query.CountAsync()
});
}
public async Task <PageResultModel <ExchangeObject> > GetPagingAysnc(PageSearchCommonModel pageSearchModel)
{
var queryable = _dbContext.ExchangeObjects.Include(a => a.CreateUser).Include(a => a.UpdateUser).Include(a => a.Parent).Where(a => true);
if (!string.IsNullOrWhiteSpace(pageSearchModel.Keywords))
{
queryable = queryable.Where(a => a.Name.Contains(pageSearchModel.Keywords) || a.ValueText.Contains(pageSearchModel.Keywords) || a.Parent.Name.Contains(pageSearchModel.Keywords));
}
return(new PageResultModel <ExchangeObject>
{
Rows = await queryable.OrderByDescending(a => a.Id).Skip(pageSearchModel.Skip).Take(pageSearchModel.Take).ToListAsync(),
Total = await queryable.CountAsync()
});
}
public async Task <PageResultModel <Place> > GetPagingAysnc(PageSearchCommonModel pageSearchModel)
{
var query = _dbContext.Places.Include(a => a.Department).Include(a => a.Parent).Include(a => a.CreateUser).Include(a => a.UpdateUser).Where(a => true);
if (!string.IsNullOrWhiteSpace(pageSearchModel.Keywords))
{
query = query.Where(a => a.Name.Contains(pageSearchModel.Keywords));
}
var pageResultEntity = new PageResultModel <Place>
{
Total = await query.CountAsync(),
Rows = await query.OrderByDescending(a => a.Id).Take(pageSearchModel.Take).Skip(pageSearchModel.Skip).ToListAsync()
};
return(pageResultEntity);
}
public async Task <PageResultModel <SortingListDto> > GetSortingLists(PageSearchCommonModel pageSearch)
{
var sortings = _sortingListRepository.GetQueryable().Include(a => a.CreateUser).Include(a => a.UpdateUser).Where(a => true);
if (!string.IsNullOrWhiteSpace(pageSearch.Keywords))
{
sortings = sortings.Where(a => a.ListNo.Contains(pageSearch.Keywords));
}
var pageResult = new PageResultModel <SortingList>
{
Rows = await sortings.OrderByDescending(a => a.Id).Skip(pageSearch.Skip).Take(pageSearch.Take).ToListAsync(),
Total = await sortings.CountAsync()
};
return(Mapper.Map <PageResultModel <SortingListDto> >(pageResult));
}
/// <summary>
/// 分页获取用户列表
/// </summary>
/// <param name="pageSearchModel"></param>
/// <returns></returns>
public async Task <PageResultModel <User> > GetPagingAysnc(PageSearchCommonModel pageSearchModel)
{
var query = _dbContext.Users.Include(a => a.CreateUser).Include(a => a.UpdateUser)
.Include(a => a.Department).Where(a => true);
if (!string.IsNullOrEmpty(pageSearchModel.Keywords))
{
query = query.Where(a => a.DisplayName.Contains(pageSearchModel.Keywords) || a.UserName.Contains(pageSearchModel.Keywords));
}
var pageResult = new PageResultModel <User>
{
Total = await query.CountAsync(),
Rows = await query.OrderByDescending(a => a.Id).Skip(pageSearchModel.Skip).Take(pageSearchModel.Take).ToListAsync()
};
return(pageResult);
}
public async Task <PageResultModel <Letter> > GetCancelLettersForSearch(PageSearchCommonModel pageSearchModel)
{
var inboxBarcode = await _dbContext.Barcodes
.Where(a => a.BarcodeNo.Contains(pageSearchModel.Keywords) && a.Status == EnumBarcodeStatus.已投递 &&
a.CurrentPlaceId == pageSearchModel.PlaceId).OrderBy(a => a.Id).Skip(pageSearchModel.Skip).Take(pageSearchModel.Take).Select(a => a.BarcodeNo).ToListAsync();
var inboxBarcodeCount = await _dbContext.Barcodes
.Where(a => a.BarcodeNo.Contains(pageSearchModel.Keywords) && a.Status == EnumBarcodeStatus.已投递 &&
a.CurrentPlaceId == pageSearchModel.PlaceId).CountAsync();
var letters = await _dbContext.Letters.Include(a => a.SendDepartment).Include(a => a.ReceiveDepartment).Include(a => a.CreateUser).Where(a => inboxBarcode.Contains(a.BarcodeNo)).ToListAsync();
return(new PageResultModel <Letter>
{
Rows = letters,
Total = inboxBarcodeCount
});
}
public async Task <PageResultModel <Letter> > GetCancelLetters(PageSearchCommonModel pageSerch)
{
var query = from letter in _dbContext.Letters.Include(a => a.CreateUser).Include(a => a.SendDepartment).Include(a => a.ReceiveDepartment)
join cancelLetter in _dbContext.CancelLetters on letter.Id equals cancelLetter.LetterId
where cancelLetter.OperationDepartmentId == pageSerch.DepartmentId || cancelLetter.ApplicantId == pageSerch.UserId
select letter;
if (!string.IsNullOrWhiteSpace(pageSerch.Keywords))
{
query = query.Where(a => a.LetterNo.Contains(pageSerch.Keywords));
}
return(new PageResultModel <Letter>
{
Rows = await query.OrderByDescending(a => a.Id).Skip(pageSerch.Skip).Take(pageSerch.Take).ToListAsync(),
Total = await query.Select(a => a).CountAsync()
});
}
public async Task <PageResultModel <Department> > GetPagingAysnc(PageSearchCommonModel pageSearchModel)
{
var query = _dbContext.Departments.Include(a => a.Parent).Include(a => a.CreateUser).Include(a => a.UpdateUser).Where(a => a.ParentId == pageSearchModel.ParentId);
if (!string.IsNullOrWhiteSpace(pageSearchModel.Keywords))
{
query = query.Where(q =>
q.Name.Contains(pageSearchModel.Keywords) || q.FullName.Contains(pageSearchModel.Keywords) || q.Code.Contains(pageSearchModel.Keywords));
}
var pageResultEntity = new PageResultModel <Department>
{
Total = await query.CountAsync(),
Rows = await query.OrderBy(a => a.Sort).Skip(pageSearchModel.Skip).Take(pageSearchModel.Take).ToListAsync()
};
return(pageResultEntity);
}
public async Task <PageResultModel <BackUpListDto> > GetPagingAysnc(PageSearchCommonModel pageSearchDto)
{
var queryable = _backUpRepository.GetQueryable();
if (!string.IsNullOrWhiteSpace(pageSearchDto.Keywords))
{
queryable = queryable.Where(a => a.FileName.Contains(pageSearchDto.Keywords));
}
var backups = await queryable.OrderByDescending(a => a.Id).Skip(pageSearchDto.Skip).Take(pageSearchDto.Take)
.ToListAsync();
return(new PageResultModel <BackUpListDto>
{
Rows = Mapper.Map <IList <BackUpListDto> >(backups),
Total = await queryable.CountAsync()
});
}
public async Task <PageResultModel <Card> > GetPagingAysnc(PageSearchCommonModel pageSearchModel)
{
var query = _dbContext.Cards.Include(a => a.CreateUser).Include(a => a.UpdateUser).Include(a => a.User).Where(a => true);
if (!string.IsNullOrWhiteSpace(pageSearchModel.Keywords))
{
query = query.Where(a =>
a.Number.Contains(pageSearchModel.Keywords) || a.Value.Contains(pageSearchModel.Keywords) ||
a.User.DisplayName.Contains(pageSearchModel.Keywords));
}
if (pageSearchModel.ParentId != null)
{
query = query.Where(a => a.User.DepartmentId == pageSearchModel.DepartmentId);
}
return(new PageResultModel <Card>
{
Rows = await query.OrderByDescending(a => a.Id).Skip(pageSearchModel.Skip).Take(pageSearchModel.Take).ToListAsync(),
Total = await query.CountAsync()
});
}
public async Task <IActionResult> GetGroups(int draw, int start, int length)
{
var keywords = Request.Query["search[value]"];
var pageSearchDto = new PageSearchCommonModel
{
Keywords = keywords,
Take = length,
Skip = start
};
var pagereslut = await _groupAppService.GetPagingAysnc(pageSearchDto);
var json = new
{
draw,
recordsTotal = pagereslut.Total,
recordsFiltered = pagereslut.Total,
data = pagereslut.Rows
};
return(Json(json));
}
public async Task <JsonResult> GetListForTable(int draw, int start, int length, int?parentId)
{
var keywords = Request.Query["search[value]"];
var pageSearchDto = new PageSearchCommonModel
{
Keywords = keywords,
ParentId = parentId == 0 ? null : parentId,
Take = length,
Skip = start
};
var pagereslut = await _menuAppService.GetPagingAysnc(pageSearchDto);
var json = new
{
draw,
recordsTotal = pagereslut.Total,
recordsFiltered = pagereslut.Total,
data = pagereslut.Rows
};
return(Json(json));
}
public async Task <PageResultModel <CardListDto> > GetPagingAysnc(PageSearchCommonModel pageSearchDto)
{
var user = await _userRepository.GetByIdAsync(pageSearchDto.UserId);
if (!"sysadmin,secadmin,audadmin".Contains(user.UserName))
{
var placeWarden = await _placeWardenRepository.GetQueryable().Include(a => a.Place).Where(a => a.UserId == pageSearchDto.UserId)
.FirstOrDefaultAsync();
if (placeWarden != null)
{
pageSearchDto.DepartmentId = placeWarden.Place.DepartmentId;
}
else
{
return(new PageResultModel <CardListDto>());
}
}
var cards = await _cardRepository.GetPagingAysnc(pageSearchDto);
return(Mapper.Map <PageResultModel <CardListDto> >(cards));
}
public async Task <IActionResult> GetBackLetters(int draw, int start, int length)
{
var keywords = Request.Query["search[value]"];
var pageSearchDto = new PageSearchCommonModel
{
DepartmentId = CurrentUser.DepartmentId,
Keywords = keywords,
Take = length,
Skip = start
};
var pagereslut = await _letterAppService.GetBackLetters(pageSearchDto);
var json = new
{
draw,
recordsTotal = pagereslut.Total,
recordsFiltered = pagereslut.Total,
data = pagereslut.Rows
};
return(Json(json));
}
public async Task <PageResultModel <ClientListDto> > GetPagingAysnc(PageSearchCommonModel pageSearchDto)
{
var clients = await _clientRepository.GetPagingAysnc(pageSearchDto);
return(Mapper.Map <PageResultModel <ClientListDto> >(clients));
}
public async Task <PageResultModel <RoleListDto> > GetPagingAysnc(PageSearchCommonModel pageSearchDto)
{
var roles = await _roleRepository.GetPagingAysnc(pageSearchDto);
return(Mapper.Map <PageResultModel <RoleListDto> >(roles));
}
public async Task <PageResultModel <RuleListDto> > GetPagingAysnc(PageSearchCommonModel pageSearchDto)
{
return(Mapper.Map <PageResultModel <RuleListDto> >(await _ruleRepository.GetPagingAysnc(pageSearchDto)));
}
public async Task <PageResultModel <PlaceListDto> > GetPagingAysnc(PageSearchCommonModel pageSearchDto)
{
var pageResult = await _placeRepository.GetPagingAysnc(pageSearchDto);
return(Mapper.Map <PageResultModel <PlaceListDto> >(pageResult));
}
public async Task <PageResultModel <MenuListDto> > GetPagingAysnc(PageSearchCommonModel pageSearchDto)
{
var pageResult = await _menuRepository.GetPagingAysnc(pageSearchDto.ParentId, pageSearchDto.Take, pageSearchDto.Skip, pageSearchDto.Keywords);
return(Mapper.Map <PageResultModel <MenuListDto> >(pageResult));
}
public async Task <PageResultModel <ExchangeObjectListDto> > GetPagingAysnc(PageSearchCommonModel pageSearchDto)
{
var exchangeObjects = await _exchangeObjectRepository.GetPagingAysnc(pageSearchDto);
return(Mapper.Map <PageResultModel <ExchangeObjectListDto> >(exchangeObjects));
}
public async Task <PageResultModel <LetterBackListDto> > GetBackLetters(PageSearchCommonModel pageSearchModel)
{
var letters = await _backLetterRepository.GetBackLetters(pageSearchModel);
return(Mapper.Map <PageResultModel <LetterBackListDto> >(letters));
}
public async Task <PageResultModel <LetterBackListDto> > GetBackLettersForSearch(PageSearchCommonModel pageSearchModel)
{
PageResultModel <Letter> letters;
letters = await _letterRepository.GetBackLettersForManagerSearch(pageSearchModel);
return(Mapper.Map <PageResultModel <LetterBackListDto> >(letters));
}
public async Task <PageResultModel <LetterCancelListDto> > GetCancelLettersForSearch(PageSearchCommonModel pageSearchModel)
{
var letters = await _letterRepository.GetCancelLettersForSearch(pageSearchModel);
return(Mapper.Map <PageResultModel <LetterCancelListDto> >(letters));
}
public async Task <PageResultModel <LetterReceiveListDto> > Out2InsideLetters(PageSearchCommonModel pageSearch)
{
var barcodeLogs = await _barcodeLogRepository.GetQueryable().Where(a =>
a.OperationTime.Date == DateTime.Now.Date &&
a.BarcodeStatus == EnumBarcodeStatus.已投递 &&
a.CurrentPlaceId == _commonSettings.Value.RootPlaceId).ToListAsync();
var letters = _letterRepository.GetQueryable().Include(a => a.ReceiveDepartment).Include(a => a.SendDepartment)
.Where(a => a.LetterType == EnumLetterType.收信 && barcodeLogs.Exists(b => b.BarcodeNumber == a.BarcodeNo));
var pageResult = new PageResultModel <Letter>
{
Rows = await letters.OrderByDescending(a => a.Id).Skip(pageSearch.Skip).Take(pageSearch.Take).ToListAsync(),
Total = await letters.CountAsync()
};
return(Mapper.Map <PageResultModel <LetterReceiveListDto> >(pageResult));
}
public async Task <PageResultModel <GroupListDto> > GetPagingAysnc(PageSearchCommonModel pageSearchDto)
{
var groups = await _groupRepository.GetPagingAysnc(pageSearchDto);
return(Mapper.Map <PageResultModel <GroupListDto> >(groups));
}
public Task <PageResultModel <BarcodeLog> > GetPagingAysnc(PageSearchCommonModel pageSearchModel)
{
throw new NotImplementedException();
}
