private void btnExportSelected_Click(object sender, RoutedEventArgs e) { if (!BaseDataBase.CurrentUser.CanExport) { MyMessageBox.Show("ليس لديك صلاحية تصدير"); return; } var control = tcMain.SelectedItem as TabItem; var DGMain = (control.Content as FrameworkElement).FindName("dgMain") as DataGrid; if (DGMain.SelectedItems.Count > 0) { if (BaseDataBase.CurrentUser.IsAdmin) { var dtx = (DGMain.ItemsSource as DataView).Table; if (dtx.Rows.Count > 0) { var dt = dtx.Clone(); for (int i = 0; i < DGMain.SelectedItems.Count; i++) { var dr = dt.NewRow(); object[] os = new object[dt.Columns.Count]; for (int j = 0; j < dt.Columns.Count; j++) { os[j] = (DGMain.SelectedItems[i] as DataRowView).Row.ItemArray[j]; } dr.ItemArray = os; dt.Rows.Add(dr); } List <int> indexes = new List <int>(); for (int i = 0; i < DGMain.Columns.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { if (DGMain.Columns[i].SortMemberPath == dt.Columns[j].ColumnName) { if (!DGMain.Columns[i].IsReadOnly) { dt.Columns.Remove(dt.Columns[j]); break; } else { dt.Columns[j].ColumnName = DGMain.Columns[i].Header.ToString(); } } } } ExportToExcel.ExportDataTableToExcel x = new ExportToExcel.ExportDataTableToExcel(dt); x.GenerateReport(); } } else { MyMessageBox.Show("لا يوجد لديك صلاحيات للتصدير"); } } }
private void btnExport2Excel_Click(object sender, RoutedEventArgs e) { if (dgExcelFile.ItemsSource != null) { var dt = (dgExcelFile.ItemsSource as DataView).Table; for (int i = 0; i < dgExcelFile.Columns.Count; i++) { dt.Columns[i].Caption = dgExcelFile.Columns[i].Header.ToString(); } ExportToExcel.ExportDataTableToExcel x = new ExportToExcel.ExportDataTableToExcel(dt); x.GenerateReport(); } }
private void btnExportToExcelMain_Click(object sender, RoutedEventArgs e) { if (dg.Items.Count > 0) { if (BaseDataBase.CurrentUser.CanExport) { var dt = (dg.ItemsSource as DataView).Table.Clone(); for (int i = 0; i < dg.Items.Count; i++) { var dr = dt.NewRow(); object[] os = new object[dt.Columns.Count]; for (int j = 0; j < dt.Columns.Count; j++) { os[j] = (dg.Items[i] as DataRowView).Row.ItemArray[j]; } dr.ItemArray = os; dt.Rows.Add(dr); } List <int> indexesToRemove = new List <int>(); for (int i = 0; i < dt.Columns.Count; i++) { int j = 0; for (; j < dg.Columns.Count; j++) { if (dg.Columns[j].SortMemberPath == dt.Columns[i].ColumnName) { dt.Columns[i].ColumnName = dg.Columns[j].Header.ToString(); break; } } if (j == dg.Columns.Count) { indexesToRemove.Add(i); } } for (int i = indexesToRemove.Count - 1; i >= 0; i--) { dt.Columns.RemoveAt(i); } ExportToExcel.ExportDataTableToExcel x = new ExportToExcel.ExportDataTableToExcel(dt); x.GenerateReport(); } } else { MyMessageBox.Show("لا يوجد لديك صلاحيات للتصدير"); } }
private void btnExport_Click(object sender, RoutedEventArgs e) { if (!BaseDataBase.CurrentUser.CanExport) { MyMessageBox.Show("ليس لديك صلاحية تصدير"); return; } var control = tcMain.SelectedItem as TabItem; var DGMain = (control.Content as FrameworkElement).FindName("dgMain") as DataGrid; if (DGMain.Items.Count > 0) { if (BaseDataBase.CurrentUser.IsAdmin) { var dt = (DGMain.ItemsSource as DataView).Table; ExportToExcel.ExportDataTableToExcel x = new ExportToExcel.ExportDataTableToExcel(dt); x.GenerateReport(); } else { MyMessageBox.Show("لا يوجد لديك صلاحيات للتصدير"); } } }