프로젝트

일반

사용자정보

개정판 3bde451b

ID3bde451b422200cd73fd780e9fdbaa7768afaead
상위 7b095cc3
하위 504c5aa1, 2c634aed

semi 이(가) 약 5년 전에 추가함

FINALPDF와 CONVERT_DOC 저장 프로시저로 변경

Change-Id: I832b4103112d7b9968f573688378b779a9df2db8

차이점 보기:

ConvertService/ServiceBase/Markus.Service.StationController/MarkusModel.Context.cs
28 28 
        }
29 29
30 30
31 
        public virtual ObjectResult<SELECT_CONVERT_ITEM_Result> SELECT_CONVERT_ITEM(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)
31 
        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)
32 32 
        {
33 
            var p_IDParameter = p_ID != null ?
34 
                new ObjectParameter("P_ID", p_ID) :
35 
                new ObjectParameter("P_ID", typeof(string));
36
33 37 
            var p_PROJECT_NOParameter = p_PROJECT_NO != null ?
34 38 
                new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :
35 39 
                new ObjectParameter("P_PROJECT_NO", typeof(string));
......
86 90 
                new ObjectParameter("P_REVISION", p_REVISION) :
87 91 
                new ObjectParameter("P_REVISION", typeof(string));
88 92
89 
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_CONVERT_ITEM_Result>("markusEntities.SELECT_CONVERT_ITEM", 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);
93 
            var p_SERVICE_IDParameter = p_SERVICE_ID != null ?
94 
                new ObjectParameter("P_SERVICE_ID", p_SERVICE_ID) :
95 
                new ObjectParameter("P_SERVICE_ID", typeof(string));
96
97 
            var p_RECONVERTERParameter = p_RECONVERTER.HasValue ?
98 
                new ObjectParameter("P_RECONVERTER", p_RECONVERTER) :
99 
                new ObjectParameter("P_RECONVERTER", typeof(int));
100
101 
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_CONVERT_ITEM_Result>("markusEntities.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);
90 102 
        }
91 103
92 
        public virtual ObjectResult<SELECT_RERECONVERT_ITEM_Result> SELECT_RERECONVERT_ITEM(string p_ID, Nullable<int> p_RECONVERTER, Nullable<int> p_STATUS)
104 
        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)
93 105 
        {
94 106 
            var p_IDParameter = p_ID != null ?
95 107 
                new ObjectParameter("P_ID", p_ID) :
......
99 111 
                new ObjectParameter("P_RECONVERTER", p_RECONVERTER) :
100 112 
                new ObjectParameter("P_RECONVERTER", typeof(int));
101 113
114 
            var p_CREATE_DATETIMEParameter = p_CREATE_DATETIME.HasValue ?
115 
                new ObjectParameter("P_CREATE_DATETIME", p_CREATE_DATETIME) :
116 
                new ObjectParameter("P_CREATE_DATETIME", typeof(System.DateTime));
117
102 118 
            var p_STATUSParameter = p_STATUS.HasValue ?
103 119 
                new ObjectParameter("P_STATUS", p_STATUS) :
104 120 
                new ObjectParameter("P_STATUS", typeof(int));
105 121
106 
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_RERECONVERT_ITEM_Result>("markusEntities.SELECT_RERECONVERT_ITEM", p_IDParameter, p_RECONVERTERParameter, p_STATUSParameter);
122 
            var p_END_DATETIMEParameter = p_END_DATETIME.HasValue ?
123 
                new ObjectParameter("P_END_DATETIME", p_END_DATETIME) :
124 
                new ObjectParameter("P_END_DATETIME", typeof(System.DateTime));
125
126 
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_RERECONVERT_ITEM", p_IDParameter, p_RECONVERTERParameter, p_CREATE_DATETIMEParameter, p_STATUSParameter, p_END_DATETIMEParameter);
107 127 
        }
108 128
109 129 
        public virtual int SELECT_CONVERT_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_URL, string p_DOCUMENT_ID)
......
126 146
127 147 
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_CONVERT_INSERT", p_IDParameter, p_PROJECT_NOParameter, p_DOCUMENT_URLParameter, p_DOCUMENT_IDParameter);
128 148 
        }
149
150 
        public virtual int SELECT_CONVERT_DELETE(string p_ID)
151 
        {
152 
            var p_IDParameter = p_ID != null ?
153 
                new ObjectParameter("P_ID", p_ID) :
154 
                new ObjectParameter("P_ID", typeof(string));
155
156 
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_CONVERT_DELETE", p_IDParameter);
157 
        }
158
159 
        public virtual int SELECT_FINAL_PDF_DELETE(string p_ID)
160 
        {
161 
            var p_IDParameter = p_ID != null ?
162 
                new ObjectParameter("P_ID", p_ID) :
163 
                new ObjectParameter("P_ID", typeof(string));
164
165 
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_FINAL_PDF_DELETE", p_IDParameter);
166 
        }
167
168 
        public virtual int SELECT_FINAL_PDF_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCINFO_ID, string p_DOCUMENT_ID)
