TWI223169B

TWI223169B - Department relation encoding system and method

Info

Publication number: TWI223169B
Application number: TW92121332A
Authority: TW
Inventors: Guang-Shin Lin; Xiao-Min Zhang
Original assignee: Inventec Corp
Priority date: 2003-08-05
Filing date: 2003-08-05
Publication date: 2004-11-01
Also published as: TW200506658A

Abstract

The present invention is a department relation encoding system and method, which is provided for the user to search the hierarchical relation between departments. The method provides a department relation encoding system to edit the encoding data between departments, so that the user can use the system for query operation. The system includes a configuration module, an encoding data editing unit, a database, a data searching module, and a data integration module. The system is to add two new data fields for each department, which are the department relation code and the present department code, and combine them as a department code to represent the upper and lower hierarchical relations in the organization structure for arbitrary department. The method can change the field value of the encoding field according to the user requirement, so as to conduct the maintenance operations, such as adding, modifying and deleting, on the department relation inside the organization according to the practical requirement.

Description

1223169 案號 92121332 年Π月Π曰修正五、發明說明（1) 【發明所屬之技術領域】本發明係有關於一種資料檢索技術，尤指一種利用不同定義之編碼表示任一部門於組織結構中之層級關係，以提高部門關係查找效率之部門關係編碼系統及方法。【先前技術】訂定明確之部門層級關係，對任何企業而言均為一制度化管理的象徵，唯有明確訂定部門彼此間之上、下層級關係，方可令各部門彼此產生一種相互約束的牵制作用，藉以提高企業本身於行政管理方面之效率，此外，企業内部的相關部門，諸如人事部、財務部及總務部等，於此些部門之業務運作上係需對企業内部之組織架構（如部門編制、層級關係、負責事務等）有一全盤的瞭解與掌握，俾令相關事務（如人員調職、升遷，經費支出流向等）之運作得以順暢進行，但，若以現今之組織架構而言，係均較以往顯得龐大且複雜，若欲於結構龐大之組織架構中逐項執行經營管理上之相關業務，不但漫無方向且毫無效率可言，是故，多數規模較大之企業，均已應用部門關係管理系統作為部門管理事務之主要輔助工具，祈藉由電腦化之管理方式，減少管理人力及金錢等營業成本之開銷，並可直接提高管理的績效以減少錯誤發生的機率，然，現今的部門關係管理系統中，係僅紀錄每一部門的直接上級部門，若欲查找該部門之所有上級部門及下級部門時，遂需採用遞迴方式進行查找作業，但因遞迴方式係利用暫存堆疊（Stack)的觀念執行運作，且遞迴方式於運作過程中，係會耗用堆疊記憶體，此乃因每次呼叫遞迴時，均需1223169 Case No. 92121332 Π / month Π Amendment V. Description of the invention (1) [Technical field to which the invention belongs] The present invention relates to a data retrieval technology, especially a code that uses different definitions to indicate any department in the organizational structure Department relationship coding system and method for improving department relationship finding efficiency. [Previous technology] Establishing a clear department-level relationship is a symbol of institutionalized management for any enterprise. Only by clearly defining the relationship between departments above and below each other can each department create a mutual relationship with each other. Constraints are used to improve the efficiency of the company's administrative management. In addition, relevant departments within the company, such as the personnel department, finance department, and general affairs department, need to organize the internal organization of the business operations of these departments. Have a comprehensive understanding of the structure (such as department establishment, hierarchical relationship, responsible affairs, etc.), so that the operation of related affairs (such as personnel transfer, promotion, flow of funds and expenditures) can be carried out smoothly, but if the current organizational structure In terms of systems, they are larger and more complicated than before. If you want to execute related business in the management organization item by item in a large organizational structure, it is not only directionless and inefficient, so most of the larger ones Enterprises have applied departmental relationship management systems as the main auxiliary tool for departmental management affairs. Management methods can reduce the overhead of management costs such as manpower and money, and can directly improve management performance to reduce the chance of errors. However, in the current departmental relationship management system, only the direct superior department of each department is recorded. When you want to find all the superior departments and subordinate departments of the department, you need to use the recursive method to perform the search operation, but because the recursive method uses the concept of a temporary stack to perform operations, and the recursive method is in the operation process, Will consume stack memory, because each time you call back, you need

17401英業達.ptc 第4頁 1223169 _案號92121332 年Π月Q曰修正_ 五、發明說明（2) 要使用一個記憶體來記錄上一次之程式位址參數、區域變數、傳回值等，故需要額外的儲存空間，亦因而造成參數之儲存程序較為費時，故需耗費使用者較多的查找時間，職是之故，如何建立一可同時查找'每個部門之上、下層級關係且又無需透過遞迴方式進行查找進而提高部門關係查找速度之部門關係管理系統，乃為目前亟待解決之技術問題。【發明内容】鑒於上述先前技術之缺點，本發明之主要目的在於提供一種部門關係編碼系統及方法，其可簡化使用者於查找部門層級關係時，所需執行的程序。本發明之另一目的在於提供一種部門關係編碼系統及方法，其無須透過遞迴方式即可執行部門上、下層級關係之查找作業，藉以減少硬體之使用空間，並可加快部門關係之查找速度。為達上揭目的，本發明提供一種部門關係編碼系統及方法。本發明之部門關係編碼系統係包括：（1)設定模組：其可供供管理人員按每一部門相互間之層級關係設定本部門編碼及部門關係編碼；（2)資料編輯單元，其内部係提供有本部門編碼欄位及部門關係編碼欄位，用以依據設定模組之設定值編輯每一部門之本部門編碼欄位值及部門關係編碼欄位值；（3)資料庫，用以儲存經由資料編輯單元編輯完成之本部門編碼欄位值及部門關係編碼攔位值合併組成之部門編碼；（4)資料搜尋模組，用以根17401 英业达 .ptc Page 4 1223169 _Case No. 92121332 Q / Y Modification_ V. Description of the invention (2) Use a memory to record the last program address parameters, regional variables, return values, etc. Therefore, it requires additional storage space, which also causes the parameter storage process to be time-consuming, so it takes more search time for users. The reason is how to establish a relationship that can simultaneously search for 'upper and lower levels of each department' A department relationship management system that does not need to search through recursive methods to improve the speed of department relationship search is a technical problem that needs to be solved at present. [Summary of the Invention] In view of the disadvantages of the foregoing prior art, the main object of the present invention is to provide a department relationship coding system and method, which can simplify the procedures that a user needs to perform when searching for department-level relationships. Another object of the present invention is to provide a department relationship coding system and method, which can perform the search of the relationship between the upper and lower levels of the department without recursively, thereby reducing the use of hardware space and speeding up the search of the department relationship. speed. To achieve the purpose of disclosure, the present invention provides a department relationship encoding system and method. The department relationship encoding system of the present invention includes: (1) a setting module: which can be used by managers to set the department code and department relationship code according to the hierarchical relationship between each department; (2) the data editing unit, which is internal The department code field and department relationship code field are provided for editing the department code field value and department relationship code field value of each department according to the setting value of the setting module; (3) database, use To store the department code composed of the department code field value and department relationship code block value edited by the data editing unit; (4) Data search module for rooting

