/ - Diff - HYTOS - 일정관리

개정판 4b9f349c

ID	4b9f349c2e9022c0a3b4b9ed81e5e1c8e62d96bb
상위	ffdd8740
하위	69a2cc26, ee797ea5, c8f723a1

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

issue #0000
excel 관련 수정진행중
- import
- export
- excel 포멧

Change-Id: I19c8d12043705db1d8ae12f6b1f574dace0e224a

                     #region Excel 유효성검사
                     //Excel 포멧체크
                     if (rowCount < 10 || columnCount != 45)
                     if (rowCount < 10 || columnCount != 48)
+                    {
                         result.Error = "Please, check the excel.";
                         return result;
-...
                     #region 엑셀 필수값 체크(도면 : 이름,담당자, 난이도, Typical)
                     ExcelData.Where(col => col.ROW_INDEX > exRow)
                             .Where(col => col.COUMMN_INDEX > 5 && col.COUMMN_INDEX < 11 && col.ROW_INDEX > exRow && string.IsNullOrEmpty(col.VALUE))
                             .Where(col => col.COUMMN_INDEX > 7 && col.COUMMN_INDEX < 17 && col.ROW_INDEX > exRow && string.IsNullOrEmpty(col.VALUE))
                            .ToList()
                            .ForEach(p => sbErrMsg.Append(", " + p.TopLeftCell));
-...
+                    }
                     #endregion
                     #region 엑셀 도명명 중복 값 체크
                     ExcelData.Where(col => col.COUMMN_INDEX == 7 && col.ROW_INDEX > exRow)
                     #region 엑셀 도면명 중복 값 체크
                     ExcelData.Where(col => col.COUMMN_INDEX == 11 && col.ROW_INDEX > exRow)
                             .GroupBy(g => g.ROW_INDEX)
                             .Select(p => new
+                            {
-...
                             })
                             .GroupBy(g => g.docNo)
                             .Where(p => p.Count() > 1)
                             .Select(p => p.Select(x => (x.rowIndex + 1).ToString())
                             .Select(p => p.Select(x => x.rowIndex.ToString())
                                                                     .Aggregate((x, y) => x.ToString() + "," + y.ToString())
                                                                     .ToString())
                             .ToList().ForEach(p => sbErrMsg.Append("\n" + p.ToString()));
-...
                             switch (cell.COUMMN_INDEX)
+                            {
                                 case 6:
                                 case 8:
                                     document.RefProjectCode = value;
                                     break;
                                 case 7:
                                 case 9:
                                     document.System = value;
                                     break;
                                 case 10:
                                     document.SubSystemCode = value;
                                     break;
                                 case 11:
                                     document.DocumentNo = value;
                                     break;
                                 case 8:
                                 case 12:
                                     document.PersonInCharge = this.GetUser(value).ID;
                                     break;
                                 case 9:
                                 case 13:
                                     document.Worker = this.GetUser(value).ID;
                                     break;
                                 case 14:
                                     document.AVEVAPersonInCharge = this.GetUser(value).ID;
                                     break;
                                 case 15:
                                     document.AVEVAWorker = this.GetUser(value).ID;
                                     break;
                                 case 16:
                                     document.JobLevel = value;
                                     break;
                                 //case 10:
                                 //    document.IsTypical = value;
                                 //    break;
                                 case 11:
                                 case 17:
                                     document.RevisonNo = value;
                                     break;
                                 case 12:
                                 case 18:
                                     document.ToIsDiscussion = value;
                                     break;
                                 case 13:
                                 case 19:
                                     document.ToRemarks = value;
                                     break;
                                 case 14:
                                 case 20:
                                     document.ToCreator = this.GetUser(value).ID;
                                     break;
                                 case 15:
                                 case 21:
                                     if (value != null)
+                                    {
                                         if (document.AttFiles == null)
-...
                                         });
+                                    }
                                     break;
                                 case 17:
                                 case 22:
                                     document.FrReviewStatus = value;
                                     break;
                                 case 18:
                                 case 23:
                                     document.FrRemarks = value;
                                     break;
                                 case 19:
                                 case 24:
                                     document.FrCreator = this.GetUser(value).ID;
                                     break;
                                 case 20:
                                 case 25:
                                     if (value != null)