169 
        {
170 
            var p_IDParameter = p_ID != null ?
171 
                new ObjectParameter("P_ID", p_ID) :
172 
                new ObjectParameter("P_ID", typeof(string));
173
174 
            var p_PROJECT_NOParameter = p_PROJECT_NO != null ?
175 
                new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :
176 
                new ObjectParameter("P_PROJECT_NO", typeof(string));
177
178 
            var p_DOCINFO_IDParameter = p_DOCINFO_ID != null ?
179 
                new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) :
180 
                new ObjectParameter("P_DOCINFO_ID", typeof(string));
181
182 
            var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ?
183 
                new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) :
184 
                new ObjectParameter("P_DOCUMENT_ID", typeof(string));
185
186 
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_FINAL_PDF_INSERT", p_IDParameter, p_PROJECT_NOParameter, p_DOCINFO_IDParameter, p_DOCUMENT_IDParameter);
187 
        }
188
189 
        public virtual ObjectResult<SELECT_FINAL_PDF_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)
190 
        {
191 
            var p_IDParameter = p_ID != null ?
192 
                new ObjectParameter("P_ID", p_ID) :
193 
                new ObjectParameter("P_ID", typeof(string));
194
195 
            var p_PROJECT_NOParameter = p_PROJECT_NO != null ?
196 
                new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :
197 
                new ObjectParameter("P_PROJECT_NO", 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 
            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_DOCINFO_IDParameter = p_DOCINFO_ID != null ?
208 
                new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) :
209 
                new ObjectParameter("P_DOCINFO_ID", typeof(string));
210
211 
            var p_DOCUMENT_NAMEParameter = p_DOCUMENT_NAME != null ?
212 
                new ObjectParameter("P_DOCUMENT_NAME", p_DOCUMENT_NAME) :
213 
                new ObjectParameter("P_DOCUMENT_NAME", typeof(string));
214
215 
            var p_DOCUMENT_NOParameter = p_DOCUMENT_NO != null ?
216 
                new ObjectParameter("P_DOCUMENT_NO", p_DOCUMENT_NO) :
217 
                new ObjectParameter("P_DOCUMENT_NO", typeof(string));
218
219 
            var p_CREATE_USER_IDParameter = p_CREATE_USER_ID != null ?
220 
                new ObjectParameter("P_CREATE_USER_ID", p_CREATE_USER_ID) :
221 
                new ObjectParameter("P_CREATE_USER_ID", typeof(string));
222
223 
            var p_STATUSParameter = p_STATUS.HasValue ?
224 
                new ObjectParameter("P_STATUS", p_STATUS) :
225 
                new ObjectParameter("P_STATUS", typeof(int));
226
227 
            var p_TAKE_COUNTParameter = p_TAKE_COUNT.HasValue ?
228 
                new ObjectParameter("P_TAKE_COUNT", p_TAKE_COUNT) :
229 
                new ObjectParameter("P_TAKE_COUNT", typeof(int));
230
231 
            var p_GROUP_NOParameter = p_GROUP_NO != null ?
232 
                new ObjectParameter("P_GROUP_NO", p_GROUP_NO) :
233 
                new ObjectParameter("P_GROUP_NO", typeof(string));
234
235 
            var p_REVISIONParameter = p_REVISION != null ?
236 
                new ObjectParameter("P_REVISION", p_REVISION) :
237 
                new ObjectParameter("P_REVISION", typeof(string));
238
239 
            var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ?
240 
                new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) :
241 
                new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime));
242
243 
            var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ?
244 
                new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) :
245 
                new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime));
246
247 
            var p_BEGIN_START_DATETIEParameter = p_BEGIN_START_DATETIE.HasValue ?
248 
                new ObjectParameter("P_BEGIN_START_DATETIE", p_BEGIN_START_DATETIE) :
249 
                new ObjectParameter("P_BEGIN_START_DATETIE", typeof(System.DateTime));
250
251 
            var p_FINISH_START_DATETIMEParameter = p_FINISH_START_DATETIME.HasValue ?
252 
                new ObjectParameter("P_FINISH_START_DATETIME", p_FINISH_START_DATETIME) :
253 
                new ObjectParameter("P_FINISH_START_DATETIME", typeof(System.DateTime));
254
255 
            var p_BEGIN_END_DATETIMEParameter = p_BEGIN_END_DATETIME.HasValue ?
256 
                new ObjectParameter("P_BEGIN_END_DATETIME", p_BEGIN_END_DATETIME) :
257 
                new ObjectParameter("P_BEGIN_END_DATETIME", typeof(System.DateTime));
258
259 
            var p_FINISH_END_DATETIMEParameter = p_FINISH_END_DATETIME.HasValue ?
260 
                new ObjectParameter("P_FINISH_END_DATETIME", p_FINISH_END_DATETIME) :
261 
                new ObjectParameter("P_FINISH_END_DATETIME", typeof(System.DateTime));
262
263 
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_FINAL_PDF_Result>("markusEntities.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);
264 
        }
129 265 
    }
130 266 
}

내보내기 Unified diff

클립보드 이미지 추가 (최대 크기: 500 MB)