/ConvertService/ServiceBase/Markus.Service.StationController/ViewModel/DataBaseItemsModel.cs - MARKUS - 일정관리

markus / ConvertService / ServiceBase / Markus.Service.StationController / ViewModel / DataBaseItemsModel.cs @ 72862ad1

       using Markus.Service.Extensions;
       using Markus.Service.StationController.Data;
       using Markus.Service.StationController.Behaviors;
       using Markus.Service.StationController.Extensions;
       using Markus.Service.StationController.Controls;
       using Microsoft.Win32;
       using System;
       using System.Collections.Generic;
       using System.ComponentModel;
       using System.Linq;
       using System.Threading.Tasks;
       using System.Web;
       using System.Windows;
       using Telerik.Windows.Controls;
       using Telerik.Windows.Data;
       using System.Net;
       using System.Windows.Threading;
       using System.Diagnostics;
       using System.Windows.Input;
       using Markus.Mvvm.ToolKit;
       using System.Windows.Data;
       using System.Windows.Controls;
       using System.IO;
       using Newtonsoft.Json;
       //using Markus.Service.Interface;
       using static Markus.Service.StationController.Data.ConvertPDF;
       using System.Collections.ObjectModel;
       namespace Markus.Service.StationController.ViewModel
+      {
           //세미
           public class DataBaseItemsModel : Mvvm.ToolKit.ViewModelBase
+          {
               #region Constructor
               /// <summary>
               /// 실행하면 처음 들어가는 부분
               /// </summary>
               public DataBaseItemsModel()
+              {
                   DataFilterCommand = new DelegateCommand(DataFilter);
                   DataSaveFileGemBoxCommand = new DelegateCommand(DataExportData);
                   ConvertCommand = new DelegateCommand(DataConvert);
                   DeleteCommand = new DelegateCommand(DataDelete);
                   ValidateCommand = new DelegateCommand(DataValidate);
                   MarkusLinkCommand = new DelegateCommand(MarkusLink);
                   RemoveCreateTimeFilterCommand = new DelegateCommand(RemoveCreateTimeFilter);
                   ResetCommand = new DelegateCommand(Reset);
                   ConvertAddCommand = new DelegateCommand(ConvertAdd);
                   ConvertPathFileSearchCommand = new DelegateCommand(ConvertPathFileSearch);
+              }
               #endregion
               #region Properties
               DataService.DataServiceClient WcfClient = new DataService.DataServiceClient();
               public ObservableCollection<ProjectName> _ProjectNames;
               public ObservableCollection<ProjectName> ProjectNames
+              {
                   get
+                  {
                       if (_ProjectNames == null)
+                      {
                           _ProjectNames = new System.Collections.ObjectModel.ObservableCollection<ProjectName>();
+                      }
                       return _ProjectNames;
+                  }
                   set
+                  {
                       _ProjectNames = value;
                       OnPropertyChanged(() => ProjectNames);
+                  }
+              }
               private bool _ExcptionCheck = false;
               public bool ExcptionCheck
+              {
                   get
+                  {
                       return _ExcptionCheck;
+                  }
                   set
+                  {
                       _ExcptionCheck = value;
                       OnPropertyChanged(() => ExcptionCheck);
+                  }
+              }
               private System.Collections.ObjectModel.ObservableCollection<ConvertPDF> _FilterSearch;
               public System.Collections.ObjectModel.ObservableCollection<ConvertPDF> FilterSearch
+              {
                   get
+                  {
                       if (_FilterSearch == null)
+                      {
                           _FilterSearch = new System.Collections.ObjectModel.ObservableCollection<ConvertPDF>
+                          {
                               new ConvertPDF{ProjectNumber = "Filter Search"}
                           };
+                      }
                       return _FilterSearch;
+                  }
+              }
               private System.Collections.ObjectModel.ObservableCollection<ConvertPDF> _AliveItems;
               public System.Collections.ObjectModel.ObservableCollection<ConvertPDF> AliveItems
+              {
                   get => _AliveItems;
                   set
+                  {
                       _AliveItems = value;
                       OnPropertyChanged(() => AliveItems);
+                  }
+              }
               public ICollectionView FilterConvertSourceView
+              {
                   get
+                  {
                       var view = CollectionViewSource.GetDefaultView(FilterConvertSource);
                       return view;
+                  }
+              }
               private static System.Collections.ObjectModel.ObservableCollection<ConvertPDF> _ConvertSource;
               public static System.Collections.ObjectModel.ObservableCollection<ConvertPDF> ConvertSource
+              {
                   get
+                  {
                       if (_ConvertSource == null)
+                      {
                           _ConvertSource = new System.Collections.ObjectModel.ObservableCollection<ConvertPDF>();
+                      }
                       return _ConvertSource;
+                  }
                   set
+                  {
                       _ConvertSource = value;
+                  }
+              }
               private System.Collections.ObjectModel.ObservableCollection<ConvertPDF> _FilterConvertSource;
               public System.Collections.ObjectModel.ObservableCollection<ConvertPDF> FilterConvertSource
+              {
                   get
+                  {
                       if (_FilterConvertSource == null)
+                      {
                           _FilterConvertSource = new System.Collections.ObjectModel.ObservableCollection<ConvertPDF>();
+                      }
                       return _FilterConvertSource;
+                  }
                   set
+                  {
                       _FilterConvertSource = value;
                      OnPropertyChanged(() => FilterConvertSource);
+                  }
+              }
               private System.Collections.ObjectModel.ObservableCollection<ConvertPDF> _RealConvertSource;
               public System.Collections.ObjectModel.ObservableCollection<ConvertPDF> RealConvertSource
+              {
                   get => _RealConvertSource;
                   set
+                  {
                       _RealConvertSource = value;
                       OnPropertyChanged(() => RealConvertSource);
+                  }
+              }
               private System.Windows.Documents.FlowDocument connectionLog;
               public System.Windows.Documents.FlowDocument ConnectionLog
+              {
                   get => connectionLog;
                   set
+                  {
                       if (connectionLog != value)
+                      {
                           connectionLog = value;
                           OnPropertyChanged(() => ConnectionLog);
+                      }
+                  }
+              }
               private int _SelectedInt = 4;
               public int SelectedInt
+              {
                   get => _SelectedInt;
                   set
+                  {
                       _SelectedInt = value;
                       OnPropertyChanged(() => SelectedInt);
+                  }
+              }
               private Telerik.Windows.Data.EnumMemberViewModel _SelectedStatus;
               public Telerik.Windows.Data.EnumMemberViewModel SelectedStatus
+              {
                   get => _SelectedStatus;
                   set
+                  {
                       _SelectedStatus = value;
                       OnPropertyChanged(() => SelectedStatus);
+                  }
+              }
               private SelectedCountItem _SelectedCount;
               public SelectedCountItem SelectedCount
+              {
                   get => _SelectedCount;
                   set
+                  {
                       _SelectedCount = value;
                       OnPropertyChanged(() => SelectedCount);
+                  }
+              }
               List<SelectedCountItem> _SelectedCountList;
               public List<SelectedCountItem> SelectedCountList
+              {
                   get
+                  {
                       if (_SelectedCountList == null)
+                      {
                           _SelectedCountList = new List<SelectedCountItem>
+                          {
                               new SelectedCountItem{DisplayMember = "50",ValueMember = 50},
                               new SelectedCountItem{DisplayMember = "100",ValueMember = 100},
                               new SelectedCountItem{DisplayMember = "150",ValueMember = 150},
                               new SelectedCountItem{DisplayMember = "200",ValueMember = 200}
                           };
+                      }
                       return _SelectedCountList;
+                  }
+              }
               private ConvertPDF _SelectFilterConvert;
               public ConvertPDF SelectFilterConvert
+              {
                   get
+                  {
                       return _SelectFilterConvert;
+                  }
                   set
+                  {
                       _SelectFilterConvert = value;
                       OnPropertyChanged(() => SelectFilterConvert);
+                  }
+              }
               private ObservableCollection<ConvertPDF> _SelectFilterConvertList;
               public ObservableCollection<ConvertPDF> SelectFilterConvertList
+              {
                   get
+                  {
                       if (_SelectFilterConvertList == null)
+                      {
                           _SelectFilterConvertList = new ObservableCollection<ConvertPDF>();
+                      }
                       return _SelectFilterConvertList;
+                  }
                   set
+                  {
                       _SelectFilterConvertList = value;
                       OnPropertyChanged(() => SelectFilterConvertList);
+                  }
+              }
               private ConvertPDF _SelectRealConvert;
               public ConvertPDF SelectRealConvert
+              {
                   get => _SelectRealConvert;
                   set
+                  {
                       _SelectRealConvert = value;
                       OnPropertyChanged(() => SelectRealConvert);
+                  }
+              }
               private ConvertPDF _SelectAliveConvert;
               public ConvertPDF SelectAliveConvert
+              {
                   get => _SelectAliveConvert;
                   set
+                  {
                       _SelectAliveConvert = value;
                       OnPropertyChanged(() => SelectAliveConvert);
+                  }
+              }
               private StatusTypeList _StatusType;
               public StatusTypeList StatusType
+              {
                   get => _StatusType;
                   set
+                  {
                       _StatusType = value;
                       OnPropertyChanged(() => StatusType);
+                  }
+              }
               private bool _IsLoading;
               public bool IsLoading
+              {
                   get => _IsLoading;
                   set
+                  {
                       if (_IsLoading != value)
+                      {
                           _IsLoading = value;
                           OnPropertyChanged(() => IsLoading);
+                      }
+                  }
+              }
               IEnumerable<Telerik.Windows.Data.EnumMemberViewModel> _StatusCodeList;
               public IEnumerable<Telerik.Windows.Data.EnumMemberViewModel> StatusCodeList
+              {
                   get
+                  {
                       if (_StatusCodeList == null)
+                      {
                           _StatusCodeList = Telerik.Windows.Data.EnumDataSource.FromType<StatusCodeType>();
+                      }
                       return _StatusCodeList;
+                  }
+              }
               public ProjectName _ProjectNumberFilter;
               public ProjectName ProjectNumberFilter
+              {
                   get
+                  {
                       if (_ProjectNumberFilter == null)
+                      {
                           _ProjectNumberFilter = new ProjectName();
+                      }
                       return _ProjectNumberFilter;
+                  }
                   set
+                  {
                       _ProjectNumberFilter = value;
                       OnPropertyChanged(() => ProjectNumberFilter);
+                  }
+              }
               public string _UniqueKeyFilter;
               public string UniqueKeyFilter
+              {
                   get
+                  {
                       return _UniqueKeyFilter;
+                  }
                   set
+                  {
                       if (_UniqueKeyFilter == "")
+                      {
                           _UniqueKeyFilter = null;
+                      }
                       else if (_UniqueKeyFilter != value)
+                      {
                           _UniqueKeyFilter = value;
                           OnPropertyChanged(() => UniqueKeyFilter);
+                      }
+                  }
+              }
               public StatusCodeType _ConvertStateFilter;
               public StatusCodeType ConvertStateFilter
+              {
                   get { return _ConvertStateFilter; }
                   set
+                  {
                       if (_ConvertStateFilter != value)
+                      {
                           _ConvertStateFilter = value;
                           OnPropertyChanged(() => ConvertStateFilter);
+                      }
+                  }
+              }
               public string _Docuemnt_NOFilter;
               public string Docuemnt_NOFilter
+              {
                   get { return _Docuemnt_NOFilter; }
                   set
+                  {
                       if (_Docuemnt_NOFilter == "")
+                      {
                           _Docuemnt_NOFilter = null;
+                      }
                       else if (_Docuemnt_NOFilter != value)
+                      {
                           _Docuemnt_NOFilter = value;
                           OnPropertyChanged(() => Docuemnt_NOFilter);
+                      }
+                  }
+              }
               public string _Document_NameFilter;
               public string Document_NameFilter
+              {
                   get { return _Document_NameFilter; }
                   set
+                  {
                       if (_Document_NameFilter == "")
+                      {
                           _Document_NameFilter = null;
+                      }
                       else if (_Document_NameFilter != value)
+                      {
                           _Document_NameFilter = value;
                           OnPropertyChanged(() => Document_NameFilter);
+                      }
+                  }
+              }
               public int? _ReconverterFilter = 0;
               public int? ReconverterFilter
+              {
                   get { return _ReconverterFilter; }
                   set
+                  {
                       if (_ReconverterFilter == null)
+                      {
                           _ReconverterFilter = 0;
+                      }
                       else if (_ReconverterFilter != value)
+                      {
                           _ReconverterFilter = value;
                           OnPropertyChanged(() => ReconverterFilter);
+                      }
+                  }
+              }
               public string _Service_IDFilter;
               public string Service_IDFilter
+              {
                   get { return _Service_IDFilter; }
                   set
+                  {
                       if (_Service_IDFilter == "")
+                      {
                           _Service_IDFilter = null;
+                      }
                       else if (_Service_IDFilter != value)
+                      {
                           _Service_IDFilter = value;
                           OnPropertyChanged(() => Service_IDFilter);
+                      }
+                  }
+              }
               public string _RevisionFilter;
               public string RevisionFilter
+              {
                   get { return _RevisionFilter; }
                   set
+                  {
                       if (_RevisionFilter == "")
+                      {
                           _RevisionFilter = null;
+                      }
                       else if (_RevisionFilter != value)
+                      {
                           _RevisionFilter = value;
                           OnPropertyChanged(() => RevisionFilter);
+                      }
+                  }
+              }
               public string _GroupNOFilter;
               public string GroupNOFilter
+              {
                   get { return _GroupNOFilter; }
                   set
+                  {
                       if (_GroupNOFilter == "")
+                      {
                           _GroupNOFilter = null;
+                      }
                       else if (_GroupNOFilter != value)
+                      {
                           _GroupNOFilter = value;
                           OnPropertyChanged(() => GroupNOFilter);
+                      }
+                  }
+              }
               public string _DOCUMENT_URLFilter;
               public string DOCUMENT_URLFilter
+              {
                   get { return _DOCUMENT_URLFilter; }
                   set
+                  {
                       if (_DOCUMENT_URLFilter == "")
+                      {
                           _DOCUMENT_URLFilter = null;
+                      }
                       else if (_DOCUMENT_URLFilter != value)
+                      {
                           _DOCUMENT_URLFilter = value;
                           OnPropertyChanged(() => DOCUMENT_URLFilter);
+                      }
+                  }
+              }
               static DateTime DefaultCreateTime = DateTime.Now;
               private DateTime _SelectedCreateTimeBegin = DefaultCreateTime;
               public DateTime SelectedCreateTimeBegin
+              {
                   get { return _SelectedCreateTimeBegin; }
                   set
+                  {
                       if (_SelectedCreateTimeBegin == value)
                           return;
                       _SelectedCreateTimeBegin = value;
                       OnPropertyChanged(() => SelectedCreateTimeBegin);
+                  }
+              }
               private DateTime _SelectedCreateTimeEnd = DefaultCreateTime;
               public DateTime SelectedCreateTimeEnd
+              {
                   get { return _SelectedCreateTimeEnd; }
                   set
+                  {
                       if (_SelectedCreateTimeEnd == value)
                           return;
                       _SelectedCreateTimeEnd = value;
                       OnPropertyChanged(() => SelectedCreateTimeEnd);
+                  }
+              }
               public bool _ConvertShow;
               public bool ConvertShow
+              {
                   get => _ConvertShow;
                   set
+                  {
                       if (_ConvertShow = !value)
+                      {
                           _ConvertShow = false;
+                      }
                       _ConvertShow = value;
                       OnPropertyChanged(() => ConvertShow);
+                  }
+              }
               #endregion
               #region Command
               public DelegateCommand ConvertCommand { get; private set; }
               public DelegateCommand DeleteCommand { get; private set; }
               public DelegateCommand ValidateCommand { get; private set; }
               public DelegateCommand DataSaveFileGemBoxCommand { get; private set; }
               public DelegateCommand MarkusLinkCommand { get; private set; }
               public DelegateCommand RemoveCreateTimeFilterCommand { get; private set; }
               public DelegateCommand DataFilterCommand { get; private set; }
               public DelegateCommand ResetCommand { get; private set; }
               public DelegateCommand ConvertAddCommand { get; private set; }
               public DelegateCommand ConvertPathFileSearchCommand { get; private set; }
               #endregion
               #region Main Logic
               /// <summary>
               /// 각각의 Grid row 객체들 업데이트
               /// </summary>
               private DispatcherTimer dispatcherTimer;
               public override void Loaded()
+              {
                   base.Loaded();
                   if (!App.IsDesignMode)
+                  {
                       dispatcherTimer = new DispatcherTimer();
                       dispatcherTimer.Tick += new EventHandler(Timer_Tick);
                       dispatcherTimer.Interval = new TimeSpan(0, 0, 1);
                       dispatcherTimer.Start();
+                  }
+              }
               private async void Timer_Tick(object sender, EventArgs e)
+              {
                   dispatcherTimer.Stop();
                   if (IsAcitve)
+                  {
                       await App.Current.Dispatcher.InvokeAsync(() =>
+                      {
                           DataSelect();
                           AliveDataSelect();
                       });
+                  }
                   await Task.Delay(5000);
                   System.Threading.Thread.Sleep(new TimeSpan(0, 0, 0, 0, 100));
                   dispatcherTimer.Start();
+              }
               private async void SearchTimer_Tick(object sender, EventArgs e)
+              {
                   dispatcherTimer.Stop();
                   if (IsAcitve)
+                  {
                       await App.Current.Dispatcher.InvokeAsync(() =>
+                      {
                           DataSearch(new[] { (StatusCodeType)(SelectedStatus.Value) }, FilterConvertSource);
                           RealDataSelect(new[] { StatusCodeType.None, StatusCodeType.Wait, StatusCodeType.PageLoading, StatusCodeType.Saving }, RealConvertSource);
                           AliveDataSelect();
                       });
+                  }
                   await Task.Delay(5000);
                   //await Task.Delay(10000);
                   System.Threading.Thread.Sleep(new TimeSpan(0, 0, 0, 0, 100));
                   dispatcherTimer.Start();
+              }
               public override void Closed()
+              {
                   if (dispatcherTimer != null)
+                  {
                       dispatcherTimer.Stop();
+                  }
                   base.Closed();
+              }
               #endregion
               #region Function
               #region Return_FilterConvertSource
               public static void Return_FilterConvertSource(ObservableCollection<ConvertPDF> convertPDFs)
+              {
                   ConvertSource = new ObservableCollection<ConvertPDF>();
                   ConvertSource = convertPDFs;
+              }
               public static ObservableCollection<ConvertPDF> Return_FilterConvertSource()
+              {
                   return ConvertSource;
+              }
               #endregion
               #region Data Select
               /// <summary>
               /// 상단 그리드 중앙 그리드 출력 데이터
               /// </summary>
               private void DataSelect()
+              {
                   if (FilterConvertSource == null)
+                  {
                       FilterConvertSource = new System.Collections.ObjectModel.ObservableCollection<ConvertPDF>();
+                  }
                   if (RealConvertSource == null)
+                  {
                       RealConvertSource = new System.Collections.ObjectModel.ObservableCollection<ConvertPDF>();
+                  }
                   /// combobox 에서 선택된 items
                   if (SelectedStatus != null)
+                  {
                       DataSelect(new[] { (StatusCodeType)(SelectedStatus.Value) }, FilterConvertSource);
+                  }
                   /// 컨버터중인 items
                   RealDataSelect(new[] { StatusCodeType.None, StatusCodeType.Wait, StatusCodeType.PageLoading, StatusCodeType.Saving }, RealConvertSource);
+              }
               private async void RealDataSelect(IEnumerable<StatusCodeType> statusCodeTypeList, System.Collections.ObjectModel.ObservableCollection<ConvertPDF> collection)
+              {
                   try
+                  {
                       List<ConvertPDF> Listitems = new List<ConvertPDF>();
                       foreach (var coll in collection)
+                      {
                          var collectionItems = from num in await WcfClient.GET_SELECT_CONVERT_ITEMAsync(coll.ConvertID, coll.ProjectNumber, null, null, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null)
                                       let MarkusLink = "kcom://" + CreateMarkusParam(num.PROJECT_NO, num.DOCUMENT_ID, "doftech")
                                       select new ConvertPDF(num.SERVICE_ID, num.ID, num.PROJECT_NO, num.STATUS, num.DOCUMENT_ID, num.DOCUMENT_NAME, num.DOCUMENT_NO, num.DOCUMENT_URL, num.REVISION, num.CURRENT_PAGE,
                                   num.TOTAL_PAGE, num.EXCEPTION, num.GROUP_NO, num.CREATE_DATETIME, num.START_DATETIME, num.END_DATETIME, num.DOCUMENT_URL, num.CONVERT_PATH, MarkusLink, num.RECONVERTER);
                           var collectionItem = collectionItems.Cast<ConvertPDF>().ToList();
                           Listitems.AddRange(collectionItem);
+                      }
                       foreach (var Listitem in Listitems)
+                      {
                           collection.UpdateWhere(changeitem =>
                           ConvertItemEx.ChangeValues(changeitem, Listitem), x => x.ProjectNumber == Listitem.ProjectNumber && x.ConvertID == Listitem.ConvertID);
+                      }
+                  }
                   catch (Exception ex)
+                  {
                       MessageBox.Show(ex.ToString());
+                  }
+              }
               private async void DataSelect(IEnumerable<StatusCodeType> statusCodeTypeList, System.Collections.ObjectModel.ObservableCollection<ConvertPDF> collection)
+              {
                   try
+                  {
                       int _status = 0;
                       if (SelectedStatus != null)
+                      {
                           _status = (int)SelectedStatus.Value;
+                      }
                       if (ProjectNames.Count() == 0)
+                      {
                           ProjectName Clear = new ProjectName("Clear", "Clear");
                           ProjectNames.Add(Clear);
                           foreach (var x in await WcfClient.GET_SELECT_RUN_PROJECTSAsync(0))
+                          {
                               ProjectName projectName = new ProjectName(x.PROJECT_NO, x.PROJECT_NAME);
                               ProjectNames.Add(projectName);
+                          }
+                      }
                       var Listitems = from num in await WcfClient.GET_SELECT_CONVERT_ITEMAsync(null, null, null, _status, SelectedCount.ValueMember, null, null, null, null, null, null, null, null, null, null, null, null, null, null)
                                       let MarkusLink = "kcom://" + CreateMarkusParam(num.PROJECT_NO, num.DOCUMENT_ID, "doftech")
                                       select new ConvertPDF(num.SERVICE_ID, num.ID, num.PROJECT_NO, num.STATUS, num.DOCUMENT_ID, num.DOCUMENT_NAME, num.DOCUMENT_NO, num.DOCUMENT_URL, num.REVISION, num.CURRENT_PAGE,
                                                               num.TOTAL_PAGE, num.EXCEPTION, num.GROUP_NO, num.CREATE_DATETIME, num.START_DATETIME, num.END_DATETIME, num.DOCUMENT_URL, num.CONVERT_PATH, MarkusLink, num.RECONVERTER);
                       if (collection.Count() == 0)
+                      {
                           if (statusCodeTypeList.Count() == 1)
+                          {
                               //Listitems.ForEach(x => collection.Add(x));
                               foreach (var Listitem in Listitems.ToList())
+                              {
                                   collection.Add(Listitem);
+                              }
+                          }
+                      }
                       else
+                      {
                           foreach (var Listitem in Listitems)
+                          {
                               collection.UpdateWhere(changeitem =>
                               ConvertItemEx.ChangeValues(changeitem, Listitem), x => x.ProjectNumber == Listitem.ProjectNumber && x.ConvertID == Listitem.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)
+                          {
                               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);
                                                   break;
+                                              }
+                                          }
                                           else
+                                          {
                                               collection.Add(item);
                                               break;
+                                          }
+                                      }
+                                  }
+                              }
+                          }
+                      }
+                  }
                   catch (Exception ex)
