markus / ConvertService / ServiceBase / Markus.Service.StationController / MarkusModel.Context.cs @ 31beca73
이력 | 보기 | 이력해설 | 다운로드 (16.1 KB)
| 1 |
//------------------------------------------------------------------------------ |
|---|---|
| 2 |
// <auto-generated> |
| 3 |
// 이 코드는 템플릿에서 생성되었습니다. |
| 4 |
// |
| 5 |
// 이 파일을 수동으로 변경하면 응용 프로그램에서 예기치 않은 동작이 발생할 수 있습니다. |
| 6 |
// 이 파일을 수동으로 변경하면 코드가 다시 생성될 때 변경 내용을 덮어씁니다. |
| 7 |
// </auto-generated> |
| 8 |
//------------------------------------------------------------------------------ |
| 9 |
|
| 10 |
namespace Markus.Service.StationController |
| 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<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) |
| 32 |
{
|
| 33 |
var p_IDParameter = p_ID != null ? |
| 34 |
new ObjectParameter("P_ID", p_ID) :
|
| 35 |
new ObjectParameter("P_ID", typeof(string));
|
| 36 |
|
| 37 |
var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
| 38 |
new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :
|
| 39 |
new ObjectParameter("P_PROJECT_NO", typeof(string));
|
| 40 |
|
| 41 |
var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
| 42 |
new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) :
|
| 43 |
new ObjectParameter("P_DOCUMENT_ID", typeof(string));
|
| 44 |
|
| 45 |
var p_STATUSParameter = p_STATUS.HasValue ? |
| 46 |
new ObjectParameter("P_STATUS", p_STATUS) :
|
| 47 |
new ObjectParameter("P_STATUS", typeof(int));
|
| 48 |
|
| 49 |
var p_TAKE_COUNTParameter = p_TAKE_COUNT.HasValue ? |
| 50 |
new ObjectParameter("P_TAKE_COUNT", p_TAKE_COUNT) :
|
| 51 |
new ObjectParameter("P_TAKE_COUNT", typeof(int));
|
| 52 |
|
| 53 |
var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ? |
| 54 |
new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) :
|
| 55 |
new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime));
|
| 56 |
|
| 57 |
var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ? |
| 58 |
new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) :
|
| 59 |
new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime));
|
| 60 |
|
| 61 |
var p_BEGIN_START_DATETIEParameter = p_BEGIN_START_DATETIE.HasValue ? |
| 62 |
new ObjectParameter("P_BEGIN_START_DATETIE", p_BEGIN_START_DATETIE) :
|
| 63 |
new ObjectParameter("P_BEGIN_START_DATETIE", typeof(System.DateTime));
|
| 64 |
|
| 65 |
var p_FINISH_START_DATETIMEParameter = p_FINISH_START_DATETIME.HasValue ? |
| 66 |
new ObjectParameter("P_FINISH_START_DATETIME", p_FINISH_START_DATETIME) :
|
| 67 |
new ObjectParameter("P_FINISH_START_DATETIME", typeof(System.DateTime));
|
| 68 |
|
| 69 |
var p_BEGIN_END_DATETIMEParameter = p_BEGIN_END_DATETIME.HasValue ? |
| 70 |
new ObjectParameter("P_BEGIN_END_DATETIME", p_BEGIN_END_DATETIME) :
|
| 71 |
new ObjectParameter("P_BEGIN_END_DATETIME", typeof(System.DateTime));
|
| 72 |
|
| 73 |
var p_FINISH_END_DATETIMEParameter = p_FINISH_END_DATETIME.HasValue ? |
| 74 |
new ObjectParameter("P_FINISH_END_DATETIME", p_FINISH_END_DATETIME) :
|
| 75 |
new ObjectParameter("P_FINISH_END_DATETIME", typeof(System.DateTime));
|
| 76 |
|
| 77 |
var p_GROUP_NOParameter = p_GROUP_NO != null ? |
| 78 |
new ObjectParameter("P_GROUP_NO", p_GROUP_NO) :
|
| 79 |
new ObjectParameter("P_GROUP_NO", typeof(string));
|
| 80 |
|
| 81 |
var p_DOCUMENT_NAMEParameter = p_DOCUMENT_NAME != null ? |
| 82 |
new ObjectParameter("P_DOCUMENT_NAME", p_DOCUMENT_NAME) :
|
| 83 |
new ObjectParameter("P_DOCUMENT_NAME", typeof(string));
|
| 84 |
|
| 85 |
var p_DOCUMENT_NOParameter = p_DOCUMENT_NO != null ? |
| 86 |
new ObjectParameter("P_DOCUMENT_NO", p_DOCUMENT_NO) :
|
| 87 |
new ObjectParameter("P_DOCUMENT_NO", typeof(string));
|
| 88 |
|
| 89 |
var p_REVISIONParameter = p_REVISION != null ? |
| 90 |
new ObjectParameter("P_REVISION", p_REVISION) :
|
| 91 |
new ObjectParameter("P_REVISION", typeof(string));
|
| 92 |
|
| 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 |
var p_DOCUMENT_URLParameter = p_DOCUMENT_URL != null ? |
| 102 |
new ObjectParameter("P_DOCUMENT_URL", p_DOCUMENT_URL) :
|
| 103 |
new ObjectParameter("P_DOCUMENT_URL", typeof(string));
|
| 104 |
|
| 105 |
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, p_DOCUMENT_URLParameter);
|
| 106 |
} |
| 107 |
|
| 108 |
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) |
| 109 |
{
|
| 110 |
var p_IDParameter = p_ID != null ? |
| 111 |
new ObjectParameter("P_ID", p_ID) :
|
| 112 |
new ObjectParameter("P_ID", typeof(string));
|
| 113 |
|
| 114 |
var p_RECONVERTERParameter = p_RECONVERTER.HasValue ? |
| 115 |
new ObjectParameter("P_RECONVERTER", p_RECONVERTER) :
|
| 116 |
new ObjectParameter("P_RECONVERTER", typeof(int));
|
| 117 |
|
| 118 |
var p_CREATE_DATETIMEParameter = p_CREATE_DATETIME.HasValue ? |
| 119 |
new ObjectParameter("P_CREATE_DATETIME", p_CREATE_DATETIME) :
|
| 120 |
new ObjectParameter("P_CREATE_DATETIME", typeof(System.DateTime));
|
| 121 |
|
| 122 |
var p_STATUSParameter = p_STATUS.HasValue ? |
| 123 |
new ObjectParameter("P_STATUS", p_STATUS) :
|
| 124 |
new ObjectParameter("P_STATUS", typeof(int));
|
| 125 |
|
| 126 |
var p_END_DATETIMEParameter = p_END_DATETIME.HasValue ? |
| 127 |
new ObjectParameter("P_END_DATETIME", p_END_DATETIME) :
|
| 128 |
new ObjectParameter("P_END_DATETIME", typeof(System.DateTime));
|
| 129 |
|
| 130 |
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_RERECONVERT_ITEM", p_IDParameter, p_RECONVERTERParameter, p_CREATE_DATETIMEParameter, p_STATUSParameter, p_END_DATETIMEParameter);
|
| 131 |
} |
| 132 |
|
| 133 |
public virtual int SELECT_CONVERT_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_URL, string p_DOCUMENT_ID) |
| 134 |
{
|
| 135 |
var p_IDParameter = p_ID != null ? |
| 136 |
new ObjectParameter("P_ID", p_ID) :
|
| 137 |
new ObjectParameter("P_ID", typeof(string));
|
| 138 |
|
| 139 |
var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
| 140 |
new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :
|
| 141 |
new ObjectParameter("P_PROJECT_NO", typeof(string));
|
| 142 |
|
| 143 |
var p_DOCUMENT_URLParameter = p_DOCUMENT_URL != null ? |
| 144 |
new ObjectParameter("P_DOCUMENT_URL", p_DOCUMENT_URL) :
|
| 145 |
new ObjectParameter("P_DOCUMENT_URL", typeof(string));
|
| 146 |
|
| 147 |
var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
| 148 |
new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) :
|
| 149 |
new ObjectParameter("P_DOCUMENT_ID", typeof(string));
|
| 150 |
|
| 151 |
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_CONVERT_INSERT", p_IDParameter, p_PROJECT_NOParameter, p_DOCUMENT_URLParameter, p_DOCUMENT_IDParameter);
|
| 152 |
} |
| 153 |
|
| 154 |
public virtual int SELECT_CONVERT_DELETE(string p_ID) |
| 155 |
{
|
| 156 |
var p_IDParameter = p_ID != null ? |
| 157 |
new ObjectParameter("P_ID", p_ID) :
|
| 158 |
new ObjectParameter("P_ID", typeof(string));
|
| 159 |
|
| 160 |
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_CONVERT_DELETE", p_IDParameter);
|
| 161 |
} |
| 162 |
|
| 163 |
public virtual int SELECT_FINAL_PDF_DELETE(string p_ID) |
| 164 |
{
|
| 165 |
var p_IDParameter = p_ID != null ? |
| 166 |
new ObjectParameter("P_ID", p_ID) :
|
| 167 |
new ObjectParameter("P_ID", typeof(string));
|
| 168 |
|
| 169 |
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_FINAL_PDF_DELETE", p_IDParameter);
|
| 170 |
} |
| 171 |
|
| 172 |
public virtual int SELECT_FINAL_PDF_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCINFO_ID, string p_DOCUMENT_ID) |
| 173 |
{
|
| 174 |
var p_IDParameter = p_ID != null ? |
| 175 |
new ObjectParameter("P_ID", p_ID) :
|
| 176 |
new ObjectParameter("P_ID", typeof(string));
|
| 177 |
|
| 178 |
var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
| 179 |
new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :
|
| 180 |
new ObjectParameter("P_PROJECT_NO", typeof(string));
|
| 181 |
|
| 182 |
var p_DOCINFO_IDParameter = p_DOCINFO_ID != null ? |
| 183 |
new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) :
|
| 184 |
new ObjectParameter("P_DOCINFO_ID", typeof(string));
|
| 185 |
|
| 186 |
var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
| 187 |
new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) :
|
| 188 |
new ObjectParameter("P_DOCUMENT_ID", typeof(string));
|
| 189 |
|
| 190 |
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_FINAL_PDF_INSERT", p_IDParameter, p_PROJECT_NOParameter, p_DOCINFO_IDParameter, p_DOCUMENT_IDParameter);
|
| 191 |
} |
| 192 |
|
| 193 |
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, string p_DOCUMENT_URL) |
| 194 |
{
|
| 195 |
var p_IDParameter = p_ID != null ? |
| 196 |
new ObjectParameter("P_ID", p_ID) :
|
| 197 |
new ObjectParameter("P_ID", typeof(string));
|
| 198 |
|
| 199 |
var p_PROJECT_NOParameter = p_PROJECT_NO != null ? |
| 200 |
new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :
|
| 201 |
new ObjectParameter("P_PROJECT_NO", typeof(string));
|
| 202 |
|
| 203 |
var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ? |
| 204 |
new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) :
|
| 205 |
new ObjectParameter("P_DOCUMENT_ID", typeof(string));
|
| 206 |
|
| 207 |
var p_MARKUPINFO_IDParameter = p_MARKUPINFO_ID != null ? |
| 208 |
new ObjectParameter("P_MARKUPINFO_ID", p_MARKUPINFO_ID) :
|
| 209 |
new ObjectParameter("P_MARKUPINFO_ID", typeof(string));
|
| 210 |
|
| 211 |
var p_DOCINFO_IDParameter = p_DOCINFO_ID != null ? |
| 212 |
new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) :
|
| 213 |
new ObjectParameter("P_DOCINFO_ID", typeof(string));
|
| 214 |
|
| 215 |
var p_DOCUMENT_NAMEParameter = p_DOCUMENT_NAME != null ? |
| 216 |
new ObjectParameter("P_DOCUMENT_NAME", p_DOCUMENT_NAME) :
|
| 217 |
new ObjectParameter("P_DOCUMENT_NAME", typeof(string));
|
| 218 |
|
| 219 |
var p_DOCUMENT_NOParameter = p_DOCUMENT_NO != null ? |
| 220 |
new ObjectParameter("P_DOCUMENT_NO", p_DOCUMENT_NO) :
|
| 221 |
new ObjectParameter("P_DOCUMENT_NO", typeof(string));
|
| 222 |
|
| 223 |
var p_CREATE_USER_IDParameter = p_CREATE_USER_ID != null ? |
| 224 |
new ObjectParameter("P_CREATE_USER_ID", p_CREATE_USER_ID) :
|
| 225 |
new ObjectParameter("P_CREATE_USER_ID", typeof(string));
|
| 226 |
|
| 227 |
var p_STATUSParameter = p_STATUS.HasValue ? |
| 228 |
new ObjectParameter("P_STATUS", p_STATUS) :
|
| 229 |
new ObjectParameter("P_STATUS", typeof(int));
|
| 230 |
|
| 231 |
var p_TAKE_COUNTParameter = p_TAKE_COUNT.HasValue ? |
| 232 |
new ObjectParameter("P_TAKE_COUNT", p_TAKE_COUNT) :
|
| 233 |
new ObjectParameter("P_TAKE_COUNT", typeof(int));
|
| 234 |
|
| 235 |
var p_GROUP_NOParameter = p_GROUP_NO != null ? |
| 236 |
new ObjectParameter("P_GROUP_NO", p_GROUP_NO) :
|
| 237 |
new ObjectParameter("P_GROUP_NO", typeof(string));
|
| 238 |
|
| 239 |
var p_REVISIONParameter = p_REVISION != null ? |
| 240 |
new ObjectParameter("P_REVISION", p_REVISION) :
|
| 241 |
new ObjectParameter("P_REVISION", typeof(string));
|
| 242 |
|
| 243 |
var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ? |
| 244 |
new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) :
|
| 245 |
new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime));
|
| 246 |
|
| 247 |
var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ? |
| 248 |
new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) :
|
| 249 |
new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime));
|
| 250 |
|
| 251 |
var p_BEGIN_START_DATETIEParameter = p_BEGIN_START_DATETIE.HasValue ? |
| 252 |
new ObjectParameter("P_BEGIN_START_DATETIE", p_BEGIN_START_DATETIE) :
|
| 253 |
new ObjectParameter("P_BEGIN_START_DATETIE", typeof(System.DateTime));
|
| 254 |
|
| 255 |
var p_FINISH_START_DATETIMEParameter = p_FINISH_START_DATETIME.HasValue ? |
| 256 |
new ObjectParameter("P_FINISH_START_DATETIME", p_FINISH_START_DATETIME) :
|
| 257 |
new ObjectParameter("P_FINISH_START_DATETIME", typeof(System.DateTime));
|
| 258 |
|
| 259 |
var p_BEGIN_END_DATETIMEParameter = p_BEGIN_END_DATETIME.HasValue ? |
| 260 |
new ObjectParameter("P_BEGIN_END_DATETIME", p_BEGIN_END_DATETIME) :
|
| 261 |
new ObjectParameter("P_BEGIN_END_DATETIME", typeof(System.DateTime));
|
| 262 |
|
| 263 |
var p_FINISH_END_DATETIMEParameter = p_FINISH_END_DATETIME.HasValue ? |
| 264 |
new ObjectParameter("P_FINISH_END_DATETIME", p_FINISH_END_DATETIME) :
|
| 265 |
new ObjectParameter("P_FINISH_END_DATETIME", typeof(System.DateTime));
|
| 266 |
|
| 267 |
var p_DOCUMENT_URLParameter = p_DOCUMENT_URL != null ? |
| 268 |
new ObjectParameter("P_DOCUMENT_URL", p_DOCUMENT_URL) :
|
| 269 |
new ObjectParameter("P_DOCUMENT_URL", typeof(string));
|
| 270 |
|
| 271 |
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, p_DOCUMENT_URLParameter);
|
| 272 |
} |
| 273 |
} |
| 274 |
} |
