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

markus / ConvertService / ServiceBase / Markus.Service.StationController / ViewModel / DataBaseItemsModel.cs @ 43b2e236

       using Markus.Message;
       using Markus.Service.DataBase;
       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 ConvertItem = Markus.Service.Interface.ConvertItem;
       using System.Net;
       using System.Windows.Threading;
       using System.Diagnostics;
       using System.Windows.Input;
       using Markus.Mvvm.ToolKit;
       using System.Windows.Data;
       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);
                   FilterConvertSourceView.Filter = new Predicate<object>(o => DetailFilter(o as ConvertItem));
                   ResetCommand = new DelegateCommand(Reset);
                   ConverAddCommand = new DelegateCommand(ConverAdd);
+              }
               #endregion
               #region Properties
               private System.Collections.ObjectModel.ObservableCollection<ConvertItem> _FilterSearch;
               public System.Collections.ObjectModel.ObservableCollection<ConvertItem> FilterSearch
+              {
                   get
+                  {
                       if (_FilterSearch == null)
+                      {
                           _FilterSearch = new System.Collections.ObjectModel.ObservableCollection<ConvertItem>
+                          {
                               new ConvertItem{ProjectNumber = "Filter Search"}
                           };
+                      }
                       return _FilterSearch;
+                  }
+              }
               private System.Collections.ObjectModel.ObservableCollection<ConvertItem> _AliveItems;
               public System.Collections.ObjectModel.ObservableCollection<ConvertItem> AliveItems
+              {
                   get => _AliveItems;
                   set
+                  {
                       _AliveItems = value;
                       OnPropertyChanged(() => AliveItems);
+                  }
+              }
               public ICollectionView FilterConvertSourceView
+              {
                   get
+                  {
                       var view = CollectionViewSource.GetDefaultView(FilterConvertSource);
                       //if (view.CanFilter)
                       //{
                       //    view.Filter = DetailFilter;
                       //    view.Filter = o => String.IsNullOrEmpty(ProjectNumberFilter) ? true : ((string)o).Contains(ProjectNumberFilter);
                       //    view.Filter = o => String.IsNullOrEmpty(UniqueKeyFilter) ? true : ((string)o).Contains(UniqueKeyFilter);
                       //}
                       return view;
+                  }
+              }
               private System.Collections.ObjectModel.ObservableCollection<ConvertItem> _FilterConvertSource;
               public System.Collections.ObjectModel.ObservableCollection<ConvertItem> FilterConvertSource
+              {
                   //get => _FilterConvertSource;
                   get
+                  {
                       if (_FilterConvertSource == null)
+                      {
                           _FilterConvertSource = new System.Collections.ObjectModel.ObservableCollection<ConvertItem>();
+                      }
                       //if (_FilterConvertSource != null)
                       //{
                       //    var view = CollectionViewSource.GetDefaultView(FilterConvertSource);
                       //    if (view.CanFilter)
                       //    {
                       //        view.Filter = DetailFilter;
                       //    }
                       //}
                       return _FilterConvertSource;
+                  }
                   set
+                  {
                       _FilterConvertSource = value;
                       OnPropertyChanged(() => FilterConvertSource);
+                  }
+              }
               private System.Collections.ObjectModel.ObservableCollection<ConvertItem> _RealConvertSource;
               public System.Collections.ObjectModel.ObservableCollection<ConvertItem> 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 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 ConvertItem _SelectFilterConvert;
               public ConvertItem SelectFilterConvert
+              {
                   get => _SelectFilterConvert;
                   set
+                  {
                       _SelectFilterConvert = value;
                       OnPropertyChanged(() => SelectFilterConvert);
+                  }
+              }
               private ConvertItem _SelectRealConvert;
               public ConvertItem SelectRealConvert
+              {
                   get => _SelectRealConvert;
                   set
+                  {
                       _SelectRealConvert = value;
                       OnPropertyChanged(() => SelectRealConvert);
+                  }
+              }
               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 bool _ConvertShow;
               public bool ConvertShow
+              {
                   get => _ConvertShow;
                   set
+                  {
                       if (_ConvertShow = !value)
+                      {
                           _ConvertShow = false;
+                      }
                       _ConvertShow = value;
                       OnPropertyChanged(() => ConvertShow);
+                  }
+              }
               public string _ProjectNumberFilter;
               public string ProjectNumberFilter