+                  {
                       MessageBox.Show(ex.ToString());
                       //System.Diagnostics.Debug.WriteLine(ex.ToString());
+                  }
+              }
               private async void DataSearch(IEnumerable<StatusCodeType> statusCodeTypeList, System.Collections.ObjectModel.ObservableCollection<ConvertPDF> collection)
+              {
                   try
+                  {
                       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;
+                      }
                       if (ProjectNames.Count() == 0)
+                      {
                           foreach (var x in await WcfClient.GET_SELECT_RUN_PROJECTSAsync(0))
+                          {
                               ProjectName projectName = new ProjectName(x.PROJECT_NO, x.PROJECT_NAME);
                               ProjectNames.Add(projectName);
+                          }
+                      }
                       var Listitems = from num in await WcfClient.GET_SELECT_CONVERT_ITEMAsync(null, ProjectNumberFilter.Project_NO, UniqueKeyFilter, _status, SelectedCount.ValueMember, Start_CreateTime, Finish_CreateTime, null,
                   null, null, null, GroupNOFilter, Document_NameFilter, Docuemnt_NOFilter, RevisionFilter, Service_IDFilter, ReconverterFilter, DOCUMENT_URLFilter, ExcptionCheck)
                                       let MarkusLink = "kcom://" + CreateMarkusParam(num.PROJECT_NO, num.DOCUMENT_ID, "doftech")
                                       select new ConvertPDF(num.SERVICE_ID, num.ID, num.PROJECT_NO, num.STATUS, num.DOCUMENT_ID, num.DOCUMENT_NAME, num.DOCUMENT_NO, num.DOCUMENT_URL, num.REVISION, num.CURRENT_PAGE,
                  num.TOTAL_PAGE, num.EXCEPTION, num.GROUP_NO, num.CREATE_DATETIME, num.START_DATETIME, num.END_DATETIME, num.DOCUMENT_URL, num.CONVERT_PATH, MarkusLink, num.RECONVERTER);
                       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);
                                                   break;
