public async Task <IActionResult> JournalGetChild(JournalGridOptions options, [FromBody] int parentId) { var grid = new ActionGrid <JournalGrid, JournalGridModel, JournalGridFilter>(_db.Connection, options) { MapResult = (row, result) => { result["id"] = parentId + "E_" + row.Id; result.Add("parentId", "M_" + parentId); result.Add("childCount", row.Count); result.Add("hasInspection", row.HasInspection); } }; return(Ok(await grid.GetChildRows(Sql.SqlQueryCach["Journal.GridGetChildByParentId"], parentId))); }
public async Task <IActionResult> Journal(JournalGridOptions options, CommandType command) { if (command == CommandType.Save) { return(Ok()); } if (command == CommandType.Clear) { options.Page = 1; options.Filter = new JournalFilter(); options.SetSortOptionsDefault(); options.SetSelectedRowsDefault(); } var filter = new JournalGridFilter(); filter.Init(options.Filter); if (filter.IsEmptyFilter()) { options.SetSelectedRowsDefault(); } //var user = await _authService.GetCurrentUser(); //filter.ApplyPermission(user); if (command == CommandType.None || command == CommandType.Clear) { filter.Configure(); } var grid = new ActionGrid <JournalGrid, JournalGridModel, JournalFilter>(_db.Connection, options, filter) { MapResult = (row, result) => { var rowId = row.HasInspection ? "M_" + row.Id : "E_" + row.Id; result["id"] = rowId; result.Add("parentId", null); result.Add("childCount", row.Count); result.Add("hasInspection", row.HasInspection); //result.Add("isSelected", options.IsSelectedRow(rowId)); } }; filter.IsEmptyFilter(); var data = await grid.Render(); if (command == CommandType.Page) { return(Ok(new { isEmptyFilter = filter.IsEmptyFilter(), DataSource = data, })); } return(Ok(new { FilterInfo = filter.GetVisibleFilters(options.VisibleFilters), Filter = options.Filter, isEmptyFilter = filter.IsEmptyFilter(), SortOptions = options.SortOptions, AllColumns = grid.GetAllColumns, VisibleColumns = grid.GetVisibleColumns, DataSource = data, IsSelectedAll = options.IsSelectedAll, SelectedRows = grid.GetSelectedRows, Data = new { DataSource = await _commonService.GetAllReference() } })); }