17401英業達.ptc 第5頁 1223169 _案號92121332 年η月〇曰修正_ 五、發明說明（3) 據使用者所輸入的部門名稱配合該資料搜尋模組内部所含結構化查詢語言(Structure Query Language; SQL)之運作，於資料庫中查找出與該部門名稱有關之所有部門名稱;以及（J )，資料整合模組，.用以將經·.由資料搜'尋模"組查找出之與該部門名稱有關的所有部門予以排列組合，藉以建立各部門彼此間之上、下層級關係。本發明之部門關係編碼方法，係包含：（1)由管理人員依據第一部門（任一部門之代稱）及該部門與其他部門間之上、下層級關係設定第一部門之本部門編碼與部門關係編碼，並將設定完成之部門編碼（即本部門編碼與部門關係編碼合併組成）存放於資料庫中；（2)令該部門編碼系統判別管理人員是否欲對已儲存於資料庫中之部門編碼進行維護，如是，則進至步驟（3)，若否，遂並進至步驟（7) ;( 3)令該部門編碼系統判別管理人員欲對第一部門進行之維護項目係為更改上級部門、新增部門亦或者删除部門，若管理人員欲更改上級部門，則直接進至步驟（4) •，如管理人員欲新增部門，則進至步驟（5)；若管理人員欲刪除第一部門本身的本部門編碼欄位，遂並進至步驟（6) ;( 4)令該部門編碼系統判別第一部門原本有無上層部門存在，若無，遂將第一部門及其相關之下級部門之部門關係編碼欄位與所新增之上層部門部門關係編碼攔位合併於同一欄位，而後進至步驟（7)，如該部門原先已有上級部門，則令部門編碼系統將原上層部門之部門關係編碼攔位替換為已修改之上層部門部門關係編碼欄位，接著執行步驟（7)；17401 英业达 .ptc Page 5 1223169 _ Case No. 92121332 Modified _ Month _ V. Description of the invention (3) According to the department name entered by the user, cooperate with the structured query language contained in the data search module ( Structure Query Language; SQL) operation, find out all the department names related to the department name in the database; and (J), a data integration module. The group finds out all the departments related to the name of the department and arranges them to establish a hierarchical relationship between the departments. The department relationship encoding method of the present invention includes: (1) the management department sets the department's own department code and Department relationship code, and store the completed department code (that is, the combination of the department code and the department relationship code) in the database; (2) Have the department coding system determine whether the management staff wants to Department code for maintenance, if yes, go to step (3), if not, then go to step (7); (3) Make the department coding system determine that the maintenance project that the manager wants to perform in the first department is to change the superior Department, add department or delete department. If the manager wants to change the superior department, go directly to step (4) • If the manager wants to add a department, go to step (5); If the manager wants to delete the A department's own department coding field then proceeds to step (6); (4) causes the department's coding system to determine whether the first department originally had a higher-level department, and if not, it will The department relationship code field of the first department and its related lower-level departments are merged with the newly added upper-level department relationship code block in the same field, and then proceed to step (7). If the department originally had a higher-level department, Then the department coding system is made to replace the department relationship coding block of the original upper department with the modified department relationship coding field of the upper department, and then execute step (7);

17401英業達.ptc 第6頁 1223169 __案號92121332 年1月η日修正_ 五、發明說明（4) (5) 令部門編碼系統檢視管理人員有無指定上級部門予所新增之部門，若有，遂將所指定之上級部門的部門關係編碼與新增部門之本部門編碼欄位合併為該新增部門之部門關係編碼，4妾著執行步驟I 7);如未指定上級部-門予新增部門，則將新增部門之本部門編碼欄位及部門關係編碼攔位之攔位值設為相同，接著執行步驟（7)。 (6) 令該部門編碼系統檢示欲刪除之第一部門原本是否含有下層部門，若第一部門並未包含任何下層部門’ 則該部門編碼系統遂不執行任何處理程序，接著執行步驟 (7);如該第一部門原先已編制有下屬部門，遂令部門編碼系統將第一部門所含之每一下屬部門之部門關係編碼欄位中，表示第一部門之部門關係編碼欄位值刪除，而後進至步驟（7);以及 (7) 令該部門編碼系統處於待命模式，以隨時供組織内部之使用者輸入部門名稱，俾令該部門編碼系統根據使用者所輸入之部門名稱搜尋該部門名稱與其他部門間之層級關係。本發明之部門關係編碼方法係與一部門關係編碼系統配合，藉由部門之編碼，查找出各部門間之層級關係，該系統係於每一部門新增兩資料欄位，分別為部門關係編碼攔位及本部門編碼欄位，並將其組成一部門編碼，藉以表示任一部門於組織結構之上、下層級關係，藉以利用編碼方式迅速查找出部門間之層級關係，俾令管理人員無須使用遞迴方式進行部門關係之查找作業，進而提高查找部門層級關係之效率性。17401 英业达 .ptc Page 6 1223169 __ Case No. 92121332 Amended on January η _ V. Description of the invention (4) (5) Order the department coding system to check whether the manager has designated a superior department to the newly added department, If there is, then the department relationship code of the designated higher department and the department code field of the newly added department are merged into the department relationship code of the newly added department, and then step I 7) is performed; if the higher department is not specified- If the door is added to a new department, the block value of the department code field and the department relationship code block of the added department are set to be the same, and then step (7) is performed. (6) The department coding system is instructed to check whether the first department to be deleted originally contains a lower-level department. If the first department does not include any lower-level departments, then the department coding system does not execute any processing procedures, and then executes step (7 ); If the first department has previously been prepared with subordinate departments, then the department coding system will instruct the department relationship code field of each subordinate department included in the first department to indicate that the value of the department relationship code field of the first department is deleted , And then proceed to step (7); and (7) put the department coding system in standby mode, so that users within the organization can enter the department name at any time, and instruct the department coding system to search for the department based on the department name entered by the user Hierarchical relationship between department names and other departments. The departmental relationship encoding method of the present invention cooperates with a departmental relationship encoding system, and finds the hierarchical relationship between departments by the departmental encoding. The system adds two data fields to each department, which are the departmental relationship encoding respectively. The block and the department's coding field, and form a department code to represent the hierarchical relationship between any department above and below the organizational structure, so as to quickly find the hierarchical relationship between the departments by using coding methods, eliminating the need for managers Use the recursive method to search for departmental relationships, thereby improving the efficiency of finding department-level relationships.