+              {
                   get { return _ProjectNumberFilter; }
                   set
+                  {
                       if(_ProjectNumberFilter == "")
+                      {
                           _ProjectNumberFilter = null;
+                      }
                       else if (_ProjectNumberFilter != value)
+                      {
                           _ProjectNumberFilter = value;
                           OnPropertyChanged(() => ProjectNumberFilter);
                           //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                           //FilterConvertSourceView.Refresh();
+                      }
+                  }
+              }
               public string _UniqueKeyFilter;
               public string UniqueKeyFilter
+              {
                   get
+                  {
                       return _UniqueKeyFilter;
+                  }
                   set
+                  {
                       if (_UniqueKeyFilter == "")
+                      {
                           _UniqueKeyFilter = null;
+                      }
                       else if (_UniqueKeyFilter != value)
+                      {
                           _UniqueKeyFilter = value;
                           OnPropertyChanged(() => UniqueKeyFilter);
                           //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                           //FilterConvertSourceView.Refresh();
+                      }
+                  }
+              }
               public StatusCodeType _ConvertStateFilter;
               public StatusCodeType ConvertStateFilter
+              {
                   get { return _ConvertStateFilter; }
                   set
+                  {
                       if (_ConvertStateFilter != value)
+                      {
                           _ConvertStateFilter = value;
                           OnPropertyChanged(() => ConvertStateFilter);
                           //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                           //FilterConvertSourceView.Refresh();
+                      }
+                  }
+              }
               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);
                           //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                           //FilterConvertSourceView.Refresh();
+                      }
+                  }
+              }
               public string _Docuemnt_NameFilter;
               public string Docuemnt_NameFilter
+              {
                   get { return _Docuemnt_NameFilter; }
                   set
+                  {
                       if (_Docuemnt_NameFilter == "")
+                      {
                           _Docuemnt_NameFilter = null;
+                      }
                       else if (_Docuemnt_NameFilter != value)
+                      {
                           _Docuemnt_NameFilter = value;
                           OnPropertyChanged(() => Docuemnt_NameFilter);
                           //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                           //FilterConvertSourceView.Refresh();
+                      }
+                  }
+              }
               public int? _ReconverterFilter = 0;
               public int? ReconverterFilter
+              {
                   get { return _ReconverterFilter; }
                   set
+                  {
                       if (_ReconverterFilter ==  null)
+                      {
                           _ReconverterFilter = 0;
+                      }
                       else if (_ReconverterFilter != value)
+                      {
                           _ReconverterFilter = value;
                           OnPropertyChanged(() => ReconverterFilter);
                           //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                           //FilterConvertSourceView.Refresh();
+                      }
+                  }
+              }
               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);
                           //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                           //FilterConvertSourceView.Refresh();
+                      }
+                  }
+              }
               public string _RevisionFilter;
               public string RevisionFilter
+              {
                   get { return _RevisionFilter; }
                   set
+                  {
                       if (_RevisionFilter == "")
+                      {
                           _RevisionFilter = null ;
+                      }
                       else if (_RevisionFilter != value)
+                      {
                           _RevisionFilter = value;
                           OnPropertyChanged(() => RevisionFilter);
                           //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                           //FilterConvertSourceView.Refresh();
+                      }
+                  }
+              }
               public string _GroupNOFilter;
               public string GroupNOFilter
+              {
                   get { return _GroupNOFilter; }
                   set
+                  {
                       if (_GroupNOFilter == "")
+                      {
                           _GroupNOFilter = null;
+                      }
                       else if (_GroupNOFilter != value)
+                      {
                           _GroupNOFilter = value;
                           OnPropertyChanged(() => GroupNOFilter);
                           //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                           //FilterConvertSourceView.Refresh();
+                      }
+                  }
+              }
               static DateTime DefaultCreateTime = DateTime.Now;
               private DateTime _SelectedCreateTimeBegin = DefaultCreateTime;
               public DateTime SelectedCreateTimeBegin
