private void BtnExportar_Click(object sender, EventArgs e)
{
try {
if (gvDatos.RowCount > 0)
{
if (RadMessageBox.Show("El listado se exportará en formato de excel, desea continuar...?", this.Text, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.Filter = "Excel|*.xls";
saveFile.Title = "Guardar Archivo";
saveFile.ShowDialog();
if (saveFile.FileName != "")
{
var exportar = new ExportToExcelML(gvDatos);
exportar.ExportVisualSettings = true;
exportar.HiddenColumnOption = HiddenOption.DoNotExport;
exportar.ExportHierarchy = true;
exportar.FileExtension = "xls";
exportar.SheetName = "Préstamos";
exportar.RunExport(saveFile.FileName);
}
RadMessageBox.Show("Archivo exportado correctamente", this.Text, MessageBoxButtons.OK, RadMessageIcon.Info);
}
}
} catch (Exception ex) {
RadMessageBox.Show("Ocurrió un error al exportar los préstamos\n" + ex.Message, this.Text, MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
private void RunExportToExcelML(string fileName, ref bool openExportFile)
{
ExportToExcelML excelExporter = new ExportToExcelML(this.radGridView1);
//set export settings
excelExporter.ExportVisualSettings = true;
excelExporter.ExportHierarchy = true;
excelExporter.HiddenColumnOption = HiddenOption.DoNotExport;
try
{
this.Cursor = Cursors.WaitCursor;
excelExporter.RunExport(fileName);
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?",
"Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
openExportFile = true;
}
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error);
}
finally
{
this.Cursor = Cursors.Default;
}
}
public rptfrmDriverCommissionPaymentSummary()
{
InitializeComponent();
this.Load += new EventHandler(rptfrmDriverCommissionPaymentSummary_Load);
ExportToExcelML export = new ExportToExcelML(this.radGridView1);
export.ExportVisualSettings = true;
export.HiddenColumnOption = HiddenOption.ExportAsHidden;
export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting);
//
//
//radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time";
//radGridView1.Columns["From"].HeaderText = "Pick-up Address";
//radGridView1.Columns["To"].HeaderText = "Drop-off Address";
//radGridView1.Columns["CompanyName"].HeaderText = "Account";
//Me.RadGridView1.Columns(0).ExcelExportType = Export.DisplayFormatType.Text
//CompanyName
//exporter = new RadGridViewExcelExporter();
//BackgroundWorker worker = new BackgroundWorker();
//worker.DoWork += new DoWorkEventHandler(worker_DoWork);
//worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted);
//worker.RunWorkerAsync(saveFileDialog1.FileName);
//exporter.Progress += new ProgressHandler(exportProgress);
//this.btnExport.Enabled = false;
}
private void RunExportToExcelML(string fileName, ref bool openExportFile)
{
ExportToExcelML excelExporter = new ExportToExcelML(this.radGridView1);
if (this.radTextBoxSheet.Text != String.Empty)
{
excelExporter.SheetName = this.radTextBoxSheet.Text;
}
switch (this.radComboBoxSummaries.SelectedIndex)
{
case 0:
excelExporter.SummariesExportOption = SummariesOption.ExportAll;
break;
case 1:
excelExporter.SummariesExportOption = SummariesOption.ExportOnlyTop;
break;
case 2:
excelExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom;
break;
case 3:
excelExporter.SummariesExportOption = SummariesOption.DoNotExport;
break;
}
//set max sheet rows
if (this.radRadioButton1.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
excelExporter.SheetMaxRows = ExcelMaxRows._1048576;
}
else if (this.radRadioButton2.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
excelExporter.SheetMaxRows = ExcelMaxRows._65536;
}
//set exporting visual settings
excelExporter.ExportVisualSettings = this.exportVisualSettings;
try
{
excelExporter.RunExport(fileName);
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?",
"Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
openExportFile = true;
}
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
private void radButton_excel_Click(object sender, EventArgs e)
{
string filename = DateTime.Now.ToString("yyyy-MM-dd HHmmss.fff");
ExportToExcelML exporter = new ExportToExcelML(this.radGridView1);
exporter.RunExport(".\\capture\\data-" + filename + ".xls");
RadMessageBox.Show("data-" + filename + ".xls Saved!!");
}
private void RunExportToExcelML(string fileName, ref bool openExportFile)
{
ExportToExcelML excelExporter = new ExportToExcelML(this.radGridView1);
switch (this.radComboBoxSummaries.SelectedIndex)
{
case 0:
excelExporter.SummariesExportOption = SummariesOption.ExportAll;
break;
case 1:
excelExporter.SummariesExportOption = SummariesOption.ExportOnlyTop;
break;
case 2:
excelExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom;
break;
case 3:
excelExporter.SummariesExportOption = SummariesOption.DoNotExport;
break;
}
//set export settings
excelExporter.ExportVisualSettings = this.radCheckBoxExportVisual.IsChecked;
excelExporter.ExportHierarchy = this.radCheckBoxExportHierarchy.IsChecked;
excelExporter.HiddenColumnOption = HiddenOption.DoNotExport;
try
{
this.Cursor = Cursors.WaitCursor;
excelExporter.RunExport(fileName);
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?",
"Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
openExportFile = true;
}
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void RunExportToExcelML(object fileName)
{
try
{
ExportToExcelML exporter = new ExportToExcelML(this.radGridView1);
exporter.ExportVisualSettings = true;
if (this.radRadioButton1.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
exporter.SheetMaxRows = ExcelMaxRows._1048576;
}
exporter.ExcelCellFormatting += new ExcelCellFormattingEventHandler(exporter_ExcelCellFormatting);
exporter.ExcelTableCreated += new ExcelTableCreatedEventHandler(exporter_ExcelTableCreated);
exporter.RunExport(fileName.ToString());
RadMessageBox.SetThemeName("ControlDefault");
string text = "Export finished successfully!";
if (this.InvokeRequired)
{
this.Invoke(new EventHandler(delegate
{
RadMessageBox.Show(this, text);
}));
}
else
{
RadMessageBox.Show(this, text);
}
}
catch (System.IO.IOException ex)
{
if (this.InvokeRequired)
{
this.Invoke(new EventHandler(delegate
{
RadMessageBox.SetThemeName("ControlDefault");
RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error);
}));
}
else
{
RadMessageBox.SetThemeName("ControlDefault");
RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
finally
{
this.WorkCompleted();
}
}
public static void ExportExcelProcess(RadGridView _gv)
{
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string strFileName = saveFileDialog1.FileName;
ExportToExcelML exporter = new ExportToExcelML(_gv);//RadGridView1)
string fileName = strFileName;
exporter.RunExport(fileName);
}
}
public static void ExportGridXlSX2(RadGridView rv, string FileName)
{
//SaveFileDialog dialog = new SaveFileDialog();
//dialog.Filter = "Excel File (*.xls)|*.xls";
//if (dialog.ShowDialog() == DialogResult.OK)
//{
ExportToExcelML exporter = new ExportToExcelML(rv);
exporter.HiddenRowOption = HiddenOption.DoNotExport;
exporter.HiddenColumnOption = HiddenOption.DoNotExport;
exporter.RunExport(FileName);
// MessageBox.Show("Export Finished");
//}
}
public static void ExportExcelProcess(RadGridView _gv)
{
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string strFileName = saveFileDialog1.FileName;
ExportToExcelML exporter = new ExportToExcelML(_gv);//RadGridView1)
string fileName = strFileName;
exporter.RunExport(fileName);
}
}
private void radButtonElement1_Click(object sender, EventArgs e)
{
saveFileDialog1.Filter = "*.xls|*.xls";
saveFileDialog1.FileName = "export";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
radGridView1.Columns[6].ExcelExportType = DisplayFormatType.Text;
radGridView1.Columns[7].ExcelExportType = DisplayFormatType.Text;
radGridView1.Columns[2].ExcelExportType = DisplayFormatType.Custom;
radGridView1.Columns[6].ExcelExportFormatString = "dd.MM.yyyy";
ExportToExcelML exporter = new ExportToExcelML(radGridView1);
exporter.RunExport(saveFileDialog1.FileName);
System.Diagnostics.Process.Start(saveFileDialog1.FileName);
}
}
private void btnExportar_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
try {
saveFileDialog.Filter = "Excel files (*.xlsx)|*.xls";
saveFileDialog.RestoreDirectory = true;
if (saveFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
if (saveFileDialog.FileName.Equals(String.Empty))
{
RadMessageBox.SetThemeName(this.gvDatos.ThemeName);
RadMessageBox.Show("Capture el nombre del archivo");
return;
}
string fileName = saveFileDialog.FileName;
ExportToExcelML excelExporter = new ExportToExcelML(this.gvDatos);
excelExporter.SheetName = "Datos";
excelExporter.SummariesExportOption = SummariesOption.ExportAll;
try {
excelExporter.RunExport(fileName);
RadMessageBox.SetThemeName(this.gvDatos.ThemeName);
if (RadMessageBox.Show("Los datos se han exportado correctamente. Desea abrir el archivo...?", this.Text,
MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)
{
Negocio.BaseWinBP.AbrirArchivoExcel(fileName);
}
} catch (System.IO.IOException ex) {
RadMessageBox.Show(this, ex.Message, "Error I/O", MessageBoxButtons.OK, RadMessageIcon.Error);
}
} catch (Exception ex) {
throw ex;
}
}
public static void RunExportToExcelML(string fileName, RadGridView radGridView)
{
ExportToExcelML excelExporter = new ExportToExcelML(radGridView);
excelExporter.SummariesExportOption = SummariesOption.ExportAll;
//set export settings
//excelExporter.ExportVisualSettings = this.radCheckBoxExportVisual.IsChecked;
//excelExporter.ExportHierarchy = this.radCheckBoxExportHierarchy.IsChecked;
excelExporter.HiddenColumnOption = HiddenOption.DoNotExport;
try
{
//this.Cursor = Cursors.WaitCursor;
excelExporter.RunExport(fileName);
RadMessageBox.SetThemeName(radGridView.ThemeName);
DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?",
"Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
try
{
System.Diagnostics.Process.Start(fileName);
}
catch (Exception ex)
{
string message = String.Format("The file cannot be opened on your system.\nError message: {0}", ex.Message);
RadMessageBox.Show(message, "Open File", MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(radGridView.ThemeName);
System.Windows.Forms.MessageBox.Show(ex.Message, "ERR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
//this.Cursor = Cursors.Default;
}
}
private void ExportExcel_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = String.Format("{0} (*{1})|*{1}", "Excel Files", ".xls");
if (sfd.ShowDialog() == DialogResult.OK)
{
//Create instance of the exporter.
ExportToExcelML exporter = new ExportToExcelML(this.radGridView1);
exporter.FileExtension = "xls";
exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
exporter.ExportVisualSettings = true;
exporter.SummariesExportOption = SummariesOption.DoNotExport;
exporter.SheetMaxRows = ExcelMaxRows._1048576;
exporter.SheetName = "Sheet";
exporter.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(exporter_ExcelCellFormatting);
exporter.ExcelTableCreated += new Telerik.WinControls.UI.Export.ExcelML.ExcelTableCreatedEventHandler(exporter_ExcelTableCreated);
exporter.RunExport(sfd.FileName);
MessageBox.Show("Export completed");
}
}
private void radButtonElement1_Click(object sender, EventArgs e)
{
saveFileDialog1.Filter = "*.xls|*.xls";
saveFileDialog1.FileName = "export";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
radGridView1.Columns[6].ExcelExportType = DisplayFormatType.Text;
radGridView1.Columns[7].ExcelExportType = DisplayFormatType.Text;
radGridView1.Columns[2].ExcelExportType = DisplayFormatType.Custom;
radGridView1.Columns[2].ExcelExportFormatString = "dd.MM.yyyy";
if (radGridView1.Columns["Выезд"] != null)
{
radGridView1.Columns["Выезд"].ExcelExportType = DisplayFormatType.Custom;
radGridView1.Columns["Выезд"].ExcelExportFormatString = "dd.MM.yyyy";
}
if (radGridView1.Columns["Смерть"] != null)
{
radGridView1.Columns["Смерть"].ExcelExportType = DisplayFormatType.Custom;
radGridView1.Columns["Смерть"].ExcelExportFormatString = "dd.MM.yyyy";
}
if (radGridView1.Columns["Дата над. обсл."] != null)
{
radGridView1.Columns["Дата над. обсл."].ExcelExportType = DisplayFormatType.Custom;
radGridView1.Columns["Дата над. обсл."].ExcelExportFormatString = "dd.MM.yyyy";
}
ExportToExcelML exporter = new ExportToExcelML(radGridView1);
exporter.PagingExportOption = PagingExportOption.AllPages;
exporter.RunExport(saveFileDialog1.FileName);
System.Diagnostics.Process.Start(saveFileDialog1.FileName);
}
}
void btnExport_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.OK == saveFileDialog1.ShowDialog())
{
if (radGridView1 == null)
{
InitializeExportGrid();
}
radGridView1.Columns.Clear();
radGridView1.Columns.Add(new GridViewTextBoxColumn("MonthCommencing", "MonthCommencing"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("OperatorLicenceNumber", "OperatorLicenceNumber"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("OperatorName", "OperatorName"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("PrivateHireLicenceNumber", "PrivateHireLicenceNumber"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("FirstName", "FirstName"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("Surname", "Surname"));
//
string Message = string.Empty;
DateTime?dtFrom = dtpFromDate.Value.ToDateorNull();
DateTime?dtTill = dtpToDate.Value.ToDateorNull();
int BookingStatusId = 0;
string MonthCommencing = string.Empty;
if (dtFrom.Value == null)
{
Message = "Required : From Date";
}
if (dtTill.Value == null)
{
if (!string.IsNullOrEmpty(Message))
{
Message = "Required : To Date";
}
else
{
Message += Environment.NewLine;// "Required : To Date";
Message += "Required : To Date";
}
}
if (!string.IsNullOrEmpty(Message))
{
ENUtils.ShowMessage(Message);
return;
}
MonthCommencing = string.Format("{0:dd/MM/yyyy}", dtFrom.Value) + "-" + string.Format("{0:dd/MM/yyyy}", dtTill.Value);
if (opAll.IsChecked)
{
BookingStatusId = 0;
}
if (opCompleted.IsChecked)
{
BookingStatusId = Enums.BOOKINGSTATUS.DISPATCHED.ToInt();
}
if (opCancelled.IsChecked)
{
BookingStatusId = Enums.BOOKINGSTATUS.CANCELLED.ToInt();
}
//
using (TaxiDataContext db = new TaxiDataContext())
{
var list = db.stp_OperatorPrivateHireDriverRecord(ddlSubCompany.SelectedValue.ToInt(), dtFrom.Value, dtTill.Value + TimeSpan.Parse("23:59:59"), BookingStatusId, MonthCommencing).ToList(); // grdLister.DataSource = list;
radGridView1.RowCount = list.Count;
for (int i = 0; i < list.Count; i++)
{
radGridView1.Rows[i].Cells["MonthCommencing"].Value = list[i].MonthCommencing;
radGridView1.Rows[i].Cells["OperatorLicenceNumber"].Value = list[i].OperatorLicenceNumber;
radGridView1.Rows[i].Cells["OperatorName"].Value = list[i].OperatorName;
radGridView1.Rows[i].Cells["PrivateHireLicenceNumber"].Value = list[i].PrivateHireLicenceNumber;
radGridView1.Rows[i].Cells["FirstName"].Value = list[i].FirstName;
radGridView1.Rows[i].Cells["Surname"].Value = list[i].Surname;
}
}
ExportToExcelML export = new ExportToExcelML(this.radGridView1);
export.ExportVisualSettings = true;
export.HiddenColumnOption = HiddenOption.ExportAsHidden;
export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting);
//
//
//radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time";
//radGridView1.Columns["From"].HeaderText = "Pick-up Address";
//radGridView1.Columns["To"].HeaderText = "Drop-off Address";
radGridView1.Columns["MonthCommencing"].HeaderText = "Month Commencing";
radGridView1.Columns["OperatorLicenceNumber"].HeaderText = "Operator Licence Number";
radGridView1.Columns["OperatorName"].HeaderText = "Operator Name";
radGridView1.Columns["PrivateHireLicenceNumber"].HeaderText = "Private Hire Licence Number";
radGridView1.Columns["FirstName"].HeaderText = "First Name";
//CompanyName
exporter = new RadGridViewExcelExporter();
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted);
worker.RunWorkerAsync(saveFileDialog1.FileName);
exporter.Progress += new ProgressHandler(exportProgress);
this.btnExport.Enabled = false;
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
private void printTheScheduleButton_Click(object sender, EventArgs e)
{
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.InitialDirectory = @"c:\";
saveDialog.Filter = "Excell File (*.xls)|*.xls";
saveDialog.FilterIndex = 2;
saveDialog.RestoreDirectory = true;
string filePath = "";
if (saveDialog.ShowDialog() == DialogResult.OK)
{
filePath = saveDialog.FileName.ToString();
ExportToExcelML exporter = new ExportToExcelML(
(documentTabStrip1.TabPanels[documentTabStrip1.SelectedIndex].Controls[0] as TimetableGridview).gridviewSchedule);
exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
exporter.ExportVisualSettings = true;
exporter.SheetName = "Разписание за " + documentTabStrip1.TabPanels[0].Text.ToString();
exporter.ExcelCellFormatting += exporter_ExcelCellFormatting;
exporter.RunExport(filePath);
}
//PrintTheScheduleForm printSchedule = new PrintTheScheduleForm(mDBManager);
//printSchedule.Show();
}
void RunExportToExcelML(string fileName, ref bool openExportFile)
{
ExportToExcelML excelExporter = new ExportToExcelML(this.radGridReport);
excelExporter.SheetName = string.Format(@"MNRP{0}{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), DateTime.Now.Millisecond);
//excelExporter.SheetMaxRows = ExcelMaxRows._1048576; //ExcelMaxRows._65536
//set exporting visual settings
excelExporter.ExportVisualSettings = true;
//if (this.radTextBoxSheet.Text != String.Empty)
//{
// excelExporter.SheetName = this.radTextBoxSheet.Text;
//}
//switch (this.radComboBoxSummaries.SelectedIndex)
//{
// case 0:
// excelExporter.SummariesExportOption = SummariesOption.ExportAll;
// break;
// case 1:
// excelExporter.SummariesExportOption = SummariesOption.ExportOnlyTop;
// break;
// case 2:
// excelExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom;
// break;
// case 3:
// excelExporter.SummariesExportOption = SummariesOption.DoNotExport;
// break;
//}
//set max sheet rows
//if (this.radRadioButton1.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
//{
// excelExporter.SheetMaxRows = ExcelMaxRows._1048576;
//}
//else if (this.radRadioButton2.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
//{
// excelExporter.SheetMaxRows = ExcelMaxRows._65536;
//}
//set exporting visual settings
//excelExporter.ExportVisualSettings = this.exportVisualSettings;
try
{
excelExporter.RunExport(fileName);
RadMessageBox.SetThemeName(this.radGridReport.ThemeName);
DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to Excel", MessageBoxButtons.OK, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
openExportFile = true;
}
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(this.radGridReport.ThemeName);
RadMessageBox.Show(this, ex.Message, "Info", MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
private void btnExport_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.OK == saveFileDialog1.ShowDialog())
{
if (radGridView1 == null)
{
InitializeExportGrid();
}
radGridView1.Columns.Clear();
radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverNo", "DriverNo"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("NetTotal", "NetTotal"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("Rent", "Rent"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("AccountBookings", "AccountBookings"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("Balance", "Balance"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("OfficeToPay", "OfficeToPay"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverToPay", "DriverToPay"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("BalanceBF", "BalanceBF"));
//radGridView1.Columns.Add(new GridViewTextBoxColumn("Total", "Total"));
//radGridView1.Columns.Add(new GridViewTextBoxColumn("Active", "Active"));
//this.radGridView1.Columns["Telephone"].ExcelExportType = Telerik.WinControls.UI.Export.DisplayFormatType.Text;
//this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom;
// radGridView1.DataSource = query;
using (TaxiDataContext db = new TaxiDataContext())
{
var list = db.stp_IncomeStatement().ToList();
// grdLister.DataSource = list;
radGridView1.RowCount = list.Count;
for (int i = 0; i < list.Count; i++)
{
radGridView1.Rows[i].Cells["DriverNo"].Value = list[i].DriverNo;
radGridView1.Rows[i].Cells["NetTotal"].Value = list[i].NetTotal;
radGridView1.Rows[i].Cells["Rent"].Value = list[i].Rent;
radGridView1.Rows[i].Cells["AccountBookings"].Value = list[i].AccountBookings;
radGridView1.Rows[i].Cells["Balance"].Value = list[i].Balance;
radGridView1.Rows[i].Cells["OfficeToPay"].Value = list[i].OfficeToPay;
radGridView1.Rows[i].Cells["DriverToPay"].Value = list[i].DriverToPay;
radGridView1.Rows[i].Cells["BalanceBF"].Value = list[i].BalanceBF;
// radGridView1.Rows[i].Cells["Telephone"].ViewInfo.;
//radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", ""));
}
}
// this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Fixed;
//this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom;
ExportToExcelML export = new ExportToExcelML(this.radGridView1);
export.ExportVisualSettings = true;
export.HiddenColumnOption = HiddenOption.ExportAsHidden;
export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting);
//
//
//radGridView1.Columns["DriverNo"].HeaderText = "Driver No";
//radGridView1.Columns["AccountBookings"].HeaderText = "Account Bookings";
//radGridView1.Columns["OfficeToPay"].HeaderText = "Office To Pay";
//radGridView1.Columns["BalanceBF"].HeaderText = "Balance B/F";
//radGridView1.Columns["DriverToPay"].HeaderText = "Driver To Pay";
radGridView1.Columns["DriverNo"].HeaderText = "Driver";
radGridView1.Columns["AccountBookings"].HeaderText = "A/C Bookings";
radGridView1.Columns["OfficeToPay"].HeaderText = "Office To Pay";
radGridView1.Columns["BalanceBF"].HeaderText = "Blnc B/F";
radGridView1.Columns["DriverToPay"].HeaderText = "Drv To Pay";
//
//CompanyName
exporter = new RadGridViewExcelExporter();
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted);
worker.RunWorkerAsync(saveFileDialog1.FileName);
exporter.Progress += new ProgressHandler(exportProgress);
this.btnExport.Enabled = false;
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
private void exportButton_Click(object sender, EventArgs e)
{
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.InitialDirectory = @"c:\";
saveDialog.Filter = "Excell File (*.xls)|*.xls";
saveDialog.FilterIndex = 2;
saveDialog.RestoreDirectory = true;
string filePath = "";
if (saveDialog.ShowDialog() == DialogResult.OK)
{
try
{
filePath = saveDialog.FileName.ToString();
ExportToExcelML exporter = new ExportToExcelML(this.gridviewSchedule);
exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
exporter.ExportVisualSettings = true;
exporter.SheetName = "Разписание за " + dropdownListClasses.SelectedItem.Text;
exporter.ExcelCellFormatting += exporter_ExcelCellFormatting;
exporter.RunExport(filePath);
}
catch { }
}
}
void Btn_ExportToExcel_Click(object sender, EventArgs e)
{
if (this.rgv_ReportDLHR.Visible == true)
{
if (rgv_ReportDLHR.RowCount != 0)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
ExportToExcelML excelExporter = null;
try
{
ExportToExcelML excelML = new ExportToExcelML(this.rgv_ReportDLHR);
excelExporter = new ExportToExcelML(this.rgv_ReportDLHR);
excelExporter.ExcelCellFormatting += excelExporter_ExcelCellFormatting;
excelExporter.ExcelTableCreated += exporter_ExcelTableCreated;
this.Cursor = Cursors.WaitCursor;
saveFileDialog.Filter = "Excel (*.xls)|*.xls";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
excelExporter.RunExport(saveFileDialog.FileName);
DialogResult dr = RadMessageBox.Show("การบันทึกไฟล์สำเร็จ คุณต้องการเปิดไฟล์หรือไม่?",
"Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (con.State == ConnectionState.Open) con.Close();
}
}
else
{
RadMessageBox.Show("ไม่มีข้อมูล");
return;
}
}
else if (this.rgv_ReportDSHR.Visible == true)
{
if (rgv_ReportDSHR.RowCount != 0)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
ExportToExcelML excelExporter = null;
try
{
ExportToExcelML excelML = new ExportToExcelML(this.rgv_ReportDSHR);
excelExporter = new ExportToExcelML(this.rgv_ReportDSHR);
excelExporter.ExcelCellFormatting += excelExporter_ExcelCellFormatting;
excelExporter.ExcelTableCreated += exporter_ExcelTableCreated;
this.Cursor = Cursors.WaitCursor;
saveFileDialog.Filter = "Excel (*.xls)|*.xls";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
excelExporter.RunExport(saveFileDialog.FileName);
DialogResult dr = RadMessageBox.Show("การบันทึกไฟล์สำเร็จ คุณต้องการเปิดไฟล์หรือไม่?",
"Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (con.State == ConnectionState.Open) con.Close();
}
}
else
{
RadMessageBox.Show("ไม่มีข้อมูล");
return;
}
}
else if (this.rgv_ReportCHDHR.Visible == true)
{
if (rgv_ReportCHDHR.RowCount != 0)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
ExportToExcelML excelExporter = null;
try
{
ExportToExcelML excelML = new ExportToExcelML(this.rgv_ReportCHDHR);
excelExporter = new ExportToExcelML(this.rgv_ReportCHDHR);
excelExporter.ExcelCellFormatting += excelExporter_ExcelCellFormatting;
excelExporter.ExcelTableCreated += exporter_ExcelTableCreated;
this.Cursor = Cursors.WaitCursor;
saveFileDialog.Filter = "Excel (*.xls)|*.xls";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
excelExporter.RunExport(saveFileDialog.FileName);
DialogResult dr = RadMessageBox.Show("การบันทึกไฟล์สำเร็จ คุณต้องการเปิดไฟล์หรือไม่?",
"Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (con.State == ConnectionState.Open) con.Close();
}
}
else
{
RadMessageBox.Show("ไม่มีข้อมูล");
return;
}
}
}
private void btnExport_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.OK == saveFileDialog1.ShowDialog())
{
if (radGridView1 == null)
{
InitializeExportGrid();
}
radGridView1.Columns.Clear();
radGridView1.Columns.Add(new GridViewTextBoxColumn("AccountName", "AccountName"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("Address", "Address"));
//this.radGridView1.Columns["Telephone"].ExcelExportType = Telerik.WinControls.UI.Export.DisplayFormatType.Text;
//this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom;
// radGridView1.DataSource = query;
var list = (from a in General.GetQueryable <Gen_Company>(null)
orderby a.CompanyName
select new
{
CompanyName = a.CompanyName,
Address = a.Address
}).ToList();
radGridView1.RowCount = list.Count;
for (int i = 0; i < list.Count; i++)
{
radGridView1.Rows[i].Cells["AccountName"].Value = list[i].CompanyName;
radGridView1.Rows[i].Cells["Address"].Value = list[i].Address;
// radGridView1.Rows[i].Cells["Telephone"].ViewInfo.;
//radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", ""));
}
// this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Fixed;
//this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom;
ExportToExcelML export = new ExportToExcelML(this.radGridView1);
export.ExportVisualSettings = true;
export.HiddenColumnOption = HiddenOption.ExportAsHidden;
export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting);
//
//
//radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time";
//radGridView1.Columns["From"].HeaderText = "Pick-up Address";
//radGridView1.Columns["To"].HeaderText = "Drop-off Address";
radGridView1.Columns["AccountName"].HeaderText = "Account Name";
//Me.RadGridView1.Columns(0).ExcelExportType = Export.DisplayFormatType.Text
//CompanyName
exporter = new RadGridViewExcelExporter();
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted);
worker.RunWorkerAsync(saveFileDialog1.FileName);
exporter.Progress += new ProgressHandler(exportProgress);
this.btnExport.Enabled = false;
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
void radButtonExport_Click(object sender, EventArgs e)
{
if (radGridData.RowCount != 0)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
ExportToExcelML excelExporter = null;
try
{
ExportToExcelML excelML = new ExportToExcelML(this.radGridData);
excelExporter = new ExportToExcelML(this.radGridData);
excelExporter.ExcelCellFormatting += excelExporter_ExcelCellFormatting;
excelExporter.ExcelTableCreated += exporter_ExcelTableCreated;
this.Cursor = Cursors.WaitCursor;
saveFileDialog.Filter = "Excel (*.xls)|*.xls";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
excelExporter.RunExport(saveFileDialog.FileName);
DialogResult dr = RadMessageBox.Show("การบันทึกไฟล์สำเร็จ คุณต้องการเปิดไฟล์หรือไม่?",
"Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog.FileName);
}
}
}
catch (Exception) { }
}
else
{
RadMessageBox.Show("ไม่มีข้อมูล");
return;
}
}
private void btnExport_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.OK == saveFileDialog1.ShowDialog())
{
if (radGridView1 == null)
{
InitializeExportGrid();
}
radGridView1.Columns.Clear();
radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverNo", "DriverNo"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverName", "Name"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("VehicleType", "Vehicle"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("Owed", "Owed"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("Paid", "Paid"));
radGridView1.Columns.Add(new GridViewTextBoxColumn("CurrentBalance", "C Balance"));
//radGridView1.Columns.Add(new GridViewTextBoxColumn("Driver", "Driver"));
//radGridView1.Columns.Add(new GridViewTextBoxColumn("Vehicle", "Vehicle"));
//radGridView1.Columns.Add(new GridViewTextBoxColumn("Price", "Price"));
using (TaxiDataContext db = new TaxiDataContext())
{
var query = db.stp_DriverCommissionPaymentSummary().ToList();
radGridView1.RowCount = query.Count;
for (int i = 0; i < query.Count; i++)
{
// radGridView1.Rows[i].Cells["PickupDate"].Value = " " + string.Format(" {0:dd/MM/yyyy HH:mm} ", query[i].PickupDate) + " ";
radGridView1.Rows[i].Cells["DriverNo"].Value = query[i].DriverNo.Replace("=", "").Trim();
radGridView1.Rows[i].Cells["DriverName"].Value = query[i].DriverName.Replace("=", "").Trim();
radGridView1.Rows[i].Cells["VehicleType"].Value = query[i].VehicleType.Replace("=", "").Trim();
//radGridView1.Rows[i].Cells["Customer"].Value = query[i].Customer.Replace("=", "").Trim();
//radGridView1.Rows[i].Cells["Telephone"].Value = string.Format(" {0:F0} ", query[i].Telephone) + "."; //" " + string.Format(" {0:dd/MM/yyyy HH:mm} ", query[i].Telephone.Replace("=", "").Trim()) + " ";
radGridView1.Rows[i].Cells["Owed"].Value = query[i].Owed;
radGridView1.Rows[i].Cells["Paid"].Value = query[i].Paid;
radGridView1.Rows[i].Cells["CurrentBalance"].Value = query[i].CurrentBalance;
// radGridView1.Rows[i].Cells["Telephone"].ViewInfo.;
//radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", ""));
}
}
ExportToExcelML export = new ExportToExcelML(this.radGridView1);
export.ExportVisualSettings = true;
export.HiddenColumnOption = HiddenOption.ExportAsHidden;
export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting);
//
radGridView1.Columns["DriverNo"].HeaderText = "Driver No";
radGridView1.Columns["DriverName"].HeaderText = "Name";
radGridView1.Columns["VehicleType"].HeaderText = "Vehicle";
//grdLister.Columns["LastStatementNo"].HeaderText = "Last Statement No";
radGridView1.Columns["CurrentBalance"].HeaderText = "C Balance";
//
//grdLister.Columns["PickupDate"].HeaderText = "Pickup Date-Time";
//radGridView1.Columns["From"].HeaderText = "Pick-up Address";
//radGridView1.Columns["To"].HeaderText = "Drop-off Address";
//radGridView1.Columns["CompanyName"].HeaderText = "Account";
//Me.RadGridView1.Columns(0).ExcelExportType = Export.DisplayFormatType.Text
//CompanyName
exporter = new RadGridViewExcelExporter();
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted);
worker.RunWorkerAsync(saveFileDialog1.FileName);
exporter.Progress += new ProgressHandler(exportProgress);
this.btnExport.Enabled = false;
}
}
catch (Exception ex)
{
}
}
void RunExportToExcelML(string fileName, ref bool openExportFile)
{
ExportToExcelML excelExporter = new ExportToExcelML(this.radGridTimeTemp);
excelExporter.SheetName = string.Format(@"MNRPSRC{0}{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), DateTime.Now.Millisecond);
excelExporter.ExportVisualSettings = true;
try
{
excelExporter.RunExport(fileName);
RadMessageBox.SetThemeName(this.radGridTimeTemp.ThemeName);
RadMessageBox.Show("The data in the grid was exported successfully.", "Export to Excel", MessageBoxButtons.OK, RadMessageIcon.Info);
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(this.radGridTimeTemp.ThemeName);
RadMessageBox.Show(this, ex.Message, "Info", MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
