public IActionResult Cates(AssetSearchParam param) { InitUi(param); //param.IsContainSubDept = true; //var list = _service.GetCateGroup(param); //return View(list); var sData = _reportService.CateSummary(); var cates = AssetCateUtil.All(); //var data = from d in sData // join cate in cates on d.Id equals cate.Id into dds // from dd in dds.DefaultIfEmpty() // select new StringSummaryDto() // { // Property = ShowName(dd.Name, dd.Level), // Num = d.Num // }; var data = from cate in cates join dto in sData on cate.Id equals dto.Id into dds from dd in dds.DefaultIfEmpty() select new StringSummaryDto() { Property = ShowName2(cate.Name, cate.Level), Num = dd?.Num ?? 0 }; return(View("Cate2", data.ToList())); }
public JsonResult GetAssets(int cateId = 0, string key = "", int?deptId = null) { var service = new AssetService(); 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; } var assets = service.ListDto(param); return(Json(ResultUtil.Success(assets))); }
public ActionResult ExportDepts(AssetSearchParam param) { param.IsContainSubDept = true; var list = _service.GetDeptGroup(param); var path = GetDetails(list, "部门资产清单"); return(Redirect(path)); }
public IActionResult Accounts(AssetSearchParam param) { InitUi(param); param.IsContainSubDept = true; var list = _service.GetAccountGroup(param); return(View("Accounts", list)); }
public JsonResult GetAssets(AssetSearchParam param, int stockId, int pageIndex = 1, int pageSize = 50) { var util = param.ToSearchUtil(); util.And("Id NOT IN (SELECT AssetId FROM Asset_StockItem WHERE StockId=" + stockId.ToString() + ")"); var db = new MyDbUtil(); var list = db.Query <AssetDto>(util, pageIndex, pageSize, "AssetView"); return(Json(ResultUtil.PageList(list))); }
public IActionResult Healthy(AssetSearchParam param) { InitUi(param); //param.IsContainSubDept = true; //var list = _service.GetHealthyGroup(param); //return View("Healthy", list); var sData = _reportService.HealthySummary(); return(View("Healthy2", sData)); }
public IActionResult States(AssetSearchParam param) { InitUi(param); //param.IsContainSubDept = true; //var list = _service.GetStateGroup(param); //return View("States", list); var sData = _reportService.StateSummary(); return(View("State2", sData)); }
public ActionResult Assets(int id) { var dept = DeptUtil.Get(id); if (dept == null) { return(new EmptyResult()); } ViewBag.DeptName = dept.Name; var param = new AssetSearchParam { DeptId = id, IsContainSubDept = true }; var assets = new AssetService().ListDto(param); return(View(assets)); }
public ActionResult Assets(int id) { var account = _service.Load(id); if (account == null) { return(new EmptyResult()); } ViewBag.AccountName = account.Name; var param = new AssetSearchParam { AccountId = id }; var assets = new AssetService().ListDto(param); return(View(assets)); }
private void InitUi(AssetSearchParam param) { // 状态 ViewBag.States = AssetParameters.States.ToSelectList(param.State); // 健康度 ViewBag.Healthy = AssetParameters.Healthy.ToSelectList(param.Healthy); // 分类 var cates = AssetCateUtil.All(); var cateItems = new List <SelectListItem>(); foreach (var c in cates) { cateItems.Add(new SelectListItem { Text = ShowName(c.Name, c.Level), Value = c.Id.ToString(), Selected = (param.CateId == c.Id) }); } ViewBag.Cates = cateItems; ViewBag.Depts = DeptUtil.GetSelectList().ToSelectList("Id", "Name", param.DeptId.ToString()); }
public IActionResult Depts(AssetSearchParam param) { InitUi(param); //param.IsContainSubDept = true; //var list = _service.GetDeptGroup(param); //return View("Depts", list); var sData = _reportService.DeptSummary(); var depts = DeptUtil.All(); var data = from cate in depts join dto in sData on cate.Id equals dto.Id into dds from dd in dds.DefaultIfEmpty() select new StringSummaryDto() { Property = ShowName2(cate.Name, cate.Level), Num = dd?.Num ?? 0 }; return(View("Dept2", data.ToList())); }
public JsonResult GetScrapts(AssetSearchParam param, int pageIndex = 1, int pageSize = 20) { var pageList = _service.ScrapAssets(param, pageIndex, pageSize); return(Json(ResultUtil.PageList(pageList))); }
public JsonResult Get(AssetSearchParam param, int pageIndex = 1, int pageSize = 20) { var list = _service.PageListDto(param, pageIndex, pageSize); return(Json(ResultUtil.PageList(list))); }