Lighting system design method based on ACCESS database

Abstract

The invention relates to the technical field of lighting design, in particular to an ACCESS database-based lighting system design method, which comprises the following steps of: creating a block file with attributes in CAD (Computer Aided Design) drawing software according to the demand of a ship user; when the lighting system is designed, a predefined block file with attributes is called, and lamps are arranged at corresponding positions of a drawing by adopting an insertion command; exporting the designed drawing file as a txt format file, importing the exported txt file into an ACCESS database, and establishing a data link; in the ACCESS database, generating a corresponding statistical report; in the design process, when the number or arrangement of the lamps in the drawing is changed, a designer updates the drawing in the CAD, and the ACCESS database automatically and synchronously updates data and reflects the data in a statistical report in real time. According to the method, the labor hour is reduced, meanwhile, the design and statistics efficiency is improved, and the accuracy and consistency of data are ensured.

Description

Technical Field

[0001] The present invention relates to the technical field of lighting design, and in particular to a lighting system design method based on ACCESS database. Background Art

[0002] With the rapid development of industry and marine economy, shipbuilding and marine engineering projects are becoming increasingly large-scale and complex, which puts higher requirements on the design of lighting systems. In these projects, the lighting system not only involves a large number of lighting equipment, but also requires accurate statistics of the model, power, installation location of the lighting, and the type and length of the required cables. However, the existing lighting system design method mainly relies on designers to manually draw drawings and manually count the lighting information, which is significantly inefficient and prone to errors.

[0003] The current lighting system design usually uses Auto CAD drawing software to draw drawings. After completing the system drawings, designers need to manually count the number and model of lamps and enter them into EXCEL and other tables for summary. This method is not only labor-intensive and time-consuming, but also prone to statistical errors when it comes to complex designs and a large number of lamps. Such errors may lead to material procurement errors, which in turn affects the project's construction progress and cost control, and will also have a significant impact on the project's delivery time.

[0004] In addition, as the complexity of the project increases, the drawings are frequently modified and updated, and each modification requires the re-counting of lighting information, further increasing the workload and the possibility of errors. The existing technology lacks an effective method to automate and simplify this process, thereby improving the efficiency of design and statistical work and ensuring the consistency and accuracy of data. Summary of the invention

[0005] The invention provides a lighting system design method based on ACCESS database.

[0006] A lighting system design method based on ACCESS database includes the following steps: S1, pre-definition of lamp types and parameters: according to the needs of ship users, a block file with attributes is created in the CAD drawing software, where the attributes include the model, power, luminous flux, installation location and cable type of the lamp; S2, drawing design and lamp arrangement: When designing the lighting system, call the block file with attributes predefined in S1, and arrange the lamps in the corresponding positions of the drawing using the insert command; S3, export and link of drawing files: export the designed drawing files into txt format files, which include the attribute information and layout information of the lamps in the drawings. The exported txt files are used as the data source for establishing a link with the ACCESS database. The exported txt files are imported into the ACCESS database, and a data link is established. The data link enables the database to read and update the attribute and layout information of the lamps in the drawings in real time, ensuring the synchronous update of the drawings and the database. S4, data statistics and report generation: In the ACCESS database, through the query and screening functions, select the lamp data that needs to be counted, and generate the corresponding statistical report. The statistical report content includes the total number of lamps, model classification, installation location distribution and cable length information. This step does not require manual statistics, which greatly improves work efficiency and data accuracy; S5, drawing modification and data update: During the design process, when the number or layout of lamps in the drawing changes, the designer updates the drawing in CAD, and the ACCESS database automatically updates the data synchronously and reflects it in the statistical report in real time. This step avoids repeated manual operations and ensures the real-time and accuracy of statistical data.

[0007] Optionally, the S1 specifically includes: S11, Ship User Demand Analysis: Analyze the lighting needs of ship users and identify key parameters, including the use environment of the lamps, expected lighting effects, and energy efficiency requirements, so as to determine the model, power, luminous flux, installation location, and cable type attributes of the lamps. The analysis results form a lighting demand report as the basis for creating a block file with attributes; S12, Collection and organization of lamp attribute data: According to the demand report, collect technical specifications and performance data of various types of lamps, including model, power, and luminous flux parameters. For each type of lamp, determine its installation location and required cable type to ensure the accuracy and completeness of the data; S13, creation of block files with attributes: In the CAD drawing software, based on the collected and organized lamp attribute data, a block file with attributes is created, each block file includes one or more attribute fields related to the lamp, and the attribute fields are set through the attribute definition function of the CAD software.

