public IActionResult Get([FromQuery] CategorySearch search, [FromServices] IGetCategoriesQuery query) { return(Ok(executor.ExecuteQuery(query, search))); }
public Task <IEnumerable <Category> > GetAsync( CategorySearch option, CancellationToken token = default(CancellationToken)) { string query = @" SELECT ct.* , ac.Code [AccountTitleCode] , ac.Name [AccountTitleName] , pa.Code [PaymentAgencyCode], pa.Name [PaymentAgencyName] , tc.Name [TaxClassName] FROM Category ct LEFT JOIN AccountTitle ac ON ac.Id = ct.AccountTitleId LEFT JOIN PaymentAgency pa ON pa.Id = ct.PaymentAgencyId LEFT JOIN TaxClass tc ON tc.Id = ct.TaxClassId WHERE ct.Id = ct.Id"; if (option.CompanyId.HasValue) { query += @" AND ct.CompanyId = @CompanyId"; } if (option.CategoryType.HasValue) { query += @" AND ct.CategoryType = @CategoryType"; } if (option.UseInput.HasValue) { query += @" AND ct.UseInput = @UseInput"; } if (option.UseLimitDate.HasValue) { query += @" AND ct.UseLimitDate = @UseLimitDate"; } if (option.UseAccountTransfer.HasValue) { query += @" AND ct.UseAccountTransfer = @UseAccountTransfer"; } if (!string.IsNullOrWhiteSpace(option.Name)) { option.Name = Sql.GetWrappedValue(option.Name); query += @" AND ct.Name LIKE @Name"; } if (option.Ids?.Any() ?? false) { query += @" AND ct.Id IN (SELECT Id FROM @Ids)"; } if (option.Codes?.Any() ?? false) { query += @" AND ct.Code IN (SELECT Code FROM @Codes)"; } query += @" ORDER BY ct.CompanyId ASC , ct.CategoryType ASC , ct.Code ASC"; return(dbHelper.GetItemsAsync <Category>(query, new { option.CompanyId, option.CategoryType, option.UseInput, option.UseLimitDate, option.UseAccountTransfer, option.Name, Ids = option.Ids.GetTableParameter(), Codes = option.Codes.GetTableParameter(), }, token)); }
public ActionResult Index(CategorySearch model) { var response = _listCategoryCommand.Execute(model); return(View(response)); }
public ActionResult <IEnumerable <CategoryDto> > Get([FromQuery] CategorySearch search) { var categories = _getCommand.Execute(search); return(Ok(categories)); }
public IActionResult CategoryList(CategorySearch search) { var result = _articleService.GetCategoryList(search); return(Ok(OperateResult.Succeed("ok", result))); }