프로젝트

일반

사용자정보

개정판 2e92b956

ID2e92b956bf109226449835843680f75ec3ddaae6
상위 4cadb2de
하위 6d6d47e3

gaqhf 이(가) 4년 이상 전에 추가함

dev issue #000 : add sql server

Change-Id: I7d64e7074737d58c91c58bfa65804458bbedf6e8

차이점 보기:

DTI_PID/SPPIDConverter/AutoModeling.cs
889 889
        }
890 890
        private void RunInputSymbolAttribute()
891 891
        {
892
            SplashScreenManager.Default.SendCommand(SPPIDSplashScreen.SplashScreenCommand.SetAllProgress, document.SYMBOLS.Count + document.Equipments.Count);
892
            SplashScreenManager.Default.SendCommand(SPPIDSplashScreen.SplashScreenCommand.SetAllProgress, document.SYMBOLS.Count + document.Equipments.Count + document.LINES.Count);
893 893
            SplashScreenManager.Default.SendCommand(SPPIDSplashScreen.SplashScreenCommand.SetStep, "Set Symbols Attribute");
894 894
            foreach (var item in document.SYMBOLS)
895 895
                try
......
918 918
                    Log.Write(ex.Message);
919 919
                    Log.Write(ex.StackTrace);
920 920
                }
921
            foreach (var item in document.LINES)
922
                try
923
                {
924
                    InputSymbolAttribute(item, item.ATTRIBUTES);
925
                    SplashScreenManager.Default.SendCommand(SPPIDSplashScreen.SplashScreenCommand.UpProgress, null);
926
                }
927
                catch (Exception ex)
928
                {
929
                    Log.Write("Error in InputSymbolAttribute");
930
                    Log.Write("UID : " + item.UID);
931
                    Log.Write(ex.Message);
932
                    Log.Write(ex.StackTrace);
933
                }
921 934
        }
922 935
        private void RunInputSpecBreakAttribute()
923 936
        {
......
4746 4759
                foreach (var item in targetAttributes)
4747 4760
                {
4748 4761
                    AttributeMapping mapping = document.AttributeMappings.Find(x => x.UID == item.UID);
4749
                    if (mapping != null && !string.IsNullOrEmpty(item.VALUE) && item.VALUE != "None")
4762
                    LMAAttribute _LMAAttribute = _LMModelItem.Attributes[mapping.SPPIDATTRIBUTENAME];
4763
                    if (mapping.SPPIDATTRIBUTENAME == "OperFluidCode" && !string.IsNullOrEmpty(item.VALUE))
4764
                    {
4765
                        LMAAttribute _FluidSystemAttribute = _LMModelItem.Attributes["FluidSystem"];
4766
                        if (_FluidSystemAttribute != null)
4767
                        {
4768
                            DataTable dt = SPPID_DB.GetFluidSystemInfo(item.VALUE);
4769
                            if (dt.Rows.Count == 1)
4770
                            {
4771
                                string fluidSystem = dt.Rows[0]["CODELIST_TEXT"].ToString();
4772
                                if (DBNull.Value.Equals(_FluidSystemAttribute.get_Value()))
4773
                                    _FluidSystemAttribute.set_Value(fluidSystem);
4774
                                else if (_FluidSystemAttribute.get_Value() != fluidSystem)
4775
                                    _FluidSystemAttribute.set_Value(fluidSystem);
4776

  
4777
                                if (_LMAAttribute != null)
4778
                                {
4779
                                    if (DBNull.Value.Equals(_LMAAttribute.get_Value()))
4780
                                        _LMAAttribute.set_Value(item.VALUE);
4781
                                    else if (_LMAAttribute.get_Value() != item.VALUE)
4782
                                        _LMAAttribute.set_Value(item.VALUE);
4783
                                }
4784
                            }
4785
                            if (dt != null)
4786
                                dt.Dispose();
4787
                        }
4788
                    }
4789
                    else if (mapping != null && !string.IsNullOrEmpty(item.VALUE) && item.VALUE != "None")
4750 4790
                    {
4751 4791
                        if (!mapping.IsText)
4752 4792
                        {
DTI_PID/SPPIDConverter/DB/SPPID_DB.cs
7 7
using System.Globalization;
8 8
using System.IO;
9 9
using Oracle.ManagedDataAccess.Client;
10
using System.Data.SqlClient;
10 11

  
11 12
namespace Converter.SPPID.DB
12 13
{
......
83 84
                        }
84 85
                    }
85 86
                }
86
                else
87
                else if (dbInfo.DBType == "SQLSERVER")
87 88
                {
88 89

  
89 90
                }
......
159 160
                        }
160 161
                    }
161 162
                }
162
                else
163
                else if (dbInfo.DBType == "SQLSERVER")
163 164
                {
165
                    string connString = string.Format("server = {0}; uid = {1}; pwd = {2}; database = {3};", dbInfo.Service, dbInfo.DBUser, dbInfo.DBPassword, dbInfo.SQLSERVER_DBNAME);
166
                    using (SqlConnection conn = new SqlConnection(connString))
167
                    {
168
                        conn.Open();
169
                        if (conn.State == ConnectionState.Open)
170
                        {
171
                            using (SqlCommand cmd = new SqlCommand())
172
                            {
173
                                cmd.Connection = conn;
164 174

  
175
                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, @"SELECT SP_SCHEMA_TYPE, USERNAME
176
                                                FROM {0}.T_DB_DATA DB_DATA 
177
                                                INNER JOIN {0}.T_ROOTITEM ROOTITEM ON DB_DATA.SP_ROOTITEMID = ROOTITEM.SP_ID 
178
                                                WHERE ROOTITEM.NAME = '{1}'", dbInfo.Site, dbInfo.SelectedPlant);
179
                                using (SqlDataAdapter adapter = new SqlDataAdapter())
180
                                {
181
                                    DataTable dt = new DataTable();
182
                                    adapter.SelectCommand = cmd;
183
                                    adapter.Fill(dt);
184

  
185
                                    foreach (DataRow row in dt.Rows)
186
                                    {
187
                                        string sType = row["SP_SCHEMA_TYPE"].ToString();
188
                                        switch (sType)
189
                                        {
190
                                            case "SPPIDDATA_DICTIONARY":
191
                                                dbInfo.PlantPIDDic = row["USERNAME"].ToString();
192
                                                break;
193
                                            case "DATA_DICTIONARY":
194
                                                dbInfo.PlantDic = row["USERNAME"].ToString();
195
                                                break;
196
                                            case "SPAPLANT":
197
                                                dbInfo.Plant = row["USERNAME"].ToString();
198
                                                break;
199
                                            case "SPPID":
200
                                                dbInfo.PlantPID = row["USERNAME"].ToString();
201
                                                break;
202
                                            default:
203
                                                break;
204
                                        }
205
                                        bResult = true;
206
                                    }
207
                                }
208

  
209
                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT PATH FROM {0}.T_ROOTITEM WHERE NAME = '{1}'", dbInfo.Site, dbInfo.SelectedPlant);
210
                                using (SqlDataReader reader = cmd.ExecuteReader())
211
                                {
212
                                    while (reader.Read())
213
                                    {
214
                                        dbInfo.PlantPath = reader["PATH"].ToString();
215
                                    }
216
                                }
217
                            }
218
                        }
219
                    }
165 220
                }
166 221
            }
167 222
            catch (Exception ex)
......
202 257
                        }
203 258
                    }
204 259
                }
205
                else
260
                else if (dbInfo.DBType == "SQLSERVER")
206 261
                {
262
                    string connString = string.Format("server = {0}; uid = {1}; pwd = {2}; database = {3};", dbInfo.Service, dbInfo.DBUser, dbInfo.DBPassword, dbInfo.SQLSERVER_DBNAME);
263
                    using (SqlConnection conn = new SqlConnection(connString))
264
                    {
265
                        conn.Open();
266
                        if (conn.State == ConnectionState.Open)
267
                        {
268
                            using (SqlCommand cmd = new SqlCommand())
269
                            {
270
                                cmd.Connection = conn;
271
                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT NAME, PATH FROM {0}.T_ROOTITEM", dbInfo.Site);
207 272

  
273
                                using (SqlDataReader reader = cmd.ExecuteReader())
274
                                {
275
                                    while (reader.Read())
276
                                    {
277
                                        plantList.Add(reader["NAME"].ToString());
278
                                    }
279
                                }
280
                            }
281

  
282
                        }
283
                    }
208 284
                }
209 285
            }
210 286
            catch (Exception ex)
......
246 322
                                adapter.SelectCommand = cmd;
247 323
                                dt = new DataTable();
248 324
                                adapter.Fill(dt);
325
                                foreach (DataColumn item in dt.Columns)
