public List <FrePasserDto> Export(QueryFrePasser queryDto)
{
var query = this._frePasserRepository.FindAll(p => p.BusinessmanCode == _code);
if (queryDto != null)
{
if (!string.IsNullOrEmpty(queryDto.Name))
{
query = query.Where(p => p.Name.Trim().Equals(queryDto.Name.Trim(), StringComparison.OrdinalIgnoreCase));
}
if (!string.IsNullOrEmpty(queryDto.AirCardNo))
{
query = query.Where(p => p.AirCardNo.Trim().Equals(queryDto.AirCardNo.Trim(), StringComparison.OrdinalIgnoreCase));
}
if (!string.IsNullOrEmpty(queryDto.CertificateNo))
{
query = query.Where(p => p.CertificateNo.Trim().Equals(queryDto.CertificateNo.Trim(), StringComparison.OrdinalIgnoreCase));
}
if (!string.IsNullOrEmpty(queryDto.CertificateType))
{
query = query.Where(p => p.CertificateType.Trim().Equals(queryDto.CertificateType.Trim(), StringComparison.OrdinalIgnoreCase));
}
if (!string.IsNullOrEmpty(queryDto.PasserType))
{
query = query.Where(p => p.PasserType.Trim().Equals(queryDto.PasserType.Trim(), StringComparison.OrdinalIgnoreCase));
}
if (!string.IsNullOrEmpty(queryDto.Mobile))
{
query = query.Where(p => p.Mobile.Trim().Equals(queryDto.Mobile.Trim(), StringComparison.OrdinalIgnoreCase));
}
}
query = query.OrderByDescending(p => p.Id);
var list = AutoMapper.Mapper.Map <List <FrePasser>, List <FrePasserDto> >(query.ToList());
return(list);
}
public DataPack <FrePasserDto> QueryFrePassers(QueryFrePasser queryDto, int pageIndex, int pageSize)
{
pageIndex = (pageIndex - 1) * pageSize;
var query = this._frePasserRepository.FindAll(p => p.BusinessmanCode == _code);
if (queryDto != null)
{
if (!string.IsNullOrEmpty(queryDto.Name))
{
query = query.Where(p => p.Name.Trim().Equals(queryDto.Name.Trim(), StringComparison.OrdinalIgnoreCase));
}
if (!string.IsNullOrEmpty(queryDto.AirCardNo))
{
query = query.Where(p => p.AirCardNo.Trim().Equals(queryDto.AirCardNo.Trim(), StringComparison.OrdinalIgnoreCase));
}
if (!string.IsNullOrEmpty(queryDto.CertificateNo))
{
query = query.Where(p => p.CertificateNo.Trim().Equals(queryDto.CertificateNo.Trim(), StringComparison.OrdinalIgnoreCase));
}
if (!string.IsNullOrEmpty(queryDto.CertificateType))
{
query = query.Where(p => p.CertificateType.Trim().Equals(queryDto.CertificateType.Trim(), StringComparison.OrdinalIgnoreCase));
}
if (!string.IsNullOrEmpty(queryDto.PasserType))
{
//手机端接口传递参数
switch (queryDto.PasserType)
{
case "1":
query = query.Where(p => p.PasserType.Trim().Equals("成人", StringComparison.OrdinalIgnoreCase));
break;
default:
query = query.Where(p => p.PasserType.Trim().Equals(queryDto.PasserType.Trim(), StringComparison.OrdinalIgnoreCase));
break;
}
}
if (!string.IsNullOrEmpty(queryDto.Mobile))
{
query = query.Where(p => p.Mobile.Trim().Equals(queryDto.Mobile.Trim(), StringComparison.OrdinalIgnoreCase));
}
}
query = query.OrderByDescending(p => p.Id);
//var list = query.Skip(pageIndex).Take(pageSize).ToList();
List <FrePasser> list = new List <FrePasser>();
if (pageSize > 0)
{
list = query.Skip(pageIndex).Take(pageSize).ToList();
}
else
{
list = query.ToList();
}
var dataPack = new DataPack <FrePasserDto>
{
TotalCount = query.Count(),
List = AutoMapper.Mapper.Map <List <FrePasser>, List <FrePasserDto> >(list)
};
return(dataPack);
}
