/ - Diff - HYTOS - 일정관리

개정판 4142eefa

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

issue #0000
공지사항(notice) 수정
- 기존 공지사항 삭제하지 않도록 수정

Change-Id: I5173bcea3472174f25c11587a29964023fc518ab

                 try
+                {
                     string query = $@"
     select top 1 * from dbo.AttachFIles where RefID=@RefID and Category=@Category order by CreatedDate";
     select top 1 * from dbo.AttachFIles where RefID=@RefID and Category=@Category order by CreatedDate desc";
                     return QueryFirstOrDefault<AttFileInfo>(query, new { RefID = refID, Category = category });
+                }
                 catch (Exception ex)
-...
                         foreach (AttFileInfo attFile in attFiles)
+                        {
                             attFile.Creator = userId;
                             switch (attFile.Category)
+                            {
                                 case "notice":
                                     query = $@"delete dbo.AttachFIles where RefID=@RefID and Category=@Category";
                                     break;
+                            }
                             query += $@"
                             query = $@"
     insert into dbo.AttachFIles (FileID,RefID,Category,FileType,FileName,FilePath,FileExtension,FileData,Creator)
     values
+    (
-...
        ,@FileData
        ,@Creator
     )";
                             base.Execute(query, attFile, transaction);
+                        }

내보내기 Unified diff