326
                                    item.ColumnName = item.ColumnName.ToUpper();
249 327
                            }
250 328
                        }
251 329
                    }
252 330
                }
253
                else
331
                else if (dbInfo.DBType == "SQLSERVER")
254 332
                {
255

  
333
                    string connString = string.Format("server = {0}; uid = {1}; pwd = {2}; database = {3};", dbInfo.Service, dbInfo.DBUser, dbInfo.DBPassword, "plant");
334
                    using (SqlConnection conn = new SqlConnection(connString))
335
                    {
336
                        conn.Open();
337
                        if (conn.State == ConnectionState.Open)
338
                        {
339
                            string sQuery = string.Format(CultureInfo.CurrentCulture,
340
                                @"SELECT ITEM.description ItemType ,ATTR.displayname, ATTR.name FROM {0}.itemattributions ATTR 
341
                                LEFT OUTER JOIN {0}.item ITEM 
342
                                    ON ITEM.ID = ATTR.ITEMID 
343
                                ORDER BY ATTR.displayname ASC", dbInfo.PlantPIDDic);
344
                            //string sQuery = string.Format(CultureInfo.CurrentCulture,
345
                            //    @"SELECT DISTINCT(ATTR.displayname), ATTR.name FROM {0}.itemattributions ATTR
346
                            //    ORDER BY ATTR.displayname ASC", dbInfo.PlantPIDDic);
347
                            using (SqlCommand cmd = new SqlCommand(sQuery, conn))
348
                            using (SqlDataAdapter adapter = new SqlDataAdapter())
349
                            {
350
                                adapter.SelectCommand = cmd;
351
                                dt = new DataTable();
352
                                adapter.Fill(dt);
353
                                foreach (DataColumn item in dt.Columns)
354
                                    item.ColumnName = item.ColumnName.ToUpper();
355
                            }
356
                        }
357
                    }
256 358
                }
359

  
257 360
            }
258 361
            catch (Exception ex)
259 362
            {
......
289 392
                                adapter.SelectCommand = cmd;
290 393
                                dt = new DataTable();
291 394
                                adapter.Fill(dt);
395
                                foreach (DataColumn item in dt.Columns)
396
                                    item.ColumnName = item.ColumnName.ToUpper();
292 397
                            }
293 398
                        }
294 399
                    }
295 400
                }
296
                else
401
                else if (dbInfo.DBType == "SQLSERVER")
297 402
                {
298

  
403
                    string connString = string.Format("server = {0}; uid = {1}; pwd = {2}; database = {3};", dbInfo.Service, dbInfo.DBUser, dbInfo.DBPassword, "plant");
404
                    using (SqlConnection conn = new SqlConnection(connString))
405
                    {
406
                        conn.Open();
407
                        if (conn.State == ConnectionState.Open)
408
                        {
409
                            string sQuery = string.Format(CultureInfo.CurrentCulture,
410
                                @"SELECT * FROM {0}.CODELISTS OUTATTR 
411
                                WHERE OUTATTR.codelist_index =  
412
                                    (SELECT attr.codelist_constraint FROM {0}.CODELISTS ATTR WHERE ATTR.CODELIST_TEXT = '{1}' AND ATTR.CODELIST_NUMBER = 19) AND OUTATTR.CODELIST_NUMBER = 20", dbInfo.PlantPIDDic, operFluidCode);
413
                            using (SqlCommand cmd = new SqlCommand(sQuery, conn))
414
                            using (SqlDataAdapter adapter = new SqlDataAdapter())
415
                            {
416
                                adapter.SelectCommand = cmd;
417
                                dt = new DataTable();
418
                                adapter.Fill(dt);
419
                                foreach (DataColumn item in dt.Columns)
420
                                    item.ColumnName = item.ColumnName.ToUpper();
421
                            }
422
                        }
423
                    }
299 424
                }
300 425
            }
301 426
            catch (Exception ex)
DTI_PID/SPPIDConverter/DB/SPPID_DBInfo.cs
17 17
        private string _Port = string.Empty;
18 18
        private string _DBUser = string.Empty;
19 19
        private string _DBPassword = string.Empty;
20
        private string _SQLSERVER_DBNAME = string.Empty;
20 21

  
21 22
        private List<string> _PlantList = new List<string>();
22 23
        private string _SelectedPlant = string.Empty;
......
44 45
        public string PlantPID { get => _PlantPID; set => _PlantPID = value; }
45 46
        public string PlantPIDDic { get => _PlantPIDDic; set => _PlantPIDDic = value; }
46 47
        public bool Enable { get => _Enable; set => _Enable = value; }
48
        public string SQLSERVER_DBNAME { get => _SQLSERVER_DBNAME; set => _SQLSERVER_DBNAME = value; }
47 49

  
48 50
        public static SPPID_DBInfo GetInstance()
49 51
        {
DTI_PID/SPPIDConverter/Form/MappingForm.Designer.cs
240 240
            this.ribbonControl.ShowDisplayOptionsMenuButton = DevExpress.Utils.DefaultBoolean.False;
241 241
            this.ribbonControl.ShowPageHeadersMode = DevExpress.XtraBars.Ribbon.ShowPageHeadersMode.ShowOnMultiplePages;
242 242
            this.ribbonControl.ShowToolbarCustomizeItem = false;
243
            this.ribbonControl.Size = new System.Drawing.Size(1135, 27);
243
            this.ribbonControl.Size = new System.Drawing.Size(1135, 32);
244 244
            this.ribbonControl.Toolbar.ShowCustomizeItem = false;
245 245
            // 
246 246
            // layoutControl1
......
276 276
            this.layoutControl1.Controls.Add(this.textBoxFlowMarkSymbolPath);
277 277
            this.layoutControl1.Controls.Add(this.btnBorder);
278 278
            this.layoutControl1.Dock = System.Windows.Forms.DockStyle.Fill;
279
            this.layoutControl1.Location = new System.Drawing.Point(0, 27);
279
            this.layoutControl1.Location = new System.Drawing.Point(0, 32);
280 280
            this.layoutControl1.Name = "layoutControl1";
281 281
            this.layoutControl1.Root = this.Root;
282
            this.layoutControl1.Size = new System.Drawing.Size(1135, 792);
282
            this.layoutControl1.Size = new System.Drawing.Size(1135, 787);
283 283
            this.layoutControl1.TabIndex = 2;
284 284
            this.layoutControl1.Text = "layoutControl1";
285 285
            // 
286 286
            // gridControlDrawingAttribute
287 287
            // 
288
            this.gridControlDrawingAttribute.Location = new System.Drawing.Point(36, 543);
288
            this.gridControlDrawingAttribute.Location = new System.Drawing.Point(36, 546);
289 289
            this.gridControlDrawingAttribute.MainView = this.gridViewDrawingAttribute;
290 290
            this.gridControlDrawingAttribute.MenuManager = this.ribbonControl;
291 291
            this.gridControlDrawingAttribute.Name = "gridControlDrawingAttribute";
292
            this.gridControlDrawingAttribute.Size = new System.Drawing.Size(744, 173);
292
            this.gridControlDrawingAttribute.Size = new System.Drawing.Size(744, 165);
293 293
            this.gridControlDrawingAttribute.TabIndex = 42;
294 294
            this.gridControlDrawingAttribute.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
295 295
            this.gridViewDrawingAttribute});
......
302 302
            // 
303 303
            // textBoxVendorSymbolPath
304 304
            // 
305
            this.textBoxVendorSymbolPath.Location = new System.Drawing.Point(184, 370);
305
            this.textBoxVendorSymbolPath.Location = new System.Drawing.Point(184, 379);
306 306
            this.textBoxVendorSymbolPath.MenuManager = this.ribbonControl;
307 307
            this.textBoxVendorSymbolPath.Name = "textBoxVendorSymbolPath";
308 308
            this.textBoxVendorSymbolPath.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
315 315
            // btnImportData
316 316
            // 
317 317
            this.btnImportData.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnImportData.ImageOptions.SvgImage")));
318
            this.btnImportData.Location = new System.Drawing.Point(825, 690);
318
            this.btnImportData.Location = new System.Drawing.Point(830, 687);
319 319
            this.btnImportData.Name = "btnImportData";
320
            this.btnImportData.Size = new System.Drawing.Size(286, 38);
320
            this.btnImportData.Size = new System.Drawing.Size(281, 36);
321 321
            this.btnImportData.StyleController = this.layoutControl1;
322 322
            this.btnImportData.TabIndex = 39;
323 323
            this.btnImportData.Text = "Import Mapping Data";
......
326 326
            // btnExportData
327 327
            // 
328 328
            this.btnExportData.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnExportData.ImageOptions.SvgImage")));
329
            this.btnExportData.Location = new System.Drawing.Point(825, 648);
