TWI223169B - Department relation encoding system and method - Google Patents
Department relation encoding system and method Download PDFInfo
- Publication number
- TWI223169B TWI223169B TW92121332A TW92121332A TWI223169B TW I223169 B TWI223169 B TW I223169B TW 92121332 A TW92121332 A TW 92121332A TW 92121332 A TW92121332 A TW 92121332A TW I223169 B TWI223169 B TW I223169B
- Authority
- TW
- Taiwan
- Prior art keywords
- department
- relationship
- coding
- code
- field
- Prior art date
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
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 (1)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW92121332A TWI223169B (en) | 2003-08-05 | 2003-08-05 | Department relation encoding system and method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW92121332A TWI223169B (en) | 2003-08-05 | 2003-08-05 | Department relation encoding system and method |
Publications (2)
Publication Number | Publication Date |
---|---|
TWI223169B true TWI223169B (en) | 2004-11-01 |
TW200506658A TW200506658A (en) | 2005-02-16 |
Family
ID=34546271
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
TW92121332A TWI223169B (en) | 2003-08-05 | 2003-08-05 | Department relation encoding system and method |
Country Status (1)
Country | Link |
---|---|
TW (1) | TWI223169B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
TWI679544B (en) * | 2018-07-18 | 2019-12-11 | 英業達股份有限公司 | Method for displaying relational desgin information |
-
2003
- 2003-08-05 TW TW92121332A patent/TWI223169B/en not_active IP Right Cessation
Also Published As
Publication number | Publication date |
---|---|
TW200506658A (en) | 2005-02-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP4045399B2 (en) | Structured document management apparatus and structured document management method | |
US7797336B2 (en) | System, method, and computer program product for knowledge management | |
US20220092256A1 (en) | Method, system, and computing device for facilitating private drafting | |
US20060287978A1 (en) | Efficient querying and paging in databases | |
CN101477549B (en) | Knowledge base supported spatial database design method and system | |
CN102663076B (en) | Method for processing file data | |
US20020107893A1 (en) | Method and system for displaying data with tree structure | |
CN102880720B (en) | The management of information resources and semantic retrieving method | |
JP4045400B2 (en) | Search device and search method | |
CN110851663A (en) | Method and apparatus for managing metadata | |
CN106802928B (en) | Power grid historical data management method and system | |
JP4604168B1 (en) | File management apparatus, method thereof, and program | |
TWI223169B (en) | Department relation encoding system and method | |
US20090193053A1 (en) | Information management system | |
CN104462461A (en) | Form null value check processing method and device | |
CN113391916A (en) | Organization architecture data processing method, device, computer equipment and storage medium | |
Huang | An object model with parametric polymorphism for dynamic segmentation | |
CN115169891B (en) | Method for realizing workflow engine comprising multi-start-point multi-branch flow | |
US7574329B1 (en) | Object model for decision and issue tracking | |
CN104199824A (en) | Method for judging node relation on tree-shaped data | |
US20020156788A1 (en) | Method of constructing, editing, indexing, and matching up with information on the interner for a knowledge map | |
CN109885953B (en) | Mapping method and device of model component | |
Zhao et al. | Design and Implementation of Enterprise Public Data Management Platform Based on Artificial Intelligence | |
Hellal et al. | Nodar: mining globally distributed substructures from a single labeled graph | |
CN112507213A (en) | Method for recommending optimized system scheme based on behavior big data analysis |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
MM4A | Annulment or lapse of patent due to non-payment of fees |