1740]英業達.ptc 第7頁 1223169 案號 92121332 —_ 年3月1曰_修正 _ 五、發明說明（5) 【實施方式】以下係藉由特定的具體實例說明本發明之實施方式，熟悉此技藝之人士可由本說明書所揭示之内容輕易地瞭解本發明之其他優點與功效。本〜發明亦可藉由其^他不7同的具體實例加以施行或應用，本說明書中的各項1細節亦可基於不同觀點與應用，在不悖離本發明之精神下進行各種修飾與變更。以下之實施例係進一步詳細說明本發明之觀點，但並非以任何觀點限制本發明之範疇。 (實施例）第1圖為一方塊圖，其係用以顯示本發明之部門關係編碼系統1之架構示意圖，如圖所示，本發明之部門關係編碼系統1 (以下略稱為編碼系統1)係用以接受管理人員針對各部門彼此間之層級關係進行修改、新增及刪除等編輯動作，並可將編輯完成之編碼資料以結構化查詢語言 (Structure Query Language; SQL)之語法即時存放於其所設的資料庫3 0中，以供各部門之使用者得以隨時透過編碼系統1查找部門間之層級關係，進而提昇查找部門關係的速度及效率，該編碼系統1係包括：設定模組1 0、資料編輯單元2 0 (以下簡稱為編輯單元2 0)、資料庫3 0、資料搜尋模組4 0，以及資料整合模組5 0，其中，該資料編輯單元2 0另包括有：本部門編碼欄位2 1及部門關係編碼欄位 22〇管理人員首先係藉由與編碼系統1所含之設定模組1 0 連接的區域網路終端的電腦設備（未圖示）依各部門間之1740] Inventec.ptc Page 7 1223169 Case No. 92121332 — _ March 1st _ Amendment _ V. Description of the Invention (5) [Embodiments] The following is a description of specific embodiments of the present invention. Those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific examples. The details of each item in this specification can also be based on different perspectives and applications, and various modifications and changes can be made without departing from the spirit of the present invention. change. The following examples further illustrate the viewpoints of the present invention in detail, but do not limit the scope of the present invention in any way. (Embodiment) FIG. 1 is a block diagram showing the architecture of the departmental relationship encoding system 1 of the present invention. As shown in the figure, the departmental relationship encoding system 1 of the present invention (hereinafter referred to as the encoding system 1) ) Is used to accept management personnel to modify, add, and delete editing actions based on the hierarchical relationship between each department, and can store the edited encoded data in the syntax of Structure Query Language (SQL) in real time In its database 30, users in each department can search the hierarchical relationship between departments at any time through the coding system 1, thereby improving the speed and efficiency of searching for department relationships. The coding system 1 includes: Group 10, data editing unit 20 (hereinafter referred to as editing unit 2 0), database 30, data search module 40, and data integration module 50. Among them, the data editing unit 20 also includes: : The department code field 2 1 and the department relationship code field 22. The manager firstly connects the computer equipment of the local network terminal through the setting module 1 0 included in the coding system 1. Not shown) in accordance with the inter-departmental