329
            this.btnExportData.Location = new System.Drawing.Point(830, 647);
330 330
            this.btnExportData.Name = "btnExportData";
331
            this.btnExportData.Size = new System.Drawing.Size(286, 38);
331
            this.btnExportData.Size = new System.Drawing.Size(281, 36);
332 332
            this.btnExportData.StyleController = this.layoutControl1;
333 333
            this.btnExportData.TabIndex = 38;
334 334
            this.btnExportData.Text = "Export Mapping Data";
......
337 337
            // btnExportExcel
338 338
            // 
339 339
            this.btnExportExcel.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnExportExcel.ImageOptions.Image")));
340
            this.btnExportExcel.Location = new System.Drawing.Point(825, 606);
340
            this.btnExportExcel.Location = new System.Drawing.Point(830, 607);
341 341
            this.btnExportExcel.Name = "btnExportExcel";
342
            this.btnExportExcel.Size = new System.Drawing.Size(286, 38);
342
            this.btnExportExcel.Size = new System.Drawing.Size(281, 36);
343 343
            this.btnExportExcel.StyleController = this.layoutControl1;
344 344
            this.btnExportExcel.TabIndex = 37;
345 345
            this.btnExportExcel.Text = "Export Mapping Info to Excel";
......
352 352
            0,
353 353
            0,
354 354
            0});
355
            this.spinEditDrainValveCellCount.Location = new System.Drawing.Point(557, 156);
355
            this.spinEditDrainValveCellCount.Location = new System.Drawing.Point(557, 158);
356 356
            this.spinEditDrainValveCellCount.MenuManager = this.ribbonControl;
357 357
            this.spinEditDrainValveCellCount.Name = "spinEditDrainValveCellCount";
358 358
            this.spinEditDrainValveCellCount.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
370 370
            0,
371 371
            0,
372 372
            0});
373
            this.spinEditMinSymbolGridCellCount.Location = new System.Drawing.Point(196, 156);
373
            this.spinEditMinSymbolGridCellCount.Location = new System.Drawing.Point(196, 158);
374 374
            this.spinEditMinSymbolGridCellCount.MenuManager = this.ribbonControl;
375 375
            this.spinEditMinSymbolGridCellCount.Name = "spinEditMinSymbolGridCellCount";
376 376
            this.spinEditMinSymbolGridCellCount.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
418 418
            // 
419 419
            // checkComboBoxLineNumberLocation
420 420
            // 
421
            this.checkComboBoxLineNumberLocation.Location = new System.Drawing.Point(546, 78);
421
            this.checkComboBoxLineNumberLocation.Location = new System.Drawing.Point(546, 79);
422 422
            this.checkComboBoxLineNumberLocation.MenuManager = this.ribbonControl;
423 423
            this.checkComboBoxLineNumberLocation.Name = "checkComboBoxLineNumberLocation";
424 424
            this.checkComboBoxLineNumberLocation.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
429 429
            // 
430 430
            // checkComboBoxNoteLocation
431 431
            // 
432
            this.checkComboBoxNoteLocation.Location = new System.Drawing.Point(538, 169);
432
            this.checkComboBoxNoteLocation.Location = new System.Drawing.Point(538, 172);
433 433
            this.checkComboBoxNoteLocation.MenuManager = this.ribbonControl;
434 434
            this.checkComboBoxNoteLocation.Name = "checkComboBoxNoteLocation";
435 435
            this.checkComboBoxNoteLocation.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
440 440
            // 
441 441
            // checkComboBoxTextLocation
442 442
            // 
443
            this.checkComboBoxTextLocation.Location = new System.Drawing.Point(538, 145);
443
            this.checkComboBoxTextLocation.Location = new System.Drawing.Point(538, 148);
444 444
            this.checkComboBoxTextLocation.MenuManager = this.ribbonControl;
445 445
            this.checkComboBoxTextLocation.Name = "checkComboBoxTextLocation";
446 446
            this.checkComboBoxTextLocation.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
452 452
            // btnImageRefresh
453 453
            // 
454 454
            this.btnImageRefresh.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnImageRefresh.ImageOptions.SvgImage")));
455
            this.btnImageRefresh.Location = new System.Drawing.Point(825, 564);
455
            this.btnImageRefresh.Location = new System.Drawing.Point(830, 567);
456 456
            this.btnImageRefresh.Name = "btnImageRefresh";
457
            this.btnImageRefresh.Size = new System.Drawing.Size(286, 38);
457
            this.btnImageRefresh.Size = new System.Drawing.Size(281, 36);
458 458
            this.btnImageRefresh.StyleController = this.layoutControl1;
459 459
            this.btnImageRefresh.TabIndex = 27;
460 460
            this.btnImageRefresh.Text = "Refresh SPPID Image";
......
462 462
            // 
463 463
            // textBoxDrainValveSize
464 464
            // 
465
            this.textBoxDrainValveSize.Location = new System.Drawing.Point(184, 303);
465
            this.textBoxDrainValveSize.Location = new System.Drawing.Point(184, 310);
466 466
            this.textBoxDrainValveSize.MenuManager = this.ribbonControl;
467 467
            this.textBoxDrainValveSize.Name = "textBoxDrainValveSize";
468 468
            this.textBoxDrainValveSize.Size = new System.Drawing.Size(596, 20);
......
471 471
            // 
472 472
            // textBoxNoteSymbolPath
473 473
            // 
474
            this.textBoxNoteSymbolPath.Location = new System.Drawing.Point(184, 169);
474
            this.textBoxNoteSymbolPath.Location = new System.Drawing.Point(184, 172);
475 475
            this.textBoxNoteSymbolPath.MenuManager = this.ribbonControl;
476 476
            this.textBoxNoteSymbolPath.Name = "textBoxNoteSymbolPath";
477 477
            this.textBoxNoteSymbolPath.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
483 483
            // 
484 484
            // textBoxTextSymbolPath
485 485
            // 
486
            this.textBoxTextSymbolPath.Location = new System.Drawing.Point(184, 145);
486
            this.textBoxTextSymbolPath.Location = new System.Drawing.Point(184, 148);
487 487
            this.textBoxTextSymbolPath.MenuManager = this.ribbonControl;
488 488
            this.textBoxTextSymbolPath.Name = "textBoxTextSymbolPath";
489 489
            this.textBoxTextSymbolPath.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
495 495
            // 
496 496
            // textBoxLineNumberPath
497 497
            // 
498
            this.textBoxLineNumberPath.Location = new System.Drawing.Point(208, 78);
498
            this.textBoxLineNumberPath.Location = new System.Drawing.Point(208, 79);
499 499
            this.textBoxLineNumberPath.MenuManager = this.ribbonControl;
500 500
            this.textBoxLineNumberPath.Name = "textBoxLineNumberPath";
501 501
            this.textBoxLineNumberPath.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
508 508
            // 
509 509
            // gridControlLineNumber
510 510
            // 
511
            this.gridControlLineNumber.Location = new System.Drawing.Point(36, 102);
511
            this.gridControlLineNumber.Location = new System.Drawing.Point(36, 103);
512 512
            this.gridControlLineNumber.MainView = this.gridViewLineNumber;
513 513
            this.gridControlLineNumber.MenuManager = this.ribbonControl;
514 514
            this.gridControlLineNumber.Name = "gridControlLineNumber";
515
            this.gridControlLineNumber.Size = new System.Drawing.Size(744, 614);
515
            this.gridControlLineNumber.Size = new System.Drawing.Size(744, 608);
516 516
            this.gridControlLineNumber.TabIndex = 21;
517 517
            this.gridControlLineNumber.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
518 518
            this.gridViewLineNumber});
......
527 527
            // btnClose
528 528
            // 
529 529
            this.btnClose.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnClose.ImageOptions.SvgImage")));
530
            this.btnClose.Location = new System.Drawing.Point(1037, 744);
530
            this.btnClose.Location = new System.Drawing.Point(1037, 739);
531 531
            this.btnClose.Name = "btnClose";
532 532
            this.btnClose.Size = new System.Drawing.Size(86, 36);
533 533
            this.btnClose.StyleController = this.layoutControl1;
......
537 537
            // 
538 538
            // gridControlAttribute
539 539
            // 
540
            this.gridControlAttribute.Location = new System.Drawing.Point(36, 78);
540
            this.gridControlAttribute.Location = new System.Drawing.Point(36, 79);
541 541
            this.gridControlAttribute.MainView = this.gridViewAttribute;
542 542
            this.gridControlAttribute.MenuManager = this.ribbonControl;
543 543
            this.gridControlAttribute.Name = "gridControlAttribute";
544
            this.gridControlAttribute.Size = new System.Drawing.Size(744, 413);
544
            this.gridControlAttribute.Size = new System.Drawing.Size(744, 408);