[0008] S14, standardization and storage of attribute block files: The created attribute block files are standardized to ensure their universality in different projects and environments.

[0009] Optionally, the S2 specifically includes: S21, selection and calling of attribute block files: In CAD drawing software, according to the design requirements of the lighting system, the attribute block files are called through the system design interface or command line. Designers select appropriate lamp types from the block file library according to the specific lighting area, lighting requirements and user needs; S22, Calibration and verification of layout positions: In the drawings, the installation positions of the lamps are calibrated through the coordinate system or reference lines of the CAD software. Before arranging the lamps, the layout positions are verified using the design tools in the software to ensure that the installation of the lamps will not conflict with other equipment or structures and meet the lighting requirements; S23, Insertion of luminaire block files: After determining the layout position, use the "Insert" command in the CAD software to insert the predefined luminaire block file into the corresponding position of the drawing. The insertion process includes automatic filling of luminaire attributes, so that the model, power, luminous flux, installation location and cable type attributes of each luminaire are automatically generated in the drawing and associated with the block file.

[0010] Optionally, the export and linking of the drawing files in S3 specifically include: S31, format conversion and export of drawing files: In CAD drawing software, after completing the layout of lamps, the drawing files are converted into txt format files containing the lamp attribute information and layout information through the export function of the software. The export process includes automatically extracting the attribute data of each lamp block file (such as model, power, luminous flux, installation location and cable type) and the coordinate position information of the lamp in the drawing, and saving the data in a structured text format to ensure that the exported txt files can be correctly identified and read by the database software; S32, data format verification and optimization: after the txt file is exported, the data format is verified to ensure that the format of the lamp attribute information and layout information in the file is correct without errors or omissions. At the same time, according to the requirements of the ACCESS database, the necessary format optimization or supplementation is performed on the data in the txt file; S33, import of txt file and establishment of database link: In ACCESS database, the exported txt file is imported into the database through the data import function. During the import process, the lamp attribute information and layout information in the txt file are automatically identified, and the lamp attribute information and layout information are mapped to the corresponding fields of the database. After the import is completed, a data link is established between the database and the CAD drawing file.

[0011] Optionally, the configuration of the data synchronization and update mechanism is also included, and the configuration of the data synchronization and update mechanism specifically includes: S34, configuring an automatic detection mechanism in the CAD drawing software, monitoring the modification status of the drawing file in real time, including the addition, deletion, position change or property change of the lamp, detecting that the drawing file is modified, triggering the synchronous update process, and starting the process of automatically generating a new txt file; S35, when the trigger mechanism detects that the drawing has been modified, the CAD software automatically performs an export operation to export the updated drawing information, including the latest attribute data and layout information of all lamps, into a new txt file; S36, configure the automatic import function of the ACCESS database so that it can automatically detect the new txt file after it is generated and import it into the database. After receiving the new txt file, the database automatically identifies the lamp attribute information and layout information therein, replaces or updates the corresponding old data in the database, and ensures that the information in the database is synchronized with the latest drawing data; S37, after the database completes the data update, automatically update the data links in the database to ensure that all associated data tables and queries point to the latest lighting fixture information and layout information; S38, configure the exception handling mechanism. When data import fails, link is interrupted or data conflicts occur during the synchronization update process, notifications are automatically issued to remind designers to check and fix the problems in time.