1740]英業達.ptc 第8頁 1223169 _案號92121332 年Π月Π曰修正_ 五、發明說明（6) 層級關係輸入相對應之編碼，其係以兩組6位元之編碼表示單一部門於組織結構中之部門編碼，其為本部門編碼及部門關係編碼，前者表示部門本身的編碼，後者則為該部門於組織結構中之編碼，例如…，&總經理室的本部門編碼為 0 0 0 0 0 1 (以6位元表示），管理處的本部門編碼為、 0 0 0 0 0 2；如果某一部門本身並無上層部門，則其部門關係編碼遂與其本部門編碼相同，反之，若該部門有上層部門存在，則該部門之部門關係編碼係由其上級部門之部門關係編碼與該部門之本部門編碼合併在一起組成，例如，總經理室並未有上層部門存在，故總經理室之部門關係編碼係與其本部門編碼相同，而設定為〇〇〇〇〇 1，而管理處的上級部門如為總經理室，則管理處的部門關係編碼係以總經理室之部門關係編碼及管理處之本部門編碼合併組成，即為0 0 0 0 0 1 · 0 0 0 0 0 2 (兩編碼間以分隔符號π · π相隔）；使用者經由終端電腦（未圖示）所設定的資料乃透過區域網路傳送至設定模組1 0，設定模組1 0於接收該筆資料後，即將此些資料依本部門編碼及部門關係編碼等編碼性質予以區分後，遂將其輸入至資料編輯單元2 0，並令資料編輯單元 2 0將此些資料分別填入適當的攔位之中，如將本部門編碼填入本部門編碼欄位2 1而編輯成一本部門編碼欄位值及將部門關係編碼寫入部門關係編碼欄位2 2中，而形成一部門關係編碼欄位值，如以後欲更改本部門編碼欄位2 1及部門關係編碼欄位2 2之欄位值或欲新增、刪除任一部門，僅需由管理人員自終端電腦（未圖示）將資料輸入至設定模組 1 0，俾令設定模組1 0控制資料編輯單元2 0進行欄位資料之1740] Inventec.ptc Page 8 1223169 _ Case No. 92121332 Π / month Π Amendment _ V. Description of the invention (6) Hierarchical relationship input corresponding coding, which is a two-bit code representing a single department The department code in the organizational structure is the department code and the department relationship code. The former represents the department's own code and the latter is the department's code in the organizational structure. For example, & the general manager's office's department code is 0 0 0 0 0 1 (represented by 6 bits), the department code of the management office is, 0 0 0 0 0 2; if a department does not have a higher-level department, its department relationship code is then the same as its department code On the contrary, if the department has an upper-level department, the department-relationship code of the department is composed of the department-relationship code of its superior department and the department's own department code. For example, there is no upper-level department in the general manager's office Therefore, the department relationship code of the general manager's office is the same as that of its own department, and it is set to 20001. If the superior department of the management office is the general manager's office, the department of the management office The code is a combination of the department code of the general manager's office and the department code of the management office, which is 0 0 0 0 0 1 · 0 0 0 0 0 2 (the two codes are separated by the separation symbol π · π); use The data set by the terminal computer (not shown) is transmitted to the setting module 10 through the local network. After receiving the data, the setting module 10 codes the data according to the department code and department relationship code. After the nature of the code is distinguished, it is then entered into the data editing unit 20, and the data editing unit 20 is instructed to fill these data into appropriate stops, such as entering the department code into the department code column. Bit 2 1 and edit it into a department code field value and write the department relationship code into the department relationship code field 2 2 to form a department relationship code field value. If you want to change the department code field 2 1 and Department relationship code field 2 2 The value of the field 2 or if you want to add or delete any department, you only need to enter data from the terminal computer (not shown) to the setting module 1 0 by the management staff, and order the setting module 1 0 Control data editing unit 2 0 Rows of field data

17401英業達.ptc 第9頁 1223169 _案號92121332 %年q月/]曰修正_ 五、發明說明（7) 編輯作業，即可對本部門編碼欄位2 1及部門關係編碼欄位 2 2各別之欄位值進行新增、刪除及修改等編輯作業；俟資料編輯單元2 0將管理人員所設定之編碼資料編輯完成後，遂將編輯究成'的資料傳送至資料庫30儲存「並育af將資料庫10中原有的編碼資料覆蓋，俾使資料庫30内部儲存之編碼資料可與資料編輯單元2 0同步更新。因此，待使用者欲查找任一部門（如財務部）之本部門編碼及其部門關係編碼時，僅需透過與編碼系統1連接之輸入裝，置2輸入所欲查找之部門名稱至資料搜尋模組4 0 中，資料搜尋模組4 0即可依據所輸入之部門名稱於資料庫 3 0中進行檢索，並於檢索完成後，將所檢索出之編碼資料傳送至資料整合模組5 0，令資料整合模組5 0將此些檢索資料依層級關係予以匯整，並將結果透過與編碼系統1相連接之輸出裝置3予以輸出顯示，以供使用者參考，如輸出裝置3輸出財務部之部門關係編碼為0 0 0 0 0 3，其部門關係編碼為0 0 0 0 0 1 · 0 0 0 0 0 2 · 0 0 0 0 0 3，即可得知財務部之上層單位為管理處，最上層單位係為總經理室。第2圖為一流程圖，其係顯示，執行本發明之部門關係編碼方法之各項程序步驟，如圖所示，於步驟S1中，管理人員係於區域網路終端連接之電腦（未圖示）上，依照各部門間之層級關係進行每一部門之本部門編碼及部門關係編碼之編碼作業，其編碼規則為：於每個部門新增兩個表示欄位，分別為本部門編碼及部門關係編碼（兩者合稱為部門編碼），每一攔位以6位元表示之，兩攔位間復以一分隔符號π w相隔，如總經理室之本部門編碼為17401 英业达 .ptc Page 9 1223169 _ Case No. 92121332% year / month /] Amendment _ V. Description of the invention (7) Editing work, you can encode the department code field 2 1 and department relationship code field 2 2 Edit, add, delete, and modify the values of each field; 编辑 Data editing unit 20 After editing the encoded data set by the management staff, the edited data will be sent to the database 30 to store " Blending af covers the original coded data in database 10, so that the coded data stored in database 30 can be updated synchronously with the data editing unit 20. Therefore, until the user wants to find any department (such as the finance department) When the department code and department relationship code are used, only the input device connected to the coding system 1 is required. Set 2 to enter the name of the department you want to find into the data search module 4 0, and the data search module 40 can The entered department name is searched in the database 30, and after the retrieval is completed, the retrieved encoded data is transmitted to the data integration module 50, so that the data integration module 50 will have these search data in a hierarchical relationship. Give The output is displayed through the output device 3 connected to the encoding system 1 for user's reference. For example, if the output device 3 outputs the department relationship code of the financial department as 0 0 0 0 0 3, the department relationship code is 0 0 0 0 0 1 · 0 0 0 0 0 2 · 0 0 0 0 0 3, you can know that the upper unit of the finance department is the management office, and the top unit is the general manager's office. Figure 2 is a flowchart , Which shows that the program steps for implementing the departmental relationship encoding method of the present invention are shown in the figure. In step S1, the management personnel are on a computer (not shown) connected to the local network terminal, in accordance with each department. The hierarchical relationship between each department performs the coding of the department code and department relationship code of each department. The coding rules are as follows: two display fields are added for each department, which are the department code and the department relationship code (the two are combined). (Referred to as department code), each block is represented by 6 bits, and the two blocks are separated by a separator π w. For example, the department code of the general manager's office is

