개정판 64e36f82
PROPERTIES Insert 버튼 완료
Change-Id: I6db17d8c5dc012b2faf6249c88192782d5c1ef72
ConvertService/ServiceController/StationControllerService/DataService.svc.cs | ||
---|---|---|
12 | 12 |
// 참고: 이 서비스를 테스트하기 위해 WCF 테스트 클라이언트를 시작하려면 솔루션 탐색기에서 DataService.svc나 DataService.svc.cs를 선택하고 디버깅을 시작하십시오. |
13 | 13 |
public class DataService : IDataService |
14 | 14 |
{ |
15 |
|
|
15 |
|
|
16 | 16 |
public List<SELECT_CONVERT_ITEM_Result> GET_SELECT_CONVERT_ITEM(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_ID, Nullable<int> p_STATUS, Nullable<int> p_TAKE_COUNT, Nullable<System.DateTime> p_BEGIN_CREATE_DATETIME, Nullable<System.DateTime> p_FINISH_CREATE_DATETIME, Nullable<System.DateTime> p_BEGIN_START_DATETIE, Nullable<System.DateTime> p_FINISH_START_DATETIME, Nullable<System.DateTime> p_BEGIN_END_DATETIME, Nullable<System.DateTime> p_FINISH_END_DATETIME, string p_GROUP_NO, string p_DOCUMENT_NAME, string p_DOCUMENT_NO, string p_REVISION, string p_SERVICE_ID, Nullable<int> p_RECONVERTER, string p_DOCUMENT_URL, Nullable<bool> p_ExcptionCheck) |
17 | 17 |
{ |
18 | 18 |
List<SELECT_CONVERT_ITEM_Result> result = new List<SELECT_CONVERT_ITEM_Result>(); |
... | ... | |
228 | 228 |
return result; |
229 | 229 |
} |
230 | 230 |
|
231 |
public List<SELECT_DOCUMENT_ITEM_Result> GET_DOCUMENT_ITEM(Nullable<int> p_TAKE_COUNT, string p_REVISION, string p_DOCUMENT_N0, string p_DOCUMENT_NAME, string p_GROUP_N0, string p_ORIGINAL_FILE, string p_DOCUMENT_ID, string p_PROJECT_NO)
|
|
231 |
public List<SELECT_DOCUMENT_ITEM_Result> GET_DOCUMENT_ITEM(Nullable<int> p_TAKE_COUNT, string p_REVISION, string p_DOCUMENT_N0, string p_DOCUMENT_NAME, string p_GROUP_N0, string p_ORIGINAL_FILE, string p_DOCUMENT_ID, string p_PROJECT_NO) |
|
232 | 232 |
{ |
233 | 233 |
|
234 | 234 |
List<SELECT_DOCUMENT_ITEM_Result> result = new List<SELECT_DOCUMENT_ITEM_Result>(); |
... | ... | |
250 | 250 |
|
251 | 251 |
return result; |
252 | 252 |
} |
253 |
|
|
254 |
public List<SELECT_PROPERTIES_RUN_PROJECTS_Result> GET_PROPERTIES_RUN_PROJECTS(string p_PROJECT_NO) |
|
255 |
{ |
|
256 |
|
|
257 |
List<SELECT_PROPERTIES_RUN_PROJECTS_Result> result = new List<SELECT_PROPERTIES_RUN_PROJECTS_Result>(); |
|
258 |
|
|
259 |
try |
|
260 |
{ |
|
261 |
//var connectionstring = Properties.Resources.ConnectionString; |
|
262 |
|
|
263 |
using (markusEntities entities = new markusEntities()) |
|
264 |
{ |
|
265 |
result = entities.SELECT_PROPERTIES_RUN_PROJECTS(p_PROJECT_NO).ToList(); |
|
266 |
} |
|
267 |
} |
|
268 |
catch (Exception ex) |
|
269 |
{ |
|
270 |
System.Diagnostics.Debug.WriteLine(ex.ToString()); |
|
271 |
throw new FaultException("GET_PROPERTIES_RUN_PROJECTS"); |
|
272 |
} |
|
273 |
|
|
274 |
return result; |
|
275 |
} |
|
276 |
public List<SELECT_RUN_PROJECTS_INSERT_Result> GET_RUN_PROJECTS_INSERT(string p_PROJECT_NO, string p_PROJECT_NAME) |
|
277 |
{ |
|
278 |
|
|
279 |
List<SELECT_RUN_PROJECTS_INSERT_Result> result = new List<SELECT_RUN_PROJECTS_INSERT_Result>(); |
|
280 |
|
|
281 |
try |
|
282 |
{ |
|
283 |
//var connectionstring = Properties.Resources.ConnectionString; |
|
284 |
|
|
285 |
using (markusEntities entities = new markusEntities()) |
|
286 |
{ |
|
287 |
result = entities.SELECT_RUN_PROJECTS_INSERT(p_PROJECT_NO, p_PROJECT_NAME).ToList(); |
|
288 |
} |
|
289 |
} |
|
290 |
catch (Exception ex) |
|
291 |
{ |
|
292 |
System.Diagnostics.Debug.WriteLine(ex.ToString()); |
|
293 |
throw new FaultException("GET_RUN_PROJECTS_INSERT"); |
|
294 |
} |
|
295 |
|
|
296 |
return result; |
|
297 |
} |
|
298 |
public int GET_PROPERTIES_INSERT(string p_TYPE, string p_PROPERTY, string p_VALUE) |
|
299 |
{ |
|
300 |
int result; |
|
301 |
|
|
302 |
try |
|
303 |
{ |
|
304 |
//var connectionstring = Properties.Resources.ConnectionString; |
|
305 |
|
|
306 |
using (markusEntities entities = new markusEntities()) |
|
307 |
{ |
|
308 |
result = entities.SELECT_PROPERTIES_INSERT(p_TYPE, p_PROPERTY, p_VALUE); |
|
309 |
} |
|
310 |
} |
|
311 |
catch (Exception ex) |
|
312 |
{ |
|
313 |
System.Diagnostics.Debug.WriteLine(ex.ToString()); |
|
314 |
throw new FaultException("GET_PROPERTIES_INSERT"); |
|
315 |
} |
|
316 |
|
|
317 |
return result; |
|
318 |
} |
|
253 | 319 |
} |
254 | 320 |
} |
내보내기 Unified diff