+                                    {
                                         if (document.AttFiles == null)
-...
                                         });
+                                    }
                                     break;
                                 //case 22:
                                 //    document.IsID2Work = value;
                                 //    break;
                                 case 24:
                                 case 26:
                                     document.ID2StartDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
                                     break;
                                 case 25:
                                 case 27:
                                     document.ID2EndDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
                                     break;
                                 case 27:
                                 case 28:
                                     document.ID2Status = value;
                                     break;
                                 case 28:
                                 case 29:
                                     document.ID2Issues = value;
                                     break;
                                 case 30:
                                     document.AVEVAConvertDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
                                     if (value != null)
+                                    {
                                         if (document.AttFiles == null)
+                                        {
                                             document.AttFiles = new List<AttFileInfo>();
+                                        }
                                         document.AttFiles.Add(new AttFileInfo
+                                        {
                                             FileID = Guid.NewGuid().ToString(),
                                             //RefID = document.DocID,
                                             Category = "id2work",
                                             FileType = "image/png",
                                             FileName = "ClipBoard",
                                             FilePath = "ClipBoard",
                                             FileExtension = ".png",
                                             CreatedDate = DateTime.Now,
                                             Creator = document.FrCreator,
                                             FileData = ExcelToImageData(value)
                                         });
+                                    }
                                     break;
                                 case 31:
                                     document.AVEVAReviewDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
                                     document.ReplyModifications = value;
                                     break;
                                 //case 31:추가필요
                                 //    document.AVEVAWorkDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
                                 //    break;
                                 case 32:
                                     document.AVEVAStatus = value;
                                     document.ReplyRequester = value;
                                     break;
                                 case 33:
                                     document.AVEVAIssues = value;
                                     document.IsConvert = value;
                                     break;
                                 case 34:
                                     document.AVEVAConvertDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
                                     break;
                                 case 35:
                                     document.AVEVAWorkDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
                                     break;
                                 case 36:
                                     document.ProdReviewer = this.GetUser(value).ID;
                                     document.AVEVAStatus = value;
                                     break;
                                 case 37:
                                     document.ProdIsResult = value;
                                     document.AVEVAIssues = value;
                                     break;
                                 case 38:
                                     document.ProdRemarks = value;
                                     document.AVEVAReviewDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);
                                     break;
                                 case 39:
                                     document.ClientReviewer = this.GetUser(value).ID;
                                     document.ProdReviewer = this.GetUser(value).ID;
                                     break;
                                 case 40:
                                     document.ClientIsResult = value;
                                     document.ProdIsResult = value;
                                     break;
                                 case 41:
                                     document.ClientRemarks = value;
                                     document.ProdRemarks = value;
                                     break;
                                 case 42:
                                     document.DTIsGateWay = value;
                                     document.ClientReviewer = this.GetUser(value).ID;
                                     break;
                                 case 43:
                                     document.DTIsImport = value;
                                     document.ClientIsResult = value;
                                     break;
                                 case 44:
                                     document.DTIsRegSystem = value;
                                     document.ClientRemarks = value;
                                     break;
                                 case 45:
                                     document.DTIsGateWay = value;
                                     break;
                                 case 46:
                                     document.DTIsImport = value;
                                     break;
                                 case 47:
                                     document.DTIsRegSystem = value;
                                     break;
                                 case 48:
                                     document.DTRemarks = value;
                                     break;
+                            }
+                        }
                         result.documents.Add(document);
-...
                     #region Excel 유효성검사
                     //Excel 포멧체크
                     if (rowCount < 10 || columnCount != 45)
                     if (rowCount < 10 || columnCount != 48)