[0012] Optionally, the data statistics and report generation in S4 specifically include: S41, creation and structuring of data tables: In the ACCESS database, a structured data table is created based on the imported lamp attribute information and layout information. The table includes the lamp model, power, luminous flux, installation location, cable type and its corresponding layout information fields. The information fields are mapped to the txt file data exported from the CAD drawing, and the integrity and consistency of the data are ensured by setting field attributes (such as data type, constraints, etc.); S42, setting and executing query conditions: in the database, through the query function, design and execute SQL query statements for lamp data, the query conditions include lamp model, installation location, cable type, and the query results will automatically generate a temporary data table for subsequent statistical analysis; S43, data screening and grouping statistics: perform secondary screening and grouping statistics on the query results according to the specific needs of the project; S44, generation and formatting of statistical reports: after completing data query and group statistics, use the report generation function in the ACCESS database to automatically generate statistical reports, the report content includes the total number of lamps, model classification, installation location distribution and cable length information; S45, dynamic update and maintenance of reports: To ensure the real-time and accuracy of statistical reports, a dynamic update mechanism for reports is configured. When the lighting data in the database changes (such as new data imported after the drawings are modified), the report is automatically refreshed to reflect the latest statistical results.

[0013] Optionally, the group statistics include: Group the data by lamp model and count the total number of lamps of each model; Group by installation location and analyze the distribution of lamps in different areas; Group by cable type and calculate the total length of each type of cable.

[0014] Optionally, the S5 specifically includes: S51, real-time detection of drawing modification: configure a real-time detection mechanism in the CAD drawing software to continuously monitor whether the number or layout of lamps has changed. Once a modification operation (such as adding, deleting or moving lamps, modifying lamp properties, etc.) is detected, the modified content is immediately marked and the subsequent data update process is triggered; S52, automatically generate updated txt file: when the drawing is modified, the CAD software automatically starts the data export function, exports the modified drawing information, including the new properties and layout information of the lamps, into an updated txt file, and the updated txt file automatically overwrites or incrementally updates the original txt file; S53, automatic data synchronization of ACCESS database: configure the automatic data synchronization function in the ACCESS database, automatically scan and detect new txt files regularly or when a trigger event occurs (such as after a txt file is updated). After the update is detected, the ACCESS database automatically imports the new txt file and replaces or updates the corresponding lamp data in the database; S54, real-time update of statistical reports: After the database completes data synchronization, configure automatic update of statistical reports. The report module in the ACCESS database will automatically refresh the report content according to the latest imported lighting data to ensure that the statistical results reflect the latest design changes.

[0015] Optionally, the S5 also includes recording and auditing of update logs: each time a drawing is modified and a data synchronization operation is performed, a log is automatically recorded, and the time, content and number of lamps involved in the modification are recorded in detail.

[0016] Beneficial effects of the present invention: The present invention, by combining ACAD drawing software with ACCESS database, automatically realizes multiple steps such as lamp design, data export and statistical report generation, and avoids the risk of errors caused by manual operation in the traditional design process by pre-defining lamp block files with attributes and automatic data synchronization and update mechanism. Especially in marine engineering and large ship projects with a large number of lamps and complex types, it reduces manual work hours, improves the efficiency of design and statistics, and ensures the accuracy and consistency of data.

[0017] The present invention is equipped with a mechanism of real-time detection, automatic generation of txt files, automatic import into database, and real-time update of statistical reports. When the number or arrangement of lamps in the drawings changes, the system can automatically identify and process these changes, and keep data synchronization between the CAD drawings and the ACCESS database. Through this mechanism, the design data and statistical reports of the project always reflect the latest design status, reducing the risk of wrong decisions caused by data lag, and enhancing the efficiency and reliability of project management.

[0018] The present invention realizes in-depth analysis and visual display of lamp data through the query, screening, grouping statistics and report generation functions of the ACCESS database. Especially in large and complex projects, it can automatically generate statistical reports including information such as the total number of lamps, model classification, installation location distribution and cable length, so as to meet the diverse needs of project management.

[0019] The present invention can greatly reduce the design man-hours by designing a file with attributes and then combining drawing software with statistical software ACCESS. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solutions in the present invention or the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings in the following description are only for the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0021] Figure 1 The figure is a flow chart of a design method according to an embodiment of the present invention. DETAILED DESCRIPTION

[0022] The present invention is described in detail below in conjunction with the accompanying drawings and specific embodiments. At the same time, it is explained here that in order to make the embodiments more detailed, the following embodiments are the best and preferred embodiments, and those skilled in the art may also adopt other alternatives to implement some known technologies; and the accompanying drawings are only for more specific description of the embodiments, and are not intended to specifically limit the present invention.

