private void XuatExcel() { DataTable Final = new DataTable(); int total = 0; Final = supBLL.SearchIngredient(supSea, 1, out total); double RecordPerPage = 20; double tem = (total / RecordPerPage); totalPage = Math.Ceiling(tem); for (int i = 2; i <= totalPage; i++) // duyet tat ca cac trang { DataTable dt = supBLL.SearchIngredient(supSea, i, out total); int j = Final.Rows.Count; foreach (DataRow dr in dt.Rows) { Final.Rows.Add(); for (int k = 0; k < dt.Columns.Count; k++) { Final.Rows[j][k] = dr[k]; } j++; } } //ExportExcelAlgorithms epex = new ExportExcelAlgorithms(); //epex.ExportFileFromDataTable(Final, "Products_" + supBLL.GetDMY() + "_" + supBLL.GetHMS()); string[] prm = { "3" }; ExportExcelAlgorithms epex = new ExportExcelAlgorithms(); epex.ExportFileFromDataTable_Dung(Final, "Ingreadient_" + DateTime.Now.ToString("ddMMyy_HHmmss"), "List of " + "Suppliers_" + DateTime.Now.ToString("ddMMyy_HHmmss"), prm); }