+                    {
                         result.Error = "Please, check the excel.";
                         return result;
-...
                     #region 엑셀 필수값 체크(도면 : 이름,담당자, 난이도, Typical)
                     ws.Rows.SelectMany(row => row.AllocatedCells)
                            .Where(col => col.Column.Index > 5 && col.Column.Index < 10 && col.Row.Index > exRow && col.Value == null)
                            .Where(col => col.Column.Index > 7 && col.Column.Index < 17 && col.Row.Index > exRow && col.Value == null)
                            .ToList()
                            .ForEach(p => sbErrMsg.Append(", " + p.Column.Name + p.Row.Name));
-...
+                    }
                     #endregion
                     #region 엑셀 도명명 중복 값 체크
                     #region 엑셀 도면명 중복 값 체크
                     ws.Rows.SelectMany(row => row.AllocatedCells)
                                                  .Where(col => col.Column.Index == 6 && col.Row.Index > exRow)
                                                  .Where(col => col.Column.Index == 11 && col.Row.Index > exRow)
                                                  .GroupBy(g => g.Row.Index)
                                                  .Select(p => new
+                                                 {
-...
+                               {
                                    result.documents.Add(new Documents()
+                                   {
                                        RefProjectCode = ws.Rows[p.Index].Cells[7].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[7].Value.ToString(),
                                        System = ws.Rows[p.Index].Cells[8].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[8].Value.ToString(),
                                        SubSystemCode = ws.Rows[p.Index].Cells[9].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[9].Value.ToString(),
                                        DocumentNo = ws.Rows[p.Index].Cells[10].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[10].Value.ToString(),
                                        PersonInCharge = ws.Rows[p.Index].Cells[11].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[11].Value.ToString()).ID,
                                        Worker = ws.Rows[p.Index].Cells[12].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[12].Value.ToString()).ID,
                                        AVEVAPersonInCharge = ws.Rows[p.Index].Cells[13].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[13].Value.ToString()).ID,
                                        AVEVAWorker = ws.Rows[p.Index].Cells[14].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[14].Value.ToString()).ID,
                                        JobLevel = ws.Rows[p.Index].Cells[15].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[15].Value.ToString(),
                                        RevisonNo = ws.Rows[p.Index].Cells[16].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[16].Value.ToString(),
                                        ToIsDiscussion = ws.Rows[p.Index].Cells[17].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[17].Value.ToString(),
                                        ToRemarks = ws.Rows[p.Index].Cells[18].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[18].Value.ToString(),
                                        ToCreator = ws.Rows[p.Index].Cells[19].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[19].Value.ToString()).ID,
                                        //toreview-20
                                        FrReviewStatus = ws.Rows[p.Index].Cells[21].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[21].Value.ToString(),
                                        FrRemarks = ws.Rows[p.Index].Cells[22].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[22].Value.ToString(),
                                        FrCreator = ws.Rows[p.Index].Cells[23].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[23].Value.ToString()).ID,
                                        //frreview-24
                                        ID2StartDate = ws.Rows[p.Index].Cells[25].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[25].Value?.ToString()),
                                        ID2EndDate = ws.Rows[p.Index].Cells[26].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[26].Value?.ToString()),
                                        ID2Status = ws.Rows[p.Index].Cells[27].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[27].Value.ToString(),
                                        ID2Issues = ws.Rows[p.Index].Cells[28].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[28].Value.ToString(),
                                        //id2work-29
                                        ReplyModifications = ws.Rows[p.Index].Cells[30].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[30].Value.ToString(),
                                        ReplyRequester = ws.Rows[p.Index].Cells[31].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[31].Value.ToString(),
                                        IsConvert = ws.Rows[p.Index].Cells[32].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[32].Value.ToString(),
                                        AVEVAConvertDate = ws.Rows[p.Index].Cells[33].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[33].Value.ToString()),
                                        AVEVAWorkDate = ws.Rows[p.Index].Cells[34].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[34].Value.ToString()),
                                        AVEVAStatus = ws.Rows[p.Index].Cells[35].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[35].Value.ToString(),
                                        AVEVAIssues = ws.Rows[p.Index].Cells[36].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[36].Value.ToString(),
                                        AVEVAReviewDate = ws.Rows[p.Index].Cells[37].IsNullOrEmpty() ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[37].Value.ToString()),
                                        ProdReviewer = ws.Rows[p.Index].Cells[38].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[38].Value.ToString()).ID,
                                        ProdIsResult = ws.Rows[p.Index].Cells[39].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[39].Value.ToString(),
                                        ProdRemarks = ws.Rows[p.Index].Cells[40].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[40].Value.ToString(),
                                        ClientReviewer = ws.Rows[p.Index].Cells[41].IsNullOrEmpty() ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[41].Value.ToString()).ID,
                                        ClientIsResult = ws.Rows[p.Index].Cells[42].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[42].Value.ToString(),
                                        ClientRemarks = ws.Rows[p.Index].Cells[43].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[43].Value.ToString(),
                                        DTIsGateWay = ws.Rows[p.Index].Cells[44].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[44].Value.ToString(),
                                        DTIsImport = ws.Rows[p.Index].Cells[45].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[45].Value.ToString(),
                                        DTIsRegSystem = ws.Rows[p.Index].Cells[46].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[46].Value.ToString(),
                                        DTRemarks = ws.Rows[p.Index].Cells[47].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[47].Value.ToString()
                                        /*
                                        //UID = string.Empty,
                                        //Type = this.radTextBoxInsulationType.Text,
                                        //TempFrom = ws.Rows[exRow].Cells[p.Column.Index].IsNullOrEmpty() ? 0 : Convert.ToSingle(ws.Rows[exRow].Cells[p.Column.Index].Value),
-...
                                        DTIsImport = ws.Rows[p.Index].Cells[42].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[42].Value.ToString(),
                                        DTIsRegSystem = ws.Rows[p.Index].Cells[43].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[43].Value.ToString(),
                                        DTRemarks = ws.Rows[p.Index].Cells[44].IsNullOrEmpty() ? string.Empty : ws.Rows[p.Index].Cells[44].Value.ToString()
                                        */
                                    });
