프로젝트

일반

사용자정보

개정판 5dfc785c

ID5dfc785c94cb338eddb3b65cd24491c5f1c40d7a
상위 9d3c79b7
하위 ce86b7e6

이지연이(가) 3년 이상 전에 추가함

issue #000: Psn Sqlite Table DataType 수정, Save 확인

Change-Id: I1b913e96caf7140ac25c3bd8493b260eee4b6dea

차이점 보기:

DTI_PID/ID2PSN/DB.cs
17 17 
        const string PSN_TOPOLOGY_RULE = "T_PSN_TOPOLOGY_RULE";
18 18 
        const string PSN_HEADER_SETTING = "T_PSN_HEADER_SETTING";
19 19 
        const string PSN_VENTDRAIN_SETTING = "T_PSN_VENTDRAIN_SETTING";
20 
        const string PSN_VIEW = "T_PSN_VIEW";
21 

  		




  20
  22
  
    
        const string PSN_PATHITEMS = "SPPIDPathItem";


  		




  21
  23
  
    
        const string PSN_SEQUENCEDATA = "SPPIDSequenceData";


  		




  22
  24
  
    
        const string PSN_PIPESYSTEMNETWORK = "SPPIDPipeSystemNetwork";


  		




  23
  25
  
    
        const string PSN_EQUIPMENT = "SPPIDEquipment";


  		




  24
  26
  
    
        const string PSN_NOZZLE = "SPPIDNozzle";


  		




  25
  27
  
    
        const string PSN_FLUIDCODE = "SPPIDFluidCode";


  		




  26
  
  
    
        const string PSN_PIPINGMATLCLASS = "SPPIDPipingMatClass";


  		




  27
  
  
    
        const string PSN_VIEW = "T_PSN_VIEW";


  		




  
  28
  
    
        const string PSN_PIPINGMATLCLASS = "SPPIDPipingMatClass";       


  		




  28
  29
  
    
        const string PSN_TOPOLOGYSET = "SPPIDTopologySet";


  		




  29
  30
  
    

  		




  30
  31
  
    
        /// <summary>


  		




  ......




  153
  154
  
    
                                }


  		




  154
  155
  
    
                                if (dt.Select(string.Format("NAME = '{0}'", PSN_PATHITEMS)).Length == 0)


  		




  155
  156
  
    
                                {


  		




  156
  
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID TEXT, SequenceData_OID TEXT, TopologySet_OID TEXT, BranchTopologySet_OID TEXT, PipeLine_OID TEXT, ITEMNAME TEXT, ITEMTAG TEXT, Class TEXT, SubClass TEXT, TYPE TEXT, PIDNAME TEXT, NPD TEXT, PipeSystemNetwork_OID TEXT, ViewPipeSystemNetwork_OID TEXT, PipeRun_OID TEXT)", PSN_PATHITEMS);


  		




  
  157
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID NVARCHAR(50), SequenceData_OID NVARCHAR(125), " +


  		




  
  158
  
    
                                        "TopologySet_OID NVARCHAR(125), BranchTopologySet_OID NVARCHAR(125), PipeLine_OID NVARCHAR(125), ITEMNAME NVARCHAR(50), ITEMTAG NVARCHAR(125), " +


  		




  
  159
  
    
                                        "Class NVARCHAR(80), SubClass NVARCHAR(80), TYPE NVARCHAR(80), PIDNAME NVARCHAR(10), NPD NVARCHAR(20), PipeSystemNetwork_OID NVARCHAR(20), " +


  		




  
  160
  
    
                                        "ViewPipeSystemNetwork_OID NVARCHAR(255), PipeRun_OID NVARCHAR(255))", PSN_PATHITEMS);


  		




  157
  161
  
    
                                    cmd.ExecuteNonQuery();


  		




  158
  162
  
    
                                }


  		




  159
  163
  
    
                                if (dt.Select(string.Format("NAME = '{0}'", PSN_SEQUENCEDATA)).Length == 0)


  		




  160
  164
  
    
                                {


  		




  161
  
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID TEXT, SERIALNUMBER TEXT, PathItem_OID TEXT, TopologySet_OID_Key TEXT)", PSN_SEQUENCEDATA);


  		




  
  165
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID NVARCHAR(125), SERIALNUMBER NVARCHAR(10), PathItem_OID NVARCHAR(50), TopologySet_OID_Key NVARCHAR(125))", PSN_SEQUENCEDATA);


  		




  162
  166
  
    
                                    cmd.ExecuteNonQuery();


  		




  163
  167
  
    
                                }


  		




  164
  168
  
    
                                if (dt.Select(string.Format("NAME = '{0}'", PSN_PIPESYSTEMNETWORK)).Length == 0)


  		




  165
  169
  
    
                                {


  		




  166
  
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID TEXT, Type TEXT, OrderNumber TEXT, Pipeline_OID TEXT, FROM_DATA TEXT, TO_DATA TEXT, TopologySet_OID_Key TEXT, PSNRevisionNumber TEXT, PBS TEXT, PIDDrawings TEXT, Validity TEXT, Status TEXT)", PSN_PIPESYSTEMNETWORK);


  		




  
  170
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID NVARCHAR(50), Type NVARCHAR(20), OrderNumber NVARCHAR(20), Pipeline_OID NVARCHAR(125), FROM_DATA NVARCHAR(255), " +


  		




  
  171
  
    
                                        "TO_DATA NVARCHAR(255), TopologySet_OID_Key NVARCHAR(125), PSNRevisionNumber NVARCHAR(255), PBS NVARCHAR(255), PIDDrawings NVARCHAR(255), " +


  		




  
  172
  
    
                                        "Validity INTEGER, Status NVARCHAR(255))", PSN_PIPESYSTEMNETWORK);


  		




  167
  173
  
    
                                    cmd.ExecuteNonQuery();


  		




  168
  174
  
    
                                }


  		




  169
  175
  
    
                                if (dt.Select(string.Format("NAME = '{0}'", PSN_EQUIPMENT)).Length == 0)


  		




  170
  176
  
    
                                {


  		




  171
  
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID TEXT, ITEMTAG TEXT, XCOORDS TEXT, YCOORDS TEXT)", PSN_EQUIPMENT);


  		




  
  177
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID NVARCHAR(50), ITEMTAG NVARCHAR(50), XCOORDS REAL, YCOORDS REAL)", PSN_EQUIPMENT);


  		




  172
  178
  
    
                                    cmd.ExecuteNonQuery();


  		




  173
  179
  
    
                                }


  		




  174
  180
  
    
                                if (dt.Select(string.Format("NAME = '{0}'", PSN_NOZZLE)).Length == 0)


  		




  175
  181
  
    
                                {


  		




  176
  
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID TEXT, ITEMTAG TEXT, XCOORDS TEXT, YCOORDS TEXT, Equipment_OID TEXT, FLUID TEXT, NPD TEXT, ROTATION TEXT, FlowDirection TEXT)", PSN_NOZZLE);


  		




  
  182
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID NVARCHAR(50), ITEMTAG NVARCHAR(50), XCOORDS REAL, YCOORDS REAL, Equipment_OID NVARCHAR(50), " +


  		




  
  183
  
    
                                        "FLUID NVARCHAR(50), NPD NVARCHAR(20), ROTATION REAL, FlowDirection NVARCHAR(10))", PSN_NOZZLE);


  		




  177
  184
  
    
                                    cmd.ExecuteNonQuery();


  		




  178
  185
  
    
                                }


  		




  179
  186
  
    
                                if (dt.Select(string.Format("NAME = '{0}'", PSN_FLUIDCODE)).Length == 0)


  		




  180
  187
  
    
                                {


  		




  181
  
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (UID TEXT, Code TEXT, Description TEXT, Condition TEXT, Remarks TEXT, GroundLevel TEXT)", PSN_FLUIDCODE);


  		




  
  188
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (UID NVARCHAR(50), Code NVARCHAR(50), Description NVARCHAR(255), Condition NVARCHAR(50), Remarks NVARCHAR(255), GroundLevel NVARCHAR(50))", PSN_FLUIDCODE);


  		




  182
  189
  
    
                                    cmd.ExecuteNonQuery();


  		




  183
  190
  
    
                                }


  		




  184
  191
  
    
                                if (dt.Select(string.Format("NAME = '{0}'", PSN_PIPINGMATLCLASS)).Length == 0)


  		




  185
  192
  
    
                                {


  		




  186
  
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (UID TEXT, Priority TEXT, Code TEXT, Description TEXT, Condition TEXT, Remarks TEXT, GroundLevel TEXT)", PSN_PIPINGMATLCLASS);


  		




  
  193
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (UID NVARCHAR(50), Priority INTEGER, Code NVARCHAR(255), Description NVARCHAR(50), Condition NVARCHAR(255), Remarks NVARCHAR(80), GroundLevel NVARCHAR(50))", PSN_PIPINGMATLCLASS);


  		




  187
  194
  
    
                                    cmd.ExecuteNonQuery();


  		




  188
  195
  
    
                                }


  		




  189
  196
  
    
                                if (dt.Select(string.Format("NAME = '{0}'", PSN_VIEW)).Length == 0)


  		




  ......




  193
  200
  
    
                                }


  		




  194
  201
  
    
                                if (dt.Select(string.Format("NAME = '{0}'", PSN_TOPOLOGYSET)).Length == 0)


  		




  195
  202
  
    
                                {


  		




  196
  
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID TEXT, Type TEXT, SubType TEXT, HeadItemTag TEXT, TailItemTag TEXT, HeadItemID TEXT, TailItemID TEXT)", PSN_TOPOLOGYSET);


  		




  
  203
  
    
                                    cmd.CommandText = string.Format("CREATE TABLE {0} (OID NVARCHAR(125), Type NVARCHAR(30), SubType NVARCHAR(30), HeadItemTag NVARCHAR(50), TailItemTag NVARCHAR(50), HeadItemID NVARCHAR(50), TailItemID NVARCHAR(50))", PSN_TOPOLOGYSET);


  		




  197
  204
  
    
                                    cmd.ExecuteNonQuery();


  		




  198
  205
  
    
                                }


  		




  199
  206
  
    
                            }


  		












  

    
      DTI_PID/ID2PSN/PSN.cs
    
  





  7
  7
  
    
