개정판 b63dcfbb
markusEntities 추가
Change-Id: Iac863d0665e1d7e6ef8ceb0f709348cfb30966a2
| ConvertService/ServiceBase/Markus.Service.DataBase/ConvertDatabase.cs | ||
|---|---|---|
| 77 | 77 |
/// <summary> |
| 78 | 78 |
/// 상단 그리드 선택된 Status에 따라 DB에서 값 가져온다. |
| 79 | 79 |
/// </summary> |
| 80 |
public IEnumerable<Interface.ConvertItem> GetConvertProjects(int status,string ProjectNumberFilter, string UniqueKeyFilter, string Docuemnt_NameFilter, string Service_IDFilter, string Docuemnt_NOFilter, int? ReconverterFilter |
|
| 81 |
, string RevisionFilter) |
|
| 82 |
{
|
|
| 83 |
List<Interface.ConvertItem> convertItems = new List<Interface.ConvertItem>(); |
|
| 84 |
var query = from items in entities.CONVERTER_DOC |
|
| 85 |
join documents in entities.DOCUMENT_ITEM on items.DOCUMENT_ID equals documents.DOCUMENT_ID into GroupItems |
|
| 86 |
from subpet in GroupItems.DefaultIfEmpty() |
|
| 87 |
where items.STATUS == status && |
|
| 88 |
// |
|
| 89 |
( |
|
| 90 |
items.PROJECT_NO.Contains(ProjectNumberFilter) |
|
| 91 |
|| subpet.DOCUMENT_NAME.Contains(Docuemnt_NameFilter) |
|
| 92 |
|| items.SERVICE_ID.Contains(Service_IDFilter) |
|
| 93 |
|| subpet.ID.Contains(UniqueKeyFilter) |
|
| 94 |
|| subpet.DOCUMENT_NO.Contains(Docuemnt_NOFilter) |
|
| 95 |
|| items.RECONVERTER == ReconverterFilter |
|
| 96 |
|| subpet.REVISION.Contains(RevisionFilter) |
|
| 97 |
) |
|
| 98 |
// |
|
| 99 |
orderby items.CREATE_DATETIME descending |
|
| 100 |
select new |
|
| 101 |
{
|
|
| 102 |
ID = items.ID, |
|
| 103 |
DOCUMENT_URL = items.DOCUMENT_URL, |
|
| 104 |
RECONVERTER = items.RECONVERTER, |
|
| 105 |
SERVICE_ID = items.SERVICE_ID, |
|
| 106 |
STATUS = items.STATUS, |
|
| 107 |
CREATE_DATETIME = items.CREATE_DATETIME, |
|
| 108 |
START_DATETIME = items.START_DATETIME, |
|
| 109 |
END_DATETIME = items.END_DATETIME, |
|
| 110 |
TOTAL_PAGE = items.TOTAL_PAGE, |
|
| 111 |
CURRENT_PAGE = items.CURRENT_PAGE, |
|
| 112 |
EXCEPTION = items.EXCEPTION, |
|
| 113 |
PROJECT_NO = items.PROJECT_NO, |
|
| 114 |
DOCUMENT_ID = items.DOCUMENT_ID, |
|
| 115 |
REVISION = subpet.REVISION, |
|
| 116 |
DOCUMENT_NO = subpet.DOCUMENT_NO, |
|
| 117 |
DOCUMENT_NAME = subpet.DOCUMENT_NAME, |
|
| 118 |
GROUP_NO = subpet.GROUP_NO, |
|
| 119 |
}; |
|
| 120 |
|
|
| 121 |
if (query.Count() > 0)//세미 |
|
| 122 |
{
|
|
| 123 |
foreach (var item in query) |
|
| 124 |
{
|
|
| 125 |
Interface.ConvertItem convertitem = new Interface.ConvertItem(item.DOCUMENT_ID, item.PROJECT_NO, item.ID, item.DOCUMENT_URL) |
|
| 126 |
{
|
|
| 127 |
|
|
| 128 |
ReConverter = item.RECONVERTER, |
|
| 129 |
ServiceID = item.SERVICE_ID, |
|
| 130 |
ConvertState = (StatusCodeType)item.STATUS, |
|
| 131 |
CreateTime = item.CREATE_DATETIME, |
|
| 132 |
StartTime = (DateTime)item.START_DATETIME, |
|
| 133 |
EndTime = (DateTime)item.END_DATETIME, |
|
| 134 |
TotalPage = item.TOTAL_PAGE, |
|
| 135 |
CurrentPageNo = item.CURRENT_PAGE, |
|
| 136 |
Exception = item.EXCEPTION, |
|
| 137 |
ConvertPath = GetConvertPath(item.PROJECT_NO, item.DOCUMENT_ID), |
|
| 138 |
|
|
| 139 |
Revision = item.REVISION, |
|
| 140 |
DocumnetNo = item.DOCUMENT_NO, |
|
| 141 |
DocumnetName = item.DOCUMENT_NAME, |
|
| 142 |
GroupNo = item.GROUP_NO, |
|
| 143 |
DocumentID = item.DOCUMENT_ID, |
|
| 144 |
|
|
| 145 |
MarkusLink = "kcom://" + Markus.Service.DataBase.Extensions.MarkusAPI.CreateMarkusParam(item.PROJECT_NO, item.DOCUMENT_ID, "doftech") |
|
| 146 |
}; |
|
| 147 |
convertItems.Add(convertitem); |
|
| 148 |
} |
|
| 149 |
} |
|
| 150 |
return convertItems; |
|
| 151 |
|
|
| 152 |
} |
|
| 153 |
|
|
| 80 | 154 |
public IEnumerable<Interface.ConvertItem> GetConvertProjects(int status) |
| 81 | 155 |
{
|
| 82 | 156 |
List<Interface.ConvertItem> convertItems = new List<Interface.ConvertItem>(); |
| ... | ... | |
| 84 | 158 |
join documents in entities.DOCUMENT_ITEM on items.DOCUMENT_ID equals documents.DOCUMENT_ID into GroupItems |
| 85 | 159 |
from subpet in GroupItems.DefaultIfEmpty() |
| 86 | 160 |
where items.STATUS == status |
| 87 |
orderby items.CREATE_DATETIME descending
|
|
| 161 |
orderby items.CREATE_DATETIME descending |
|
| 88 | 162 |
select new |
| 89 | 163 |
{
|
| 90 | 164 |
ID = items.ID, |
내보내기 Unified diff