+                                              }
+                                          }
                                           else
+                                          {
                                               collection.Add(item);
                                               break;
+                                          }
+                                      }
+                                  }
+                              }
+                          }
+                      }
+                  }
                   catch (Exception ex)
+                  {
                       MessageBox.Show(ex.ToString());
                       //System.Diagnostics.Debug.WriteLine(ex.ToString());
+                  }
+              }
               /// <summary>
               /// 서비스의 실시간 컨버터 Item
               /// </summary>
               private async void AliveDataSelect()
+              {
                   try
+                  {
                       List<ConvertPDF> newitems = new List<ConvertPDF>();
                       foreach (var client in App.StationClientList)
+                      {
                           if (await SimplePingAsync(client.Endpoint.Address.ToString()))
+                          {
                               try
+                              {
                                   List<ConvertPDF> itemsToList = new List<ConvertPDF>();
                                   var items = await client.AliveConvertListAsync();
                                   string result = "";
                                   foreach (var item in items)
+                                  {
                                       ConvertPDF itemsToEach = new ConvertPDF();
                                       itemsToEach.ServiceID = item.ServiceID;
                                       itemsToEach.ConvertID = item.ConvertID;
                                       itemsToEach.ProjectNumber = item.ProjectNumber;
                                       var MarkusLink = "kcom://" + CreateMarkusParam(item.ProjectNumber, item.DocumentID, "doftech");
                                       if (item.ConvertState != null)
+                                      {
                                           itemsToEach.ConvertState = (StatusCodeType)Enum.Parse(typeof(StatusCodeType), item.ConvertState);
+                                      }
                                       if (item.OriginfilePath.Contains("/"))
+                                      {
                                           result = item.OriginfilePath.Substring(item.OriginfilePath.LastIndexOf("/") + 1);
+                                      }
                                       else
+                                      {
                                           result = item.OriginfilePath.Substring(item.OriginfilePath.LastIndexOf("%") + 1);
+                                      }
                                       itemsToEach.FileName = result;
                                       itemsToEach.CurrentPageNo = item.CurrentPageNo;
                                       itemsToEach.TotalPage = item.TotalPage;
                                       itemsToEach.OriginfilePath = item.OriginfilePath;
                                       itemsToEach.ConvertPath = item.ConvertPath;
                                       itemsToEach.MarkusLink = MarkusLink;
                                       itemsToEach.UniqueKey = item.UniqueKey;//DocumentNO 없음
                                       itemsToEach.GroupNo = item.GroupNo;//없음
                                       //itemsToEach.ProcessorAffinity = item.ProcessorAffinity;
                                       itemsToEach.DocumentName = item.DocumnetName;
                                       itemsToEach.Revision = item.Revision; //없음
                                       itemsToEach.Exception = item.Exception;//없음
                                       itemsToEach.ConvertPath = item.ConvertPath;
                                       itemsToEach.CreateTime = item.CreateTime;
                                       itemsToEach.ReConverter = item.ReConverter;
                                       itemsToEach.DocumentID = item.DocumentID;
                                       itemsToEach.StartTime = item.StartTime;
                                       itemsToEach.EndTime = item.EndTime;
                                       itemsToList.Add(itemsToEach);
+                                  }
                                   newitems.AddRange(itemsToList);
                                   System.Diagnostics.Trace.WriteLine($"{client.Endpoint.Address} ping");
                                   if (items.Count() == 0)
+                                  {
                                       System.Diagnostics.Trace.WriteLine($"{client.Endpoint.Address} Alive Items is zero.");
+                                  }
+                              }
                               catch (Exception ex)
+                              {
                                   System.Diagnostics.Trace.Fail($"{client.Endpoint.Address} {ex.Message}");
+                              }
+                          }
                           else
+                          {
                               System.Diagnostics.Trace.Fail($"{client.Endpoint.Address} ping Error");
+                          }
+                      }
                       ItemsUpdate(newitems);
                       await System.Windows.Application.Current.Dispatcher.InvokeAsync(() => ItemsUpdate(newitems));
+                  }
                   catch (Exception ex)
+                  {
                       System.Diagnostics.Debug.WriteLine(ex.ToString());
+                  }
+              }
               /// <summary>
               /// AliveDataSelect의 Data Update
               /// </summary>
               /// <param name="newitems"></param>
               private void ItemsUpdate(List<ConvertPDF> newitems)
