개정판 e8a86b9b
issue #0000
캡쳐항목변경
- 캡쳐된 항목만 표시하기위해
- ID2 도프텍, 삼성 (DB 컬럼도 같이 삭제)
- Valiation 도프텍, 삼성
document 조회 쿼리 수정
- total count
Change-Id: I7e8703b0826d5f1bebf51645d97fd5645b511acf
| ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs | ||
|---|---|---|
| 74 | 74 |
if (string.IsNullOrEmpty(projectCode)) |
| 75 | 75 |
{
|
| 76 | 76 |
sbWhere.Append(" and isnull(doc.RefProjectCode,'') in (select Code from dbo.Projects where ParentID=@RefGroupID union all select '') ");
|
| 77 |
sbTotalWhere.Append(" and isnull(doc.RefProjectCode,'') in (select Code from dbo.Projects where ParentID=@RefGroupID union all select '') ");
|
|
| 77 | 78 |
parameters.Add("RefGroupID", projectGroupID);
|
| 78 | 79 |
} |
| 79 | 80 |
else |
| 80 | 81 |
{
|
| 82 |
sbTotalWhere.Append(" and isnull(doc.RefProjectCode,'') in (select Code from dbo.Projects where ParentID=@RefGroupID union all select '') ");
|
|
| 83 |
parameters.Add("RefGroupID", projectGroupID);
|
|
| 84 |
|
|
| 81 | 85 |
sbWhere.Append(" and doc.RefProjectCode=@RefProjectCode ");
|
| 82 |
sbTotalWhere.Append(" and doc.RefProjectCode=@RefProjectCode ");
|
|
| 83 | 86 |
parameters.Add("RefProjectCode", projectCode);
|
| 84 | 87 |
} |
| 85 | 88 |
if (!string.IsNullOrEmpty(personIncharge)) |
| ... | ... | |
| 210 | 213 |
System.Diagnostics.Debug.WriteLine(attfile.FileName); |
| 211 | 214 |
if (!doc.AttFiles.Any(x => x.FileID == attfile.FileID)) |
| 212 | 215 |
{
|
| 216 |
switch (attfile.Category) |
|
| 217 |
{
|
|
| 218 |
case "toreview": |
|
| 219 |
doc.ToCapture++; |
|
| 220 |
break; |
|
| 221 |
case "frreview": |
|
| 222 |
doc.FrCapture++; |
|
| 223 |
break; |
|
| 224 |
case "prodvalidation": |
|
| 225 |
doc.ProdCapture++; |
|
| 226 |
break; |
|
| 227 |
case "clientvalidation": |
|
| 228 |
doc.ClientCapture++; |
|
| 229 |
break; |
|
| 230 |
} |
|
| 231 |
|
|
| 213 | 232 |
doc.AttFiles.Add(attfile); |
| 214 | 233 |
} |
| 215 | 234 |
} |
내보내기 Unified diff