+              {
                   get { return _SelectedCreateTimeBegin; }
                   set
+                  {
                       if (_SelectedCreateTimeBegin == value)
                           return;
                       _SelectedCreateTimeBegin = value;
                       OnPropertyChanged(() => SelectedCreateTimeBegin);
                       //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                       //FilterConvertSourceView.Refresh();
                       //AddGeneratorBeginFilter();
+                  }
+              }
               private DateTime _SelectedCreateTimeEnd = DefaultCreateTime;
               public DateTime SelectedCreateTimeEnd
+              {
                   get { return _SelectedCreateTimeEnd; }
                   set
+                  {
                       if (_SelectedCreateTimeEnd == value)
                           return;
                       _SelectedCreateTimeEnd = value;
                       OnPropertyChanged(() => SelectedCreateTimeEnd);
                       //CollectionViewSource.GetDefaultView(FilterConvertSource).Refresh();
                       //FilterConvertSourceView.Refresh();
                       //AddGeneratorBeginFilter();
+                  }
+              }
               public int _DocpanelHeigh = 800;
               public int DocpanelHeight //나중에 다시 해야함
+              {
                   get { return _DocpanelHeigh; }
                   set
+                  {
                       _DocpanelHeigh = value;
                       OnPropertyChanged(() => DocpanelHeight);
+                  }
+              }
               private string _Click = "Click";
               public string Click
+              {
                   get { return _Click; }
+              }
               #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 ConverAddCommand { 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();
+              }
               public override void Closed()
+              {
                   if (dispatcherTimer != null)
+                  {
                       dispatcherTimer.Stop();
+                  }
                   base.Closed();
+              }
               #endregion
               #region Function
               #region Data Select
               /// <summary>
               /// 상단 그리드 중앙 그리드 출력 데이터
               /// </summary>
               private void DataSelect()
+              {
                   if (FilterConvertSource == null)
+                  {
                       FilterConvertSource = new System.Collections.ObjectModel.ObservableCollection<ConvertItem>();
+                  }
                   if (RealConvertSource == null)
+                  {
                       RealConvertSource = new System.Collections.ObjectModel.ObservableCollection<ConvertItem>();
+                  }
                   /// combobox 에서 선택된 items
                   if (SelectedStatus != null)
+                  {
                       DataSelect(new[] { (StatusCodeType)(SelectedStatus.Value) }, FilterConvertSource);
+                  }
                   /// 컨버터중인 items
                   RealDataSelect(new[] { StatusCodeType.None, StatusCodeType.Wait, StatusCodeType.PageLoading, StatusCodeType.Saving }, RealConvertSource);
+              }
               private void RealDataSelect(IEnumerable<StatusCodeType> statusCodeTypeList, System.Collections.ObjectModel.ObservableCollection<ConvertItem> collection)
+              {
                   try
+                  {
                       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);
                           });
+                      }
+                  }
                   catch (Exception ex)
+                  {
                       MessageBox.Show(ex.ToString());
+                  }
+              }
               private void DataSelect(IEnumerable<StatusCodeType> statusCodeTypeList, System.Collections.ObjectModel.ObservableCollection<ConvertItem> collection)