using System.Threading.Tasks;


  		




  8
  8
  
    
using ID2PSN.Properties;


  		




  9
  9
  
    
using System.Text.RegularExpressions;


  		




  
  10
  
    
using System.Windows.Forms;


  		




  10
  11
  
    

  		




  11
  12
  
    
namespace ID2PSN


  		




  12
  13
  
    
{


  		




  ......




  42
  43
  
    
        DataTable opcDT = null;


  		




  43
  44
  
    
        DataTable topologyRuleDT = null;


  		




  44
  45
  
    

  		




  
  46
  
    
        ID2Info id2Info = ID2Info.GetInstance();


  		




  
  47
  
    

  		




  45
  48
  
    
        const string FluidPriorityType = "FLUIDCODE";


  		




  46
  49
  
    
        const string PipingMaterialsPriorityType = "PIPINGMATERIALSCLASS";


  		




  47
  50
  
    

  		




  ......




  52
  55
  
    

  		




  53
  56
  
    
        public PSN(List<Document> documents, int Revision)


  		




  54
  57
  
    
        {


  		




  55
  
  
    
            Documents = documents;


  		




  56
  
  
    
            foreach (Document document in Documents)


  		




  57
  
  
    
                groups.AddRange(document.Groups);


  		




  58
  
  
    
            opcDT = GetOPCInfo();


  		




  59
  
  
    
            topologyRuleDT = GetTopologyRule();


  		




  60
  
  
    
            this.Revision = Revision;


  		




  61
  
  
    
            DrawingSize = DB.GetDrawingSize();


  		




  62
  
  
    
            DrawingWidth = DrawingSize[2] - DrawingSize[0];


  		




  63
  
  
    
            DrawingHeight = DrawingSize[3] - DrawingSize[1];


  		




  
  58
  
    
            try


  		




  
  59
  
    
            {


  		




  
  60
  
    
                Documents = documents;


  		




  
  61
  
    
                foreach (Document document in Documents)


  		




  
  62
  
    
                    groups.AddRange(document.Groups);


  		




  
  63
  
    
                opcDT = GetOPCInfo();


  		




  
  64
  
    
                topologyRuleDT = GetTopologyRule();


  		




  
  65
  
    
                this.Revision = Revision;


  		




  
  66
  
    
                DrawingSize = DB.GetDrawingSize();


  		




  
  67
  
    
                if (DrawingSize == null)


  		




  
  68
  
    
                {


  		




  
  69
  
    
                    MessageBox.Show("There is no data whose Section is Area and Key is Drawing in the drawing table.", "ID2 " + id2Info.ProgramName, MessageBoxButtons.OK, MessageBoxIcon.Information);


  		




  
  70
  
    
                    return;


  		




  
  71
  
    
                }


  		




  
  72
  
    
                DrawingWidth = DrawingSize[2] - DrawingSize[0];


  		




  
  73
  
    
                DrawingHeight = DrawingSize[3] - DrawingSize[1];


  		




  
  74
  
    
            }


  		




  
  75
  
    
            catch (Exception ex)


  		




  
  76
  
    
            {


  		




  
  77
  
    
                Log.Write(ex.Message + "\r\n" + ex.StackTrace);


  		




  
  78
  
    
                MessageBox.Show(ex.Message, "ID2 " + id2Info.ProgramName, MessageBoxButtons.OK, MessageBoxIcon.Information);


  		




  
  79
  
    
            }


  		




  64
  80
  
    
        }


  		




  65
  81
  
    

  		




  66
  82
  
    
        private string GetItemTag(Item item)


  		












  

    
      DTI_PID/ID2PSN/Program.cs
    
  





  37
  37
  
    
                //info.DefaultPath = @"E:\DOFTECH\10.PSN\SampleProject_규호";


  		




  38
  38
  
    
                //info.DefaultPath = @"D:\Projects\dd\21100497014_REB";


  		




  39
  39
  
    
                args = new string[1];


  		




  40
  
  
    
                 //args[0] = @"E:\DOFTECH\10.PSN\REB☆■☆PSN";


  		




  41
  
  
    
                


  		




  42
  
  
    
                args[0] = @"Z:\ID2_Project\REB☆■☆PSN";


  		




  
  40
  
    
                //args[0] = @"E:\DOFTECH\10.PSN\REB☆■☆PSN";


  		




  
  41
  
    

  		




  
  42
  
    
                //args[0] = @"Z:\ID2_Project\REB☆■☆PSN";


  		




  
  43
  
    
                args[0] = @"E:\DOFTECH\10.PSN\SampleProject_규호☆■☆PSN"; 


  		




  43
  44
  
    
#endif


  		




  44
  45
  
    

  		




  45
  46
  
    
                if (args.Length > 0)


  		












내보내기  Unified diff