Table of Contents
This documentation provides an overview of grid functionalities in a Delphi-based application for managing data such as materials, pricing, and inventory. The grids utilize DevExpress cxGrid components to handle data display, interaction, and manipulation from database queries (e.g., PostgreSQL via components like TPgQuery). They support multilingual interfaces (e.g., English and Thai), dynamic view switching, filtering, editing, and customization features. Data is bound to datasets, with grids managing various data aspects like listing, aggregated views, and detailed editing.
1. Overview of Grids and Views #
- Grids are typically placed within tabbed interfaces for separating list and edit modes.
- They support multiple table views that can be dynamically switched to show different data perspectives, such as core details, pricing summaries, or inventory metrics.
- Views adapt to language preferences, toggling between standard and localized captions and fields.
- Key features include data binding, automatic refreshing, parameterized queries for efficient data retrieval, and tools for column handling and summary calculations.
2. Switching Between Views #
- View switching is done through menu options or buttons, with indicators showing the current active view.
- Switching involves loading relevant datasets and adjusting visible controls like filters.
- This enables users to move between general data overviews and specialized representations without reloading the entire interface.
3. Key Features in Views #
- Columns and Display: Views include fields like identifiers, statuses, descriptions, units, quantities, prices, and timestamps. Columns may be hidden, formatted (e.g., currency or dates), or use controls like image combos for visual representation.
- Interactions: Row double-clicks trigger actions such as opening edit modes or navigating to related records. Popup menus provide quick actions like editing or deleting.
- Summaries: Footers offer aggregates like record counts, aiding in quick data analysis.
- Variants: Localized views adjust for different languages, ensuring consistent usability across interfaces.
4. Filtering and Searching #
- Status-based filtering via checkboxes applies to relevant views, allowing selective display of data states.
- Additional filters, such as category selectors or toggles for comprehensive views, refine results in specific contexts.
- Integrated search panels support text-based querying within the displayed data.
5. Editing and Data Manipulation #
- Grids allow adding new records, modifying existing ones, and deleting with user confirmations.
- Edits update component states, enabling save actions and performing calculations (e.g., derived values like taxes).
- Duplication features copy data entries and refresh views to reflect changes.
6. Layout Customization #
- Layouts can be saved and restored through menu options, preserving user preferences for column order and visibility.
- Quick customization enables on-the-fly adjustments like hiding or reordering columns.