+              {
                   foreach (var item in newitems)
+                  {
                       item.OriginfilePath = HttpUtility.UrlDecode(item.OriginfilePath);
+                  }
                   if (AliveItems == null)
+                  {
                       AliveItems = new System.Collections.ObjectModel.ObservableCollection<ConvertPDF>();
                       foreach (var item in newitems)
+                      {
                           AliveItems.Add(item);
+                      }
+                  }
                   else
+                  {
                       /// 데이터 업데이트
                       newitems.ForEach(newitem =>
+                      {
                           AliveItems.UpdateWhere(changeitem => ConvertItemEx.ChangeValues(changeitem, newitem), x => x.ProjectNumber == newitem.ProjectNumber && x.ConvertID == newitem.ConvertID);
                       });
                       // 추가
                       foreach (var item in newitems)
+                      {
                           if (AliveItems.Count(x => x.ConvertID == item.ConvertID && x.ProjectNumber == item.ProjectNumber) == 0)
+                          {
                               AliveItems.Add(item);
+                          }
+                      }
                       /// 삭제
                       for (int i = AliveItems.Count() - 1; i > -1; --i)
+                      {
                           var item = AliveItems[i];
                           if (newitems.Count(x => x.ConvertID == item.ConvertID && x.ProjectNumber == item.ProjectNumber) == 0)
+                          {
                               try
+                              {
                                   AliveItems.RemoveAt(i);
+                              }
                               catch (Exception ex)
+                              {
                                   System.Diagnostics.Debug.WriteLine(ex.ToString());
+                              }
+                          }
+                      }
+                  }
+              }
               public static async Task<bool> SimplePingAsync(string uri)
