개정판 2aa2a446
issue #0000
ID2 작업여부
- Model 삭제
- DB 삭제
- 조회조건 및 crud 제거, 디자인 수정
- Excel 주석
마크업 여부
- Model 삭제
- DB 삭제
- crud 제거, 디자인 수정
Change-Id: I74bcd49d0e6199dd1396c5e44891b919722644fb
| ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs | ||
|---|---|---|
| 58 | 58 |
} |
| 59 | 59 |
|
| 60 | 60 |
|
| 61 |
public (IEnumerable<Documents> dwgs, int totalCnt) GetDocuments(string projectGroupID, List<string> dateTypes, DateTime? frDate, DateTime? toDate, string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string isID2Work, string id2Status, string id2Issues, string avevaStatus, string avevaIssues, string prodIsResult, string clientIsResult, string isGateWay, string isRegSystem)
|
|
| 61 |
public (IEnumerable<Documents> dwgs, int totalCnt) GetDocuments(string projectGroupID, List<string> dateTypes, DateTime? frDate, DateTime? toDate, string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string id2Status, string id2Issues, string avevaStatus, string avevaIssues, string prodIsResult, string clientIsResult, string isGateWay, string isRegSystem) |
|
| 62 | 62 |
{
|
| 63 | 63 |
var map = new CustomPropertyTypeMap(typeof(AttFileInfo), (type, columnName) |
| 64 | 64 |
=> type.GetProperties().FirstOrDefault(prop => GetDescriptionFromAttribute(prop) == columnName.ToLower())); |
| ... | ... | |
| 141 | 141 |
parameters.Add("FrReviewStatus", isFrReviewStatus);
|
| 142 | 142 |
} |
| 143 | 143 |
|
| 144 |
if (!string.IsNullOrEmpty(isID2Work)) |
|
| 145 |
{
|
|
| 146 |
sbWhere.Append(" and doc.IsID2Work=@IsID2Work ");
|
|
| 147 |
parameters.Add("IsID2Work", isID2Work);
|
|
| 148 |
} |
|
| 149 |
|
|
| 150 | 144 |
if (!string.IsNullOrEmpty(id2Status)) |
| 151 | 145 |
{
|
| 152 | 146 |
sbWhere.Append(" and doc.ID2Status=@ID2Status ");
|
| ... | ... | |
| 379 | 373 |
,ToIsDiscussion |
| 380 | 374 |
,ToRemarks |
| 381 | 375 |
,ToCreator |
| 382 |
,ToIsMarkup |
|
| 383 | 376 |
,FrReviewStatus |
| 384 | 377 |
,FrRemarks |
| 385 | 378 |
,FrCreator |
| 386 |
,FrIsMarkup |
|
| 387 |
,IsID2Work |
|
| 388 | 379 |
,ID2Connection |
| 389 | 380 |
,ID2StartDate |
| 390 | 381 |
,ID2EndDate |
| ... | ... | |
| 425 | 416 |
,@ToIsDiscussion |
| 426 | 417 |
,@ToRemarks |
| 427 | 418 |
,@ToCreator |
| 428 |
,@ToIsMarkup |
|
| 429 | 419 |
,@FrReviewStatus |
| 430 | 420 |
,@FrRemarks |
| 431 | 421 |
,@FrCreator |
| 432 |
,@FrIsMarkup |
|
| 433 |
,@IsID2Work |
|
| 434 | 422 |
,@ID2Connection |
| 435 | 423 |
,@ID2StartDate |
| 436 | 424 |
,@ID2EndDate |
| ... | ... | |
| 482 | 470 |
,ToIsDiscussion=@ToIsDiscussion |
| 483 | 471 |
,ToRemarks=@ToRemarks |
| 484 | 472 |
,ToCreator=@ToCreator |
| 485 |
,ToIsMarkup=@ToIsMarkup |
|
| 486 | 473 |
,FrReviewStatus=@FrReviewStatus |
| 487 | 474 |
,FrRemarks=@FrRemarks |
| 488 | 475 |
,FrCreator=@FrCreator |
| 489 |
,FrIsMarkup=@FrIsMarkup |
|
| 490 |
,IsID2Work=@IsID2Work |
|
| 491 | 476 |
,ID2Connection=@ID2Connection |
| 492 | 477 |
,ID2StartDate=@ID2StartDate |
| 493 | 478 |
,ID2EndDate=@ID2EndDate |
내보내기 Unified diff
