MARKUS

        //DataSearch 상단 그리드 Search  DataConvert

            DateTime create_datetime, DateTime? start_datetime, DateTime? end_datetime , string originfilePath, string convertPath, string markusLink, int? reconverter)//20

            ReConverter = reconverter;

        public ConvertItem(string convertId, string projectNo, int Status, string documentID, string markupInfoID, string docInfoID ,string documentName, string documentNo, string createUserID,//20

            string revision, int currentPageNo, int totalPage, string exception, string groupNo, DateTime create_datetime, DateTime? start_datetime, DateTime? end_datetime, string originfilePath,

            string convertPath, string markusLink, int Final)

        {//FinalPDF

            ConvertID = convertId;

            ProjectNumber = projectNo;

            DocumentID = documentID;

            ConvertID = convertId;

            ProjectNumber = projectNo;

            MarkupInfo_ID = markupInfoID;

            Create_User_ID = createUserID;

            ConvertState = (StatusCodeType)Status;

            DocInfo_ID = docInfoID;

            DocumnetName = documentName;

            DocumnetNo = documentNo;

            Revision = revision;

            CurrentPageNo = currentPageNo;

            TotalPage = totalPage;

            Exception = exception;

            GroupNo = groupNo;

            CreateTime = create_datetime;

            StartTime = start_datetime;

            EndTime = end_datetime;

            ConvertPath = convertPath;

            MarkusLink = markusLink;

            OriginfilePath = originfilePath;

            if (OriginfilePath != null)

            {

                string result = "";

                if (originfilePath.Contains("/"))

                {

                    result = originfilePath.Substring(originfilePath.LastIndexOf("/") + 1);

                }

                else

                {

                    result = originfilePath.Substring(originfilePath.LastIndexOf("%") + 1);

                }

                this._FileName = result;

            }

            else

            {

                this._FileName = "";

            }

        }

        int? _reConverter;

        public int? ReConverter

        [DataMember]

        private string _DocInfo_ID;

        public string DocInfo_ID

        {

            get

            {

                return _DocInfo_ID;

            }

            set

            {

                if (_DocInfo_ID != value)

                {

                    _DocInfo_ID = value;

                    OnPropertyChanged("DocInfo_ID");

                }

            }

        }

        [DataMember]

        private string _MarkupInfo_ID;

        public string MarkupInfo_ID

        {

            get

            {

                return _MarkupInfo_ID;

            }

            set

            {

                if (_MarkupInfo_ID != value)

                {

                    _MarkupInfo_ID = value;

                    OnPropertyChanged("MarkupInfo_ID");

                }

            }

        }

        [DataMember]

        private string _Create_User_ID;

        public string Create_User_ID

        {

            get

            {

                return _Create_User_ID;

            }

            set

            {

                if (_Create_User_ID != value)

                {

                    _Create_User_ID = value;

                    OnPropertyChanged("Create_User_ID");

                }

            }

        }

        public IEnumerable<Interface.ConvertItem> GetConvertProjects(int status,string ProjectNumberFilter, string UniqueKeyFilter, string Document_NameFilter, string Service_IDFilter, string Docuemnt_NOFilter, int? ReconverterFilter

                         || subpet.DOCUMENT_NAME.Contains(Document_NameFilter)

        /// <summary>Final PDF

        /// 상단 그리드 선택된 Status에 따라 DB에서 값 가져온다.

        /// </summary>

        public IEnumerable<Interface.ConvertItem> GetFinalPDFProjects(int status, string ProjectNumberFilter, string DocumentIDFIlter, string MarkupInfo_IDFilter, string DOCINFO_IDFilter, string Document_NameFilter,

            string Docuemnt_NOFilter, string CreateUser_IDFilter)

        {

            var MarkupInfo_IDFilter_Int = 0;

            if (MarkupInfo_IDFilter != null)

            {

                MarkupInfo_IDFilter_Int = int.Parse(MarkupInfo_IDFilter);

            }

            List<Interface.ConvertItem> convertItems = new List<Interface.ConvertItem>();

            var query = from items in entities.FINAL_PDF

                        join documents in entities.DOCUMENT_ITEM on items.DOCUMENT_ID equals documents.DOCUMENT_ID into GroupItems

                        from subpet in GroupItems.DefaultIfEmpty()

                        where items.STATUS == status &&

                        //

                        (

                         items.PROJECT_NO.Contains(ProjectNumberFilter)

                         || subpet.DOCUMENT_ID.Contains(DocumentIDFIlter)

                         || items.MARKUPINFO_ID == MarkupInfo_IDFilter_Int

                         || items.DOCINFO_ID.Contains(DOCINFO_IDFilter)

                         || subpet.DOCUMENT_NAME.Contains(Document_NameFilter)

                         || subpet.DOCUMENT_NO.Contains(Docuemnt_NOFilter)

                         || items.CREATE_USER_ID.Contains(CreateUser_IDFilter)

                         )

                        //

                        orderby items.CREATE_DATETIME descending

                        select new

                        {

                            ID = items.ID,

                            PROJECT_NO = items.PROJECT_NO,

                            DOCINFO_ID = items.DOCINFO_ID,

                            MARKUPINFO_ID = items.MARKUPINFO_ID,

                            CREATE_USER_ID = items.CREATE_USER_ID,

                            CREATE_DATETIME = items.CREATE_DATETIME,

                            STATUS = items.STATUS,

                            TOTAL_PAGE = items.TOTAL_PAGE,

                            CURRENT_PAGE = items.CURRENT_PAGE,

                            EXCEPTION = items.EXCEPTION,

                            END_DATETIME = items.END_DATETIME,

                            START_DATETIME = items.START_DATETIME,

                            DOCUMENT_ID = items.DOCUMENT_ID,

                            DOCUMENT_URL = subpet.ORIGINAL_FILE,

                            REVISION = subpet.REVISION,

                            GROUP_NO = subpet.GROUP_NO,

                            RESULT_FILE = subpet.RESULT_FILE,

                            RESULT = subpet.RESULT,

                            DOCUMENT_NO = subpet.DOCUMENT_NO,

                            DOCUMENT_NAME = subpet.DOCUMENT_NAME

                        };

            if (query.Count() > 0)//세미

            {

                foreach (var item in query)

                {

                    Interface.ConvertItem convertitem = new Interface.ConvertItem(item.DOCUMENT_ID, item.PROJECT_NO, item.ID, item.DOCUMENT_URL)

                    {

                        ConvertID = item.ID,

                        DocInfo_ID = item.DOCINFO_ID,

                        MarkupInfo_ID = item.MARKUPINFO_ID.ToString(),

                        Create_User_ID = item.CREATE_USER_ID,

                        CreateTime = item.CREATE_DATETIME,

                        ConvertState = (StatusCodeType)item.STATUS,

                        TotalPage = item.TOTAL_PAGE,

                        CurrentPageNo = item.CURRENT_PAGE,

                        Exception = item.EXCEPTION,

                        EndTime = (DateTime)item.END_DATETIME,

                        StartTime = (DateTime)item.START_DATETIME,

                        DocumnetNo = item.DOCUMENT_NO,

                        DocumnetName = item.DOCUMENT_NAME,

                        GroupNo = item.GROUP_NO,

                        Revision = item.REVISION,

                        ConvertPath = GetConvertPath(item.PROJECT_NO, item.DOCUMENT_ID),

                        MarkusLink = "kcom://" + Markus.Service.DataBase.Extensions.MarkusAPI.CreateMarkusParam(item.PROJECT_NO, item.DOCUMENT_ID, "doftech")

                    };

                    convertItems.Add(convertitem);

                }

            }

            return convertItems;

        }

                            GROUP_NO = subpet.GROUP_NO

        public IEnumerable<Interface.ConvertItem> GetConvertFinalPDFProjects(System.Collections.ObjectModel.ObservableCollection<Interface.ConvertItem> selectedConvert)

        {

            List<Interface.ConvertItem> StatusKeep = new List<Interface.ConvertItem>();

            List<Interface.ConvertItem> convertItems = new List<Interface.ConvertItem>();

            foreach (var selectedConvertItem in selectedConvert)

            {

                var query = from items in entities.FINAL_PDF //세미

                            join documents in entities.DOCUMENT_ITEM on items.DOCUMENT_ID equals documents.DOCUMENT_ID into GroupItems

                            from subpet in GroupItems.DefaultIfEmpty()

                            where items.PROJECT_NO == selectedConvertItem.ProjectNumber && items.ID == selectedConvertItem.ConvertID

                            select new

                            {

                                ID = items.ID,

                                PROJECT_NO = items.PROJECT_NO,

                                DOCINFO_ID = items.DOCINFO_ID,

                                MARKUPINFO_ID = items.MARKUPINFO_ID,

                                CREATE_USER_ID = items.CREATE_USER_ID,

                                CREATE_DATETIME = items.CREATE_DATETIME,

                                STATUS = items.STATUS,

                                TOTAL_PAGE = items.TOTAL_PAGE,

                                CURRENT_PAGE = items.CURRENT_PAGE,

                                EXCEPTION = items.EXCEPTION,

                                END_DATETIME = items.END_DATETIME,

                                START_DATETIME = items.START_DATETIME,

                                DOCUMENT_ID = items.DOCUMENT_ID,

                                DOCUMENT_URL = subpet.ORIGINAL_FILE,

                                DOCUMENT_NO = subpet.DOCUMENT_NO,

                                DOCUMENT_NAME = subpet.DOCUMENT_NAME

                            };

                if (query.Count() > 0)//세미

                {

                    foreach (var item in query)

                    {

                        Interface.ConvertItem convertitem = new Interface.ConvertItem(item.DOCUMENT_ID, item.PROJECT_NO, item.ID, item.DOCUMENT_URL)

                        {

                            DocInfo_ID = item.DOCINFO_ID,

                            MarkupInfo_ID = item.MARKUPINFO_ID.ToString(),

                            Create_User_ID = item.CREATE_USER_ID,

                            CreateTime = item.CREATE_DATETIME,

                            ConvertState = (StatusCodeType)item.STATUS,

                            TotalPage = item.TOTAL_PAGE,

                            CurrentPageNo = item.CURRENT_PAGE,

                            Exception = item.EXCEPTION,

                            EndTime = (DateTime)item.END_DATETIME,

                            StartTime = (DateTime)item.START_DATETIME,

                            DocumnetNo = item.DOCUMENT_NO,

                            DocumnetName = item.DOCUMENT_NAME,

                            ConvertPath = GetConvertPath(item.PROJECT_NO, item.DOCUMENT_ID),

                            MarkusLink = "kcom://" + Markus.Service.DataBase.Extensions.MarkusAPI.CreateMarkusParam(item.PROJECT_NO, item.DOCUMENT_ID, "doftech")

                        };

                        StatusKeep.Add(convertitem);

                    }

                }

            }

            return StatusKeep;

        }

        public IEnumerable<Interface.ConvertItem> GetConvertFinalPDFProjects(Markus.Service.Interface.ConvertItem selectedConvert)

        {

            List<Interface.ConvertItem> StatusKeep = new List<Interface.ConvertItem>();

            System.Diagnostics.Stopwatch stopwatch = new System.Diagnostics.Stopwatch();

            stopwatch.Start();

            List<Interface.ConvertItem> convertItems = new List<Interface.ConvertItem>();//디비 다 조인 후 조건 비교 후 그리드 출력

            var query = from items in entities.FINAL_PDF //세미

                        join documents in entities.DOCUMENT_ITEM on items.DOCUMENT_ID equals documents.DOCUMENT_ID into GroupItems

                        from subpet in GroupItems.DefaultIfEmpty()

                        where items.PROJECT_NO == selectedConvert.ProjectNumber && items.DOCUMENT_ID == selectedConvert.DocumentID

                        orderby items.CREATE_DATETIME descending

                        select new

                        {

                            ID = items.ID,

                            PROJECT_NO = items.PROJECT_NO,

                            DOCINFO_ID = items.DOCINFO_ID,

                            MARKUPINFO_ID = items.MARKUPINFO_ID,

                            CREATE_USER_ID = items.CREATE_USER_ID,

                            CREATE_DATETIME = items.CREATE_DATETIME,

                            STATUS = items.STATUS,

                            TOTAL_PAGE = items.TOTAL_PAGE,

                            CURRENT_PAGE = items.CURRENT_PAGE,

                            EXCEPTION = items.EXCEPTION,

                            END_DATETIME = items.END_DATETIME,

                            START_DATETIME = items.START_DATETIME,

                            DOCUMENT_ID = items.DOCUMENT_ID,

                            DOCUMENT_URL = subpet.ORIGINAL_FILE,

                            DOCUMENT_NO = subpet.DOCUMENT_NO,

                            DOCUMENT_NAME = subpet.DOCUMENT_NAME

                        };

            if (query.Count() > 0)//세미

            {

                foreach (var item in query)

                {

                    Interface.ConvertItem convertitem = new Interface.ConvertItem(item.DOCUMENT_ID, item.PROJECT_NO, item.ID, item.DOCUMENT_URL)

                    {

                        DocInfo_ID = item.DOCINFO_ID,

                        MarkupInfo_ID = item.MARKUPINFO_ID.ToString(),

                        Create_User_ID = item.CREATE_USER_ID,

                        CreateTime = item.CREATE_DATETIME,

                        ConvertState = (StatusCodeType)item.STATUS,

                        TotalPage = item.TOTAL_PAGE,

                        CurrentPageNo = item.CURRENT_PAGE,

                        Exception = item.EXCEPTION,

                        EndTime = (DateTime)item.END_DATETIME,

                        StartTime = (DateTime)item.START_DATETIME,

                        DocumnetNo = item.DOCUMENT_NO,

                        DocumnetName = item.DOCUMENT_NAME,

                        ConvertPath = GetConvertPath(item.PROJECT_NO, item.DOCUMENT_ID),

                        MarkusLink = "kcom://" + Markus.Service.DataBase.Extensions.MarkusAPI.CreateMarkusParam(item.PROJECT_NO, item.DOCUMENT_ID, "doftech")

                    };

                    StatusKeep.Add(convertitem);

                }

            }

            System.Diagnostics.Debug.WriteLine(new TimeSpan(stopwatch.ElapsedTicks).ToString());

            return StatusKeep;

        }

        public int SetCleanUpFinalPDFItem(ConvertItem _ConvertItem)

            var items = entities.FINAL_PDF.Where(x => x.ID == _ConvertItem.ConvertID);

                //item.RECONVERTER = item.RECONVERTER - _ConvertItem.ReConverter;

        //public int SetCleanUpItem(ConvertItem _ConvertItem)

        //{

        //    int result = 0;

        //    var items = entities.CONVERTER_DOC.Where(x => x.ID == _ConvertItem.ConvertID);

        //    result = items.Count();

        //    if (items.Count() > 0)

        //    {

        //        var item = items.First();

        //        item.RECONVERTER = item.RECONVERTER - _ConvertItem.ReConverter;

        //        item.CREATE_DATETIME = DateTime.Now;

        //        item.STATUS = (int)StatusCodeType.None;

        //        item.END_DATETIME = null;

        //        result = entities.SaveChanges();

        //    }

        //    return result;

        //}

        /// 

        public int RemoveFinalPDFItem(string convertID)

        {

            int result = 0;

            var items = entities.FINAL_PDF.Where(x => x.ID == convertID);

            if (items.Count() > 0)

            {

                FINAL_PDF item = items.First();

                entities.FINAL_PDF.Remove(item);

                result = entities.SaveChanges();

            }

            return result;

        } 

         EmptyContent="Docuemnt Name" Value="{Binding Document_NameFilter , UpdateSourceTrigger=PropertyChanged, Mode=TwoWay}"

        private void DatePicker1_SelectionChanged(object sender, SelectionChangedEventArgs e)

        {

        }

    <Compile Include="SELECT_FINAL_PDF_Result.cs">

    <Compile Include="ViewModel\FinalPDFViewModel.cs" />

    <Compile Include="ViewModel\FinalPDFAddDialogViewModel.cs" />

    <Compile Include="Views\FinalPDFAddDialog.xaml.cs">

      <DependentUpon>FinalPDFAddDialog.xaml</DependentUpon>

    </Compile>

    <Compile Include="Views\FinalPDFViewInfo.xaml.cs">

      <DependentUpon>FinalPDFViewInfo.xaml</DependentUpon>

    </Compile>

    <Compile Include="Views\FinalPDFView.xaml.cs">

      <DependentUpon>FinalPDFView.xaml</DependentUpon>

    </Compile>

    <Page Include="Views\FinalPDFAddDialog.xaml">

      <Generator>MSBuild:Compile</Generator>

      <SubType>Designer</SubType>

    </Page>

    <Page Include="Views\FinalPDFViewInfo.xaml">

      <SubType>Designer</SubType>

      <Generator>MSBuild:Compile</Generator>

    </Page>

    <Page Include="Views\FinalPDFView.xaml">

      <SubType>Designer</SubType>

      <Generator>MSBuild:Compile</Generator>

    </Page>

        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)

            var p_IDParameter = p_ID != null ?

                new ObjectParameter("P_ID", p_ID) :

                new ObjectParameter("P_ID", 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));

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

        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_CREATE_DATETIMEParameter = p_CREATE_DATETIME.HasValue ?

                new ObjectParameter("P_CREATE_DATETIME", p_CREATE_DATETIME) :

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

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

        {

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

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

        }

        <Function Name="SELECT_CONVERT_DELETE" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">

          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />

        </Function>

          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />

          <Parameter Name="P_SERVICE_ID" Type="nvarchar" Mode="In" />

          <Parameter Name="P_RECONVERTER" Type="int" Mode="In" />

        </Function>

        <Function Name="SELECT_FINAL_PDF_DELETE" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">

          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />

        </Function>

        <Function Name="SELECT_FINAL_PDF_INSERT" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">

          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />

          <Parameter Name="P_PROJECT_NO" Type="nvarchar" Mode="In" />

          <Parameter Name="P_DOCINFO_ID" Type="nvarchar" Mode="In" />

          <Parameter Name="P_DOCUMENT_ID" Type="nvarchar" Mode="In" />

        </Function>

        <Function Name="SELECT_FINAL_PDF_ITEM" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">

          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />

          <Parameter Name="P_PROJECT_NO" Type="nvarchar" Mode="In" />

          <Parameter Name="P_DOCUMENT_ID" Type="nvarchar" Mode="In" />

          <Parameter Name="P_MARKUPINFO_ID" Type="nvarchar" Mode="In" />

          <Parameter Name="P_DOCINFO_ID" Type="nvarchar" Mode="In" />

          <Parameter Name="P_DOCUMENT_NAME" Type="nvarchar" Mode="In" />

          <Parameter Name="P_DOCUMENT_NO" Type="nvarchar" Mode="In" />

          <Parameter Name="P_CREATE_USER_ID" Type="nvarchar" Mode="In" />

          <Parameter Name="P_STATUS" Type="int" Mode="In" />

          <Parameter Name="P_TAKE_COUNT" Type="int" Mode="In" />

          <Parameter Name="P_GROUP_NO" Type="nvarchar" Mode="In" />

          <Parameter Name="P_REVISION" Type="nvarchar" Mode="In" />

          <Parameter Name="P_BEGIN_CREATE_DATETIME" Type="datetime" Mode="In" />

          <Parameter Name="P_FINISH_CREATE_DATETIME" Type="datetime" Mode="In" />

          <Parameter Name="P_BEGIN_START_DATETIE" Type="datetime" Mode="In" />

          <Parameter Name="P_FINISH_START_DATETIME" Type="datetime" Mode="In" />

          <Parameter Name="P_BEGIN_END_DATETIME" Type="datetime" Mode="In" />

          <Parameter Name="P_FINISH_END_DATETIME" Type="datetime" Mode="In" />

          <Parameter Name="P_CREATE_DATETIME" Type="datetime" Mode="In" />

          <Parameter Name="P_END_DATETIME" Type="datetime" Mode="In" />

            <Parameter Name="P_ID" Mode="In" Type="String" />

            <Parameter Name="P_SERVICE_ID" Mode="In" Type="String" />

            <Parameter Name="P_RECONVERTER" Mode="In" Type="Int32" />

          <FunctionImport Name="SELECT_RERECONVERT_ITEM">

            <Parameter Name="P_CREATE_DATETIME" Mode="In" Type="DateTime" />

            <Parameter Name="P_END_DATETIME" Mode="In" Type="DateTime" />

          <FunctionImport Name="SELECT_CONVERT_DELETE">

          <Parameter Name="P_ID" Mode="In" Type="String" />

          </FunctionImport>

          <FunctionImport Name="SELECT_FINAL_PDF_DELETE">

          <Parameter Name="P_ID" Mode="In" Type="String" />

          </FunctionImport>

          <FunctionImport Name="SELECT_FINAL_PDF_INSERT">

            <Parameter Name="P_ID" Mode="In" Type="String" />

            <Parameter Name="P_PROJECT_NO" Mode="In" Type="String" />

            <Parameter Name="P_DOCINFO_ID" Mode="In" Type="String" />

            <Parameter Name="P_DOCUMENT_ID" Mode="In" Type="String" />

          </FunctionImport>

          <FunctionImport Name="SELECT_FINAL_PDF_ITEM" ReturnType="Collection(markusModel.SELECT_FINAL_PDF_Result)">

            <Parameter Name="P_ID" Mode="In" Type="String" />

            <Parameter Name="P_PROJECT_NO" Mode="In" Type="String" />

            <Parameter Name="P_DOCUMENT_ID" Mode="In" Type="String" />

            <Parameter Name="P_MARKUPINFO_ID" Mode="In" Type="String" />

            <Parameter Name="P_DOCINFO_ID" Mode="In" Type="String" />

            <Parameter Name="P_DOCUMENT_NAME" Mode="In" Type="String" />

            <Parameter Name="P_DOCUMENT_NO" Mode="In" Type="String" />

            <Parameter Name="P_CREATE_USER_ID" Mode="In" Type="String" />

            <Parameter Name="P_STATUS" Mode="In" Type="Int32" />

            <Parameter Name="P_TAKE_COUNT" Mode="In" Type="Int32" />

            <Parameter Name="P_GROUP_NO" Mode="In" Type="String" />

            <Parameter Name="P_REVISION" Mode="In" Type="String" />

            <Parameter Name="P_BEGIN_CREATE_DATETIME" Mode="In" Type="DateTime" />

            <Parameter Name="P_FINISH_CREATE_DATETIME" Mode="In" Type="DateTime" />

            <Parameter Name="P_BEGIN_START_DATETIE" Mode="In" Type="DateTime" />

            <Parameter Name="P_FINISH_START_DATETIME" Mode="In" Type="DateTime" />

            <Parameter Name="P_BEGIN_END_DATETIME" Mode="In" Type="DateTime" />

            <Parameter Name="P_FINISH_END_DATETIME" Mode="In" Type="DateTime" />

          </FunctionImport>

          <Property Type="String" Name="PROPERTIES_VALUE" Nullable="false" />

        <ComplexType Name="SELECT_FINAL_PDF_Result" >

          <Property Type="String" Name="ID" Nullable="false" />

          <Property Type="String" Name="PROJECT_NO" Nullable="false" />

          <Property Type="String" Name="DOCUMENT_ID" Nullable="false" />

          <Property Type="String" Name="MARKUPINFO_ID" Nullable="false" />

          <Property Type="String" Name="DOCINFO_ID" Nullable="false" />

          <Property Type="String" Name="DOCUMENT_NAME" Nullable="false" />

          <Property Type="String" Name="DOCUMENT_NO" Nullable="false" />

          <Property Type="String" Name="CREATE_USER_ID" Nullable="false" />

          <Property Type="String" Name="GROUP_NO" Nullable="false" />

          <Property Type="Int32" Name="STATUS" Nullable="false" />

          <Property Type="String" Name="REVISION" Nullable="false" />

          <Property Type="DateTime" Name="CREATE_DATETIME" Nullable="false" />

          <Property Type="DateTime" Name="START_DATETIME" Nullable="true" />

          <Property Type="DateTime" Name="END_DATETIME" Nullable="true" />

          <Property Type="Int32" Name="CURRENT_PAGE" Nullable="false" />

          <Property Type="Int32" Name="TOTAL_PAGE" Nullable="false" />

          <Property Type="String" Name="ORIGINAL_FILE" Nullable="false" />

          <Property Type="String" Name="EXCEPTION" Nullable="false" />

          <Property Type="String" Name="RESULT_FILE" Nullable="false" />

          <Property Type="String" Name="RESULT" Nullable="false" />

          <Property Type="String" Name="LINK" Nullable="false" />

          <Property Type="String" Name="PROPERTIES_TYPE" Nullable="false" />

          <Property Type="String" Name="PROPERTIES_PROPERTY" Nullable="false" />

          <Property Type="String" Name="PROPERTIES_VALUE" Nullable="false" />

          </FunctionImportMapping>

          <FunctionImportMapping FunctionImportName="SELECT_CONVERT_INSERT" FunctionName="markusModel.Store.SELECT_CONVERT_INSERT" />

          <FunctionImportMapping FunctionImportName="SELECT_CONVERT_DELETE" FunctionName="markusModel.Store.SELECT_CONVERT_DELETE" />

          <FunctionImportMapping FunctionImportName="SELECT_FINAL_PDF_DELETE" FunctionName="markusModel.Store.SELECT_FINAL_PDF_DELETE" />

          <FunctionImportMapping FunctionImportName="SELECT_FINAL_PDF_INSERT" FunctionName="markusModel.Store.SELECT_FINAL_PDF_INSERT" />

          <FunctionImportMapping FunctionImportName="SELECT_FINAL_PDF_ITEM" FunctionName="markusModel.Store.SELECT_FINAL_PDF_ITEM" >

              <ComplexTypeMapping TypeName="markusModel.SELECT_FINAL_PDF_Result" />

        public string PROPERTIES_VALUE { get; set; }

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

