private void btnExportExcel_Click(object sender, EventArgs e)
{
FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();
folderBrowserDialog.RootFolder = Environment.SpecialFolder.Desktop;
folderBrowserDialog.ShowNewFolderButton = false;
if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
{
ExportExcel obj = new ExportExcel();
obj.WriteDataTableToExcel(dataExcel, "Danh mục", folderBrowserDialog.SelectedPath + "\\" + "danhMuc.xlsx", "");
MessageBox.Show("Xuất file danh mục thành công!", "Thông Báo");
}
}
private void guna2ImageButton1_Click(object sender, EventArgs e)
{
FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();
folderBrowserDialog.RootFolder = Environment.SpecialFolder.Desktop;
folderBrowserDialog.ShowNewFolderButton = false;
if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
{
ExportExcel obj = new ExportExcel();
obj.WriteDataTableToExcel(data, "Nhân Viên", folderBrowserDialog.SelectedPath + "\\" + "nhanVien.xlsx", "");
MessageBox.Show("Xuất file nhân viên thành công!", "Thông Báo");
}
}
private void btnExportExcel_Click(object sender, EventArgs e)
{
FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();
folderBrowserDialog.RootFolder = Environment.SpecialFolder.Desktop;
folderBrowserDialog.ShowNewFolderButton = false;
if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
{
ExportExcel obj = new ExportExcel();
if (cbbThongKe.Text.ToString() == "Doanh Thu")
{
obj.WriteDataTableToExcel(dataExportExcel, "Doanh Thu", folderBrowserDialog.SelectedPath + "\\" + "thongKeDoanhThu.xlsx", "");
}
else
{
obj.WriteDataTableToExcel(dataExportExcel, "Sản Phẩm Đã Bán", folderBrowserDialog.SelectedPath + "\\" + "thongKeSPDaBan.xlsx", "");
}
MessageBox.Show("Xuất file thống kê thành công!", "Thông Báo");
}
}