public List <AssetSelectDto> FetchSelectDto(int cateId = 0, string key = "", int?deptId = null)
{
var param = new AssetSearchParam();
if (cateId > 0)
{
param.CateId = cateId;
}
if (deptId.HasValue)
{
if (deptId > 0)
{
param.IsContainSubDept = true;
param.DeptId = deptId;
}
else
{
param.IsContainSubDept = false;
param.DeptId = 0;
}
}
if (!string.IsNullOrWhiteSpace(key))
{
param.Key = key;
}
return(db.Fetch <AssetSelectDto>(param.ToSearchUtil(), "Asset_Asset", "Id, Name, Code, State").ToList());
}
public List <AssetGroupDto> GetDeptGroup(AssetSearchParam param)
{
var all = ListDto(param).ToList();
var groups = all.Select(a => a.DeptName).Distinct();
return(groups.Select(g => new AssetGroupDto
{
GroupName = string.IsNullOrWhiteSpace(g) ? "闲置物品" : g, Assets = all.Where(a => a.DeptName == g).ToList()
}).ToList());
}
public IEnumerable <AssetDto> ListDto(AssetSearchParam param = null, string cols = "*")
{
if (param == null)
{
param = new AssetSearchParam();
}
var util = param.ToSearchUtil();
return(db.Fetch <AssetDto>(util, table: "AssetView", cols: cols));
}
public PageList <AssetDto> PageListDto(AssetSearchParam param = null, int pageIndex = 1, int pageSize = 20, string cols = "*")
{
if (param == null)
{
param = new AssetSearchParam();
}
var util = param.ToSearchUtil();
return(db.Query <AssetDto>(util, pageIndex, pageSize, "AssetView", cols));
}
public List <AssetGroupDto> GetCateGroup(AssetSearchParam param)
{
var all = ListDto(param).ToList();
var groups = all.Select(a => a.AssetCateId).Distinct();
var cates = AssetCateUtil.All();
return(groups.Select(g => new AssetGroupDto
{
GroupId = g,
GroupName = cates.SingleOrDefault(c => c.Id == g)?.Name,
Assets = all.Where(a => a.AssetCateId == g).ToList()
}).ToList());
}
public List <AssetGroupDto> GetHealthyGroup(AssetSearchParam param)
{
var all = ListDto(param).ToList();
var groups = all.Select(a => a.Healthy).Distinct();
return(groups.Select(g =>
{
var dto = new AssetGroupDto
{
Assets = all.Where(a => a.Healthy == g).ToList(),
GroupName = string.IsNullOrWhiteSpace(g) ? "其他" : g
};
return dto;
}).ToList());
}
public PageList <AssetDto> ScrapAssets(AssetSearchParam param, int pageIndex, int pageSize)
{
param.State = "报废";
param.IncludeScrap = true;
return(db.Query <AssetDto>(param.ToSearchUtil(), pageIndex, pageSize, "AssetView"));
}