17401英業達.ptc 第10頁 1223169 案號 92121332 卩年1 月 q 日_^ 五、發明說明（8) 0 0 0 0 0 1、管理處之本部門編碼為0 0 0 0 0 2、財務部之本部門編碼為0 0 0 0 0 3 ;總經理室之部門關係編碼為0 0 0 0 0 1，管理處之部門關係編碼為0 0 0 0 0 1. 0 0 0 0 0 2，財務部之部門關係編碟為:αο0.0αι · 0 0 0 0 0 2· Θ 0 0 0 0 3等，接著進至步驟S2。於步驟S2中，令該編碼系統1判另4使用者是否欲使“甩設定模組1 0驅動資料編輯單元2 0以對本部門編碼欄位2 1及部門關係編碼攔位2 2之欄位值進行維護，如使用者不對任一欄位值進行維護，遂直接進至步驟S 7 ;若使用者欲對編碼欄位之欄位值進行維護，即接著進至步驟S 3。於步驟S3中，令該編碼系統1判別使用者欲對某一部門（在此以管理處為例）之部門編碼進行之維護項目為更改上級編碼、新增部門或刪除編碼，如使用者之維護項目為更改上級編碼，則進至步驟S4，為新增部門，遂並進至步驟S 5，若為刪除編碼，緊接著執行步驟S 6。於步驟S4中，令該編碼系統1判別管理處原本是否有上級部門，若其原先未有上級部門存在（當前有總經理室、管理處及財務部三個部門，如總經理室0 0 0 0 0 1管理處000002·;財務部000002.000003.，由此可看出，管理處未指定上級部門，但其有一下級部門-財務部），則進至步驟S4-1，如有（假設當前有總經理室、管理處、財務部及資財處4個部門，其個別的部門關係編碼為總經理室 0 0 0 0 0 1 ·;管理處 0 0 0 0 0 1 · 0 0 0 0 0 2 財務部 0 0 0 0 0 1. 0 0 0 0 0 2 · 0 0 0 0 0 3 ·;資財處 0 0 0 0 0 4 _，由此得知，管理處的上級部門為總經理室，其有一下級部門-財務部 )，遂進至步驟S4-2。 _17401 Yingyeda.ptc Page 10 1223169 Case No. 92121332 January q of the next year _ ^ V. Description of the invention (8) 0 0 0 0 0 1. The department code of the management office is 0 0 0 0 0 2. Finance The department code of the department is 0 0 0 0 0 3; the department relationship code of the general manager's office is 0 0 0 0 0 1; the department relationship code of the management office is 0 0 0 0 0 1. 0 0 0 0 0 2; finance The departmental relationship compilation of the ministry is: αο0.0αι · 0 0 0 0 0 2 · Θ 0 0 0 0 3 and so on, and then proceed to step S2. In step S2, the coding system 1 is instructed to determine whether the other 4 users wish to use the "setting setting module 1 0 to drive the data editing unit 20 to set the field 2 of the department code and the field 2 2 of the department relationship code. If the user does not perform maintenance on any field value, proceed directly to step S7; if the user wants to maintain the field value of the coded field, then proceed to step S3. At step S3 In order to make the coding system 1 judge that the maintenance item that the user wants to perform for the department code of a certain department (here, the management office is taken as an example) is to change the superior code, add a department or delete the code. If the upper-level code is changed, go to step S4. If you want to add a department, go to step S5. If you want to delete the code, go to step S6. In step S4, make the coding system 1 determine whether the management office originally has If there is no higher-level department before (there are three departments: general manager's office, management office, and financial department, such as general manager's office 0 0 0 0 0 1 management office 000002 ·; financial department 000002.000003.) See the management office Designate a higher-level department, but it has a lower-level department-Finance Department), then proceed to step S4-1, if there is (assuming that there are currently 4 departments of the General Manager's Office, Management Office, Finance Department and Assets and Finance Department), the individual department relationship codes For General Manager's Office 0 0 0 0 0 1 · Management Office 0 0 0 0 0 1 ; Assets and Resources Department 0 0 0 0 0 4 _, it is learned that the superior department of the management department is the general manager's office, which has a lower department-the finance department), and then proceeds to step S4-2. _

]740〗英業達.ptc 第11頁 1223169 案號 92121332 五、發明說明（9) 於步驟S4-1中，令設定模組1〇透過碥輯單元2〇將其處及其編制内所有下屬部門之部門關係碥瑪予以編輯^理為修改後上級部門之部門關係編碼與各自邱鬥—„ 7耳’改，^ 。丨門之關係編碼攔，位，合併於同一攔位’例如’現才曰定管理處.之上級部严、總經理室’則將管理處和財務部的部、門關係編碼於& == ‘ 基礎上’左侧加入總經理室的部門關係編碼，如她娘理— 之部門關係編碼為0 0 0 0 0 1. ’則更改上級編碼後之%理成至部門關係編碼為0 0 0 0 0 1 · 〇〇〇⑽2 ·，財務部為处 0 0 0 0 0 1 · 0 0 0 0 0 2 · 0 0 0 0 0 3 ·，接著進至步驟 s 7。於步驟S4-2中’令設定模組1〇透過編輯單元2〇將管理處及其所有下屬部門之部Π關係編蝎攔位中，原上級邻關係編碼部分替換為新上級部門之部門關係編碼；例如，若將管理處之上級部Η改為資財處，則將管理處和財務部之部門關係編碼攔位中’原上級編竭Q 〇 Q Q 〇 1改為 0 0 0 0 0 4.;如下所示’總經理室之部門關係編碼為 0 0 0 0 0 1. ·，管理處之部π關係編碼為〇〇〇〇〇4 〇〇〇〇〇2;財部0 0 0 0 04.0 0 0 0 0 2.0 0 0 0 0 3;資財處為〇〇〇〇〇4，接著進至步驟S 7 〇] 740〗 Industry.ptc Page 11 1223169 Case No. 92121332 V. Description of the Invention (9) In step S4-1, let the setting module 10 go through the editing unit 20 and place it and all its subordinates in the organization. The departmental relationship of the department was edited by the department as the revised departmental relationship code of the higher-level department and its respective Qiudou— “7 ears”, ^. The relationship code of the door was merged into the same place, for example, “current” Cai Yueding Management Office. The higher-level department, the general manager's office, will code the department and door relationship between the management office and the financial department at & == 'Based on the left' and add the department relationship code of the general manager's office, such as her Niangli — The departmental relationship code is 0 0 0 0 0 1. 'The% reasoning after changing the higher-level code to the departmental relationship code is 0 0 0 0 0 1 · 〇〇〇⑽2 ·, the financial department is 0 0 0 0 0 1 · 0 0 0 0 0 2 · 0 0 0 0 0 3 ·, then proceed to step s 7. In step S4-2 'Let the setting module 1〇 pass the editing unit 2 through the management office and all of it In the scorpion block of the Ministry of Relations Department of the subordinate department, the original neighboring relationship coding part was replaced by the department relationship editor of the new higher department. ; For example, if the upper management department of the management department is changed to the treasury department, the original relationship between the management department and the financial department's departmental code block 'exhausted senior editor Q 〇QQ 〇1 is changed to 0 0 0 0 0 4 .; As shown below, the department relationship code of the general manager's office is 0 0 0 0 0 1. · The π relationship code of the management department is 0 0 0 0 4 0 0 0 2 0; the Ministry of Finance 0 0 0 0 0 4.0 0 0 0 0 2.0 0 0 0 0 3; Assets Office is 〇〇〇〇〇〇〇04, then proceed to step S7.

