public XtraReport PrintInvoice(uint invoiceID)
{
using (var db = DB.GetContext())
{
DataSet data = InvoiceRepository.PrintInvoice(db, invoiceID);
//data.WriteXmlSchema("D:\\schema.xml");
return(ReportBinder.BindReport(12, data));
}
}
public XtraReport RenderInvoice(uint invoiceID)
{
using (var db = DB.GetContext())
{
DataSet data = InvoiceRepository.PrintInvoice(db, invoiceID);
//data.WriteXmlSchema("D:\\schema.xml");
var report = ReportBinder.BindReport(12, data);
report.Tag = data.Tables[0].Rows[0]["InvoiceNumber"].ToString();
return(report);
}
}
public RelGerencialReport(IList<BratDTO> brats)
{
InitializeComponent();
var binder = new ReportBinder<BratDTO>(this);
this.DataSource = brats;
binder.BindText(lblNumBrat, c => c.NumBrat);
binder.BindDate(lblData, c => c.Data);
binder.BindText(lblHora, c => c.Hora);
binder.BindText(lblCondTempo, c => c.CondTempo);
binder.BindText(lblTipoSinalizacao, c => c.TipoSinalizacao);
binder.BindText(lblNumVitimas, c => c.NumVitimas);
binder.BindText(lblNumVeiculos, c => c.NumVeiculos);
binder.BindText(lblNumTestemunhas, c => c.NumTestemunha);
lblTotalAcidentes.Text = brats.Count.ToString();
lblDataExecucao.Text = string.Format("{0} - {1}:{2}:{3}", DateTime.Now.ToShortDateString(), DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
}
public XtraReport RenderConfirmation(uint invoiceID)
{
using (var db = DB.GetContext())
{
var invoice = InvoiceRepository.GetInvoice(db, invoiceID);
uint[] companies = new uint[1] {
invoice.CompanyID
};
uint[] locations = new uint[1] {
invoice.LocationID
};
var report = ReportRepository.GenerateReport(db, 3, companies, locations, fromDate: invoice.InvoicePeriodFrom, toDate: invoice.InvoicePeriodTo);
var rep = ReportBinder.BindReport(report);
rep.Tag = invoice.InvoiceNumber;
return(rep);
}
}
private void btnGenerate_Click(object sender, EventArgs e)
{
if (ReportID.EditValue == null || ReportID.EditValue.ToString() == "0")
{
Mess.Info("Please select a report!");
ReportID.ShowPopup();
return;
}
using (var db = DB.GetContext())
{
uint reportID = Convert.ToUInt32(ReportID.EditValue);
uint[] companies = CompanyID.GetCheckedValues();
uint[] locations = LocationID.GetCheckedValues();
uint[] drivers = DriverID.GetCheckedValues();
DateTime fromDt = FromDate.DateTime;
DateTime toDt = ToDate.DateTime;
var report = ReportRepository.GenerateReport(db, reportID, companies, locations, drivers, fromDt, toDt);
//report.DataSource.WriteXmlSchema("D:\\schema.xml");
ReportBinder.ShowReport(report);
}
}