545 545
            this.gridControlAttribute.TabIndex = 19;
546 546
            this.gridControlAttribute.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
547 547
            this.gridViewAttribute});
......
555 555
            // 
556 556
            // gridControlLine
557 557
            // 
558
            this.gridControlLine.Location = new System.Drawing.Point(36, 78);
558
            this.gridControlLine.Location = new System.Drawing.Point(36, 79);
559 559
            this.gridControlLine.MainView = this.gridViewLine;
560 560
            this.gridControlLine.MenuManager = this.ribbonControl;
561 561
            this.gridControlLine.Name = "gridControlLine";
562
            this.gridControlLine.Size = new System.Drawing.Size(744, 638);
562
            this.gridControlLine.Size = new System.Drawing.Size(744, 632);
563 563
            this.gridControlLine.TabIndex = 18;
564 564
            this.gridControlLine.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
565 565
            this.gridViewLine});
......
573 573
            // 
574 574
            // gridControlSymbol
575 575
            // 
576
            this.gridControlSymbol.Location = new System.Drawing.Point(36, 78);
576
            this.gridControlSymbol.Location = new System.Drawing.Point(36, 79);
577 577
            this.gridControlSymbol.MainView = this.gridViewSymbol;
578 578
            this.gridControlSymbol.MenuManager = this.ribbonControl;
579 579
            this.gridControlSymbol.Name = "gridControlSymbol";
580
            this.gridControlSymbol.Size = new System.Drawing.Size(744, 280);
580
            this.gridControlSymbol.Size = new System.Drawing.Size(744, 276);
581 581
            this.gridControlSymbol.TabIndex = 16;
582 582
            this.gridControlSymbol.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
583 583
            this.gridViewSymbol});
......
593 593
            // 
594 594
            // pictureEditSPPIDSymbol
595 595
            // 
596
            this.pictureEditSPPIDSymbol.Location = new System.Drawing.Point(837, 328);
596
            this.pictureEditSPPIDSymbol.Location = new System.Drawing.Point(842, 334);
597 597
            this.pictureEditSPPIDSymbol.MenuManager = this.ribbonControl;
598 598
            this.pictureEditSPPIDSymbol.Name = "pictureEditSPPIDSymbol";
599 599
            this.pictureEditSPPIDSymbol.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;
600 600
            this.pictureEditSPPIDSymbol.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;
601
            this.pictureEditSPPIDSymbol.Size = new System.Drawing.Size(262, 220);
601
            this.pictureEditSPPIDSymbol.Size = new System.Drawing.Size(257, 217);
602 602
            this.pictureEditSPPIDSymbol.StyleController = this.layoutControl1;
603 603
            this.pictureEditSPPIDSymbol.TabIndex = 15;
604 604
            // 
605 605
            // btnSave
606 606
            // 
607 607
            this.btnSave.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnSave.ImageOptions.SvgImage")));
608
            this.btnSave.Location = new System.Drawing.Point(934, 744);
608
            this.btnSave.Location = new System.Drawing.Point(934, 739);
609 609
            this.btnSave.Name = "btnSave";
610 610
            this.btnSave.Size = new System.Drawing.Size(84, 36);
611 611
            this.btnSave.StyleController = this.layoutControl1;
......
616 616
            // treeListSPPIDTreeList
617 617
            // 
618 618
            this.treeListSPPIDTreeList.Cursor = System.Windows.Forms.Cursors.Default;
619
            this.treeListSPPIDTreeList.Location = new System.Drawing.Point(825, 43);
619
            this.treeListSPPIDTreeList.Location = new System.Drawing.Point(830, 45);
620 620
            this.treeListSPPIDTreeList.Name = "treeListSPPIDTreeList";
621 621
            this.treeListSPPIDTreeList.OptionsView.ShowAutoFilterRow = true;
622
            this.treeListSPPIDTreeList.Size = new System.Drawing.Size(286, 245);
622
            this.treeListSPPIDTreeList.Size = new System.Drawing.Size(281, 242);
623 623
            this.treeListSPPIDTreeList.TabIndex = 12;
624 624
            this.treeListSPPIDTreeList.FocusedNodeChanged += new DevExpress.XtraTreeList.FocusedNodeChangedEventHandler(this.treeListSPPIDTreeList_FocusedNodeChanged);
625 625
            this.treeListSPPIDTreeList.DoubleClick += new System.EventHandler(this.treeListSPPIDTreeList_DoubleClick);
626 626
            // 
627 627
            // pictureEditID2Symbol
628 628
            // 
629
            this.pictureEditID2Symbol.Location = new System.Drawing.Point(36, 410);
629
            this.pictureEditID2Symbol.Location = new System.Drawing.Point(36, 414);
630 630
            this.pictureEditID2Symbol.MenuManager = this.ribbonControl;
631 631
            this.pictureEditID2Symbol.Name = "pictureEditID2Symbol";
632 632
            this.pictureEditID2Symbol.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;
633 633
            this.pictureEditID2Symbol.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;
634
            this.pictureEditID2Symbol.Size = new System.Drawing.Size(354, 306);
634
            this.pictureEditID2Symbol.Size = new System.Drawing.Size(354, 297);
635 635
            this.pictureEditID2Symbol.StyleController = this.layoutControl1;
636 636
            this.pictureEditID2Symbol.TabIndex = 4;
637 637
            // 
638 638
            // pictureEditMapped
639 639
            // 
640
            this.pictureEditMapped.Location = new System.Drawing.Point(423, 410);
640
            this.pictureEditMapped.Location = new System.Drawing.Point(428, 414);
641 641
            this.pictureEditMapped.MenuManager = this.ribbonControl;
642 642
            this.pictureEditMapped.Name = "pictureEditMapped";
643 643
            this.pictureEditMapped.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;
644 644
            this.pictureEditMapped.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;
645
            this.pictureEditMapped.Size = new System.Drawing.Size(357, 306);
645
            this.pictureEditMapped.Size = new System.Drawing.Size(352, 297);
646 646
            this.pictureEditMapped.StyleController = this.layoutControl1;
647 647
            this.pictureEditMapped.TabIndex = 5;
648 648
            // 
649 649
            // checkEditSnapGrid
650 650
            // 
651 651
            this.checkEditSnapGrid.EditValue = true;
652
            this.checkEditSnapGrid.Location = new System.Drawing.Point(36, 78);
652
            this.checkEditSnapGrid.Location = new System.Drawing.Point(36, 79);
653 653
            this.checkEditSnapGrid.MenuManager = this.ribbonControl;
654 654
            this.checkEditSnapGrid.Name = "checkEditSnapGrid";
655 655
            this.checkEditSnapGrid.Properties.Caption = "Use Snap Grid";
656
            this.checkEditSnapGrid.Size = new System.Drawing.Size(744, 19);
656
            this.checkEditSnapGrid.Size = new System.Drawing.Size(744, 18);
657 657
            this.checkEditSnapGrid.StyleController = this.layoutControl1;
658 658
            this.checkEditSnapGrid.TabIndex = 31;
659 659
            this.checkEditSnapGrid.CheckedChanged += new System.EventHandler(this.checkEditSnapGrid_CheckedChanged);
660 660
            // 
661 661
            // textBoxFlowMarkSymbolPath
662 662
            // 
663
            this.textBoxFlowMarkSymbolPath.Location = new System.Drawing.Point(184, 236);
663
            this.textBoxFlowMarkSymbolPath.Location = new System.Drawing.Point(184, 241);
664 664
            this.textBoxFlowMarkSymbolPath.MenuManager = this.ribbonControl;
665 665
            this.textBoxFlowMarkSymbolPath.Name = "textBoxFlowMarkSymbolPath";
666 666
            this.textBoxFlowMarkSymbolPath.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
672 672
            // 
673 673
            // btnBorder
674 674
            // 
675
            this.btnBorder.Location = new System.Drawing.Point(184, 78);
675
            this.btnBorder.Location = new System.Drawing.Point(184, 79);
676 676
            this.btnBorder.MenuManager = this.ribbonControl;
677 677
            this.btnBorder.Name = "btnBorder";
678 678
            this.btnBorder.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
......
695 695
            this.layoutControlItem4,
696 696
            this.emptySpaceItem1});
697 697
            this.Root.Name = "Root";
698
            this.Root.Size = new System.Drawing.Size(1135, 792);
698
            this.Root.Size = new System.Drawing.Size(1135, 787);
699 699
            this.Root.TextVisible = false;
700 700
            // 
701 701
            // layoutControlGroup2
......
708 708
            this.layoutControlItem25,
709 709
            this.layoutControlItem26,
710 710
            this.layoutControlItem27});
711
            this.layoutControlGroup2.Location = new System.Drawing.Point(801, 0);