於步驟S5中，令該編碼系統叫別使用者有無指定部門予新增部π，若否，遂執行步驟S5-1，反之，則直接進至步驟S 5 - 2。於步驟S5-1中，令設定杈纽1〇透過編輯單元2〇依照使用者所指定上級部Η之部Η關係、編碼欄位與新增部門之本部門編碼棚位合併組成此一新増邹門之部門關係編碼，接著進至步驟S 7。In step S5, the coding system is instructed to ask another user whether there is a designated department to add a new part π, and if not, step S5-1 is performed, otherwise, it goes directly to step S5-2. In step S5-1, the setting unit 10 is merged into the new department through the editing unit 20 according to the department relationship, the coding field, and the department coding booth of the newly added department. Zou Men's department relationship code, then proceed to step S7.

1223169 __案號 92121332 年 1 月 ___ 五、發明說明（10) 於步驟S 5 - 2中，令設定模組1 0透過編輯單元2 〇將新增部門之本部門編碼攔位及部門關係編碼攔位之攔位值設為相同，接著進至步驟S 7。，於步〜驟S 6中’:玲該、編瑪系統1檢'視使用者欲刪除之部… 門（例如管屬處）、是否編制有下屬部門，如欲刪除之部f1 未編制下屬部門，則編碼系統1遂不進行任何處理措施，接著進至步驟S7，若刪除之部門編制有下屬部門，則直接進至步驟S 6 - 1。 ' 於步驟S6-1中，遂令設定模組1〇藉由編輯單元2〇將管理處所編制之所有下屬部門之部門關係編碼中，表示管理處之編碼部分删除，例如，現今有總經理室、管理處和財務部3個部門，各部門之本部門編碼如後所示，總經理室為000001·;管理處為000002·以及財務部為 0 0 0 0 0 2· 0 0 0 0 0 3·;現使用者經由設定模組1〇將管理處自資料庫3 0中刪除，設定模組丨〇同時亦透過編輯單元2 〇將管理處之下屬部門財務部之部門關係編碼中，表示碼部分去除，如財務部原先之部門編碼為里處之'、扁〇〇〇〇〇 2.0 0 0 0 0 3,修改後變為財務部〇〇〇〇〇3, 門存在，接著進至步驟S 7。未有上級部 ;v驟S7中，令該編碼系統1呈待機模式用者：隨時查找各部門間之層級關係。加时:!上所| ’本發明之部門關係編碼系統及方wπ :門間之層級關係明確，且因其係以6位元 = 二ΪΓ令…依實際需求擴充足夠多之部η Λ 俾令使用者查找指定部門之所有上級或下級部門；層： 1223169 _案號92121332 气3年q月1曰修正_ 五、發明說明（11) 通過遞迴、遍曆即可查找出各部門間之層級關係，大幅提高查找部門關係之速度及效率。上述實施例僅為例示性說明本發明之原理及功效，而非甩於限制本發明八任何熟習此項技藝之人士均可在不違背本發明之精神及範疇下，對土述實施例進行修飾與變化。因此本發明之權利保護範圍，應如後述之申請專利範圍所列。1223169 __Case No. 92121332 January ___ V. Description of the invention (10) In step S 5-2, let the setting module 1 0 through the editing unit 2 〇 will add the department's own department code block and department relationship in the new department The block value of the coded block is set to the same, and then the process proceeds to step S7. In step ~ step S6, ': Linggai, editor system 1 check' depending on the department you want to delete ... Door (for example, the subordinate department), whether there is a subordinate department, if you want to delete the department f1, there is no subordinate. Department, the coding system 1 does not perform any processing measures, and then proceeds to step S7. If the deleted department has a subordinate department, it proceeds directly to step S6-1. 'In step S6-1, the setting module 10 is then instructed to delete the code of the management office from the department relationship codes of all the subordinate departments compiled by the management office 20, for example, there is a general manager office now. , Management department and finance department, the department code of each department is shown below, general manager's office is 000001 ·; management department is 000002 · and finance department is 0 0 0 0 0 2 · 0 0 0 0 0 3 ·; The current user deletes the management office from the database 30 through the setting module 10, and the setting module 丨〇 also edits the department relationship code of the financial department under the management office through the editing unit 20, indicating the code Partially removed, such as the original department code of the Ministry of Finance was 'where in the place', flat 〇〇〇〇〇〇〇2.0 〇 0 003, after the modification became the Department of Finance 〇〇〇〇〇〇 3, the door exists, and then proceed to step S 7. There is no higher-level department; v In step S7, the coding system 1 is put into standby mode. User: Search for the hierarchical relationship between departments at any time. Extra time:! 上所 | 'The departmental relationship encoding system of the present invention and the square wπ: The hierarchical relationship between the gates is clear, and because it is based on 6 bits = two ΪΓ order ... expand enough sections η Λ 俾 order according to actual needs The user searches all the superior or subordinate departments of the specified department; Level: 1223169 _Case No. 92121332 Modified for 3 years and 1st month_ V. Description of the invention (11) You can find the level between departments by recursion and traversal Relationships, greatly improving the speed and efficiency of finding department relationships. The above embodiments are only for illustrative purposes to explain the principles and effects of the present invention, and are not intended to limit the present invention. Any person skilled in the art can modify the described embodiments without departing from the spirit and scope of the present invention. And change. Therefore, the scope of protection of the rights of the present invention should be as listed in the patent application scope mentioned later.

