CN107357825A - A kind of project document management system based on database - Google Patents
A kind of project document management system based on database Download PDFInfo
- Publication number
- CN107357825A CN107357825A CN201710454816.5A CN201710454816A CN107357825A CN 107357825 A CN107357825 A CN 107357825A CN 201710454816 A CN201710454816 A CN 201710454816A CN 107357825 A CN107357825 A CN 107357825A
- Authority
- CN
- China
- Prior art keywords
- file
- project
- module
- query
- borrow
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/148—File search processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiments of the invention provide a kind of project document management system based on database, the system includes：Switch projects module, project information display module, project search module, newly-built catalogue module, borrow initiation module, borrow approval module, borrow list block, batch uploading module, batch download module.The management such as the present invention is by being borrowed, being examined to item file synthesis, batch is uploaded, batch is downloaded operate, and the integration to the various management functions of item file are realized, so as to realize the efficient management to item file.
Description
Technical field
The present invention relates to technical field of document management, more particularly to a kind of project document management system based on database
System.
Background technology
Current project document management system function in the management to project document is single, and each function is separate,
It can not be integrated into same management system so that relatively low to the efficiency of management of project document.
The content of the invention
The invention provides a kind of project document management system based on database, to solve project text of the prior art
The problem of efficiency of management of shelves is relatively low.
In order to solve the above problems, according to an aspect of the present invention, the invention discloses a kind of item based on database
Mesh document file management system, including：
Switch projects module, for being instructed according to the instruction of the project query of user or items selection, obtained in database
Destination item document library corresponding to the project query instruction or items selection instruction, will currently show in project document management system
The project document storehouse shown switches to the destination item document library, wherein, each project text in the destination item document library
Part and each project folder are shown according to the subordinate relation between item file in a manner of catalogue；
Project information display module, for according to the user to any one project folder in the catalogue of display
Selection operation, the project information of item file corresponding to selected project folder is shown in a manner of list；
The project information display module, it is additionally operable to the project to any one item file of display according to the user
The selection operation of information, the file content of the item file of selection is shown；
The project information display module, it is additionally operable to according to the user to any one project text in the catalogue of display
Part presss from both sides or chooses operation to any one item file of display, by the project folder chosen or the item file chosen
Attribute information is shown；
Project search module, for receiving search operation of the user to all items file in project document storehouse,
The user is searched in the project document storehouse has item file and the display of access rights；
Newly-built catalogue module, the target text selected for receiving the user in the destination item document library of display
Part presss from both sides, and receives the clicking operation to newly-built catalogue, and show newly-built inventory interface；
The newly-built catalogue module, it is additionally operable to receive the newly-built catalogue that the user inputs in the newly-built inventory interface
Attribute information, and the new folder under the destination folder according to the attribute information of the newly-built catalogue generates subordinate；
Initiation module is borrowed, each item file shown for receiving the user to the project information display module
Attribute information in the addition of destination item file borrow operation, the destination item file is added into borrowing to the user
Listed files；
It is described to borrow initiation module, it is additionally operable to receive the user and borrows the project to be borrowed of target in listed files to described
The selection operation of file, and receive and condition is borrowed to target item file to be borrowed, by target file to be borrowed
Condition is borrowed accordingly send to the approval list for borrowing approval module borrow file as copending, wherein, it is described to borrow
Condition includes Borrowing and reading power, borrows reason, borrows number of days；
It is described to borrow approval module, list is carried out to each copending file of borrowing in approval list for receiving approver
Trial at nisi prius batch or the suggestions made after examination of batch examination ＆ approval, changed according to the suggestions made after examination and each in the approval list copending borrow text
The approval status of part；
Borrow list block, for by it is described borrow user described in listed files it is each borrow file borrow information
Shown with approval information；
It is described to borrow list block, be additionally operable to receive the user to it is described borrow listed files in some borrow text
During the selection operation of part, some attribute information for borrowing file described in selection is shown；
It is described to borrow list block, be additionally operable to receive the user to it is described some borrow file check operation
When, some described file content for borrowing file is shown；
It is described to borrow list block, be additionally operable to receive the user to it is described borrow that examination ＆ approval in listed files pass through borrow
The down operation of file, by the storage catalogue borrowed file download and selected to the user of the corresponding down operation；
Batch uploading module, for will treat that the file destination that batch uploads is uploaded to target in the destination item document library
Uploading position, wherein, the file destination for treating that batch uploads includes：Local file, selected from the destination item document library
In file, the All Files under the folder content chosen from the destination item document library；
The batch uploading module, it is additionally operable to be uploaded to the destination item document in the file destination that will treat batch upload
In storehouse before target uploading position, batch editor is carried out to the attribute of the file destination treated batch and uploaded；
Batch download module, for selecting file destination to be downloaded, and selection pair from the destination item document library
Position is locally stored in the file destination to be downloaded, and the file destination batch to be downloaded is downloaded into the local deposits
Storage space is put, wherein, the file destination for treating that batch is downloaded includes：The file chosen from the destination item document library, from
All Files under the folder content chosen in the destination item document library.
Compared with prior art, the present invention includes advantages below：
The management operations such as the present invention can be borrowed to item file synthesis, examined, batch is uploaded, batch is downloaded, it is real
Now to the integration of the various management functions of item file, so as to realize the efficient management to item file.
Brief description of the drawings
Fig. 1 is a kind of structured flowchart of project document management system based on database of the embodiment of the present invention；
Fig. 2 is a kind of items selection or query interface schematic diagram of the embodiment of the present invention；
Fig. 3 is a kind of MDI schematic diagram of Ecuador Meng Texinayi construction projects of the embodiment of the present invention；
Fig. 4 is the interface schematic diagram of the item file under a kind of owner's contract documents folder of the embodiment of the present invention；
Fig. 5 is a kind of interface schematic diagram of the file content of the thin item table of full factory owner's item of the embodiment of the present invention；
Fig. 6 is the interface schematic diagram of the attribute information of a kind of project folder or item file of the embodiment of the present invention；
Fig. 7 is a kind of interface schematic diagram of search item file of the embodiment of the present invention；
Fig. 8 is a kind of interface schematic diagram of newly-built catalogue of the embodiment of the present invention；
Fig. 9 is that a kind of item file of the embodiment of the present invention borrows interface schematic diagram；
Figure 10 is that a kind of of the embodiment of the present invention borrows the schematic diagram for initiating interface；
Figure 11 is that the interface schematic diagram of file is borrowed in a kind of removal of the embodiment of the present invention；
Figure 12 is a kind of interface schematic diagram of approval list of the embodiment of the present invention；
Figure 13 is a kind of examination ＆ approval interface schematic diagram of file to be borrowed of the embodiment of the present invention；
Figure 14 is a kind of leader's examination ＆ approval interface schematic diagram of the embodiment of the present invention；
Figure 15 is a kind of interface schematic diagram for borrowing listed files of the embodiment of the present invention；
Figure 16 is a kind of interface schematic diagram for borrowing file of the embodiment of the present invention；
Figure 17 is a kind of interface schematic diagram for borrowing file content of the embodiment of the present invention；
Figure 18 is a kind of download interface schematic diagram for borrowing file of the embodiment of the present invention；
Figure 19 is a kind of batch upload interface schematic diagram of local file of the embodiment of the present invention；
Figure 20 be the embodiment of the present invention a kind of project document storehouse in file or folder file batch upload interface
Schematic diagram；
Figure 21 is the interface schematic diagram that a kind of file attribute to the upper transmitting file of batch of the embodiment of the present invention is changed；
Figure 22 is the interface schematic diagram that a kind of batch documents of the embodiment of the present invention are downloaded.
Embodiment
In order to facilitate the understanding of the purposes, features and advantages of the present invention, it is below in conjunction with the accompanying drawings and specific real
Applying mode, the present invention is further detailed explanation.
Reference picture 1, show a kind of structural frames of project document management system embodiment based on database of the present invention
Figure, can specifically include following module：
Switch projects module 11, for being instructed according to the instruction of the project query of user or items selection, obtained in database
Destination item document library corresponding to taking the project query instruction or items selection instruction, will be current in project document management system
The project document storehouse of display switches to the destination item document library, wherein, each project in the destination item document library
File and each project folder are shown according to the subordinate relation between item file in a manner of catalogue；
In a specific embodiment, as shown in Figures 2 and 3, it is when the user of project document management system logs in this
After system, in the items selection dialog box as shown in Figure 2 that can be ejected from present system selection need the project that manages or
Input needs the title for the project inquired about in items selection dialog box as shown in Figure 2, so as to show that user needs what is checked
The MDI of project, in this example, user have selected Ecuador's Meng Texinayi construction projects, therefore, illustrate shown in Fig. 3
Ecuador's Meng Texinayi construction projects project document storehouse interface, in the project document storehouse interface, involved by the project
And All Files and file be all to be showed by the subordinate relation between them in a manner of catalogue.
Project information display module 12, for according to the user to any one project folder in the catalogue of display
Selection operation, the project information of item file corresponding to selected project folder is shown in a manner of list；
In a specific embodiment, as shown in figure 4, having many files, Mei Gewen under the project document library directory
Part folder is lower to have sub-folder again, and user have selected the selection operation to owner's contract documents folder here, then the embodiment of the present invention
The can of project information display module 12 by the project information of each item file (being here 4 annexes) under owner's contract
(including file name, renewal time, project name etc.) is shown in a manner of list.
The project information display module 12, it is additionally operable to the item to any one item file of display according to the user
The selection operation of mesh information, the file content of the item file of selection is shown；
In a specific embodiment, as shown in figure 4, for the project information of 4 annexes shown in list, user
An item file (being here the thin item table of full factory owner's item) can be selected to be checked from 4 annexes, so the present invention is implemented
The file content of the example can displaying thin item table of full factory owner's item as shown in Figure 5.
The project information display module 12, it is additionally operable to according to the user to any one project in the catalogue of display
File chooses operation to any one item file of display, by the project folder chosen or the item file chosen
Attribute information shown；
In a specific embodiment, as shown in fig. 6, when any one in the left side catalogue of the MDI shown in Fig. 3
When any one annex (i.e. item file) is chosen by user in individual file or Fig. 4, then the system of the embodiment of the present invention can be with
By the attribute information of selected file or item file (here including base attribute, version, position, relation, history, power
Limit etc.) shown, wherein, base attribute includes data application scope, project code, file coding etc. as shown in Figure 6
Referring in particular to Fig. 6, will not be repeated here.
Project search module 13, for receiving search operation of the user to all items file in project document storehouse,
The user is searched in the project document storehouse has item file and the display of access rights；
In a specific embodiment, after item file as shown in Figure 4 is illustrated, it can be inputted in search column
Search content simultaneously clicks on search button, so as to realize the search to all items file in the project document storehouse, shown in Fig. 7, this
The system of inventive embodiments can search for the user in the project document storehouse has all items file of access rights
And show, do not shown then without possessing the file or folder of access rights.
Newly-built catalogue module 14, the target selected for receiving the user in the destination item document library of display
File, the clicking operation to newly-built catalogue is received, and show newly-built inventory interface；
In a specific embodiment, when user needs to increase new catalogue (i.e. Ziwen under management plan file
Part presss from both sides), user can select management plan file in the left side catalogue shown in Fig. 8 first, then, click in Fig. 8 interfaces
Newly-built category buttons, so as to show newly-built catalogue dialog box as shown in Figure 8 (i.e. newly-built inventory interface).
The newly-built catalogue module 14, it is additionally operable to receive newly-built catalogue of the user in the newly-built inventory interface input
Attribute information, and the new folder according to the attribute information of the newly-built catalogue generates subordinate under destination folder；
In a specific embodiment, with continued reference to Fig. 8, need to input this in newly-built inventory interface user and created
Catalogue (i.e. newly-built catalogue) attribute information (essential information including file, preset value, authority here, wherein, basic letter
Breath includes Folder Name, folder type and some remark informations), after determination is clicked on, the system of the embodiment of the present invention is just
The sub-folder being subordinated under the management plan file can be generated according to these attribute informations of the newly-built catalogue (i.e. here
New folder).
Initiation module 15 is borrowed, each project shown for receiving the user to the project information display module 14
Operation is borrowed in the addition of destination item file in the attribute information of file, and the destination item file is added to the user's
Borrow listed files；
In a specific embodiment, as shown in figure 9, when project information display module 14 shows each item file
Attribute information when, user can borrow to each item file of display, especially by each project for choosing display
The destination item file (here including the pdf files and word document shown in Fig. 9) borrowed is needed in file, then, clicks on Fig. 9
" list is borrowed in addition " button in shown interface, so as to which the two the destination item files chosen are added into the use
Borrow in listed files at family.
It is described to borrow initiation module 15, it is additionally operable to receive the user and borrows the item to be borrowed of target in listed files to described
The selection operation of mesh file, and receive and condition is borrowed to target item file to be borrowed, by target text to be borrowed
Part and condition is borrowed accordingly send to the approval list for borrowing approval module 16 and borrow file as copending, wherein, it is described
Borrowing condition includes Borrowing and reading power, borrows reason, borrows number of days；
In a specific example, show that user added originally as shown in Figure 10 to borrowing in listed files
Each item file to be borrowed, at this moment, user can be initiated to borrow to first file in the list, wherein it is desired to select
First item file, and number of days is borrowed in input in Figure 10 interfaces, borrows reason, and Borrowing and reading power is set, clicking on
After borrowing button, it is possible to send first item file of selection and corresponding condition of borrowing to borrowing approval module 16
Approval list borrow file as copending.
In addition as shown in figure 11, the item file to be borrowed of any one in Figure 10 interfaces can also be removed, this
In Figure 11 only remain next item file to be borrowed, further, it is also possible to modification authority, such as shown in figure 11, filesselected, point
Modification authority (read-only, download) is hit, the authority of item file can be changed, wherein, can be with for the file that can not check online
Authority is changed to download when borrowing, such as compressed package.
It is described to borrow approval module 16, each copending file of borrowing in approval list is carried out for receiving approver
The individually suggestions made after examination of examination ＆ approval or batch examination ＆ approval, each in the approval list copending borrow is changed according to the suggestions made after examination
The approval status of file；
In a specific example, as shown in figure 12, borrow approval module 16 Figure 12 can be shown it is each pending
Batch borrowing file is shown, and approver can to it is each it is copending borrow that file carries out examination ＆ approval one by one or batch is examined, and
The approval status for borrowing the can of approval module 16 and being changed according to suggestions made after examination both of these documents in approval list of the present invention,
Such as in newly-built, examination ＆ approval.
User can be chosen by clicking on, and Quan Xuan, anti-choose are selected come the copending file of borrowing of some to Figure 12
In, it is possible to see it is copending as shown in fig. 13 that borrow file, examined, typing suggestions made after examination.
When approver is initiated to some item file when borrowing, acquiescence is as shown in figure 14, chooses leader's examination ＆ approval.
Borrow list block 17, for by it is described borrow user described in listed files it is each borrow file borrow letter
Breath and approval information are shown；
As shown in figure 15, borrowing information includes borrower, creation time, Borrowing period；Approval information includes approver, examined
The state of criticizing, suggestions made after examination.
It is described to borrow list block 17, be additionally operable to receive the user to it is described borrow listed files in some borrow
During the selection operation of file, some attribute information for borrowing file described in selection is shown；
For example, as shown in figure 16, can will be selected when user borrows file to some in Figure 15 to be selected
Some attribute information (including title, type, project name, approval status, authority) for borrowing file is shown.
It is described to borrow list block 17, be additionally operable to receive the user to it is described some borrow file check operation
When, some described file content for borrowing file is shown；
As shown in figure 17, (trigger when user is borrowed to some in Figure 16 when file is chosen and check operation), then
The file content that this shown in Figure 17 can be borrowed to file is shown.
It is described to borrow list block 17, be additionally operable to receive the user to it is described borrow that examination ＆ approval in listed files pass through borrow
The down operation of file is read, by the storage catalogue borrowed file download and selected to the user of the corresponding down operation；
Wherein, as shown in figure 18, the file of borrowing examined and passed through in listed files is borrowed for this, user can enter
Row is downloaded, so as to borrow file download accordingly into the storage catalogue of local.
Batch uploading module 18, for will treat that the file destination that batch uploads is uploaded to mesh in the destination item document library
Uploading position is marked, wherein, the file destination for treating that batch uploads includes：Local file (as shown in figure 19), from the target
Under the file (as shown in figure 20) chosen in project document storehouse, the folder content chosen from the destination item document library
All Files (as shown in figure 20)；
The batch uploading module 18, it is additionally operable to be uploaded to the destination item text in the file destination that will treat batch upload
In shelves storehouse before target uploading position, batch editor is carried out to the attribute of the file destination treated batch and uploaded；
Wherein, as shown in figure 21, the attribute that can also treat the file that batch uploads is modified.
Batch download module 19, for selecting file destination to be downloaded from the destination item document library, and select
Position is locally stored to the file destination to be downloaded, the file destination batch to be downloaded is downloaded into the local
Storage location, wherein, the file destination for treating that batch is downloaded includes：The file chosen from the destination item document library,
All Files under the folder content chosen from the destination item document library, it is specific as shown in figure 22.
By means of the above-mentioned project document management system of the embodiment of the present invention, item file can be integrated be borrowed,
The operations such as examination ＆ approval, batch are uploaded, batch is downloaded, realize the integration to the various management functions of item file, so as to realize to item
The efficient management of mesh file.
Alternatively, the system also includes the following module for being used to inquire about information used in above-mentioned module from database：
Acquisition module, be configured to respond to inquiry request, obtain the inquiry request using the minimum query feedback time as
The query planning of target and the query planning using minimum query time total length as target；
Execution module, it is configured as performing using the minimum query feedback time as the query planning of target and at least to inquire about
Total length of time is the query planning of target；
Whether control module, the query planning for being configured as detecting using minimum query time total length as target go to finger
Fixed point；
Output module, it is configured as exporting Query Result；
Wherein, detect that the query planning using minimum query time total length as target goes to finger in the control module
Before fixed point, query planning of the output module output using the minimum query feedback time as target performs obtained original query
As a result；Gone in response to the query planning that the control module detects using minimum query time total length as target specified
Point, it is the query planning of target so that the output module is defeated that the execution module, which is continued executing with using minimum query time total length,
Go out balance inquiring result；
Query planning wherein using the minimum query feedback time as target is the query planning connected using nested circulation, with
Minimum query time total length is using the query planning of Hash connection for the query planning of target, and the specified point is that Hash connects
The point that the structure stage connect terminates；
The query planning that wherein described execution module continues executing with using minimum query time total length as target includes：Perform
Module is not carried out nested circulation Connection inquiring from first in the driving table using the nested query planning for circulating connection and planned
Record start, perform using Hash connect query planning detection phase operation.
Alternatively, the execution module also includes：
Original query result sub-module stored, it is configured as storing the original query result；
Whole Query Result sub-module storeds, it is configured as inquiry of the storage using minimum query time total length as target and advises
The whole Query Results drawn；
Balance inquiring result obtains submodule, is configured as that original query result will be removed in whole Query Results, obtains
Balance inquiring result.
Alternatively, the system also includes：
Evaluation module, the Cost Model for being configured to, with database query engine optimizer are assessed with minimum query time
Total length uses the query planning of Hash connection for the query planning of target and merges the query planning connected using sequence；
Selecting module, it is configured as selecting the query planning that cost is small in said two devices to be used as with minimum query time overall length
Spend the query planning for target.
The above-mentioned module used when being inquired about to database included by means of said system, can cause right
When item file is managed, when inquiring about database, it can be come with minimum query feedback time and minimum query execution time
The inquiry is performed, so as to meet search request of the project document management to database, the efficiency of management of Improving Project document.
Alternatively, the system also includes：
Analysis module, generate and analyze according to file attribute for the item file to different type product in the database
Report, wherein, the file attribute includes product price, project the country one belongs to；
For example, analyzed by the product price of each item file to product A, so as to generate product A near
The price trend of several years, or the country at the place of product A each item file is analyzed, so as to generate product A
In the demand distribution situation of every country.
Adjusting module, for the analysis report according to different type product, adjust to the raw material of respective type product
Purchase parameter.
For example, can be adjusted according to the analysis including buying parameter of the class to the raw material of the product of respective type,
Such as price trend is downward trend, then materials procurement can be reduced, for example, it is larger in the demand of C countries, then can be to C
The product A of country raw material increase amount of purchase.
So, can of the embodiment of the present invention is generated to each production according to each item file of project document management system
The analysis report of product, consequently facilitating the buying parameter of product is adjusted flexibly, realize that income is optimal.
Alternatively, the system deployment includes master server and sub-server, the system in server, the server
Including：
Synchronization module, for being spaced same project on the master server and the sub-server to schedule
Data synchronize.
That is, the system of the present invention be while can be deployed in master server (such as Pekinese's server), also portion
Affix one's name at sub-server (such as overseas server), wherein, due to abroad also having project, it is necessary to carry out the management of project document, because
This, in order to which the information for some project for ensureing to store in overseas server can inquire on master server, the present invention is implemented
The synchronization module of example needs that master server and sub-service are engaged according to certain time interval (such as 3 days, one week, one month etc.)
Data message on device on identical items synchronizes, and is easy to the strange land management to project.
Alternatively, the system also includes：
Approval distributing module, for the copending document flow of preset kind in the project document management system to be gone into item
Mesh approval system so that the project examination system examines the table of comparisons according to default document, determines the pending certification of different type
The approval process of shelves is to be examined.
For example, certain form of document (such as contract, equipment purchase document) needs to examine in project document management system,
Then the system of the embodiment of the present invention can be by these document automatic flows to project examination system, and such project examination system can
To examine the table of comparisons (being provided with different approval processes corresponding to different type document) according to default document, each project is determined
The approval process of document is so as to being examined.
The automatic flow of copending document between project document management system and project examination system has been achieved in that, without
Manual operation, realize the automation of project examination.
Alternatively, the system also includes：
Archive module is examined, the project document passed through for receiving the examination ＆ approval that the project examination system is sent, and determine
The file belonging to the project document passed through is examined, and the project document that the examination ＆ approval pass through is stored into corresponding folder.
Wherein, for project examination system, after the completion of it is examined to each project document, for examining the project passed through
Document can be automatically sent to project document management system, and such project document management system can is literary to the project received
Shelves are stored into the corresponding folder in the corresponding project document library described in the project document.
So, the embodiment of the present invention realizes project examination system to examining the project document passed through to project document management
The automatic upload of system, avoids manual entry, lifts the treatment effeciency cleared a paper.
Alternatively, the examination ＆ approval archive module, is additionally operable to receive that the project examination system sends to each copending
The approval record table generated after document examination ＆ approval, and the approval record table is stored into the database.
Wherein, the approval record table that project document management system can also be sent to project examination system is deposited automatically
Storage.
Alternatively, the identical file stored in the project document management system and the project examination system, institute
It is identical to state storage mark of the identical file in the project document management system and the project examination system.
That is, for the identical file stored in project document management system and project examination system, they
File identification is consistent, can so ensure the uniformity of file, avoid file from being got muddled in approval process, and can be with
So that same file can be interacted in two systems, shared.
It should be noted that for embodiment of the method, in order to be briefly described, therefore it is all expressed as to a series of action group
Close, but those skilled in the art should know, the embodiment of the present invention is not limited by described sequence of movement, because according to
According to the embodiment of the present invention, some steps can use other orders or carry out simultaneously.Secondly, those skilled in the art also should
Know, embodiment described in this description belongs to preferred embodiment, and the involved action not necessarily present invention is implemented
Necessary to example.
Each embodiment in this specification is described by the way of progressive, what each embodiment stressed be with
The difference of other embodiment, between each embodiment identical similar part mutually referring to.
It should be understood by those skilled in the art that, the embodiment of the embodiment of the present invention can be provided as system, device or calculate
Machine program product.Therefore, the embodiment of the present invention can use complete hardware embodiment, complete software embodiment or combine software and
The form of the embodiment of hardware aspect.Moreover, the embodiment of the present invention can use one or more wherein include computer can
With in the computer-usable storage medium (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.) of program code
The form of the computer program product of implementation.
The embodiment of the present invention is with reference to terminal device (system) according to embodiments of the present invention and computer program product
Flow chart and/or block diagram describe.It should be understood that can be by every in computer program instructions implementation process figure and/or block diagram
One flow and/or the flow in square frame and flow chart and/or block diagram and/or the combination of square frame.These computers can be provided
Programmed instruction is to the place of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing terminal equipments
Device is managed to produce a machine so that pass through computer or the finger of the computing device of other programmable data processing terminal equipments
Order, which produces, to be used to realize what is specified in one flow of flow chart or multiple flows and/or one square frame of block diagram or multiple square frames
The device of function.
These computer program instructions, which may be alternatively stored in, can guide computer or other programmable data processing terminal equipments
In the computer-readable memory to work in a specific way so that the instruction being stored in the computer-readable memory produces bag
The manufacture of command device is included, the command device is realized in one flow of flow chart or multiple flows and/or one side of block diagram
The function of being specified in frame or multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing terminal equipments so that
Series of operation steps is performed on computer or other programmable terminal equipments to produce computer implemented processing, so that
The instruction performed on computer or other programmable terminal equipments is provided for realizing in one flow of flow chart or multiple flows
And/or specified in one square frame of block diagram or multiple square frames function the step of.
Although having been described for the preferred embodiment of the embodiment of the present invention, those skilled in the art once know base
This creative concept, then other change and modification can be made to these embodiments.So appended claims are intended to be construed to
Including preferred embodiment and fall into having altered and changing for range of embodiment of the invention.
Finally, it is to be noted that, herein, such as first and second or the like relational terms be used merely to by
One entity or operation make a distinction with another entity or operation, and not necessarily require or imply these entities or operation
Between any this actual relation or order be present.Moreover, term " comprising ", "comprising" or its any other variant meaning
Covering including for nonexcludability, so that process, method, article or terminal device including a series of elements are not only wrapped
Those key elements, but also the other element including being not expressly set out are included, or is also included for this process, method, article
Or the key element that terminal device is intrinsic.In the absence of more restrictions, wanted by what sentence "including a ..." limited
Element, it is not excluded that other identical element in the process including the key element, method, article or terminal device also be present.
Above to a kind of project document management system based on database provided by the present invention, it is described in detail,
Specific case used herein is set forth to the principle and embodiment of the present invention, and the explanation of above example is simply used
Understand the method and its core concept of the present invention in help；Meanwhile for those of ordinary skill in the art, according to the present invention's
Thought, there will be changes in specific embodiments and applications, in summary, this specification content should not be construed as
Limitation of the present invention.
Claims (10)
- A kind of 1. project document management system based on database, it is characterised in that including：Switch projects module, for being instructed according to the instruction of the project query of user or items selection, in database described in acquisition Destination item document library corresponding to project query instruction or items selection instruction, by what is currently shown in project document management system Project document storehouse switches to the destination item document library, wherein, each item file in the destination item document library and Each project folder is shown according to the subordinate relation between item file in a manner of catalogue；Project information display module, for according to selection of the user to any one project folder in the catalogue of display Operation, the project information of item file corresponding to selected project folder is shown in a manner of list；The project information display module, it is additionally operable to the project information to any one item file of display according to the user Selection operation, the file content of the item file of selection is shown；The project information display module, it is additionally operable to according to the user to any one project folder in the catalogue of display Or operation is chosen to any one item file of display, by the project folder chosen or the attribute for the item file chosen Information is shown；Project search module, for receiving search operation of the user to all items file in project document storehouse, described The user is searched in project document storehouse has item file and the display of access rights；Newly-built catalogue module, the file destination selected for receiving the user in the destination item document library of display Folder, receives the clicking operation to newly-built catalogue, and show newly-built inventory interface；The newly-built catalogue module, it is additionally operable to receive attribute of the user in the newly-built catalogue of the newly-built inventory interface input Information, and the new folder under the destination folder according to the attribute information of the newly-built catalogue generates subordinate；Initiation module is borrowed, the category of each item file shown for receiving the user to the project information display module Operation is borrowed in the addition of destination item file in property information, and the destination item file is added to the user and borrows file List；It is described to borrow initiation module, it is additionally operable to receive the user and borrows the item file to be borrowed of target in listed files to described Selection operation, and receive condition is borrowed to target item file to be borrowed, by target file to be borrowed and phase The condition of borrowing answered sends to the approval list for borrowing approval module and borrows file as copending, wherein, it is described to borrow condition Including Borrowing and reading power, borrow reason, borrow number of days；It is described to borrow approval module, each in approval list copending is borrowed by file individually examined for receiving approver Batch or batch examination ＆ approval suggestions made after examination, change each copending file of borrowing in the approval list according to the suggestions made after examination Approval status；Borrow list block, for by it is described borrow user described in listed files it is each borrow file borrow information and examine Information is criticized to be shown；It is described to borrow list block, be additionally operable to receive the user to it is described borrow listed files in some borrow file During selection operation, some attribute information for borrowing file described in selection is shown；It is described to borrow list block, be additionally operable to receive the user to it is described some borrow when checking operation of file, will Some described file content for borrowing file is shown；It is described to borrow list block, be additionally operable to receive the user to it is described borrow that examination ＆ approval in listed files pass through borrow file Down operation, will the corresponding down operation the storage catalogue borrowed file download and selected to the user；Batch uploading module, for will treat that the file destination that batch uploads is uploaded to target upload in the destination item document library Position, wherein, the file destination for treating that batch uploads includes：Local file, choose from the destination item document library All Files under file, the folder content chosen from the destination item document library；The batch uploading module, it is additionally operable to be uploaded in the destination item document library in the file destination that will treat batch upload Before target uploading position, batch editor is carried out to the attribute of the file destination treated batch and uploaded；Batch download module, for selecting file destination to be downloaded from the destination item document library, and select to described Position is locally stored in file destination to be downloaded, and the file destination batch to be downloaded is downloaded to and described position is locally stored Put, wherein, the file destination for treating that batch is downloaded includes：The file chosen from the destination item document library, from described All Files under the folder content chosen in destination item document library.
- 2. system according to claim 1, it is characterised in that the system also includes：Acquisition module, be configured to respond to inquiry request, obtain the inquiry request using the minimum query feedback time as target Query planning and query planning using minimum query time total length as target；Execution module, it is configured as performing using the minimum query feedback time as the query planning of target and with minimum query time Total length is the query planning of target；Control module, it is specified whether the query planning for being configured as detecting using minimum query time total length as target goes to Point；Output module, it is configured as exporting Query Result；Wherein, detect that the query planning using minimum query time total length as target goes to specified point in the control module Before, query planning of the output module output using the minimum query feedback time as target performs obtained original query knot Fruit；Detect that the query planning using minimum query time total length as target goes to specified point in response to the control module, The execution module continues executing with the query planning using minimum query time total length as target so that the output module exports Balance inquiring result；Query planning wherein using the minimum query feedback time as target is using the query planning of nested circulation connection, with minimum Query time total length is using the query planning of Hash connection for the query planning of target, and the specified point is Hash connection The point that the structure stage terminates；The query planning that wherein described execution module continues executing with using minimum query time total length as target includes：Execution module The nested note for circulating Connection inquiring and planning is not carried out from first in the driving table using the nested query planning for circulating connection Record starts, and performs the operation of the detection phase of the query planning connected using Hash.
- 3. system according to claim 2, it is characterised in that the execution module also includes：Original query result sub-module stored, it is configured as storing the original query result；Whole Query Result sub-module storeds, storage is configured as using minimum query time total length as the query planning of target Whole Query Results；Balance inquiring result obtains submodule, is configured as that original query result will be removed in whole Query Results, is saved Query Result.
- 4. system according to claim 2, it is characterised in that the system also includes：Evaluation module, the Cost Model for being configured to, with database query engine optimizer are assessed with minimum query time overall length Spend the query planning connected for the query planning of target using Hash and the query planning for merging connection using sequence；Selecting module, be configured as selecting in said two devices the small query planning of cost be used as using minimum query time total length as The query planning of target.
- 5. system according to claim 1, it is characterised in that the system also includes：Analysis module, analysis report is generated according to file attribute for the item file to different type product in the database Accuse, wherein, the file attribute includes product price, project the country one belongs to；Adjusting module, for the analysis report according to different type product, adjust the buying of the raw material to respective type product Parameter.
- 6. system according to claim 1, it is characterised in that the system deployment includes in server, the server Master server and sub-server, the system include：Synchronization module, for being spaced the data of same project on the master server and the sub-server to schedule Synchronize.
- 7. system according to claim 1, it is characterised in that the system also includes：Approval distributing module, examined for the copending document flow of preset kind in the project document management system to be gone into project The system of criticizing so that the project examination system examines the table of comparisons according to default document, determines the copending document of different type Approval process is to be examined.
- 8. system according to claim 7, it is characterised in that the system also includes：Archive module is examined, the project document passed through for receiving the examination ＆ approval that the project examination system is sent, and determine to examine The file belonging to project document passed through, and the project document that the examination ＆ approval pass through is stored into corresponding folder.
- 9. system according to claim 8, it is characterised in that the examination ＆ approval archive module, be additionally operable to receive the project Approval system send to the approval record table that is generated after each copending document examination ＆ approval, and by the approval record table store to In the database.
- 10. system according to claim 7, it is characterised in that examined in the project document management system and the project The identical file stored in the system of criticizing, the identical file is in the project document management system and the project examination system In storage mark it is identical.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710454816.5A CN107357825A (en) | 2017-06-15 | 2017-06-15 | A kind of project document management system based on database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710454816.5A CN107357825A (en) | 2017-06-15 | 2017-06-15 | A kind of project document management system based on database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107357825A true CN107357825A (en) | 2017-11-17 |
Family
ID=60273765
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710454816.5A Pending CN107357825A (en) | 2017-06-15 | 2017-06-15 | A kind of project document management system based on database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107357825A (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107993051A (en) * | 2017-11-29 | 2018-05-04 | 珠海市艾森科技有限公司 | Material document management method and its management system |
| CN108229930A (en) * | 2018-02-08 | 2018-06-29 | 北京汽车研究总院有限公司 | A kind of automobile development valve point delivers property management reason system |
| CN109471840A (en) * | 2018-10-15 | 2019-03-15 | 北京海数宝科技有限公司 | Fileview method, apparatus, computer equipment and storage medium |
| CN110413626A (en) * | 2019-07-31 | 2019-11-05 | 上海掌门科技有限公司 | Promotion message update, method for uploading, device, electronic equipment and medium |
| CN110825702A (en) * | 2019-11-12 | 2020-02-21 | 广发证券股份有限公司 | Investment bank work manuscript management method and system |
| CN111639052A (en) * | 2020-06-10 | 2020-09-08 | 刘庆辉 | Online file examination system and device |
| CN111651196A (en) * | 2020-06-24 | 2020-09-11 | 腾讯科技（深圳）有限公司 | Document publishing method, device and server |
| CN111680323A (en) * | 2020-05-26 | 2020-09-18 | 广州多益网络股份有限公司 | Code borrowing protection method and system |
| CN111723197A (en) * | 2020-06-28 | 2020-09-29 | 贵州电网物资有限公司 | Electronic borrowing management system for power grid bidding archive |
| CN111767441A (en) * | 2020-07-03 | 2020-10-13 | 中国农业银行股份有限公司贵州省分行 | Document management and operation and maintenance system |
| CN111881442A (en) * | 2020-08-07 | 2020-11-03 | 浙江汇泽医药科技有限公司 | Cross-device file management method and system |
| CN112100462A (en) * | 2020-11-17 | 2020-12-18 | 甬矽电子(宁波)股份有限公司 | Project file generation method and device, server and data acquisition system |
| CN112150113A (en) * | 2020-09-28 | 2020-12-29 | 建信金融科技有限责任公司 | Method, device and system for borrowing file data and method for borrowing data |
| CN113743898A (en) * | 2021-08-31 | 2021-12-03 | 远光软件股份有限公司 | Method for file grading authorization, computer device and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102368321A (en) * | 2011-11-01 | 2012-03-07 | 苏州万戈软件科技有限公司 | Office cost management control method based on office management system supported by short message |
| CN102968420A (en) * | 2011-08-31 | 2013-03-13 | 国际商业机器公司 | Database query method and system |
| CN105678435A (en) * | 2014-11-19 | 2016-06-15 | 镇江金软计算机科技有限责任公司 | Document management system on the basis of B/S configuration |
| CN106503901A (en) * | 2016-10-29 | 2017-03-15 | 合肥桐科电子科技有限公司 | A kind of education office automation chain of command |
-
2017
- 2017-06-15 CN CN201710454816.5A patent/CN107357825A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102968420A (en) * | 2011-08-31 | 2013-03-13 | 国际商业机器公司 | Database query method and system |
| CN102368321A (en) * | 2011-11-01 | 2012-03-07 | 苏州万戈软件科技有限公司 | Office cost management control method based on office management system supported by short message |
| CN105678435A (en) * | 2014-11-19 | 2016-06-15 | 镇江金软计算机科技有限责任公司 | Document management system on the basis of B/S configuration |
| CN106503901A (en) * | 2016-10-29 | 2017-03-15 | 合肥桐科电子科技有限公司 | A kind of education office automation chain of command |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107993051A (en) * | 2017-11-29 | 2018-05-04 | 珠海市艾森科技有限公司 | Material document management method and its management system |
| CN108229930A (en) * | 2018-02-08 | 2018-06-29 | 北京汽车研究总院有限公司 | A kind of automobile development valve point delivers property management reason system |
| CN109471840A (en) * | 2018-10-15 | 2019-03-15 | 北京海数宝科技有限公司 | Fileview method, apparatus, computer equipment and storage medium |
| CN110413626A (en) * | 2019-07-31 | 2019-11-05 | 上海掌门科技有限公司 | Promotion message update, method for uploading, device, electronic equipment and medium |
| CN110825702A (en) * | 2019-11-12 | 2020-02-21 | 广发证券股份有限公司 | Investment bank work manuscript management method and system |
| CN111680323A (en) * | 2020-05-26 | 2020-09-18 | 广州多益网络股份有限公司 | Code borrowing protection method and system |
| CN111639052A (en) * | 2020-06-10 | 2020-09-08 | 刘庆辉 | Online file examination system and device |
| CN111651196A (en) * | 2020-06-24 | 2020-09-11 | 腾讯科技（深圳）有限公司 | Document publishing method, device and server |
| CN111723197A (en) * | 2020-06-28 | 2020-09-29 | 贵州电网物资有限公司 | Electronic borrowing management system for power grid bidding archive |
| CN111767441A (en) * | 2020-07-03 | 2020-10-13 | 中国农业银行股份有限公司贵州省分行 | Document management and operation and maintenance system |
| CN111881442A (en) * | 2020-08-07 | 2020-11-03 | 浙江汇泽医药科技有限公司 | Cross-device file management method and system |
| CN112150113A (en) * | 2020-09-28 | 2020-12-29 | 建信金融科技有限责任公司 | Method, device and system for borrowing file data and method for borrowing data |
| CN112100462A (en) * | 2020-11-17 | 2020-12-18 | 甬矽电子(宁波)股份有限公司 | Project file generation method and device, server and data acquisition system |
| CN113743898A (en) * | 2021-08-31 | 2021-12-03 | 远光软件股份有限公司 | Method for file grading authorization, computer device and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107357825A (en) | A kind of project document management system based on database | |
| US20210318851A1 (en) | Systems and Methods for Dataset Merging using Flow Structures | |
| CN108351883B (en) | Display of dynamic contextual pivot grid analysis | |
| CN100511054C (en) | Experiment management system and method | |
| US20100217777A1 (en) | System for Automatic Arrangement of Portlets on Portal Pages According to Semantical and Functional Relationship | |
| CN100408280C (en) | Robot system provided with robot controller | |
| EP3063677A1 (en) | Real-time search tuning | |
| CN103150320B (en) | The system and method that content is issued for electronics | |
| CN108021107B (en) | Production support system, production support method, and production support program | |
| US20210342920A1 (en) | Adaptively enhancing procurement data | |
| US7653452B2 (en) | Methods and computer systems for reducing runtimes in material requirements planning | |
| CN103026334A (en) | Data classification | |
| EP3299968A1 (en) | Big data calculation method and system | |
| CN107391535A (en) | The method and device of document is searched in document application | |
| CN106294785A (en) | Content Selection method and system | |
| CN102722784A (en) | Method for setting list or quota rapidly | |
| CN103984752B (en) | Animation resource retrieval management system | |
| EP3009900A1 (en) | Dynamic recommendation of elements suitable for use in an engineering configuration | |
| CN108874395A (en) | Hard Compilation Method and device during a kind of modularization stream process | |
| US20140006228A1 (en) | E-Commerce Data Management and Software Application | |
| CN114386920A (en) | Information operation system and method based on data sharing | |
| Eder et al. | A knowledge management approach to support concurrent engineering in wiring harness development | |
| JPH08305724A (en) | Device for managing design supporting information document | |
| CN102467505B (en) | Product information searching method, system and device | |
| CN113327101A (en) | Technical management method for realizing product configuration by using PDM integrated system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171117 |
|
| RJ01 | Rejection of invention patent application after publication |