711
            this.layoutControlGroup2.Location = new System.Drawing.Point(806, 0);
712 712
            this.layoutControlGroup2.Name = "layoutControlGroup2";
713
            this.layoutControlGroup2.Size = new System.Drawing.Size(314, 732);
713
            this.layoutControlGroup2.Size = new System.Drawing.Size(309, 727);
714 714
            this.layoutControlGroup2.Text = "SPPID Symbol";
715 715
            // 
716 716
            // layoutControlItem8
......
718 718
            this.layoutControlItem8.Control = this.treeListSPPIDTreeList;
719 719
            this.layoutControlItem8.Location = new System.Drawing.Point(0, 0);
720 720
            this.layoutControlItem8.Name = "layoutControlItem8";
721
            this.layoutControlItem8.Size = new System.Drawing.Size(290, 249);
721
            this.layoutControlItem8.Size = new System.Drawing.Size(285, 246);
722 722
            this.layoutControlItem8.TextSize = new System.Drawing.Size(0, 0);
723 723
            this.layoutControlItem8.TextVisible = false;
724 724
            // 
......
726 726
            // 
727 727
            this.layoutControlGroup5.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
728 728
            this.layoutControlItem9});
729
            this.layoutControlGroup5.Location = new System.Drawing.Point(0, 254);
729
            this.layoutControlGroup5.Location = new System.Drawing.Point(0, 256);
730 730
            this.layoutControlGroup5.Name = "layoutControlGroup5";
731
            this.layoutControlGroup5.Size = new System.Drawing.Size(290, 267);
731
            this.layoutControlGroup5.Size = new System.Drawing.Size(285, 266);
732 732
            this.layoutControlGroup5.Text = "SPPID Image";
733 733
            // 
734 734
            // layoutControlItem9
......
736 736
            this.layoutControlItem9.Control = this.pictureEditSPPIDSymbol;
737 737
            this.layoutControlItem9.Location = new System.Drawing.Point(0, 0);
738 738
            this.layoutControlItem9.Name = "layoutControlItem9";
739
            this.layoutControlItem9.Size = new System.Drawing.Size(266, 224);
739
            this.layoutControlItem9.Size = new System.Drawing.Size(261, 221);
740 740
            this.layoutControlItem9.TextSize = new System.Drawing.Size(0, 0);
741 741
            this.layoutControlItem9.TextVisible = false;
742 742
            // 
743 743
            // splitterItem5
744 744
            // 
745 745
            this.splitterItem5.AllowHotTrack = true;
746
            this.splitterItem5.Location = new System.Drawing.Point(0, 249);
746
            this.splitterItem5.Location = new System.Drawing.Point(0, 246);
747 747
            this.splitterItem5.Name = "splitterItem5";
748
            this.splitterItem5.Size = new System.Drawing.Size(290, 5);
748
            this.splitterItem5.Size = new System.Drawing.Size(285, 10);
749 749
            // 
750 750
            // layoutControlItem15
751 751
            // 
752 752
            this.layoutControlItem15.Control = this.btnImageRefresh;
753
            this.layoutControlItem15.Location = new System.Drawing.Point(0, 521);
753
            this.layoutControlItem15.Location = new System.Drawing.Point(0, 522);
754 754
            this.layoutControlItem15.Name = "layoutControlItem15";
755
            this.layoutControlItem15.Size = new System.Drawing.Size(290, 42);
755
            this.layoutControlItem15.Size = new System.Drawing.Size(285, 40);
756 756
            this.layoutControlItem15.TextSize = new System.Drawing.Size(0, 0);
757 757
            this.layoutControlItem15.TextVisible = false;
758 758
            // 
759 759
            // layoutControlItem25
760 760
            // 
761 761
            this.layoutControlItem25.Control = this.btnExportExcel;
762
            this.layoutControlItem25.Location = new System.Drawing.Point(0, 563);
762
            this.layoutControlItem25.Location = new System.Drawing.Point(0, 562);
763 763
            this.layoutControlItem25.Name = "layoutControlItem25";
764
            this.layoutControlItem25.Size = new System.Drawing.Size(290, 42);
764
            this.layoutControlItem25.Size = new System.Drawing.Size(285, 40);
765 765
            this.layoutControlItem25.TextSize = new System.Drawing.Size(0, 0);
766 766
            this.layoutControlItem25.TextVisible = false;
767 767
            // 
768 768
            // layoutControlItem26
769 769
            // 
770 770
            this.layoutControlItem26.Control = this.btnExportData;
771
            this.layoutControlItem26.Location = new System.Drawing.Point(0, 605);
771
            this.layoutControlItem26.Location = new System.Drawing.Point(0, 602);
772 772
            this.layoutControlItem26.Name = "layoutControlItem26";
773
            this.layoutControlItem26.Size = new System.Drawing.Size(290, 42);
773
            this.layoutControlItem26.Size = new System.Drawing.Size(285, 40);
774 774
            this.layoutControlItem26.TextSize = new System.Drawing.Size(0, 0);
775 775
            this.layoutControlItem26.TextVisible = false;
776 776
            // 
777 777
            // layoutControlItem27
778 778
            // 
779 779
            this.layoutControlItem27.Control = this.btnImportData;
780
            this.layoutControlItem27.Location = new System.Drawing.Point(0, 647);
780
            this.layoutControlItem27.Location = new System.Drawing.Point(0, 642);
781 781
            this.layoutControlItem27.Name = "layoutControlItem27";
782
            this.layoutControlItem27.Size = new System.Drawing.Size(290, 42);
782
            this.layoutControlItem27.Size = new System.Drawing.Size(285, 40);
783 783
            this.layoutControlItem27.TextSize = new System.Drawing.Size(0, 0);
784 784
            this.layoutControlItem27.TextVisible = false;
785 785
            // 
786 786
            // emptySpaceItem2
787 787
            // 
788 788
            this.emptySpaceItem2.AllowHotTrack = false;
789
            this.emptySpaceItem2.Location = new System.Drawing.Point(0, 732);
789
            this.emptySpaceItem2.Location = new System.Drawing.Point(0, 727);
790 790
            this.emptySpaceItem2.Name = "emptySpaceItem2";
791 791
            this.emptySpaceItem2.Size = new System.Drawing.Size(922, 40);
792 792
            this.emptySpaceItem2.TextSize = new System.Drawing.Size(0, 0);
......
796 796
            this.splitterItem3.AllowHotTrack = true;
797 797
            this.splitterItem3.Location = new System.Drawing.Point(796, 0);
798 798
            this.splitterItem3.Name = "splitterItem3";
799
            this.splitterItem3.Size = new System.Drawing.Size(5, 732);
799
            this.splitterItem3.Size = new System.Drawing.Size(10, 727);
800 800
            // 
801 801
            // tabbedControlGroup
802 802
            // 
803 803
            this.tabbedControlGroup.Location = new System.Drawing.Point(0, 0);
804 804
            this.tabbedControlGroup.Name = "tabbedControlGroup";
805 805
            this.tabbedControlGroup.SelectedTabPage = this.GroupSymbol;
806
            this.tabbedControlGroup.Size = new System.Drawing.Size(796, 732);
806
            this.tabbedControlGroup.Size = new System.Drawing.Size(796, 727);
807 807
            this.tabbedControlGroup.TabPages.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
808 808
            this.GroupSymbol,
809 809
            this.GroupLine,
......
822 822
            this.layoutControlGroup1});
823 823
            this.GroupSymbol.Location = new System.Drawing.Point(0, 0);
824 824
            this.GroupSymbol.Name = "GroupSymbol";
825
            this.GroupSymbol.Size = new System.Drawing.Size(772, 685);
825
            this.GroupSymbol.Size = new System.Drawing.Size(772, 681);
826 826
            this.GroupSymbol.Text = "Symbol";
827 827
            // 
828 828
            // splitterItem1
829 829
            // 
830 830
            this.splitterItem1.AllowHotTrack = true;
831
            this.splitterItem1.Location = new System.Drawing.Point(0, 327);
831
            this.splitterItem1.Location = new System.Drawing.Point(0, 325);
832 832
            this.splitterItem1.Name = "splitterItem1";
833
            this.splitterItem1.Size = new System.Drawing.Size(772, 5);
833
            this.splitterItem1.Size = new System.Drawing.Size(772, 10);
834 834
            // 
835 835
            // layoutControlGroup3
836 836
            // 
837 837
            this.layoutControlGroup3.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
838 838
            this.layoutControlItem1});
839
            this.layoutControlGroup3.Location = new System.Drawing.Point(0, 332);
839
            this.layoutControlGroup3.Location = new System.Drawing.Point(0, 335);
840 840
            this.layoutControlGroup3.Name = "layoutControlGroup3";