[0023] It should be noted that the references to "one embodiment", "embodiment", "exemplary embodiments", "some embodiments" and the like in the specification indicate that the embodiments described may include specific features, structures or characteristics, but not every embodiment may include the specific features, structures or characteristics. In addition, when a specific feature, structure or characteristic is described in conjunction with an embodiment, it should be within the knowledge of a person skilled in the art to implement such feature, structure or characteristic in conjunction with other embodiments (whether or not explicitly described).

[0024] In general, a term can be understood, at least in part, from its use in context. For example, depending, at least in part, on the context, the term "one or more" as used herein can be used to describe any feature, structure, or characteristic in the singular sense, or can be used to describe a combination of features, structures, or characteristics in the plural sense. Additionally, the term "based on" can be understood as not necessarily intended to convey an exclusive set of factors, but can instead, depending, at least in part, on the context, allow for the presence of other factors that are not necessarily explicitly described.

[0025] like Figure 1 As shown, a lighting system design method based on ACCESS database includes the following steps: S1, pre-definition of lamp types and parameters: according to the needs of ship users, a block file with attributes is created in the CAD drawing software, where the attributes include the model, power, luminous flux, installation location and cable type of the lamp. By defining the attributes of the lamp, data support is provided for the automated processing of subsequent steps; S1 specifically includes: S11, Ship User Demand Analysis: Analyze the lighting needs of ship users and identify key parameters, including the use environment of the lamps, expected lighting effects, and energy efficiency requirements, so as to determine the model, power, luminous flux, installation location, and cable type attributes of the lamps. The analysis results form a lighting demand report as the basis for creating a block file with attributes; S12, Collection and organization of lamp attribute data: According to the demand report, collect technical specifications and performance data of various types of lamps, including model, power, and luminous flux parameters. For each type of lamp, determine its installation location and required cable type to ensure the accuracy and completeness of the data; S13, creating a block file with attributes: in the CAD drawing software, based on the collected and sorted lamp attribute data, a block file with attributes is created, each block file includes one or more attribute fields related to the lamp, and the attribute fields are set through the attribute definition function of the CAD software, specifically including: Model attribute: specify the model of the lamp to ensure that the type of lamp used in the design is clearly identifiable; Power attributes: record the power of the lamp to facilitate power load analysis; Luminous flux attribute: defines the light output of the luminaire to ensure that the lighting design meets the lighting requirements; Installation location attributes: indicate the installation location of the lamp in the drawing to ensure the rationality of the layout; Cable type attributes: Based on the power and installation location of the luminaire, define the required cable type to ensure the safety and reliability of the electrical connection.

[0026] S14, standardization and storage of attribute block files: The created attribute block files are standardized to ensure universality in different projects and environments. Finally, the standardized block files are stored in a centrally managed library for easy call in subsequent design processes.

[0027] S2, drawing design and lamp arrangement: When designing the lighting system, call the block file with attributes predefined in S1, and arrange the lamps in the corresponding positions of the drawing using the insert command, avoiding the process of manually drawing lamps and ensuring that the lamp attribute information is consistent with the drawing, reducing the risk of errors caused by manual operation; S2 specifically includes: S21, selection and calling of attribute block files: In CAD drawing software, according to the design requirements of the lighting system, the attribute block files are called through the system design interface or command line. Designers select appropriate lamp types from the block file library according to the specific lighting area, lighting requirements and user needs; S22, Calibration and verification of layout positions: In the drawings, the installation positions of the lamps are calibrated through the coordinate system or reference lines of the CAD software. Before arranging the lamps, the layout positions are verified using the design tools in the software to ensure that the installation of the lamps will not conflict with other equipment or structures and meet the lighting requirements; S23, inserting the luminaire block file: after determining the layout position, use the "Insert" command in the CAD software to insert the predefined luminaire block file into the corresponding position of the drawing. The insertion process includes automatic filling of luminaire attributes, so that the model, power, luminous flux, installation position and cable type attributes of each luminaire are automatically generated in the drawing and associated with the block file; After inserting the luminaire block file, the attribute data of each luminaire is verified through the software's attribute checking tool to ensure that the attribute information matches the design requirements and drawing position. If there is an inconsistency in the attributes or an unreasonable layout, the designer can make adjustments directly in the CAD software by modifying the attribute values ​​or repositioning the luminaire to ensure the accuracy and feasibility of the design. After completing the layout and attribute verification of the luminaire, save the design drawings and generate a backup file for tracing and comparison during subsequent design modifications or audits.

