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("لا يوجد لديك صلاحيات للتصدير");
}
}
}