17401英業達.ptc 第14頁 1223169 _案號92121332 年Q月Q曰修正_ 圖式簡單說明【圖式簡單說明】第1圖為一方塊圖，其係用以顯示本發明之部門關係編碼糸統之架構不意圖，以及第2圖為一海程爵，其係顯示，.執行本發明之部Π關係編碼方法.之—各項步驟程序。 (元件符號說明） 1 部門關係編碼系統 2 輸入裝置 3 輸出裝置 1 0 設定模組 20 資料編輯單元 21 本部門編碼棚位 22 部門關係編碼欄位 3 0 資料庫 4 0 資料搜尋模組 5 0 資料整合模組17401 英业达 .ptc Page 14 1223169 _ Case No. 92121332 Q and Q amendments _ Brief description of the drawings [Simplified description of the drawings] Figure 1 is a block diagram, which is used to display the department relationship code of the present invention The structure of the system is not intended, and the second figure is Yihai Chengjue, which shows that the implementation of the present invention's Π relation coding method.-Each step procedure. (Description of component symbols) 1 Departmental relationship coding system 2 Input device 3 Output device 1 0 Setting module 20 Data editing unit 21 Department code booth 22 Department relationship code field 3 0 Database 4 0 Data search module 5 0 Data Integration module

17401英業達.ptc 第15頁17401 Inventec.ptc Page 15

Claims

1223169 _案號92121332 年1月Q曰修正_ 六、申請專利範圍 1 . 一種部門關係編碼系統，係用以提高查找部門間層級關係之速度，該系統包括：設定單元，用以供管理人員依照部門間之層級關係設定相對於各部門本身及imr之編碼；" 、資料編輯單元，其包含有本部門編碼欄位及部門關係編碼攔位，用以根據管理人員所設定之資料，對本部門編碼欄位及部門關係編碼攔位進行編輯；資料庫，用以儲存經由資料編輯單元處理完成之本部門編碼攔位及部門關係編碼欄位組合而成之部門層級關係資料；資料搜尋模組，用以根據使用者所輸入的部門名稱配合該模組内部所含程式語句之運作，於資料庫中查找出與該部門名稱有關之所有部門名稱；以及資料整合模組，係將資料搜尋模組所查找出與該部門名稱有關之所有部門予以排列組合，藉以建立各部門彼此間之層級關係。 2. 如申請專利範圍第1項之部門關係編碼系統，其中，該設定單元係與區域網路連結，俾供管理人員可藉由網路終端電腦對該編輯單元之編碼資料進行設定。 3. 如申請專利範圍第1項之部門關係編碼系統，其中，該資料編輯單元係用以令管理人員可於日後對其先前所設定之部門本身及與其他部門所組群組之一者的編碼攔位值進行修改。 4. 如申請專利範圍第3項之部門關係編碼系統，其中，該1223169 _ Case No. 92121332 January Q_ Amendment_ 6. Scope of Patent Application 1. A department relationship coding system is used to improve the speed of searching for hierarchical relationships between departments. The system includes: a setting unit for management personnel to follow The setting of the hierarchical relationship between departments is relative to the coding of each department itself and imr; " The data editing unit, which contains the coding field of the department and the code block of the department relationship, is used for the department based on the data set by the management staff. The coding field and department relationship coding block are edited; the database is used to store the department-level relationship data composed of the department coding block and department relationship coding field processed by the data editing unit; the data search module, It is used to match the operation of the program statements contained in the module according to the department name entered by the user to find out all department names related to the department name in the database; and the data integration module is a data search module All the departments found related to the department name are arranged and combined to establish each department. The hierarchical relationship between departments. 2. For the departmental relationship coding system in the first scope of the patent application, the setting unit is connected to the local area network, so that the administrator can set the coding data of the editing unit through the network terminal computer. 3. If the department relationship coding system of item 1 of the scope of patent application is filed, the data editing unit is used to enable the management staff in the future to control the department itself and one of the groups grouped with other departments. Coding stop values are modified. 4. If the departmental relationship coding system for item 3 of the patent application scope, where

17401英業達.ptc 第16頁 1223169 _案號92121332 巧3年Ί月0曰修正_ 六、申請專利範圍編碼欄位值係指本部門編碼欄位及部門關係編碼欄位所組群組之一者。 5. 如申請專利範圍第1項之部門關係編碼系統，其中，該編碼修改係指可對本部門綸碼欄位及部門關係’繞凑欄位所組群組之一者進行新增及刪除之其中一種程序。 6. 如申請專利範圍第1項之部門關係編碼系統，其中，該部門層級關係乃由部門關係編碼欄位作為前端欄位，本部門編碼搁位為後端搁位組合而成，猎以表不各部門間之層級關係資料。 7. 如申請專利範圍第1項之部門關係編碼系統，其中，該程式語句係指結構化查詢語言（Structure Query Language ； SQL) ° 8. 如申請專利範圍第1項之部門關係編碼系統，其中，使用者係藉由輸入設備，如鍵盤、滑鼠、手寫盤、條碼機其中之一者，將部門名稱輸入至資料搜尋模組中。 9. 如申請專利範圍第1項之部門關係編碼系統，其中，該資料整合模組匯整完成之部門層級關係資料係藉由螢幕、印表機其中之一者予以輸出顯示。 1 0. —種部門關係編碼方法，係與部門關係編碼系統配合，用以提高查找部門關係之速度，該方法係包含： (1)由管理者依據一部門及該部門與其他部門間之層級關係設定本部門編碼與部門關係編碼，並將完成之編碼資料傳送至部門關係編碼系統所設的資料庫中存放；17401 英业达 .ptc Page 16 1223169 _Case No. 92121332 Modified on the 0th of the 3rd month_ Sixth, the value of the patent application code field refers to the group of the department code field and department relationship code field One. 5. For the departmental relationship coding system in the first scope of the patent application, the code modification refers to the addition and deletion of one of the groups in the department code field and departmental relationship field. One of the programs. 6. If you apply for the department relationship coding system in item 1 of the scope of patent application, the department-level relationship is composed of the department relationship coding field as the front-end field, and the department coding shelf is composed of the back-end shelf. Hierarchical relationships between departments. 7. If the department relation coding system of item 1 of the patent scope is applied, the program sentence refers to Structure Query Language (SQL) ° 8. If the department relation coding system of item 1 of the patent scope is applied, where , The user enters the department name into the data search module through an input device, such as one of a keyboard, a mouse, a handwriting pad, and a barcode machine. 9. For the department relationship coding system in the first scope of the patent application, the department-level relationship data collected by the data integration module is output and displayed through one of the screen and the printer. 1 0. — A departmental relationship coding method, which is used in conjunction with the departmental relationship coding system to improve the speed of finding departmental relationships. The method includes: (1) managers based on the level of a department and between the department and other departments Set the relationship between the department code and the department relationship code, and send the completed coding data to the database set by the department relationship coding system for storage;

