//Xuất Excel
private void btnXuatExcel_Click(object sender, RoutedEventArgs e)
{
#region 1. Tạo datatable xuất
DataTable _dtXuat = new DataTable();
_dtXuat.Columns.Add("Mã nhóm");
_dtXuat.Columns.Add("Tên nhóm");
_dtXuat.Columns.Add("Ghi chú");
DataRow _drXuat;
for (int i = 0; i < _DtNSP.Rows.Count; i++)
{
_drXuat = _dtXuat.NewRow();
_drXuat["Mã nhóm"] = _DtNSP.Rows[i]["MaNSP_NSP"].ToString();
_drXuat["Tên nhóm"] = _DtNSP.Rows[i]["TenNSP_NSP"].ToString();
_drXuat["Ghi chú"] = _DtNSP.Rows[i]["GhiChu_NSP"].ToString();
_dtXuat.Rows.Add(_drXuat);
}
#endregion
#region 2.Lưu file
SaveFileDialog _saveFile = new SaveFileDialog();
_saveFile.InitialDirectory = "C:";
_saveFile.Title = "Save as Excel Files";
_saveFile.FileName = "San pham";
_saveFile.DefaultExt = ".xls";
_saveFile.Filter = "Excel Files(2003)|*xls|Excel Files(2007)|*.xlsx";
if (_saveFile.ShowDialog() == true)
{
string _tenFile = _saveFile.FileName;
//Cho chạy ngầm cho hết đơ
bdProgress.Visibility = System.Windows.Visibility.Visible;
pbTienTrinh.IsIndeterminate = true;
lbProgress.Content = "Đang xử lý...";
worker = new BackgroundWorker();
// worker.WorkerReportsProgress = true;
worker.DoWork += (obj, ea) => UntilitiesBusiness.XuatExcel(_dtXuat, _tenFile);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(XuatExcelHoanThanh);
worker.RunWorkerAsync();
}
#endregion
}
