CN-121997902-A - System for generating modification list based on EXCEL VBA

CN121997902ACN 121997902 ACN121997902 ACN 121997902ACN-121997902-A

Abstract

The invention discloses a generation system of a change list based on EXCEL VBA, which is used for carrying out through marking on the change list in the process of compiling the change list to obtain the change list meeting the requirements, and comprises a highlighting editing module, a display module and a display module, wherein the highlighting editing module is used for highlighting cells to be filled in an editing page, receiving a first filling operation of a user on the highlighted cells and providing rule description about filling contents for the user; the system realizes the generation of the change bill meeting the requirements according to the standard requirements by the display interface module, the highlighting and editing module, the new adding module, the change content modifying module, the change content deleting module and the change bill generating module, improves the compiling efficiency, the standardization level of the change bill and reduces the rollback rate, and the borrowing part change notification bill is compiled by the change bill generating module by inquiring the borrowing situation of the pattern corresponding to the change of the new added pattern in other projects, thereby reducing the workload.

Inventors

SHAO SHENGMIN
YANG XINHUI
ZHANG AIPING
LIU LIMING
Zheng Xinghuai
SHEN YAN

Assignees

中国电子科技集团公司第五十二研究所

Dates

Publication Date: 20260508
Application Date: 20251230

Claims (10)

1. The system for generating the change list based on the EXCEL VBA is characterized by being used for carrying out through marking on the change list in the process of compiling the change list to obtain the change list meeting the requirements, and the system for generating the change list based on the EXCEL VBA comprises the following steps: The highlighting editing module is used for highlighting the cell to be filled in the editing page, receiving a first filling operation of a user on the highlighted cell, and providing rule description about filling content for the user; The new adding module is used for generating new adding contents with preset number in the modified content column of the edited page according to the operation of the user; the modification and change content module is used for modifying the newly added content according to user operation; the deleting and changing content module is used for deleting the newly added content according to user operation; and the change list generation module is used for generating a change list meeting the requirements.
2. The system for generating a modification list based on EXCEL VBA according to claim 1, wherein the types of the newly added contents comprise three types, namely newly added document modification, newly added pattern modification and batch newly added/voided; The new module comprises a first new unit and a second new unit, the first new unit comprises a new content changing button and a second new unit comprises a new content changing button above a designated position, when new content is generated, the first new unit or the second receiving unit receives a first clicking operation of a user on the new content changing button or the new content changing button above the designated position and generates a first window which comprises new document changing, new pattern changing and batch new/invalid and has selectivity after responding to the first clicking operation, the first new unit or the second receiving unit receives a selection operation of the user on one of the first window types, generates a second window corresponding to the new content type after responding to the selection operation, and generates new filling content corresponding to the content of the second window in the changing content of the editing page after responding to the second clicking operation.
3. The system for generating a modification ticket based on EXCEL VBA according to claim 2, wherein the second frame corresponding to the newly added document modification or newly added pattern modification comprises a document or pattern identification, a document or pattern name, a first modification type and a text box for modifying contents, the second frame corresponding to the batch newly added/voided modification comprises a second modification type, a pattern identification and a text box for modifying contents, wherein the first modification type of the newly added document modification comprises an integral replacement, an integral addition, an integral voiding, a local page replacement and a local page replacement, and a local page replacement and a local page voiding, the first modification type of the newly added pattern modification comprises a pattern addition, a pattern voiding, a pattern replacement, a pattern shift-in and a pattern removal, and the second modification type comprises a pattern addition and a pattern voiding.
4. The system for generating a modification list based on EXCEL VBA according to claim 2, wherein the modification content module comprises a modification content button, and when the new content is modified, the modification content module receives a first selection operation of a user on the new content and a second click operation of the user on the modification content button, pops up a second window corresponding to the current piece of the new content in response to the first selection operation and the second click operation, and receives a modification operation of the user on the content in the second window to modify the new content.
5. The system for generating a modified ticket based on EXCEL VBA according to claim 2, wherein the modified content deleting module comprises a modified content deleting button, and when deleting the new content, the modified content deleting module receives a second selection operation of the new content from the user and a third click operation of the modified content deleting button from the user, pops up a second window corresponding to the current content after responding to the second selection operation and the third click operation, and receives a deletion operation of the content in the second window from the user, so as to delete the new content.
6. The system for generating a modification list based on EXCEL VBA according to claim 1, wherein the modification list generating module further comprises a modification list generating button, and the modification list generating module receives a third click operation of the modification list generating button by a user, and after responding to the third click operation, firstly checks whether the cells to be filled in the editing page are completely filled in; The generation modification list module typesets the editing page after complete filling, namely, the number of lines occupied by all newly added contents of a modification content column in the editing page after complete filling is compared with a preset value, if the number of lines is larger than the preset value, paging is carried out, otherwise, paging is not carried out, and all contents belonging to the same newly added content are kept in the same page; Obtaining a change sheet meeting the requirements after typesetting; The change list generation module also adds work protection to the change list meeting the requirements; the change generation module also judges whether to pop up a prompt to a user or not and judges whether to generate a borrowed change notification.
7. The system for generating a modification ticket based on EXCEL VBA according to claim 6, wherein the modification ticket generation module is configured to, when determining whether to pop up a prompt to a user, operate as follows: Generating a change list module to inquire new content about the change of the new pattern, and generating a prompt that the pattern cannot be newly added if the change type of the current new pattern change is pattern new and the pattern mark in the new pattern change is checked to be borrowed by other items; If the change type of the current newly added pattern change is pattern replacement, revocation, shift-in or shift-out and the pattern mark is not checked to be borrowed by other items in the newly added pattern change, generating a prompt that the pattern cannot be replaced, revoked, shift-in or shift-out by the change single module; if the change type of the current newly added pattern change is pattern invalidation and the pattern mark in the newly added pattern change is checked to be borrowed by other items, a generation change single module generates a prompt for synchronously initiating a flow if the pattern is invalidated and other subject changes; And the change list generation module receives the operation of whether the user modifies the generated change list meeting the requirements according to the prompt selection.
8. The system for generating a modification ticket based on EXCEL VBA according to claim 6, wherein the module for generating the modification ticket is configured to, when determining whether to generate the borrowed item modification ticket, operate as follows: If none is displayed in the usability column in the change list meeting the requirements, and the change list generation module inquires that the newly added pattern change does not have borrowing in other items, a borrowing part change notification list is not generated; if none is displayed in the usability column in the change list meeting the requirements, and the change list generation module inquires that the newly added pattern change is borrowed in other projects, a borrowed part change notification list is generated; If the borrowed part change notification list is displayed in the usability column in the change list meeting the requirements, and the generation change list module inquires that the newly added pattern change is not borrowed in other items, a blank borrowed part change notification list is generated; If the borrowed part change notification list is displayed in the usability column in the change list meeting the requirements, and the generation change list module inquires that the newly added pattern change is borrowed in other items, the borrowed part change notification list is generated; If none and no inquiry usability are displayed in the usability column in the change list meeting the requirements, whether the newly added pattern change is borrowed in other projects is not inquired, and a borrowed part change notice is not generated.
9. The system for generating an EXCEL VBA based manifest of claim 2, further comprising a modify manifest module for returning to the edit page and for deleting the generated satisfactory manifest and borrowed component change notification according to user operation.
10. The system for generating the EXCEL VBA-based change order according to claim 1, further comprising a display interface module, wherein the display interface module displays an editing page and the generated change order meeting requirements, a toolbar is further arranged on the interface, and the newly added change content button, the changed change content button, the deleted change content button, the generated change single button and the changed change single button are integrated in the toolbar.

