개정판 fe310cac
issue #0000
작업시간 삭제
- Main 화면(crud 포함)
- ID2 Connection 시 자동계산 로직 삭제
- Model에서 제거
Change-Id: If868c2ff52188d7e60009a48d8e7ea7c62df7fc1
| ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs | ||
|---|---|---|
| 196 | 196 |
{
|
| 197 | 197 |
|
| 198 | 198 |
//files.[FileID],files.[FileID] as AttFileID, files.RefID, files.Category, files.FileType, files.FileName, files.FilePath, files.FileExtension, files.FileData, files.Remark, files.CreatedDate, files.Creator, |
| 199 |
string query = $@"
|
|
| 200 |
select doc.*, datediff(SECOND, doc.ID2StartDate, doc.ID2EndDate) as ID2JobTime,
|
|
| 201 |
files.[FileID] as FileID, files.*,
|
|
| 202 |
markus.PROJECT_NO as PROJECT_NO, markus.*
|
|
| 203 |
from dbo.Documents doc
|
|
| 204 |
LEFT OUTER JOIN AttachFIles files ON doc.DocID = fIles.RefID
|
|
| 205 |
LEFT OUTER JOIN
|
|
| 206 |
(SELECT [PROJECT_NO] as PROJECT_NO
|
|
| 207 |
,[DOCUMENT_ID] as DocumentNo
|
|
| 199 |
string query = $@" |
|
| 200 |
select doc.*,
|
|
| 201 |
files.[FileID] as FileID, files.*, |
|
| 202 |
markus.PROJECT_NO as PROJECT_NO, markus.* |
|
| 203 |
from dbo.Documents doc |
|
| 204 |
LEFT OUTER JOIN AttachFIles files ON doc.DocID = fIles.RefID |
|
| 205 |
LEFT OUTER JOIN |
|
| 206 |
(SELECT [PROJECT_NO] as PROJECT_NO |
|
| 207 |
,[DOCUMENT_ID] as DocumentNo |
|
| 208 | 208 |
|
| 209 |
,[PAGENUMBER]
|
|
| 210 |
,[Text] as TEXT
|
|
| 211 |
,[CREATE_DATE] as CREATE_DATE
|
|
| 212 |
,[NAME] as CREATE_USER
|
|
| 213 |
FROM ViewMarkupData) markus
|
|
| 214 |
ON doc.DocumentNo = markus.DocumentNo
|
|
| 215 |
where doc.IsDeleted=0 {sbWhere}
|
|
| 216 |
order by doc.Seq
|
|
| 209 |
,[PAGENUMBER] |
|
| 210 |
,[Text] as TEXT |
|
| 211 |
,[CREATE_DATE] as CREATE_DATE |
|
| 212 |
,[NAME] as CREATE_USER |
|
| 213 |
FROM ViewMarkupData) markus |
|
| 214 |
ON doc.DocumentNo = markus.DocumentNo |
|
| 215 |
where doc.IsDeleted=0 {sbWhere}
|
|
| 216 |
order by doc.Seq |
|
| 217 | 217 |
|
| 218 | 218 |
select @Total=count(*) from dbo.Documents doc where doc.IsDeleted=0 {sbTotalWhere}
|
| 219 | 219 |
select @Total;"; |
| ... | ... | |
| 615 | 615 |
|
| 616 | 616 |
if @@rowcount > 0 |
| 617 | 617 |
begin |
| 618 |
select *, datediff(SECOND, ID2StartDate, ID2EndDate) as ID2JobTime from dbo.Documents where DocID=@DocID
|
|
| 618 |
select * from dbo.Documents where DocID=@DocID |
|
| 619 | 619 |
end |
| 620 | 620 |
else |
| 621 | 621 |
begin |
| 622 |
select *, 0 as ID2JobTime from dbo.Documents where 1=2
|
|
| 622 |
select * from dbo.Documents where 1=2 |
|
| 623 | 623 |
end;"; |
| 624 | 624 |
resultData = base.QueryFirstOrDefault<Documents>(query, parameters, transaction); |
| 625 | 625 |
} |
내보내기 Unified diff