[0028] S3, export and link of drawing files: export the designed drawing files to txt format files, which include the attribute information and layout information of the lamps in the drawings. The exported txt files are used as the data source for establishing a link with the ACCESS database. The exported txt files are imported into the ACCESS database and a data link is established. The data link enables the database to read and update the attribute and layout information of the lamps in the drawings in real time, ensuring the synchronous update of the drawings and the database. The export and linking of drawing files in S3 specifically include: S31, format conversion and export of drawing files: In CAD drawing software, after completing the layout of lamps, the drawing files are converted into txt format files containing the lamp attribute information and layout information through the export function of the software. The export process includes automatically extracting the attribute data of each lamp block file (such as model, power, luminous flux, installation location and cable type) and the coordinate position information of the lamp in the drawing, and saving the data in a structured text format to ensure that the exported txt files can be correctly identified and read by the database software; S32, data format verification and optimization: After the txt file is exported, the data format is verified to ensure that the lighting attribute information and layout information in the file are in the correct format without errors or omissions. At the same time, according to the requirements of the ACCESS database, the data in the txt file is optimized or supplemented in the necessary format to ensure seamless connection and accurate data reading in the subsequent data import process; S33, import of txt file and establishment of database link: in ACCESS database, the exported txt file is imported into the database through the data import function. During the import process, the lamp attribute information and layout information in the txt file are automatically identified, and the lamp attribute information and layout information are mapped to the corresponding fields of the database. After the import is completed, the data link between the database and the CAD drawing file is established, so that the database can read and update the lamp information in the drawing in real time, ensuring the synchronous update of the drawing and the database; To ensure that the lighting data in the database can reflect the latest status of the drawings in real time, a data synchronization and update mechanism is configured. When the drawings are modified or updated, the CAD software will automatically generate a new txt file and import it into the database. The data link in the database will be automatically updated according to the new data source, so that the lighting properties and layout information are consistent between the database and the drawings; After the data link is established, the data link between the database and the drawing is verified regularly to ensure the integrity and accuracy of the data. If the link is interrupted or the data is inconsistent, an automatic warning will be given. Designers can maintain the stability of data synchronization by repairing or re-establishing the link.

[0029] S3 also includes the configuration of the data synchronization and update mechanism, which specifically includes: S34, configuring an automatic detection mechanism in the CAD drawing software, monitoring the modification status of the drawing file in real time, including the addition, deletion, position change or property change of the lamp, detecting that the drawing file is modified, triggering the synchronous update process, and starting the process of automatically generating a new txt file; S35, when the trigger mechanism detects that the drawing has been modified, the CAD software automatically performs an export operation to export the updated drawing information, including the latest attribute data and layout information of all lamps, into a new txt file; S36, configure the automatic import function of the ACCESS database so that it can automatically detect the new txt file after it is generated and import it into the database. After receiving the new txt file, the database automatically identifies the lamp attribute information and layout information therein, replaces or updates the corresponding old data in the database, and ensures that the information in the database is synchronized with the latest drawing data; S37, after the database completes the data update, automatically update the data links in the database to ensure that all associated data tables and queries point to the latest lighting fixture information and layout information; S38, configure the exception handling mechanism. When data import fails, link is interrupted or data conflicts occur during the synchronization update process, notifications are automatically issued to remind designers to check and fix the problems in time.

