public override void PopulateData()
{
try
{
using (TaxiDataContext db = new TaxiDataContext())
{
var list = db.stp_IncomeStatement().ToList();
grdLister.DataSource = list;
}
grdLister.Columns["Id"].IsVisible = false;
grdLister.Columns["DriverName"].IsVisible = false;
grdLister.Columns["DriverNo"].HeaderText = "Driver";
grdLister.Columns["NetTotal"].HeaderText = "Net Total";
grdLister.Columns["AccountBookings"].HeaderText = "Account Bookings";
grdLister.Columns["OfficeToPay"].HeaderText = "Office To Pay";
grdLister.Columns["DriverToPay"].HeaderText = "Driver To Pay";
grdLister.Columns["AccountBookings"].HeaderText = "Account Bookings";
grdLister.Columns["DriverNo"].Width = 160;
grdLister.Columns["AccountBookings"].Width = 130;
grdLister.Columns["Balance"].Width = 130;
grdLister.Columns["DriverToPay"].Width = 130;
grdLister.Columns["NetTotal"].Width = 130;
grdLister.Columns["Rent"].Width = 130;
grdLister.Columns["OfficeToPay"].Width = 130;
grdLister.Columns["BalanceBF"].HeaderText = "Balance B/F";
grdLister.Columns["BalanceBF"].Width = 130;
//grdLister.Columns["DriverNo"].Width = 120;
//Active
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
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);
}
}