+                                }
                                catch (Exception ex)

+                }
+            }
             private void RadButtonElementExcelImport_Click_old(object sender, EventArgs e)
+            {
                 using (OpenFileDialog ofd = new OpenFileDialog()
+                {
                     Filter = "Excel files (*.xlsx)|*.xlsx",
                     Title = "Open an Excel File",
                     RestoreDirectory = true
                 })
+                {
                     if (ofd.ShowDialog() == DialogResult.OK)
+                    {
                         //Error Message
                         StringBuilder sbErrMsg = new StringBuilder();
                         var exFile = ExcelFile.Load(ofd.FileName);
                         var ws = exFile.Worksheets[0];
                         int rowCount = ws.Rows.Count;
                         int columnCount = ws.CalculateMaxUsedColumns();
                         int exRow = 8;
     #region Excel 유효성검사
                         //Excel 포멧체크
                         if (rowCount < 10 || columnCount != 45)
+                        {
                             RadMessageBox.Show("Please, check the excel.\n", "Information", MessageBoxButtons.OK, RadMessageIcon.Info);
                             return;
+                        }
     #region 엑셀 필수값 체크(도면 : 이름,담당자, 난이도, Typical)
                         ws.Rows.SelectMany(row => row.AllocatedCells)
                                .Where(col => col.Column.Index > 5 && col.Column.Index < 10 && col.Row.Index > exRow && col.Value == null)
                                .ToList()
                                .ForEach(p => sbErrMsg.Append(", " + p.Column.Name + p.Row.Name));
                         if (sbErrMsg.Length > 0)
+                        {
                             string errMsg = sbErrMsg.ToString().Substring(2);
                             if (errMsg.Length > 100)
+                            {
                                 errMsg = $"{errMsg.Substring(0, 100)}...";
+                            }
                             RadMessageBox.Show($"Please, check null value in excel.\n{errMsg}", "Information", MessageBoxButtons.OK, RadMessageIcon.Info);
                             return;
+                        }
     #endregion
     #region 엑셀 도명명 중복 값 체크
                         ws.Rows.SelectMany(row => row.AllocatedCells)
                                                      .Where(col => col.Column.Index == 6 && col.Row.Index > exRow)
                                                      .GroupBy(g => g.Row.Index)
                                                      .Select(p => new {
                                                          rowIndex = p.Key,
                                                          docNo = p.Select(x => x.Value.ToString()).FirstOrDefault()
                                                      })
                                                      .GroupBy(g => g.docNo)
                                                      .Where(p => p.Count() > 1)
                                                      .Select(p => p.Select(x => (x.rowIndex + 1).ToString())
                                                                                                 .Aggregate((x, y) => x.ToString() + "," + y.ToString())
                                                                                                 .ToString())
                                                      .ToList().ForEach(p => sbErrMsg.Append("\n" + p.ToString()));
                         if (sbErrMsg.Length > 0)
+                        {
                             sbErrMsg.Insert(0, "\n중복 된 도면명 Excel row : ");
                             string errMsg = sbErrMsg.ToString();
                             if (errMsg.Length > 100)
+                            {
                                 errMsg = $"{errMsg.Substring(0, 100)}...";
+                            }
                             RadMessageBox.Show($"Please, check the duplicate value in excel.\n{errMsg}", "Information", MessageBoxButtons.OK, RadMessageIcon.Info);
                             return;
+                        }
     #endregion
     #endregion
                         List<Documents> appendDocuments = new List<Documents>();
                         ws.Rows.Where(row => row.Index > exRow)
                                .ToList()
                                .ForEach(p => appendDocuments.Add(new Documents()
+                               {
                                    //UID = string.Empty,
                                    //Type = this.radTextBoxInsulationType.Text,
                                    //TempFrom = ws.Rows[exRow].Cells[p.Column.Index].Value == null ? 0 : Convert.ToSingle(ws.Rows[exRow].Cells[p.Column.Index].Value),
                                    //TempTo = ws.Rows[exRow + 2].Cells[p.Column.Index].Value == null ? 0 : Convert.ToSingle(ws.Rows[exRow + 2].Cells[p.Column.Index].Value),
                                    //NPS = ws.Rows[p.Row.Index].Cells[0].Value == null ? 0 : Convert.ToSingle(ws.Rows[p.Row.Index].Cells[0].Value),
                                    //Thickness = p.Value == null ? 0 : Convert.ToSingle(p.Value)
                                    RefProjectCode = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),
                                    DocumentNo = ws.Rows[p.Index].Cells[6].Value == null ? string.Empty : ws.Rows[p.Index].Cells[6].Value.ToString(),
                                    PersonInCharge = ws.Rows[p.Index].Cells[7].Value == null ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[7].Value.ToString()).ID,
                                    JobLevel = ws.Rows[p.Index].Cells[8].Value == null ? string.Empty : ws.Rows[p.Index].Cells[8].Value.ToString(),
                                    //IsTypical = ws.Rows[p.Index].Cells[9].Value == null ? string.Empty : ws.Rows[p.Index].Cells[9].Value.ToString(),
                                    RevisonNo = ws.Rows[p.Index].Cells[10].Value == null ? string.Empty : ws.Rows[p.Index].Cells[10].Value.ToString(),
                                    ToIsDiscussion = ws.Rows[p.Index].Cells[11].Value == null ? string.Empty : ws.Rows[p.Index].Cells[11].Value.ToString(),
                                    ToRemarks = ws.Rows[p.Index].Cells[12].Value == null ? string.Empty : ws.Rows[p.Index].Cells[12].Value.ToString(),
                                    ToCreator = ws.Rows[p.Index].Cells[13].Value == null ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[13].Value.ToString()).ID,
                                    //ToCapture = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),
                                    //ToIsMarkup = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),
                                    FrReviewStatus = ws.Rows[p.Index].Cells[16].Value == null ? string.Empty : ws.Rows[p.Index].Cells[16].Value.ToString(),
                                    FrRemarks = ws.Rows[p.Index].Cells[17].Value == null ? string.Empty : ws.Rows[p.Index].Cells[17].Value.ToString(),
                                    FrCreator = ws.Rows[p.Index].Cells[18].Value == null ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[18].Value.ToString()).ID,
                                    //FrCapture = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),
                                    //FrIsMarkup = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),
                                    //IsID2Work = ws.Rows[p.Index].Cells[21].Value == null ? string.Empty : ws.Rows[p.Index].Cells[21].Value.ToString(),
                                    //ID2Connection = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),
                                    ID2StartDate = ws.Rows[p.Index].Cells[23].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[23].Value?.ToString()),
                                    ID2EndDate = ws.Rows[p.Index].Cells[24].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[24].Value?.ToString()),
                                    //ID2JobTime = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),
                                    ID2Status = ws.Rows[p.Index].Cells[26].Value == null ? string.Empty : ws.Rows[p.Index].Cells[26].Value.ToString(),
                                    ID2Issues = ws.Rows[p.Index].Cells[27].Value == null ? string.Empty : ws.Rows[p.Index].Cells[27].Value.ToString(),
                                    //AVEVAConnection = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),
                                    AVEVAConvertDate = ws.Rows[p.Index].Cells[29].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[29].Value.ToString()),
                                    AVEVAReviewDate = ws.Rows[p.Index].Cells[30].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[30].Value.ToString()),
                                    //추가필요 AVEVAWorkDate = ws.Rows[p.Index].Cells[30].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[30].Value.ToString()),
                                    AVEVAStatus = ws.Rows[p.Index].Cells[31].Value == null ? string.Empty : ws.Rows[p.Index].Cells[31].Value.ToString(),
                                    AVEVAIssues = ws.Rows[p.Index].Cells[32].Value == null ? string.Empty : ws.Rows[p.Index].Cells[32].Value.ToString(),
                                    ProdReviewer = ws.Rows[p.Index].Cells[35].Value == null ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[35].Value.ToString()).ID,
                                    ProdIsResult = ws.Rows[p.Index].Cells[36].Value == null ? string.Empty : ws.Rows[p.Index].Cells[36].Value.ToString(),
                                    ProdRemarks = ws.Rows[p.Index].Cells[37].Value == null ? string.Empty : ws.Rows[p.Index].Cells[37].Value.ToString(),
                                    ClientReviewer = ws.Rows[p.Index].Cells[38].Value == null ? string.Empty : this.GetUser(ws.Rows[p.Index].Cells[38].Value.ToString()).ID,
                                    ClientIsResult = ws.Rows[p.Index].Cells[39].Value == null ? string.Empty : ws.Rows[p.Index].Cells[39].Value.ToString(),
                                    ClientRemarks = ws.Rows[p.Index].Cells[40].Value == null ? string.Empty : ws.Rows[p.Index].Cells[40].Value.ToString(),
                                    DTIsGateWay = ws.Rows[p.Index].Cells[41].Value == null ? string.Empty : ws.Rows[p.Index].Cells[41].Value.ToString(),
                                    DTIsImport = ws.Rows[p.Index].Cells[42].Value == null ? string.Empty : ws.Rows[p.Index].Cells[42].Value.ToString(),
                                    DTIsRegSystem = ws.Rows[p.Index].Cells[43].Value == null ? string.Empty : ws.Rows[p.Index].Cells[43].Value.ToString(),
                                    DTRemarks = ws.Rows[p.Index].Cells[44].Value == null ? string.Empty : ws.Rows[p.Index].Cells[44].Value.ToString()
                                }));
                         this.documents.AddRange(appendDocuments);
                         if (this.orgDocuments == null) this.orgDocuments = new List<Documents>();
                         this.DocumentListBinding();
                         //foreach (Documents appDoc in appendDocuments)
                         //{
                         //    GridViewRowInfo rowInfo = this.radGridViewDocuments.Rows.AddNew();
                         //    foreach (FieldInfo fieldInfo in appDoc.GetType().GetFields(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly))
                         //    {
                         //        if (fieldInfo.GetValue(appDoc) != null)
                         //        {
                         //            var cols = rowInfo.Cells.Where(x => fieldInfo.Name.Contains($"<{x.ColumnInfo.Name}>"));
                         //            if (cols.Any())
                         //            {
                         //                cols.FirstOrDefault().Value = fieldInfo.GetValue(appDoc);
                         //            }
                         //        }
                         //    }
                         //}