[0030] S4, data statistics and report generation: In the ACCESS database, through the query and screening functions, select the lamp data that needs to be counted, and generate the corresponding statistical report. The statistical report content includes the total number of lamps, model classification, installation location distribution and cable length information. This step does not require manual statistics, which greatly improves work efficiency and data accuracy; The data statistics and report generation in S4 specifically include: S41, creation and structuring of data tables: In the ACCESS database, a structured data table is created based on the imported lamp attribute information and layout information. The table includes the lamp model, power, luminous flux, installation location, cable type and its corresponding layout information fields. The information fields are mapped to the txt file data exported from the CAD drawing, and the integrity and consistency of the data are ensured by setting field attributes (such as data type, constraints, etc.); S42, setting and executing query conditions: in the database, through the query function, design and execute SQL query statements for lamp data, the query conditions include lamp model, installation location, cable type, for example, by writing SQL statements, you can select a specific model of lamps, count their layout in different areas, and calculate the total length of the cable, the query results will automatically generate a temporary data table for subsequent statistical analysis; S43, data screening and grouping statistics: according to the specific needs of the project, the query results are screened and grouped for statistics. The grouping function in the ACCESS database enables these statistical operations to be automatically executed and generate corresponding statistical results. S44, generation and formatting of statistical reports: after completing data query and group statistics, use the report generation function in the ACCESS database to automatically generate statistical reports. The report content includes the total number of lamps, model classification, installation location distribution and cable length information. According to project requirements, customize the format and layout of the report to ensure that the report information is clear and easy to interpret. It can also be exported to multiple formats (such as PDF, Excel) for easy sharing and archiving; S45, dynamic update and maintenance of reports: To ensure the real-time and accuracy of statistical reports, a dynamic update mechanism for reports is configured. When the lighting data in the database changes (such as new data imported after the drawings are modified), the report is automatically refreshed to reflect the latest statistical results. Designers can view and export the latest statistical reports at any time to avoid decision-making errors caused by data lag; The generated statistical reports can be reviewed and proofread through the report review function of the ACCESS database before final output. Designers can verify the data in the report to ensure the consistency of the statistical results with the actual design data. After the review is passed, the report can be archived and used as a formal document for project management.

[0031] Group statistics include: Group the data by lamp model and count the total number of lamps of each model; Group by installation location and analyze the distribution of lamps in different areas; Group by cable type and calculate the total length of each type of cable.

[0032] S5, drawing modification and data update: During the design process, when the number or layout of lamps in the drawing changes, the designer updates the drawing in CAD, and the ACCESS database automatically updates the data synchronously and reflects it in the statistical report in real time. This step avoids repeated manual operations and ensures the real-time and accuracy of statistical data.

[0033] S5 specifically includes: S51, real-time detection of drawing modification: configure a real-time detection mechanism in the CAD drawing software to continuously monitor whether the number or layout of lamps has changed. Once a modification operation (such as adding, deleting or moving lamps, modifying lamp properties, etc.) is detected, the modified content is immediately marked and the subsequent data update process is triggered; S52, automatically generate updated txt files: When the drawing is modified, the CAD software automatically starts the data export function, and exports the modified drawing information, including the new properties and layout information of the lamps, as updated txt files. The updated txt files automatically overwrite or incrementally update the original txt files, ensuring that the exported data files are always consistent with the latest design status; S53, automatic data synchronization of ACCESS database: configure the automatic data synchronization function in the ACCESS database, automatically scan and detect new txt files regularly or when a trigger event occurs (such as after a txt file is updated). After the update is detected, the ACCESS database automatically imports the new txt file and replaces or updates the corresponding lighting data in the database to ensure that the database is synchronized with the latest status of the drawing design; S54, real-time update of statistical reports: After the database completes data synchronization, configure automatic update of statistical reports. The report module in the ACCESS database will automatically refresh the report content according to the latest imported lighting data to ensure that the statistical results (such as the total number of lamps, model classification, installation location distribution and cable length information) reflect the latest design modifications. Designers can view and export the latest statistical reports in real time to avoid wrong decisions due to data lag.

[0034] S5 also includes update log recording and auditing: each drawing modification and data synchronization operation is automatically logged, detailing the time, content and number of lamps involved in the modification. The log can be audited and reviewed by designers to ensure that each modification and update process is transparent and traceable.

[0035] The present invention covers any substitution, modification, equivalent method and scheme made on the essence and scope of the present invention. In order to make the public have a thorough understanding of the present invention, specific details are described in detail in the following preferred embodiments of the present invention, but those skilled in the art can fully understand the present invention without the description of these details. In addition, in order to avoid unnecessary confusion about the essence of the present invention, well-known methods, processes, procedures, components and circuits are not described in detail.

