/ - Diff - HYTOS - 일정관리

                         using (SQLiteCommand cmd = connection.CreateCommand())
+                        {
                             cmd.CommandText = string.Format(@"
                                 SELECT s.UID, s.Name, st.Type, sp.SPPID_SYMBOL_PATH FROM {1} as st, {0} as s
                                 SELECT sp.UID, s.Name, st.Type, sp.SPPID_SYMBOL_PATH FROM {1} as st, {0} as s
                                     LEFT OUTER JOIN {2} as sp
                                         ON s.UID = SP.UID
                                 WHERE s.SymbolType_UID = st.UID
-...
                 return dt;
+            }
             public static DataTable SelectProjectChildSymbol()
+            {
                 DataTable result = new DataTable();
                 result.Columns.Add("UID");
                 result.Columns.Add("Name");
                 result.Columns.Add("Type");
                 result.Columns.Add("SPPID_SYMBOL_PATH");
                 Project_Info projectInfo = Project_Info.GetInstance();
                 using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))
                 using (DataTable dt = new DataTable())
+                {
                     try
+                    {
                         connection.Open();
                         using (SQLiteCommand cmd = connection.CreateCommand())
+                        {
                             cmd.CommandText = string.Format(@"
                                 SELECT AdditionalSymbol FROM Symbol");
                             using (SQLiteDataReader dr = cmd.ExecuteReader())
                                 dt.Load(dr);
                             List<string> childList = new List<string>();
                             foreach (DataRow row in dt.Rows)
+                            {
                                 if (!string.IsNullOrEmpty((string)row["AdditionalSymbol"]))
+                                {
                                     string[] array = row["AdditionalSymbol"].ToString().Split(new char[] { '/' });
                                     foreach (var childString in array)
+                                    {
                                         childList.Add(childString.Split(new char[] { ',' })[2]);
+                                    }
+                                }
+                            }
                             dt.Clear();
                             cmd.Reset();
                             cmd.CommandText = string.Format(@"
                                 SELECT * FROM {0}", SPPID_SYMBOL_MAPPING_TABLE);
                             using (SQLiteDataReader dr = cmd.ExecuteReader())
                                 dt.Load(dr);
                             childList = childList.Distinct().ToList();
                             foreach (var child in childList)
+                            {
                                 string mappingPath = string.Empty;
                                 DataRow[] rows = dt.Select(string.Format("UID = '{0}'", child));
                                 if (rows.Length == 1)
                                     mappingPath = !DBNull.Value.Equals(rows[0]["SPPID_SYMBOL_PATH"]) ? (string)rows[0]["SPPID_SYMBOL_PATH"] : null;
                                 DataRow newRow = result.NewRow();
                                 newRow["UID"] = child;
                                 newRow["Name"] = child;
                                 newRow["Type"] = "Child Symbol";
                                 newRow["SPPID_SYMBOL_PATH"] = mappingPath;
                                 result.Rows.Add(newRow);
+                            }
+                        }
                         connection.Close();
+                    }
                     catch (Exception ex)
+                    {
+                    }
                     finally
+                    {
                         connection.Dispose();
+                    }
+                }
                 return result;
+            }
             public static DataTable SelectProjectLine()
+            {
                 DataTable dt = new DataTable();

                     _LMSymbol.Commit();
                     symbol.SPPID.RepresentationId = _LMSymbol.AsLMRepresentation().Id;
                     //foreach (var item in symbol.ChildSymbols)
                     //    CreateChildSymbol(item, _LMSymbol, x, y);
                     foreach (var item in symbol.ChildSymbols)
                         CreateChildSymbol(item, _LMSymbol);
+                }
                 ReleaseCOMObjects(_LMSymbol);
+            }
             private void CreateChildSymbol(ChildSymbol childSymbol, LMSymbol parentSymbol, double x, double y)
             private void CreateChildSymbol(ChildSymbol childSymbol, LMSymbol parentSymbol)
