TWI626582B - Complex form application system - Google Patents
Complex form application system Download PDFInfo
- Publication number
- TWI626582B TWI626582B TW106112098A TW106112098A TWI626582B TW I626582 B TWI626582 B TW I626582B TW 106112098 A TW106112098 A TW 106112098A TW 106112098 A TW106112098 A TW 106112098A TW I626582 B TWI626582 B TW I626582B
- Authority
- TW
- Taiwan
- Prior art keywords
- data
- setting value
- field
- complexity
- display
- Prior art date
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
一種複雜性表單應用系統，係包含一資料庫平台及一客戶端網頁程式，該資料庫平台更包含有一複雜性表單設定模組，其中該複雜性表單設定模組能夠設定出一具有數個類別參數的對照檔及至少一個對應類別參數的表單設定檔，而該客戶端網頁程式能夠顯示於一電腦設備中，其中該客戶端網頁程式係與該資料庫平台進行連線，該客戶端網頁程式係至少包含一表單設定檔對應模組、一複雜性表單呈現模組，而該表單設定檔對應模組能夠依據輸入不同的類別參數，以進行取出不同的表單設定檔，用以讓該複雜性表單呈現模組能夠藉由所取出的表單設定檔於該資料庫平台中撈取資料、並於該客戶端網頁程式上呈現出運作該客戶端網頁程式所需之操作介面及顯示區塊，而所撈取的資料能夠一併顯示於該顯示區塊中。A complexity form application system includes a database platform and a client webpage program. The database platform further includes a complex form setting module, wherein the complexity form setting module can set a plurality of categories. a comparison file of the parameter and at least one form profile corresponding to the category parameter, wherein the client webpage program can be displayed on a computer device, wherein the client webpage program is connected to the database platform, the client webpage program The system includes at least a form profile corresponding module and a complexity form presentation module, and the form profile corresponding module can input different form profiles according to inputting different category parameters for the complexity. The form presentation module can retrieve the data from the database platform by using the extracted form configuration file, and display the operation interface and the display block required for running the client webpage program on the client webpage program. The retrieved data can be displayed together in the display block.
Description
本發明是有關一種複雜性表單應用系統，特別是一種能夠以表單化設定檔直接轉換為所需之操作介面及顯示區塊，而所撈取的資料更能夠一併顯示於該顯示區塊中。The invention relates to a complexity form application system, in particular to a form that can be directly converted into a required operation interface and a display block, and the retrieved data can be displayed together in the display block.
由於當資料收集後，會依據不同需求來進行資料篩選與分析，但若是資料庫太龐大的情況下，一般傳統對於名單撈取的作法，如第1圖所示，必須藉由工程師透過資料庫軟體1進入資料庫寫入程式碼才能取得名單資料，且若需要修名單資料時，則又要花費相同的工序再做一次，其過程技術門檻高且花費較多時間。Since data collection and analysis will be carried out according to different needs after data collection, if the database is too large, the traditional practice of collecting the list, as shown in Figure 1, must be done by the engineer through the database software. 1 Enter the database to write the code to get the list data, and if you need to repair the list data, you have to spend the same process and do it again. The process technology is high and takes a lot of time.
為了讓名單撈取更方便在網站上進行，因此建立了介面版的操作，但此功能雖然有引導如何建立SQL語法，但仍需具備SQL的基本知識才能完成名單撈取，但這則是必須在SQL中撰寫資料庫語法，但撰寫資料庫語法若要進行修改或新增，都將是很繁瑣的事。In order to make the list more convenient to be carried out on the website, the interface version is established, but although this function guides how to build SQL syntax, it still needs to have the basic knowledge of SQL to complete the list, but it must be in SQL. Writing a database grammar, but writing a database grammar to be modified or added will be very cumbersome.
因此當每一次不同廠商需要新增、刪除、修改或是編輯等功能的程式，往往軟體供應商都要重新設計一套新的軟體，這對於軟體供應商來講是非常麻煩的，故若能夠設計出一可共用的表單設定檔，能夠依據輸入不同的類別參數，以進行取出不同的表單設定檔，並藉由所取出的表單設定檔於該資料庫平台中撈取資料、將能夠於一網頁程式上呈現出運作所需之操作介面及顯示區塊，而所撈取的資料能夠一併顯示於該顯示區塊中，而不同使用者需求的操作介面之不同，也能夠直接修改表單設定檔內的設定值，以此因應不同客戶的需求，因此本發明應為一最佳解決方案。Therefore, every time a different vendor needs to add, delete, modify or edit functions, software vendors often have to redesign a new software, which is very troublesome for software vendors, so if you can design A common form configuration file can be used to retrieve different form profiles according to different category parameters, and to retrieve data from the database platform by using the extracted form configuration file, which can be used in a webpage program. The operation interface and display block required for operation are presented, and the retrieved data can be displayed together in the display block, and the operation interface of different user requirements can also directly modify the form configuration file. The present invention should be an optimal solution by setting values in response to the needs of different customers.
本發明複雜性表單應用系統，係包含：一資料庫平台，係用以儲存一筆以上的資料；一客戶端網頁程式，係能夠顯示於一電腦設備中，而該客戶端網頁程式係與該資料庫平台進行連線，該客戶端網頁程式係至少包含一複雜性表單設定模組，係能夠設定出一具有數個類別參數的對照檔及至少一個對應類別參數的表單設定檔，其中該表單設定檔係至少具有一對應類別參數、至少一個顯示欄位名稱設定值、至少一個顯示資料設定值、至少一個資料來源設定值及至少一個顯示欄位型態設定值；一表單設定檔對應模組，係能夠與該複雜性表單設定模組相連接，用以依據輸入不同的類別參數，以進行取出不同的表單設定檔；一複雜性表單呈現模組，係與該表單設定檔對應模組相連接，用以藉由所取出的表單設定檔於該資料庫平台中撈取資料、並於該客戶端網頁程式上呈現出運作該客戶端網頁程式所需之操作介面及顯示區塊，而所撈取的資料能夠一併顯示於該顯示區塊中。The complexity form application system of the present invention comprises: a database platform for storing more than one piece of data; a client webpage program, which can be displayed on a computer device, and the client webpage program and the data The library platform is connected. The client webpage program includes at least one complexity form setting module, and is capable of setting a comparison file having a plurality of category parameters and at least one form setting file corresponding to the category parameter, wherein the form setting The file system has at least one corresponding category parameter, at least one display field name setting value, at least one display data setting value, at least one data source setting value, and at least one display field type setting value; a form setting file corresponding module, The system can be connected to the complexity form setting module to input different form profiles according to different category parameters; a complex form presentation module is connected with the corresponding module of the form profile For extracting data from the database platform by using the extracted form profile, and on the client webpage Showing the desired type of operation on the client web programming user interface and display area, and the information can be displayed together to fish in the display block.
更具體的說，所述表單設定檔更包含有一顯示欄位長度設定值及一顯示欄位格式設定值，其中該顯示欄位格式設定值係能夠為文字、數字、圖片、符號、HTML格式或其混合。More specifically, the form profile further includes a display field length setting value and a display field format setting value, wherein the display field format setting value can be text, number, picture, symbol, HTML format or It's mixed.
更具體的說，所述表單設定檔更包含有一欄位顯示設定值及一欄位修改設定值，其中該欄位顯示設定值用以控制欄位內的資料是否能夠顯示，而該欄位修改設定值用以控制欄位內的資料是否能夠修改。More specifically, the form profile further includes a field display setting value and a field modification setting value, wherein the field display setting value is used to control whether the data in the field can be displayed, and the field modification is performed. The set value is used to control whether the data in the field can be modified.
更具體的說，所述表單設定檔更包含有一資料重覆驗證設定值，其中該資料重覆驗證設定值用以驗證一筆資料或是至少兩筆相關的資料是否已重覆存在於該資料庫平台中。More specifically, the form profile further includes a data re-verification setting value, wherein the data repeatedly verifies the setting value to verify whether a piece of data or at least two related materials have been repeatedly stored in the database. In the platform.
更具體的說，所述表單設定檔更包含有一自動編碼設定值，其中該自動編碼設定值用以能夠依設定自動產生出不同編碼格式的資料。More specifically, the form profile further includes an automatic code setting value, wherein the automatic code setting value is used to automatically generate data of different encoding formats according to the setting.
更具體的說，所述資料來源設定值係能夠對應於該資料庫平台內的資料，用以依據該資料來源設定值於該資料庫平台取出要顯示的資料。More specifically, the data source setting value can correspond to the data in the database platform, and the data to be displayed is taken out from the database platform according to the data source setting value.
有關於本發明其他技術內容、特點與功效，在以下配合參考圖式之較佳實施例的詳細說明中，將可清楚的呈現。Other details, features, and advantages of the present invention will be apparent from the following description of the preferred embodiments.
請參閱第2A及2B圖，為本發明複雜性表單應用系統之整體架構示意圖及客戶端網頁程式之內部架構示意圖，由圖中可知，該複雜性表單應用系統係包含有一資料庫平台2及一具有一螢幕30及一客戶端網頁程式31之電腦設備3，其中該資料庫平台2係用以儲存一筆以上的資料，而該資料庫平台2中更包含有一複雜性表單設定模組21，該複雜性表單設定模組21用以設定出一具有數個類別參數的對照檔及至少一個對應類別參數的表單設定檔，其中該表單設定檔係至少具有一對應類別參數、至少一個顯示欄位名稱設定值、至少一個顯示資料設定值、至少一個資料來源設定值、至少一個顯示欄位型態設定值、顯示欄位長度設定值、顯示欄位格式設定值、欄位顯示設定值及欄位修改設定值；Please refer to FIGS. 2A and 2B , which are schematic diagrams showing the overall architecture of the complexity form application system and the internal architecture of the client webpage program. As can be seen from the figure, the complexity form application system includes a database platform 2 and a The computer device 3 has a screen 30 and a client webpage program 31, wherein the database platform 2 is used for storing more than one piece of data, and the database platform 2 further includes a complexity form setting module 21, which The complexity form setting module 21 is configured to set a comparison file having a plurality of category parameters and at least one form profile corresponding to the category parameter, wherein the form setting file has at least one corresponding category parameter and at least one display field name. Set value, at least one display data setting value, at least one data source setting value, at least one display field type setting value, display field length setting value, display field format setting value, field display setting value, and field modification Set value
其中該顯示欄位格式設定值係能夠為文字、數字、圖片、符號、HTML格式或其混合，而該表單設定檔更包含有一欄位顯示設定值及一欄位修改設定值，其中該欄位顯示設定值用以控制是否顯示，而該欄位修改設定值用以控制是否能夠修改。The display field format setting value can be a text, a number, a picture, a symbol, an HTML format or a mixture thereof, and the form setting file further includes a field display setting value and a field modification setting value, wherein the field is set. The set value is displayed to control whether the display is displayed, and the field is modified to set whether the value can be modified.
其中該客戶端網頁程式31係至少包含有一表單設定檔對應模組311及一複雜性表單呈現模組312，其中該表單設定檔對應模組311係用以依據於該客戶端網頁程式上輸入不同的類別參數，以於該資料庫平台中取出不同的表單設定檔，而該複雜性表單呈現模組312用以藉由所取出的表單設定檔於該資料庫平台2中撈取資料、並於該客戶端網頁程式31上呈現出運作該客戶端網頁程式31所需之操作介面及顯示區塊，而所撈取的資料能夠一併顯示於該顯示區塊中。The client webpage program 31 includes at least one form profile corresponding module 311 and a complexity form presentation module 312, wherein the form profile corresponding module 311 is configured to input differently according to the client webpage program. a category parameter for taking out a different form profile in the database platform, and the complexity form presentation module 312 is configured to retrieve data from the database platform 2 by using the extracted form profile, and The client webpage program 31 displays the operation interface and display block required to operate the client webpage program 31, and the retrieved data can be displayed together in the display block.
由於本發明之複雜性表單可適用於各種查詢、新增、刪除、修改需求（例如：會員維護，商品維護、積點設定等），而本發明利用CLASS設定，透過於網址上傳入不同的CLASS參數，使複雜性表單可依傳入之參數於對應的表格中取得其設定值呈現，因而達成一隻程式可完成多項功能。Since the complexity form of the present invention can be applied to various query, add, delete, and modify requirements (for example, member maintenance, product maintenance, point setting, etc.), the present invention utilizes the CLASS setting to pass in different CLASSs through the URL. The parameter allows the complexity form to obtain its set value in the corresponding table according to the parameters passed in, so that a program can be completed to perform multiple functions.
以會員維護為範例，網址為~/DynamicFormList/ MemberInfo，網址中的MemberInfo為參數，因此能夠對應CL_Class中欄位strClassID設定，由第3A圖中的表格中取得strClassID='MemberInfo'，代表此會為會員維護，而對應於「MemberInfo」參數的表單設定檔至少能夠顯示出如第3B圖及第3C圖所顯示的查詢條件區、查詢結果區、基本資訊顯示區，而上述三個區域及其他區域的畫面與設定內容會於接下來說明。Take the member maintenance as an example, the URL is ~/DynamicFormList/ MemberInfo, and the MemberInfo in the URL is a parameter, so it can be set corresponding to the field strClassID in the CL_Class, and strClassID='MemberInfo' is obtained from the table in Figure 3A, which means that this will be The member maintains, and the form profile corresponding to the "MemberInfo" parameter can display at least the query condition area, the query result area, and the basic information display area as shown in FIG. 3B and FIG. 3C, and the above three areas and other areas. The screen and settings will be explained next.
先進行說明查詢條件區，依據所取出的表單設定檔，能夠於該客戶端網頁程式31上呈現出如第4A-1圖所示的操作介面及顯示區塊，而對應於第4A-1圖之strColumnClass ='MemberInfo'的設定如第4B-1~4B-2圖所示，其中各顯示區塊對應如下： (1) 「請輸入姓名」：對應於Member001的設定 (2) 「會員生日介於」、「請輸入生日」：對應於Member002的設定 (3) 「請選擇縣市」：對應於Member003的設定 (4) 「請選擇區域」：對應於Member004的設定 (5) 「請選擇性別」：對應於Member005的設定 (6) 「請輸入日期」：對應於Member006的設定 (7) 「請輸入ERPID」：對應於Member007的設定 (8) 「請輸入手機」：對應於Member008的設定 (9) 「請輸入MSCRM ID」：對應於Member009的設定First, the query condition area is described. According to the extracted form profile, the operation interface and the display block as shown in FIG. 4A-1 can be presented on the client webpage program 31, and corresponds to the 4A-1 map. The settings of strColumnClass = 'MemberInfo' are shown in Figures 4B-1~4B-2, and the display blocks correspond to the following: (1) "Please enter a name": corresponding to the setting of Member001 (2) "Membership birthday "", "Please enter the birthday": corresponding to the setting of Member002 (3) "Please select the county": corresponding to the setting of Member003 (4) "Please select the area": corresponding to the setting of Member004 (5) "Please select gender ": Corresponds to the setting of Member005 (6) "Please enter the date": Corresponds to the setting of Member006 (7) "Please enter ERPID": Corresponds to the setting of Member007 (8) "Please enter the phone": Corresponds to the setting of Member008 ( 9) "Please enter MSCRM ID": corresponding to the setting of Member009
另外，關於Member000的設定，由於是KEY碼，所以不會呈現於畫面中，故Member000的ysnListDisplay之設定值為0，除此之外，如第4A-2圖所示， 更能夠顯示出「依照客戶代碼排序」等排序選項，而除了設定為不顯示者之外，排序中都會出現第4A-2圖的畫面。In addition, since the setting of Member000 is not the KEY code, it is not displayed on the screen. Therefore, the setting value of the ysnListDisplay of Member000 is 0. In addition, as shown in Fig. 4A-2, it is possible to display "in accordance with Sorting options such as "customer code sorting", except for those that are set to not display, the screen of Figure 4A-2 appears in the sorting.
而第4B-1~4B-2圖的欄位說明如第4C-1~4C-3圖所示（第4B-1~4B-2圖係為一連續的表格，且皆對應著Member000~009），有幾個欄位特別說明如下： (1) 「strColumnType」欄位，用已設定日期格式； (2) 「ysnPK」欄位，設定中僅允許一個PK； (3) 「strJoinTable」欄位，用以設定下拉選項類欄位，若無實際表格時，可設定來呈現對應顯示值； 例如：性別，設定資料欄位值( strEnterValue)及顯示的值(strDisplayValue)，而表格設定如下所示： (4) 「strJoinValue」欄位，用以設定下拉選項類欄位； (5) 「strJoinOnColumn」欄位，用以設定下拉選項類欄位。 The fields in Figures 4B-1~4B-2 are as shown in Figures 4C-1~4C-3 (the 4B-1~4B-2 diagrams are a continuous table, and all correspond to Member000~009 There are several fields that are specifically described as follows: (1) "strColumnType" field, with the date format set; (2) "ysnPK" field, only one PK is allowed in the setting; (3) "strJoinTable" field Used to set the drop-down option class field. If there is no actual table, it can be set to display the corresponding display value; for example: gender, set the data field value ( strEnterValue) and the displayed value (strDisplayValue), and the table settings are as follows : (4) The "strJoinValue" field is used to set the drop-down option class field; (5) The "strJoinOnColumn" field is used to set the drop-down option class field.
另外，於第4A-1圖的畫面上方，按下「 」，則會出現第4D圖的畫面，使用者可以直接拖拉欄位，變更順序或是否顯示，移動到下方(灰色)，則為不顯示區，移到上方(藍色)，代表顯示。 In addition, on the top of the screen of Figure 4A-1, press " The 4D picture will appear. The user can drag the field directly, change the order or whether it is displayed. If it moves to the bottom (gray), it will be the non-display area and move to the top (blue) to represent the display.
再進行說明查詢結果區，依據所取出的表單設定檔，能夠於該客戶端網頁程式31上呈現出如第5A圖或第5D圖所示的列表式或卡片式的操作介面及顯示區塊，而對應於第5A圖或第5D圖之strColumnClass ='MemberInfo'的設定如第5B-1~5B-2圖所示（第5B-1~5B-2圖係為一連續的表格，且皆對應著Member000~009），其中各顯示區塊對應如下： (1) 「會員姓名」：對應於Member001的設定 (2) 「會員生日」：對應於Member002的設定 (3) 「縣市」：對應於Member003的設定 (4) 「區域」：對應於Member004的設定 (5) 「會員性別」：對應於Member005的設定 (6) 「ERPID」：對應於Member007的設定 (7) 「手機」：對應於Member008的設定 (8) 「客戶代碼」：對應於Member009的設定The query result area is further described, and according to the extracted form profile, the list or card type operation interface and display block as shown in FIG. 5A or 5D can be presented on the client webpage program 31. The setting of strColumnClass = 'MemberInfo' corresponding to the 5A or 5D is as shown in the 5B-1~5B-2 (the 5B-1~5B-2 is a continuous table, and both correspond to Member000~009), each of the display blocks corresponds to the following: (1) "Member name": corresponding to the setting of Member001 (2) "Member birthday": corresponding to the setting of Member002 (3) "County and city": corresponds to Member003 setting (4) "Zone": corresponding to Member004 setting (5) "Member gender": corresponding to Member005 setting (6) "ERPID": corresponding to the setting of Member007 (7) "Mobile": corresponding to Member008 Setting (8) "Customer Code": Corresponds to the setting of Member009
另外，關於Member000的設定，由於是KEY碼，所以不會呈現於畫面中，故Member000的ysnListDisplay之設定值為0，而第5B-1~5B-2圖的欄位說明如第5C圖所示，有幾個欄位特別說明如下： (1) 「ysnPK」欄位，用以顯示超連結，因此能夠點選超連結後，進入編輯區。In addition, since the setting of Member000 is not the KEY code, it is not displayed on the screen. Therefore, the setting of the ysnListDisplay of the Member000 is 0, and the description of the field of the 5B-1~5B-2 is as shown in FIG. 5C. There are several fields that are specifically described as follows: (1) The "ysnPK" field is used to display hyperlinks, so you can click on the hyperlink and enter the editing area.
再進行說明基本資訊顯示區，依據所取出的表單設定檔，能夠於該客戶端網頁程式31上呈現出如第3C圖的操作介面及顯示區塊，而依照顯示區域，如第6A-1~6A-2圖所示（第6A-1~6A-2圖係為一連續的表格），此表格設定編輯區中會需要的那幾個區域，而第6A-1~6A-2圖的欄位說明如第6B所示，有幾個欄位特別說明如下： (1) 「strClassID」欄位，對應CL_Class.strClassID； (2) 「strClassDesc」欄位，對應會員資訊，這可不用設定； (3) 「strClassType」欄位，若只有一個表格，則設定Head即可，若為一對多的表格，則設定主檔為Head，明細檔為Detail。例如：訂單主檔為Head，訂單明細表為Detail； (4) 「strArea」欄位，區域代表，可自行命名； (5) 「strAreaDesc」欄位，名稱，會顯示在區域中，如第6B圖中的「strAreaDesc」欄位的備註中所示； (6) 「strCSSClassName」欄位，設定會顯示區域上面條的顏色，如第6B圖中的「strCSSClassName」欄位的備註中所示； (7) 「ysnMust」欄位，若為必要代表此區域為必填，如第6B圖中的「ysnMust」欄位的備註中所示； (8) 「ysnModify」欄位，若不可修改為ReadOnly； (9) 「ysnDisplay」欄位，雖然不顯示，但資料仍會存入對應表格中。The basic information display area is further described. According to the extracted form configuration file, the operation interface and the display block of the 3C figure can be presented on the client webpage program 31, and according to the display area, for example, the 6A-1~ Figure 6A-2 (6A-1~6A-2 is a continuous table), this table sets the areas that will be needed in the editing area, and the columns of Figure 6A-1~6A-2 The bit descriptions are shown in Section 6B. There are several fields that are specifically described as follows: (1) The "strClassID" field corresponds to CL_Class.strClassID; (2) The "strClassDesc" field corresponds to member information, which can be set without setting; 3) The "strClassType" field, if there is only one table, set Head. If it is a one-to-many table, set the main file to Head and the detail file to Detail. For example: the order master file is Head, the order schedule is Detail; (4) "strArea" field, area representative, can be named by itself; (5) "strAreaDesc" field, name, will be displayed in the area, such as 6B In the remarks of the "strAreaDesc" field in the figure; (6) The "strCSSClassName" field, the setting will display the color of the upper bar of the area, as shown in the remarks of the "strCSSClassName" field in Figure 6B; 7) "ysnMust" field, if necessary, this field is required, as shown in the remarks of the "ysnMust" field in Figure 6B; (8) "ysnModify" field, if not modified to ReadOnly; (9) The “ysnDisplay” field, although not displayed, will still be stored in the corresponding table.
再進行說明新增資訊區，於列表按下新增鍵後，依據所取出的表單設定檔，能夠於該客戶端網頁程式31上顯示如第7A圖的主要資訊編輯POPUP視窗，而對應於第7A圖之設定如第7B-1~7B-2圖所示（表格設定不同區域中所擁有的欄位資訊、而第7B-1~7B-2圖係為一連續的表格），其中各顯示區塊對應如下： (1) 「客戶代碼」：對應於「A002」的設定； (2) 「姓名」：對應於「A003」的設定； (3) 「ERPID」：對應於「A007」的設定；Then, the new information area is added. After the new key is pressed in the list, according to the extracted form configuration file, the main information editing POPUP window as shown in FIG. 7A can be displayed on the client webpage program 31, and corresponds to the first The setting of 7A is as shown in Figure 7B-1~7B-2 (the table sets the field information in different areas, and the 7B-1~7B-2 is a continuous table), in which each display The block corresponds to the following: (1) "Customer Code": corresponds to the setting of "A002"; (2) "Name": corresponds to the setting of "A003"; (3) "ERPID": corresponds to the setting of "A007" ;
另外，關於「A001」的設定，由於是KEY碼，所以不會呈現於畫面中，而「E001」及「E002」的設定皆是系統自動產生，所以設定為不顯示，但若要顯示也是可以的，因此上述三個設定的ysnDisplay之設定值為0；In addition, the setting of "A001" is not displayed on the screen because it is a KEY code, and the settings of "E001" and "E002" are automatically generated by the system, so it is set to not display, but it can be displayed. Therefore, the setting of ysnDisplay of the above three settings is 0;
而第7B-1~7B-2圖的欄位說明如第7C-1~7C-2圖所示，有幾個欄位特別說明如下： (1) 「strJoinTable」欄位，若無實際表格時，可設定來呈現對應顯示值，例如：性別，設定資料欄位值(strEnterValue)及顯示的值(strDisplayValue)，而表格設定如下所示： (2) 「strJoinValue」欄位，若關連表格為CF_DisplaySetting，則不需設定； (3) 「strJoinOnColumn」欄位，若關連表格為CF_DisplaySetting，則不需設定； (4) 「ysnMust」欄位，若設為必填，欄位名稱前方會有*號，否則則無，如「* 客戶代碼」； (5) 「ysnModify」欄位，可維護欄位才可編輯，否則為ReadOnly； (6) 「strAutoCode」欄位，自動編碼設定於CF_AutoCode，設定如第7C-2圖，表示如下： (a) Seqno：流水號，對應之intSegmentBit為補0長度，例如，為3，則代表產生的之流水號為001，002，003… (b) Value：固定值，固定產生strSegmentValue設定的值 (c) Guid：產生GUID碼 (d) LoginID：登入者帳號 (e) Function：SQL語法 另外，若一個AutoCode需要多種組合，例如第1碼為P+yyyymmdd+流水號，則設定相同的strAutoCode，以intSeqmentOrder的順序組成。 (7) 「ysnPK」欄位，來源表格的PK； (8) 「ysnKey」欄位，供系統驗證資料是否重覆，而設定資料是否重覆，能夠設定一筆資料（例如設定姓名欄位驗證，當輸入資料後，當有相同姓名資料已存在時，將無法建立存檔）重覆或是兩筆以上的資料重覆（例如設定姓名+手機號碼欄位驗證，當輸入資料後，當有相同姓名及相同手機號碼資料皆已存在時，將無法建立存檔）。 The description of the fields in Figures 7B-1~7B-2 is shown in Figure 7C-1~7C-2. There are several fields that are specifically described as follows: (1) "strJoinTable" field, if there is no actual form , can be set to display the corresponding display value, such as: gender, set the data field value (strEnterValue) and the displayed value (strDisplayValue), and the table settings are as follows: (2) "strJoinValue" field, if the related table is CF_DisplaySetting, no need to set; (3) "strJoinOnColumn" field, if the related table is CF_DisplaySetting, no need to set; (4) "ysnMust" field, if Set as required, there will be an * in front of the field name, otherwise no, such as "*Customer Code"; (5) "ysnModify" field, the field can be edited, otherwise ReadOnly; (6) " The strAutoCode field is automatically set to CF_AutoCode and is set as shown in Figure 7C-2. It is expressed as follows: (a) Seqno: the serial number, corresponding to intSegmentBit is the complement 0 length, for example, 3, which represents the generated serial number. 001,002,003... (b) Value: fixed value, fixed value generated by strSegmentValue (c) Guid: generated GUID code (d) LoginID: login user account (e) Function: SQL syntax In addition, if an AutoCode needs Various combinations, for example, the first code is P+yyyymmdd+serial number, then the same strAutoCode is set, which is composed in the order of intSeqmentOrder. (7) "ysnPK" field, PK of source form; (8) "ysnKey" field for system verification whether the data is repeated, and whether the setting data is repeated, can set a piece of information (such as setting name field verification, After entering the data, when the same name data already exists, it will not be able to create an archive. Repeat or repeat more than two pieces of data (for example, set name + mobile number field verification, when entering the data, when there is the same name If the same mobile phone number data already exists, the archive will not be created).
再進行編輯區，當於第3C圖按下編輯後，會依前述的設定顯示可編輯的欄位及其對應欄位的型態及限制，開啟如第8圖所述的編輯視窗，而其表單設定檔與新增資訊區說明類似，故不在重複說明。Then, in the editing area, when the editing is performed in the 3C figure, the editable field and the corresponding field type and restriction are displayed according to the foregoing settings, and the editing window as shown in FIG. 8 is opened, and The form profile is similar to the new information section description, so it is not repeated.
本發明所提供之複雜性表單應用系統，與其他習用技術相互比較時，其優點如下： (1) 本發明能夠設計出多種表單設定檔，能夠依據輸入不同的類別參數，以進行取出不同的表單設定檔，並藉由所取出的表單設定檔於該資料庫平台中撈取資料、並於一網頁程式上呈現出運作所需之操作介面及顯示區塊，而所撈取的資料能夠一併顯示於該顯示區塊中。 (2) 本發明是設計出一種複雜性表單，如同程式轉換器的功能一般，當有不同客戶需要這一類需要新增、修改、刪除等具有查詢與編輯功能的軟體時，廠商將不需重新設計一套新的軟體，而是直接透過更改表單設定檔內的設定值，則能夠直接轉換出不同客戶需求的操作介面及顯示區塊，如此能夠減少廠商重覆設計同一類型軟體的時間與人力成本。The advantages of the complexity form application system provided by the present invention when compared with other conventional technologies are as follows: (1) The present invention can design a plurality of form configuration files, and can input different forms according to inputting different category parameters. The profile is displayed in the database platform by using the extracted form profile, and the operation interface and display block required for operation are presented on a webpage program, and the retrieved data can be displayed together In the display block. (2) The present invention is to design a complexity form, like the function of a program converter. When there are different types of software that need to be added, modified, deleted, etc., which have query and edit functions, the manufacturer will not need to re- Designing a new software, but directly changing the settings in the form configuration file, you can directly convert the operation interface and display block of different customer requirements, thus reducing the time and labor for manufacturers to repeatedly design the same type of software. cost.
本發明已透過上述之實施例揭露如上，然其並非用以限定本發明，任何熟悉此一技術領域具有通常知識者，在瞭解本發明前述的技術特徵及實施例，並在不脫離本發明之精神和範圍內，當可作些許之更動與潤飾，因此本發明之專利保護範圍須視本說明書所附之請求項所界定者為準。The present invention has been disclosed in the above embodiments, and is not intended to limit the present invention. Any of those skilled in the art can understand the foregoing technical features and embodiments of the present invention without departing from the invention. In the spirit and scope, the scope of patent protection of the present invention is subject to the definition of the claims attached to the present specification.
1‧‧‧資料庫軟體
2‧‧‧資料庫平台
21‧‧‧複雜性表單設定模組
3‧‧‧電腦設備
30‧‧‧螢幕
31‧‧‧客戶端網頁程式
311‧‧‧表單設定檔對應模組
312‧‧‧複雜性表單呈現模組1‧‧‧Database software
2‧‧‧Database Platform
21‧‧‧Complex form setting module
3‧‧‧Computer equipment
30‧‧‧ screen
31‧‧‧Client web application
311‧‧‧Form configuration file corresponding module
312‧‧‧Complex form presentation module
[第1圖]係習用資料撈取示意圖。 [第2A圖]係本發明複雜性表單應用系統之整體架構示意圖。 [第2B圖]係本發明複雜性表單應用系統之客戶端網頁程式之內部架構示意圖。 [第3A圖]係本發明複雜性表單應用系統之表單設定檔取出實施示意圖。 [第3B圖]係本發明複雜性表單應用系統之表單設定檔取出後呈現畫面實施示意圖。 [第3C圖]係本發明複雜性表單應用系統之表單設定檔取出後呈現畫面實施示意圖。 [第4A-1圖]係本發明複雜性表單應用系統之查詢條件實施示意圖。 [第4A-2圖]係本發明複雜性表單應用系統之查詢條件排序實施示意圖。 [第4B-1圖]係本發明複雜性表單應用系統之查詢條件設定實施示意圖。 [第4B-2圖]係本發明複雜性表單應用系統之查詢條件設定實施示意圖。 [第4C-1圖]係本發明複雜性表單應用系統之查詢條件欄位說明實施示意圖。 [第4C-2圖]係本發明複雜性表單應用系統之查詢條件欄位說明實施示意圖。 [第4D圖]係本發明複雜性表單應用系統之查詢條件拖移欄位實施示意圖。 [第5A圖]係本發明複雜性表單應用系統之列表式查詢結果實施示意圖。 [第5B-1圖]係本發明複雜性表單應用系統之查詢結果設定實施示意圖。 [第5B-2圖]係本發明複雜性表單應用系統之查詢結果設定實施示意圖。 [第5C圖]係本發明複雜性表單應用系統之查詢條件欄位說明實施示意圖。 [第5D圖]係本發明複雜性表單應用系統之卡片式查詢結果實施示意圖。 [第6A-1圖]係本發明複雜性表單應用系統之資訊顯示設定實施示意圖。 [第6A-2圖]係本發明複雜性表單應用系統之資訊顯示設定實施示意圖。 [第6B圖]係本發明複雜性表單應用系統之資訊顯示欄位說明實施示意圖。 [第7A圖]係本發明複雜性表單應用系統之會員新增實施示意圖。 [第7B-1圖]係本發明複雜性表單應用系統之會員新增設定實施示意圖。 [第7B-2圖]係本發明複雜性表單應用系統之會員新增設定實施示意圖。 [第7C-1圖]係本發明複雜性表單應用系統之會員新增欄位說明實施示意圖。 [第7C-2圖]係本發明複雜性表單應用系統之會員新增欄位說明實施示意圖。 [第8圖]係本發明複雜性表單應用系統之資訊顯示實施示意圖。[Fig. 1] is a schematic diagram of the data acquisition. [Fig. 2A] is a schematic diagram of the overall architecture of the complexity form application system of the present invention. [Fig. 2B] is a schematic diagram of the internal architecture of the client webpage program of the complexity form application system of the present invention. [Fig. 3A] is a schematic diagram showing the implementation of the form setting file of the complexity form application system of the present invention. [Fig. 3B] is a schematic diagram showing the implementation of the presentation of the form profile of the complexity form application system of the present invention. [FIG. 3C] FIG. 3 is a schematic diagram showing the implementation of the presentation of the form profile of the complexity form application system of the present invention. [Fig. 4A-1] is a schematic diagram of the implementation of the query condition of the complexity form application system of the present invention. [Fig. 4A-2] is a schematic diagram of the ordering of query conditions of the complexity form application system of the present invention. [Fig. 4B-1] is a schematic diagram showing the implementation of the query condition setting of the complexity form application system of the present invention. [Fig. 4B-2] is a schematic diagram showing the implementation of the query condition setting of the complexity form application system of the present invention. [Fig. 4C-1] is a schematic diagram showing the implementation of the query condition field of the complexity form application system of the present invention. [Fig. 4C-2] is a schematic diagram showing the implementation of the query condition field of the complexity form application system of the present invention. [Fig. 4D] is a schematic diagram of the implementation of the query condition dragging field of the complexity form application system of the present invention. [Fig. 5A] is a schematic diagram showing the implementation of the list query result of the complexity form application system of the present invention. [Fig. 5B-1] is a schematic diagram showing the implementation of the query result setting of the complexity form application system of the present invention. [Fig. 5B-2] is a schematic diagram showing the implementation of the query result setting of the complexity form application system of the present invention. [Fig. 5C] is a schematic diagram showing the implementation of the query condition field of the complexity form application system of the present invention. [Fig. 5D] is a schematic diagram showing the implementation of the card-type query result of the complexity form application system of the present invention. [Fig. 6A-1] is a schematic diagram showing the implementation of information display setting of the complexity form application system of the present invention. [Fig. 6A-2] is a schematic diagram showing the implementation of information display setting of the complexity form application system of the present invention. [Fig. 6B] is a schematic diagram showing the implementation of the information display field of the complexity form application system of the present invention. [Fig. 7A] is a schematic diagram of a newly implemented member of the complexity form application system of the present invention. [Fig. 7B-1] is a schematic diagram of a new configuration of a member of the complexity form application system of the present invention. [Fig. 7B-2] is a schematic diagram of a new configuration of a member of the complexity form application system of the present invention. [Fig. 7C-1] is a schematic diagram of the implementation of the new field description of the member of the complexity form application system of the present invention. [Fig. 7C-2] is a schematic diagram of the implementation of the new field description of the member of the complexity form application system of the present invention. [Fig. 8] is a schematic diagram showing the implementation of information display of the complexity form application system of the present invention.
Claims (6)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| TW106112098A TWI626582B (en) | 2017-04-11 | 2017-04-11 | Complex form application system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| TW106112098A TWI626582B (en) | 2017-04-11 | 2017-04-11 | Complex form application system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| TWI626582B true TWI626582B (en) | 2018-06-11 |
| TW201837689A TW201837689A (en) | 2018-10-16 |
Family
ID=63256093
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| TW106112098A TWI626582B (en) | 2017-04-11 | 2017-04-11 | Complex form application system |
Country Status (1)
| Country | Link |
|---|---|
| TW (1) | TWI626582B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200802029A (en) * | 2005-09-26 | 2008-01-01 | Ingrian Networks Inc | System and method for protecting sensitive data in a database |
| US20090049288A1 (en) * | 2007-08-17 | 2009-02-19 | Salesforce.Com, Inc. | System, method, and computer program product for runtime invocation of an appropriate version of program instructions in an on-demand database |
| TW201413482A (en) * | 2012-06-14 | 2014-04-01 | Melaleuca Inc | Simplified interaction with complex database |
| TW201445953A (en) * | 2013-04-29 | 2014-12-01 | Nokia Corp | White space database discovery |
-
2017
- 2017-04-11 TW TW106112098A patent/TWI626582B/en not_active IP Right Cessation
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200802029A (en) * | 2005-09-26 | 2008-01-01 | Ingrian Networks Inc | System and method for protecting sensitive data in a database |
| US20090049288A1 (en) * | 2007-08-17 | 2009-02-19 | Salesforce.Com, Inc. | System, method, and computer program product for runtime invocation of an appropriate version of program instructions in an on-demand database |
| TW201413482A (en) * | 2012-06-14 | 2014-04-01 | Melaleuca Inc | Simplified interaction with complex database |
| TW201445953A (en) * | 2013-04-29 | 2014-12-01 | Nokia Corp | White space database discovery |
Also Published As
| Publication number | Publication date |
|---|---|
| TW201837689A (en) | 2018-10-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10242331B2 (en) | Supplemental system for business intelligence systems to provide visual identification of meaningful differences | |
| US9727836B2 (en) | Systems and methods for generating data visualization dashboards | |
| US8234137B2 (en) | One view integrated project management system | |
| CN106599039B (en) | Statistical representation method supporting free combination nesting of relational database data | |
| US9678719B1 (en) | System and software for creation and modification of software | |
| US20120246170A1 (en) | Managing compliance of data integration implementations | |
| US20040221258A1 (en) | Method and apparatus for generating custom status display | |
| US20170329786A1 (en) | Data flow design with static and dynamic elements | |
| US20060271863A1 (en) | User definable task based interface | |
| US20040122699A1 (en) | Method and system for integrating workflow management with business intelligence | |
| WO2007030585A1 (en) | Browse mode designer | |
| US7512451B2 (en) | System and method for interactive process management | |
| US11693873B2 (en) | Systems and methods for using entity/relationship model data to enhance user interface engine | |
| JP2018067163A (en) | Construction body three-dimensional model management program and construction body three-dimensional model management method | |
| TWI626582B (en) | Complex form application system | |
| US8392442B2 (en) | Method and computer program product for creating content management systems | |
| Yu | Getting started with Salesforce Einstein analytics: A Beginner’s guide to building interactive dashboards | |
| Luck | Sample | |
| KR101499052B1 (en) | A method for building cardbook using knowledge card based on digital information | |
| Floyd | QlikView Scripting | |
| WO2024065338A1 (en) | Electronic kanban determining method and apparatus | |
| Lidberg | Getting Started with SQL Server 2012 Cube Development | |
| Chhatrapati | Reporting in TFS | |
| Lai et al. | SAP BusinessObjects Dashboards 4.1 Cookbook | |
| Root et al. | Reporting with Microsoft Excel |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| MM4A | Annulment or lapse of patent due to non-payment of fees |