// <auto-generated>

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

//

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

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

// </auto-generated>

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

namespace Markus.Service.StationController

{

    using System;

    public partial class SELECT_FINAL_PDF_Result

    {

        public string ID { get; set; }

        public string PROJECT_NO { get; set; }

        public string DOCUMENT_ID { get; set; }

        public string MARKUPINFO_ID { get; set; }

        public string DOCINFO_ID { get; set; }

        public string DOCUMENT_NAME { get; set; }

        public string DOCUMENT_NO { get; set; }

        public string CREATE_USER_ID { get; set; }

        public string GROUP_NO { get; set; }

        public int STATUS { get; set; }

        public string REVISION { get; set; }

        public System.DateTime CREATE_DATETIME { get; set; }

        public Nullable<System.DateTime> START_DATETIME { get; set; }

        public Nullable<System.DateTime> END_DATETIME { get; set; }

        public int CURRENT_PAGE { get; set; }

        public int TOTAL_PAGE { get; set; }

        public string ORIGINAL_FILE { get; set; }

        public string EXCEPTION { get; set; }

        public string RESULT_FILE { get; set; }

        public string RESULT { get; set; }

        public string LINK { get; set; }

        public string PROPERTIES_TYPE { get; set; }

        public string PROPERTIES_PROPERTY { get; set; }

