/ - Diff - HYTOS - 일정관리

개정판 57ea162e

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

issue #0000
excel import
- row 순서대로 정렬
- capture 있을 경우 이미지 아이콘 보이도록 수정

Change-Id: I27a7fb54949ef5ac8f96e8222cac7040b02b41fc

                         var document = new Documents();
                         //document.DocID = Guid.NewGuid().ToString();
                         int toreview = 0;
                         int frreview = 0;
                         int id2work = 0;
                         foreach (var cell in row.OrderBy(x=>x.COUMMN_INDEX))
+                        {
                             var value = cell.VALUE.DefalutValue();
-...
                                             FileData = ExcelToImageData(value)
                                         });
                                         document.ToCapture = ++toreview;
+                                    }
                                     break;
                                 case 22:
-...
                                             FileData = ExcelToImageData(value)
                                         });
                                         document.FrCapture = ++frreview;
+                                    }
                                     break;
                                 case 26:
-...
                                             FileData = ExcelToImageData(value)
                                         });
                                         document.ID2Capture = ++id2work;
+                                    }
                                     break;
                                 case 31:

ID2.Manager/ID2.Manager.Dapper/Repository/ExcelDataRepository.cs
16	16	{
17	17	try
18	18	{
19		string query = $@"select * from dbo.ImportExcel where [FILE_NAME] = @FileName and WORKSHEET_NAME = @WorksheetName";
	19	string query = $@"select * from dbo.ImportExcel where [FILE_NAME] = @FileName and WORKSHEET_NAME = @WorksheetName order by ROW_INDEX, COUMMN_INDEX";
20	20	var dynamicParameters = new DynamicParameters();
21	21	dynamicParameters.Add("@FileName", FileName);
22	22	dynamicParameters.Add("@WorksheetName", WorksheetName);

내보내기 Unified diff