프로젝트

일반

사용자정보

개정판 709c1971

ID709c19717f0efb8717c92cbfba084066de838ff3
상위 482f6326
하위 cd8502c2

유성호이(가) 일년 이상 전에 추가함

issue #0000
전체 유저 리스트 추가
문서 저장/수정/삭제 추가 진행

Change-Id: I828d95f415d5d360bfc039625eb7aa42fd4135c2

차이점 보기:

ID2.Manager/ID2.Manager.Common/Informations.cs
27 27

  
28 28
        public UserInfo ActiveUser { get; set; }
29 29

  
30
        public List<UserInfo> UserList { get; set; } = new List<UserInfo>();
31

  
30 32
        private readonly List<string> _JobLevel = new List<string>() { "1", "2", "3", "4", "5" };
31 33
        public List<string> JobLevel
32 34
        {
ID2.Manager/ID2.Manager.Controller/Controllers/DocumentController.cs
18 18
                return rep.GetAllDocuments();
19 19
            }
20 20
        }
21

  
22
        public bool SetDocumentData(List<Documents> docList, List<Documents> delDocList)
23
        {
24
            using (DocumentRepository rep = new DocumentRepository(this._DbConnectionStr))
25
            {
26
                return rep.SetDocumentData(docList, delDocList);
27
            }
28
        }
21 29
    }
