public IActionResult List(PesticideRequestPayload payload)
{
var query = from p in _dbITMContext.Samples
join o in _dbITMContext.Orgs
on p.OrganizationId equals o.OrganizationId
select new
{
p.Id,
p.SampleName,
p.MealTimeName,
SampledAt = Convert.ToDateTime(p.SampledAt).ToString("yyyy-MM-dd HH:mm:ss"),
p.Weight,
p.Hours,
p.FoodName,
p.AuditorName,
p.Note, //备注
p.Img, //图片
o.SchoolName
};
if (!string.IsNullOrEmpty(AuthContextService.CurrentUser.SchoolName))
{
query = query.Where(x => x.SchoolName == AuthContextService.CurrentUser.SchoolName);
}
query = query.OrderByDescending(x => x.Id);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
public IActionResult aList(PesticideRequestPayload payload)
{
var entity = _dbITMContext.Disinfections.FirstOrDefault(x => x.Id.ToString() == payload.Kw);
var query = from i in _dbITMContext.Disinfections
join o in _dbITMContext.DisinfectionRecords
on i.DisinfectionId equals o.DisinfectionId
select new
{
o.Id,
o.TypeName,
o.Method,
o.Number,
o.RoomName,
o.ToolName,
o.DisinfectionId,
o.OwnerDisinfectionId
};
if (entity.DisinfectionId != 0)
{
query = query.Where(x => x.DisinfectionId == entity.DisinfectionId);
}
else
{
query = query.Where(x => x.OwnerDisinfectionId.ToString() == payload.Kw);
}
query = query.OrderByDescending(x => x.Id);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
public IActionResult List(PesticideRequestPayload payload)
{
var query = from p in _dbITMContext.Pesticides
join o in _dbITMContext.Orgs
on p.OrganizationId equals o.OrganizationId
select new
{
p.Id,
p.UserName, //登记人员
CreatedAt = Convert.ToDateTime(p.CreatedAt).ToString("yyyy-MM-dd HH:mm:ss"), //登记时间
p.Inspector, //检测人员
CheckedAt = Convert.ToDateTime(p.CheckedAt).ToString("yyyy-MM-dd HH:mm:ss"), //检测时间
p.VegetablesName, //果蔬品名
InspectionOrder = p.InspectionOrder == 0 ? "清洗前" : "清洗后", //检测次序
InspectionResult = p.InspectionResult == 0 ? "阴性" : "阳性", //检测结果
HandleMeasure = p.HandleMeasure == 0?"正常使用":"暂停使用", //处理结果
p.Note, //备注
p.TestPaper, //检测结果图片
o.SchoolName
};
if (!string.IsNullOrEmpty(AuthContextService.CurrentUser.SchoolName))
{
query = query.Where(x => x.SchoolName == AuthContextService.CurrentUser.SchoolName);
}
query = query.OrderByDescending(x => x.Id);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
public IActionResult List(PesticideRequestPayload payload)
{
var query = from p in _dbITMContext.Synthesizes
join o in _dbITMContext.Orgs
on p.OrganizationId equals o.OrganizationId
select new
{
p.Id,
p.SynthesizeId,
p.SubjectName,
CreatedAt = Convert.ToDateTime(p.CreatedAt).ToString("yyyy-MM-dd HH:mm:ss"),
p.DepartmentName,
p.Introduce,
p.ContinueTime,
o.SchoolName
};
if (!string.IsNullOrEmpty(AuthContextService.CurrentUser.SchoolName))
{
query = query.Where(x => x.SchoolName == AuthContextService.CurrentUser.SchoolName);
}
query = query.OrderByDescending(x => x.Id);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
public IActionResult List(PesticideRequestPayload payload)
{
var query = from p in _dbITMContext.Wastes
join o in _dbITMContext.Orgs
on p.OrganizationId equals o.OrganizationId
select new
{
p.Id,
HandleDate = Convert.ToDateTime(p.HandleDate).ToString("yyyy-MM-dd HH:mm:ss"),
p.NewHandlerName,
p.FullName,
p.Receiver,
p.ReceiverIdentityCard,
p.SwillNumber,
p.WasteoilNumber,
p.OtherWasteNumber,
o.SchoolName
};
if (!string.IsNullOrEmpty(AuthContextService.CurrentUser.SchoolName))
{
query = query.Where(x => x.SchoolName == AuthContextService.CurrentUser.SchoolName);
}
query = query.OrderByDescending(x => x.Id);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
public IActionResult aList(PesticideRequestPayload payload)
{
var query = from p in _dbITMContext.PurchaseInformation
join o in _dbITMContext.Purchases
on p.PurchaseId equals o.PurchaseId
where o.Id.ToString() == payload.Kw
select new
{
p.Id,
p.FoodName,
p.UnitName,
CreatedAt = Convert.ToDateTime(p.CreatedAt).ToString("yyyy-MM-dd HH:mm:ss"),
p.ModelName,
p.Number,
p.OrganizationId
};
if (!string.IsNullOrEmpty(AuthContextService.CurrentUser.SchoolName))
{
var ene = _dbITMContext.Orgs.FirstOrDefault(x => x.SchoolName == AuthContextService.CurrentUser.SchoolName);
query = query.Where(x => x.OrganizationId == ene.OrganizationId);
}
query = query.OrderByDescending(x => x.Id);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