+            {
                 LMSymbol _LMSymbol = _placement.PIDPlaceSymbol(childSymbol.SPPID.MAPPINGNAME, x, y, TargetItem: parentSymbol);
                 foreach (var item in childSymbol.ChildSymbols)
                     CreateChildSymbol(item, _LMSymbol, x, y);
                 Ingr.RAD2D.Symbol2d symbol2d = radApp.ActiveDocument.ActiveSheet.DrawingObjects[parentSymbol.get_GraphicOID().ToString()];
                 double x1 = 0;
                 double x2 = 0;
                 double y1 = 0;
                 double y2 = 0;
                 symbol2d.Range(out x1, out y1, out x2, out y2);
                 LMSymbol _LMSymbol = _placement.PIDPlaceSymbol(childSymbol.SPPID.MAPPINGNAME, (x1 + x2) / 2, (y1 + y2) / 2, TargetItem: parentSymbol);
                 if (_LMSymbol != null)
+                {
                     childSymbol.SPPID.RepresentationId = _LMSymbol.AsLMRepresentation().Id;
                     foreach (var item in childSymbol.ChildSymbols)
                         CreateChildSymbol(item, _LMSymbol);
+                }
                 ReleaseCOMObjects(_LMSymbol);
+            }

             private DataTable _ID2SymbolDT = new DataTable();
             private DataTable _ID2ChildSymbolDT = new DataTable();
             private DataTable _ID2LineDT = new DataTable();
             private DataTable _ID2AttributeDT = new DataTable();
             private DataTable _ID2LinePropertyDT = new DataTable();
-...
             private List<SymbolMapping> symbolMappings = new List<SymbolMapping>();
             private List<ChildSymbolMapping> childSymbolMappings = new List<ChildSymbolMapping>();
             private List<LineMapping> lineMappings = new List<LineMapping>();
             private List<LineNumberMapping> lineNumberMappings = new List<LineNumberMapping>();
             private List<AttributeMapping> attributeMappings = new List<AttributeMapping>();
-...
                             SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),
                         });
+                    }
                     MergeID2ChildSymbol();
+                }
+            }
             private void MergeID2ChildSymbol()
+            {
                 using (DataTable childSymbolDT = Project_DB.SelectProjectChildSymbol())
+                {
                     childSymbolMappings.Clear();
                     _ID2ChildSymbolDT = childSymbolDT;
                     _ID2ChildSymbolDT.Columns.Add("Clear");
                     _ID2ChildSymbolDT.Columns["Clear"].Caption = "";
                     foreach (DataRow row in childSymbolDT.Rows)
+                    {
                         childSymbolMappings.Add(new ChildSymbolMapping()
+                        {
                             UID = row["UID"] == null ? "" : row["UID"].ToString(),
                             SYMBOLNAME = row["Name"] == null ? "" : row["Name"].ToString(),
                             SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),
                         });
+                    }
                     _ID2SymbolDT.Merge(_ID2ChildSymbolDT);
+                }
+            }
-...
                 //SPPID_Document document = new SPPID_Document(@"Z:\HanKyouHo\temp\Isocynates\Temp\zIsocynates-325_Page75.xml");
                 SPPID_Document document = new SPPID_Document(@"Z:\HanKyouHo\temp\Isocynates\Temp\Isocynates-325_Page49.xml");
                 document.SymbolMappings = symbolMappings;
                 document.ChildSymbolMappings = childSymbolMappings;
                 document.LineMappings = lineMappings;
                 document.LineNumberMappings = lineNumberMappings;
                 document.AttributeMappings = attributeMappings;

DTI_PID/SPPIDConverter/Form/MappingForm.Designer.cs
327	327	this.gridViewSymbol.Name = "gridViewSymbol";
328	328	this.gridViewSymbol.OptionsBehavior.ReadOnly = true;
329	329	this.gridViewSymbol.OptionsCustomization.AllowGroup = false;
	330	this.gridViewSymbol.OptionsView.ShowAutoFilterRow = true;
330	331	this.gridViewSymbol.OptionsView.ShowGroupPanel = false;
331	332	this.gridViewSymbol.ShowingEditor += new System.ComponentModel.CancelEventHandler(this.gridView_ShowingEditor);
332	333	//

DTI_PID/SPPIDConverter/Form/MappingForm.cs
65	65	this.lineDT = lineDT;
66	66	this.linePropertyDT = linePropertyDT;
67	67	this.associationDT = associationDT;
	68
68	69	InitID2GridView();
69	70	InitSPPIDSymbolTree();
70	71	InitETCSetting();

     using System;
     using System.Collections.Generic;
     using System.Linq;
     using System.Text;
     using System.Threading.Tasks;
     namespace Converter.SPPID.Model
