public async Task <ReturnPagin <List <ReturnStaffinfoDto> > > QueryPaginAsync(SelectStaffinfoDto model)
{
var result = new ReturnPagin <List <ReturnStaffinfoDto> >();
var staffInfos = _context.StaffInfos.Include(i => i.Position).AsNoTracking();
result.Items = await staffInfos.OrderByDescending(i => i.CreateTime).Pagin(model).Select(i => new ReturnStaffinfoDto
{
Id = i.Id,
Email = i.Email,
Name = i.Name,
EntryTime = i.EntryTime,
LastUpTime = i.LastUpTime,
Phone = i.Phone,
PositionName = i.Position.Name,
ResignationTime = i.ResignationTime,
WorkingStatus = i.WorkingStatus,
}).ToListAsync();
result.Count = await staffInfos.CountAsync();
result.Number = model.Number;
result.Page = model.Page;
return(result);
}
public async Task <ReturnPagin <List <ReturnSalaryDto> > > QueryPaginAsync(SelectSalaryDto model)
{
var result = new ReturnPagin <List <ReturnSalaryDto> >();
var salarys = _context.Salarys.Include(i => i.StaffInfo).AsNoTracking();
result.Items = await salarys.OrderByDescending(i => i.CreateTime).Pagin(model).Select(i => new ReturnSalaryDto
{
Id = i.Id,
StaffInfoName = i.StaffInfo.Name,
BasicSalary = i.BasicSalary,
Deduction = i.Deduction,
CreateTime = i.LastUpTime,
MealSubsidy = i.MealSubsidy,
OtherSubsidies = i.OtherSubsidies,
Reward = i.Reward,
TransportationSubsidy = i.TransportationSubsidy,
}).ToListAsync();
result.Count = await salarys.CountAsync();
result.Number = model.Number;
result.Page = model.Page;
return(result);
}
public async Task <ReturnPagin <List <ReturnProductDto> > > QueryPaginAsync(SelectProductDto model)
{
var result = new ReturnPagin <List <ReturnProductDto> >();
var products = _context.Products.AsNoTracking();
if (!string.IsNullOrEmpty(model.Name))
{
products = products.Where(i => i.Name.Contains(model.Name));
}
if (!string.IsNullOrEmpty(model.ProductNumber))
{
products = products.Where(i => i.Number.Contains(model.ProductNumber));
}
if (model.BeginPrice.HasValue)
{
products = products.Where(i => i.Price >= model.BeginPrice);
}
if (model.EndPrice.HasValue)
{
products = products.Where(i => i.Price <= model.BeginPrice);
}
if (model.BeginTime.HasValue)
{
products = products.Where(i => i.CreateTime >= model.BeginTime);
}
if (model.EndTime.HasValue)
{
products = products.Where(i => i.CreateTime <= model.EndTime);
}
result.Items = await products.OrderByDescending(i => i.CreateTime).Pagin(model).Select(i => new ReturnProductDto
{
Number = i.Number,
Price = i.Price,
LastUpTime = i.LastUpTime,
Name = i.Name,
Id = i.Id
}).ToListAsync();
result.Count = await products.CountAsync();
result.Number = model.Number;
result.Page = model.Page;
return(result);
}
public async Task <ReturnPagin <List <ReturnAttendanceDto> > > QueryPaginAsync(SelectAttendanceDto model)
{
var result = new ReturnPagin <List <ReturnAttendanceDto> >();
var attendances = _context.Attendances.Include(i => i.StaffInfo).AsNoTracking();
if (model.BeginTime.HasValue)
{
attendances = attendances.Where(i => i.CreateTime >= model.BeginTime);
}
if (model.EndTime.HasValue)
{
attendances = attendances.Where(i => i.CreateTime <= model.EndTime);
}
if (model.IsLate.HasValue)
{
attendances = attendances.Where(i => i.IsLate == model.IsLate);
}
if (model.IsLeaveEarly.HasValue)
{
attendances = attendances.Where(i => i.IsLeaveEarly == model.IsLeaveEarly);
}
if (model.StaffInfoId.HasValue)
{
attendances = attendances.Where(i => i.StaffInfoId == model.StaffInfoId);
}
result.Count = await attendances.CountAsync();
result.Page = model.Page;
result.Number = model.Number;
result.Items = await attendances.OrderByDescending(i => i.CreateTime)
.Pagin(model)
.Select(i => new ReturnAttendanceDto
{
IsLate = i.IsLate,
IsLeaveEarly = i.IsLeaveEarly,
Id = i.Id,
OffworkTime = i.OffworkTime,
StaffInfoName = i.StaffInfo.Name,
WorkingTime = i.WorkingTime
}).ToListAsync();
return(result);
}
public async Task <ReturnPagin <List <ReturnStockDto> > > QueryPaginStockAsync(SelectStockDto model)
{
var result = new ReturnPagin <List <ReturnStockDto> >();
var stocks = _context.Stocks.Include(i => i.Product).AsNoTracking();
if (model.ProductId.HasValue)
{
stocks = stocks.Where(i => i.PrductId == model.ProductId);
}
result.Count = await stocks.CountAsync();
result.Number = model.Number;
result.Page = model.Page;
result.Items = _mapper.Map <List <ReturnStockDto> >(await stocks.Pagin(model).ToListAsync());
return(result);
}
public async Task <ReturnPagin <List <ReturnDepartmentDto> > > QueryAsync(SelectDeparmentDto model)
{
var result = new ReturnPagin <List <ReturnDepartmentDto> >();
var departments = _context.Departments.AsNoTracking();
result.Items = await departments.Select(i => new ReturnDepartmentDto()
{
CreateTime = i.CreateTime,
Id = i.Id,
LastUpTime = i.LastUpTime,
Name = i.Name
}).ToListAsync();
result.Page = model.Page;
result.Number = model.Number;
result.Count = result.Items.Count;
return(result);
}
public async Task <ReturnPagin <List <ReturnCompanyScheduleDto> > > QueryAsync(SelectCompanyScheduleDto model)
{
var result = new ReturnPagin <List <ReturnCompanyScheduleDto> >();
var companys = _context.CompanySchedules.AsNoTracking();
result.Items = await companys.Select(i => new ReturnCompanyScheduleDto()
{
CreateTime = i.CreateTime,
LastUpTime = i.LastUpTime,
ScheduleTime = i.ScheduleTime,
EventName = i.EventName,
EventDetails = i.EventDetails,
Id = i.Id
}).ToListAsync();
result.Page = model.Page;
result.Number = model.Number;
result.Count = result.Items.Count;
return(result);
}
public async Task <ReturnPagin <List <ReturnPersonalScheduleDto> > > QueryAsync(SelectPersonalScheduleDto model)
{
var result = new ReturnPagin <List <ReturnPersonalScheduleDto> >();
var personalSchedules = _context.PersonalSchedules.Include(i => i.StaffInfo).AsNoTracking();
result.Items = await personalSchedules.Select(i => new ReturnPersonalScheduleDto()
{
CreateTime = i.CreateTime,
LastUpTime = i.LastUpTime,
ScheduleTime = i.ScheduleTime,
EventName = i.EventName,
EventDetails = i.EventDetails,
Id = i.Id,
UserName = i.StaffInfo.Name
}).ToListAsync();
result.Page = model.Page;
result.Number = model.Number;
result.Count = result.Items.Count;
return(result);
}
public async Task <ReturnPagin <List <ReturnPositionDto> > > QueryPaginAsync(SelectPositionDto model)
{
var result = new ReturnPagin <List <ReturnPositionDto> >();
var positions = _context.Positions.Include(i => i.Department).AsNoTracking();
result.Items = await positions.OrderByDescending(i => i.CreateTime).Pagin(model).Select(i => new ReturnPositionDto
{
DepartmentName = i.Department.Name,
Id = i.Id,
LastUpTime = i.LastUpTime,
CreateTime = i.CreateTime,
Name = i.Name
}).ToListAsync();
result.Count = await positions.CountAsync();
result.Number = model.Number;
result.Page = model.Page;
return(result);
}
public async Task <ReturnPagin <List <ReturnStockAccessDto> > > QueryPaginStockRecordAsync(SelectStockAccessDto model)
{
var result = new ReturnPagin <List <ReturnStockAccessDto> >();
var stockAccess = _context.InAndOutStockDetaileds.Include(i => i.Stock.Product).AsNoTracking();
if (model.StockId.HasValue)
{
stockAccess = stockAccess.Where(i => i.StockId == model.StockId);
}
result.Page = model.Page;
result.Number = model.Number;
result.Count = await stockAccess.CountAsync();
result.Items = await stockAccess.Select(i => new ReturnStockAccessDto
{
InAndOutStockType = i.InAndOutStockType,
Number = i.Number,
StockProductName = i.Stock.Product.Name,
SurplusStock = i.SurplusStock,
CreateTime = i.CreateTime
}).ToListAsync();
return(result);
}
