76 lines
2.0 KiB
Markdown
76 lines
2.0 KiB
Markdown
|
|
# BOM Form Documentation
|
|
|
|
## Overview
|
|
The BOM (Bill of Materials) form provides functionality for reading, displaying and managing BOM data from different sources.
|
|
|
|
## Form Controls
|
|
|
|
### Text Fields
|
|
- `txtAssembly` - Assembly number input (8 characters - part number and revision)
|
|
- `txtBOM` - Full path and filename of BOM file
|
|
- `txtGood` - Status indicator field
|
|
|
|
### Buttons
|
|
- `cmdReadBOM` - Reads standard format BOM files
|
|
- `cmdReadAltimaBOM` - Reads Altima format BOM files
|
|
- `cmdReadSolidBOM` - Reads SolidWorks BOM files
|
|
- `cmdClearBOM` - Clears existing BOM records
|
|
- `cmdShow` - Displays loaded BOM data
|
|
- `cmdHide` - Closes the form
|
|
- `cmdClose` - Closes the form
|
|
|
|
### Data Display
|
|
- `DataGrid1` - Displays BOM records with columns:
|
|
- WASM# (Assembly Number)
|
|
- WASMR (Revision)
|
|
- WCMP# (Component Number)
|
|
- WQTY (Quantity)
|
|
- WENTD (Entry Date)
|
|
- `lstStatus` - Status and logging messages
|
|
- `lblStat` - Status label
|
|
|
|
### Data Connection
|
|
- `Adodc1` - ADO data control connected to EGBWP1A0 table via ODBCrms DSN
|
|
|
|
## Key Functions
|
|
|
|
### BOM Reading
|
|
- Standard BOM format (cmdReadBOM_Click)
|
|
- Parses fixed width format files
|
|
- Handles Part and Sub-Assembly records
|
|
|
|
- Altima BOM format (cmdReadAltimaBOM_Click)
|
|
- Parses CSV format files
|
|
- Skips header rows
|
|
|
|
- SolidWorks BOM format (cmdReadSolidBOM_Click)
|
|
- Parses tab-delimited files
|
|
- Handles ItemNo, PartNo, Qty fields
|
|
|
|
### BOM Management
|
|
- Clear BOM (cmdClearBOM_Click)
|
|
- Removes existing records for an assembly
|
|
- Uses stored procedure for deletion
|
|
|
|
- Show BOM (cmdShow_Click)
|
|
- Filters grid to show specific assembly/revision
|
|
|
|
### Logging
|
|
- Uses loglist() function to:
|
|
- Display status messages
|
|
- Maintain history in lstStatus
|
|
- Limit list to 600 entries
|
|
|
|
## Data Format
|
|
- Assembly numbers: 7 digits + 1 revision character
|
|
- Quantities stored with 3 decimal places
|
|
- Dates stored as YYYYMMDDHHNNSS
|
|
|
|
## Error Handling
|
|
- File existence checking
|
|
- Error trapping for database operations
|
|
- Status codes for operation results:
|
|
- 0: Success
|
|
- 1: Bad BOM format
|
|
- 2: File not found |