17401英業達.ptc 第17頁 1223169 _案號 92121332 __ 修正_ 六、申請專利範圍 (2)令該部門編碼系統判別管理者是否欲對編碼資料進行維護，如是，則進至步驟（3)，若否，遂並進至步驟（7); (D.令該部門編碼:系、統咧別管理者所欲雜護項目係為更改上級部門、，新增部門亦或者刪除部門其中之一，若管理者欲修改該部門之上層部門關係編碼欄位，則直接進至步驟（4)，新增部門，遂進至步驟 (5)，如管理者欲刪除該部門本身的本部門編碼攔位，遂並進至步驟（6)；… (4) 令該部門編碼系統判別該部門原本有無上層部門存在，若無，遂將與該部門相關的之部門關係編碼欄位新增一上層部門關係編碼欄位，而後進至步驟 (7)，如該部門原先已有上級部門，則令部門編碼系統將原上層部門之部門關係編碼攔位替換為已修改之上層部門部門關係編碼攔位，接著執行步驟（7)； (5) 令部門編碼系統檢視管理者是否指定上級部門予新增部門，若有，遂將所指定之上級部門的部門關係編碼與新增部門之本部門編碼攔位合併為該新增部門之部門關係編碼，接著執行步驟（7);如未指定上級部門予新增部門，則將新增部門之本部門編碼欄位及部門關係編碼欄位之攔位值設為相同，接著執行步驟（7); (6) 令該部門編碼系統檢示欲刪除之部門原本有無編制下層部門，若該部門並未編制任何下層部門，17401 英业达 .ptc Page 17 1223169 _ Case No. 92121332 __ Amendment _ 6. Scope of patent application (2) Makes the department's coding system to determine whether the manager wants to maintain the coded data. If yes, go to step (3) , If not, then proceed to step (7); (D. make the department code: Department, system management, the miscellaneous protection project that the manager wants is to change the superior department, add a department, or delete one of the departments, If the manager wants to modify the upper department relationship code field of the department, go directly to step (4), add a department, then go to step (5), if the manager wants to delete the department's own department code block Then, proceed to step (6); ... (4) Make the department coding system determine whether the department originally had an upper department. If not, add a department relationship code field to the department relationship code field related to the department. Field, and then proceed to step (7), if the department already has a higher-level department, make the department coding system replace the department relationship code block of the previous upper department with the modified department relationship code block of the upper department, then Carry out step (7); (5) Have the department coding system check whether the manager has designated a superior department to add a new department, and if so, merge the department relationship code of the designated higher department with the department code of the added department. Code the department relationship of the newly added department, and then execute step (7); if the higher-level department is not specified to add the department, set the block values of the department code field and department relationship code field of the added department to Same, then proceed to step (7); (6) Have the department coding system check whether the department to be deleted originally has a lower-level department. If the department has not prepared any lower-level department,

17401英業達.ptc 第18頁 1223169 _案號92121332 年Π月 0日修正_ 六、申請專利範圍則該部門編碼系統遂不執行任何處理程序，接著執行步驟（7);如該部門原先編制有下屬部門，遂令部門編碼系統將該部門編制内之所有下屬部門之部門關係編碼櫥位中，表示該部門之部門關係編碼欄〃位刪除，而後進至步驟（7);以及 (7)令該部門編碼系統進入待命模式，以隨時供使用者輸入部門名稱，以查詢與該部門名稱與其他部門間之層級關係。 1 1.如申請專利範圍第1 0項之部門關係編碼方法，其中，編碼資料維護係指管理者對先前所設定之編碼進行重新設定、修改、新增及刪除其中之一種程序稱之。 1 2 .如申請專利範圍第1 0項之部門關係編碼方法，其中，該部門編碼欄位係指部門本身的編碼欄位值。 1 3 .如申請專利範圍第1 0項之部門關係編碼方法，其中，該部門關係編碼攔位係指該部門於組織結構中之編碼欄位值。 1 4.如申請專利範圍第1 0項之部門關係編碼方法，其中，如部門本身並無隸屬之上層部門，則其部門關係編碼欄位值係與其部門編碼欄位值相同。17401 英业达 .ptc Page 18 1223169 _ Case No. 92121332 Rev. Π / 0 / 0_ Sixth, the scope of patent application then the department's coding system does not perform any processing procedures, and then execute step (7); if the department was originally prepared If there is a subordinate department, the department coding system is instructed to delete the department relationship coding column of the department in the department relationship coding cabinet of all subordinate departments in the department compilation, and then proceed to step (7); and (7) The department coding system is put into a standby mode for the user to input the department name at any time to query the hierarchical relationship between the department name and other departments. 1 1. According to the departmental relationship coding method of the 10th scope of the patent application, the maintenance of coding data refers to a procedure in which a manager resets, modifies, adds, and deletes a previously set coding. 12. As for the department relation coding method of item 10 of the scope of patent application, wherein the department coding field refers to the coding field value of the department itself. 1 3. According to the department relationship coding method of item 10 of the scope of patent application, wherein the department relationship coding stop refers to the value of the coding field of the department in the organizational structure. 14. If the department relationship coding method of item 10 in the scope of patent application is applied, if the department itself is not affiliated with an upper-level department, the value of the department relationship coding field is the same as the value of its department coding field.

17401英業達.ptc 第19頁17401 Inventec.ptc Page 19