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 System.Text.RegularExpressions;

using GemBox.Spreadsheet;

using System.IO;

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

        MainWindow mainWindow;

        //string old_Revision = "";

        string old_DocID = "";

        string Current_Revision = "";

        //string Current_DocNo = "";

        //string Current_Slip = "";

        bool Isinit = false;

        int rev_cnt = 1;

        bool isCheck_Status = false;

        string Select_StatusID = "";

        #endregion

        #region 생성자

        public CheckList(MainWindow main)

        {

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

            InitializeComponent();

            mainWindow = main;

            this.Loaded += CheckList_Loaded;

            this.KeyDown += new KeyEventHandler(KeyEventDownAction);

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

        }

        #endregion

        public void DataBind()

        {

            try

            {

                Isinit = false;

                Lists = new List<Customer>();

                string doc_no = mainWindow.dzMainMenu._DocItem.DOCUMENT_NO;

                string project_no = App.ViewInfo.ProjectNO;

                string user_id = App.ViewInfo.UserID;

                //Logger.sendReqLog("GetUserCheckList: ", project_no + "," + user_id + "," + doc_no, 1);

                items = Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.GetUserCheckList(project_no, user_id, doc_no);

                if (items.Count() > 0)

                {

                    //Logger.sendResLog("GetUserCheckList", "TRUE", 1);

                }

                else

                {

                    //Logger.sendResLog("GetUserCheckList", "FALSE", 1);

                }

                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

                    //Logger.sendReqLog("GetCheckListHistory: ", project_no + "," + item.ID, 1);

                    var history = Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.GetCheckListHistory(project_no, item.ID);

                    if (history.Count() > 0)

                    {

                        //Logger.sendResLog("GetCheckListHistory", "TRUE", 1);

                    }

                    else

                    {

                        //Logger.sendResLog("GetCheckListHistory", "FALSE", 1);

                    }

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

                }

            }

            catch (Exception ex)

            {

                Logger.sendResLog("Checklist DataBind", ex.Message, 0);

            }

        }

        private void ChangeSize(double width, double height)

        {

            this.Width = width;

            this.Height = height;

        }

        private void SyncInit()

        {

            try

            {

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

                {

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

                    ViewerDataModel.Instance.PageBalanceMode = false;

                    ViewerDataModel.Instance.PageBalanceNumber = 0;

                    ViewerDataModel.Instance.SyncPageNumber = 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;

                }

            }

            catch(Exception ex)

            {

                //Logger.sendResLog("SyncInit", ex.Message, 0);

            }

        }

        private void DialogMessage_Alert(string Msg)

        {

            try

            {

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

            }

            catch (Exception ex)

            {

                //Logger.sendResLog("DialogMessage_Alert", ex.Message, 0);

            }

        }

        private void History_Set()

        {

            try

            {

                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

                }

            }

            catch (Exception ex)

            {

                //Logger.sendResLog("History_Set", ex.Message, 0);

            }

        }

        #region Excel Export

        [Obsolete]

        private void ExportEvent(object sender, RoutedEventArgs e)

        {

            try

            {

                if (mainWindow.dzMainMenu.mouseHandlingMode == MouseHandlingMode.Capture)

                {

                    DialogMessage_Alert("Capture중 입니다.");

                    return;

                }

                this.ExportIndy.IsBusy = true;

                if (Lists.Count == 0)

                {

                    DialogMessage_Alert("Data Not Found");

                    this.ExportIndy.IsBusy = false;

                    return;

                }

                string extension = "xlsx";

                string excelpath = CommonLib.Common.GetConfigString("excelFilePath", "URL", "", App.isExternal);

                Uri url = new Uri(excelpath);

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

                        SpreadsheetInfo.SetLicense(Properties.Settings.Default.GemBoxLicense);// "EXK0-W4HZ-N518-IMEW");                    

                        ExcelFile workbook = null;

                        ExcelWorksheet worksheet = null;

                        try

                        {

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

                            workbook = ExcelFile.Load(dialog.FileName);

                            worksheet = workbook.Worksheets[0];

                            // 데이타 넣기

                            int h = 8;

                            int w = 1;

                            string project_no = App.ViewInfo.ProjectNO;

                            worksheet.Cells[1, w + 8].Value = project_no;

                            string project_name = Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.GetProjectName(project_no);

                            if (project_name != null || project_name != "")

                            {

                                //Logger.sendResLog("GetProjectName", "TRUE", 1);

                            }

                            else

                            {

                                //Logger.sendResLog("GetProjectName", "FALSE", 1);

                            }

                            worksheet.Cells[2, w + 8].Value = project_name;

                            worksheet.Cells[3, w + 8].Value = (mainWindow as MainWindow).dzMainMenu._DocItem.DOCUMENT_NO;

                            worksheet.Cells[4, w + 8].Value = (mainWindow as MainWindow).dzMainMenu.userData.NAME + " (" + App.ViewInfo.UserID + ")";

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

                            ExcelCell Range_I = worksheet.Cells["K9"];                           

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

                            worksheet.Cells.GetSubrangeAbsolute(8, 11, 8, 11 + rev_cnt - 1).Merged = true;                       

                            if (rev_cnt != 1)

                            {

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

                            }

                            CellRange iRange = worksheet.Cells.GetSubrange("B10:" + Ran + "10");

                            //필터 기능 추가

                            CellRange Filter_Range = worksheet.Cells.GetSubrange("B9:" + Ran + "9");

                            Filter_Range.Filter(true);

                            ExcelCell Range_b = worksheet.Cells["B10"];

                            Range_b.Row.SetHeight(190, LengthUnit.Pixel);

                            Lists.ForEach(data =>

                            {

                                h++;

                                // Get the range.

                                CellRange oRange = worksheet.Cells.GetSubrange("B" + (h + 1) + ":" + Ran + (h + 1));

                                foreach (var cell in oRange)

                                {

                                    cell.Style.Borders.SetBorders(MultipleBorders.Outside, SpreadsheetColor.FromName(ColorName.Black), LineStyle.Thin);

                                }

                                if (data.IMAGE_PATH != null)

                                {

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

                                    ImageRange.Row.Height = Range_b.Row.Height;

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

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

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

                                    ImageRange.Style.HorizontalAlignment = HorizontalAlignmentStyle.Left;

                                    ImageRange.Style.VerticalAlignment = VerticalAlignmentStyle.Top;                                      

                                    byte[] imageData = data.IMAGE_PATH;

                                    MemoryStream memoryStream = new MemoryStream();

                                    o_Image.Save(memoryStream, System.Drawing.Imaging.ImageFormat.Jpeg);                                    

                                    int column = 2; // 이미지를 삽입할 열

                                    int row = h;    // 이미지를 삽입할 행

                                    // 이미지를 워크시트에 추가

                                    ExcelPicture picture = worksheet.Pictures.Add(memoryStream, PositioningMode.Move, new AnchorCell(ImageRange.Column, ImageRange.Row, 0, 0), ExcelPictureFormat.Jpeg);

                                    picture.Position.SetTop(picture.Position.Top + 7, LengthUnit.Point);

                                    picture.Position.SetLeft(picture.Position.Left + 7, LengthUnit.Point);

                                    int Height = o_Image.Height > 100 ? o_Image.Height : 100;

                                    ImageRange.Row.SetHeight(Height + 20, LengthUnit.Pixel);

                                    //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].Value = data.REVISION;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                                //worksheet.Rows[h]

                                #endregion

                            });

                            for (int columnIndex = 1; columnIndex < 11; ++columnIndex)

                            {    

                                worksheet.Columns[columnIndex].AutoFit();

                            }

                            worksheet.Columns["D"].SetWidth(200, LengthUnit.Pixel);

                            worksheet.Columns["G"].Width = Convert.ToInt32(worksheet.Columns["G"].Width * 1.1);

                            // 엑셀파일 저장

                            workbook.Save(dialog.FileName);

                        }

                        finally

                        {                        

                            // Clean up

                            ReleaseExcelObject(worksheet);

                            ReleaseExcelObject(workbook);

                        }

                    }

                    DialogMessage_Alert("Success");

                }

                this.ExportIndy.IsBusy = false;

            }

            catch (Exception ex)

            {

                //Logger.sendResLog("CheckList ExportEvent", ex.Message, 0);

            }

        }

        private static void SetWidth(ExcelColumn column, double width)

        {

            column.SetWidth(

                Math.Truncate((width * 7 + 5) / 7 * 256) / 256,

                LengthUnit.ZeroCharacterWidth);

        }

        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;

            try

            {

                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;

            }

            catch (Exception ex)

            {

                //Logger.sendResLog("Resize", ex.Message, 0);

                return null;

            }

        }

        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)

        {

            DataBind();

            this.tb.ItemsSource = null;

            this.tb.ItemsSource = Lists;

            History_Set();

        }

        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)

        {

            try

            {

                mainWindow.Focus();

                Common.ViewerDataModel.Instance.CheckList_ID = Commons.ShortGuid();

                Common.ViewerDataModel.Instance.Capture_Opacity = 0.5;

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

            }

            catch(Exception ex)

            {

                //Logger.sendResLog("Checklist Addevent", ex.Message, 0);

            }

        }

        private void SaveEvent(object sender, RoutedEventArgs e)

        {

            try

            {

                if ((mainWindow as MainWindow).dzMainMenu.mouseHandlingMode == MouseHandlingMode.Capture)

                {

                    DialogMessage_Alert("Capture중 입니다.");

                    return;

                }

                CHECK_LIST Check_value = new CHECK_LIST();

                CHECK_LIST_HISTORY Check_History = new CHECK_LIST_HISTORY();

                foreach (var item in tb.Items)

                {

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

                    string state = "";

                    //Logger.sendReqLog("GetCheckList: ", App.ViewInfo.ProjectNO + "," + Check_ID, 1);

                    Check_value = Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.GetCheckList(App.ViewInfo.ProjectNO, Check_ID);

                    if (Check_value != null)

                    {

                        //Logger.sendResLog("GetCheckList", "TRUE", 1);

                    }

                    else

                    {

                        //Logger.sendResLog("GetCheckList", "FALSE", 1);

                    }

                    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 ((item as Customer).STATUS == "False")

                                description = Check_value.STATUS_DESC_OPEN;

                            else

                                description = Check_value.STATUS_DESC_CLOSE;

                            //Logger.sendReqLog("GetCheckListHistory: ", App.ViewInfo.ProjectNO + "," + Check_ID, 1);

                            var history = Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.GetCheckListHistory(App.ViewInfo.ProjectNO, Check_ID);

                            if (history.Count() > 0)

                            {

                                //Logger.sendResLog("GetCheckList", "TRUE", 1);

                            }

                            else

                            {

                                //Logger.sendResLog("GetCheckList", "FALSE", 1);

                            }

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

                            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 = Commons.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

                                    };

                                    var result = Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.AddCheckListHistory(App.ViewInfo.ProjectNO, Check_History).ToString();

                                    Logger.sendReqLog("AddCheckListHistory: ", App.ViewInfo.ProjectNO + "," + Check_History, 1);

                                    Logger.sendResLog("AddCheckListHistory", result, 1);

                                    Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.AddCheckListHistory(App.ViewInfo.ProjectNO, 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;

                                    if (state == "Open")

                                    {

                                        Check_History.STATUS_DESC = Check_value.STATUS_DESC_OPEN;

                                    }

                                    else

                                    {

                                        Check_History.STATUS_DESC = Check_value.STATUS_DESC_CLOSE;

                                    }

                                    Logger.sendReqLog("SaveCheckListHistory: ", App.ViewInfo.ProjectNO + "," + ViewerDataModel.Instance.SystemMain.dzMainMenu.CurrentDoc.Revision + "," + Check_History, 1);

                                    //Logger.sendResLog("SaveCheckListHistory", Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.SaveCheckListHistory(App.ViewInfo.ProjectNO, ViewerDataModel.Instance.SystemMain.dzMainMenu.CurrentDoc.Revision, Check_History).ToString(), 1);

                                    Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.SaveCheckListHistory(App.ViewInfo.ProjectNO, ViewerDataModel.Instance.SystemMain.dzMainMenu.CurrentDoc.Revision, Check_History);

                                }

                            }

                            validation = new List<string>();

                        }

                    }

                    Logger.sendReqLog("SaveCheckList: ", App.ViewInfo.ProjectNO + "," + Check_ID + "," + Check_value, 1);

                    //Logger.sendResLog("SaveCheckList", Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.SaveCheckList(App.ViewInfo.ProjectNO, Check_ID, Check_value).ToString(), 1);

                    Common.ViewerDataModel.Instance.SystemMain.dzMainMenu.BaseClient.SaveCheckList(App.ViewInfo.ProjectNO, Check_ID, Check_value);

                }

                DataBind();

                tb.ItemsSource = null;

                tb.ItemsSource = Lists;

                History_Set();

                DialogMessage_Alert("Success");

            }

            catch (Exception ex)

            {

                //Logger.sendResLog("Checklist SaveEvent", ex.Message, 0);

            }

        }

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

            mainWindow.Focus();

        }

        private void CaptureEvent(object sender, MouseButtonEventArgs e)

        {

            SyncInit();

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

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

            {

                var menu = (mainWindow as MainWindow).dzMainMenu;

                SelectionSet.Instance.UnSelect(menu);

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

                {

                    (mainWindow as MainWindow).dzTopMenu.SaveEventCallback(null, null);

                }

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

                {

                }

                else

                {

                    (mainWindow as MainWindow).dzTopMenu.SaveEventCallback(null, null);

                }

            }

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

            //Common.ViewerDataModel.Instance.PageNumber = ((e.Source as Image).DataContext as Customer).PAGENUMBER;

            mainWindow.Focus();

            Common.ViewerDataModel.Instance.Capture_Opacity = 0.49;

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

        }

        public void KeyEventDownAction(object sender, KeyEventArgs e)

        {

            switch (e.Key)

            {

                case Key.Escape:

                    {

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

                        Common.ViewerDataModel.Instance.Capture_Opacity = 0;

                    }

                    break;

            }

        }

        private void tb_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e)

        {

            try

            {

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

                    }

                }

            }

            catch(Exception ex)

            {

                //Logger.sendResLog("tb_IsVisibleChanged", ex.Message, 0);

            }

        }

        private void Radio_Open_Checked(object sender, RoutedEventArgs e)

        {

            try

            {

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

                        }

                    }

                }

            }

            catch(Exception ex)

            {

                //Logger.sendResLog("Radio_Open_Checked", ex.Message, 0);

            }

        }

        private void Radio_Close_Checked(object sender, RoutedEventArgs e)

        {

            try

            {

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

                }

            }

            catch(Exception ex)

            {

                //Logger.sendResLog("Radio_Close_Checked", ex.Message, 0);

            }

        }

        private void CheckPop_Closed(object sender, WindowClosedEventArgs e)

        {

            try

            {

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

                        }