private void Save()
{
Excel.Application Raport;
Excel.Workbook workbook;
Excel.Worksheet worksheet;
bool PNC = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_CalcPNC", true).First()).Checked;
bool PNCSpec = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_CalcPNCSpec", true).First()).Checked;
DataGridView PNCList = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_PNC", true).First();
string FileName = Name();
if (PNCList.Rows.Count > 0)
{
Create_Excel_Application _Application = new Create_Excel_Application();
Raport = _Application.Create_Application();
Raport.Visible = false;
Raport.DisplayAlerts = false;
Raport.ScreenUpdating = false;
Raport.DisplayStatusBar = false;
Raport.EnableEvents = false;
Create_Excel_WorkBooks _Excel_WorkBooks = new Create_Excel_WorkBooks();
workbook = _Excel_WorkBooks.Create_WorkBooks(Raport);
Create_Excel_WorkSheet _Excel_WorkSheet = new Create_Excel_WorkSheet();
worksheet = _Excel_WorkSheet.Create_WorkSheet(workbook, "Action");
worksheet.Application.ActiveWindow.Zoom = 85;
if (PNC)
{
CreatePNC(worksheet);
Save_Excel_WorkBook_All Save = new Save_Excel_WorkBook_All();
Save.Save_WorkBook(Raport, workbook, FileName);
}
else if (PNCSpec)
{
CreatePNCSpec(worksheet);
Save_Excel_WorkBook_All Save = new Save_Excel_WorkBook_All();
Save.Save_WorkBook(Raport, workbook, FileName);
}
}
else
{
MessageBox.Show("No data to save!", "Save Data");
}
}
public void Genereted_PCRaport()
{
System.Data.DataTable ActionList = new System.Data.DataTable();
System.Data.DataTable NewActionPozitive;
System.Data.DataTable NewActionNegative;
System.Data.DataTable NewActionPozitiveFinish;
System.Data.DataTable NewActionNegativeFinish;
string Link;
Worksheet worksheet;
Link = data_Import.Load_Link("Action");
data_Import.Load_TxtToDataTable(ref ActionList, Link);
NewActionPozitive = Load_Table(ActionList, "2019", "Pozytywna");
NewActionNegative = Load_Table(ActionList, "2019", "Negatywna");
NewActionPozitiveFinish = Prepare_Table(NewActionPozitive);
NewActionNegativeFinish = Prepare_Table(NewActionNegative);
Microsoft.Office.Interop.Excel.Application excel;
Workbook workbook;
Create_Excel_Application Application = new Create_Excel_Application();
excel = Application.Create_Application();
Create_Excel_WorkBooks Workbooks = new Create_Excel_WorkBooks();
workbook = Workbooks.Create_WorkBooks(excel);
Create_Excel_WorkSheet Excel_worksheet = new Create_Excel_WorkSheet();
worksheet = Excel_worksheet.Create_WorkSheet(workbook, "DM 2019");
worksheet.Application.ActiveWindow.Zoom = 85;
Action_WorkSheet(worksheet, NewActionPozitiveFinish, 10);
Action_WorkSheet(worksheet, NewActionNegativeFinish, 14 + NewActionPozitiveFinish.Rows.Count);
Save_Excel_WorkBook Save = new Save_Excel_WorkBook();
Save.Save_WorkBook(excel, workbook);
}
private void Sum(Workbook workbook, decimal Year)
{
Worksheet worksheet;
DataRow Frozen;
string Revision;
int Month;
Frozen = Load_Frozen(Year);
Revision = CheckRevision(Year, Frozen);
Month = CheckMonth(Year, Frozen);
Create_Excel_WorkSheet excel_WorkSheet = new Create_Excel_WorkSheet();
worksheet = excel_WorkSheet.Create_WorkSheet(workbook, "Tabela");
worksheet.Application.ActiveWindow.DisplayGridlines = false;
worksheet.Application.ActiveWindow.Zoom = 85;
//Generowanie Tabeli
Sum_Text(worksheet, Revision);
//Ładowanie danych do tabeli SUM
ActionSum(worksheet, Revision, Month);
}
