개정판 296ffcbd
issue #0000
문의(DOF),회신(DS) 조회조건 추가
Change-Id: Ieb4f166887cbf6137eb6f55fb2300232f19431d7
| ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs | ||
|---|---|---|
| 14 | 14 |
{
|
| 15 | 15 |
public DocumentRepository(string connectionStr) : base(connectionStr) { }
|
| 16 | 16 |
|
| 17 |
public IEnumerable<Documents> GetAllDocuments(string projectCode, string personIncharge, string jobLevel, string documentNo, string isID2Work, string id2Status, string avevaStatus, string prodIsResult, string clientIsResult) |
|
| 17 |
public IEnumerable<Documents> GetAllDocuments(string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string isID2Work, string id2Status, string avevaStatus, string prodIsResult, string clientIsResult)
|
|
| 18 | 18 |
{
|
| 19 | 19 |
StringBuilder sbWhere = new StringBuilder(); |
| 20 | 20 |
var parameters = new Dictionary<string, object>(); |
| ... | ... | |
| 39 | 39 |
parameters.Add("DocumentNo", documentNo);
|
| 40 | 40 |
} |
| 41 | 41 |
|
| 42 |
if (!string.IsNullOrEmpty(isToIsDiscussion)) |
|
| 43 |
{
|
|
| 44 |
sbWhere.Append(" and doc.ToIsDiscussion=@ToIsDiscussion ");
|
|
| 45 |
parameters.Add("ToIsDiscussion", isToIsDiscussion);
|
|
| 46 |
} |
|
| 47 |
|
|
| 48 |
if (!string.IsNullOrEmpty(isFrReviewStatus)) |
|
| 49 |
{
|
|
| 50 |
sbWhere.Append(" and doc.FrReviewStatus=@FrReviewStatus ");
|
|
| 51 |
parameters.Add("FrReviewStatus", isFrReviewStatus);
|
|
| 52 |
} |
|
| 53 |
|
|
| 42 | 54 |
if (!string.IsNullOrEmpty(isID2Work)) |
| 43 | 55 |
{
|
| 44 | 56 |
sbWhere.Append(" and doc.IsID2Work=@IsID2Work ");
|
내보내기 Unified diff