22 30
}
ID2.Manager/ID2.Manager.Controller/Controllers/UserController.cs
11 11
{
12 12
    public class UserController : BaseController
13 13
    {
14
        public IEnumerable<UserInfo> GetAllUserInfo()
15
        {
16
            using (UserRepository rep = new UserRepository(this._DbConnectionStr))
17
            {
18
                return rep.GetAllUserInfo();
19
            }
20
        }
21

  
14 22
        public UserInfo GetUserInfo(string userId, string userPW)
15 23
        {
16 24
            using (UserRepository rep = new UserRepository(this._DbConnectionStr))
ID2.Manager/ID2.Manager.Dapper/Repository/BaseRepository.cs
95 95
            return await this._DbConnection.QueryAsync<T>(sql, param);
96 96
        }
97 97

  
98
        public int Execute(string query, IDbTransaction dbTran)
99
        {
100
            if (this._DbConnection.State != ConnectionState.Open)
101
            {
102
                this._DbConnection.Open();
103
            }
104

  
105
            return this._DbConnection.Execute(query, dbTran);
106
        }
107

  
98 108
        public int Execute(string query, object param, IDbTransaction dbTran)
99 109
        {
100 110
            if (this._DbConnection.State != ConnectionState.Open)
ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs
22 22
            return Query<Documents>(query);
23 23
        }
24 24

  
25
        public bool SetDocumentData(List<Documents> docList)
25
        public bool SetDocumentData(List<Documents> docList, List<Documents> delDocList)
26 26
        {
27 27
            bool isSuccess = false;
28 28

  
......
30 30
            {
31 31
                using (var transaction = base._DbConnection.BeginTransaction())
32 32
                {
33
                    var param = new
33
                    string query = string.Empty;
34

  
35
                    if (delDocList.Count > 0)
34 36
                    {
35
                        Cases_UID = ""
36
                    };
37
                    string query = @"
38
delete dbo.Documents where Cases_UID=@Cases_UID";
39
                    base.Execute(query, param, transaction);
37
                        string docIDList = string.Join("','", delDocList.Where(x => !string.IsNullOrEmpty(x.DocID)).Select(x => x.DocID).ToList());
38

  
39
                        if (docIDList.Length > 0)
40
                        {
41
                            query = $@"delete from dbo.Documents where Cases_UID=@Cases_UID and [DocID] in ('{docIDList}');";
42
                            base.Execute(query, transaction);
43
                        }
44
                    }
40 45

  
41 46
                    foreach (Documents doc in docList)
42 47
                    {
......
111 116
    ,@IsTypical
112 117
    ,@PersonInCharge
113 118
    ,@IsDeleted
114
    ,@RegisteredDate
119
    ,getdate()
115 120
    ,@ModifiedDate
116 121
    ,@DeletedDate
117 122
    ,@ToIsDiscussion
......
150 155
    ,@DTIsImport
151 156
    ,@DTIsRegSystem
152 157
    ,@DTRemarks
153
)";
158
);";
154 159
                        }
155 160
                        else
156 161
                        {
......
206 211
      ,[DTIsImport]
207 212
      ,[DTIsRegSystem]
208 213
      ,[DTRemarks]
209
where  [DocID]=@DocID
210
";
214
where  [DocID]=@DocID;";
211 215
                        }
212 216
                        base.Execute(query, doc, transaction);
213 217
                    }
ID2.Manager/ID2.Manager.Dapper/Repository/UserRepository.cs
12 12
    {
13 13
        public UserRepository(string connectionStr) : base(connectionStr) {}
14 14

  
15
        public IEnumerable<UserInfo> GetAllUserInfo()
16
        {
17
            string query = $@"select * from dbo.Users order by [Name]";
18

  
19
            return Query<UserInfo>(query);
20
        }
21

  
15 22
        public UserInfo GetUserInfo(string userId, string userPW)
16 23
        {
17 24
            string query = $@"
ID2.Manager/ID2.Manager.Data/Models/Documents.cs
9 9
namespace ID2.Manager.Data.Models
10 10
{
11 11
    [DataContract]
12
    public class Documents
12
    public class Documents : IEquatable<Documents>
13 13
    {
14 14
        [DataMember]
15 15
        public int Seq { get; set; }
......
123 123
        public string DTIsRegSystem { get; set; }
124 124
        [DataMember]
125 125
        public string DTRemarks { get; set; }
126

  
127
        public override bool Equals(object obj)
128
        {
129
            return Equals(obj as Documents);
130
        }
131

  
132
        public bool Equals(Documents other)
133
        {
134
            return other != null && this.DocumentNo == other.DocumentNo && this.RevisonNo == other.RevisonNo && this.ProjectID == other.ProjectID && this.IsLatest == other.IsLatest 
135
                && this.AutoCADFilie == other.AutoCADFilie && this.PDFFile == other.PDFFile && this.MarkupLink == other.MarkupLink && this.AVEVALink == other.AVEVALink
136
                && this.DocFilePath == other.DocFilePath && this.DocFileName == other.DocFileName && this.Place == other.Place && this.JobLevel == other.JobLevel && this.IsTypical == other.IsTypical
137
                && this.PersonInCharge == other.PersonInCharge && this.IsDeleted == other.IsDeleted && this.ToIsDiscussion == other.ToIsDiscussion && this.ToRemarks == other.ToRemarks
138
                && this.ToCreator == other.ToCreator && this.ToModifier == other.ToModifier && this.ToCapturePath == other.ToCapturePath && this.ToIsMarkup == other.ToIsMarkup
139
                && this.FrReviewStatus == other.FrReviewStatus && this.FrRemarks == other.FrRemarks && this.FrCreator == other.FrCreator && this.FrModifier == other.FrModifier
140
                && this.FrCapturePath == other.FrCapturePath && this.FrIsMarkup == other.FrIsMarkup && this.IsID2Work == other.IsID2Work && this.ID2Connection == other.ID2Connection
141
                && this.ID2StartDate == other.ID2StartDate && this.ID2EndDate == other.ID2EndDate && this.ID2JobTime == other.ID2JobTime && this.ID2Status == other.ID2Status
142
                && this.ID2Issues == other.ID2Issues && this.AVEVAConnection == other.AVEVAConnection && this.AVEVAConvertDate == other.AVEVAConvertDate && this.AVEVAReviewDate == other.AVEVAReviewDate
143
                && this.AVEVAStatus == other.AVEVAStatus && this.AVEVAIssues == other.AVEVAIssues && this.ReviewFilePath == other.ReviewFilePath && this.ReviewFileName == other.ReviewFileName
144
                && this.ProdReviewer == other.ProdReviewer && this.ProdIsResult == other.ProdIsResult && this.ProdRemarks == other.ProdRemarks && this.ClientReviewer == other.ClientReviewer
145
                && this.ClientIsResult == other.ClientIsResult && this.ClientRemarks == other.ClientRemarks && this.DTIsGateWay == other.DTIsGateWay && this.DTIsImport == other.DTIsImport
146
                && this.DTIsRegSystem == other.DTIsRegSystem && this.DTRemarks == other.DTRemarks;
147

  
148
        }
149
        public override int GetHashCode()
150
        {
151
            return this.DocumentNo.GetHashCode() + this.RevisonNo.GetHashCode() + this.ProjectID.GetHashCode() + this.IsLatest.GetHashCode()
152
                + this.AutoCADFilie.GetHashCode() + this.PDFFile.GetHashCode() + this.MarkupLink.GetHashCode() + this.AVEVALink.GetHashCode()
153
                + this.DocFilePath.GetHashCode() + this.DocFileName.GetHashCode() + this.Place.GetHashCode() + this.JobLevel.GetHashCode() + this.IsTypical.GetHashCode()
154
                + this.PersonInCharge.GetHashCode() + this.IsDeleted.GetHashCode() + this.ToIsDiscussion.GetHashCode() + this.ToRemarks.GetHashCode()
155
                + this.ToCreator.GetHashCode() + this.ToModifier.GetHashCode() + this.ToCapturePath.GetHashCode() + this.ToIsMarkup.GetHashCode()
156
                + this.FrReviewStatus.GetHashCode() + this.FrRemarks.GetHashCode() + this.FrCreator.GetHashCode() + this.FrModifier.GetHashCode()
157
                + this.FrCapturePath.GetHashCode() + this.FrIsMarkup.GetHashCode() + this.IsID2Work.GetHashCode() + this.ID2Connection.GetHashCode()
158
                + this.ID2StartDate.GetHashCode() + this.ID2EndDate.GetHashCode() + this.ID2JobTime.GetHashCode() + this.ID2Status.GetHashCode()
159
                + this.ID2Issues.GetHashCode() + this.AVEVAConnection.GetHashCode() + this.AVEVAConvertDate.GetHashCode() + this.AVEVAReviewDate.GetHashCode()
160
                + this.AVEVAStatus.GetHashCode() + this.AVEVAIssues.GetHashCode() + this.ReviewFilePath.GetHashCode() + this.ReviewFileName.GetHashCode()
161
                + this.ProdReviewer.GetHashCode() + this.ProdIsResult.GetHashCode() + this.ProdRemarks.GetHashCode() + this.ClientReviewer.GetHashCode()
162
                + this.ClientIsResult.GetHashCode() + this.ClientRemarks.GetHashCode() + this.DTIsGateWay.GetHashCode() + this.DTIsImport.GetHashCode()
163
                + this.DTIsRegSystem.GetHashCode() + this.DTRemarks.GetHashCode();
164
        }
126 165
    }
127 166
}
ID2.Manager/ID2.Manager/Main.Designer.cs
35 35
            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn4 = new Telerik.WinControls.UI.GridViewCommandColumn();
36 36
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn1 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
37 37
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn2 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
38
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn3 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
39 38
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn1 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
40 39
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn2 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
41
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn4 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
42 40
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn3 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
41
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn3 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
42
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn4 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
43
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn4 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
43 44
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn5 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
44
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn6 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
45 45
            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn5 = new Telerik.WinControls.UI.GridViewCommandColumn();
46
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn4 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
47 46
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn5 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
47
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn6 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
48
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn6 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
48 49
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn7 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
49
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn8 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
50 50
            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn6 = new Telerik.WinControls.UI.GridViewCommandColumn();
51
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn6 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
52 51
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn7 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
52
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn8 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
53 53
            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn7 = new Telerik.WinControls.UI.GridViewCommandColumn();
54 54
            Telerik.WinControls.UI.GridViewDateTimeColumn gridViewDateTimeColumn1 = new Telerik.WinControls.UI.GridViewDateTimeColumn();
55 55
            Telerik.WinControls.UI.GridViewDateTimeColumn gridViewDateTimeColumn2 = new Telerik.WinControls.UI.GridViewDateTimeColumn();
56
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn8 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
57
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn9 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
56 58
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn9 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
57
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn8 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
58
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn10 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
59 59
            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn8 = new Telerik.WinControls.UI.GridViewCommandColumn();
60 60
            Telerik.WinControls.UI.GridViewDateTimeColumn gridViewDateTimeColumn3 = new Telerik.WinControls.UI.GridViewDateTimeColumn();
61 61
            Telerik.WinControls.UI.GridViewDateTimeColumn gridViewDateTimeColumn4 = new Telerik.WinControls.UI.GridViewDateTimeColumn();
62
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn9 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
63
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn11 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
62
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn10 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
63
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn10 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
64 64
            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn9 = new Telerik.WinControls.UI.GridViewCommandColumn();
65 65
            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn10 = new Telerik.WinControls.UI.GridViewCommandColumn();
66
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn11 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
67
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn11 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
66 68
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn12 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
67
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn10 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
68 69
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn13 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
69
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn14 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
70
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn11 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
71
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn15 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
72 70
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn12 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
71
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn14 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
73 72
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn13 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
74 73
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn14 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
75
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn16 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
74
            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn15 = new Telerik.WinControls.UI.GridViewComboBoxColumn();
75
            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn15 = new Telerik.WinControls.UI.GridViewTextBoxColumn();
76 76
            Telerik.WinControls.UI.TableViewDefinition tableViewDefinition1 = new Telerik.WinControls.UI.TableViewDefinition();
77 77
            this.ID2ManagerRadRibbonBar = new Telerik.WinControls.UI.RadRibbonBar();
78
            this.ribbonTabHome = new Telerik.WinControls.UI.RibbonTab();
79
            this.radRibbonBarGroup1 = new Telerik.WinControls.UI.RadRibbonBarGroup();
80
            this.radButtonElementSave = new Telerik.WinControls.UI.RadButtonElement();
78 81
            this.ribbonTabProjMgt = new Telerik.WinControls.UI.RibbonTab();
79 82
            this.radRibbonBarGroupExcel = new Telerik.WinControls.UI.RadRibbonBarGroup();
80 83
            this.radButtonElementExcelImport = new Telerik.WinControls.UI.RadButtonElement();
......
85 88
            this.radGridViewDocuments = new Telerik.WinControls.UI.RadGridView();
86 89
            this.splitPanelRight = new Telerik.WinControls.UI.SplitPanel();
87 90
            this.radButtonElementImportPCWBS = new Telerik.WinControls.UI.RadButtonElement();
88
            this.ribbonTabHome = new Telerik.WinControls.UI.RibbonTab();
89
            this.radRibbonBarGroup1 = new Telerik.WinControls.UI.RadRibbonBarGroup();
90
            this.radButtonElementSave = new Telerik.WinControls.UI.RadButtonElement();
91 91
            ((System.ComponentModel.ISupportInitialize)(this.ID2ManagerRadRibbonBar)).BeginInit();
92 92
            ((System.ComponentModel.ISupportInitialize)(this.radSplitContainerWrap)).BeginInit();
93 93
            this.radSplitContainerWrap.SuspendLayout();
......
112 112
            this.ID2ManagerRadRibbonBar.TabIndex = 0;
113 113
            this.ID2ManagerRadRibbonBar.Text = "Main";
114 114
            // 
115
            // ribbonTabHome
116
            // 
117
            this.ribbonTabHome.IsSelected = true;
118
            this.ribbonTabHome.Items.AddRange(new Telerik.WinControls.RadItem[] {
119
            this.radRibbonBarGroup1});
120
            this.ribbonTabHome.Name = "ribbonTabHome";
121
            this.ribbonTabHome.Text = "Home";
122
            this.ribbonTabHome.UseMnemonic = false;
123
            // 
124
            // radRibbonBarGroup1
125
            // 
126
            this.radRibbonBarGroup1.Items.AddRange(new Telerik.WinControls.RadItem[] {
127
            this.radButtonElementSave});
128
            this.radRibbonBarGroup1.Name = "radRibbonBarGroup1";
129
            this.radRibbonBarGroup1.Text = "Save";
130
            // 
131
            // radButtonElementSave
132
            // 
133
            this.radButtonElementSave.Image = global::ID2.Manager.Properties.Resources.Save;
134
            this.radButtonElementSave.Name = "radButtonElementSave";
135
            this.radButtonElementSave.Text = "Save";
136
            this.radButtonElementSave.TextAlignment = System.Drawing.ContentAlignment.BottomCenter;
137
            this.radButtonElementSave.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
138
            // 
115 139
            // ribbonTabProjMgt
116 140
            // 
117 141
            this.ribbonTabProjMgt.IsSelected = false;
......
202 226
            // 
203 227
            // 
204 228
            this.radGridViewDocuments.MasterTemplate.AllowColumnHeaderContextMenu = false;
205
            this.radGridViewDocuments.MasterTemplate.AllowDeleteRow = false;
206 229
            this.radGridViewDocuments.MasterTemplate.AllowSearchRow = true;
207 230
            this.radGridViewDocuments.MasterTemplate.AutoGenerateColumns = false;
208 231
            this.radGridViewDocuments.MasterTemplate.ChildViewTabsPosition = Telerik.WinControls.UI.TabPositions.Left;
209 232
            gridViewCommandColumn1.FieldName = "AutoCADLink";
210 233
            gridViewCommandColumn1.HeaderText = "AutoCAD";
234
            gridViewCommandColumn1.ImageLayout = System.Windows.Forms.ImageLayout.Center;
211 235
            gridViewCommandColumn1.Name = "AutoCADLink";
212 236
            gridViewCommandColumn1.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
213 237
            gridViewCommandColumn1.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
......
215 239
            gridViewCommandColumn2.FieldName = "PDFLink";
216 240
            gridViewCommandColumn2.HeaderText = "PDF";
217 241
            gridViewCommandColumn2.ImageLayout = System.Windows.Forms.ImageLayout.Center;
218
            gridViewCommandColumn2.MaxWidth = 50;
219
            gridViewCommandColumn2.MinWidth = 18;
220 242
            gridViewCommandColumn2.Name = "PDFLink";
221
            gridViewCommandColumn2.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
222 243
            gridViewCommandColumn2.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
244
            gridViewCommandColumn2.Width = 70;
223 245
            gridViewCommandColumn3.FieldName = "MarkupLink";
224 246
            gridViewCommandColumn3.HeaderText = "Markus";
247
            gridViewCommandColumn3.ImageLayout = System.Windows.Forms.ImageLayout.Center;
225 248
            gridViewCommandColumn3.Name = "MarkupLink";
249
            gridViewCommandColumn3.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
226 250
            gridViewCommandColumn3.Width = 70;
227 251
            gridViewCommandColumn4.FieldName = "AVEVALink";
228 252
            gridViewCommandColumn4.HeaderText = "AVEVA";
253
            gridViewCommandColumn4.ImageLayout = System.Windows.Forms.ImageLayout.Center;
229 254
            gridViewCommandColumn4.Name = "AVEVALink";
255
            gridViewCommandColumn4.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
230 256
            gridViewCommandColumn4.Width = 70;
231 257
            gridViewTextBoxColumn1.FieldName = "Place";
232 258
            gridViewTextBoxColumn1.HeaderText = "위치";
......
237 263
            gridViewTextBoxColumn2.HeaderText = "이름";
238 264
            gridViewTextBoxColumn2.Name = "DocumentNo";
239 265
            gridViewTextBoxColumn2.Width = 150;
240
            gridViewTextBoxColumn3.FieldName = "PersonInCharge";
241
            gridViewTextBoxColumn3.HeaderText = "담당자";
242
            gridViewTextBoxColumn3.Name = "PersonInCharge";
243
            gridViewTextBoxColumn3.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
244
            gridViewTextBoxColumn3.Width = 70;
245
            gridViewComboBoxColumn1.FieldName = "JobLevel";
246
            gridViewComboBoxColumn1.HeaderText = "난이도";
247
            gridViewComboBoxColumn1.Name = "JobLevel";
266
            gridViewComboBoxColumn1.FieldName = "PersonInCharge";
267
            gridViewComboBoxColumn1.HeaderText = "담당자";
268
            gridViewComboBoxColumn1.Name = "PersonInCharge";
248 269
            gridViewComboBoxColumn1.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
249
            gridViewComboBoxColumn1.Width = 60;
250
            gridViewComboBoxColumn2.FieldName = "IsTypical";
251
            gridViewComboBoxColumn2.HeaderText = "Typical";
252
            gridViewComboBoxColumn2.Name = "IsTypical";
270
            gridViewComboBoxColumn1.Width = 100;
271
            gridViewComboBoxColumn2.FieldName = "JobLevel";
272
            gridViewComboBoxColumn2.HeaderText = "난이도";
273
            gridViewComboBoxColumn2.Name = "JobLevel";
253 274
            gridViewComboBoxColumn2.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
254 275
            gridViewComboBoxColumn2.Width = 60;
255
            gridViewTextBoxColumn4.FieldName = "RevisonNo";
256
            gridViewTextBoxColumn4.HeaderText = "Rev.";
257
            gridViewTextBoxColumn4.Name = "RevisonNo";
258
            gridViewTextBoxColumn4.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
259
            gridViewComboBoxColumn3.FieldName = "ToIsDiscussion";
260
            gridViewComboBoxColumn3.HeaderText = "협의사항";
261
            gridViewComboBoxColumn3.Name = "ToIsDiscussion";
262
            gridViewComboBoxColumn3.Width = 80;
263
            gridViewTextBoxColumn5.FieldName = "ToRemarks";
264
            gridViewTextBoxColumn5.HeaderText = "Brief";
265
            gridViewTextBoxColumn5.Multiline = true;
266
            gridViewTextBoxColumn5.Name = "ToRemarks";
267
            gridViewTextBoxColumn5.Width = 150;
268
            gridViewTextBoxColumn6.FieldName = "ToModifier";
269
            gridViewTextBoxColumn6.HeaderText = "작성자";
270
            gridViewTextBoxColumn6.Name = "ToModifier";
271
            gridViewTextBoxColumn6.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
272
            gridViewTextBoxColumn6.Width = 70;
276
            gridViewComboBoxColumn3.FieldName = "IsTypical";
277
            gridViewComboBoxColumn3.HeaderText = "Typical";
278
            gridViewComboBoxColumn3.Name = "IsTypical";
279
            gridViewComboBoxColumn3.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
280
            gridViewComboBoxColumn3.Width = 60;
281
            gridViewTextBoxColumn3.FieldName = "RevisonNo";
282
            gridViewTextBoxColumn3.HeaderText = "Rev.";
283
            gridViewTextBoxColumn3.Name = "RevisonNo";
284
            gridViewTextBoxColumn3.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
285
            gridViewComboBoxColumn4.FieldName = "ToIsDiscussion";
286
            gridViewComboBoxColumn4.HeaderText = "협의사항";
287
            gridViewComboBoxColumn4.Name = "ToIsDiscussion";
288
            gridViewComboBoxColumn4.Width = 80;
289
            gridViewTextBoxColumn4.FieldName = "ToRemarks";
290
            gridViewTextBoxColumn4.HeaderText = "Brief";
291
            gridViewTextBoxColumn4.Multiline = true;
292
            gridViewTextBoxColumn4.Name = "ToRemarks";
293
            gridViewTextBoxColumn4.Width = 150;
294
            gridViewTextBoxColumn5.FieldName = "ToModifier";
295
            gridViewTextBoxColumn5.HeaderText = "작성자";
296
            gridViewTextBoxColumn5.Name = "ToModifier";
297
            gridViewTextBoxColumn5.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
298
            gridViewTextBoxColumn5.Width = 70;
273 299
            gridViewCommandColumn5.FieldName = "ToCapturePath";
274 300
            gridViewCommandColumn5.HeaderText = "캡쳐";
275 301
            gridViewCommandColumn5.Name = "ToCapturePath";
276 302
            gridViewCommandColumn5.Width = 70;
277
            gridViewComboBoxColumn4.FieldName = "ToIsMarkup";
278
            gridViewComboBoxColumn4.HeaderText = "마크업여부";
279
            gridViewComboBoxColumn4.Name = "ToIsMarkup";
280
            gridViewComboBoxColumn4.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
281
            gridViewComboBoxColumn4.Width = 80;
282
            gridViewComboBoxColumn5.FieldName = "FrReviewStatus";
283
            gridViewComboBoxColumn5.HeaderText = "의견Status";
284
            gridViewComboBoxColumn5.Name = "FrReviewStatus";
303
            gridViewComboBoxColumn5.FieldName = "ToIsMarkup";
304
            gridViewComboBoxColumn5.HeaderText = "마크업여부";
305
            gridViewComboBoxColumn5.Name = "ToIsMarkup";
285 306
            gridViewComboBoxColumn5.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
286 307
            gridViewComboBoxColumn5.Width = 80;
287
            gridViewTextBoxColumn7.FieldName = "FrRemarks";
288
            gridViewTextBoxColumn7.HeaderText = "Brief";
289
            gridViewTextBoxColumn7.Name = "FrRemarks";
290
            gridViewTextBoxColumn7.Width = 150;
291
            gridViewTextBoxColumn8.FieldName = "FrModifier";
292
            gridViewTextBoxColumn8.HeaderText = "검토자";
293
            gridViewTextBoxColumn8.Name = "FrModifier";
294
            gridViewTextBoxColumn8.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
295
            gridViewTextBoxColumn8.Width = 70;
308
            gridViewComboBoxColumn6.FieldName = "FrReviewStatus";
309
            gridViewComboBoxColumn6.HeaderText = "의견Status";
310
            gridViewComboBoxColumn6.Name = "FrReviewStatus";
311
            gridViewComboBoxColumn6.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
312
            gridViewComboBoxColumn6.Width = 80;
313
            gridViewTextBoxColumn6.FieldName = "FrRemarks";
314
            gridViewTextBoxColumn6.HeaderText = "Brief";
315
            gridViewTextBoxColumn6.Name = "FrRemarks";
316
            gridViewTextBoxColumn6.Width = 150;
317
            gridViewTextBoxColumn7.FieldName = "FrModifier";
318
            gridViewTextBoxColumn7.HeaderText = "검토자";
319
            gridViewTextBoxColumn7.Name = "FrModifier";
320
            gridViewTextBoxColumn7.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
321
            gridViewTextBoxColumn7.Width = 70;
296 322
            gridViewCommandColumn6.FieldName = "FrCapturePath";
297 323
            gridViewCommandColumn6.HeaderText = "캡쳐";
298 324
            gridViewCommandColumn6.Name = "FrCapturePath";
299 325
            gridViewCommandColumn6.Width = 70;
300
            gridViewComboBoxColumn6.FieldName = "FrIsMarkup";
301
            gridViewComboBoxColumn6.HeaderText = "마크업여부";
302
            gridViewComboBoxColumn6.Name = "FrIsMarkup";
303
            gridViewComboBoxColumn6.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
304
            gridViewComboBoxColumn6.Width = 80;
305
            gridViewComboBoxColumn7.FieldName = "IsID2Work";
306
            gridViewComboBoxColumn7.HeaderText = "ID2 작업가능";
307
            gridViewComboBoxColumn7.Name = "IsID2Work";
308
            gridViewComboBoxColumn7.Width = 90;
326
            gridViewComboBoxColumn7.FieldName = "FrIsMarkup";
327
            gridViewComboBoxColumn7.HeaderText = "마크업여부";
328
            gridViewComboBoxColumn7.Name = "FrIsMarkup";
329
            gridViewComboBoxColumn7.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
330
            gridViewComboBoxColumn7.Width = 80;
331
            gridViewComboBoxColumn8.FieldName = "IsID2Work";
332
            gridViewComboBoxColumn8.HeaderText = "ID2 작업가능";
333
            gridViewComboBoxColumn8.Name = "IsID2Work";
334
            gridViewComboBoxColumn8.Width = 90;
309 335
            gridViewCommandColumn7.FieldName = "ID2Connection";
310 336
            gridViewCommandColumn7.HeaderText = "연결";
311 337
            gridViewCommandColumn7.Name = "ID2Connection";
......
324 350
            gridViewDateTimeColumn2.Name = "ID2EndDate";
325 351
            gridViewDateTimeColumn2.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
326 352
            gridViewDateTimeColumn2.Width = 80;
327
            gridViewTextBoxColumn9.FieldName = "ID2JobTime";
328
            gridViewTextBoxColumn9.HeaderText = "작업시간";
329
            gridViewTextBoxColumn9.Name = "ID2JobTime";
330
            gridViewTextBoxColumn9.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
331
            gridViewTextBoxColumn9.Width = 80;
332
            gridViewComboBoxColumn8.FieldName = "ID2Status";
333
            gridViewComboBoxColumn8.HeaderText = "Status";
334
            gridViewComboBoxColumn8.Name = "ID2Status";
335
            gridViewComboBoxColumn8.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
336
            gridViewComboBoxColumn8.Width = 70;
337
            gridViewTextBoxColumn10.FieldName = "ID2Issues";
338
            gridViewTextBoxColumn10.HeaderText = "이슈사항";
339
            gridViewTextBoxColumn10.Name = "ID2Issues";
340
            gridViewTextBoxColumn10.Width = 150;
353
            gridViewTextBoxColumn8.FieldName = "ID2JobTime";
354
            gridViewTextBoxColumn8.HeaderText = "작업시간";
355
            gridViewTextBoxColumn8.Name = "ID2JobTime";
356
            gridViewTextBoxColumn8.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
357
            gridViewTextBoxColumn8.Width = 80;
358
            gridViewComboBoxColumn9.FieldName = "ID2Status";
359
            gridViewComboBoxColumn9.HeaderText = "Status";
360
            gridViewComboBoxColumn9.Name = "ID2Status";
361
            gridViewComboBoxColumn9.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
362
            gridViewComboBoxColumn9.Width = 70;
363
            gridViewTextBoxColumn9.FieldName = "ID2Issues";
364
            gridViewTextBoxColumn9.HeaderText = "이슈사항";
365
            gridViewTextBoxColumn9.Name = "ID2Issues";
366
            gridViewTextBoxColumn9.Width = 150;
341 367
            gridViewCommandColumn8.FieldName = "AVEVAConnection";
342 368
            gridViewCommandColumn8.HeaderText = "연결";
343 369
            gridViewCommandColumn8.Name = "AVEVAConnection";
......
356 382
            gridViewDateTimeColumn4.Name = "AVEVAReviewDate";
357 383
            gridViewDateTimeColumn4.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
358 384
            gridViewDateTimeColumn4.Width = 70;
359
            gridViewComboBoxColumn9.FieldName = "AVEVAStatus";
360
            gridViewComboBoxColumn9.HeaderText = "Status";
361
            gridViewComboBoxColumn9.Name = "AVEVAStatus";
362
            gridViewComboBoxColumn9.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
363
            gridViewComboBoxColumn9.Width = 70;
364
            gridViewTextBoxColumn11.FieldName = "AVEVAIssues";
365
            gridViewTextBoxColumn11.HeaderText = "이슈사항";
366
            gridViewTextBoxColumn11.Name = "AVEVAIssues";
367
            gridViewTextBoxColumn11.Width = 150;
385
            gridViewComboBoxColumn10.FieldName = "AVEVAStatus";
386
            gridViewComboBoxColumn10.HeaderText = "Status";
387
            gridViewComboBoxColumn10.Name = "AVEVAStatus";
388
            gridViewComboBoxColumn10.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
389
            gridViewComboBoxColumn10.Width = 70;
390
            gridViewTextBoxColumn10.FieldName = "AVEVAIssues";
391
            gridViewTextBoxColumn10.HeaderText = "이슈사항";
392
            gridViewTextBoxColumn10.Name = "AVEVAIssues";
393
            gridViewTextBoxColumn10.Width = 150;
368 394
            gridViewCommandColumn9.FieldName = "ReviewFileName";
369 395
            gridViewCommandColumn9.HeaderText = "PDF";
370 396
            gridViewCommandColumn9.Name = "ReviewFileName";
......
372 398
            gridViewCommandColumn10.HeaderText = "시스템";
373 399
            gridViewCommandColumn10.Name = "SystemLink";
374 400
            gridViewCommandColumn10.Width = 70;
375
            gridViewTextBoxColumn12.FieldName = "ProdReviewer";
376
            gridViewTextBoxColumn12.HeaderText = "검토자";
377
            gridViewTextBoxColumn12.Name = "ProdReviewer";
378
            gridViewTextBoxColumn12.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
379
            gridViewTextBoxColumn12.Width = 70;
380
            gridViewComboBoxColumn10.FieldName = "ProdIsResult";
381
            gridViewComboBoxColumn10.HeaderText = "결과";
382
            gridViewComboBoxColumn10.Name = "ProdIsResult";
383
            gridViewComboBoxColumn10.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
384
            gridViewComboBoxColumn10.Width = 70;
385
            gridViewTextBoxColumn13.FieldName = "ProdRemarks";
386
            gridViewTextBoxColumn13.HeaderText = "비고";
387
            gridViewTextBoxColumn13.Name = "ProdRemarks";
388
            gridViewTextBoxColumn13.Width = 150;
389
            gridViewTextBoxColumn14.FieldName = "ClientReviewer";
390
            gridViewTextBoxColumn14.HeaderText = "검토자";
391
            gridViewTextBoxColumn14.Name = "ClientReviewer";
392
            gridViewTextBoxColumn14.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
393
            gridViewTextBoxColumn14.Width = 70;
394
            gridViewComboBoxColumn11.FieldName = "ClientIsResult";
401
            gridViewTextBoxColumn11.FieldName = "ProdReviewer";
402
            gridViewTextBoxColumn11.HeaderText = "검토자";
403
            gridViewTextBoxColumn11.Name = "ProdReviewer";
404
            gridViewTextBoxColumn11.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
405
            gridViewTextBoxColumn11.Width = 70;
406
            gridViewComboBoxColumn11.FieldName = "ProdIsResult";
395 407
            gridViewComboBoxColumn11.HeaderText = "결과";
396
            gridViewComboBoxColumn11.Name = "ClientIsResult";
408
            gridViewComboBoxColumn11.Name = "ProdIsResult";
397 409
            gridViewComboBoxColumn11.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
398 410
            gridViewComboBoxColumn11.Width = 70;
399
            gridViewTextBoxColumn15.FieldName = "ClientRemarks";
400
            gridViewTextBoxColumn15.HeaderText = "비고";
401
            gridViewTextBoxColumn15.Name = "ClientRemarks";
402
            gridViewTextBoxColumn15.Width = 150;
403
            gridViewComboBoxColumn12.FieldName = "DTIsGateWay";
404
            gridViewComboBoxColumn12.HeaderText = "GateWay";
405
            gridViewComboBoxColumn12.Name = "DTIsGateWay";
411
            gridViewTextBoxColumn12.FieldName = "ProdRemarks";
412
            gridViewTextBoxColumn12.HeaderText = "비고";
413
            gridViewTextBoxColumn12.Name = "ProdRemarks";
414
            gridViewTextBoxColumn12.Width = 150;
415
            gridViewTextBoxColumn13.FieldName = "ClientReviewer";
416
            gridViewTextBoxColumn13.HeaderText = "검토자";
417
            gridViewTextBoxColumn13.Name = "ClientReviewer";
418
            gridViewTextBoxColumn13.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
419
            gridViewTextBoxColumn13.Width = 70;
420
            gridViewComboBoxColumn12.FieldName = "ClientIsResult";
421
            gridViewComboBoxColumn12.HeaderText = "결과";
422
            gridViewComboBoxColumn12.Name = "ClientIsResult";
406 423
            gridViewComboBoxColumn12.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
407
            gridViewComboBoxColumn12.Width = 80;
408
            gridViewComboBoxColumn13.FieldName = "DTIsImport";
409
            gridViewComboBoxColumn13.HeaderText = "Import 성공여부";
410
            gridViewComboBoxColumn13.Name = "DTIsImport";
424
            gridViewComboBoxColumn12.Width = 70;
425
            gridViewTextBoxColumn14.FieldName = "ClientRemarks";
426
            gridViewTextBoxColumn14.HeaderText = "비고";
427
            gridViewTextBoxColumn14.Name = "ClientRemarks";
428
            gridViewTextBoxColumn14.Width = 150;
429
            gridViewComboBoxColumn13.FieldName = "DTIsGateWay";
430
            gridViewComboBoxColumn13.HeaderText = "GateWay";
431
            gridViewComboBoxColumn13.Name = "DTIsGateWay";
411 432
            gridViewComboBoxColumn13.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
412 433
            gridViewComboBoxColumn13.Width = 80;
413
            gridViewComboBoxColumn14.FieldName = "DTIsRegSystem";
414
            gridViewComboBoxColumn14.HeaderText = "시스템등록";
415
            gridViewComboBoxColumn14.Name = "DTIsRegSystem";
434
            gridViewComboBoxColumn14.FieldName = "DTIsImport";
435
            gridViewComboBoxColumn14.HeaderText = "Import 성공여부";
436
            gridViewComboBoxColumn14.Name = "DTIsImport";
416 437
            gridViewComboBoxColumn14.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
417 438
            gridViewComboBoxColumn14.Width = 80;
418
            gridViewTextBoxColumn16.FieldName = "DTRemarks";
419
            gridViewTextBoxColumn16.HeaderText = "비고";
420
            gridViewTextBoxColumn16.Name = "DTRemarks";
421
            gridViewTextBoxColumn16.Width = 150;
439
            gridViewComboBoxColumn15.FieldName = "DTIsRegSystem";
440
            gridViewComboBoxColumn15.HeaderText = "시스템등록";
441
            gridViewComboBoxColumn15.Name = "DTIsRegSystem";
442
            gridViewComboBoxColumn15.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
443
            gridViewComboBoxColumn15.Width = 80;
444
            gridViewTextBoxColumn15.FieldName = "DTRemarks";
445
            gridViewTextBoxColumn15.HeaderText = "비고";
446
            gridViewTextBoxColumn15.Name = "DTRemarks";
447
            gridViewTextBoxColumn15.Width = 150;
422 448
            this.radGridViewDocuments.MasterTemplate.Columns.AddRange(new Telerik.WinControls.UI.GridViewDataColumn[] {
423 449
            gridViewCommandColumn1,
424 450
            gridViewCommandColumn2,
......
426 452
            gridViewCommandColumn4,
427 453
            gridViewTextBoxColumn1,
428 454
            gridViewTextBoxColumn2,
429
            gridViewTextBoxColumn3,
430 455
            gridViewComboBoxColumn1,
431 456
            gridViewComboBoxColumn2,
432
            gridViewTextBoxColumn4,
433 457
            gridViewComboBoxColumn3,
458
            gridViewTextBoxColumn3,
459
            gridViewComboBoxColumn4,
460
            gridViewTextBoxColumn4,
434 461
            gridViewTextBoxColumn5,
435
            gridViewTextBoxColumn6,
436 462
            gridViewCommandColumn5,
437
            gridViewComboBoxColumn4,
438 463
            gridViewComboBoxColumn5,
464
            gridViewComboBoxColumn6,
465
            gridViewTextBoxColumn6,
439 466
            gridViewTextBoxColumn7,
440
            gridViewTextBoxColumn8,
441 467
            gridViewCommandColumn6,
442
            gridViewComboBoxColumn6,
443 468
            gridViewComboBoxColumn7,
469
            gridViewComboBoxColumn8,
444 470
            gridViewCommandColumn7,
445 471
            gridViewDateTimeColumn1,
446 472
            gridViewDateTimeColumn2,
473
            gridViewTextBoxColumn8,
474
            gridViewComboBoxColumn9,
447 475
            gridViewTextBoxColumn9,
448
            gridViewComboBoxColumn8,
449
            gridViewTextBoxColumn10,
450 476
            gridViewCommandColumn8,
451 477
            gridViewDateTimeColumn3,
452 478
            gridViewDateTimeColumn4,
453
            gridViewComboBoxColumn9,
454
            gridViewTextBoxColumn11,
479
            gridViewComboBoxColumn10,
480
            gridViewTextBoxColumn10,
455 481
            gridViewCommandColumn9,
456 482
            gridViewCommandColumn10,
483
            gridViewTextBoxColumn11,
484
            gridViewComboBoxColumn11,
457 485
            gridViewTextBoxColumn12,
458
            gridViewComboBoxColumn10,
459 486
            gridViewTextBoxColumn13,
460
            gridViewTextBoxColumn14,
461
            gridViewComboBoxColumn11,
462
            gridViewTextBoxColumn15,
463 487
            gridViewComboBoxColumn12,
488
            gridViewTextBoxColumn14,
464 489
            gridViewComboBoxColumn13,
465 490
            gridViewComboBoxColumn14,
466
            gridViewTextBoxColumn16});
491
            gridViewComboBoxColumn15,
492
            gridViewTextBoxColumn15});
467 493
            this.radGridViewDocuments.MasterTemplate.EnableAlternatingRowColor = true;
468 494
            this.radGridViewDocuments.MasterTemplate.EnableFiltering = true;
469 495
            this.radGridViewDocuments.MasterTemplate.ShowFilteringRow = false;
......
497 523
            this.radButtonElementImportPCWBS.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
498 524
            this.radButtonElementImportPCWBS.UseCompatibleTextRendering = false;
499 525
            // 
500
            // ribbonTabHome
501
            // 
502
            this.ribbonTabHome.IsSelected = true;
503
            this.ribbonTabHome.Items.AddRange(new Telerik.WinControls.RadItem[] {
504
            this.radRibbonBarGroup1});
505
            this.ribbonTabHome.Name = "ribbonTabHome";
506
            this.ribbonTabHome.Text = "Home";
507
            this.ribbonTabHome.UseMnemonic = false;
508
            // 
509
            // radRibbonBarGroup1
510
            // 
511
            this.radRibbonBarGroup1.Items.AddRange(new Telerik.WinControls.RadItem[] {
512
            this.radButtonElementSave});
513
            this.radRibbonBarGroup1.Name = "radRibbonBarGroup1";
514
            this.radRibbonBarGroup1.Text = "Save";
515
            // 
516
            // radButtonElementSave
517
            // 
518
            this.radButtonElementSave.Image = global::ID2.Manager.Properties.Resources.Save;
519
            this.radButtonElementSave.Name = "radButtonElementSave";
520
            this.radButtonElementSave.Text = "Save";
521
            this.radButtonElementSave.TextAlignment = System.Drawing.ContentAlignment.BottomCenter;
522
            this.radButtonElementSave.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
523
            // 
524 526
            // Main
525 527
            // 
526 528
            this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
ID2.Manager/ID2.Manager/Main.cs
16 16

  
17 17
using Telerik.WinControls;
18 18
using Telerik.WinControls.UI;
19
using Telerik.WinControls.Data;
20

  
19 21
using GemBox.Spreadsheet;
20 22

  
23
using Newtonsoft.Json;
24

  
21 25
namespace ID2.Manager
22 26
{
23 27
    public partial class Main : RadRibbonForm
24 28
    {
25 29
        readonly Informations informations = Informations.Instance;
26 30

  
31
        List<Documents> documents = new List<Documents>();
32
        List<Documents> orgDocuments = null;
33

  
34
        private readonly Color _SummaryColor = Color.FromArgb(255, 108, 55);
35

  
27 36
        public Main()
28 37
        {
29 38
            InitializeComponent();
30 39

  
40
            this.Initialize();
41

  
31 42
            SpreadsheetInfo.SetLicense(Properties.Settings.Default.GemBoxLicense);
32 43

  
33 44
            this.Load += Main_Load;
......
44 55
            this.InitColumnGroupsViewDefinition(this.radGridViewDocuments);
45 56
        }
46 57

  
58
        private void Initialize()
59
        {
60
            IEnumerable<UserInfo> allUserList = new UserController().GetAllUserInfo();
61
            allUserList.ToList().ForEach(x => informations.UserList.Add(x));
62
        }
63

  
47 64
        private void Main_Load(object sender, EventArgs e)
48 65
        {
49 66
            this.GetDocList();
......
51 68

  
52 69
        public void GetDocList()
53 70
        {
54
            IEnumerable<Documents> docList = new DocumentController().GetAllDocuments();
55
            this.radGridViewDocuments.DataSource = docList;
71
            this.documents = new DocumentController().GetAllDocuments().ToList();
72
            this.orgDocuments = JsonConvert.DeserializeObject<List<Documents>>(JsonConvert.SerializeObject(this.documents));
56 73

  
57
            BeginInvoke(new Action(() =>
58
            {
59
                if (this.radGridViewDocuments.DataSource != null)
60
                    this.radGridViewDocuments.DataSource = null;
74
            GridViewComboBoxColumn ColUserList = this.radGridViewDocuments.Columns["PersonInCharge"] as GridViewComboBoxColumn;
75
            ColUserList.DataSource = informations.UserList;
76
            ColUserList.DisplayMember = "Name";
77
            ColUserList.ValueMember = "ID";
78

  
79
            //Data
80
            if (this.radGridViewDocuments.DataSource != null)
81
                this.radGridViewDocuments.DataSource = null;
82
            this.radGridViewDocuments.DataSource = this.documents;
83

  
84
            if (this.radGridViewDocuments.SummaryRowsTop != null)
85
                this.radGridViewDocuments.SummaryRowsTop.Clear();
86

  
87
            string totalCount = String.Format("{0:#,###}", this.documents.Count());
61 88

  
62
                this.radGridViewDocuments.DataSource = docList;
63
            }));
89
            //Summary
90
            GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem()
91
                {
92
                    new GridViewSummaryItem("DocumentNo", "{0:#,###} / " + totalCount, GridAggregateFunction.Count)
93
                };
94
            this.radGridViewDocuments.SummaryRowsTop.Add(summaryRowItem);
95
            this.radGridViewDocuments.MasterView.SummaryRows[0].PinPosition = PinnedRowPosition.Top;
96
            this.radGridViewDocuments.MasterTemplate.BottomPinnedRowsMode = GridViewBottomPinnedRowsMode.Fixed;
64 97
        }
65 98

  
66 99
        private void RadGridViewDocuments_CommandCellClick(object sender, GridViewCellEventArgs e)
......
144 177

  
145 178
        private void RadGridViewDocuments_ViewCellFormatting(object sender, CellFormattingEventArgs e)
146 179
        {
147
            if (e.CellElement is GridRowHeaderCellElement)
180
            if (e.Row is GridViewDataRowInfo)
148 181
            {
149
                e.CellElement.Text = (e.CellElement.RowIndex + 1).ToString();
182
                if (e.CellElement is GridRowHeaderCellElement)
183
                {
184
                    if (e.CellElement.RowIndex > -1)
185
                        e.CellElement.Text = (e.CellElement.RowIndex + 1).ToString();
186
                }
187
                else
188
                {
189
                    var result = e.Row.DataBoundItem as Documents;
190
                    if (result != null || e.Row is GridViewNewRowInfo)
191
                    {
192
                        switch (e.CellElement.ColumnInfo.Name)
193
                        {
194
                            case "AutoCADLink":
195
                            case "PDFLink":
196
                            case "MarkupLink":
197
                            case "AVEVALink":
198
                            case "AVEVAConnection":
199
                            case "ReviewFileName"://일단주석
200
                            case "SystemLink":
201
                            case "ToCapturePath":
202
                            case "FrCapturePath":
203
                            case "ID2Connection":
204
                                this.GetCommandColBtnElement(e.CellElement.Children[0], e.CellElement.ColumnInfo.Name);
205
                                break;
206
                        }
207
                    }
208
                    else
209
                    {
210

  
211
                    }
212
                }
150 213
            }
151
            else if (e.Row is GridViewNewRowInfo)
214
            else if (e.Row is GridViewSummaryRowInfo)
152 215
            {
153
                switch (e.CellElement.ColumnInfo.Name)
216
                if (e.CellElement is GridRowHeaderCellElement)
154 217
                {
155
                    case "AutoCADLink":
156
                    case "PDFLink":
157
                    case "MarkupLink":
158
                    case "AVEVALink":
159
                    case "AVEVAConnection":
160
                    case "ReviewFileName"://일단주석
161
                    case "SystemLink":
162
                    case "ToCapturePath":
163
                    case "FrCapturePath":
164
                    case "ID2Connection":
165
                        this.GetCommandColBtnElement(e.CellElement.Children[0], e.CellElement.ColumnInfo.Name);
166
                        break;
218
                    e.CellElement.Text = "Count";
219
                }
220
                else if (e.CellElement is GridSummaryCellElement)
221
                {
222
                    e.CellElement.ForeColor = this._SummaryColor;
223
                    e.CellElement.TextAlignment = ContentAlignment.BottomRight;
224
                    e.CellElement.Font = new Font(e.CellElement.Font, FontStyle.Bold);
225
                }
226
                else
227
                {
228

  
167 229
                }
168 230
            }
169 231
            else
170 232
            {
171
                var result = e.Row.DataBoundItem as Documents;
172
                if (result != null)
173
                {
174
                    switch (e.CellElement.ColumnInfo.Name)
175
                    {
176
                        case "AutoCADLink":
177
                        case "PDFLink":
178
                        case "MarkupLink":
179
                        case "AVEVALink":
180
                        case "AVEVAConnection":
181
                        case "ReviewFileName"://일단주석
182
                        case "SystemLink":
183
                        case "ToCapturePath":
184
                        case "FrCapturePath":
185
                        case "ID2Connection":
186
                            this.GetCommandColBtnElement(e.CellElement.Children[0], e.CellElement.ColumnInfo.Name);
187
                            break;
188
                    }
189
                }
233

  
190 234
            }
191 235
        }
192 236

  
......
421 465
        private void RadButtonElementSave_Click(object sender, EventArgs e)
422 466
        {
423 467
            //저장
468
            List<Documents> setDocuments = new List<Documents>();
469
            List<Documents> delDocuments = new List<Documents>();
470

  
471
            this.documents.Where(x => !this.orgDocuments.Any(y => y.Equals(x)))
472
                          .ToList().ForEach(x => setDocuments.Add(x));
473

  
474
            this.orgDocuments.Where(x => this.documents.Any(y => y.Equals(x) && !string.IsNullOrEmpty(y.DocID)))
475
                             .ToList()
476
                             .ForEach(x => delDocuments.Add(x));
424 477
        }
425 478

  
426 479
        #region ColumnGroup

내보내기 Unified diff

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