프로젝트

일반

사용자정보

개정판 28907ead

ID28907ead6f598aa4b4f008d38d7202c408e08b7c
상위 846f3036
하위 6b8a740b

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

issue #0000
excel 유사도 추가
- import, export, excel 파일 수정

Change-Id: I321df2c611034fb54c319a8dc1a8f689ab0dbb43

차이점 보기:

ID2.Manager/ID2.Manager.Common/Helpers/ID2Excel.cs
225 225 
                            case 16:
226 226 
                                document.AVEVAWorker = this.GetUser(value).ID;
227 227 
                                break;
228 
                            case 17:
228 
                            case 17://유사도
229 
                                break;
230 
                            case 18://난이도
229 231 
                                document.JobLevel = value;
230 232 
                                break;
231 
                            case 18:
233 
                            case 19:
232 234 
                                document.RevisonNo = value;
233 235 
                                break;
234 
                            case 19:
236 
                            case 20:
235 237 
                                document.ToIsDiscussion = value;
236 238 
                                break;
237 
                            case 20:
239 
                            case 21:
238 240 
                                document.ToRemarks = value;
239 241 
                                break;
240 
                            case 21:
242 
                            case 22:
241 243 
                                document.ToCreator = this.GetUser(value).ID;
242 244 
                                break;
243 
                            case 22:
245 
                            case 23:
244 246 
                                if (value != null)
245 247 
                                {
246 248 
                                    if (document.AttFiles == null)
......
266 268 
                                    document.ToCapture = ++toreview;
267 269 
                                }
268 270 
                                break;
269 
                            case 23:
271 
                            case 24:
270 272 
                                document.FrReviewStatus = value;
271 273 
                                break;
272 
                            case 24:
274 
                            case 25:
273 275 
                                document.FrRemarks = value;
274 276 
                                break;
275 
                            case 25:
277 
                            case 26:
276 278 
                                document.FrCreator = this.GetUser(value).ID;
277 279 
                                break;
278 
                            case 26:
280 
                            case 27:
279 281 
                                if (value != null)
280 282 
                                {
281 283 
                                    if (document.AttFiles == null)
......
301 303 
                                    document.FrCapture = ++frreview;
302 304 
                                }
303 305 
                                break;
304 
                            case 27:
306 
                            case 28:
305 307 
                                document.ID2StartDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
306 308 
                                break;
307 
                            case 28:
309 
                            case 29:
308 310 
                                document.ID2EndDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
309 311 
                                break;
310 
                            case 29:
312 
                            case 30:
311 313 
                                document.ID2Status = value;
312 314 
                                break;
313 
                            case 30:
315 
                            case 31:
314 316 
                                document.ID2Issues = value;
315 317 
                                break;
316 
                            case 31:
318 
                            case 32:
317 319 
                                if (value != null)
318 320 
                                {
319 321 
                                    if (document.AttFiles == null)
......
339 341 
                                    document.ID2Capture = ++id2work;
340 342 
                                }
341 343 
                                break;
342 
                            case 32:
344 
                            case 33:
343 345 
                                document.ReplyModifications = value;
344 346 
                                break;
345 
                            case 33:
347 
                            case 34:
346 348 
                                document.ReplyRequester = this.GetUser(value).ID;
347 349 
                                break;
348 
                            case 34:
350 
                            case 35:
349 351 
                                document.IsConvert = value;
350 352 
                                break;
351 
                            case 35:
353 
                            case 36:
352 354 
                                document.AVEVAConvertDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
353 355 
                                break;
354 
                            case 36:
356 
                            case 37:
355 357 
                                document.AVEVAWorkDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
356 358 
                                break;
357 
                            case 37:
359 
                            case 38:
358 360 
                                document.AVEVAStatus = value;
359 361 
                                break;
360 
                            case 38:
362 
                            case 39:
361 363 
                                document.AVEVAIssues = value;
362 364 
                                break;
363 
                            case 39:
365 
                            case 40:
364 366 
                                document.AVEVAReviewDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
365 367 
                                break;
366 
                            case 40:
368 
                            case 41:
367 369 
                                document.ProdReviewer = this.GetUser(value).ID;
368 370 
                                break;
369 
                            case 41:
371 
                            case 42:
370 372 
                                document.ProdIsResult = value;
371 373 
                                break;
372 
                            case 42:
374 
                            case 43:
373 375 
                                document.ProdRemarks = value;
374 376 
                                break;
375 
                            case 43:
377 
                            case 44:
376 378 
                                document.ClientReviewer = this.GetUser(value).ID;
377 379 
                                break;
378 
                            case 44:
380 
                            case 45:
379 381 
                                document.ClientIsResult = value;
380 382 
                                break;
381 
                            case 45:
383 
                            case 46:
382 384 
                                document.ClientRemarks = value;
383 385 
                                break;
384 
                            case 46:
386 
                            case 47:
385 387 
                                document.DTIsGateWay = value;
386 388 
                                break;
387 
                            case 47:
389 
                            case 48:
388 390 
                                document.DTIsImport = value;
389 391 
                                break;
390 
                            case 48:
392 
                            case 49:
391 393 
                                document.DTIsRegSystem = value;
392 394 
                                break;
393 
                            case 49:
395 
                            case 50:
394 396 
                                document.DTRemarks = value;
395 397 
                                break;
396 398 
                        }
......
432 434 
                    return result;
433 435 
                }
434 436 

  		




  435
  
  
    
                #region 엑셀 필수값 체크(도면 : 이름,담당자, 난이도, Typical)


  		




  
  437
  
    
                #region 엑셀 필수값 체크(도면 : 이름, 담당자, 난이도, Typical) -> 추후 gembox사용시 변경필요


  		




  436
  438
  
    
                ws.Rows.SelectMany(row => row.AllocatedCells)


  		




  437
  439
  
    
                       .Where(col => col.Column.Index > 8 && col.Column.Index < 18 && col.Row.Index > exRow && col.Value == null)


  		




  438
  440
  
    
                       .ToList()


  		




  ......




  493
  495
  
    
                           {


  		




  494
  496
  
    
                               result.documents.Add(new Documents()


  		




  495
  497
  
    
                               {


  		




  496
  
  
    
                                   RefProjectCode = ws.Rows[p.Index].Cells[8].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[8].Value.ToString(),


  		




  497
  
  
    
                                   System = ws.Rows[p.Index].Cells[9].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[9].Value.ToString(),


  		




  498
  
  
    
                                   SubSystemCode = ws.Rows[p.Index].Cells[10].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[10].Value.ToString(),


  		




  499
  
  
    
                                   DocumentNo = ws.Rows[p.Index].Cells[11].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[11].Value.ToString(),


  		




  500
  
  
    
                                   PersonInCharge = ws.Rows[p.Index].Cells[12].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[12].Value.ToString()).ID,


  		




  501
  
  
    
                                   Worker = ws.Rows[p.Index].Cells[13].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[13].Value.ToString()).ID,


  		




  502
  
  
    
                                   AVEVAPersonInCharge = ws.Rows[p.Index].Cells[14].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[14].Value.ToString()).ID,


  		




  503
  
  
    
                                   AVEVAWorker = ws.Rows[p.Index].Cells[15].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[15].Value.ToString()).ID,


  		




  504
  
  
    
                                   JobLevel = ws.Rows[p.Index].Cells[16].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[16].Value.ToString(),


  		




  505
  
  
    
                                   RevisonNo = ws.Rows[p.Index].Cells[17].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[17].Value.ToString(),


  		




  506
  
  
    
                                   ToIsDiscussion = ws.Rows[p.Index].Cells[18].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[18].Value.ToString(),


  		




  507
  
  
    
                                   ToRemarks = ws.Rows[p.Index].Cells[19].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[19].Value.ToString(),


  		




  508
  
  
    
                                   ToCreator = ws.Rows[p.Index].Cells[20].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[20].Value.ToString()).ID,


  		




  509
  
  
    
                                   //toreview-21


  		




  510
  
  
    
                                   FrReviewStatus = ws.Rows[p.Index].Cells[22].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[22].Value.ToString(),


  		




  511
  
  
    
                                   FrRemarks = ws.Rows[p.Index].Cells[23].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[23].Value.ToString(),


  		




  512
  
  
    
                                   FrCreator = ws.Rows[p.Index].Cells[24].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[24].Value.ToString()).ID,


  		




  513
  
  
    
                                   //frreview-25


  		




  514
  
  
    
                                   ID2StartDate = ws.Rows[p.Index].Cells[26].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[26].Value?.ToString()),


  		




  515
  
  
    
                                   ID2EndDate = ws.Rows[p.Index].Cells[27].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[27].Value?.ToString()),


  		




  516
  
  
    
                                   ID2Status = ws.Rows[p.Index].Cells[28].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[28].Value.ToString(),


  		




  517
  
  
    
                                   ID2Issues = ws.Rows[p.Index].Cells[29].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[29].Value.ToString(),


  		




  518
  
  
    
                                   //id2work-30


  		




  519
  
  
    
                                   ReplyModifications = ws.Rows[p.Index].Cells[31].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[31].Value.ToString(),


  		




  520
  
  
    
                                   ReplyRequester = ws.Rows[p.Index].Cells[32].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[32].Value.ToString()).ID,


  		




  521
  
  
    
                                   IsConvert = ws.Rows[p.Index].Cells[33].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[33].Value.ToString(),


  		




  522
  
  
    
                                   AVEVAConvertDate = ws.Rows[p.Index].Cells[34].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[34].Value.ToString()),


  		




  523
  
  
    
                                   AVEVAWorkDate = ws.Rows[p.Index].Cells[35].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[35].Value.ToString()),


  		




  524
  
  
    
                                   AVEVAStatus = ws.Rows[p.Index].Cells[36].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[36].Value.ToString(),


  		




  525
  
  
    
                                   AVEVAIssues = ws.Rows[p.Index].Cells[37].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[37].Value.ToString(),


  		




  526
  
  
    
                                   AVEVAReviewDate = ws.Rows[p.Index].Cells[38].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[38].Value.ToString()),


  		




  527
  
  
    
                                   ProdReviewer = ws.Rows[p.Index].Cells[39].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[39].Value.ToString()).ID,


  		




  528
  
  
    
                                   ProdIsResult = ws.Rows[p.Index].Cells[40].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[40].Value.ToString(),


  		




  529
  
  
    
                                   ProdRemarks = ws.Rows[p.Index].Cells[41].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[41].Value.ToString(),


  		




  530
  
  
    
                                   ClientReviewer = ws.Rows[p.Index].Cells[42].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[42].Value.ToString()).ID,


  		




  531
  
  
    
                                   ClientIsResult = ws.Rows[p.Index].Cells[43].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[43].Value.ToString(),


  		




  532
  
  
    
                                   ClientRemarks = ws.Rows[p.Index].Cells[44].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[44].Value.ToString(),


  		




  533
  
  
    
                                   DTIsGateWay = ws.Rows[p.Index].Cells[45].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[45].Value.ToString(),


  		




  534
  
  
    
                                   DTIsImport = ws.Rows[p.Index].Cells[46].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[46].Value.ToString(),


  		




  535
  
  
    
                                   DTIsRegSystem = ws.Rows[p.Index].Cells[47].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[47].Value.ToString(),


  		




  536
  
  
    
                                   DTRemarks = ws.Rows[p.Index].Cells[48].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[48].Value.ToString()


  		




  
  498
  
    
                                   RefProjectCode = ws.Rows[p.Index].Cells[9].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[9].Value.ToString(),


  		




  
  499
  
    
                                   System = ws.Rows[p.Index].Cells[10].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[10].Value.ToString(),


  		




  
  500
  
    
                                   SubSystemCode = ws.Rows[p.Index].Cells[11].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[11].Value.ToString(),


  		




  
  501
  
    
                                   DocumentNo = ws.Rows[p.Index].Cells[12].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[12].Value.ToString(),


  		




  
  502
  
    
                                   PersonInCharge = ws.Rows[p.Index].Cells[13].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[13].Value.ToString()).ID,


  		




  
  503
  
    
                                   Worker = ws.Rows[p.Index].Cells[14].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[14].Value.ToString()).ID,


  		




  
  504
  
    
                                   AVEVAPersonInCharge = ws.Rows[p.Index].Cells[15].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[15].Value.ToString()).ID,


  		




  
  505
  
    
                                   AVEVAWorker = ws.Rows[p.Index].Cells[16].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[16].Value.ToString()).ID,


  		




  
  506
  
    
                                   Simularity = ws.Rows[p.Index].Cells[17].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[17].Value.ToString(),


  		




  
  507
  
    
                                   JobLevel = ws.Rows[p.Index].Cells[18].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[18].Value.ToString(),


  		




  
  508
  
    
                                   RevisonNo = ws.Rows[p.Index].Cells[19].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[19].Value.ToString(),


  		




  
  509
  
    
                                   ToIsDiscussion = ws.Rows[p.Index].Cells[20].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[20].Value.ToString(),


  		




  
  510
  
    
                                   ToRemarks = ws.Rows[p.Index].Cells[21].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[21].Value.ToString(),


  		




  
  511
  
    
                                   ToCreator = ws.Rows[p.Index].Cells[22].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[22].Value.ToString()).ID,


  		




  
  512
  
    
                                   //toreview-23


  		




  
  513
  
    
                                   FrReviewStatus = ws.Rows[p.Index].Cells[24].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[24].Value.ToString(),


  		




  
  514
  
    
                                   FrRemarks = ws.Rows[p.Index].Cells[25].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[25].Value.ToString(),


  		




  
  515
  
    
                                   FrCreator = ws.Rows[p.Index].Cells[26].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[26].Value.ToString()).ID,


  		




  
  516
  
    
                                   //frreview-27


  		




  
  517
  
    
                                   ID2StartDate = ws.Rows[p.Index].Cells[28].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[28].Value?.ToString()),


  		




  
  518
  
    
                                   ID2EndDate = ws.Rows[p.Index].Cells[29].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[29].Value?.ToString()),


  		




  
  519
  
    
                                   ID2Status = ws.Rows[p.Index].Cells[30].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[30].Value.ToString(),


  		




  
  520
  
    
                                   ID2Issues = ws.Rows[p.Index].Cells[31].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[31].Value.ToString(),


  		




  
  521
  
    
                                   //id2work-32


  		




  
  522
  
    
                                   ReplyModifications = ws.Rows[p.Index].Cells[33].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[33].Value.ToString(),


  		




  
  523
  
    
                                   ReplyRequester = ws.Rows[p.Index].Cells[34].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[34].Value.ToString()).ID,


  		




  
  524
  
    
                                   IsConvert = ws.Rows[p.Index].Cells[35].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[35].Value.ToString(),


  		




  
  525
  
    
                                   AVEVAConvertDate = ws.Rows[p.Index].Cells[36].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[36].Value.ToString()),


  		




  
  526
  
    
                                   AVEVAWorkDate = ws.Rows[p.Index].Cells[37].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[37].Value.ToString()),


  		




  
  527
  
    
                                   AVEVAStatus = ws.Rows[p.Index].Cells[38].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[38].Value.ToString(),


  		




  
  528
  
    
                                   AVEVAIssues = ws.Rows[p.Index].Cells[39].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[39].Value.ToString(),


  		




  
  529
  
    
                                   AVEVAReviewDate = ws.Rows[p.Index].Cells[40].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[40].Value.ToString()),


  		




  
  530
  
    
                                   ProdReviewer = ws.Rows[p.Index].Cells[41].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[41].Value.ToString()).ID,


  		




  
  531
  
    
                                   ProdIsResult = ws.Rows[p.Index].Cells[42].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[42].Value.ToString(),


  		




  
  532
  
    
                                   ProdRemarks = ws.Rows[p.Index].Cells[43].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[43].Value.ToString(),


  		




  
  533
  
    
                                   ClientReviewer = ws.Rows[p.Index].Cells[44].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[44].Value.ToString()).ID,


  		




  
  534
  
    
                                   ClientIsResult = ws.Rows[p.Index].Cells[45].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[45].Value.ToString(),


  		




  
  535
  
    
                                   ClientRemarks = ws.Rows[p.Index].Cells[46].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[46].Value.ToString(),


  		




  
  536
  
    
                                   DTIsGateWay = ws.Rows[p.Index].Cells[47].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[47].Value.ToString(),


  		




  
  537
  
    
                                   DTIsImport = ws.Rows[p.Index].Cells[48].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[48].Value.ToString(),


  		




  
  538
  
    
                                   DTIsRegSystem = ws.Rows[p.Index].Cells[49].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[49].Value.ToString(),


  		




  
  539
  
    
                                   DTRemarks = ws.Rows[p.Index].Cells[50].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[50].Value.ToString()


  		




  537
  540
  
    

  		




  538
  541
  
    
                                   /*


  		




  539
  542
  
    
                                   //UID = string.Empty,


  		












  

    
      ID2.Manager/ID2.Manager/Main.cs
    
  





  3025
  3025
  
    
                            templateWorksheet.Cells[rowIndex, 13].Value = this.GetUser(doc.Worker).Name;


  		




  3026
  3026
  
    
                            templateWorksheet.Cells[rowIndex, 14].Value = this.GetUser(doc.AVEVAPersonInCharge).Name;


  		




  3027
  3027
  
    
                            templateWorksheet.Cells[rowIndex, 15].Value = this.GetUser(doc.AVEVAWorker).Name;


  		




  3028
  
  
    
                            templateWorksheet.Cells[rowIndex, 16].Value = doc.JobLevel;


  		




  3029
  
  
    
                            templateWorksheet.Cells[rowIndex, 17].Value = doc.RevisonNo;


  		




  3030
  
  
    
                            templateWorksheet.Cells[rowIndex, 18].Value = doc.ToIsDiscussion;


  		




  3031
  
  
    
                            templateWorksheet.Cells[rowIndex, 19].Value = doc.ToRemarks;


  		




  3032
  
  
    
                            templateWorksheet.Cells[rowIndex, 20].Value = this.GetUser(doc.ToCreator).Name;


  		




  3033
  
  
    
                            //toreview-21


  		




  3034
  
  
    
                            templateWorksheet.Cells[rowIndex, 22].Value = doc.FrReviewStatus;


  		




  3035
  
  
    
                            templateWorksheet.Cells[rowIndex, 23].Value = doc.FrRemarks;


  		




  3036
  
  
    
                            templateWorksheet.Cells[rowIndex, 24].Value = this.GetUser(doc.FrCreator).Name;


  		




  3037
  
  
    
                            //frreview-25


  		




  3038
  
  
    
                            templateWorksheet.Cells[rowIndex, 26].Value = $"{doc.ID2StartDate:yyyy/MM/dd HH:mm:ss}";


  		




  3039
  
  
    
                            templateWorksheet.Cells[rowIndex, 27].Value = $"{doc.ID2EndDate:yyyy/MM/dd HH:mm:ss}";


  		




  3040
  
  
    
                            templateWorksheet.Cells[rowIndex, 28].Value = doc.ID2Status;


  		




  3041
  
  
    
                            templateWorksheet.Cells[rowIndex, 29].Value = doc.ID2Issues;


  		




  3042
  
  
    
                            //id2work-30


  		




  3043
  
  
    
                            templateWorksheet.Cells[rowIndex, 31].Value = doc.ReplyModifications;


  		




  3044
  
  
    
                            templateWorksheet.Cells[rowIndex, 32].Value = this.GetUser(doc.ReplyRequester).Name;


  		




  3045
  
  
    
                            templateWorksheet.Cells[rowIndex, 33].Value = doc.IsConvert;


  		




  3046
  
  
    
                            templateWorksheet.Cells[rowIndex, 34].Value = $"{doc.AVEVAConvertDate:yyyy/MM/dd}";


  		




  3047
  
  
    
                            templateWorksheet.Cells[rowIndex, 35].Value = $"{doc.AVEVAWorkDate:yyyy/MM/dd}";


  		




  3048
  
  
    
                            templateWorksheet.Cells[rowIndex, 36].Value = doc.AVEVAStatus;


  		




  3049
  
  
    
                            templateWorksheet.Cells[rowIndex, 37].Value = doc.AVEVAIssues;


  		




  3050
  
  
    
                            templateWorksheet.Cells[rowIndex, 38].Value = $"{doc.AVEVAReviewDate:yyyy/MM/dd}";


  		




  3051
  
  
    
                            templateWorksheet.Cells[rowIndex, 39].Value = this.GetUser(doc.ProdReviewer).Name;


  		




  3052
  
  
    
                            templateWorksheet.Cells[rowIndex, 40].Value = doc.ProdIsResult;


  		




  3053
  
  
    
                            templateWorksheet.Cells[rowIndex, 41].Value = doc.ProdRemarks;


  		




  3054
  
  
    
                            templateWorksheet.Cells[rowIndex, 42].Value = this.GetUser(doc.ClientReviewer).Name;


  		




  3055
  
  
    
                            templateWorksheet.Cells[rowIndex, 43].Value = doc.ClientIsResult;


  		




  3056
  
  
    
                            templateWorksheet.Cells[rowIndex, 44].Value = doc.ClientRemarks;


  		




  3057
  
  
    
                            templateWorksheet.Cells[rowIndex, 45].Value = doc.DTIsGateWay;


  		




  3058
  
  
    
                            templateWorksheet.Cells[rowIndex, 46].Value = doc.DTIsImport;


  		




  3059
  
  
    
                            templateWorksheet.Cells[rowIndex, 47].Value = doc.DTIsRegSystem;


  		




  3060
  
  
    
                            templateWorksheet.Cells[rowIndex, 48].Value = doc.DTRemarks;


  		




  
  3028
  
    
                            templateWorksheet.Cells[rowIndex, 16].Value = doc.Simularity;


  		




  
  3029
  
    
                            templateWorksheet.Cells[rowIndex, 17].Value = doc.JobLevel;


  		




  
  3030
  
    
                            templateWorksheet.Cells[rowIndex, 18].Value = doc.RevisonNo;


  		




  
  3031
  
    
                            templateWorksheet.Cells[rowIndex, 19].Value = doc.ToIsDiscussion;


  		




  
  3032
  
    
                            templateWorksheet.Cells[rowIndex, 20].Value = doc.ToRemarks;


  		




  
  3033
  
    
                            templateWorksheet.Cells[rowIndex, 21].Value = this.GetUser(doc.ToCreator).Name;


  		




  
  3034
  
    
                            //toreview-22


  		




  
  3035
  
    
                            templateWorksheet.Cells[rowIndex, 23].Value = doc.FrReviewStatus;


  		




  
  3036
  
    
                            templateWorksheet.Cells[rowIndex, 24].Value = doc.FrRemarks;


  		




  
  3037
  
    
                            templateWorksheet.Cells[rowIndex, 25].Value = this.GetUser(doc.FrCreator).Name;


  		




  
  3038
  
    
                            //frreview-26


  		




  
  3039
  
    
                            templateWorksheet.Cells[rowIndex, 27].Value = $"{doc.ID2StartDate:yyyy/MM/dd HH:mm:ss}";


  		




  
  3040
  
    
                            templateWorksheet.Cells[rowIndex, 28].Value = $"{doc.ID2EndDate:yyyy/MM/dd HH:mm:ss}";


  		




  
  3041
  
    
                            templateWorksheet.Cells[rowIndex, 29].Value = doc.ID2Status;


  		




  
  3042
  
    
                            templateWorksheet.Cells[rowIndex, 30].Value = doc.ID2Issues;


  		




  
  3043
  
    
                            //id2work-31


  		




  
  3044
  
    
                            templateWorksheet.Cells[rowIndex, 32].Value = doc.ReplyModifications;


  		




  
  3045
  
    
                            templateWorksheet.Cells[rowIndex, 33].Value = this.GetUser(doc.ReplyRequester).Name;


  		




  
  3046
  
    
                            templateWorksheet.Cells[rowIndex, 34].Value = doc.IsConvert;


  		




  
  3047
  
    
                            templateWorksheet.Cells[rowIndex, 35].Value = $"{doc.AVEVAConvertDate:yyyy/MM/dd}";


  		




  
  3048
  
    
                            templateWorksheet.Cells[rowIndex, 36].Value = $"{doc.AVEVAWorkDate:yyyy/MM/dd}";


  		




  
  3049
  
    
                            templateWorksheet.Cells[rowIndex, 37].Value = doc.AVEVAStatus;


  		




  
  3050
  
    
                            templateWorksheet.Cells[rowIndex, 38].Value = doc.AVEVAIssues;


  		




  
  3051
  
    
                            templateWorksheet.Cells[rowIndex, 39].Value = $"{doc.AVEVAReviewDate:yyyy/MM/dd}";


  		




  
  3052
  
    
                            templateWorksheet.Cells[rowIndex, 40].Value = this.GetUser(doc.ProdReviewer).Name;


  		




  
  3053
  
    
                            templateWorksheet.Cells[rowIndex, 41].Value = doc.ProdIsResult;


  		




  
  3054
  
    
                            templateWorksheet.Cells[rowIndex, 42].Value = doc.ProdRemarks;


  		




  
  3055
  
    
                            templateWorksheet.Cells[rowIndex, 43].Value = this.GetUser(doc.ClientReviewer).Name;


  		




  
  3056
  
    
                            templateWorksheet.Cells[rowIndex, 44].Value = doc.ClientIsResult;


  		




  
  3057
  
    
                            templateWorksheet.Cells[rowIndex, 45].Value = doc.ClientRemarks;


  		




  
  3058
  
    
                            templateWorksheet.Cells[rowIndex, 46].Value = doc.DTIsGateWay;


  		




  
  3059
  
    
                            templateWorksheet.Cells[rowIndex, 47].Value = doc.DTIsImport;


  		




  
  3060
  
    
                            templateWorksheet.Cells[rowIndex, 48].Value = doc.DTIsRegSystem;


  		




  
  3061
  
    
                            templateWorksheet.Cells[rowIndex, 49].Value = doc.DTRemarks;


  		




  3061
  3062
  
    

  		




  3062
  3063
  
    
                            /*


  		




  3063
  3064
  
    
                            templateWorksheet.Cells[rowIndex, 0].Value = doc.Seq;


  		












내보내기  Unified diff




        
        

    















   



  

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