MARKUS

using KCOMDataModel.Common;

using KCOMDataModel.DataModel;

using System;

using System.Collections.Generic;

using System.Collections.ObjectModel;

using System.Linq;

using System.Text;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Data;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Imaging;

using System.Windows.Navigation;

using System.Windows.Shapes;

using Telerik.Windows.Controls;

using KCOM.Common.Converter;

using System.ComponentModel;

using Telerik.Windows.Controls.GridView;

using KCOM.Controls;

using KCOM.Common;

using IKCOM;

using Excel = Microsoft.Office.Interop.Excel;

namespace KCOM.Controls

{

    #region Customer

    public class Customer

    {

        public string ID { get; set; }

        public string DOCUMENT_ID { get; set; }

        public string USER_ID { get; set; }

        public string REVISION { get; set; }

        public int PAGENUMBER { get; set; }

        public string TODOLIST { get; set; }

        public string IMAGE_URL { get; set; }

        public string STATUS { get; set; }

        public string STATUS_ { get; set; }

        public string _STATUS { get; set; }

        public string VENDOR { get; set; }

        public string REMARK { get; set; }

        public string PROJECT_NO { get; set; }

        public string REV_19 { get; set; }

        public string REV_18 { get; set; }

        public string REV_17 { get; set; }

        public string REV_16 { get; set; }

        public string REV_15 { get; set; }

        public string REV_14 { get; set; }

        public string REV_13 { get; set; }

        public string REV_12 { get; set; }

        public string REV_11 { get; set; }

        public string REV_10 { get; set; }

        public string REV_9 { get; set; }

        public string REV_8 { get; set; }

        public string REV_7 { get; set; }

        public string REV_6 { get; set; }

        public string REV_5 { get; set; }

        public string REV_4 { get; set; }

        public string REV_3 { get; set; }

        public string REV_2 { get; set; }

        public string REV_1 { get; set; }

        public string REV_0 { get; set; }

        public string IMAGE_ANCHOR { get; set; }

        public byte[] IMAGE_PATH { get; set; }

        public string STATUS_DESC { get; set; }

        public string REPLY { get; set; }

        public DateTime CREATE_TIME { get; set; }

    } 

    #endregion

    /// <summary>

    /// Interaction logic for CheckList.xaml

    /// </summary>

    public partial class CheckList : UserControl

    {

        #region 프로퍼티

        List<CHECK_LIST> items = new List<CHECK_LIST>();

        List<Customer> Lists = new List<Customer>();

        string old_Revision = "";

        string old_DocID = "";

        string Current_Revision = "";

        string Current_DocNo = "";

        int Current_Slip = 0;

        bool Isinit = false;

        int rev_cnt = 1;

        bool isCheck_Status = false;

        string Select_StatusID = "";

        #endregion

        #region 생성자

        public CheckList()

        {

            Common.ViewerDataModel.Instance.ViewVisible = Visibility.Visible;

            InitializeComponent();

            this.Loaded += CheckList_Loaded;

            this.KeyDown += new KeyEventHandler(KeyEventDownAction);

            this.AddHandler(Image.MouseLeftButtonDownEvent, new MouseButtonEventHandler(mousedownOnImage), true);

        }

        #endregion

        public void DataBind()

        {

            Isinit = false;

            Lists = new List<Customer>();

            string doc_no = (Application.Current.MainWindow as MainWindow).dzMainMenu._DocItem.DOCUMENT_NO;

            using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(App.ViewInfo.ProjectNO).ToString()))

