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