MARKUS

//------------------------------------------------------------------------------

// <auto-generated>

//     이 코드는 템플릿에서 생성되었습니다.

//

//     이 파일을 수동으로 변경하면 응용 프로그램에서 예기치 않은 동작이 발생할 수 있습니다.

//     이 파일을 수동으로 변경하면 코드가 다시 생성될 때 변경 내용을 덮어씁니다.

// </auto-generated>

//------------------------------------------------------------------------------

namespace Markus.Service.StationController

{

    using System;

    using System.Data.Entity;

    using System.Data.Entity.Infrastructure;

    using System.Data.Entity.Core.Objects;

    using System.Linq;

    public partial class markusEntities : DbContext

    {

        public markusEntities()

            : base("name=markusEntities")

        {

        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)

        {

            throw new UnintentionalCodeFirstException();

        }

        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)

        {

            var p_IDParameter = p_ID != null ?

                new ObjectParameter("P_ID", p_ID) :

                new ObjectParameter("P_ID", typeof(string));

            var p_PROJECT_NOParameter = p_PROJECT_NO != null ?

                new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :

                new ObjectParameter("P_PROJECT_NO", typeof(string));

            var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ?

                new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) :

                new ObjectParameter("P_DOCUMENT_ID", typeof(string));

            var p_STATUSParameter = p_STATUS.HasValue ?

                new ObjectParameter("P_STATUS", p_STATUS) :

                new ObjectParameter("P_STATUS", typeof(int));

            var p_TAKE_COUNTParameter = p_TAKE_COUNT.HasValue ?

                new ObjectParameter("P_TAKE_COUNT", p_TAKE_COUNT) :

                new ObjectParameter("P_TAKE_COUNT", typeof(int));

