예제 #1
0
 public void OnWindowActivate(object workbook)
 {
     if (IsConnected)
     {
         Excel._Workbook book = this.Parent as Excel._Workbook;
         if (book != null)
         {
             try
             {
                 string parentBookFullName = (string)book.GetType().InvokeMember(
                     "FullName", System.Reflection.BindingFlags.GetProperty, null, book, null, CultureInfo.CurrentUICulture);
                 string workbookFullName = (string)workbook.GetType().InvokeMember(
                     "FullName", System.Reflection.BindingFlags.GetProperty, null, workbook, null, CultureInfo.CurrentUICulture);
                 if (string.Compare(parentBookFullName, workbookFullName, true) == 0)
                 {
                     Excel._Worksheet sheet = book.ActiveSheet as Excel._Worksheet;
                     if (sheet != null)
                     {
                         try
                         {
                             if (String.Compare(sheet.Name, Worksheet, true) == 0)
                             {
                                 adxClearTimesheet.Enabled             = true;
                                 adxRibbonButtonClearTimesheet.Enabled = true;
                             }
                         }
                         finally { Marshal.ReleaseComObject(sheet); }
                     }
                 }
             }
             catch (Exception err)
             {
                 MessageBox.Show(err.Message, err.Source, MessageBoxButtons.OK, MessageBoxIcon.Error);
             }
         }