public async Task <PageResultModel <Letter> > GetManagerReceiveLetters(LetterPageSerchModel pageSearch)
{
var query = _dbContext.Letters.Include(a => a.SendDepartment).Include(a => a.ReceiveDepartment).Include(a => a.CreateUser).Where(a => a.LetterType == EnumLetterType.收信);
if (pageSearch.BeginTime != null)
{
query = query.Where(a => a.CreateTime >= pageSearch.BeginTime.Value);
}
if (pageSearch.EndTime != null)
{
query = query.Where(a => a.CreateTime <= pageSearch.EndTime.Value);
}
if (!string.IsNullOrWhiteSpace(pageSearch.LetterNo))
{
query = query.Where(a => a.LetterNo.Contains(pageSearch.LetterNo));
}
if (pageSearch.SendDepartmentId != 0)
{
query = query.Where(a => a.SendDepartmentId == pageSearch.SendDepartmentId);
}
if (!string.IsNullOrWhiteSpace(pageSearch.ShiJiNo))
{
query = query.Where(a => a.ShiJiCode.Contains(pageSearch.ShiJiNo));
}
return(new PageResultModel <Letter>
{
Rows = await query.OrderByDescending(a => a.Id).Skip(pageSearch.Skip).Take(pageSearch.Take).ToListAsync(),
Total = await query.CountAsync()
});
}
public async Task <IActionResult> GetSearchList(int draw, int start, int length)
{
var pageSearchDto = new LetterPageSerchModel
{
Take = length,
Skip = start
};
pageSearchDto.SetTimeValue(Request.Query["beginTime"], Request.Query["endTime"]);
if (!string.IsNullOrWhiteSpace(Request.Query["sendDepartmentId"]))
{
pageSearchDto.SendDepartmentId = Convert.ToInt32(Request.Query["sendDepartmentId"]);
}
if (!string.IsNullOrWhiteSpace(Request.Query["receiveDepartmentId"]))
{
pageSearchDto.ReceiveDepartmentId = Convert.ToInt32(Request.Query["receiveDepartmentId"]);
}
pageSearchDto.ShiJiNo = Request.Query["shiJiNo"];
pageSearchDto.LetterNo = Request.Query["letterNo"];
var pagereslut = await _letterAppService.GetSearchLetters(pageSearchDto);
var json = new
{
draw,
recordsTotal = pagereslut.Total,
recordsFiltered = pagereslut.Total,
data = pagereslut.Rows
};
return(Json(json));
}
public async Task <PageResultModel <Letter> > GetReceiveLetters(LetterPageSerchModel pageSearch)
{
//父级单位可以查询子单位的信件
var query = _dbContext.Letters.Include(a => a.SendDepartment).Include(a => a.ReceiveDepartment)
.Include(a => a.CreateUser)
.Join(_dbContext.BarcodeLogs, l => l.ReceiveDepartmentId, bl => bl.DepartmentId, (l, bl) => new { l, bl })
.Where(a => a.bl.BarcodeStatus == EnumBarcodeStatus.已签收);
if (pageSearch.BeginTime != null)
{
query = query.Where(a => a.bl.OperationTime >= pageSearch.BeginTime.Value);
}
if (pageSearch.EndTime != null)
{
query = query.Where(a => a.bl.OperationTime <= pageSearch.EndTime.Value);
}
if (!string.IsNullOrWhiteSpace(pageSearch.LetterNo))
{
query = query.Where(a => a.l.LetterNo.Contains(pageSearch.LetterNo));
}
if (pageSearch.SendDepartmentId != 0)
{
query = query.Where(a => a.l.SendDepartmentId == pageSearch.SendDepartmentId);
}
if (!string.IsNullOrWhiteSpace(pageSearch.ShiJiNo))
{
query = query.Where(a => a.l.ShiJiCode.Contains(pageSearch.ShiJiNo));
}
var newQuery = query.Select(a => a.l);
return(new PageResultModel <Letter>
{
Rows = await newQuery.Skip(pageSearch.Skip).Take(pageSearch.Take).ToListAsync(),
Total = await newQuery.CountAsync()
});
}
public async Task <PageResultModel <LetterSendListDto> > GetSendLetters(LetterPageSerchModel pageSearchModel)
{
var letters = await _letterRepository.GetSendLetters(pageSearchModel);
return(Mapper.Map <PageResultModel <LetterSendListDto> >(letters));
}
public async Task <PageResultModel <LetterReceiveListDto> > GetReceiveLetters(LetterPageSerchModel pageSearchModel)
{
PageResultModel <Letter> letters;
if (_commonSettings.Value.ReceiveDepartmentId == pageSearchModel.ReceiveDepartmentId)
{
letters = await _letterRepository.GetManagerReceiveLetters(pageSearchModel);
}
else
{
letters = await _letterRepository.GetReceiveLetters(pageSearchModel);
}
return(Mapper.Map <PageResultModel <LetterReceiveListDto> >(letters));
}