建立IEC／MIL線種SQL資料庫暨批次線種命名簡易輸入工具（含JIS規格擴充與建置資料庫）Establish an IEC/MIL cable type SQL database and a simple batch cable type naming input tool (including JIS specification expansion and database creation).

 建立JIS／IEC／MIL線種SQL資料庫暨批次線種命名簡易輸入工具（含JIS規格擴充與建置資料庫）Establish an JIS/IEC/MIL cable type SQL database and a simple batch cable type naming input tool (including JIS specification expansion and database creation).

一、 功能敘述 Function Description

於系統圖中，輸入”SCA”或點擊 後視窗如下，預設先呈現JIS， 請見以下說明：

 In the system diagram, enter "SCA" or click the following window. JIS is displayed first by default. Please see the following explanation:

1. 電纜種類頁籤：依需求切換。

Cable Type Tab: Switch as needed.

2. 廠家電纜規格書：資料來源，用於詳查線徑，特性說明等…
Manufacturer's Cable Specification Sheet: Data source, used for detailed checking of wire diameter, characteristic descriptions, etc.

3. 選擇區：已過濾不適用之電纜，只要點選任一項，item5線種&item7最終選擇電纜品項即出現。
Selection Area: Unsuitable cables have been filtered. Simply select any item, and the cable type for item 5 and the final cable selection for item 7 will appear.

4. 選擇區選取後即出現對應之規格/耐電流/耐電流*0.85(法規規定)/額定電壓，預設選取第一個。
After selection in the selection area, the corresponding specification/current withstand/current withstand * 0.85 (regulated)/rated voltage will appear. The first option is selected by default.

5. 線種結果：＃變數為規格。
Cable Type Result: # Variable represents the specification.

6. 歷史紀錄區：當使用數次後，會記錄使用過的線種，勾選”選取歷史紀錄”以便再次輸入，若不要紀錄則按”清除”。
History Record Area: After several uses, the used cable types will be recorded. Check "Select History Record" for re-entry; otherwise, click "Clear".

7. 最終選擇電纜品項：決定之電纜結果，可複製。
Final Cable Selection: The final cable selection result can be copied.

8. 選取電纜：點擊按鈕後，在繪圖區選擇單或複數線種圖塊，最後再按空白鍵，即全匯入完成。
Select Cable: After clicking the button, select one or more cable type blocks in the drawing area, and finally press the space bar to complete the import.

9. 匯入結果：呈現匯入數量，以確保匯入正確。
Import Results: Displays the imported quantity to ensure correct import.

10. 使用說明：方便第一次操作者了解此程式使用方法。
Instructions: Helps first-time users understand how to use this program.

11. 離開：關閉視窗
Exit: Closes the window.

二、 範例 Example

1. 紅框選擇要輸入的線種。

 Select the cable types to be imported using the red box.

2.點擊＂選取電纜＂按鈕，框選將選中9個線種圖。

Click the "Select Cable" button; the selection box will select 9 cable type blocks.

3.按空白鍵確定後，即產生線種，圖面匯入完成如下。歷史紀錄則出現，匯入結果出現文字表示匯入9個完成。

Press the space bar to confirm. The cable types are now generated, and the import is complete as shown below. The history will appear, and the import result will display text indicating that 9 cables have been imported.

 三、 線種分類JIS選單

 JIS Cable Classification Menu

電源線種：線徑1.5~185 Power Cable: Wire Diameter 1.5~185 m

多芯線種：線數2~77 Multi-core Cable: 2~77 Wires

絞線線種：成對數1~48  Twisted Cable: 1~48 Pairs

同軸線種：依四種屬性 Coaxial Cable: According to four attributes

網路：依四種屬性 Network: According to four attributes

光纖：依四種屬性 Fiber Optic: According to four attributes

其他：依類型及說明 Other: According to type and description

四、 選取MIL頁籤，”常用”選項，如下圖，補充說明如下文，步驟5之後與JIS操作步驟6~11相同

 Select the MIL tab, "Common" option, as shown in the image below. Supplementary explanation is as follows. Steps after 5 are the same as JIS operation steps 6~11.

1. 廠家電纜文件：點擊圖片可看詳細規格
Manufacturer's Cable Documents: Click the image to view detailed specifications.

2. 選擇電纜：分常用（如設計便覽）與全部軍規電纜（MURRAY BENJAMIN）
Select Cable: Divided into Common (e.g., Design Overview) and All Military Grade Cables (MURRAY BENJAMIN).

3. 電纜使用分類：依設備性質點選。
Cable Usage Classification: Select according to equipment type.

4. 種類與特性表：種類會列出其特性，額定電壓等性質。
Type and Characteristic Table: The type will list its characteristics, rated voltage, etc.

5. 規格與耐電流表：種類選完後，接續會顯示該對應之規格與耐電流。
Specification and Current Capacity Table: After selecting the type, the corresponding specifications and current capacity will be displayed.

五、 若MIL不使用常用電纜，可選取”全部”選項如下圖

 If MIL does not use common cables, select the "All" option as shown in the image below.

六、 選取IEC頁籤，GC(廠家General cable)如下圖，補充說明如下文，步驟4之後與JIS操作步驟6~11相同

 Select the IEC tab, GC (Manufacturer General Cable) as shown in the image below. Supplementary explanations are as follows: Steps after 4 are the same as JIS operation steps 6-11.

1. 廠家電纜選擇：共有General cable，LS cable，和Kukdong，圖示為廠家電纜文件。
Manufacturer Cable Selection: There are General cable, LS cable, and Kukdong. The image shows the manufacturer cable document.

2. 電纜種類選擇區：任一項點選後即產生種類，及規格等屬性。
Cable Type Selection Area: Selecting any item will generate the type and specifications.

3. 種類結果欄：＃變數為規格
Type Result Column: # Variable represents the specification.

4. 規格，耐電流，額定電壓表：任一項點選後即產生最終選擇電纜品項。
Specifications, Current Withstand, Rated Voltage Meter: Selecting any item will generate the final selected cable item.

七、 選取IEC頁籤，LS廠家如下圖

 Select the IEC tab, LS manufacturer shown in the image below.

八、 選取IEC頁籤，Kukdong廠家如下圖

 Select the IEC tab, Kukdong manufacturer shown in the image below.

以下對於程式注意事項：

The following are  notes regarding the program:

1. 電纜資料維護：透過SQL Server Management Studio上瀏覽表格，資料庫路徑位於資料表，以下有五個分類表：

Cable data maintenance: View the tables through SQL Server Management Studio. The database path is Tables. There are five category tables:

表格名稱Table Name	表格內容Table Content
cable_category	電纜分類Cable category
cable_standard	三大電纜標準hree major cable standards(JIS，MIL，IEC)
cable_manufacturer	各類廠家Various manufacturers
cable_type	種類，特性Type, characteristics
cable_spec	規格，耐電流Specification, current withstand