+                    }
+                }
+            }
             private void RadButtonElementExcelExport_Click(object sender, EventArgs e)
+            {
                 string sPrefixName = "Samsung Elec Task Management";
-...
+                        {
                             int rowIndex = 9;
                             //int colIndex = 1;
                             int rowNo = 1;
                             foreach (var row in this.radGridViewDocuments.Rows)
+                            {
                                 var doc = row.DataBoundItem as Documents;
                                 templateWorksheet.Cells[rowIndex, 0].Value = rowNo++;
                                 templateWorksheet.Cells[rowIndex, 7].Value = doc.RefProjectCode;
                                 templateWorksheet.Cells[rowIndex, 8].Value = doc.System;
                                 templateWorksheet.Cells[rowIndex, 9].Value = doc.SubSystemCode;
                                 templateWorksheet.Cells[rowIndex, 10].Value = doc.DocumentNo;
                                 templateWorksheet.Cells[rowIndex, 11].Value = this.GetUser(doc.PersonInCharge).Name;
                                 templateWorksheet.Cells[rowIndex, 12].Value = this.GetUser(doc.Worker).Name;
                                 templateWorksheet.Cells[rowIndex, 13].Value = this.GetUser(doc.AVEVAPersonInCharge).Name;
                                 templateWorksheet.Cells[rowIndex, 14].Value = this.GetUser(doc.AVEVAWorker).Name;
                                 templateWorksheet.Cells[rowIndex, 15].Value = doc.JobLevel;
                                 templateWorksheet.Cells[rowIndex, 16].Value = doc.RevisonNo;
                                 templateWorksheet.Cells[rowIndex, 17].Value = doc.ToIsDiscussion;
                                 templateWorksheet.Cells[rowIndex, 18].Value = doc.ToRemarks;
                                 templateWorksheet.Cells[rowIndex, 19].Value = this.GetUser(doc.ToCreator).Name;
                                 //toreview-20
                                 templateWorksheet.Cells[rowIndex, 21].Value = doc.FrReviewStatus;
                                 templateWorksheet.Cells[rowIndex, 22].Value = doc.FrRemarks;
                                 templateWorksheet.Cells[rowIndex, 23].Value = this.GetUser(doc.FrCreator).Name;
                                 //frreview-24
                                 templateWorksheet.Cells[rowIndex, 25].Value = $"{doc.ID2StartDate:yyyy/MM/dd hh:mm:ss}";
                                 templateWorksheet.Cells[rowIndex, 26].Value = $"{doc.ID2EndDate:yyyy/MM/dd hh:mm:ss}";
                                 templateWorksheet.Cells[rowIndex, 27].Value = doc.ID2Status;
                                 templateWorksheet.Cells[rowIndex, 28].Value = doc.ID2Issues;
                                 //id2work-29
                                 templateWorksheet.Cells[rowIndex, 30].Value = doc.ReplyModifications;
                                 templateWorksheet.Cells[rowIndex, 31].Value = this.GetUser(doc.ReplyRequester).Name;
                                 templateWorksheet.Cells[rowIndex, 32].Value = doc.IsConvert;
                                 templateWorksheet.Cells[rowIndex, 33].Value = $"{doc.AVEVAConvertDate:yyyy/MM/dd}";
                                 templateWorksheet.Cells[rowIndex, 34].Value = $"{doc.AVEVAWorkDate:yyyy/MM/dd}";
                                 templateWorksheet.Cells[rowIndex, 35].Value = doc.AVEVAStatus;
                                 templateWorksheet.Cells[rowIndex, 36].Value = doc.AVEVAIssues;
                                 templateWorksheet.Cells[rowIndex, 37].Value = $"{doc.AVEVAReviewDate:yyyy/MM/dd}";
                                 templateWorksheet.Cells[rowIndex, 38].Value = this.GetUser(doc.ProdReviewer).Name;
                                 templateWorksheet.Cells[rowIndex, 39].Value = doc.ProdIsResult;
                                 templateWorksheet.Cells[rowIndex, 40].Value = doc.ProdRemarks;
                                 templateWorksheet.Cells[rowIndex, 41].Value = this.GetUser(doc.ClientReviewer).Name;
                                 templateWorksheet.Cells[rowIndex, 42].Value = doc.ClientIsResult;
                                 templateWorksheet.Cells[rowIndex, 43].Value = doc.ClientRemarks;
                                 templateWorksheet.Cells[rowIndex, 44].Value = doc.DTIsGateWay;
                                 templateWorksheet.Cells[rowIndex, 45].Value = doc.DTIsImport;
                                 templateWorksheet.Cells[rowIndex, 46].Value = doc.DTIsRegSystem;
                                 templateWorksheet.Cells[rowIndex, 47].Value = doc.DTRemarks;
                                 /*
                                 templateWorksheet.Cells[rowIndex, 0].Value = doc.Seq;
                                 //templateWorksheet.Cells[rowIndex, 1].Value = doc.DocumentNo;
                                 //templateWorksheet.Cells[rowIndex, 2].Value = doc.DocumentNo;
-...
                                 templateWorksheet.Cells[rowIndex, 42].Value = doc.DTIsImport;
                                 templateWorksheet.Cells[rowIndex, 43].Value = doc.DTIsRegSystem;
                                 templateWorksheet.Cells[rowIndex, 44].Value = doc.DTRemarks;
                                 */
                                 rowIndex++;
+                            }
+                        }
-...
                 List<string> docInfoColNames = new List<string>() { "RefProjectCode", "System", "SubSystemCode", "DocumentNo", "PersonInCharge", "Worker", "AVEVAPersonInCharge", "AVEVAWorker", "JobLevel", "RevisonNo" };
                 List<string> rvToColNames = new List<string>() { "ToIsDiscussion", "ToRemarks", "ToCreator", "ToCapture" };
                 List<string> rvFrColNames = new List<string>() { "FrReviewStatus", "FrRemarks", "FrCreator", "FrCapture" };
                 List<string> wkID2ColNames = new List<string>() { "ID2StartDate", "ID2EndDate", "ID2Status", "ID2Issues", "ID2Capture", "ReplyModifications", "ReplyRequester", "IsConvert" };
                 List<string> wkAVEVAColNames = new List<string>() { "AVEVAConvertDate", "AVEVAWorkDate", "AVEVAStatus", "AVEVAIssues" };
                 List<string> wkID2ColNames = new List<string>() { "ID2StartDate", "ID2EndDate", "ID2Status", "ID2Issues", "ID2Capture", "ReplyModifications", "ReplyRequester" };
                 List<string> wkAVEVAColNames = new List<string>() { "IsConvert", "AVEVAConvertDate", "AVEVAWorkDate", "AVEVAStatus", "AVEVAIssues" };
                 List<string> valProdColNames = new List<string>() { "AVEVAReviewDate", "ProdReviewer", "ProdIsResult", "ProdRemarks" };
                 List<string> valCntColNames = new List<string>() { "ClientReviewer", "ClientIsResult", "ClientRemarks" };
                 List<string> dtColNames = new List<string>() { "DTIsGateWay", "DTIsImport", "DTIsRegSystem", "DTRemarks" };

내보내기 Unified diff

프로젝트

일반

사용자정보

HYTOS

개정판 4b9f349c