프로젝트

일반

사용자정보

개정판 be38bb2e

IDbe38bb2e8ea9beb176ffbad29d9e09956a9a3b78
상위 3bea5944
하위 378846cd

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

issue #0000
유사도2 추가
- 조회,수정,삭제,model,excel(import,export),ui

Change-Id: Iae5e69b4f602310b23dea9b3cdd56a90bbac2f5d

차이점 보기:

ID2.Manager/ID2.Manager.Common/Helpers/ID2Excel.cs
493 493 
                       {
494 494 
                           try
495 495 
                           {
496 
                               result.documents.Add(new Documents()
497 
                               {
496 
                               int colIndex = 9;
497 
                               var docInfo = new Documents();
498 
                               docInfo.RefProjectCode = ws.Rows[p.Index].Cells[colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
499 
                               docInfo.System = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
500 
                               docInfo.SubSystemCode = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
501 
                               docInfo.DocumentNo = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
502 
                               docInfo.PersonInCharge = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID;
503 
                               docInfo.Worker = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID;
504 
                               docInfo.AVEVAPersonInCharge = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID;
505 
                               docInfo.AVEVAWorker = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID;
506 
                               docInfo.Simularity = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
507 
                               docInfo.Simularity2 = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
508 
                               docInfo.JobLevel = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
509 
                               docInfo.RevisonNo = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
510 
                               docInfo.ToIsDiscussion = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
511 
                               docInfo.ToRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
512 
                               docInfo.ToCreator = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID;
513 
                               ++colIndex;//toreview-24
514 
                               docInfo.FrReviewStatus = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
515 
                               docInfo.FrRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
516 
                               docInfo.FrCreator = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID;
517 
                               ++colIndex;//frreview-28
518 
                               docInfo.ID2StartDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value?.ToString());
519 
                               docInfo.ID2EndDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value?.ToString());
520 
                               docInfo.ID2Status = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
521 
                               docInfo.ID2Issues = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
522 
                               ++colIndex;//id2work-33
523 
                               docInfo.ReplyModifications = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
524 
                               docInfo.ReplyRequester = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID;
525 
                               docInfo.IsConvert = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
526 
                               docInfo.AVEVAConvertDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value.ToString());
527 
                               docInfo.AVEVAWorkDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value.ToString());
528 
                               docInfo.AVEVAStatus = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
529 
                               docInfo.AVEVAIssues = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
530 
                               docInfo.AVEVAReviewDate = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[colIndex].Value.ToString());
531 
                               docInfo.ProdReviewer = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID;
532 
                               docInfo.ProdIsResult = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
533 
                               docInfo.ProdRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
534 
                               docInfo.ClientReviewer = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[colIndex].Value.ToString()).ID;
535 
                               docInfo.ClientIsResult = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
536 
                               docInfo.ClientRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
537 
                               docInfo.DTIsGateWay = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
538 
                               docInfo.DTIsImport = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
539 
                               docInfo.DTIsRegSystem = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
540 
                               docInfo.DTRemarks = ws.Rows[p.Index].Cells[++colIndex].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[colIndex].Value.ToString();
541 
                               result.documents.Add(docInfo);
542 

  		




  
  543
  
    
                               //result.documents.Add(new Documents()


  		




  
  544
  
    
                               //{


  		




  
  545
  
    
                                   /*


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  
  588
  
    
                                   */


  		




  540
  589
  
    

  		




  541
  590
  
    
                                   /*


  		




  542
  591
  
    
                                   //UID = string.Empty,


  		




  ......




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


  		




  587
  636
  
    
                                   DTRemarks = ws.Rows[p.Index].Cells[44].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[44].Value.ToString()


  		




  588
  637
  
    
                                   */


  		




  589
  
  
    
                               });


  		




  
  638
  
    
                               //});


  		




  590
  639
  
    
                           }


  		




  591
  640
  
    
                           catch (Exception ex)


  		




  592
  641
  
    
                           {


  		












내보내기  Unified diff




        
        

    















   



  

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