Exemple #1
0
        private void MenuItemExcel_Click(object sender, EventArgs e)
        {
            switch (TabControl.SelectedIndex)
            {
            case 0:
                DGVFish.SelectAll();
                var data0 = DGVFish.GetClipboardContent();
                if (data0 != null)
                {
                    Clipboard.SetDataObject(data0);
                }
                break;

            case 1:
                DGVPlant.SelectAll();
                var data1 = DGVPlant.GetClipboardContent();
                if (data1 != null)
                {
                    Clipboard.SetDataObject(data1);
                }
                break;

            case 2:
                DGVStatistics.SelectAll();
                var data2 = DGVStatistics.GetClipboardContent();
                if (data2 != null)
                {
                    Clipboard.SetDataObject(data2);
                }
                break;
            }
            Microsoft.Office.Interop.Excel.Application xlexcel;
            Microsoft.Office.Interop.Excel.Workbook    xlWorkBook;
            Microsoft.Office.Interop.Excel.Worksheet   xlWorkSheet;
            object misValue = System.Reflection.Missing.Value;

            xlexcel = new Microsoft.Office.Interop.Excel.Application {
                Visible = true
            };
            xlWorkBook  = xlexcel.Workbooks.Add(misValue);
            xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
            Microsoft.Office.Interop.Excel.Range CR = (Microsoft.Office.Interop.Excel.Range)xlWorkSheet.Cells[1, 1];
            CR.Select();
            xlWorkSheet.PasteSpecial(CR, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, true);
        }
Exemple #2
0
 public void InitDGVStatistics()
 {
     using (var context = new BotanicalGardenContext())
     {
         context.Statistics.Load();
         DGVStatistics.DataSource = context.Statistics.Local.ToBindingList();
         DGVStatistics.Columns["Tree"].Visible                = false;
         DGVStatistics.Columns["Plant"].Visible               = false;
         DGVStatistics.Columns["Id"].HeaderText               = "№";
         DGVStatistics.Columns["DateTime"].HeaderText         = "Дата/Время";
         DGVStatistics.Columns["LivingСonditions"].HeaderText = "Среда обитания";
         DGVStatistics.Columns["Сondition"].HeaderText        = "Состояние";
         DGVStatistics.Columns["Population"].HeaderText       = "Количество";
         DGVStatistics.Columns["TreeId"].HeaderText           = "№ дереа";
         DGVStatistics.Columns["PlantId"].HeaderText          = "№ растения";
         DGVStatistics.Refresh();
     }
 }
Exemple #3
0
 public void InitDGVStatistics()
 {
     using (var context = new AquariumContext())
     {
         context.Statistics.Load();
         DGVStatistics.DataSource = context.Statistics.Local.ToBindingList();
         DGVStatistics.Columns["Fish"].Visible                = false;
         DGVStatistics.Columns["Plant"].Visible               = false;
         DGVStatistics.Columns["Plant"].Visible               = false;
         DGVStatistics.Columns["Id"].HeaderText               = "№";
         DGVStatistics.Columns["DateTime"].HeaderText         = "Дата/Время";
         DGVStatistics.Columns["LivingСonditions"].HeaderText = "Условия обитания";
         DGVStatistics.Columns["Nutrition"].HeaderText        = "Питание";
         DGVStatistics.Columns["Population"].HeaderText       = "Популяция";
         DGVStatistics.Columns["FishId"].HeaderText           = "№ рыбы";
         DGVStatistics.Columns["PlantId"].HeaderText          = "№ водоросли";
         DGVStatistics.Refresh();
     }
 }