841
            this.layoutControlGroup3.Size = new System.Drawing.Size(382, 353);
841
            this.layoutControlGroup3.Size = new System.Drawing.Size(382, 346);
842 842
            this.layoutControlGroup3.Text = "ID2 Image";
843 843
            // 
844 844
            // layoutControlItem1
......
846 846
            this.layoutControlItem1.Control = this.pictureEditID2Symbol;
847 847
            this.layoutControlItem1.Location = new System.Drawing.Point(0, 0);
848 848
            this.layoutControlItem1.Name = "layoutControlItem1";
849
            this.layoutControlItem1.Size = new System.Drawing.Size(358, 310);
849
            this.layoutControlItem1.Size = new System.Drawing.Size(358, 301);
850 850
            this.layoutControlItem1.TextSize = new System.Drawing.Size(0, 0);
851 851
            this.layoutControlItem1.TextVisible = false;
852 852
            // 
......
854 854
            // 
855 855
            this.layoutControlGroup4.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
856 856
            this.layoutControlItem2});
857
            this.layoutControlGroup4.Location = new System.Drawing.Point(387, 332);
857
            this.layoutControlGroup4.Location = new System.Drawing.Point(392, 335);
858 858
            this.layoutControlGroup4.Name = "layoutControlGroup4";
859
            this.layoutControlGroup4.Size = new System.Drawing.Size(385, 353);
859
            this.layoutControlGroup4.Size = new System.Drawing.Size(380, 346);
860 860
            this.layoutControlGroup4.Text = "Mapped Image";
861 861
            // 
862 862
            // layoutControlItem2
......
864 864
            this.layoutControlItem2.Control = this.pictureEditMapped;
865 865
            this.layoutControlItem2.Location = new System.Drawing.Point(0, 0);
866 866
            this.layoutControlItem2.Name = "layoutControlItem2";
867
            this.layoutControlItem2.Size = new System.Drawing.Size(361, 310);
867
            this.layoutControlItem2.Size = new System.Drawing.Size(356, 301);
868 868
            this.layoutControlItem2.TextSize = new System.Drawing.Size(0, 0);
869 869
            this.layoutControlItem2.TextVisible = false;
870 870
            // 
871 871
            // splitterItem4
872 872
            // 
873 873
            this.splitterItem4.AllowHotTrack = true;
874
            this.splitterItem4.Location = new System.Drawing.Point(382, 332);
874
            this.splitterItem4.Location = new System.Drawing.Point(382, 335);
875 875
            this.splitterItem4.Name = "splitterItem4";
876
            this.splitterItem4.Size = new System.Drawing.Size(5, 353);
876
            this.splitterItem4.Size = new System.Drawing.Size(10, 346);
877 877
            // 
878 878
            // layoutControlGroup1
879 879
            // 
......
881 881
            this.layoutControlItem6});
882 882
            this.layoutControlGroup1.Location = new System.Drawing.Point(0, 0);
883 883
            this.layoutControlGroup1.Name = "layoutControlGroup1";
884
            this.layoutControlGroup1.Size = new System.Drawing.Size(772, 327);
884
            this.layoutControlGroup1.Size = new System.Drawing.Size(772, 325);
885 885
            this.layoutControlGroup1.Text = "ID2 Symbol List";
886 886
            // 
887 887
            // layoutControlItem6
......
889 889
            this.layoutControlItem6.Control = this.gridControlSymbol;
890 890
            this.layoutControlItem6.Location = new System.Drawing.Point(0, 0);
891 891
            this.layoutControlItem6.Name = "layoutControlItem6";
892
            this.layoutControlItem6.Size = new System.Drawing.Size(748, 284);
892
            this.layoutControlItem6.Size = new System.Drawing.Size(748, 280);
893 893
            this.layoutControlItem6.TextSize = new System.Drawing.Size(0, 0);
894 894
            this.layoutControlItem6.TextVisible = false;
895 895
            // 
......
899 899
            this.layoutControlGroup6});
900 900
            this.GroupLine.Location = new System.Drawing.Point(0, 0);
901 901
            this.GroupLine.Name = "GroupLine";
902
            this.GroupLine.Size = new System.Drawing.Size(772, 685);
902
            this.GroupLine.Size = new System.Drawing.Size(772, 681);
903 903
            this.GroupLine.Text = "Line";
904 904
            // 
905 905
            // layoutControlGroup6
......
908 908
            this.layoutControlItem10});
909 909
            this.layoutControlGroup6.Location = new System.Drawing.Point(0, 0);
910 910
            this.layoutControlGroup6.Name = "layoutControlGroup6";
911
            this.layoutControlGroup6.Size = new System.Drawing.Size(772, 685);
911
            this.layoutControlGroup6.Size = new System.Drawing.Size(772, 681);
912 912
            this.layoutControlGroup6.Text = "ID2 Line List";
913 913
            // 
914 914
            // layoutControlItem10
......
916 916
            this.layoutControlItem10.Control = this.gridControlLine;
917 917
            this.layoutControlItem10.Location = new System.Drawing.Point(0, 0);
918 918
            this.layoutControlItem10.Name = "layoutControlItem10";
919
            this.layoutControlItem10.Size = new System.Drawing.Size(748, 642);
919
            this.layoutControlItem10.Size = new System.Drawing.Size(748, 636);
920 920
            this.layoutControlItem10.TextSize = new System.Drawing.Size(0, 0);
921 921
            this.layoutControlItem10.TextVisible = false;
922 922
            // 
......
926 926
            this.layoutControlGroup8});
927 927
            this.GroupLineNumber.Location = new System.Drawing.Point(0, 0);
928 928
            this.GroupLineNumber.Name = "GroupLineNumber";
929
            this.GroupLineNumber.Size = new System.Drawing.Size(772, 685);
929
            this.GroupLineNumber.Size = new System.Drawing.Size(772, 681);
930 930
            this.GroupLineNumber.Text = "Line Number";
931 931
            // 
932 932
            // layoutControlGroup8
......
937 937
            this.layoutControlItem18});
938 938
            this.layoutControlGroup8.Location = new System.Drawing.Point(0, 0);
939 939
            this.layoutControlGroup8.Name = "layoutControlGroup8";
940
            this.layoutControlGroup8.Size = new System.Drawing.Size(772, 685);
940
            this.layoutControlGroup8.Size = new System.Drawing.Size(772, 681);
941 941
            this.layoutControlGroup8.Text = "ID2 Line Number";
942 942
            // 
943 943
            // layoutControlItem13
......
945 945
            this.layoutControlItem13.Control = this.gridControlLineNumber;
946 946
            this.layoutControlItem13.Location = new System.Drawing.Point(0, 24);
947 947
            this.layoutControlItem13.Name = "layoutControlItem13";
948
            this.layoutControlItem13.Size = new System.Drawing.Size(748, 618);
948
            this.layoutControlItem13.Size = new System.Drawing.Size(748, 612);
949 949
            this.layoutControlItem13.TextSize = new System.Drawing.Size(0, 0);
950 950
            this.layoutControlItem13.TextVisible = false;
951 951
            // 
......
980 980
            this.layoutControlGroup15});
981 981
            this.GroupAttribute.Location = new System.Drawing.Point(0, 0);
982 982
            this.GroupAttribute.Name = "GroupAttribute";
983
            this.GroupAttribute.Size = new System.Drawing.Size(772, 685);
983
            this.GroupAttribute.Size = new System.Drawing.Size(772, 681);
984 984
            this.GroupAttribute.Text = "Attribute";
985 985
            // 
986 986
            // layoutControlGroup7
......
989 989
            this.layoutControlItem11});
990 990
            this.layoutControlGroup7.Location = new System.Drawing.Point(0, 0);
991 991
            this.layoutControlGroup7.Name = "layoutControlGroup7";
992
            this.layoutControlGroup7.Size = new System.Drawing.Size(772, 460);
992
            this.layoutControlGroup7.Size = new System.Drawing.Size(772, 457);
993 993
            this.layoutControlGroup7.Text = "ID2 Attribute List";
994 994
            // 
995 995
            // layoutControlItem11
......
997 997
            this.layoutControlItem11.Control = this.gridControlAttribute;
998 998
            this.layoutControlItem11.Location = new System.Drawing.Point(0, 0);
999 999
            this.layoutControlItem11.Name = "layoutControlItem11";
1000
            this.layoutControlItem11.Size = new System.Drawing.Size(748, 417);
1000
            this.layoutControlItem11.Size = new System.Drawing.Size(748, 412);
1001 1001
            this.layoutControlItem11.TextSize = new System.Drawing.Size(0, 0);
1002 1002
            this.layoutControlItem11.TextVisible = false;
1003 1003
            // 
1004 1004
            // splitterItem6
1005 1005
            // 