+              {
                   try
+                  {
                       using (Markus.Service.DataBase.ConvertDatabase database = new Markus.Service.DataBase.ConvertDatabase(App.MarkusDataBaseConnecitonString))
+                      {
                           int _status = 0;
                           if (SelectedStatus != null)
+                          {
                               _status = (int)SelectedStatus.Value;
+                          }
                           var items = database.GetConvertProjects(_status, ProjectNumberFilter, UniqueKeyFilter, Docuemnt_NameFilter, Service_IDFilter, Docuemnt_NOFilter
                               , ReconverterFilter, RevisionFilter)//x:database객체 y:statusCodeTypeList의값  Count()안에 predicator 조건 만족하면 count개수안에 넣음
                                                 .Take(SelectedCount.ValueMember).ToList();
                           if (collection.Count() == 0)
+                          {
                               if (statusCodeTypeList.Count() == 1)
+                              {
                                   items.ForEach(x => collection.Add(x));
+                              }
+                          }
                           else
+                          {
                               ////세미 업데이트
                               items.ForEach(newitem =>
+                              {
                                   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 (items.Count(x => x.ConvertID == item.ConvertID && x.ProjectNumber == item.ProjectNumber) == 0)//디비에서 가져온 값과 마지막값부터 차례대로 비교
                                       {//참=> 0제외한 모든 수
                                           collection.RemoveAt(i);
+                                      }
+                                  }
+                              }
                               if (statusCodeTypeList.Count() == 1)
+                              {
                                   //추가 convert 후 추가됨
                                   foreach (var item in items)
+                                  {
                                       if (collection.Count(x => x.ConvertID == item.ConvertID && x.ProjectNumber == item.ProjectNumber) == 0)//그리드와 디비 변동 없으면 안들어감
+                                      {
                                           /*for (int i = 0; i < collection.Count()+1; i++)//위 그리드에서 카운드 개수 변함 없고 컨버터 끝난 후 추가할때 createtime 비교 하며 order by 순으로 추가*/
                                           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 void DataSearch(IEnumerable<StatusCodeType> statusCodeTypeList, System.Collections.ObjectModel.ObservableCollection<ConvertItem> collection)
+              {
                   try
+                  {
                       using (Markus.Service.DataBase.ConvertDatabase database = new Markus.Service.DataBase.ConvertDatabase(App.MarkusDataBaseConnecitonString))
+                      {
                           using (markusEntities entities = new markusEntities())
+                          {
                               int _status = 0;
                               if (SelectedStatus != null)
+                              {
                                   _status = (int)SelectedStatus.Value;
+                              }
                               //DocumentID = unikey
                               //null 왼쪽에서 부터 p_BEGIN_START_DATETIE, p_Finish_START_DATETIE, BEGIN_END_DATETIME, Finish_END_DATETIME (전에 없애라고 하셔서..)
                               //오류떠서  [Model].Context.tt File에서  288줄  Function.Name to edmFunction.FullName바꿨더니 오류 안남
                               var items = entities.SELECT_CONVERT_ITEM(ProjectNumberFilter, UniqueKeyFilter, _status, SelectedCount.ValueMember, SelectedCreateTimeBegin, SelectedCreateTimeEnd, null, null, null, null, GroupNOFilter,
                                   Docuemnt_NameFilter, Docuemnt_NOFilter, RevisionFilter).ToList();//이대로 그냥 쓰면 쿼리 -> 쿼리 결과는 두 번 이상 열거할 수 없습니다 뜸
                               //SEARCH 할때 최소한 프로젝트 넘버랑 유니크키(다큐먼트 넘버) 크레이트타임 시작 줘야함
                               List<ConvertItem> Listitems = new List<ConvertItem>();
                               foreach (var x in items)
+                              {
                                   var convertpath = database.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]);
                                   Listitems.Add(AddItem);
                                   //이거 없으면 collection.Insert(i, item); 할때 문제 생김
+                              }
                               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<ConvertItem> newitems = new List<ConvertItem>();
                       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();
                                   foreach (var item in items)
+                                  {
                                       ConvertItem itemsToEach = new ConvertItem();
                                       itemsToEach.ServiceID = item.ServiceID;
                                       itemsToEach.ConvertID = item.ConvertID;
                                       itemsToEach.ProjectNumber = item.ProjectNumber;
                                       if (item.ConvertState != null)
+                                      {
                                           itemsToEach.ConvertState = (StatusCodeType)Enum.Parse(typeof(StatusCodeType), item.ConvertState);
+                                      }
                                       itemsToEach.CurrentPageNo = item.CurrentPageNo;
                                       itemsToEach.TotalPage = item.TotalPage;
                                       itemsToEach.OriginfilePath = item.OriginfilePath;
                                       itemsToEach.ConvertPath = item.ConvertPath;
                                       itemsToEach.MarkusLink = item.MarkusLink;
                                       itemsToEach.UniqueKey = item.UniqueKey;
                                       itemsToEach.FileName = item.FileName;
                                       itemsToEach.ConvertPath = item.ConvertPath;
                                       itemsToEach.CreateTime = item.CreateTime;
                                       itemsToEach.Exception = item.Exception;
                                       itemsToEach.ProcessorAffinity = item.ProcessorAffinity;
                                       itemsToEach.ReConverter = item.ReConverter;
                                       itemsToEach.DocumentID = item.DocumentID;
                                       itemsToEach.DocumnetName = item.DocumnetName;
                                       itemsToEach.GroupNo = item.GroupNo;
                                       itemsToEach.Revision = item.Revision;
                                       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<ConvertItem> newitems)
+              {
                   foreach (var item in newitems)
+                  {
                       item.OriginfilePath = HttpUtility.UrlDecode(item.OriginfilePath);
+                  }
                   if (AliveItems == null)
+                  {
                       AliveItems = new System.Collections.ObjectModel.ObservableCollection<ConvertItem>();
                       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 void DataConvert(object obj)
+              {
                   if (SelectFilterConvert == null && SelectRealConvert == null)
+                  {
                       MessageBox.Show("왼쪽 버튼 클릭 후 Converter 해주세요!");
+                  }
                   else
+                  {
                       ConvertDatabase _DataConvert = new ConvertDatabase(App.MarkusDataBaseConnecitonString);
                       var resultRealConvert = 0;
                       var resultFiltertConvert = 0;
                       if (SelectRealConvert != null)
+                      {
                           resultRealConvert = _DataConvert.SetCleanUpItem(SelectRealConvert);
+                      }
                       else if (SelectFilterConvert != null)
+                      {
                           resultFiltertConvert = _DataConvert.SetCleanUpItem(SelectFilterConvert);
+                      }
                       System.Diagnostics.Debug.WriteLine(resultRealConvert + "  " + resultFiltertConvert);
                       using (Markus.Service.DataBase.ConvertDatabase database = new Markus.Service.DataBase.ConvertDatabase(App.MarkusDataBaseConnecitonString))
+                      {
                           var items = database.GetConvertProjects(SelectFilterConvert);
                           foreach (var item in items)
+                          {
                               RealConvertSource.Add(item);
+                          }
                           if (RealConvertSource.Count() == 1)
+                          {
                               ConvertShow = true;
+                          }
+                      }
+                  }
+              }
               #endregion
               #region Validation
               private void DataValidate(object obj)
+              {
                   bool result = false;
                   WebRequest webRequest = WebRequest.Create(SelectFilterConvert.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);
                   DataSearch(new[] { (StatusCodeType)(SelectedStatus.Value) }, FilterConvertSource);
                   //dispatcherTimer.Start();
+              }
               #endregion
               #region MarkusLink
               private void MarkusLink(object obj)///여기서 부터
+              {
                   if (obj is ConvertItem)
+                  {
                       if (obj != null)
+                      {
                           var convertitem = obj as ConvertItem;
                           SelectFilterConvert = 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 void OnClosed(object sender, WindowClosedEventArgs e)
+              {
                   var result = e.DialogResult;
                   if (result == true)
+                  {
                       ConvertDatabase _DataConvert = new ConvertDatabase(App.MarkusDataBaseConnecitonString);
                       var resultRealConvert = _DataConvert.RemoveItem(SelectRealConvert.ConvertID);
                       var resultFiltertConvert = _DataConvert.RemoveItem(SelectFilterConvert.ConvertID);
                       System.Diagnostics.Debug.WriteLine(resultRealConvert + "  " + resultFiltertConvert);
+                  }
+              }
               #endregion
               #region Data Export
               /// <summary>
               /// 필터된 상단 그리드 엑셀로 출력
               /// </summary>
               public void DataExportData(object obj)
+              {
                   SaveFileDialog saveFileDialog = new SaveFileDialog();
                   saveFileDialog.FileName = "Document"; // Default file name
                   saveFileDialog.DefaultExt = ".txt"; // Default file extension
                   saveFileDialog.Filter = "Csv documents (.Csv)|*.csv|Excel(2017~2019)Worksheets|*.xlsx"; // Filter files by extension
                   if (saveFileDialog.ShowDialog() == true)
+                  {
                       if (!string.IsNullOrWhiteSpace(saveFileDialog.FileName))
+                      {
                           var extension = new System.IO.FileInfo(saveFileDialog.FileName).Extension;
                           if (extension == ".xlsx" || extension == ".csv")
+                          {
                               var headers = new List<HeaderMember>
+                              {
                                   new HeaderMember{HeaderName = "ServiceID", Property = "ServiceID" },
                                   new HeaderMember{HeaderName = "ConvertID", Property = "ConvertID" },
                                   new HeaderMember{HeaderName = "ProjectNumber", Property = "ProjectNumber" },
                                   new HeaderMember{HeaderName = "ConvertState", Property = "ConvertState" },
                                   new HeaderMember{HeaderName = "CurrentPageNo", Property = "CurrentPageNo" },
                                   new HeaderMember{HeaderName = "TotalPage", Property = "TotalPage" },
                                   new HeaderMember{HeaderName = "OriginfilePath", Property = "OriginfilePath" },
                                   new HeaderMember{HeaderName = "ConvertPath", Property = "ConvertPath" },
                                   new HeaderMember{HeaderName = "CreateTime", Property = "CreateTime" },
                                   new HeaderMember{HeaderName = "Exception", Property = "Exception" },
                                   new HeaderMember{HeaderName = "ProcessorAffinity", Property = "ProcessorAffinity" },
                                   new HeaderMember{HeaderName = "ReConverter", Property = "ReConverter" },
                                   new HeaderMember{HeaderName = "UniqueKey", Property = "UniqueKey" }
                               };
                               DataExport dataExport = new DataExport();
                               dataExport.DataExportExcel(saveFileDialog.FileName, "Hello world", FilterConvertSource, headers);
                               //_dataExport.DataExportExcel(saveFileDialog.FileName, saveFileDialog.FileName.ToString(),  Projectsource, headers);
                               //GemBoxFileSave(obj);
+                          }
+                      }
+                  }
+              }
               #endregion
               #region Data Search
               /// <summary>
               /// Grid Filter
               /// </summary>
               private bool DetailFilter(object item)
+              {
                   var Item = item as ConvertItem;
                   if (ProjectNumberFilter == null) return true;
                   if (ProjectNumberFilter == Item.ProjectNumber) return true;
                   //if (ConvertStateFilter == null) return true;
                   //if (ConvertStateFilter == (StatusCodeType)Item.ConvertState) return true;
                   if (Docuemnt_NameFilter == null) return true;
                   if (Docuemnt_NameFilter == Item.DocumnetName) return true;
                   if (Service_IDFilter == null) return true;
                   if (Service_IDFilter == Item.ServiceID) return true;
                   if (UniqueKeyFilter == null) return true;
                   if (UniqueKeyFilter == Item.UniqueKey) return true;
                   if (Docuemnt_NOFilter == null) return true;
                   if (Docuemnt_NOFilter == Item.DocumnetNo) return true;
                   if (ReconverterFilter == null) return true;
                   if (ReconverterFilter == Item.ReConverter) return true;
                   if (RevisionFilter == null) return true;
                   if (RevisionFilter == Item.Revision) return true;
                   return false;
+              }
               public void RemoveCreateTimeFilter(object obj)
+              {
                   DefaultCreateTime = DateTime.Now;
                   SelectedCreateTimeBegin = DefaultCreateTime;
                   SelectedCreateTimeEnd = DefaultCreateTime;
+              }
               #endregion
               #region Reset
               /// <summary>
               /// 그리드 상단 원상복귀 버튼
               /// 필터를 끝낸 후 다시 복귀
               /// </summary>
               public void Reset(object obj)
+              {
                   dispatcherTimer.Tick += new EventHandler(Timer_Tick);
+              }
               #endregion
               #region
               /// <summary>
               /// 그리드 상단 Conver 추가 버튼
               /// ProjectNo, DocumentURL, DocumentID, 입력해서 저장 프로시저에서 추가
               /// </summary>
               public void ConverAdd(object obj)
+              {
                   //줄 530줄 load부분 주석 처리하면 잘됨
                   //dispatcherTimer.Stop();
                   Views.ConvertAddDialog convertAddDialog = new Views.ConvertAddDialog();
                   convertAddDialog.ShowDialog();
                   //dispatcherTimer.Start();
+              }
               #endregion
               #endregion
+          }
+      }

프로젝트

일반

사용자정보

MARKUS

markus / ConvertService / ServiceBase / Markus.Service.StationController / ViewModel / DataBaseItemsModel.cs @ 43b2e236