public Form1()
{
InitializeComponent();
dataConnector = new DataConnector();
dataConnector.OpenConnection("all");
// Recupera os relatórios em formato Crystal Reports ( Categoria C )
ReportingDocumentDAO reportingDocumentDAO = new ReportingDocumentDAO(dataConnector.SqlServerConnection);
List <ReportingDocumentDTO> reportList = reportingDocumentDAO.GetReports("Category = 'C'");
// Recupera dados do firebird
ProdutoDAO productDAO = new ProdutoDAO(dataConnector.FirebirdConnection);
List <ProdutoDTO> productList = productDAO.GetAll();
CidadeDAO cidadeDAO = new CidadeDAO(dataConnector.FirebirdConnection);
List <CidadeDTO> cityList = cidadeDAO.GetAll();
FormaPagamentoDAO formaPagamentoDAO = new FormaPagamentoDAO(dataConnector.FirebirdConnection);
List <FormaPagamentoDTO> paymentMethodList = formaPagamentoDAO.GetAll();
dataConnector.CloseConnection();
cmbReport.Items.AddRange(reportList.ToArray());
cmbReport.SelectedIndex = 0;
cmbProduct.Items.AddRange(productList.ToArray());
cmbProduct.SelectedIndex = 0;
cmbCity.Items.AddRange(cityList.ToArray());
cmbCity.SelectedIndex = 0;
cmbPaymentMethod.Items.AddRange(paymentMethodList.ToArray());
cmbPaymentMethod.SelectedIndex = 0;
}
public Form2()
{
InitializeComponent();
dataConnector = new DataConnector();
dataConnector.OpenConnection("sqlServer");
ReportingDocumentDAO reportingDocumentDAO = new ReportingDocumentDAO(dataConnector.SqlServerConnection);
ReportingElementDAO reportingElementDAO = new ReportingElementDAO(dataConnector.SqlServerConnection);
ReportingDocumentDTO reportDoc = reportingDocumentDAO.GetReport(docCode);
Bitmap bmp = new Bitmap(reportDoc.Width, reportDoc.Height);
Graphics graphs = Graphics.FromImage(bmp);
graphs.Clear(System.Drawing.Color.White);
List <ReportingElementDTO> elementList = reportingElementDAO.GetElements(docCode, "Type=10");
foreach (ReportingElementDTO element in elementList)
{
Rectangle rect = new Rectangle(element.left, element.top, element.width, element.height);
graphs.FillRectangle(new SolidBrush(System.Drawing.Color.LightYellow), rect);
if (element.borderTop > 0)
{
graphs.DrawRectangle(new Pen(System.Drawing.Color.Black, element.borderTop), rect);
}
if (element.borderBottom > 0)
{
graphs.DrawRectangle(new Pen(System.Drawing.Color.Black, element.borderBottom), rect);
}
if (element.borderLeft > 0)
{
graphs.DrawRectangle(new Pen(System.Drawing.Color.Black, element.borderLeft), rect);
}
if (element.borderRight > 0)
{
graphs.DrawRectangle(new Pen(System.Drawing.Color.Black, element.borderRight), rect);
}
}
List <ReportingElementDTO> imageList = reportingElementDAO.GetElements(docCode, "Type=11");
foreach (ReportingElementDTO image in imageList)
{
Rectangle rect = new Rectangle(image.left, image.top, image.width, image.height);
Bitmap bitmap = new Bitmap(bitmapPath + image.caption);
graphs.DrawImage(bitmap, rect);
}
graphs.Flush();
imgReport.Image = bmp;
dataConnector.CloseConnection();
}