1006 1006
            this.splitterItem6.AllowHotTrack = true;
1007
            this.splitterItem6.Location = new System.Drawing.Point(0, 460);
1007
            this.splitterItem6.Location = new System.Drawing.Point(0, 457);
1008 1008
            this.splitterItem6.Name = "splitterItem6";
1009
            this.splitterItem6.Size = new System.Drawing.Size(772, 5);
1009
            this.splitterItem6.Size = new System.Drawing.Size(772, 10);
1010 1010
            // 
1011 1011
            // layoutControlGroup15
1012 1012
            // 
1013 1013
            this.layoutControlGroup15.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
1014 1014
            this.layoutControlItem30});
1015
            this.layoutControlGroup15.Location = new System.Drawing.Point(0, 465);
1015
            this.layoutControlGroup15.Location = new System.Drawing.Point(0, 467);
1016 1016
            this.layoutControlGroup15.Name = "layoutControlGroup15";
1017
            this.layoutControlGroup15.Size = new System.Drawing.Size(772, 220);
1017
            this.layoutControlGroup15.Size = new System.Drawing.Size(772, 214);
1018 1018
            this.layoutControlGroup15.Text = "ID2 Drawing Attribute List";
1019 1019
            // 
1020 1020
            // layoutControlItem30
......
1022 1022
            this.layoutControlItem30.Control = this.gridControlDrawingAttribute;
1023 1023
            this.layoutControlItem30.Location = new System.Drawing.Point(0, 0);
1024 1024
            this.layoutControlItem30.Name = "layoutControlItem30";
1025
            this.layoutControlItem30.Size = new System.Drawing.Size(748, 177);
1025
            this.layoutControlItem30.Size = new System.Drawing.Size(748, 169);
1026 1026
            this.layoutControlItem30.TextSize = new System.Drawing.Size(0, 0);
1027 1027
            this.layoutControlItem30.TextVisible = false;
1028 1028
            // 
......
1037 1037
            this.layoutControlGroup14});
1038 1038
            this.GroupETCSetting.Location = new System.Drawing.Point(0, 0);
1039 1039
            this.GroupETCSetting.Name = "GroupETCSetting";
1040
            this.GroupETCSetting.Size = new System.Drawing.Size(772, 685);
1040
            this.GroupETCSetting.Size = new System.Drawing.Size(772, 681);
1041 1041
            this.GroupETCSetting.Text = "ETC Setting";
1042 1042
            // 
1043 1043
            // emptySpaceItem3
1044 1044
            // 
1045 1045
            this.emptySpaceItem3.AllowHotTrack = false;
1046
            this.emptySpaceItem3.Location = new System.Drawing.Point(0, 359);
1046
            this.emptySpaceItem3.Location = new System.Drawing.Point(0, 369);
1047 1047
            this.emptySpaceItem3.Name = "emptySpaceItem3";
1048
            this.emptySpaceItem3.Size = new System.Drawing.Size(772, 326);
1048
            this.emptySpaceItem3.Size = new System.Drawing.Size(772, 312);
1049 1049
            this.emptySpaceItem3.TextSize = new System.Drawing.Size(0, 0);
1050 1050
            // 
1051 1051
            // layoutControlGroup9
......
1055 1055
            this.layoutControlItem7,
1056 1056
            this.layoutControlItem16,
1057 1057
            this.layoutControlItem17});
1058
            this.layoutControlGroup9.Location = new System.Drawing.Point(0, 67);
1058
            this.layoutControlGroup9.Location = new System.Drawing.Point(0, 69);
1059 1059
            this.layoutControlGroup9.Name = "layoutControlGroup9";
1060
            this.layoutControlGroup9.Size = new System.Drawing.Size(772, 91);
1060
            this.layoutControlGroup9.Size = new System.Drawing.Size(772, 93);
1061 1061
            this.layoutControlGroup9.Text = "Text && Note Setting";
1062 1062
            // 
1063 1063
            // layoutControlItem5
......
1106 1106
            // 
1107 1107
            this.layoutControlGroup10.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
1108 1108
            this.layoutControlItem14});
1109
            this.layoutControlGroup10.Location = new System.Drawing.Point(0, 225);
1109
            this.layoutControlGroup10.Location = new System.Drawing.Point(0, 231);
1110 1110
            this.layoutControlGroup10.Name = "layoutControlGroup10";
1111
            this.layoutControlGroup10.Size = new System.Drawing.Size(772, 67);
1111
            this.layoutControlGroup10.Size = new System.Drawing.Size(772, 69);
1112 1112
            this.layoutControlGroup10.Text = "Drain Valve Setting";
1113 1113
            this.layoutControlGroup10.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
1114 1114
            // 
......
1125 1125
            // 
1126 1126
            this.layoutControlGroup12.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
1127 1127
            this.layoutControlItem24});
1128
            this.layoutControlGroup12.Location = new System.Drawing.Point(0, 158);
1128
            this.layoutControlGroup12.Location = new System.Drawing.Point(0, 162);
1129 1129
            this.layoutControlGroup12.Name = "layoutControlGroup12";
1130
            this.layoutControlGroup12.Size = new System.Drawing.Size(772, 67);
1130
            this.layoutControlGroup12.Size = new System.Drawing.Size(772, 69);
1131 1131
            this.layoutControlGroup12.Text = "Flow Mark";
1132 1132
            // 
1133 1133
            // layoutControlItem24
......
1143 1143
            // 
1144 1144
            this.layoutControlGroup13.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
1145 1145
            this.layoutControlItem28});
1146
            this.layoutControlGroup13.Location = new System.Drawing.Point(0, 292);
1146
            this.layoutControlGroup13.Location = new System.Drawing.Point(0, 300);
1147 1147
            this.layoutControlGroup13.Name = "layoutControlGroup13";
1148
            this.layoutControlGroup13.Size = new System.Drawing.Size(772, 67);
1148
            this.layoutControlGroup13.Size = new System.Drawing.Size(772, 69);
1149 1149
            this.layoutControlGroup13.Text = "Vendor Package Symbol";
1150 1150
            // 
1151 1151
            // layoutControlItem28
......
1163 1163
            this.layoutControlItem29});
1164 1164
            this.layoutControlGroup14.Location = new System.Drawing.Point(0, 0);
1165 1165
            this.layoutControlGroup14.Name = "layoutControlGroup14";
1166
            this.layoutControlGroup14.Size = new System.Drawing.Size(772, 67);
1166
            this.layoutControlGroup14.Size = new System.Drawing.Size(772, 69);
1167 1167
            this.layoutControlGroup14.Text = "Border Setting";
1168 1168
            // 
1169 1169
            // layoutControlItem29
......
1182 1182
            this.layoutControlGroupSnapGrid});
1183 1183
            this.GroupGridSetting.Location = new System.Drawing.Point(0, 0);
1184 1184
            this.GroupGridSetting.Name = "GroupGridSetting";
1185
            this.GroupGridSetting.Size = new System.Drawing.Size(772, 685);
1185
            this.GroupGridSetting.Size = new System.Drawing.Size(772, 681);
1186 1186
            this.GroupGridSetting.Text = "Grid Setting";
1187 1187
            // 
1188 1188
            // emptySpaceItem4
1189 1189
            // 
1190 1190
            this.emptySpaceItem4.AllowHotTrack = false;
1191
            this.emptySpaceItem4.Location = new System.Drawing.Point(0, 157);
1191
            this.emptySpaceItem4.Location = new System.Drawing.Point(0, 160);
1192 1192
            this.emptySpaceItem4.Name = "emptySpaceItem4";
1193
            this.emptySpaceItem4.Size = new System.Drawing.Size(772, 528);
1193
            this.emptySpaceItem4.Size = new System.Drawing.Size(772, 521);
1194 1194
            this.emptySpaceItem4.TextSize = new System.Drawing.Size(0, 0);
1195 1195
            // 
1196 1196
            // layoutControlGroupSnapGrid
......
1202 1202
            this.layoutControlItem21});
1203 1203
            this.layoutControlGroupSnapGrid.Location = new System.Drawing.Point(0, 0);
1204 1204
            this.layoutControlGroupSnapGrid.Name = "layoutControlGroupSnapGrid";
1205
            this.layoutControlGroupSnapGrid.Size = new System.Drawing.Size(772, 157);
1205
            this.layoutControlGroupSnapGrid.Size = new System.Drawing.Size(772, 160);
1206 1206
            this.layoutControlGroupSnapGrid.Text = "Snap Grid";
1207 1207
            // 
1208 1208
            // layoutControlItem19
......
1210 1210
            this.layoutControlItem19.Control = this.checkEditSnapGrid;
1211 1211
            this.layoutControlItem19.Location = new System.Drawing.Point(0, 0);
1212 1212
            this.layoutControlItem19.Name = "layoutControlItem19";