        public string PROPERTIES_VALUE { get; set; }

    }

}

using System.IO;

        public string _Document_NameFilter;

        public string Document_NameFilter

            get { return _Document_NameFilter; }

                if (_Document_NameFilter == "")

                    _Document_NameFilter = null;

                else if (_Document_NameFilter != value)

                    _Document_NameFilter = value;

                    OnPropertyChanged(() => Document_NameFilter);

                using (markusEntities entities = new markusEntities())

                    List<ConvertItem> Listitems = new List<ConvertItem>();

                    foreach (var coll in collection)

                    {

                        var items = entities.SELECT_CONVERT_ITEM(coll.ConvertID, coll.ProjectNumber, null, null, 1, null, null, null, null, null, null, null, null, null, null, null, null).ToList();

                        foreach (var x in items)

                        {

                            var convertpath = GetSearchConvertPathAndMarkus(x.PROJECT_NO, x.DOCUMENT_ID);

                            ConvertItem AddItem = new ConvertItem(x.SERVICE_ID, x.ID, x.PROJECT_NO, x.STATUS, x.DOCUMENT_ID, x.DOCUMENT_NAME, x.DOCUMENT_NO, x.DOCUMENT_URL, x.REVISION, x.CURRENT_PAGE,

                                x.TOTAL_PAGE, x.EXCEPTION, x.GROUP_NO, x.CREATE_DATETIME, x.START_DATETIME, x.END_DATETIME, x.DOCUMENT_URL, convertpath[0], convertpath[1], x.RECONVERTER);

                            Listitems.Add(AddItem);

                        }

                    }

                    Listitems.ForEach(newitem =>

                //using (Markus.Service.DataBase.ConvertDatabase database = new Markus.Service.DataBase.ConvertDatabase(App.MarkusDataBaseConnecitonString))

                //{

                //    var items = database.GetConvertProjects(collection)//x:database객체 y:statusCodeTypeList의값  Count()안에 predicator 조건 만족하면 count개수안에 넣음

                //                          .Take(SelectedCount.ValueMember).ToList();//

                //    items.ForEach(newitem =>

                //    {

                //        collection.UpdateWhere(changeitem =>

                //        ConvertItemEx.ChangeValues(changeitem, newitem), x => x.ConvertID == newitem.ConvertID && x.ProjectNumber == newitem.ProjectNumber);

                //    });

                //    RealConvert_Height = 80 + (10 * collection.Count());

                //    DataBase_ItemsHeight = 800 - (RealConvert_Height + Alive_Height);

                //}

                using (markusEntities entities = new markusEntities())

                    var items = entities.SELECT_CONVERT_ITEM(null, null, null, _status, SelectedCount.ValueMember, null, null, null,

                        null, null, null, null, null, null, null, null, null).ToList();

                    //var items = database.GetConvertProjects(_status, ProjectNumberFilter, UniqueKeyFilter, Document_NameFilter, Service_IDFilter, Docuemnt_NOFilter

                    //    , ReconverterFilter, RevisionFilter)//x:database객체 y:statusCodeTypeList의값  Count()안에 predicator 조건 만족하면 count개수안에 넣음

                    //                      .Take(SelectedCount.ValueMember).ToList();

                    List<ConvertItem> Listitems = new List<ConvertItem>();

                    foreach (var x in items)

                    {

                        var convertpath = GetSearchConvertPathAndMarkus(x.PROJECT_NO, x.DOCUMENT_ID);

                        ConvertItem AddItem = new ConvertItem(x.SERVICE_ID, x.ID, x.PROJECT_NO, x.STATUS, x.DOCUMENT_ID, x.DOCUMENT_NAME, x.DOCUMENT_NO, x.DOCUMENT_URL, x.REVISION, x.CURRENT_PAGE,

                            x.TOTAL_PAGE, x.EXCEPTION, x.GROUP_NO, x.CREATE_DATETIME, x.START_DATETIME, x.END_DATETIME, x.DOCUMENT_URL, convertpath[0], convertpath[1], x.RECONVERTER);

                        Listitems.Add(AddItem);

                    }

                            Listitems.ForEach(x => collection.Add(x));

                        Listitems.ForEach(newitem =>

                                if (Listitems.Count(x => x.ConvertID == item.ConvertID && x.ProjectNumber == item.ProjectNumber) == 0)//디비에서 가져온 값과 마지막값부터 차례대로 비교

                            foreach (var item in Listitems)

                using (markusEntities entities = new markusEntities())

                    int _status = 0;

                    if (SelectedStatus != null)

                        _status = (int)SelectedStatus.Value;

                    }

                    //DocumentID = unikey

                    DateTime? Start_CreateTime = null;

                    DateTime? Finish_CreateTime = null;

                    if(SelectedCreateTimeBegin != DefaultCreateTime)

                    {

                        Start_CreateTime = SelectedCreateTimeBegin;

                    }

                    if(SelectedCreateTimeEnd != DefaultCreateTime)

                    {

                        Finish_CreateTime = SelectedCreateTimeEnd;

                    }

                    var items = entities.SELECT_CONVERT_ITEM(null, ProjectNumberFilter, UniqueKeyFilter, _status, SelectedCount.ValueMember, Start_CreateTime, Finish_CreateTime, null,

                        null, null, null, GroupNOFilter, Document_NameFilter, Docuemnt_NOFilter, RevisionFilter, Service_IDFilter, ReconverterFilter).ToList();

                    List<ConvertItem> Listitems = new List<ConvertItem>();

                    foreach (var x in items)

                    {

                        var convertpath = GetSearchConvertPathAndMarkus(x.PROJECT_NO, x.DOCUMENT_ID);

                        ConvertItem AddItem = new ConvertItem(x.SERVICE_ID, x.ID, x.PROJECT_NO, x.STATUS, x.DOCUMENT_ID, x.DOCUMENT_NAME, x.DOCUMENT_NO, x.DOCUMENT_URL, x.REVISION, x.CURRENT_PAGE,

                            x.TOTAL_PAGE, x.EXCEPTION, x.GROUP_NO, x.CREATE_DATETIME, x.START_DATETIME, x.END_DATETIME, x.DOCUMENT_URL, convertpath[0], convertpath[1], x.RECONVERTER);

                        Listitems.Add(AddItem);

                    }

                    if (collection.Count() == 0)

                    {

                        if (statusCodeTypeList.Count() == 1)

                            foreach (var x in Listitems)

                                collection.Add(x);

                    }

                    else

                    {

                        ////세미 업데이트

                        foreach (var newitem in Listitems)

                            collection.UpdateWhere(changeitem =>

                            ConvertItemEx.ChangeValues(changeitem, newitem), x => x.ProjectNumber == newitem.ProjectNumber && x.ConvertID == newitem.ConvertID);

                        }

                        if (statusCodeTypeList.Count() == 1)

                        {

                            //삭제

                            for (int i = collection.Count() - 1; i >= 0; --i)

                                var item = collection[i];

                                if (Listitems.Count(x => x.ConvertID == item.ConvertID && x.ProjectNumber == item.ProjectNumber) == 0)

                                    collection.RemoveAt(i);

                        }

                        if (statusCodeTypeList.Count() == 1)

                        {

                            //추가 convert 후 추가됨

                            foreach (var item in Listitems)

                                if (collection.Count(x => x.ConvertID == item.ConvertID && x.ProjectNumber == item.ProjectNumber) == 0)

                                    for (int i = 0; i < 200; i++)

                                        if (i < collection.Count() - 1)

                                            if (DateTime.Compare(collection[i].CreateTime, item.CreateTime) < 0)

                                                collection.Insert(i, item);

                                        else

                                        {

                                            collection.Add(item);

                                            break;

                                        }

                            }

                foreach (var client in App.StationClientList)

                    if (await SimplePingAsync(client.Endpoint.Address.ToString()))

                        try

                            List<ConvertItem> itemsToList = new List<ConvertItem>();

                            var items = await client.AliveConvertListAsync();

                            string result = "";

                            foreach (var item in items)

                            {

                                ConvertItem itemsToEach = new ConvertItem();

                                itemsToEach.ServiceID = item.ServiceID;

                                itemsToEach.ConvertID = item.ConvertID;

                                itemsToEach.ProjectNumber = item.ProjectNumber;