public async Task <IActionResult> GetPageListJson(JqGridRequest request, int category, string condition, string keyword)
{
var data = await _dmosService.GetByWhere(category, keyword, condition, request.PageIndex, request.RecordsCount);
var dtos = CrudDtoMapper.MapEntityToDtos(data);
var organizes = await this._organizeService.GetAlls();
var departments = await _departmentService.GetAlls();
JqGridResponse response = new JqGridResponse();
foreach (DMOSViewModel userInput in dtos)
{
var organizeId = userInput.OrganizeId;
var departmentId = userInput.DepartmentId;
if (departmentId == 0)
{
userInput.OrganizeName = organizes.Where(o => o.Id == organizeId)?.FirstOrDefault()?.FullName;
}
else
{
var department = departments.Where(o => o.Id == departmentId)?.FirstOrDefault();
userInput.DepartmentName = department?.FullName;
userInput.OrganizeName = organizes.Where(o => o.Id == department?.OrganizeId)?.FirstOrDefault()?.FullName;
}
response.Records.Add(new JqGridRecord(Convert.ToString(userInput.Id), userInput));
}
response.Reader.RepeatItems = false;
return(new JqGridJsonResult(response));
}
/// <summary>
/// 获取一条记录后
/// </summary>
/// <param name="arg"></param>
protected override void OnAfterGet(DataItemViewModel arg)
{
var allDataItemDto = CrudDtoMapper.MapEntityToDtos(_readerService.GetAll());
var ids = arg.FindParentWhere(allDataItemDto.ToList(), null).Select(x => x.Id).ToArray();
arg.ParentPath = string.Join(",", ids);
}
public ActionResult GetTreeListJson(string keyword)
{
var data = _dataItemService.GetAlls();
if (!string.IsNullOrEmpty(keyword))
{
data = data.TreeWhere(t => t.ItemName.Contains(keyword));
}
JqGridResponse response = new JqGridResponse();
var dtos = CrudDtoMapper.MapEntityToDtos(data);
var TreeList = new List <TreeGridEntity>();
foreach (DataItemViewModel item in dtos)
{
TreeGridEntity tree = new TreeGridEntity();
bool hasChildren = data.Count(t => t.ParentId == item.Id && t.ParentId != t.Id) == 0 ? false : true;
tree.id = item.Id.ToString();
tree.parentId = item.ParentId.HasValue ? item.ParentId.Value.ToString() : "";
tree.expanded = true;
tree.hasChildren = hasChildren;
tree.entityJson = item.ToJson();
TreeList.Add(tree);
}
return(Content(TreeList.TreeJson()));
}
public async Task <IActionResult> GetListJson(int category, string organizeId)
{
var data = await _dmosService.QueryFilterByCategoryAsync(category, organizeId);
var dtos = CrudDtoMapper.MapEntityToDtos(data);
return(Content(dtos.ToJson()));
}
public IActionResult SaveModulePost(ModuleViewModel moduleModel, string moduleButtonListJson)
{
var moduleButtonList = moduleButtonListJson.ToList <PermissionEntity>();
var moduleEntity = new ModuleEntity();
if (moduleModel.Id != 0)
{
moduleEntity = _backendUnitOfWork.Module.GetById(moduleModel.Id);
}
CrudDtoMapper.MapDtoToEntity(moduleModel, moduleEntity);
_moduleService.SaveForm(moduleEntity, moduleButtonList);
this._mediator.Publish(new EntityUpdatedEventData <ModuleEntity>(moduleEntity));
return(Success("Save Success"));
}
public async Task <IActionResult> GetListJson(JqGridRequest request, long value, string keyword)
{
var data = await _areaService.GetPageListBykeyword(value, keyword);
var dtos = CrudDtoMapper.MapEntityToDtos(data);
JqGridResponse response = new JqGridResponse();
foreach (AreaViewModel userInput in dtos)
{
response.Records.Add(new JqGridRecord(Convert.ToString(userInput.Id), userInput));
}
response.Reader.RepeatItems = false;
return(new JqGridJsonResult(response));
}
public async Task <IActionResult> GetListJson(JqGridRequest request, ModuleSearchRequest searchRequest)
{
var data = await _moduleService.GetPageListBykeyword(searchRequest.ParentId, searchRequest.KeyWord, searchRequest.Condition);
var dtos = CrudDtoMapper.MapEntityToDtos(data);
JqGridResponse response = new JqGridResponse();
foreach (ModuleViewModel userInput in dtos)
{
response.Records.Add(new JqGridRecord(Convert.ToString(userInput.Id), userInput));
}
response.Reader.RepeatItems = false;
return(new JqGridJsonResult(response));
}
public ActionResult GetPageListJson(long itemId, string condition, string keyword, JqGridRequest request)
{
Expression <Func <DataItemDetailEntity, bool> > pk = d => d.ItemId == itemId;
if (!string.IsNullOrEmpty(keyword))
{
Expression <Func <DataItemDetailEntity, bool> > pc = null;
#region 多条件查询
switch (condition)
{
case "ItemName": //项目名
pc = d => d.ItemName.Contains(keyword);
break;
case "ItemValue": //项目值
pc = d => d.ItemValue.Contains(keyword);
break;
case "SimpleSpelling": //拼音
pc = d => d.SimpleSpelling.Contains(keyword);
break;
default:
break;
}
#endregion
pk.And(pc);
}
var query = _repository.QueryPage(pk, page: request.PageIndex, pageSize: request.RecordsCount);
var dtos = CrudDtoMapper.MapEntityToDtos(query);
JqGridResponse response = new JqGridResponse()
{
TotalPagesCount = query.TotalPages,
PageIndex = request.PageIndex,
TotalRecordsCount = query.TotalCount,
};
foreach (DataItemDetailViewModel userInput in dtos)
{
response.Records.Add(new JqGridRecord(Convert.ToString(userInput.Id), userInput));
}
response.Reader.RepeatItems = false;
return(new JqGridJsonResult(response));
}
public ActionResult GetPageListJson(JqGridRequest request, string keyword)
{
var query = _dataItemService.GetPageListBykeyword(keyword, request.PageIndex, request.RecordsCount);
var dtos = CrudDtoMapper.MapEntityToDtos(query);
JqGridResponse response = new JqGridResponse()
{
TotalPagesCount = query.TotalPages,
PageIndex = request.PageIndex,
TotalRecordsCount = query.TotalCount,
};
foreach (DataItemViewModel userInput in dtos)
{
response.Records.Add(new JqGridRecord(Convert.ToString(userInput.Id), userInput));
}
response.Reader.RepeatItems = false;
return(new JqGridJsonResult(response));
}