1213
            this.layoutControlItem19.Size = new System.Drawing.Size(748, 23);
1213
            this.layoutControlItem19.Size = new System.Drawing.Size(748, 22);
1214 1214
            this.layoutControlItem19.TextSize = new System.Drawing.Size(0, 0);
1215 1215
            this.layoutControlItem19.TextVisible = false;
1216 1216
            this.layoutControlItem19.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
......
1218 1218
            // layoutControlItem20
1219 1219
            // 
1220 1220
            this.layoutControlItem20.Control = this.spinEditDensity;
1221
            this.layoutControlItem20.Location = new System.Drawing.Point(0, 23);
1221
            this.layoutControlItem20.Location = new System.Drawing.Point(0, 22);
1222 1222
            this.layoutControlItem20.Name = "layoutControlItem20";
1223 1223
            this.layoutControlItem20.Size = new System.Drawing.Size(373, 24);
1224 1224
            this.layoutControlItem20.Text = "Density";
......
1229 1229
            this.layoutControlGroup11.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
1230 1230
            this.layoutControlItem22,
1231 1231
            this.layoutControlItem23});
1232
            this.layoutControlGroup11.Location = new System.Drawing.Point(0, 47);
1232
            this.layoutControlGroup11.Location = new System.Drawing.Point(0, 46);
1233 1233
            this.layoutControlGroup11.Name = "layoutControlGroup11";
1234
            this.layoutControlGroup11.Size = new System.Drawing.Size(748, 67);
1234
            this.layoutControlGroup11.Size = new System.Drawing.Size(748, 69);
1235 1235
            this.layoutControlGroup11.Text = "Symbol To Symbol Distance Setting";
1236 1236
            // 
1237 1237
            // layoutControlItem22
......
1256 1256
            // layoutControlItem21
1257 1257
            // 
1258 1258
            this.layoutControlItem21.Control = this.comboBoxEditUnit;
1259
            this.layoutControlItem21.Location = new System.Drawing.Point(373, 23);
1259
            this.layoutControlItem21.Location = new System.Drawing.Point(373, 22);
1260 1260
            this.layoutControlItem21.Name = "layoutControlItem21";
1261 1261
            this.layoutControlItem21.Size = new System.Drawing.Size(375, 24);
1262 1262
            this.layoutControlItem21.Text = "Unit";
......
1265 1265
            // layoutControlItem12
1266 1266
            // 
1267 1267
            this.layoutControlItem12.Control = this.btnClose;
1268
            this.layoutControlItem12.Location = new System.Drawing.Point(1025, 732);
1268
            this.layoutControlItem12.Location = new System.Drawing.Point(1025, 727);
1269 1269
            this.layoutControlItem12.MaxSize = new System.Drawing.Size(90, 40);
1270 1270
            this.layoutControlItem12.MinSize = new System.Drawing.Size(90, 40);
1271 1271
            this.layoutControlItem12.Name = "layoutControlItem12";
......
1277 1277
            // layoutControlItem4
1278 1278
            // 
1279 1279
            this.layoutControlItem4.Control = this.btnSave;
1280
            this.layoutControlItem4.Location = new System.Drawing.Point(922, 732);
1280
            this.layoutControlItem4.Location = new System.Drawing.Point(922, 727);
1281 1281
            this.layoutControlItem4.MaxSize = new System.Drawing.Size(88, 40);
1282 1282
            this.layoutControlItem4.MinSize = new System.Drawing.Size(88, 40);
1283 1283
            this.layoutControlItem4.Name = "layoutControlItem4";
......
1289 1289
            // emptySpaceItem1
1290 1290
            // 
1291 1291
            this.emptySpaceItem1.AllowHotTrack = false;
1292
            this.emptySpaceItem1.Location = new System.Drawing.Point(1010, 732);
1292
            this.emptySpaceItem1.Location = new System.Drawing.Point(1010, 727);
1293 1293
            this.emptySpaceItem1.MaxSize = new System.Drawing.Size(15, 40);
1294 1294
            this.emptySpaceItem1.MinSize = new System.Drawing.Size(15, 40);
1295 1295
            this.emptySpaceItem1.Name = "emptySpaceItem1";
DTI_PID/SPPIDConverter/Form/SPPID_DB_SettingForm.cs
36 36
            textBoxPort.Text = info.Port;
37 37
            textBoxDBUser.Text = info.DBUser;
38 38
            textBoxDBPassword.Text = info.DBPassword;
39
            formDBInfo.SQLSERVER_DBNAME = info.SQLSERVER_DBNAME;
39 40
            comboPlant.Properties.Items.Clear();
40 41
            comboPlant.Properties.Items.AddRange(info.PlantList);
41 42

  
......
48 49
                    break;
49 50
                }
50 51
            }
52

  
53
            if (info.DBType.Equals("ORACLE"))
54
            {
55
                layoutControlItem5.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
56
                layoutControlItem6.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
57
            }
58
            else if (info.DBType.Equals("SQLSERVER"))
59
            {
60
                layoutControlItem5.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
61
                layoutControlItem6.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
62
            }
51 63
        }
52 64

  
53 65
        private void btnLoadINIFile_Click(object sender, EventArgs e)
......
58 70
                string sDBTYPE = string.Empty;
59 71
                string sSERVICENAME = string.Empty;
60 72
                string sUID = string.Empty;
61

  
73
                string sSQLSERVER_DBNAME = string.Empty;
62 74
                try
63 75
                {
64 76
                    string[] texts = File.ReadAllLines(path);
......
78 90
                                sSERVICENAME = text.Remove(0, "DBSERVER=".Length);
79 91
                            else if (text.StartsWith("UID=") && string.IsNullOrEmpty(sUID))
80 92
                                sUID = text.Remove(0, "UID=".Length);
93
                            else if (text.StartsWith("SQLSERVER_DBNAME=") && string.IsNullOrEmpty(sSQLSERVER_DBNAME))
94
                                sSQLSERVER_DBNAME = text.Remove(0, "SQLSERVER_DBNAME=".Length);
81 95
                        }
82 96
                    }
83 97
                }
......
85 99
                {
86 100

  
87 101
                }
88
                if (string.IsNullOrEmpty(sDBTYPE) || string.IsNullOrEmpty(sSERVICENAME) || string.IsNullOrEmpty(sUID))
102

  
103
                if (sDBTYPE.Equals("ORACLE") && !string.IsNullOrEmpty(sSERVICENAME) && !string.IsNullOrEmpty(sUID))
104
                {
105
                    textBoxDBType.Text = sDBTYPE;
106
                    textBoxServiceName.Text = sSERVICENAME;
107
                    textBoxSiteName.Text = sUID;
108
                }
109
                else if (sDBTYPE.Equals("SQLSERVER") && !string.IsNullOrEmpty(sSERVICENAME) && !string.IsNullOrEmpty(sUID) && !string.IsNullOrEmpty(sSQLSERVER_DBNAME))
110
                {
111
                    textBoxDBType.Text = sDBTYPE;
112
                    textBoxServiceName.Text = sSERVICENAME;
113
                    textBoxSiteName.Text = sUID;
114
                    formDBInfo.SQLSERVER_DBNAME = sSQLSERVER_DBNAME;
115
                }
116
                else
89 117
                {
90 118
                    textBoxDBType.Text = "";
91 119
                    textBoxServiceName.Text = "";
92 120
                    textBoxSiteName.Text = "";
93 121
                    MessageBox.Show(Msg.FailLoadiniFile, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);
94 122
                }
95
                else
123

  
124
                if (sDBTYPE.Equals("ORACLE"))
96 125
                {
97
                    textBoxDBType.Text = sDBTYPE;
98
                    textBoxServiceName.Text = sSERVICENAME;
99
                    textBoxSiteName.Text = sUID;
126
                    layoutControlItem5.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
127
                    layoutControlItem6.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
128
                }
129
                else if (sDBTYPE.Equals("SQLSERVER"))
130
                {
131
                    layoutControlItem5.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
132
                    layoutControlItem6.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
100 133
                }
101 134

  
102 135
            }
DTI_PID/SPPIDConverter/Util/SPPIDUtil.cs
48 48
                _SPPIDInfo.Enable = jsonSPPIDInfo.Enable;
49 49
                _SPPIDInfo.SelectedPlant = jsonSPPIDInfo.SelectedPlant;
50 50
                _SPPIDInfo.PlantList = jsonSPPIDInfo.PlantList;
51
                _SPPIDInfo.SQLSERVER_DBNAME = jsonSPPIDInfo.SQLSERVER_DBNAME;
51 52

  
52 53
            }
53 54
            catch (Exception ex)

내보내기 Unified diff

클립보드 이미지 추가 (최대 크기: 500 MB)