markus / ConvertService / ServiceController / StationControllerService / MarkusModel.Context.cs @ 4d701de6
이력 | 보기 | 이력해설 | 다운로드 (29.6 KB)
1 | 5c387707 | semi | //------------------------------------------------------------------------------ |
---|---|---|---|
2 | // <auto-generated> |
||
3 | // 이 코드는 템플릿에서 생성되었습니다. |
||
4 | // |
||
5 | // 이 파일을 수동으로 변경하면 응용 프로그램에서 예기치 않은 동작이 발생할 수 있습니다. |
||
6 | // 이 파일을 수동으로 변경하면 코드가 다시 생성될 때 변경 내용을 덮어씁니다. |
||
7 | // </auto-generated> |
||
8 | //------------------------------------------------------------------------------ |
||
9 | |||
10 | namespace StationControllerService |
||
11 | { |
||
12 | using System; |
||
13 | using System.Data.Entity; |
||
14 | using System.Data.Entity.Infrastructure; |
||
15 | using System.Data.Entity.Core.Objects; |
||
16 | using System.Linq; |
||
17 | |||
18 | public partial class markusEntities : DbContext |
||
19 | { |
||
20 | public markusEntities() |
||
21 | : base("name=markusEntities") |
||
22 | { |
||
23 | } |
||
24 | |||
25 | protected override void OnModelCreating(DbModelBuilder modelBuilder) |
||
26 | { |
||
27 | throw new UnintentionalCodeFirstException(); |
||
28 | } |
||
29 | |||
30 | |||
31 | public virtual ObjectResult<CONVERT_COUNT_Result> CONVERT_COUNT(Nullable<int> p_STATUS, Nullable<System.DateTime> p_BEGIN_CREATE_DATETIME, Nullable<System.DateTime> p_FINISH_CREATE_DATETIME) |
||
32 | { |
||
33 | var p_STATUSParameter = p_STATUS.HasValue ? |
||
34 | new ObjectParameter("P_STATUS", p_STATUS) : |
||
35 | new ObjectParameter("P_STATUS", typeof(int)); |
||
36 | |||
37 | var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ? |
||
38 | new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) : |
||
39 | new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime)); |
||
40 | |||
41 | var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ? |
||
42 | new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) : |
||
43 | new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime)); |
||
44 | |||
45 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<CONVERT_COUNT_Result>("CONVERT_COUNT", p_STATUSParameter, p_BEGIN_CREATE_DATETIMEParameter, p_FINISH_CREATE_DATETIMEParameter); |
||
46 | } |
||
47 | |||
48 | public virtual ObjectResult<FINALPDF_COUNT_Result> FINALPDF_COUNT(Nullable<int> p_STATUS, Nullable<System.DateTime> p_BEGIN_CREATE_DATETIME, Nullable<System.DateTime> p_FINISH_CREATE_DATETIME) |
||
49 | { |
||
50 | var p_STATUSParameter = p_STATUS.HasValue ? |
||
51 | new ObjectParameter("P_STATUS", p_STATUS) : |
||
52 | new ObjectParameter("P_STATUS", typeof(int)); |
||
53 | |||
54 | var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ? |
||
55 | new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) : |
||
56 | new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime)); |
||
57 | |||
58 | var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ? |
||
59 | new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) : |
||
60 | new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime)); |
||
61 | |||
62 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<FINALPDF_COUNT_Result>("FINALPDF_COUNT", p_STATUSParameter, p_BEGIN_CREATE_DATETIMEParameter, p_FINISH_CREATE_DATETIMEParameter); |
||
63 | } |
||
64 | |||
65 | public virtual int SELECT_CONVERT_DELETE(string p_ID) |
||
66 | { |
||
67 | var p_IDParameter = p_ID != null ? |
||
68 | new ObjectParameter("P_ID", p_ID) : |
||
69 | new ObjectParameter("P_ID", typeof(string)); |
||
70 | |||
71 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SELECT_CONVERT_DELETE", p_IDParameter); |
||
72 | } |
||
73 | |||
74 | public virtual int SELECT_CONVERT_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_URL, string p_DOCUMENT_ID) |
||
75 | { |
||
76 | var p_IDParameter = p_ID != null ? |
||
77 | new ObjectParameter("P_ID", p_ID) : |
||
78 | new ObjectParameter("P_ID", typeof(string)); |
||
79 | |||
80 | var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
||
81 | new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) : |
||
82 | new ObjectParameter("P_PROJECT_NO", typeof(string)); |
||
83 | |||
84 | var p_DOCUMENT_URLParameter = p_DOCUMENT_URL != null ? |
||
85 | new ObjectParameter("P_DOCUMENT_URL", p_DOCUMENT_URL) : |
||
86 | new ObjectParameter("P_DOCUMENT_URL", typeof(string)); |
||
87 | |||
88 | var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
||
89 | new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) : |
||
90 | new ObjectParameter("P_DOCUMENT_ID", typeof(string)); |
||
91 | |||
92 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SELECT_CONVERT_INSERT", p_IDParameter, p_PROJECT_NOParameter, p_DOCUMENT_URLParameter, p_DOCUMENT_IDParameter); |
||
93 | } |
||
94 | |||
95 | aa42c9c1 | semi | public virtual ObjectResult<SELECT_CONVERT_ITEM_Result> 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<int> p_ExcptionCheck) |
96 | 5c387707 | semi | { |
97 | var p_IDParameter = p_ID != null ? |
||
98 | new ObjectParameter("P_ID", p_ID) : |
||
99 | new ObjectParameter("P_ID", typeof(string)); |
||
100 | |||
101 | var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
||
102 | new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) : |
||
103 | new ObjectParameter("P_PROJECT_NO", typeof(string)); |
||
104 | |||
105 | var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
||
106 | new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) : |
||
107 | new ObjectParameter("P_DOCUMENT_ID", typeof(string)); |
||
108 | |||
109 | var p_STATUSParameter = p_STATUS.HasValue ? |
||
110 | new ObjectParameter("P_STATUS", p_STATUS) : |
||
111 | new ObjectParameter("P_STATUS", typeof(int)); |
||
112 | |||
113 | var p_TAKE_COUNTParameter = p_TAKE_COUNT.HasValue ? |
||
114 | new ObjectParameter("P_TAKE_COUNT", p_TAKE_COUNT) : |
||
115 | new ObjectParameter("P_TAKE_COUNT", typeof(int)); |
||
116 | |||
117 | var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ? |
||
118 | new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) : |
||
119 | new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime)); |
||
120 | |||
121 | var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ? |
||
122 | new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) : |
||
123 | new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime)); |
||
124 | |||
125 | var p_BEGIN_START_DATETIEParameter = p_BEGIN_START_DATETIE.HasValue ? |
||
126 | new ObjectParameter("P_BEGIN_START_DATETIE", p_BEGIN_START_DATETIE) : |
||
127 | new ObjectParameter("P_BEGIN_START_DATETIE", typeof(System.DateTime)); |
||
128 | |||
129 | var p_FINISH_START_DATETIMEParameter = p_FINISH_START_DATETIME.HasValue ? |
||
130 | new ObjectParameter("P_FINISH_START_DATETIME", p_FINISH_START_DATETIME) : |
||
131 | new ObjectParameter("P_FINISH_START_DATETIME", typeof(System.DateTime)); |
||
132 | |||
133 | var p_BEGIN_END_DATETIMEParameter = p_BEGIN_END_DATETIME.HasValue ? |
||
134 | new ObjectParameter("P_BEGIN_END_DATETIME", p_BEGIN_END_DATETIME) : |
||
135 | new ObjectParameter("P_BEGIN_END_DATETIME", typeof(System.DateTime)); |
||
136 | |||
137 | var p_FINISH_END_DATETIMEParameter = p_FINISH_END_DATETIME.HasValue ? |
||
138 | new ObjectParameter("P_FINISH_END_DATETIME", p_FINISH_END_DATETIME) : |
||
139 | new ObjectParameter("P_FINISH_END_DATETIME", typeof(System.DateTime)); |
||
140 | |||
141 | var p_GROUP_NOParameter = p_GROUP_NO != null ? |
||
142 | new ObjectParameter("P_GROUP_NO", p_GROUP_NO) : |
||
143 | new ObjectParameter("P_GROUP_NO", typeof(string)); |
||
144 | |||
145 | var p_DOCUMENT_NAMEParameter = p_DOCUMENT_NAME != null ? |
||
146 | new ObjectParameter("P_DOCUMENT_NAME", p_DOCUMENT_NAME) : |
||
147 | new ObjectParameter("P_DOCUMENT_NAME", typeof(string)); |
||
148 | |||
149 | var p_DOCUMENT_NOParameter = p_DOCUMENT_NO != null ? |
||
150 | new ObjectParameter("P_DOCUMENT_NO", p_DOCUMENT_NO) : |
||
151 | new ObjectParameter("P_DOCUMENT_NO", typeof(string)); |
||
152 | |||
153 | var p_REVISIONParameter = p_REVISION != null ? |
||
154 | new ObjectParameter("P_REVISION", p_REVISION) : |
||
155 | new ObjectParameter("P_REVISION", typeof(string)); |
||
156 | |||
157 | var p_SERVICE_IDParameter = p_SERVICE_ID != null ? |
||
158 | new ObjectParameter("P_SERVICE_ID", p_SERVICE_ID) : |
||
159 | new ObjectParameter("P_SERVICE_ID", typeof(string)); |
||
160 | |||
161 | var p_RECONVERTERParameter = p_RECONVERTER.HasValue ? |
||
162 | new ObjectParameter("P_RECONVERTER", p_RECONVERTER) : |
||
163 | new ObjectParameter("P_RECONVERTER", typeof(int)); |
||
164 | |||
165 | var p_DOCUMENT_URLParameter = p_DOCUMENT_URL != null ? |
||
166 | new ObjectParameter("P_DOCUMENT_URL", p_DOCUMENT_URL) : |
||
167 | new ObjectParameter("P_DOCUMENT_URL", typeof(string)); |
||
168 | |||
169 | var p_ExcptionCheckParameter = p_ExcptionCheck.HasValue ? |
||
170 | new ObjectParameter("P_ExcptionCheck", p_ExcptionCheck) : |
||
171 | aa42c9c1 | semi | new ObjectParameter("P_ExcptionCheck", typeof(int)); |
172 | 5c387707 | semi | |
173 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_CONVERT_ITEM_Result>("SELECT_CONVERT_ITEM", p_IDParameter, p_PROJECT_NOParameter, p_DOCUMENT_IDParameter, p_STATUSParameter, p_TAKE_COUNTParameter, p_BEGIN_CREATE_DATETIMEParameter, p_FINISH_CREATE_DATETIMEParameter, p_BEGIN_START_DATETIEParameter, p_FINISH_START_DATETIMEParameter, p_BEGIN_END_DATETIMEParameter, p_FINISH_END_DATETIMEParameter, p_GROUP_NOParameter, p_DOCUMENT_NAMEParameter, p_DOCUMENT_NOParameter, p_REVISIONParameter, p_SERVICE_IDParameter, p_RECONVERTERParameter, p_DOCUMENT_URLParameter, p_ExcptionCheckParameter); |
||
174 | } |
||
175 | |||
176 | public virtual int SELECT_FINAL_PDF_DELETE(string p_ID) |
||
177 | { |
||
178 | var p_IDParameter = p_ID != null ? |
||
179 | new ObjectParameter("P_ID", p_ID) : |
||
180 | new ObjectParameter("P_ID", typeof(string)); |
||
181 | |||
182 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SELECT_FINAL_PDF_DELETE", p_IDParameter); |
||
183 | } |
||
184 | |||
185 | 919dee1b | semi | public virtual int SELECT_FINAL_PDF_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCINFO_ID, string p_DOCUMENT_ID, string p_MARKUPINFO_ID, string p_CREATE_USER_ID, Nullable<int> p_TOTAL_PAGE, Nullable<int> p_STATUS) |
186 | 5c387707 | semi | { |
187 | var p_IDParameter = p_ID != null ? |
||
188 | new ObjectParameter("P_ID", p_ID) : |
||
189 | new ObjectParameter("P_ID", typeof(string)); |
||
190 | |||
191 | var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
||
192 | new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) : |
||
193 | new ObjectParameter("P_PROJECT_NO", typeof(string)); |
||
194 | |||
195 | var p_DOCINFO_IDParameter = p_DOCINFO_ID != null ? |
||
196 | new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) : |
||
197 | new ObjectParameter("P_DOCINFO_ID", typeof(string)); |
||
198 | |||
199 | var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
||
200 | new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) : |
||
201 | new ObjectParameter("P_DOCUMENT_ID", typeof(string)); |
||
202 | |||
203 | 919dee1b | semi | var p_MARKUPINFO_IDParameter = p_MARKUPINFO_ID != null ? |
204 | new ObjectParameter("P_MARKUPINFO_ID", p_MARKUPINFO_ID) : |
||
205 | new ObjectParameter("P_MARKUPINFO_ID", typeof(string)); |
||
206 | |||
207 | var p_CREATE_USER_IDParameter = p_CREATE_USER_ID != null ? |
||
208 | new ObjectParameter("P_CREATE_USER_ID", p_CREATE_USER_ID) : |
||
209 | new ObjectParameter("P_CREATE_USER_ID", typeof(string)); |
||
210 | |||
211 | var p_TOTAL_PAGEParameter = p_TOTAL_PAGE.HasValue ? |
||
212 | new ObjectParameter("P_TOTAL_PAGE", p_TOTAL_PAGE) : |
||
213 | new ObjectParameter("P_TOTAL_PAGE", typeof(int)); |
||
214 | |||
215 | var p_STATUSParameter = p_STATUS.HasValue ? |
||
216 | new ObjectParameter("P_STATUS", p_STATUS) : |
||
217 | new ObjectParameter("P_STATUS", typeof(int)); |
||
218 | |||
219 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SELECT_FINAL_PDF_INSERT", p_IDParameter, p_PROJECT_NOParameter, p_DOCINFO_IDParameter, p_DOCUMENT_IDParameter, p_MARKUPINFO_IDParameter, p_CREATE_USER_IDParameter, p_TOTAL_PAGEParameter, p_STATUSParameter); |
||
220 | 5c387707 | semi | } |
221 | |||
222 | aa42c9c1 | semi | public virtual ObjectResult<SELECT_FINAL_PDF_ITEM_Result> SELECT_FINAL_PDF_ITEM(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_ID, string p_MARKUPINFO_ID, string p_DOCINFO_ID, string p_DOCUMENT_NAME, string p_DOCUMENT_NO, string p_CREATE_USER_ID, Nullable<int> p_STATUS, Nullable<int> p_TAKE_COUNT, string p_GROUP_NO, string p_REVISION, 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_DOCUMENT_URL, Nullable<int> p_ExcptionCheck) |
223 | 5c387707 | semi | { |
224 | var p_IDParameter = p_ID != null ? |
||
225 | new ObjectParameter("P_ID", p_ID) : |
||
226 | new ObjectParameter("P_ID", typeof(string)); |
||
227 | |||
228 | var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
||
229 | new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) : |
||
230 | new ObjectParameter("P_PROJECT_NO", typeof(string)); |
||
231 | |||
232 | var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
||
233 | new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) : |
||
234 | new ObjectParameter("P_DOCUMENT_ID", typeof(string)); |
||
235 | |||
236 | var p_MARKUPINFO_IDParameter = p_MARKUPINFO_ID != null ? |
||
237 | new ObjectParameter("P_MARKUPINFO_ID", p_MARKUPINFO_ID) : |
||
238 | new ObjectParameter("P_MARKUPINFO_ID", typeof(string)); |
||
239 | |||
240 | var p_DOCINFO_IDParameter = p_DOCINFO_ID != null ? |
||
241 | new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) : |
||
242 | new ObjectParameter("P_DOCINFO_ID", typeof(string)); |
||
243 | |||
244 | var p_DOCUMENT_NAMEParameter = p_DOCUMENT_NAME != null ? |
||
245 | new ObjectParameter("P_DOCUMENT_NAME", p_DOCUMENT_NAME) : |
||
246 | new ObjectParameter("P_DOCUMENT_NAME", typeof(string)); |
||
247 | |||
248 | var p_DOCUMENT_NOParameter = p_DOCUMENT_NO != null ? |
||
249 | new ObjectParameter("P_DOCUMENT_NO", p_DOCUMENT_NO) : |
||
250 | new ObjectParameter("P_DOCUMENT_NO", typeof(string)); |
||
251 | |||
252 | var p_CREATE_USER_IDParameter = p_CREATE_USER_ID != null ? |
||
253 | new ObjectParameter("P_CREATE_USER_ID", p_CREATE_USER_ID) : |
||
254 | new ObjectParameter("P_CREATE_USER_ID", typeof(string)); |
||
255 | |||
256 | var p_STATUSParameter = p_STATUS.HasValue ? |
||
257 | new ObjectParameter("P_STATUS", p_STATUS) : |
||
258 | new ObjectParameter("P_STATUS", typeof(int)); |
||
259 | |||
260 | var p_TAKE_COUNTParameter = p_TAKE_COUNT.HasValue ? |
||
261 | new ObjectParameter("P_TAKE_COUNT", p_TAKE_COUNT) : |
||
262 | new ObjectParameter("P_TAKE_COUNT", typeof(int)); |
||
263 | |||
264 | var p_GROUP_NOParameter = p_GROUP_NO != null ? |
||
265 | new ObjectParameter("P_GROUP_NO", p_GROUP_NO) : |
||
266 | new ObjectParameter("P_GROUP_NO", typeof(string)); |
||
267 | |||
268 | var p_REVISIONParameter = p_REVISION != null ? |
||
269 | new ObjectParameter("P_REVISION", p_REVISION) : |
||
270 | new ObjectParameter("P_REVISION", typeof(string)); |
||
271 | |||
272 | var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ? |
||
273 | new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) : |
||
274 | new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime)); |
||
275 | |||
276 | var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ? |
||
277 | new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) : |
||
278 | new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime)); |
||
279 | |||
280 | var p_BEGIN_START_DATETIEParameter = p_BEGIN_START_DATETIE.HasValue ? |
||
281 | new ObjectParameter("P_BEGIN_START_DATETIE", p_BEGIN_START_DATETIE) : |
||
282 | new ObjectParameter("P_BEGIN_START_DATETIE", typeof(System.DateTime)); |
||
283 | |||
284 | var p_FINISH_START_DATETIMEParameter = p_FINISH_START_DATETIME.HasValue ? |
||
285 | new ObjectParameter("P_FINISH_START_DATETIME", p_FINISH_START_DATETIME) : |
||
286 | new ObjectParameter("P_FINISH_START_DATETIME", typeof(System.DateTime)); |
||
287 | |||
288 | var p_BEGIN_END_DATETIMEParameter = p_BEGIN_END_DATETIME.HasValue ? |
||
289 | new ObjectParameter("P_BEGIN_END_DATETIME", p_BEGIN_END_DATETIME) : |
||
290 | new ObjectParameter("P_BEGIN_END_DATETIME", typeof(System.DateTime)); |
||
291 | |||
292 | var p_FINISH_END_DATETIMEParameter = p_FINISH_END_DATETIME.HasValue ? |
||
293 | new ObjectParameter("P_FINISH_END_DATETIME", p_FINISH_END_DATETIME) : |
||
294 | new ObjectParameter("P_FINISH_END_DATETIME", typeof(System.DateTime)); |
||
295 | |||
296 | var p_DOCUMENT_URLParameter = p_DOCUMENT_URL != null ? |
||
297 | new ObjectParameter("P_DOCUMENT_URL", p_DOCUMENT_URL) : |
||
298 | new ObjectParameter("P_DOCUMENT_URL", typeof(string)); |
||
299 | |||
300 | var p_ExcptionCheckParameter = p_ExcptionCheck.HasValue ? |
||
301 | new ObjectParameter("P_ExcptionCheck", p_ExcptionCheck) : |
||
302 | aa42c9c1 | semi | new ObjectParameter("P_ExcptionCheck", typeof(int)); |
303 | 5c387707 | semi | |
304 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_FINAL_PDF_ITEM_Result>("SELECT_FINAL_PDF_ITEM", p_IDParameter, p_PROJECT_NOParameter, p_DOCUMENT_IDParameter, p_MARKUPINFO_IDParameter, p_DOCINFO_IDParameter, p_DOCUMENT_NAMEParameter, p_DOCUMENT_NOParameter, p_CREATE_USER_IDParameter, p_STATUSParameter, p_TAKE_COUNTParameter, p_GROUP_NOParameter, p_REVISIONParameter, p_BEGIN_CREATE_DATETIMEParameter, p_FINISH_CREATE_DATETIMEParameter, p_BEGIN_START_DATETIEParameter, p_FINISH_START_DATETIMEParameter, p_BEGIN_END_DATETIMEParameter, p_FINISH_END_DATETIMEParameter, p_DOCUMENT_URLParameter, p_ExcptionCheckParameter); |
||
305 | } |
||
306 | |||
307 | public virtual int SELECT_RERECONVERT_ITEM(string p_ID, Nullable<int> p_RECONVERTER, Nullable<System.DateTime> p_CREATE_DATETIME, Nullable<int> p_STATUS, Nullable<System.DateTime> p_END_DATETIME) |
||
308 | { |
||
309 | var p_IDParameter = p_ID != null ? |
||
310 | new ObjectParameter("P_ID", p_ID) : |
||
311 | new ObjectParameter("P_ID", typeof(string)); |
||
312 | |||
313 | var p_RECONVERTERParameter = p_RECONVERTER.HasValue ? |
||
314 | new ObjectParameter("P_RECONVERTER", p_RECONVERTER) : |
||
315 | new ObjectParameter("P_RECONVERTER", typeof(int)); |
||
316 | |||
317 | var p_CREATE_DATETIMEParameter = p_CREATE_DATETIME.HasValue ? |
||
318 | new ObjectParameter("P_CREATE_DATETIME", p_CREATE_DATETIME) : |
||
319 | new ObjectParameter("P_CREATE_DATETIME", typeof(System.DateTime)); |
||
320 | |||
321 | var p_STATUSParameter = p_STATUS.HasValue ? |
||
322 | new ObjectParameter("P_STATUS", p_STATUS) : |
||
323 | new ObjectParameter("P_STATUS", typeof(int)); |
||
324 | |||
325 | var p_END_DATETIMEParameter = p_END_DATETIME.HasValue ? |
||
326 | new ObjectParameter("P_END_DATETIME", p_END_DATETIME) : |
||
327 | new ObjectParameter("P_END_DATETIME", typeof(System.DateTime)); |
||
328 | |||
329 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SELECT_RERECONVERT_ITEM", p_IDParameter, p_RECONVERTERParameter, p_CREATE_DATETIMEParameter, p_STATUSParameter, p_END_DATETIMEParameter); |
||
330 | } |
||
331 | |||
332 | public virtual ObjectResult<SELECT_RUN_PROJECTS_Result> SELECT_RUN_PROJECTS(Nullable<int> p_RUN_PROJECTS) |
||
333 | { |
||
334 | var p_RUN_PROJECTSParameter = p_RUN_PROJECTS.HasValue ? |
||
335 | new ObjectParameter("P_RUN_PROJECTS", p_RUN_PROJECTS) : |
||
336 | new ObjectParameter("P_RUN_PROJECTS", typeof(int)); |
||
337 | |||
338 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_RUN_PROJECTS_Result>("SELECT_RUN_PROJECTS", p_RUN_PROJECTSParameter); |
||
339 | } |
||
340 | |||
341 | public virtual ObjectResult<SELECT_DOCUMENT_ITEM_Result> SELECT_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) |
||
342 | { |
||
343 | var p_TAKE_COUNTParameter = p_TAKE_COUNT.HasValue ? |
||
344 | new ObjectParameter("P_TAKE_COUNT", p_TAKE_COUNT) : |
||
345 | new ObjectParameter("P_TAKE_COUNT", typeof(int)); |
||
346 | |||
347 | var p_REVISIONParameter = p_REVISION != null ? |
||
348 | new ObjectParameter("P_REVISION", p_REVISION) : |
||
349 | new ObjectParameter("P_REVISION", typeof(string)); |
||
350 | |||
351 | var p_DOCUMENT_N0Parameter = p_DOCUMENT_N0 != null ? |
||
352 | new ObjectParameter("P_DOCUMENT_N0", p_DOCUMENT_N0) : |
||
353 | new ObjectParameter("P_DOCUMENT_N0", typeof(string)); |
||
354 | |||
355 | var p_DOCUMENT_NAMEParameter = p_DOCUMENT_NAME != null ? |
||
356 | new ObjectParameter("P_DOCUMENT_NAME", p_DOCUMENT_NAME) : |
||
357 | new ObjectParameter("P_DOCUMENT_NAME", typeof(string)); |
||
358 | |||
359 | var p_GROUP_N0Parameter = p_GROUP_N0 != null ? |
||
360 | new ObjectParameter("P_GROUP_N0", p_GROUP_N0) : |
||
361 | new ObjectParameter("P_GROUP_N0", typeof(string)); |
||
362 | |||
363 | var p_ORIGINAL_FILEParameter = p_ORIGINAL_FILE != null ? |
||
364 | new ObjectParameter("P_ORIGINAL_FILE", p_ORIGINAL_FILE) : |
||
365 | new ObjectParameter("P_ORIGINAL_FILE", typeof(string)); |
||
366 | |||
367 | var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
||
368 | new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) : |
||
369 | new ObjectParameter("P_DOCUMENT_ID", typeof(string)); |
||
370 | |||
371 | var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
||
372 | new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) : |
||
373 | new ObjectParameter("P_PROJECT_NO", typeof(string)); |
||
374 | |||
375 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_DOCUMENT_ITEM_Result>("SELECT_DOCUMENT_ITEM", p_TAKE_COUNTParameter, p_REVISIONParameter, p_DOCUMENT_N0Parameter, p_DOCUMENT_NAMEParameter, p_GROUP_N0Parameter, p_ORIGINAL_FILEParameter, p_DOCUMENT_IDParameter, p_PROJECT_NOParameter); |
||
376 | } |
||
377 | 64e36f82 | semi | |
378 | public virtual ObjectResult<SELECT_PROPERTIES_RUN_PROJECTS_Result> SELECT_PROPERTIES_RUN_PROJECTS(string p_PROJECT_NO) |
||
379 | { |
||
380 | var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
||
381 | new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) : |
||
382 | new ObjectParameter("P_PROJECT_NO", typeof(string)); |
||
383 | |||
384 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_PROPERTIES_RUN_PROJECTS_Result>("SELECT_PROPERTIES_RUN_PROJECTS", p_PROJECT_NOParameter); |
||
385 | } |
||
386 | |||
387 | a11f76e7 | semi | public virtual int SELECT_RUNANDPROPERTY_INSERT(string p_PROJECT_NO, string p_PROJECT_NAME, string p_TYPE_InitialCatalog, string p_VALUE_InitialCatalog, string p_TYPE_TileSorceStorage, string p_VALUE_TileSorceStorage, string p_TYPE_TileSourcePath, string p_VALUE_TileSourcePath, string p_TYPE_FinalPDFStorageRemote, string p_VALUE_FinalPDFStorageRemote, string p_TYPE_FinalPDFStorageLocal, string p_VALUE_FinalPDFStorageLocal, string p_TYPE_UpLoadServiceUrl, string p_VALUE_UpLoadServiceUrl, Nullable<int> p_IS_ACTIVITY) |
388 | 64e36f82 | semi | { |
389 | var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
||
390 | new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) : |
||
391 | new ObjectParameter("P_PROJECT_NO", typeof(string)); |
||
392 | |||
393 | var p_PROJECT_NAMEParameter = p_PROJECT_NAME != null ? |
||
394 | new ObjectParameter("P_PROJECT_NAME", p_PROJECT_NAME) : |
||
395 | new ObjectParameter("P_PROJECT_NAME", typeof(string)); |
||
396 | |||
397 | 4a41c345 | semi | var p_TYPE_InitialCatalogParameter = p_TYPE_InitialCatalog != null ? |
398 | new ObjectParameter("P_TYPE_InitialCatalog", p_TYPE_InitialCatalog) : |
||
399 | new ObjectParameter("P_TYPE_InitialCatalog", typeof(string)); |
||
400 | 64e36f82 | semi | |
401 | 4a41c345 | semi | var p_VALUE_InitialCatalogParameter = p_VALUE_InitialCatalog != null ? |
402 | new ObjectParameter("P_VALUE_InitialCatalog", p_VALUE_InitialCatalog) : |
||
403 | new ObjectParameter("P_VALUE_InitialCatalog", typeof(string)); |
||
404 | |||
405 | var p_TYPE_TileSorceStorageParameter = p_TYPE_TileSorceStorage != null ? |
||
406 | new ObjectParameter("P_TYPE_TileSorceStorage", p_TYPE_TileSorceStorage) : |
||
407 | new ObjectParameter("P_TYPE_TileSorceStorage", typeof(string)); |
||
408 | |||
409 | var p_VALUE_TileSorceStorageParameter = p_VALUE_TileSorceStorage != null ? |
||
410 | new ObjectParameter("P_VALUE_TileSorceStorage", p_VALUE_TileSorceStorage) : |
||
411 | new ObjectParameter("P_VALUE_TileSorceStorage", typeof(string)); |
||
412 | |||
413 | var p_TYPE_TileSourcePathParameter = p_TYPE_TileSourcePath != null ? |
||
414 | new ObjectParameter("P_TYPE_TileSourcePath", p_TYPE_TileSourcePath) : |
||
415 | new ObjectParameter("P_TYPE_TileSourcePath", typeof(string)); |
||
416 | |||
417 | var p_VALUE_TileSourcePathParameter = p_VALUE_TileSourcePath != null ? |
||
418 | new ObjectParameter("P_VALUE_TileSourcePath", p_VALUE_TileSourcePath) : |
||
419 | new ObjectParameter("P_VALUE_TileSourcePath", typeof(string)); |
||
420 | |||
421 | var p_TYPE_FinalPDFStorageRemoteParameter = p_TYPE_FinalPDFStorageRemote != null ? |
||
422 | new ObjectParameter("P_TYPE_FinalPDFStorageRemote", p_TYPE_FinalPDFStorageRemote) : |
||
423 | new ObjectParameter("P_TYPE_FinalPDFStorageRemote", typeof(string)); |
||
424 | |||
425 | var p_VALUE_FinalPDFStorageRemoteParameter = p_VALUE_FinalPDFStorageRemote != null ? |
||
426 | new ObjectParameter("P_VALUE_FinalPDFStorageRemote", p_VALUE_FinalPDFStorageRemote) : |
||
427 | new ObjectParameter("P_VALUE_FinalPDFStorageRemote", typeof(string)); |
||
428 | |||
429 | var p_TYPE_FinalPDFStorageLocalParameter = p_TYPE_FinalPDFStorageLocal != null ? |
||
430 | new ObjectParameter("P_TYPE_FinalPDFStorageLocal", p_TYPE_FinalPDFStorageLocal) : |
||
431 | new ObjectParameter("P_TYPE_FinalPDFStorageLocal", typeof(string)); |
||
432 | |||
433 | var p_VALUE_FinalPDFStorageLocalParameter = p_VALUE_FinalPDFStorageLocal != null ? |
||
434 | new ObjectParameter("P_VALUE_FinalPDFStorageLocal", p_VALUE_FinalPDFStorageLocal) : |
||
435 | new ObjectParameter("P_VALUE_FinalPDFStorageLocal", typeof(string)); |
||
436 | 64e36f82 | semi | |
437 | 4a41c345 | semi | var p_TYPE_UpLoadServiceUrlParameter = p_TYPE_UpLoadServiceUrl != null ? |
438 | new ObjectParameter("P_TYPE_UpLoadServiceUrl", p_TYPE_UpLoadServiceUrl) : |
||
439 | new ObjectParameter("P_TYPE_UpLoadServiceUrl", typeof(string)); |
||
440 | 64e36f82 | semi | |
441 | 4a41c345 | semi | var p_VALUE_UpLoadServiceUrlParameter = p_VALUE_UpLoadServiceUrl != null ? |
442 | new ObjectParameter("P_VALUE_UpLoadServiceUrl", p_VALUE_UpLoadServiceUrl) : |
||
443 | new ObjectParameter("P_VALUE_UpLoadServiceUrl", typeof(string)); |
||
444 | 64e36f82 | semi | |
445 | a11f76e7 | semi | var p_IS_ACTIVITYParameter = p_IS_ACTIVITY.HasValue ? |
446 | new ObjectParameter("P_IS_ACTIVITY", p_IS_ACTIVITY) : |
||
447 | new ObjectParameter("P_IS_ACTIVITY", typeof(int)); |
||
448 | |||
449 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SELECT_RUNANDPROPERTY_INSERT", p_PROJECT_NOParameter, p_PROJECT_NAMEParameter, p_TYPE_InitialCatalogParameter, p_VALUE_InitialCatalogParameter, p_TYPE_TileSorceStorageParameter, p_VALUE_TileSorceStorageParameter, p_TYPE_TileSourcePathParameter, p_VALUE_TileSourcePathParameter, p_TYPE_FinalPDFStorageRemoteParameter, p_VALUE_FinalPDFStorageRemoteParameter, p_TYPE_FinalPDFStorageLocalParameter, p_VALUE_FinalPDFStorageLocalParameter, p_TYPE_UpLoadServiceUrlParameter, p_VALUE_UpLoadServiceUrlParameter, p_IS_ACTIVITYParameter); |
||
450 | 64e36f82 | semi | } |
451 | 919dee1b | semi | |
452 | public virtual ObjectResult<FINAL_PDF_MARKUP_CHECK_Result> FINAL_PDF_MARKUP_CHECK(string p_PROJECT_NO, string p_DOCUMENT_ID) |
||
453 | { |
||
454 | var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
||
455 | new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) : |
||
456 | new ObjectParameter("P_PROJECT_NO", typeof(string)); |
||
457 | |||
458 | var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
||
459 | new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) : |
||
460 | new ObjectParameter("P_DOCUMENT_ID", typeof(string)); |
||
461 | |||
462 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<FINAL_PDF_MARKUP_CHECK_Result>("FINAL_PDF_MARKUP_CHECK", p_PROJECT_NOParameter, p_DOCUMENT_IDParameter); |
||
463 | } |
||
464 | |||
465 | public virtual ObjectResult<SELECT_MARKUP_INFO_Result> SELECT_MARKUP_INFO(string p_DOCINFO_ID) |
||
466 | { |
||
467 | var p_DOCINFO_IDParameter = p_DOCINFO_ID != null ? |
||
468 | new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) : |
||
469 | new ObjectParameter("P_DOCINFO_ID", typeof(string)); |
||
470 | |||
471 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_MARKUP_INFO_Result>("SELECT_MARKUP_INFO", p_DOCINFO_IDParameter); |
||
472 | } |
||
473 | |||
474 | public virtual ObjectResult<SELECT_DOCINFO_Result> SELECT_DOCINFO(string p_DOCINFO_ID) |
||
475 | { |
||
476 | var p_DOCINFO_IDParameter = p_DOCINFO_ID != null ? |
||
477 | new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) : |
||
478 | new ObjectParameter("P_DOCINFO_ID", typeof(string)); |
||
479 | |||
480 | return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_DOCINFO_Result>("SELECT_DOCINFO", p_DOCINFO_IDParameter); |
||
481 | } |
||
482 | 5c387707 | semi | } |
483 | } |