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")); }