프로젝트

일반

사용자정보

개정판 90ae20f6

ID90ae20f6305463624ba5979d365fa00023c96704
상위 7573f758
하위 5369929f, 4f493cbd

유성호이(가) 약 2년 전에 추가함

issue #0000
Document 정보 변경 진행

Change-Id: Ib7725c09fcf935e25e35a601f803599bb0c11c14

차이점 보기:

ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs
15 15 
        public IEnumerable<Documents> GetAllDocuments()
16 16 
        {
17 17 
            string query = $@"
18 
select   doc.Seq
19 
        ,doc.DocumentNo
20 
        ,rev.ProcNo
21 
        ,rev.RevNo
22 
        ,rev.PhysicalPath
23 
        ,rev.VirtualPath
24 
        ,doc.JobLevel
25 
        ,doc.Typical
26 
        ,doc.PersonInCharge
27 
        ,rev.Created
28 
        ,toreview.IsDiscussion
29 
        ,toreview.Remarks ToRemarks
30 
        ,toreview.Capture ToCapture
31 
        ,toreview.MarkupLink ToMarkupLink
32 
        ,isnull(toreview.ModifiedUser,toreview.CreatedUser) ToUserID
33 
        ,frreview.ReviewStatus
34 
        ,frreview.Remarks FrRemarks
35 
        ,frreview.Capture FrCapture
36 
        ,frreview.MarkupLink FrMarkupLink
37 
        ,isnull(frreview.ModifiedUser,frreview.CreatedUser) FromUserID
18 
select   doc.*
38 19 
from     dbo.Documents doc
39 
             inner join dbo.DocRevisions rev on doc.Seq=rev.RefDocSeq
40 
		     left outer join dbo.ToReview toreview on rev.ProcNo=toreview.RefProcNo
41 
		     left outer join dbo.FromReview frreview on rev.ProcNo=frreview.RefProcNo
42 
where    doc.IsDeleted=0 and  rev.IsLatest=1
43 
order by doc.DocumentNo, rev.ProcNo desc";
20 
order by doc.Seq";
44 21 

  		




  45
  22
  
    
            return Query<Documents>(query);


  		




  46
  23
  
    
        }


  		












  

    
      ID2.Manager/ID2.Manager.Data/Models/Documents.cs
    
  





  14
  14
  
    
        [DataMember]


  		




  15
  15
  
    
        public int Seq { get; set; }


  		




  16
  16
  
    
        [DataMember]


  		




  
  17
  
    
        public string DocID { get; set; }


  		




  
  18
  
    
        [DataMember]


  		




  17
  19
  
    
        public string DocumentNo { get; set; }


  		




  18
  20
  
    
        [DataMember]


  		




  19
  
  
    
        public int ProcNo { get; set; }


  		




  
  21
  
    
        public string RevisonNo { get; set; }


  		




  
  22
  
    
        [DataMember]


  		




  
  23
  
    
        public string ProjectID { get; set; }


  		




  20
  24
  
    
        [DataMember]


  		




  21
  
  
    
        public string RevNo { get; set; }


  		




  
  25
  
    
        public bool IsLatest { get; set; }


  		




  22
  26
  
    
        [DataMember]


  		




  23
  
  
    
        public string PhysicalPath { get; set; }


  		




  
  27
  
    
        public string DocFilePath { get; set; }


  		




  24
  28
  
    
        [DataMember]


  		




  25
  
  
    
        public string VirtualPath { get; set; }


  		




  
  29
  
    
        public string DocFileName { get; set; }


  		




  
  30
  
    
        [DataMember]


  		




  
  31
  
    
        public string Place { get; set; }


  		




  26
  32
  
    
        [DataMember]


  		




  27
  33
  
    
        public string JobLevel { get; set; }


  		




  28
  34
  
    
        [DataMember]


  		




  29
  
  
    
        public string Typical { get; set; }


  		




  
  35
  
    
        public bool Typical { get; set; }


  		




  30
  36
  
    
        [DataMember]


  		




  31
  37
  
    
        public string PersonInCharge { get; set; }


  		




  32
  38
  
    
        [DataMember]


  		




  33
  
  
    
        public DateTime Created { get; set; }


  		




  
  39
  
    
        public bool IsDeleted { get; set; }


  		




  
  40
  
    
        [DataMember]


  		




  
  41
  
    
        public DateTime RegisteredDate { get; set; }


  		




  34
  42
  
    
        [DataMember]


  		




  35
  
  
    
        public bool IsDiscussion { get; set; }


  		




  
  43
  
    
        public DateTime ModifiedDate { get; set; }


  		




  
  44
  
    
        [DataMember]


  		




  
  45
  
    
        public DateTime DeletedDate { get; set; }


  		




  
  46
  
    
        [DataMember]


  		




  
  47
  
    
        public bool ToIsDiscussion { get; set; }


  		




  36
  48
  
    
        [DataMember]


  		




  37
  49
  
    
        public string ToRemarks { get; set; }


  		




  38
  50
  
    
        [DataMember]


  		




  39
  
  
    
        public string ToCapture { get; set; }


  		




  
  51
  
    
        public string ToCreator { get; set; }


  		




  40
  52
  
    
        [DataMember]


  		




  41
  
  
    
        public string ToMarkupLink { get; set; }


  		




  
  53
  
    
        public string ToModifier { get; set; }


  		




  42
  54
  
    
        [DataMember]


  		




  43
  
  
    
        public string ToUserID { get; set; }


  		




  
  55
  
    
        public string ToCapturePath { get; set; }


  		




  44
  56
  
    
        [DataMember]


  		




  45
  
  
    
        public string ReviewStatus { get; set; }


  		




  
  57
  
    
        public bool ToIsMarkup { get; set; }


  		




  
  58
  
    
        [DataMember]


  		




  
  59
  
    
        public string FrReviewStatus { get; set; }


  		




  46
  60
  
    
        [DataMember]


  		




  47
  61
  
    
        public string FrRemarks { get; set; }


  		




  48
  62
  
    
        [DataMember]


  		




  49
  
  
    
        public string FrCapture { get; set; }


  		




  
  63
  
    
        public string FrCreator { get; set; }


  		




  
  64
  
    
        [DataMember]


  		




  
  65
  
    
        public string FrModifier { get; set; }


  		




  
  66
  
    
        [DataMember]


  		




  
  67
  
    
        public string FrCapturePath { get; set; }


  		




  
  68
  
    
        [DataMember]


  		




  
  69
  
    
        public bool FrIsMarkup { get; set; }


  		




  
  70
  
    
        [DataMember]


  		




  
  71
  
    
        public bool IsID2Work { get; set; }


  		




  
  72
  
    
        [DataMember]


  		




  
  73
  
    
        public string ID2Connection { get; set; }


  		




  
  74
  
    
        [DataMember]


  		




  
  75
  
    
        public DateTime ID2StartDate { get; set; }


  		




  
  76
  
    
        [DataMember]


  		




  
  77
  
    
        public DateTime ID2EndDate { get; set; }


  		




  
  78
  
    
        [DataMember]


  		




  
  79
  
    
        public int ID2JobTime { get; set; }


  		




  
  80
  
    
        [DataMember]


  		




  
  81
  
    
        public string ID2Status { get; set; }


  		




  
  82
  
    
        [DataMember]


  		




  
  83
  
    
        public string ID2Issues { get; set; }


  		




  
  84
  
    
        [DataMember]


  		




  
  85
  
    
        public string AVEVAConnection { get; set; }


  		




  
  86
  
    
        [DataMember]


  		




  
  87
  
    
        public DateTime AVEVAConvertDate { get; set; }


  		




  
  88
  
    
        [DataMember]


  		




  
  89
  
    
        public DateTime AVEVAReviewDate { get; set; }


  		




  
  90
  
    
        [DataMember]


  		




  
  91
  
    
        public string AVEVAStatus { get; set; }


  		




  
  92
  
    
        [DataMember]


  		




  
  93
  
    
        public string AVEVAIssues { get; set; }


  		




  
  94
  
    
        [DataMember]


  		




  
  95
  
    
        public string ReviewFilePath { get; set; }


  		




  
  96
  
    
        [DataMember]


  		




  
  97
  
    
        public string ReviewFileName { get; set; }


  		




  
  98
  
    
        [DataMember]


  		




  
  99
  
    
        public string ProdReviewer { get; set; }


  		




  
  100
  
    
        [DataMember]


  		




  
  101
  
    
        public bool ProdIsResult { get; set; }


  		




  
  102
  
    
        [DataMember]


  		




  
  103
  
    
        public string ProdRemarks { get; set; }


  		




  
  104
  
    
        [DataMember]


  		




  
  105
  
    
        public string ClientReviewer { get; set; }


  		




  
  106
  
    
        [DataMember]


  		




  
  107
  
    
        public bool ClientIsResult { get; set; }


  		




  
  108
  
    
        [DataMember]


  		




  
  109
  
    
        public string ClientRemarks { get; set; }


  		




  
  110
  
    
        [DataMember]


  		




  
  111
  
    
        public string DWGateWay { get; set; }


  		




  
  112
  
    
        [DataMember]


  		




  
  113
  
    
        public bool DWIsImport { get; set; }


  		




  50
  114
  
    
        [DataMember]


  		




  51
  
  
    
        public string FrMarkupLink { get; set; }


  		




  
  115
  
    
        public string DWRegSystem { get; set; }


  		




  52
  116
  
    
        [DataMember]


  		




  53
  
  
    
        public string FromUserID { get; set; }


  		




  
  117
  
    
        public string DWRemarks { get; set; }


  		




  54
  118
  
    
    }


  		




  55
  119
  
    
}


  		












  

    
      ID2.Manager/ID2.Manager/Main.Designer.cs
    
  





  29
  29
  
    
        /// </summary>


  		




  30
  30
  
    
        private void InitializeComponent()


  		




  31
  31
  
    
        {


  		




  
  32
  
    
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn1 = new Telerik.WinControls.UI.GridViewTextBoxColumn();


  		




  
  33
  
    
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn2 = new Telerik.WinControls.UI.GridViewTextBoxColumn();


  		




  
  34
  
    
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn1 = new Telerik.WinControls.UI.GridViewComboBoxColumn();


  		




  
  35
  
    
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn2 = new Telerik.WinControls.UI.GridViewComboBoxColumn();


  		




  
  36
  
    
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn3 = new Telerik.WinControls.UI.GridViewTextBoxColumn();


  		




  32
  37
  
    
            Telerik.WinControls.UI.TableViewDefinition tableViewDefinition1 = new Telerik.WinControls.UI.TableViewDefinition();


  		




  33
  38
  
    
            this.ID2ManagerRadRibbonBar = new Telerik.WinControls.UI.RadRibbonBar();


  		




  34
  39
  
    
            this.radSplitContainerWrap = new Telerik.WinControls.UI.RadSplitContainer();


  		




  35
  40
  
    
            this.splitPanelLeft = new Telerik.WinControls.UI.SplitPanel();


  		




  36
  
  
    
            this.splitPanelRight = new Telerik.WinControls.UI.SplitPanel();


  		




  37
  41
  
    
            this.radGridViewDocuments = new Telerik.WinControls.UI.RadGridView();


  		




  
  42
  
    
            this.splitPanelRight = new Telerik.WinControls.UI.SplitPanel();


  		




  38
  43
  
    
            ((System.ComponentModel.ISupportInitialize)(this.ID2ManagerRadRibbonBar)).BeginInit();


  		




  39
  44
  
    
            ((System.ComponentModel.ISupportInitialize)(this.radSplitContainerWrap)).BeginInit();


  		




  40
  45
  
    
            this.radSplitContainerWrap.SuspendLayout();


  		




  41
  46
  
    
            ((System.ComponentModel.ISupportInitialize)(this.splitPanelLeft)).BeginInit();


  		




  42
  47
  
    
            this.splitPanelLeft.SuspendLayout();


  		




  43
  
  
    
            ((System.ComponentModel.ISupportInitialize)(this.splitPanelRight)).BeginInit();


  		




  44
  48
  
    
            ((System.ComponentModel.ISupportInitialize)(this.radGridViewDocuments)).BeginInit();


  		




  45
  49
  
    
            ((System.ComponentModel.ISupportInitialize)(this.radGridViewDocuments.MasterTemplate)).BeginInit();


  		




  
  50
  
    
            ((System.ComponentModel.ISupportInitialize)(this.splitPanelRight)).BeginInit();


  		




  46
  51
  
    
            ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();


  		




  47
  52
  
    
            this.SuspendLayout();


  		




  48
  53
  
    
            // 


  		




  ......




  85
  90
  
    
            this.splitPanelLeft.TabIndex = 0;


  		




  86
  91
  
    
            this.splitPanelLeft.TabStop = false;


  		




  87
  92
  
    
            // 


  		




  88
  
  
    
            // splitPanelRight


  		




  89
  
  
    
            // 


  		




  90
  
  
    
            this.splitPanelRight.Location = new System.Drawing.Point(896, 0);


  		




  91
  
  
    
            this.splitPanelRight.Name = "splitPanelRight";


  		




  92
  
  
    
            // 


  		




  93
  
  
    
            // 


  		




  94
  
  
    
            // 


  		




  95
  
  
    
            this.splitPanelRight.RootElement.MinSize = new System.Drawing.Size(25, 25);


  		




  96
  
  
    
            this.splitPanelRight.Size = new System.Drawing.Size(289, 566);


  		




  97
  
  
    
            this.splitPanelRight.SizeInfo.AutoSizeScale = new System.Drawing.SizeF(-0.2552921F, 0F);


  		




  98
  
  
    
            this.splitPanelRight.SizeInfo.SplitterCorrection = new System.Drawing.Size(-302, 0);


  		




  99
  
  
    
            this.splitPanelRight.TabIndex = 1;


  		




  100
  
  
    
            this.splitPanelRight.TabStop = false;


  		




  101
  
  
    
            // 


  		




  102
  93
  
    
            // radGridViewDocuments


  		




  103
  94
  
    
            // 


  		




  
  95
  
    
            this.radGridViewDocuments.AutoScroll = true;


  		




  104
  96
  
    
            this.radGridViewDocuments.Dock = System.Windows.Forms.DockStyle.Fill;


  		




  105
  97
  
    
            this.radGridViewDocuments.Location = new System.Drawing.Point(0, 0);


  		




  106
  98
  
    
            // 


  		




  107
  99
  
    
            // 


  		




  108
  100
  
    
            // 


  		




  109
  101
  
    
            this.radGridViewDocuments.MasterTemplate.AllowSearchRow = true;


  		




  
  102
  
    
            this.radGridViewDocuments.MasterTemplate.AutoGenerateColumns = false;


  		




  110
  103
  
    
            this.radGridViewDocuments.MasterTemplate.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;


  		




  
  104
  
    
            gridViewTextBoxColumn1.FieldName = "DocumentNo";


  		




  
  105
  
    
            gridViewTextBoxColumn1.HeaderText = "이름";


  		




  
  106
  
    
            gridViewTextBoxColumn1.Name = "DocumentNo";


  		




  
  107
  
    
            gridViewTextBoxColumn1.Width = 70;


  		




  
  108
  
    
            gridViewTextBoxColumn2.FieldName = "PersonInCharge";


  		




  
  109
  
    
            gridViewTextBoxColumn2.HeaderText = "담당자";


  		




  
  110
  
    
            gridViewTextBoxColumn2.Name = "PersonInCharge";


  		




  
  111
  
    
            gridViewTextBoxColumn2.Width = 308;


  		




  
  112
  
    
            gridViewComboBoxColumn1.FieldName = "JobLevel";


  		




  
  113
  
    
            gridViewComboBoxColumn1.HeaderText = "난이도";


  		




  
  114
  
    
            gridViewComboBoxColumn1.Name = "JobLevel";


  		




  
  115
  
    
            gridViewComboBoxColumn1.Width = 344;


  		




  
  116
  
    
            gridViewComboBoxColumn2.FieldName = "Typical";


  		




  
  117
  
    
            gridViewComboBoxColumn2.HeaderText = "Typical";


  		




  
  118
  
    
            gridViewComboBoxColumn2.Name = "Typical";


  		




  
  119
  
    
            gridViewComboBoxColumn2.Width = 89;


  		




  
  120
  
    
            gridViewTextBoxColumn3.FieldName = "RevisonNo";


  		




  
  121
  
    
            gridViewTextBoxColumn3.HeaderText = "Rev.";


  		




  
  122
  
    
            gridViewTextBoxColumn3.Name = "RevisonNo";


  		




  
  123
  
    
            gridViewTextBoxColumn3.Width = 64;


  		




  
  124
  
    
            this.radGridViewDocuments.MasterTemplate.Columns.AddRange(new Telerik.WinControls.UI.GridViewDataColumn[] {


  		




  
  125
  
    
            gridViewTextBoxColumn1,


  		




  
  126
  
    
            gridViewTextBoxColumn2,


  		




  
  127
  
    
            gridViewComboBoxColumn1,


  		




  
  128
  
    
            gridViewComboBoxColumn2,


  		




  
  129
  
    
            gridViewTextBoxColumn3});


  		




  111
  130
  
    
            this.radGridViewDocuments.MasterTemplate.EnableAlternatingRowColor = true;


  		




  112
  131
  
    
            this.radGridViewDocuments.MasterTemplate.EnableFiltering = true;


  		




  113
  132
  
    
            this.radGridViewDocuments.MasterTemplate.ShowFilteringRow = false;


  		




  ......




  118
  137
  
    
            this.radGridViewDocuments.Size = new System.Drawing.Size(892, 566);


  		




  119
  138
  
    
            this.radGridViewDocuments.TabIndex = 0;


  		




  120
  139
  
    
            // 


  		




  
  140
  
    
            // splitPanelRight


  		




  
  141
  
    
            // 


  		




  
  142
  
    
            this.splitPanelRight.Location = new System.Drawing.Point(896, 0);


  		




  
  143
  
    
            this.splitPanelRight.Name = "splitPanelRight";


  		




  
  144
  
    
            // 


  		




  
  145
  
    
            // 


  		




  
  146
  
    
            // 


  		




  
  147
  
    
            this.splitPanelRight.RootElement.MinSize = new System.Drawing.Size(25, 25);


  		




  
  148
  
    
            this.splitPanelRight.Size = new System.Drawing.Size(289, 566);


  		




  
  149
  
    
            this.splitPanelRight.SizeInfo.AutoSizeScale = new System.Drawing.SizeF(-0.2552921F, 0F);


  		




  
  150
  
    
            this.splitPanelRight.SizeInfo.SplitterCorrection = new System.Drawing.Size(-302, 0);


  		




  
  151
  
    
            this.splitPanelRight.TabIndex = 1;


  		




  
  152
  
    
            this.splitPanelRight.TabStop = false;


  		




  
  153
  
    
            // 


  		




  121
  154
  
    
            // Main


  		




  122
  155
  
    
            // 


  		




  123
  156
  
    
            this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);


  		




  ......




  134
  167
  
    
            this.radSplitContainerWrap.ResumeLayout(false);


  		




  135
  168
  
    
            ((System.ComponentModel.ISupportInitialize)(this.splitPanelLeft)).EndInit();


  		




  136
  169
  
    
            this.splitPanelLeft.ResumeLayout(false);


  		




  137
  
  
    
            ((System.ComponentModel.ISupportInitialize)(this.splitPanelRight)).EndInit();


  		




  138
  170
  
    
            ((System.ComponentModel.ISupportInitialize)(this.radGridViewDocuments.MasterTemplate)).EndInit();


  		




  139
  171
  
    
            ((System.ComponentModel.ISupportInitialize)(this.radGridViewDocuments)).EndInit();


  		




  
  172
  
    
            ((System.ComponentModel.ISupportInitialize)(this.splitPanelRight)).EndInit();


  		




  140
  173
  
    
            ((System.ComponentModel.ISupportInitialize)(this)).EndInit();


  		




  141
  174
  
    
            this.ResumeLayout(false);


  		




  142
  175
  
    
            this.PerformLayout();


  		












내보내기  Unified diff