[0036] The above is only a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principle of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A lighting system design method based on ACCESS database, characterized in that: The following steps are involved: S1, pre-definition of lamp types and parameters: according to the needs of ship users, a block file with attributes is created in the CAD drawing software, where the attributes include the lamp model, power, luminous flux, installation location and cable type; S2, drawing design and lamp arrangement: When designing the lighting system, call the block file with attributes predefined in S1, and arrange the lamps in the corresponding positions of the drawing using the insert command; S3, export and link of drawing files: export the designed drawing files into txt format files, which include the attribute information and layout information of the lamps in the drawings. The exported txt files are used as the data source for establishing a link with the ACCESS database. The exported txt files are imported into the ACCESS database, and a data link is established. The data link enables the database to read and update the attribute and layout information of the lamps in the drawings in real time, ensuring the synchronous update of the drawings and the database. S4, data statistics and report generation: In the ACCESS database, through the query and filter functions, select the lamp data that needs to be counted, and generate the corresponding statistical report. The statistical report content includes the total number of lamps, model classification, installation location distribution and cable length information; S5, drawing modification and data update: During the design process, when the number or arrangement of lamps in the drawing changes, the designer updates the drawing in CAD, and the ACCESS database automatically updates the data synchronously and reflects it in the statistical report in real time.

2. The lighting system design method based on ACCESS database according to claim 1, characterized in that: The S1 specifically includes: S11, Ship User Demand Analysis: Analyze the lighting needs of ship users and identify key parameters, including the use environment of the lamps, expected lighting effects, and energy efficiency requirements, so as to determine the model, power, luminous flux, installation location, and cable type attributes of the lamps. The analysis results form a lighting demand report as the basis for creating a block file with attributes; S12, Collection and organization of lamp attribute data: According to the demand report, collect technical specifications and performance data of various types of lamps, including model, power, and luminous flux parameters. For each type of lamp, determine its installation location and required cable type; S13, creating a block file with attributes: in the CAD drawing software, based on the collected and sorted lamp attribute data, creating a block file with attributes, each block file includes one or more attribute fields related to the lamp, and the attribute fields are set by the attribute definition function of the CAD software; S14, standardization and storage of attribute block files: The created attribute block files are standardized to ensure their universality in different projects and environments.

3. The lighting system design method based on ACCESS database according to claim 1, characterized in that: The S2 specifically includes: S21, selection and calling of attribute block files: in the CAD drawing software, according to the design requirements of the lighting system, the attribute block files are called through the system design interface or command line. The designer selects the lamp type from the block file library according to the specific lighting area, lighting requirements and user needs; S22, Calibration and verification of layout positions: In the drawings, the installation positions of the lamps are calibrated through the coordinate system or reference lines of the CAD software. Before arranging the lamps, the layout positions are verified using the design tools in the software to ensure that the installation of the lamps will not conflict with other equipment or structures and meet the lighting requirements; S23, Insertion of luminaire block files: After determining the layout position, use the "Insert" command in the CAD software to insert the predefined luminaire block file into the corresponding position of the drawing. The insertion process includes the automatic filling of luminaire attributes, so that the model, power, luminous flux, installation location and cable type attributes of each luminaire are automatically generated in the drawing and associated with the block file.

4. The lighting system design method based on ACCESS database according to claim 1, characterized in that: The export and linking of the drawing files in S3 specifically include: S31, format conversion and export of drawing files: in the CAD drawing software, after completing the arrangement of lamps, the drawing files are converted into txt format files containing the lamp attribute information and arrangement information through the export function of the software. The export process includes automatically extracting the attribute data of each lamp block file and the coordinate position information of the lamp in the drawing, and saving the data in a structured text format to ensure that the exported txt files can be correctly identified and read by the database software; S32, data format verification and optimization: after the txt file is exported, the data format is verified to ensure that the format of the lamp attribute information and layout information in the file is correct without errors or omissions. At the same time, the data format in the txt file is optimized or supplemented according to the requirements of the ACCESS database; S33, import of txt file and establishment of database link: In ACCESS database, the exported txt file is imported into the database through the data import function. During the import process, the lamp attribute information and layout information in the txt file are automatically identified, and the lamp attribute information and layout information are mapped to the corresponding fields of the database. After the import is completed, a data link is established between the database and the CAD drawing file.

