개정판 c7f3eb42
issue #00000 markus image Create 수정
Change-Id: I9fc9beeea867be787be7c425e905b6fdfeadfbba
| ID2.Manager/ID2.Manager.Dapper/Repository/MarkusRepository.cs | ||
|---|---|---|
| 158 | 158 |
return convertItems; |
| 159 | 159 |
} |
| 160 | 160 |
|
| 161 |
public IEnumerable<MarkupText> GetMarkupText(IEnumerable<string> ProjectNoList, IEnumerable<string> DocumentNoList) |
|
| 162 |
{
|
|
| 163 |
string SQL = "GET_MARKUPDATA"; |
|
| 161 |
//public IEnumerable<MarkupText> GetMarkupText(IEnumerable<string> ProjectNoList, IEnumerable<string> DocumentNoList)
|
|
| 162 |
//{
|
|
| 163 |
// string SQL = "GET_MARKUPDATA";
|
|
| 164 | 164 |
|
| 165 |
var parameters = new DynamicParameters(); |
|
| 166 |
parameters.AddTable("@PROJECT_NOs", "VARCHAR_TABLE", ProjectNoList.Select(x=>new VARCHAR_TABLE { ITEM = x }));
|
|
| 167 |
parameters.AddTable("@DOCUMENT_IDs", "VARCHAR_TABLE", DocumentNoList.Select(x => new VARCHAR_TABLE { ITEM = x }));
|
|
| 165 |
// var parameters = new DynamicParameters();
|
|
| 166 |
// parameters.AddTable("@PROJECT_NOs", "VARCHAR_TABLE", ProjectNoList.Select(x=>new VARCHAR_TABLE { ITEM = x }));
|
|
| 167 |
// parameters.AddTable("@DOCUMENT_IDs", "VARCHAR_TABLE", DocumentNoList.Select(x => new VARCHAR_TABLE { ITEM = x }));
|
|
| 168 | 168 |
|
| 169 |
var Items = base.Query<MarkupText>(SQL, parameters,commandType:CommandType.StoredProcedure); |
|
| 169 |
// var Items = base.Query<MarkupText>(SQL, parameters,commandType:CommandType.StoredProcedure);
|
|
| 170 | 170 |
|
| 171 |
return Items; |
|
| 172 |
} |
|
| 171 |
// return Items;
|
|
| 172 |
//}
|
|
| 173 | 173 |
|
| 174 | 174 |
/// <summary> |
| 175 | 175 |
/// 완료 |
| ... | ... | |
| 308 | 308 |
|
| 309 | 309 |
var parameter = new DynamicParameters(); |
| 310 | 310 |
|
| 311 |
parameter.AddTable("DOCPAGES", "TYPE_INSERT_DOCPAGE", docPages);
|
|
| 311 |
parameter.AddTable< DocPage>("DOCPAGES", "TYPE_INSERT_DOCPAGE", docPages.ToList());
|
|
| 312 | 312 |
|
| 313 | 313 |
var id = base.Execute("CONVERT_INSERT_DOCPAGE", parameter, tran, commandType: CommandType.StoredProcedure);
|
| 314 | 314 |
|
내보내기 Unified diff