+              {
                   bool result = false;
                   try
+                  {
                       using (System.Net.Http.HttpClient Client = new System.Net.Http.HttpClient())
+                      {
                           Client.Timeout = new TimeSpan(0, 0, 60);
                           var message = await Client.GetAsync(uri);
                           System.Net.HttpStatusCode StatusCode = message.StatusCode;
                           switch (StatusCode)
+                          {
                               case System.Net.HttpStatusCode.Accepted:
                               case System.Net.HttpStatusCode.OK:
                                   result = true;
                                   break;
+                          }
+                      }
+                  }
                   catch (Exception ex)
+                  {
                       result = false;
                       System.Diagnostics.Debug.WriteLine(ex.ToString());
+                  }
                   return result;
+              }
               #endregion
               #region Data Convert
               private async void DataConvert(object obj)
+              {
                   if (SelectFilterConvertList == null)
+                  {
                       MessageBox.Show("왼쪽 버튼 클릭 후 Converter 해주세요!");
+                  }
                   else
+                  {
                       if (SelectRealConvert != null)
+                      {
                           SetCleanUpItem(SelectRealConvert);//ConvertDataBase
+                      }
                       if (SelectFilterConvertList != null)
+                      {
                           foreach (var SelectFilterConvert in SelectFilterConvertList)
+                          {
                               SetCleanUpItem(SelectFilterConvert);
+                          }
+                      }
                       foreach (var SelectFilterConvert in SelectFilterConvertList)
+                      {
                           var items = from x in await WcfClient.GET_SELECT_CONVERT_ITEMAsync(SelectFilterConvert.ConvertID, null, null, null, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null)
                                       let MarkusLink = "kcom://" + CreateMarkusParam(x.PROJECT_NO, x.DOCUMENT_ID, "doftech")
                                       select new ConvertPDF(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, x.CONVERT_PATH, MarkusLink, x.RECONVERTER);
                           foreach (var item in items)
+                          {
                               RealConvertSource.Add(item);
                               if (RealConvertSource.Count() == 1)
+                              {
                                   ConvertShow = true;
+                              }
+                          }
+                      }
+                  }
+              }
               public async void SetCleanUpItem(ConvertPDF _ConvertItem)
