개정판 902f397c
DatabaseFilter 수정
Change-Id: I44d6697b18f74f21cd98d46243a56e1d3b50cc26
| ConvertService/ServiceBase/Markus.Service.DataBase/ConvertDatabase.cs | ||
|---|---|---|
| 84 | 84 |
join documents in entities.DOCUMENT_ITEM on items.DOCUMENT_ID equals documents.DOCUMENT_ID into GroupItems |
| 85 | 85 |
from subpet in GroupItems.DefaultIfEmpty() |
| 86 | 86 |
where items.STATUS == status |
| 87 |
orderby items.CREATE_DATETIME descending |
|
| 88 |
select new |
|
| 89 |
{
|
|
| 90 |
ID = items.ID, |
|
| 91 |
DOCUMENT_URL = items.DOCUMENT_URL, |
|
| 92 |
RECONVERTER = items.RECONVERTER, |
|
| 93 |
SERVICE_ID = items.SERVICE_ID, |
|
| 94 |
STATUS = items.STATUS, |
|
| 95 |
CREATE_DATETIME = items.CREATE_DATETIME, |
|
| 96 |
START_DATETIME = items.START_DATETIME, |
|
| 97 |
END_DATETIME = items.END_DATETIME, |
|
| 98 |
TOTAL_PAGE = items.TOTAL_PAGE, |
|
| 99 |
CURRENT_PAGE = items.CURRENT_PAGE, |
|
| 100 |
EXCEPTION = items.EXCEPTION, |
|
| 101 |
PROJECT_NO = items.PROJECT_NO, |
|
| 102 |
DOCUMENT_ID = items.DOCUMENT_ID, |
|
| 103 |
REVISION = subpet.REVISION, |
|
| 104 |
DOCUMENT_NO = subpet.DOCUMENT_NO, |
|
| 105 |
DOCUMENT_NAME = subpet.DOCUMENT_NAME, |
|
| 106 |
GROUP_NO = subpet.GROUP_NO, |
|
| 107 |
//REVISION = documents.REVISION, |
|
| 108 |
//DOCUMENT_NO = documents.DOCUMENT_NO, |
|
| 109 |
//DOCUMENT_NAME = documents.DOCUMENT_NAME, |
|
| 110 |
//GROUP_NO = documents.GROUP_NO |
|
| 111 |
}; |
|
| 87 |
select items; |
|
| 88 |
|
|
| 89 |
|
|
| 90 |
//orderby items.CREATE_DATETIME descending |
|
| 91 |
//select new |
|
| 92 |
//{
|
|
| 93 |
// ID = items.ID, |
|
| 94 |
// DOCUMENT_URL = items.DOCUMENT_URL, |
|
| 95 |
// RECONVERTER = items.RECONVERTER, |
|
| 96 |
// SERVICE_ID = items.SERVICE_ID, |
|
| 97 |
// STATUS = items.STATUS, |
|
| 98 |
// CREATE_DATETIME = items.CREATE_DATETIME, |
|
| 99 |
// START_DATETIME = items.START_DATETIME, |
|
| 100 |
// END_DATETIME = items.END_DATETIME, |
|
| 101 |
// TOTAL_PAGE = items.TOTAL_PAGE, |
|
| 102 |
// CURRENT_PAGE = items.CURRENT_PAGE, |
|
| 103 |
// EXCEPTION = items.EXCEPTION, |
|
| 104 |
// PROJECT_NO = items.PROJECT_NO, |
|
| 105 |
// DOCUMENT_ID = items.DOCUMENT_ID, |
|
| 106 |
// REVISION = subpet.REVISION, |
|
| 107 |
// DOCUMENT_NO = subpet.DOCUMENT_NO, |
|
| 108 |
// DOCUMENT_NAME = subpet.DOCUMENT_NAME, |
|
| 109 |
// GROUP_NO = subpet.GROUP_NO, |
|
| 110 |
// //REVISION = documents.REVISION, |
|
| 111 |
// //DOCUMENT_NO = documents.DOCUMENT_NO, |
|
| 112 |
// //DOCUMENT_NAME = documents.DOCUMENT_NAME, |
|
| 113 |
// //GROUP_NO = documents.GROUP_NO |
|
| 114 |
//}; |
|
| 112 | 115 |
|
| 113 | 116 |
if (query.Count() > 0)//세미 |
| 114 | 117 |
{
|
내보내기 Unified diff