Description

System for generating modification list based on EXCEL VBA Technical Field The invention belongs to the technical field of file generation, and particularly relates to a generation system of a change order based on EXCEL VBA. Background For a technical state change, the underwriting entity should compile a technical state change notification file. The state of the art change notification file in the current enterprise is in the form of a change ticket. At present, manual input is needed for compiling a change bill, the problems that filling content does not meet standard requirements, compiling quality is poor, rollback rate is high and the like exist, and in addition, time and labor are wasted when a borrowed part change notice bill is compiled by manually filling and inquiring borrowing conditions of change drawing numbers in other problems, so that change progress is affected to a certain extent. Disclosure of Invention The invention aims to solve the problems in the background art and provides a generation system of a change order based on EXCEL VBA. In order to achieve the above purpose, the technical scheme adopted by the invention is as follows: the invention provides a generation system of a change list based on EXCEL VBA, which is used for carrying out through marking on the change list in the process of compiling the change list to obtain the change list meeting the requirements, and the generation system of the change list based on the EXCEL VBA comprises the following steps: The highlighting editing module is used for highlighting the cell to be filled in the editing page, receiving a first filling operation of a user on the highlighted cell, and providing rule description about filling content for the user; The new adding module is used for generating new adding contents with preset number in the modified content column of the edited page according to the operation of the user; the modification and change content module is used for modifying the newly added content according to user operation; the deleting and changing content module is used for deleting the newly added content according to user operation; and the change list generation module is used for generating a change list meeting the requirements. Preferably, the types of the added content include three types, namely added document change, added pattern change and batch addition/revocation; The new module comprises a first new unit and a second new unit, the first new unit comprises a new content changing button and a second new unit comprises a new content changing button above a designated position, when new content is generated, the first new unit or the second receiving unit receives a first clicking operation of a user on the new content changing button or the new content changing button above the designated position and generates a first window which comprises new document changing, new pattern changing and batch new/invalid and has selectivity after responding to the first clicking operation, the first new unit or the second receiving unit receives a selection operation of the user on one of the first window types, generates a second window corresponding to the new content type after responding to the selection operation, and generates new filling content corresponding to the content of the second window in the changing content of the editing page after responding to the second clicking operation. Preferably, the second window corresponding to the new document change or the new pattern change includes text boxes of a document or a pattern identifier, a document or a pattern name, a first change type and a change content, the second window corresponding to the new document change or the new pattern change includes text boxes of a second change type, a pattern identifier and a pattern name, wherein the first change type of the new document change includes integral replacement, integral addition, integral cancellation, local page replacement, simultaneous local page addition of local page replacement, and simultaneous local page cancellation of local page replacement, the first change type of the new pattern change includes pattern addition, pattern cancellation, pattern replacement, pattern shift-in and pattern shift-out, and the second change type includes pattern addition and pattern cancellation. Preferably, the modification and change content module includes a modification and change content button, and when the modification is performed on the newly-added content, the modification and change content module receives a first selection operation of the user on the newly-added content and a second click operation of the user on the modification and change content button, pops up a second window corresponding to the currently-added content after responding to the first selection operation and the second click operation, and receives a modification operation of the user on the content in the second window, thereby realizing the modi