+              {
                   var items = await WcfClient.GET_SELECT_CONVERT_ITEMAsync(_ConvertItem.ConvertID, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
                   if (items.Count() > 0)
+                  {
                       var item = items.First();
                       var _RECONVERTER = item.RECONVERTER - _ConvertItem.ReConverter;
                       var _CREATE_DATETIME = DateTime.Now;
                       var _STATUS = (int)StatusCodeType.None;
                       await WcfClient.GET_SELECT_RERECONVERT_ITEMAsync(_ConvertItem.ConvertID, _RECONVERTER, _CREATE_DATETIME, _STATUS, null);//_END_DATETIME = null 에러
+                  }
+              }
               public static string CreateMarkusParam(string projectNo, string documentID, string userID)
+              {
                   ViewInfo viewInfo = new ViewInfo();
                   viewInfo.DocumentItemID = documentID;
                   viewInfo.ProjectNO = projectNo;
                   viewInfo.UserID = userID;
                   return ParamEncoding(JsonConvert.SerializeObject(viewInfo));
+              }
               public static string ParamEncoding(string EncodingText, System.Text.Encoding oEncoding = null)
+              {
                   if (oEncoding == null)
                       oEncoding = System.Text.Encoding.UTF8;
                   return Convert.ToBase64String(oEncoding.GetBytes(EncodingText));
+              }
               #endregion
               #region Validation
               private void DataValidate(object obj)
+              {
                   if (SelectFilterConvertList.Count() > 1)
+                  {
                       MessageBox.Show("하나만 클릭해 주세요");
+                  }
                   else
+                  {
                       bool result = false;
                       WebRequest webRequest = WebRequest.Create(SelectFilterConvertList[0].OriginfilePath);
                       webRequest.Timeout = 1200; // miliseconds
                       webRequest.Method = "HEAD";
                       HttpWebResponse response = null;
                       try
+                      {
                           response = (HttpWebResponse)webRequest.GetResponse();
                           result = true;
+                      }
                       catch (WebException webException)
+                      {
                           MessageBox.Show(SelectFilterConvert.FileName + " doesn't exist: " + webException.Message);
                           result = true;
+                      }
                       finally
+                      {
                           if (response != null)
+                          {
                               response.Close();
+                          }
+                      }
                       if (result == true)
+                      {
                           MessageBox.Show("File exists");
+                      }
+                  }
+              }
               #endregion
               #region DataFilter
               public void DataFilter(object obj)
+              {
                   dispatcherTimer.Tick -= new EventHandler(Timer_Tick);
                   dispatcherTimer.Tick += new EventHandler(SearchTimer_Tick);
                   //DataSearch(new[] { (StatusCodeType)(SelectedStatus.Value) }, FilterConvertSource);
+              }
               #endregion
               #region MarkusLink
               private void MarkusLink(object obj)
+              {
                   if (obj is ConvertPDF)
+                  {
                       if (obj != null)
+                      {
                           var convertitem = obj as ConvertPDF;
                           SelectFilterConvertList[0] = convertitem;
                           SelectRealConvert = convertitem;
                           ProcessStartInfo startInfo = null;
                           startInfo = new ProcessStartInfo("iexplore.exe", convertitem.MarkusLink);
                           Process.Start(startInfo);
+                      }
+                  }
+              }
               #endregion
               #region Data Delete
               private void DataDelete(object obj)
+              {
                   RadWindow.Alert("Do you want to delete it??", this.OnClosed);
+              }
               private async void OnClosed(object sender, WindowClosedEventArgs e)
+              {
+                  {
                       var result = e.DialogResult;
                       if (result == true)
+                      {
                           if (SelectFilterConvertList.Count() > 1)
+                          {
                               MessageBox.Show("하나만 클릭해 주세요!");
+                          }
                           else
+                          {
                               if (SelectRealConvert != null)
+                              {
                                   await WcfClient.GET_SELECT_CONVERT_DELETEAsync(SelectRealConvert.ConvertID);
+                              }
                               if (SelectFilterConvertList != null)
+                              {
                                   await WcfClient.GET_SELECT_CONVERT_DELETEAsync(SelectFilterConvertList[0].ConvertID);
+                              }
+                          }
+                      }
+                  }
+              }
               #endregion
               #region Data Export
               /// <summary>
               /// 필터된 상단 그리드 엑셀로 출력
               /// </summary>
               public void DataExportData(object obj)
+              {
                   dispatcherTimer.Tick -= new EventHandler(Timer_Tick);
                   Return_FilterConvertSource(FilterConvertSource);
                   Views.ConvertExcelDialog convertExcelDialog = new Views.ConvertExcelDialog();
                   convertExcelDialog.Owner = Application.Current.MainWindow;
                   convertExcelDialog.WindowStartupLocation = WindowStartupLocation.CenterOwner;
                   convertExcelDialog.ShowDialog();
                   dispatcherTimer.Tick += new EventHandler(Timer_Tick);
+              }
               #endregion
               #region Data Search
               public void RemoveCreateTimeFilter(object obj)
+              {
                   DefaultCreateTime = DateTime.Now;
                   SelectedCreateTimeBegin = DefaultCreateTime;
                   SelectedCreateTimeEnd = DefaultCreateTime;
+              }
               #endregion
               #region Reset
               /// <summary>
               /// 그리드 상단 원상복귀 버튼
               /// 필터를 끝낸 후 다시 복귀
               /// </summary>
               public void Reset(object obj)
+              {
                   SelectedInt = 10;
                   ProjectNumberFilter = ProjectNames[0];
                   UniqueKeyFilter = null;
                   Service_IDFilter = null;
                   Document_NameFilter = null;
                   Docuemnt_NOFilter = null;
                   ReconverterFilter = null;
                   RevisionFilter = null;
                   GroupNOFilter = null;
                   DOCUMENT_URLFilter = null;
                   DefaultCreateTime = DateTime.Now;
                   SelectedCreateTimeBegin = DefaultCreateTime;
                   SelectedCreateTimeEnd = DefaultCreateTime;
                   dispatcherTimer.Tick -= new EventHandler(SearchTimer_Tick);
                   dispatcherTimer.Tick += new EventHandler(Timer_Tick);
+              }
               #endregion
               #region ConvertAddDialog
               /// <summary>
               /// 그리드 상단 Conver 추가 버튼
               /// ProjectNo, DocumentURL, DocumentID, 입력해서 저장 프로시저에서 추가
               /// </summary>
               public void ConvertAdd(object obj)
+              {
                   dispatcherTimer.Tick -= new EventHandler(Timer_Tick);
                   Views.ConvertAddDialog convertAddDialog = new Views.ConvertAddDialog();
                   convertAddDialog.WindowStartupLocation = WindowStartupLocation.CenterOwner;
                   convertAddDialog.ShowDialog();
                   dispatcherTimer.Tick += new EventHandler(Timer_Tick);
+              }
               #endregion
               #region ConvertPathFileSearch
               /// <summary>
               ///  ConvertPath 파일 탐색기로 열리는 아이콘
               /// </summary>
               public void ConvertPathFileSearch(object obj)
+              {
                   if (obj is ConvertPDF)
+                  {
                       if (obj != null)
+                      {
                           var convertitem = obj as ConvertPDF;
                           if (!string.IsNullOrEmpty(convertitem.ConvertPath))
+                          {
                               System.Diagnostics.Process.Start("explorer.exe", convertitem.ConvertPath);
+                          }
+                      }
+                  }
+              }
               #endregion
               #endregion
+          }
+      }

프로젝트

일반

사용자정보

MARKUS

markus / ConvertService / ServiceBase / Markus.Service.StationController / ViewModel / DataBaseItemsModel.cs @ 72862ad1