private void relatorioFonecedores_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { { int eixoX = 105; string expirado; // titulo e.Graphics.DrawString("Relatório mensal de fornecedores", new Font("Arial", 12, FontStyle.Bold), new SolidBrush(Color.Black), new Point(20, 30)); //headers e.Graphics.DrawString("Nome", new Font("Arial", 11, FontStyle.Bold), new SolidBrush(Color.Black), new Point(20, 85)); e.Graphics.DrawString("RG", new Font("Arial", 11, FontStyle.Bold), new SolidBrush(Color.Black), new Point(320, 85)); e.Graphics.DrawString("Entrada", new Font("Arial", 11, FontStyle.Bold), new SolidBrush(Color.Black), new Point(400, 85)); e.Graphics.DrawString("Saída", new Font("Arial", 11, FontStyle.Bold), new SolidBrush(Color.Black), new Point(550, 85)); e.Graphics.DrawString("Empresa", new Font("Arial", 11, FontStyle.Bold), new SolidBrush(Color.Black), new Point(700, 85)); IQueryable<Fornecedor> fornecedores = null; string saida = ""; try { var fDAO = new FornecedorDAO(); fornecedores = fDAO.get(f => f.entrada.Year.ToString() == cmbRelAno.SelectedItem.ToString() && f.entrada.Month.ToString() == cmbRelMes.SelectedItem.ToString()); } catch (Exception) { mensagem("Erro ao gerar relatório"); } foreach (Fornecedor f in fornecedores) { if (f.saida == null) { saida = ""; } else { saida = f.saida.Value.ToString("dd/mm/yyy hh:mm:ss"); } e.Graphics.DrawString(f.nome, new Font("Arial", 11, FontStyle.Regular), new SolidBrush(Color.Black), new Point(20, eixoX)); e.Graphics.DrawString(f.rg, new Font("Arial", 11, FontStyle.Regular), new SolidBrush(Color.Black), new Point(320, eixoX)); e.Graphics.DrawString(f.entrada.ToString("dd/mm/yyy hh:mm:ss"), new Font("Arial", 11, FontStyle.Regular), new SolidBrush(Color.Black), new Point(400, eixoX)); e.Graphics.DrawString(saida, new Font("Arial", 11, FontStyle.Regular), new SolidBrush(Color.Black), new Point(550, eixoX)); e.Graphics.DrawString(f.empresa, new Font("Arial", 11, FontStyle.Regular), new SolidBrush(Color.Black), new Point(700, eixoX)); eixoX += 15; } } }
private void preencherGridVisitanteFornecedores() { dgvFornecedores.Rows.Clear(); dgvVisitante.Rows.Clear(); FornecedorDAO fDao = new FornecedorDAO(); VisitanteDAO vDao = new VisitanteDAO(); var fornecedores = fDao.get(f => f.entrada.Day == DateTime.Now.Day && f.entrada.Month == DateTime.Now.Month && f.entrada.Year == DateTime.Now.Year && f.saida == null); var visitantes = vDao.get(v => v.entrada.Day == DateTime.Now.Day && v.entrada.Month == DateTime.Now.Month && v.entrada.Year == DateTime.Now.Year && v.saida == null); foreach (Fornecedor item in fornecedores) { dgvFornecedores.Rows.Add(item.idFornecedor, item.nome, item.empresa, item.entrada); } foreach (Visitante item in visitantes) { dgvVisitante.Rows.Add(item.idVisitante, item.nome, item.empresa, item.entrada); } }