개정판 c0420a29
issue #0000
ID2 작업시간 grid 실시간 반영되도록 수정
ID2 시작시간, 종료시간, 작업시간 은 readonly로 수정
Change-Id: Ib3393f4544fab1f4ff749e4d3b7f8e921c22ac0e
ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs | ||
---|---|---|
359 | 359 |
|
360 | 360 |
if @@rowcount > 0 |
361 | 361 |
begin |
362 |
select * from dbo.Documents where DocID=@DocID |
|
362 |
select *, datediff(SECOND, ID2StartDate, ID2EndDate) as ID2JobTime from dbo.Documents where DocID=@DocID
|
|
363 | 363 |
end |
364 | 364 |
else |
365 | 365 |
begin |
366 |
select * from dbo.Documents where 1=2 |
|
366 |
select *, 0 as ID2JobTime from dbo.Documents where 1=2
|
|
367 | 367 |
end;"; |
368 | 368 |
resultData = base.QueryFirstOrDefault<Documents>(query, parameters, transaction); |
369 | 369 |
} |
내보내기 Unified diff