5. The lighting system design method based on ACCESS database according to claim 4 is characterized in that: The S3 also includes the configuration of the data synchronization and update mechanism, and the configuration of the data synchronization and update mechanism specifically includes: S34, configuring an automatic detection mechanism in the CAD drawing software, monitoring the modification status of the drawing file in real time, including the addition, deletion, position change or property change of the lamp, detecting that the drawing file is modified, triggering the synchronous update process, and starting the process of automatically generating a new txt file; S35, when the trigger mechanism detects that the drawing has been modified, the CAD software automatically performs an export operation to export the updated drawing information, including the latest attribute data and layout information of all lamps, into a new txt file; S36, configure the automatic import function of the ACCESS database so that it can automatically detect the new txt file after it is generated and import it into the database. After receiving the new txt file, the database automatically identifies the lamp attribute information and layout information therein, replaces or updates the corresponding old data in the database, and ensures that the information in the database is synchronized with the latest drawing data; S37, after the database completes the data update, automatically update the data links in the database to ensure that all associated data tables and queries point to the latest lighting fixture information and layout information; S38, configure the exception handling mechanism. When data import fails, link is interrupted or data conflicts occur during the synchronization update process, notifications are automatically issued to remind designers to check and fix the problems in time.

6. The lighting system design method based on ACCESS database according to claim 1, characterized in that: The data statistics and report generation in S4 specifically include: S41, creation and structuring of data tables: In the ACCESS database, a structured data table is created based on the imported lamp attribute information and layout information. The table includes the lamp model, power, luminous flux, installation location, cable type and its corresponding layout information fields. The information fields are mapped to the txt file data exported from the CAD drawing, and the integrity and consistency of the data are ensured by setting field attributes; S42, setting and executing query conditions: in the database, through the query function, design and execute SQL query statements for lamp data, the query conditions include lamp model, installation location, cable type, and the query results will automatically generate a temporary data table for subsequent statistical analysis; S43, data screening and grouping statistics: perform secondary screening and grouping statistics on the query results according to the specific needs of the project; S44, generation and formatting of statistical reports: after completing data query and group statistics, use the report generation function in the ACCESS database to automatically generate statistical reports, the report content includes the total number of lamps, model classification, installation location distribution and cable length information; S45, dynamic update and maintenance of reports: To ensure the real-time and accuracy of statistical reports, a dynamic update mechanism for reports is configured. When the lighting data in the database changes, the report is automatically refreshed to reflect the latest statistical results.

7. The lighting system design method based on ACCESS database according to claim 6 is characterized in that: The group statistics include: Group the data by lamp model and count the total number of lamps of each model; Group by installation location and analyze the distribution of lamps in different areas; Group by cable type and calculate the total length of each type of cable.

8. The lighting system design method based on ACCESS database according to claim 1, characterized in that: The S5 specifically includes: S51, real-time detection of drawing modification: configure a real-time detection mechanism in the CAD drawing software to continuously monitor whether the number or layout of lamps has changed. Once a modification operation is detected, the modified content is immediately marked and the subsequent data update process is triggered; S52, automatically generate updated txt file: when the drawing is modified, the CAD software automatically starts the data export function, exports the modified drawing information, including the new properties and layout information of the lamps, into an updated txt file, and the updated txt file automatically overwrites or incrementally updates the original txt file; S53, automatic data synchronization of ACCESS database: configure the automatic data synchronization function in the ACCESS database, automatically scan and detect new txt files regularly or when a trigger event occurs. After detecting an update, the ACCESS database automatically imports the new txt file and replaces or updates the corresponding lamp data in the database; S54, real-time update of statistical reports: After the database completes data synchronization, configure automatic update of statistical reports. The report module in the ACCESS database will automatically refresh the report content according to the latest imported lighting data to ensure that the statistical results reflect the latest design changes.

9. The lighting system design method based on ACCESS database according to claim 8, characterized in that: The S5 also includes the recording and auditing of update logs: each time a drawing is modified and data is synchronized, a log is automatically recorded, detailing the time, content and number of lamps involved in the modification.

Images