            var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) :

                new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime));

            var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) :

                new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime));

            var p_BEGIN_START_DATETIEParameter = p_BEGIN_START_DATETIE.HasValue ?

                new ObjectParameter("P_BEGIN_START_DATETIE", p_BEGIN_START_DATETIE) :

                new ObjectParameter("P_BEGIN_START_DATETIE", typeof(System.DateTime));

            var p_FINISH_START_DATETIMEParameter = p_FINISH_START_DATETIME.HasValue ?

                new ObjectParameter("P_FINISH_START_DATETIME", p_FINISH_START_DATETIME) :

                new ObjectParameter("P_FINISH_START_DATETIME", typeof(System.DateTime));

            var p_BEGIN_END_DATETIMEParameter = p_BEGIN_END_DATETIME.HasValue ?

                new ObjectParameter("P_BEGIN_END_DATETIME", p_BEGIN_END_DATETIME) :

                new ObjectParameter("P_BEGIN_END_DATETIME", typeof(System.DateTime));

            var p_FINISH_END_DATETIMEParameter = p_FINISH_END_DATETIME.HasValue ?

                new ObjectParameter("P_FINISH_END_DATETIME", p_FINISH_END_DATETIME) :

                new ObjectParameter("P_FINISH_END_DATETIME", typeof(System.DateTime));

            var p_GROUP_NOParameter = p_GROUP_NO != null ?

                new ObjectParameter("P_GROUP_NO", p_GROUP_NO) :

                new ObjectParameter("P_GROUP_NO", typeof(string));

            var p_DOCUMENT_NAMEParameter = p_DOCUMENT_NAME != null ?

                new ObjectParameter("P_DOCUMENT_NAME", p_DOCUMENT_NAME) :

                new ObjectParameter("P_DOCUMENT_NAME", typeof(string));

            var p_DOCUMENT_NOParameter = p_DOCUMENT_NO != null ?

                new ObjectParameter("P_DOCUMENT_NO", p_DOCUMENT_NO) :

                new ObjectParameter("P_DOCUMENT_NO", typeof(string));

            var p_REVISIONParameter = p_REVISION != null ?

                new ObjectParameter("P_REVISION", p_REVISION) :

                new ObjectParameter("P_REVISION", typeof(string));

            var p_SERVICE_IDParameter = p_SERVICE_ID != null ?

                new ObjectParameter("P_SERVICE_ID", p_SERVICE_ID) :

                new ObjectParameter("P_SERVICE_ID", typeof(string));

            var p_RECONVERTERParameter = p_RECONVERTER.HasValue ?

                new ObjectParameter("P_RECONVERTER", p_RECONVERTER) :

                new ObjectParameter("P_RECONVERTER", typeof(int));

            var p_DOCUMENT_URLParameter = p_DOCUMENT_URL != null ?

                new ObjectParameter("P_DOCUMENT_URL", p_DOCUMENT_URL) :

                new ObjectParameter("P_DOCUMENT_URL", typeof(string));

            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);

        }

        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)

        {

            var p_IDParameter = p_ID != null ?

                new ObjectParameter("P_ID", p_ID) :

                new ObjectParameter("P_ID", typeof(string));

            var p_RECONVERTERParameter = p_RECONVERTER.HasValue ?

                new ObjectParameter("P_RECONVERTER", p_RECONVERTER) :

                new ObjectParameter("P_RECONVERTER", typeof(int));

            var p_CREATE_DATETIMEParameter = p_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_CREATE_DATETIME", p_CREATE_DATETIME) :

                new ObjectParameter("P_CREATE_DATETIME", typeof(System.DateTime));

            var p_STATUSParameter = p_STATUS.HasValue ?

                new ObjectParameter("P_STATUS", p_STATUS) :

                new ObjectParameter("P_STATUS", typeof(int));

            var p_END_DATETIMEParameter = p_END_DATETIME.HasValue ?

                new ObjectParameter("P_END_DATETIME", p_END_DATETIME) :

                new ObjectParameter("P_END_DATETIME", typeof(System.DateTime));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_RERECONVERT_ITEM", p_IDParameter, p_RECONVERTERParameter, p_CREATE_DATETIMEParameter, p_STATUSParameter, p_END_DATETIMEParameter);

        }

        public virtual int SELECT_CONVERT_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_URL, string p_DOCUMENT_ID)

        {

            var p_IDParameter = p_ID != null ?

                new ObjectParameter("P_ID", p_ID) :

                new ObjectParameter("P_ID", typeof(string));

            var p_PROJECT_NOParameter = p_PROJECT_NO != null ?

                new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :

                new ObjectParameter("P_PROJECT_NO", typeof(string));

            var p_DOCUMENT_URLParameter = p_DOCUMENT_URL != null ?

                new ObjectParameter("P_DOCUMENT_URL", p_DOCUMENT_URL) :

                new ObjectParameter("P_DOCUMENT_URL", typeof(string));

            var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ?

                new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) :

                new ObjectParameter("P_DOCUMENT_ID", typeof(string));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_CONVERT_INSERT", p_IDParameter, p_PROJECT_NOParameter, p_DOCUMENT_URLParameter, p_DOCUMENT_IDParameter);

        }

        public virtual int SELECT_CONVERT_DELETE(string p_ID)

        {

            var p_IDParameter = p_ID != null ?

                new ObjectParameter("P_ID", p_ID) :

                new ObjectParameter("P_ID", typeof(string));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_CONVERT_DELETE", p_IDParameter);

        }

        public virtual int SELECT_FINAL_PDF_DELETE(string p_ID)

        {

            var p_IDParameter = p_ID != null ?

                new ObjectParameter("P_ID", p_ID) :

                new ObjectParameter("P_ID", typeof(string));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_FINAL_PDF_DELETE", p_IDParameter);

        }

        public virtual int SELECT_FINAL_PDF_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCINFO_ID, string p_DOCUMENT_ID)

        {

            var p_IDParameter = p_ID != null ?

                new ObjectParameter("P_ID", p_ID) :

                new ObjectParameter("P_ID", typeof(string));

            var p_PROJECT_NOParameter = p_PROJECT_NO != null ?

                new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :

                new ObjectParameter("P_PROJECT_NO", typeof(string));

            var p_DOCINFO_IDParameter = p_DOCINFO_ID != null ?

                new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) :

                new ObjectParameter("P_DOCINFO_ID", typeof(string));

            var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ?

                new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) :

                new ObjectParameter("P_DOCUMENT_ID", typeof(string));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.SELECT_FINAL_PDF_INSERT", p_IDParameter, p_PROJECT_NOParameter, p_DOCINFO_IDParameter, p_DOCUMENT_IDParameter);

        }

        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)

        {

            var p_IDParameter = p_ID != null ?

                new ObjectParameter("P_ID", p_ID) :

                new ObjectParameter("P_ID", typeof(string));

            var p_PROJECT_NOParameter = p_PROJECT_NO != null ?

                new ObjectParameter("P_PROJECT_NO", p_PROJECT_NO) :

                new ObjectParameter("P_PROJECT_NO", typeof(string));

            var p_DOCUMENT_IDParameter = p_DOCUMENT_ID != null ?

                new ObjectParameter("P_DOCUMENT_ID", p_DOCUMENT_ID) :

                new ObjectParameter("P_DOCUMENT_ID", typeof(string));

            var p_MARKUPINFO_IDParameter = p_MARKUPINFO_ID != null ?

                new ObjectParameter("P_MARKUPINFO_ID", p_MARKUPINFO_ID) :

                new ObjectParameter("P_MARKUPINFO_ID", typeof(string));

            var p_DOCINFO_IDParameter = p_DOCINFO_ID != null ?

                new ObjectParameter("P_DOCINFO_ID", p_DOCINFO_ID) :

                new ObjectParameter("P_DOCINFO_ID", typeof(string));

            var p_DOCUMENT_NAMEParameter = p_DOCUMENT_NAME != null ?

                new ObjectParameter("P_DOCUMENT_NAME", p_DOCUMENT_NAME) :

                new ObjectParameter("P_DOCUMENT_NAME", typeof(string));

            var p_DOCUMENT_NOParameter = p_DOCUMENT_NO != null ?

                new ObjectParameter("P_DOCUMENT_NO", p_DOCUMENT_NO) :

                new ObjectParameter("P_DOCUMENT_NO", typeof(string));

            var p_CREATE_USER_IDParameter = p_CREATE_USER_ID != null ?

                new ObjectParameter("P_CREATE_USER_ID", p_CREATE_USER_ID) :

                new ObjectParameter("P_CREATE_USER_ID", typeof(string));

            var p_STATUSParameter = p_STATUS.HasValue ?

                new ObjectParameter("P_STATUS", p_STATUS) :

                new ObjectParameter("P_STATUS", typeof(int));

            var p_TAKE_COUNTParameter = p_TAKE_COUNT.HasValue ?

                new ObjectParameter("P_TAKE_COUNT", p_TAKE_COUNT) :

                new ObjectParameter("P_TAKE_COUNT", typeof(int));

            var p_GROUP_NOParameter = p_GROUP_NO != null ?

                new ObjectParameter("P_GROUP_NO", p_GROUP_NO) :

                new ObjectParameter("P_GROUP_NO", typeof(string));

            var p_REVISIONParameter = p_REVISION != null ?

                new ObjectParameter("P_REVISION", p_REVISION) :

                new ObjectParameter("P_REVISION", typeof(string));

            var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) :

                new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime));

            var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) :

                new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime));

            var p_BEGIN_START_DATETIEParameter = p_BEGIN_START_DATETIE.HasValue ?

                new ObjectParameter("P_BEGIN_START_DATETIE", p_BEGIN_START_DATETIE) :

                new ObjectParameter("P_BEGIN_START_DATETIE", typeof(System.DateTime));

            var p_FINISH_START_DATETIMEParameter = p_FINISH_START_DATETIME.HasValue ?

                new ObjectParameter("P_FINISH_START_DATETIME", p_FINISH_START_DATETIME) :

                new ObjectParameter("P_FINISH_START_DATETIME", typeof(System.DateTime));

            var p_BEGIN_END_DATETIMEParameter = p_BEGIN_END_DATETIME.HasValue ?

                new ObjectParameter("P_BEGIN_END_DATETIME", p_BEGIN_END_DATETIME) :

                new ObjectParameter("P_BEGIN_END_DATETIME", typeof(System.DateTime));

            var p_FINISH_END_DATETIMEParameter = p_FINISH_END_DATETIME.HasValue ?

                new ObjectParameter("P_FINISH_END_DATETIME", p_FINISH_END_DATETIME) :

                new ObjectParameter("P_FINISH_END_DATETIME", typeof(System.DateTime));

            var p_DOCUMENT_URLParameter = p_DOCUMENT_URL != null ?

                new ObjectParameter("P_DOCUMENT_URL", p_DOCUMENT_URL) :

                new ObjectParameter("P_DOCUMENT_URL", typeof(string));

            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);

        }

        public virtual int CONVERT_COUNT(Nullable<int> p_STATUS, Nullable<System.DateTime> p_BEGIN_CREATE_DATETIME, Nullable<System.DateTime> p_FINISH_CREATE_DATETIME)

        {

            var p_STATUSParameter = p_STATUS.HasValue ?

                new ObjectParameter("P_STATUS", p_STATUS) :

                new ObjectParameter("P_STATUS", typeof(int));

            var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) :

                new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime));

            var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) :

                new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("markusEntities.CONVERT_COUNT", p_STATUSParameter, p_BEGIN_CREATE_DATETIMEParameter, p_FINISH_CREATE_DATETIMEParameter);

        }

        public virtual ObjectResult<SELECT_CONVERT_COUNT> SELECT_CONVERT_COUNT(Nullable<int> p_STATUS, Nullable<System.DateTime> p_BEGIN_CREATE_DATETIME, Nullable<System.DateTime> p_FINISH_CREATE_DATETIME)

        {

            var p_STATUSParameter = p_STATUS.HasValue ?

                new ObjectParameter("P_STATUS", p_STATUS) :

                new ObjectParameter("P_STATUS", typeof(int));

            var p_BEGIN_CREATE_DATETIMEParameter = p_BEGIN_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_BEGIN_CREATE_DATETIME", p_BEGIN_CREATE_DATETIME) :

                new ObjectParameter("P_BEGIN_CREATE_DATETIME", typeof(System.DateTime));

            var p_FINISH_CREATE_DATETIMEParameter = p_FINISH_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_FINISH_CREATE_DATETIME", p_FINISH_CREATE_DATETIME) :

                new ObjectParameter("P_FINISH_CREATE_DATETIME", typeof(System.DateTime));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<SELECT_CONVERT_COUNT>("markusEntities.SELECT_CONVERT_COUNT", p_STATUSParameter, p_BEGIN_CREATE_DATETIMEParameter, p_FINISH_CREATE_DATETIMEParameter);

        }

    }

}