            {

                items = Entity.CHECK_LIST.Where(i => i.PROJECT_NO == App.ViewInfo.ProjectNO && i.DOCUMENT_NO == doc_no && i.USER_ID == App.ViewInfo.UserID).OrderBy(p => p.CREATE_TIME).ToList();

                if (Lists.Count == 0)

                {

                    foreach (var item in items)

                    {

                        Customer customer = new Customer();

                        customer.ID = item.ID;

                        customer.IMAGE_ANCHOR = item.IMAGE_ANCHOR;

                        if (item.IMAGE_URL != null && item.IMAGE_URL != "")

                            customer.IMAGE_PATH = Convert.FromBase64String(item.IMAGE_URL);

                        customer.PAGENUMBER = item.PAGENUMBER;

                        customer.PROJECT_NO = item.PROJECT_NO;

                        customer.REMARK = item.REMARK;

                        customer.REVISION = item.REVISION;

                        #region history

                        var history = Entity.CHECK_LIST_HISTORY.Where(data => data.CHECKLIST_ID == item.ID).ToList();

                        foreach (var rev in history)

                        {

                            if (rev.REVISION == "A")

                            { customer.REV_0 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); }

                            if (rev.REVISION == "B")

                            { customer.REV_1 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 2 ? 2 : rev_cnt; }

                            if (rev.REVISION == "C")

                            { customer.REV_2 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 3 ? 3 : rev_cnt; }

                            if (rev.REVISION == "D")

                            { customer.REV_3 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 4 ? 4 : rev_cnt; }

                            if (rev.REVISION == "E")

                            { customer.REV_4 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 5 ? 5 : rev_cnt; }

                            if (rev.REVISION == "F")

                            { customer.REV_5 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 6 ? 6 : rev_cnt; }

                            if (rev.REVISION == "G")

                            { customer.REV_6 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 7 ? 7 : rev_cnt; }

                            if (rev.REVISION == "H")

                            { customer.REV_7 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 8 ? 8 : rev_cnt; }

                            if (rev.REVISION == "I")

                            { customer.REV_8 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 9 ? 9 : rev_cnt; }

                            if (rev.REVISION == "J")

                            { customer.REV_9 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 10 ? 10 : rev_cnt; }

                            if (rev.REVISION == "K")

                            { customer.REV_10 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 11 ? 11 : rev_cnt; }

                            if (rev.REVISION == "L")

                            { customer.REV_11 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 12 ? 12 : rev_cnt; }

                            if (rev.REVISION == "M")

                            { customer.REV_12 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 13 ? 13 : rev_cnt; }

                            if (rev.REVISION == "N")

                            { customer.REV_13 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 14 ? 14 : rev_cnt; }

                            if (rev.REVISION == "O")

                            { customer.REV_14 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 15 ? 15 : rev_cnt; }

                            if (rev.REVISION == "P")

                            { customer.REV_15 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 16 ? 16 : rev_cnt; }

                            if (rev.REVISION == "Q")

                            { customer.REV_16 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 17 ? 17 : rev_cnt; }

                            if (rev.REVISION == "R")

                            { customer.REV_17 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 18 ? 18 : rev_cnt; }

                            if (rev.REVISION == "S")

                            { customer.REV_18 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 19 ? 19 : rev_cnt; }

                            if (rev.REVISION == "T")

                            { customer.REV_19 = rev.STATUS + "" + rev.CREATE_TIME.ToString("yyyy.MM.dd"); rev_cnt = rev_cnt < 20 ? 20 : rev_cnt; }

                        }

                        #endregion

                        customer.STATUS = item.STATUS;

                        customer.REPLY = item.REPLY;

                        customer.TODOLIST = item.TODOLIST;

                        customer.USER_ID = item.USER_ID;

                        customer.VENDOR = item.VENDOR;

                        customer.DOCUMENT_ID = item.DOCUMENT_ID;

                        customer.CREATE_TIME = DateTime.Parse(item.CREATE_TIME.ToString());

                        if (item.STATUS == "True")

                        {

                            customer._STATUS = "Close";

                            customer.STATUS_ = "False";

                            customer.STATUS_DESC = item.STATUS_DESC_CLOSE;

                        }

                        else

                        {

                            customer._STATUS = "Open";

                            customer.STATUS_ = "True";

                            customer.STATUS_DESC = item.STATUS_DESC_OPEN;

                        }

                        Lists.Add(customer);

                    }

                }

            }

        }

        private void ChangeSize(double width, double height)

        {

            this.Width = width;

            this.Height = height;

        }

        private void SyncInit()

        {

            if (!ViewerDataModel.Instance.SystemMain.dzMainMenu.testPanel2.IsHidden)

            {

                ViewerDataModel.Instance.SystemMain.dzMainMenu.testPanel2.IsHidden = true;

                ViewerDataModel.Instance.PageBalanceMode = false;

                ViewerDataModel.Instance.PageBalanceNumber = 0;

                ViewerDataModel.Instance.PageNumber = 0;

                ViewerDataModel.Instance.MarkupControls_Sync.Clear();

                ViewerDataModel.Instance.SystemMain.dzMainMenu.gridViewRevMarkup.Visibility = Visibility.Collapsed;

                ViewerDataModel.Instance.SystemMain.dzMainMenu.UserList.IsChecked = false;

                ViewerDataModel.Instance.SystemMain.dzMainMenu.BalanceMode.IsChecked = false;

            }

        }

        private void DialogMessage_Alert(string Msg)

        {

            RadWindow CheckPop = new RadWindow();

            Alert check = new Alert(Msg);

            CheckPop = new RadWindow

            {

                MinWidth = 400,

                MinHeight = 100,

                //Closed = (obj, args) => this.MarkupNamePromptClose(MarkupData, args),

                Header = "Alert",

                Content = check,

                ResizeMode = System.Windows.ResizeMode.NoResize,

                WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen,

                IsTopmost = true,

            };

            StyleManager.SetTheme(CheckPop, new Office2013Theme());

            CheckPop.ShowDialog();

        }

        private void History_Set()

        {

            if (col1.Width != new GridLength(1200))

            {

                Col_Remark.IsVisible = true;

                Col_Reply.IsVisible = true;

                Col_Vendor.IsVisible = true;

                if (Lists.Where(info => info.REV_1 != null).FirstOrDefault() != null)

                    REV_1.IsVisible = true;

                #region history

                REV_0.IsVisible = true;

                if (Lists.Where(info => info.REV_1 != null).FirstOrDefault() != null)

                    { REV_1.IsVisible = true; REV_0.Width = 70; }

                else

                { REV_0.Width = 140;}

                if (Lists.Where(info => info.REV_2 != null).FirstOrDefault() != null)

                    REV_2.IsVisible = true; REV_2.IsVisible = true;

                if (Lists.Where(info => info.REV_3 != null).FirstOrDefault() != null)

                    REV_3.IsVisible = true;

                if (Lists.Where(info => info.REV_4 != null).FirstOrDefault() != null)

                    REV_4.IsVisible = true;

                if (Lists.Where(info => info.REV_5 != null).FirstOrDefault() != null)

                    REV_5.IsVisible = true;

                if (Lists.Where(info => info.REV_6 != null).FirstOrDefault() != null)

                    REV_6.IsVisible = true;

                if (Lists.Where(info => info.REV_7 != null).FirstOrDefault() != null)

                    REV_7.IsVisible = true;

                if (Lists.Where(info => info.REV_8 != null).FirstOrDefault() != null)

                    REV_8.IsVisible = true;

                if (Lists.Where(info => info.REV_9 != null).FirstOrDefault() != null)

                    REV_9.IsVisible = true;

                if (Lists.Where(info => info.REV_10 != null).FirstOrDefault() != null)

                    REV_10.IsVisible = true;

                if (Lists.Where(info => info.REV_11 != null).FirstOrDefault() != null)

                    REV_11.IsVisible = true;

                if (Lists.Where(info => info.REV_12 != null).FirstOrDefault() != null)

                    REV_12.IsVisible = true;

                if (Lists.Where(info => info.REV_13 != null).FirstOrDefault() != null)

                    REV_13.IsVisible = true;

                if (Lists.Where(info => info.REV_14 != null).FirstOrDefault() != null)

                    REV_14.IsVisible = true;

                if (Lists.Where(info => info.REV_15 != null).FirstOrDefault() != null)

                    REV_15.IsVisible = true;

                if (Lists.Where(info => info.REV_16 != null).FirstOrDefault() != null)

                    REV_16.IsVisible = true;

                if (Lists.Where(info => info.REV_17 != null).FirstOrDefault() != null)

                    REV_17.IsVisible = true;

                if (Lists.Where(info => info.REV_18 != null).FirstOrDefault() != null)

                    REV_18.IsVisible = true;

                if (Lists.Where(info => info.REV_19 != null).FirstOrDefault() != null)

                    REV_19.IsVisible = true;

                #endregion

            }

            else

            {

                Col_Remark.IsVisible = false;

                Col_Reply.IsVisible = false;

                Col_Vendor.IsVisible = false;

                #region history

                REV_0.IsVisible = false;

                REV_1.IsVisible = false;

                REV_2.IsVisible = false;

                REV_3.IsVisible = false;

                REV_4.IsVisible = false;

                REV_5.IsVisible = false;

                REV_6.IsVisible = false;

                REV_7.IsVisible = false;

                REV_8.IsVisible = false;

                REV_9.IsVisible = false;

                REV_10.IsVisible = false;

                REV_11.IsVisible = false;

                REV_12.IsVisible = false;

                REV_13.IsVisible = false;

                REV_14.IsVisible = false;

                REV_15.IsVisible = false;

                REV_16.IsVisible = false;

                REV_17.IsVisible = false;

                REV_18.IsVisible = false;

                REV_19.IsVisible = false;

                #endregion

            }

        }

        #region Excel Export

        private void ExportEvent(object sender, RoutedEventArgs e)

        {

            this.ExportIndy.IsBusy = true;

            if (Lists.Count == 0)

            {

                DialogMessage_Alert("Data Not Found");

                this.ExportIndy.IsBusy = false;

                return;

            }

            string extension = "xlsx";

            //Uri url = new Uri("http://cloud.devdoftech.co.kr:5977/TileSource/Check_Test/CheckList.xlsx");

            Uri url = new Uri("http://cloud.devdoftech.co.kr:5977/TileSource/Check_Test/CheckList_T.xlsx");

            System.Windows.Forms.SaveFileDialog dialog = new System.Windows.Forms.SaveFileDialog()

            {

                DefaultExt = extension,

                Filter = String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, "Excel"),

                FilterIndex = 1

            };

            if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)

            {

                using (var client = new System.Net.WebClient())

                {

                    client.DownloadFile(url, dialog.FileName);

                    Excel.Application application = null;

                    Excel.Workbook workbook = null;

                    Excel.Worksheet worksheet = null;

                    try

                    {

                        // Excel 첫번째 워크시트 가져오기                

                        application = new Excel.Application();

                        workbook = application.Workbooks.Open(dialog.FileName);

                        worksheet = (Excel.Worksheet)workbook.Worksheets.get_Item("Sheet1");

                        // 데이타 넣기

                        int h = 9;

                        int w = 2;

                        worksheet.Cells[2, w + 8] = App.ViewInfo.ProjectNO;

                        using (KCOMDataModel.DataModel.KCOMEntities Entity = new KCOMDataModel.DataModel.KCOMEntities(KCOMDataModel.Common.ConnectStringBuilder.KCOMConnectionString().ToString()))

                        {

                            worksheet.Cells[3, w + 8] = Entity.RUN_PROJECTS.Where(i => i.PROJECT_NO == App.ViewInfo.ProjectNO).FirstOrDefault().PROJECT_NAME.ToString();

                        }

                        worksheet.Cells[4, w + 8] = (Application.Current.MainWindow as MainWindow).dzMainMenu._DocItem.DOCUMENT_NO;

                        worksheet.Cells[5, w + 8] = (Application.Current.MainWindow as MainWindow).dzMainMenu.userData.NAME + " (" + App.ViewInfo.UserID + ")";

                        worksheet.Cells[6, w + 8] = DateTime.Now.ToString("yyyy.MM.dd");

                        Excel.Range Range_I = worksheet.Range["K9"];

                        Excel.Range Range_O = null;

                        Excel.Borders border_ = null;

                        var Rev = Lists.Select(info => info.REVISION).Distinct();

                        string[] Cell = { "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T" };

                        string[] Range = { "L9", "M9", "N9", "O9", "P9", "Q9", "R9", "S9", "T9", "U9", "V9", "W9", "X9", "Y9", "Z9", "AA9", "AB9", "AC9", "AD9" };

                        string Ran = "K";

                        for (int i = 0; i < rev_cnt - 1; i++)

                        {

                            worksheet.Cells[9, 12 + i] = Cell[i];

                            Range_O = worksheet.Range[Range[i]];

                            border_ = Range_O.Borders;

                            border_.LineStyle = Range_I.Borders.LineStyle;

                            border_.Weight = Range_I.Borders.Weight;

                            Range_O.Interior.Color = Range_I.Interior.Color;

                        }

                        worksheet.Range[worksheet.Cells[8, 11], worksheet.Cells[8, 11 + rev_cnt - 1]].Merge();

                        if (rev_cnt != 1)

                        {

                            Ran = Range[rev_cnt - 2].Substring(0, Range[rev_cnt - 2].Length - 1);

                        }

                        Excel.Range iRange = worksheet.Range["B10:" + Ran + "10"];

                        //필터 기능 추가

                        Excel.Range Filter_Range = worksheet.Range["B9:" + Ran + "9"];

                        Filter_Range.AutoFilter(1, Type.Missing, Excel.XlAutoFilterOperator.xlAnd, Type.Missing, true);

                        Lists.ForEach(data =>

                        {

                            h++;

                            Excel.Range oRange = worksheet.Range["B" + h + ":" + Ran + h];

                            oRange.RowHeight = iRange.RowHeight;

                            Excel.Borders border = oRange.Borders;

                            border.LineStyle = Excel.XlLineStyle.xlContinuous;

                            border.Weight = 2d;

                            if (data.IMAGE_PATH != null)

                            {

                                Excel.Range ImageRange = worksheet.Cells[h, w + 2];

                                System.Drawing.Image I_Image = byteArrayToImage(data.IMAGE_PATH);

                                System.Drawing.Image o_Image = Resize(I_Image, 80, 80);

                                System.Windows.Forms.Clipboard.SetDataObject(o_Image, true);

                                ImageRange.Cells.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenterAcrossSelection;

                                ImageRange.Cells.VerticalAlignment = Excel.XlHAlign.xlHAlignCenter;

                                worksheet.Paste(ImageRange.Cells, "TEST");

                                foreach (Microsoft.Office.Interop.Excel.Shape shp in worksheet.Shapes)

                                {

                                    if (shp.TopLeftCell.Address != ImageRange.Address)

                                        continue;

                                    double Left = shp.TopLeftCell.Left + (shp.TopLeftCell.Width - shp.Width) / 2;

                                    double Top = shp.TopLeftCell.Top + (shp.TopLeftCell.Height - shp.Height) / 2;

                                    shp.Left = float.Parse(Left.ToString());

                                    shp.Top = float.Parse(Top.ToString());

                                    break;

                                }

                            }

                            #region Excel Bind

                            worksheet.Cells[h, w] = data.REVISION;

                            worksheet.Cells[h, w + 1] = data.PAGENUMBER;

                            worksheet.Cells[h, w + 3] = data.TODOLIST;

                            worksheet.Cells[h, w + 4] = data.STATUS.ToUpper() == "TRUE" ? "closed" : "open";

                            worksheet.Cells[h, w + 5] = data.STATUS_DESC;

                            worksheet.Cells[h, w + 6] = data.VENDOR;

                            worksheet.Cells[h, w + 7] = data.REMARK;

                            worksheet.Cells[h, w + 8] = data.REPLY;

                            worksheet.Cells[h, w + 9] = data.REV_0 == null ? "" : data.REV_0.Replace("", " / ");

                            worksheet.Cells[h, w + 10] = data.REV_1 == null ? "" : data.REV_1.Replace("", " / ");

                            worksheet.Cells[h, w + 11] = data.REV_2 == null ? "" : data.REV_2.Replace("", " / ");

                            worksheet.Cells[h, w + 12] = data.REV_3 == null ? "" : data.REV_3.Replace("", " / ");

                            worksheet.Cells[h, w + 13] = data.REV_4 == null ? "" : data.REV_4.Replace("", " / ");

                            worksheet.Cells[h, w + 14] = data.REV_5 == null ? "" : data.REV_5.Replace("", " / ");

                            worksheet.Cells[h, w + 15] = data.REV_6 == null ? "" : data.REV_6.Replace("", " / ");

                            worksheet.Cells[h, w + 16] = data.REV_7 == null ? "" : data.REV_7.Replace("", " / ");

                            worksheet.Cells[h, w + 17] = data.REV_8 == null ? "" : data.REV_8.Replace("", " / ");

                            worksheet.Cells[h, w + 18] = data.REV_9 == null ? "" : data.REV_9.Replace("", " / ");

                            worksheet.Cells[h, w + 19] = data.REV_10 == null ? "" : data.REV_10.Replace("", " / ");

                            worksheet.Cells[h, w + 20] = data.REV_11 == null ? "" : data.REV_11.Replace("", " / ");

                            worksheet.Cells[h, w + 21] = data.REV_12 == null ? "" : data.REV_12.Replace("", " / ");

                            worksheet.Cells[h, w + 22] = data.REV_13 == null ? "" : data.REV_13.Replace("", " / ");

                            worksheet.Cells[h, w + 23] = data.REV_14 == null ? "" : data.REV_14.Replace("", " / ");

                            worksheet.Cells[h, w + 24] = data.REV_15 == null ? "" : data.REV_15.Replace("", " / ");

                            worksheet.Cells[h, w + 25] = data.REV_16 == null ? "" : data.REV_16.Replace("", " / ");

                            worksheet.Cells[h, w + 26] = data.REV_17 == null ? "" : data.REV_17.Replace("", " / ");

                            worksheet.Cells[h, w + 27] = data.REV_18 == null ? "" : data.REV_18.Replace("", " / ");

                            worksheet.Cells[h, w + 28] = data.REV_19 == null ? "" : data.REV_19.Replace("", " / ");

                            #endregion

                        });

                        worksheet.Columns.AutoFit();

                        // 엑셀파일 저장

                        workbook.Save();

                        workbook.Close(true);

                        application.Quit();

                    }

                    finally

                    {

                        System.Diagnostics.Process[] ExCel = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                        if (ExCel.Count() != 0)

                        {

                            ExCel[0].Kill();

                        }

                        // Clean up

                        ReleaseExcelObject(worksheet);

                        ReleaseExcelObject(workbook);

                        ReleaseExcelObject(application);

                    }

                }

                DialogMessage_Alert("Success");

            }

            this.ExportIndy.IsBusy = false;

        }

        public System.Drawing.Image byteArrayToImage(byte[] byteArrayIn)

        {

            using (var ms = new System.IO.MemoryStream(byteArrayIn))

            {

                return System.Drawing.Image.FromStream(ms);

            }

        }

        public System.Drawing.Image Resize(System.Drawing.Image image, int newWidth, int maxHeight)

        {

            //if (onlyResizeIfWider && image.Width <= newWidth) newWidth = image.Width;

            var newHeight = image.Height * newWidth / image.Width;

            if (newHeight > maxHeight)

            {

                // Resize with height instead  

                newWidth = image.Width * maxHeight / image.Height;

                newHeight = maxHeight;

            }

            var res = new System.Drawing.Bitmap(newWidth, newHeight);

            using (var graphic = System.Drawing.Graphics.FromImage(res))

            {

                graphic.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;

                graphic.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;

                graphic.PixelOffsetMode = System.Drawing.Drawing2D.PixelOffsetMode.HighQuality;

                graphic.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality;

                graphic.DrawImage(image, 0, 0, newWidth, newHeight);

            }

            return res;

        }

        private static void ReleaseExcelObject(object obj)

        {

            try

            {

                if (obj != null)

                {

                    obj = null;

                }

            }

            catch (Exception ex)

            {

                obj = null;

                throw ex;

            }

            finally

            {

                GC.Collect();

            }

        }

        #endregion

        #region 이벤트

        void MainWindow_SizeChanged(object sender, SizeChangedEventArgs e)

        {

            ChangeSize(e.NewSize.Width, e.NewSize.Height);

        }

        private void CheckList_Loaded(object sender, RoutedEventArgs e)

        {

            Current_DocNo = (Application.Current.MainWindow as MainWindow).dzMainMenu._DocItem.DOCUMENT_NO;

            Current_Revision = (Application.Current.MainWindow as MainWindow).dzMainMenu._DocItem.REVISION;

            Current_Slip = int.Parse((Application.Current.MainWindow as MainWindow).dzMainMenu._DocItem.GROUP_NO);

            using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(App.ViewInfo.ProjectNO).ToString()))

            {

                var Gaby = Entity.DOCUMENT_ITEM.Where(i => i.PROJECT_NO == App.ViewInfo.ProjectNO

                && i.DOCUMENT_NO == Current_DocNo

                && i.REVISION != Current_Revision).OrderByDescending(i => i.GROUP_NO);

                foreach (var I in Gaby)

                {

                    if (int.Parse(I.GROUP_NO) < Current_Slip)

                    {

                        old_Revision = I.REVISION;

                        old_DocID = I.DOCUMENT_ID;

                        return;

                    }

                }

            }

        }

        private void RadGridView_Loaded(object sender, RoutedEventArgs e)

        {

            DataBind();

            (sender as Telerik.Windows.Controls.RadGridView).ItemsSource = null;

            (sender as Telerik.Windows.Controls.RadGridView).ItemsSource = Lists;

            ChangeSize(this.ActualWidth, this.ActualHeight);

            this.SizeChanged += new SizeChangedEventHandler(MainWindow_SizeChanged);

        }

        private void AddEvent(object sender, RoutedEventArgs e)

        {

            Application.Current.MainWindow.Focus();

            Common.ViewerDataModel.Instance.CheckList_ID = KCOM.Events.Save.shortGuid();

            Common.ViewerDataModel.Instance.Capture_Opacity = 0.5;

            (Application.Current.MainWindow as MainWindow).dzMainMenu.mouseHandlingMode = IKCOM.MouseHandlingMode.Capture;

        }

        private void SaveEvent(object sender, RoutedEventArgs e)

        {

            CHECK_LIST Check_value = new CHECK_LIST();

            CHECK_LIST_HISTORY Check_History = new CHECK_LIST_HISTORY();

            using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(App.ViewInfo.ProjectNO).ToString()))

            {

                foreach (var item in tb.Items)

                {

                    string Check_ID = (item as Customer).ID.ToString();

                    string state = "";

                    Check_value = Entity.CHECK_LIST.Where(info => info.ID == Check_ID).FirstOrDefault();

                    if (Check_value != null)

                    {

                        if ((item as Customer).STATUS.ToUpper() == "TRUE")

                        {

                            state = "Closed";

                            Check_value.STATUS_DESC_CLOSE = (item as Customer).STATUS_DESC;

                        }

                        else

                        {

                            state = "Open";

                            Check_value.STATUS_DESC_OPEN = (item as Customer).STATUS_DESC;

                        }

                        string Rev = state + "" + DateTime.Now.ToString("yyyy.MM.dd");

                        string description = "";

                        if (char.Parse(ViewerDataModel.Instance.SystemMain.dzMainMenu.CurrentDoc.Revision) >= char.Parse(Check_value.REVISION))

                        {

                            Check_value.REMARK = (item as Customer).REMARK;

                            Check_value.STATUS = (item as Customer).STATUS;

                            Check_value.TODOLIST = (item as Customer).TODOLIST;

                            Check_value.VENDOR = (item as Customer).VENDOR;

                            Check_value.REPLY = (item as Customer).REPLY;

                            if (state == "Open")

                                description = Check_value.STATUS_DESC_OPEN;

                            else

                                description = Check_value.STATUS_DESC_CLOSE;

                            var history = Entity.CHECK_LIST_HISTORY.Where(data => data.CHECKLIST_ID == Check_ID).ToList();

                            Check_History = history.Where(info => info.REVISION == ViewerDataModel.Instance.SystemMain.dzMainMenu.CurrentDoc.Revision).FirstOrDefault();

                            //Check_History = Entity.CHECK_LIST_HISTORY.Where(info => info.CHECKLIST_ID == Check_ID && info.REVISION == ViewerDataModel.Instance.SystemMain.dzMainMenu.CurrentDoc.Revision).FirstOrDefault();

                            //var history = Entity.CHECK_LIST_HISTORY.Where(data => data.CHECKLIST_ID == Check_ID).ToList();

                            List<string> validation = new List<string>();

                            foreach (var his in history)

                            {

                                if (his.TODOLIST == Check_value.TODOLIST)

                                    validation.Add("TODOLIST");

                                if ( his.STATUS_DESC == description)

                                    validation.Add("STATUS_DESC");

                                if (his.VENDOR == Check_value.VENDOR)

                                    validation.Add("VENDOR");

                                if (his.REMARK == Check_value.REMARK)

                                    validation.Add("REMARK");

                                if (his.REPLY == Check_value.REPLY)

                                    validation.Add("REPLY");

                            }

                            if (validation.Count < 5)

                            {

                                if (Check_History == null)

                                {

                                    Check_History = new CHECK_LIST_HISTORY()

                                    {

                                        ID = Events.Save.shortGuid(),

                                        CHECKLIST_ID = Check_ID,

                                        REVISION = ViewerDataModel.Instance.SystemMain.dzMainMenu.CurrentDoc.Revision,

                                        STATUS = state,

                                        IMAGE_URL = Check_value.IMAGE_URL,

                                        STATUS_DESC = validation.Where(i => i.ToString() == "STATUS_DESC").FirstOrDefault() == null ? description : "",

                                        TODOLIST = validation.Where(i => i.ToString() == "TODOLIST").FirstOrDefault() == null ? Check_value.TODOLIST : "",

                                        VENDOR = validation.Where(i => i.ToString() == "VENDOR").FirstOrDefault() == null ? Check_value.VENDOR : "",

                                        REMARK = validation.Where(i => i.ToString() == "REMARK").FirstOrDefault() == null ?  Check_value.REMARK : "",

                                        REPLY = validation.Where(i => i.ToString() == "REPLY").FirstOrDefault() == null ?  Check_value.REPLY : "",

                                        CREATE_TIME = DateTime.Now,

                                        UPDATE_TIME = DateTime.Now

                                    };

                                    Entity.CHECK_LIST_HISTORY.AddObject(Check_History);

                                    Check_value.REVISION = Current_Revision;

                                }

                                else

                                {

                                    Check_History.IMAGE_URL = Check_value.IMAGE_URL;

                                    Check_History.STATUS = state;

                                    Check_History.TODOLIST = Check_value.TODOLIST;

                                    Check_History.VENDOR = Check_value.VENDOR;

                                    Check_History.REMARK = Check_value.REMARK;

                                    Check_History.REPLY = Check_value.REPLY;

                                    Check_History.UPDATE_TIME = DateTime.Now;

                                }

                            }

                            validation = new List<string>();

                        }

                    }

                    Entity.SaveChanges();

                }

                DataBind();

                tb.ItemsSource = null;

                tb.ItemsSource = Lists;

                History_Set();

                //MessageBox.Show("Success");

                DialogMessage_Alert("Success");

            }

        }

        private void CheckListEvent(object sender, RoutedEventArgs e)

        {

            if (col1.Width == new GridLength(1200))

            {

                this.Width += 600;

                col1.Width = new GridLength(1800);

            }

            else

            {

                this.Width -= 600;

                col1.Width = new GridLength(1200);

            }

            History_Set();

        }

        private void CommentMoveEvent(object sender, MouseButtonEventArgs e)

        {

            SyncInit();

            Rect rect = new Rect();

            string[] RectPoint = ((e.Source as Image).DataContext as Customer).IMAGE_ANCHOR.Split(',');

            //string[] RectPoint = ((e.Source as Telerik.Windows.Controls.RadButton).DataContext as Customer).IMAGE_ANCHOR.Split(',');

            rect = new Rect(new Point(double.Parse(RectPoint[0]), double.Parse(RectPoint[1])), new Point(double.Parse(RectPoint[0]) + double.Parse(RectPoint[2]), double.Parse(RectPoint[1]) + double.Parse(RectPoint[3])));

            //Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.pageNavigator.GotoPage(((e.Source as Telerik.Windows.Controls.RadButton).DataContext as Customer).PAGENUMBER);

            Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.pageNavigator.GotoPage(((e.Source as Image).DataContext as Customer).PAGENUMBER);

            Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.zoomAndPanControl.ZoomTo(rect);

            Application.Current.MainWindow.Focus();

        }

        private void CaptureEvent(object sender, MouseButtonEventArgs e)

        {

            SyncInit();

            //캡쳐 하기 전에 코멘트 저장

            if (Common.ViewerDataModel.Instance.MarkupControls_USER.Count > 0 || (Application.Current.MainWindow as MainWindow).dzMainMenu.SelectLayer.Children.Count > 0)

            {

                var menu = (Application.Current.MainWindow as MainWindow).dzMainMenu;

                menu.ReleaseAdorner();

                if (menu.PreviewUserMarkupInfoItem != null && menu.PreviewUserMarkupInfoItem.IsPreviewUser == true)

                {

                    (Application.Current.MainWindow as MainWindow).dzTopMenu.RefactoryCommentReact(menu);

                }

                else if (menu.gridViewMarkup.SelectedItems.Count == 0 || (menu.gridViewMarkup.SelectedItems.FirstOrDefault() as IKCOM.MarkupInfoItem).UserID != App.ViewInfo.UserID)

                {

                }

                else

                {

                    (Application.Current.MainWindow as MainWindow).dzTopMenu.RefactoryCommentReact(menu);

                }

            }

            //Common.ViewerDataModel.Instance.CheckList_ID = ((e.Source as Telerik.Windows.Controls.RadButton).DataContext as Customer).ID;

            Common.ViewerDataModel.Instance.CheckList_ID = ((e.Source as Image).DataContext as Customer).ID;

            Application.Current.MainWindow.Focus();

            Common.ViewerDataModel.Instance.Capture_Opacity = 0.49;

            (Application.Current.MainWindow as MainWindow).dzMainMenu.mouseHandlingMode = IKCOM.MouseHandlingMode.Capture;

        }

        public void KeyEventDownAction(object sender, KeyEventArgs e)

        {

            switch (e.Key)

            {

                case Key.Escape:

                    {

                        (Application.Current.MainWindow as MainWindow).dzMainMenu.mouseHandlingMode = IKCOM.MouseHandlingMode.None;

                        Common.ViewerDataModel.Instance.Capture_Opacity = 0;

                    }

                    break;

            }

        }

        private void tb_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e)

        {

            if(ViewerDataModel.Instance.Capture_Opacity == 0)

                return;

            DataBind();

            tb.ItemsSource = null;

            tb.ItemsSource = Lists.OrderBy(info => info.CREATE_TIME);

            //tb1.ItemsSource = Lists.OrderBy(info => info.CREATE_TIME);

            if (ViewerDataModel.Instance.Capture_Opacity == 0.5)

            {

                tb.SortDescriptors.Clear();

                tb.FilterDescriptors.Clear();

                var scrollViewer = this.tb.ChildrenOfType<GridViewScrollViewer>().FirstOrDefault();

                if (scrollViewer != null)

                {

                    //this.tb.ChildrenOfType<GridViewScrollViewer>().FirstOrDefault().ScrollToVerticalOffset(this.tb.ChildrenOfType<GridViewScrollViewer>().FirstOrDefault().ExtentHeight);

                    //this.tb1.ChildrenOfType<GridViewScrollViewer>().FirstOrDefault().ScrollToVerticalOffset(this.tb.ChildrenOfType<GridViewScrollViewer>().FirstOrDefault().ExtentHeight);

                    tb.ScrollIndexIntoView(tb.Items.Count - 1);

                    tb.CurrentCellInfo = new GridViewCellInfo(tb.Items[tb.Items.Count - 1], tb.Columns["TODOLIST"]);

                    tb.Focus();

                }

            }

        }

        private void Radio_Open_Checked(object sender, RoutedEventArgs e)

        {

            (e.Source as RadioButton).Foreground = Brushes.Red;

            (e.Source as RadioButton).FontWeight = FontWeights.Bold;

            if ((((e.OriginalSource as RadioButton).Parent as StackPanel).Parent as GridViewCell).ParentRow.Item != null)

            {

                ((((e.OriginalSource as RadioButton).Parent as StackPanel).Parent as GridViewCell).ParentRow.Item as Customer)._STATUS = "Open";

            }

            if (Isinit)

            {

                Isinit = false;

                if ((e.Source as RadioButton).DataContext != null)

                {

                    if (((e.Source as RadioButton).DataContext as Customer).STATUS_DESC != "Vendor 반영 필요")

                    {

                        ((e.Source as RadioButton).DataContext as Customer).STATUS_DESC = "Vendor 반영 필요";

                        tb.Rebind();

                    }

                }

            }

        }

        private void Radio_Close_Checked(object sender, RoutedEventArgs e)

        {

            if (Isinit)

            {

                if (!isCheck_Status)

                {

                    Select_StatusID = ((e.Source as RadioButton).DataContext as Customer).ID;

                    isCheck_Status = true;

                    RadWindow CheckPop = new RadWindow();

                    CheckList_Status check = new CheckList_Status();

                    CheckPop = new RadWindow

                    {

                        MinWidth = 350,

                        MinHeight = 150,

                        Header = "Status Description을 입력하세요",

                        Content = check,

                        ResizeMode = System.Windows.ResizeMode.NoResize,

                        WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen,

                        IsTopmost = true,

                    };

                    StyleManager.SetTheme(CheckPop, new Office2013Theme());

                    CheckPop.Closed += CheckPop_Closed;

                    CheckPop.Show();

                    Isinit = false;

                    tb.Rebind();

                }

            }

            (e.Source as RadioButton).FontWeight = FontWeights.Bold;

            if ((((e.OriginalSource as RadioButton).Parent as StackPanel).Parent as GridViewCell).ParentRow.Item != null)

            {

                ((((e.OriginalSource as RadioButton).Parent as StackPanel).Parent as GridViewCell).ParentRow.Item as Customer)._STATUS = "Close";

            }

        }

        private void CheckPop_Closed(object sender, WindowClosedEventArgs e)

        {

            isCheck_Status = false;

            foreach(var item in tb.Items)

            {

                if(Select_StatusID == (item as Customer).ID.ToString())

                {

                    if (ViewerDataModel.Instance.CheckStatus != "" && ViewerDataModel.Instance.CheckStatus != null)

                    {

                        (item as Customer).STATUS_DESC = ViewerDataModel.Instance.CheckStatus;

                    }

                    else

                    {

                        (item as Customer).STATUS = "False";

                        (item as Customer)._STATUS = "Open";

                        (item as Customer).STATUS_ = "True";

                    }

                    ViewerDataModel.Instance.CheckStatus = "";

                    Select_StatusID = "";

                    tb.Rebind();

                    return;

                }

            }

        }

        private void Radio_Unchecked(object sender, RoutedEventArgs e)

        {

            (e.Source as RadioButton).Foreground = Brushes.Black;

            (e.Source as RadioButton).FontWeight = FontWeights.Normal;

        }

        private void mousedownOnImage(object sender, MouseButtonEventArgs args)

        {

            if(args.OriginalSource as TextBlock != null && (args.OriginalSource as TextBlock).Parent != null)

            {

                if((args.OriginalSource as TextBlock).Parent.GetType().Name == "GridViewHeaderCell")

                {

                    Isinit = false;

                    return;

                }

            }

            Isinit = true;

            RadWindow CheckPop = new RadWindow();

            if (args.OriginalSource is Image)

            {

                Image img = (args.OriginalSource as Image);

                if (img.Height != 45)

                    return;

                CommantImage check = new CommantImage(img);

                CheckPop = new RadWindow

                {

                    MinWidth = 500,

                    MinHeight = 500,

                    Header = "Image",

                    Content = check,

                    ResizeMode = System.Windows.ResizeMode.NoResize,

                    WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen,

                    IsTopmost = true,

                };

                StyleManager.SetTheme(CheckPop, new Office2013Theme());

                CheckPop.Show();

            }

            if (args.OriginalSource as TextBlock == null || (args.OriginalSource as TextBlock).Parent == null || ((args.OriginalSource as TextBlock).Parent) as GridViewCell == null)

            {

                return;

            }

            if ((((args.OriginalSource as TextBlock).Parent) as GridViewCell).DataColumn.ColumnGroupName.ToString() == "History")

            {

                CheckList_Detail Detail = new CheckList_Detail((((args.OriginalSource as TextBlock).Parent as GridViewCell).ParentRow.Item as KCOM.Controls.Customer).ID, (((args.OriginalSource as TextBlock).Parent) as GridViewCell).DataColumn.Header.ToString());

                CheckPop = new RadWindow

                {

                    MinWidth = 800,

                    MinHeight = 400,

                    Header = "Detail",

                    Content = Detail,

                    //ResizeMode = System.Windows.ResizeMode.CanResizeWithGrip,

                    ResizeMode = System.Windows.ResizeMode.NoResize,

                    WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen,

                    IsTopmost = true,

                };

                StyleManager.SetTheme(CheckPop, new Office2013Theme());

                //CheckPop.ShowDialog();

                CheckPop.Show();

            }

        }

        private void SyncEvent(object sender, MouseButtonEventArgs e)

        {

            using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(App.ViewInfo.ProjectNO).ToString()))

            {

                var _vpList = (from docitem in entity.DOCUMENT_ITEM

                               where docitem.DOCUMENT_ID == old_DocID

                               select new VPRevision

                               {

                                   RevNo = docitem.REVISION,

                                   GroupNo = docitem.GROUP_NO,

                                   FROM_VENDOR = docitem.ORIGINAL_FILE,

                                   DOCUMENT_ID = docitem.DOCUMENT_ID,

                                   TO_VENDOR = docitem.RESULT_FILE,

                                   RESULT = docitem.RESULT,

                                   //IsSyncPossible = docitem.DOCUMENT_ID == DocumentId ? false : true

                               }).FirstOrDefault();

                if (old_DocID == "")

                {

                    //DialogMessage_Alert("상위 리비전이 없습니다.", "Alert");

                    //MessageBox.Show("상위 리비전이 없습니다.");

                    DialogMessage_Alert("상위 리비전이 없습니다.");

                    return;

                }

                SyncInit();

                Rect rect = new Rect();

                //string[] RectPoint = ((e.Source as Telerik.Windows.Controls.RadButton).DataContext as Customer).IMAGE_ANCHOR.Split(',');

                string[] RectPoint = ((e.Source as Image).DataContext as Customer).IMAGE_ANCHOR.Split(',');

                rect = new Rect(new Point(double.Parse(RectPoint[0]), double.Parse(RectPoint[1])), new Point(double.Parse(RectPoint[0]) + double.Parse(RectPoint[2]), double.Parse(RectPoint[1]) + double.Parse(RectPoint[3])));

                //ViewerDataModel.Instance.SystemMain.dzMainMenu.pageNavigator.GotoPage(((e.Source as Telerik.Windows.Controls.RadButton).DataContext as Customer).PAGENUMBER);

                ViewerDataModel.Instance.SystemMain.dzMainMenu.pageNavigator.GotoPage(((e.Source as Image).DataContext as Customer).PAGENUMBER);

                ViewerDataModel.Instance.SystemMain.dzMainMenu.zoomAndPanControl.Sync_ZoomTo(rect);

                (Application.Current.MainWindow as MainWindow).dzMainMenu.Sync_Event(_vpList);

            }

        }

        #endregion

    }

}