+    {
         public class ChildSymbolMapping
+        {
             private string _UID;
             private string _SYMBOLNAME;
             private string _SPPIDSYMBOLNAME;
             public string UID { get => _UID; set => _UID = value; }
             public string SYMBOLNAME { get => _SYMBOLNAME; set => _SYMBOLNAME = value; }
             public string SPPIDSYMBOLNAME { get => _SPPIDSYMBOLNAME; set => _SPPIDSYMBOLNAME = value; }
+        }
+    }

             private double testY = 0.55;
             public List<SymbolMapping> SymbolMappings;
             public List<ChildSymbolMapping> ChildSymbolMappings;
             public List<LineMapping> LineMappings;
             public List<LineNumberMapping> LineNumberMappings;
             public List<AttributeMapping> AttributeMappings;
-...
             public string Unit { get; set; }
             public string Template { get; set; }
             public void SetSPPIDInfo()
+            {
                 foreach (var item in SYMBOLS)
-...
                     SPPIDUtil.ConvertSPPIDPoint(ref x, ref y, SIZE_WIDTH, SIZE_HEIGHT, testX, testY);
                     item.SPPID.ORIGINAL_X = x;
                     item.SPPID.ORIGINAL_Y = y;
                     foreach (var childSymbol in item.ChildSymbols)
+                    {
                         if (childSymbol.SPPID == null)
                             childSymbol.SPPID = new SPPIDSymbolInfo();
                         SetChildSymbolSPPIDInfo(childSymbol);
+                    }
+                }
                 foreach (var item in LINES)
-...
                     item.SPPID.ORIGINAL_Y = y;
+                }
+            }
             private void SetChildSymbolSPPIDInfo(ChildSymbol item)
+            {
                 foreach (var childSymbol in item.ChildSymbols)
+                {
                     if (childSymbol.SPPID == null)
                         childSymbol.SPPID = new SPPIDSymbolInfo();
                     SetChildSymbolSPPIDInfo(childSymbol);
+                }
+            }
             public bool SetSPPIDMapping()
+            {
                 foreach (var item in SYMBOLS)
-...
                     item.SPPID.MAPPINGNAME = mapping != null ? mapping.SPPIDSYMBOLNAME : null;
                     if (string.IsNullOrEmpty(item.SPPID.MAPPINGNAME))
                         return false;
                     foreach (var childSymbol in item.ChildSymbols)
+                    {
                         ChildSymbolMapping childMapping = ChildSymbolMappings.Find(x => x.UID == childSymbol.NAME);
                         childSymbol.SPPID.MAPPINGNAME = childMapping != null ? childMapping.SPPIDSYMBOLNAME : null;
                         if (string.IsNullOrEmpty(childSymbol.SPPID.MAPPINGNAME) || !SetChildSymbolMapping(childSymbol))
                             return false;
+                    }
+                }
                 foreach (var item in LINES)
-...
                     if (string.IsNullOrEmpty(item.SPPID.MAPPINGNAME))
                         return false;
+                }
                 return true;
+            }
             private bool SetChildSymbolMapping(ChildSymbol item)
+            {
                 foreach (var childSymbol in item.ChildSymbols)
+                {
                     ChildSymbolMapping childMapping = ChildSymbolMappings.Find(x => x.UID == childSymbol.NAME);
                     childSymbol.SPPID.MAPPINGNAME = childMapping != null ? childMapping.SPPIDSYMBOLNAME : null;
                     if (string.IsNullOrEmpty(childSymbol.SPPID.MAPPINGNAME))
                         return false;
                     else
                         return SetChildSymbolMapping(childSymbol);
+                }
                 return true;
+            }
             #region Grouping Source
             private bool SetGrouping()
+            {

DTI_PID/SPPIDConverter/SPPIDConverter.csproj
146	146	<Compile Include="Model\SPPID_Document.cs" />
147	147	<Compile Include="Model\LineMapping.cs" />
148	148	<Compile Include="Model\AttributeMapping.cs" />
	149	<Compile Include="Model\ChildSymbolMapping.cs" />
149	150	<Compile Include="Model\SymbolMapping.cs" />
150	151	<Compile Include="Program.cs" />
151	152	<Compile Include="Properties\AssemblyInfo.cs" />

ID	4b4dbca9d12f023aab8a8921ea996cabe5e2e371
상위	ac78b508
하위	7c990804, a30d7077

프로젝트

일반

사용자정보

HYTOS

개정판 4b4dbca9