Volcore Documentation

Order order = new Order();
order.Id = value;

// Get the previous approval node information
List<Sys_WorkFlowTableStep> steps2 = order.GetTablePreFlowStep();

view-grid
├── vol-form  ref="searchForm"     ← searchFormFields / searchFormOptions（查询区）
├── vol-table ref="table"          ← columns（主表列表）
└── 编辑弹框 (vol-box)
    ├── vol-form  ref="form"       ← editFormFields / editFormOptions（主表编辑）
    └── vol-table ref="detail"     ← detail.columns / detailOptions（明细，一对多另有 details[]）

// In src\api\http.js
axios.defaults.baseURL = 'http://your-deployed-backend-address';

public partial class Sys_WorkFlowTableService
{
    private readonly ISys_WorkFlowTableRepository _repository;
    private readonly ISys_WorkFlowTableStepRepository _stepRepository;

    [ActivatorUtilitiesConstructor]
    public Sys_WorkFlowTableService(
        ISys_WorkFlowTableRepository dbRepository, 
        IHttpContextAccessor httpContextAccessor, 
        ISys_WorkFlowTableStepRepository stepRepository)
        : base(dbRepository)
    {
        _repository = dbRepository;
        _stepRepository = stepRepository; // Access to other tables
    }
}

public override PageGridData<YourEntity> GetPageData(PageDataOptions options)
{
    // 1. Handle extra parameters passed from the frontend (searchBefore method)
    object extraValue = options.Value;

    // 2. Filter or extract specific search parameters from the relative list
    QueryRelativeList = (List<SearchParameters> parameters) =>
    {
        foreach (var item in parameters)
        {
            if (item.Name == "TargetField")
            {
                string value = item.Value;
                item.Value = null; // Clearing the value prevents the framework from using it automatically
            }
        }
    };

    // 3. Define custom query expressions (IQueryable for EF, ISugarQueryable for SqlSugar)
    QueryRelativeExpression = (IQueryable<YourEntity> queryable) =>
    {
        // Example: Filter by current user
        queryable = queryable.Where(x => x.CreateID == UserContext.Current.UserId);
        // Example: Include related detail tables
        queryable = queryable.Include(x => x.DetailTable);
        return queryable;
    };

    // 4. Specify multiple fields for sorting
    OrderByExpression = x => new Dictionary<object, QueryOrderBy>() {
        { x.CreateDate, QueryOrderBy.Desc },
        { x.PhoneNo, QueryOrderBy.Asc }
    };

    // 5. Perform operations on the result set before returning to the page
    GetPageDataOnExecuted = (PageGridData<YourEntity> grid) =>
    {
        List<YourEntity> rows = grid.rows;
    };

    var res = base.GetPageData(options);
    // Optional: Add extra data to be received by frontend searchAfter(rows, res)
    res.extra = new { CustomValue = 123 };
    return res;
}