/ID2.Manager/ID2.Manager.Dapper/Repository/ID2Repository.cs - Diff - HYTOS - 일정관리

개정판 473ee829

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

issue #0000
Project 정보 수정
ID2 Project DB의 정보를 ID2 Manager와 매핑

Change-Id: Idcc82a34b8027032529cbc43a62757ea6d48f586

                 try
+                {
                     string query = $@"
     SELECT p.*
     FROM Projects p
     INNER JOIN (
     SELECT Min(Id) AS Id, Name
     FROM Projects pg
     WHERE ifnull(Name, '') <> ''
     GROUP BY Name
     ) pg ON p.ID=pg.Id
     ORDER BY p.Id;";
     select    pj.Id, pj.ProjectID, pj.ProjectNo, pj.Name, pj.Desc, pj.Unit, pj.NPSUnit, pj.Path, pj.AreaName, pj.PlantName, pj.CreatedDate, pj.UpdatedDate
              ,ty.UID as DBTypeID ,ty.Name as DBTypeName
              ,db.Host, db.User, db.Password, db.FilePath as DBPath
     from      (
                   select p.*
                   from   Projects p
                          inner join
+                         (
                              select Min(Id) as Id, Name
                              from   Projects
                              where  ifnull(Name, '') <> ''
                              group by Name
                          ) g on p.Id=g.Id
               ) pj
                   inner join DBSettings db on pj.Id=db.Projects_UID
                   inner join DBTypes ty on db.DBTypes_UID=ty.UID
     order  by pj.Id;";
                     results = Query<ID2ProjectInfo>(query);
+                }

내보내기 Unified diff