public static void relClientes() { CAMADAS.BLL.Clientes bllClientes = new CAMADAS.BLL.Clientes(); List <CAMADAS.MODEL.Clientes> lstClientes = new List <CAMADAS.MODEL.Clientes>(); lstClientes = bllClientes.Select(); string pasta = Funcoes.deretorioPasta(); string arquivo = pasta + @"\ReClientes_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".html"; StreamWriter ws = new StreamWriter(arquivo); using (ws) { ws.WriteLine("<html>"); ws.WriteLine("<head>"); ws.WriteLine("<meta http-equiv='Content-Type' " + "content='text/html; charset=utf-8'/>"); ws.WriteLine("<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' integrity='sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T' crossorigin='anonymous'>"); ws.WriteLine("</head>"); ws.WriteLine("<body>"); ws.WriteLine("<h1>Relatório de Clientes</h1>"); ws.WriteLine("<hr align='left' border:'5px' />"); ws.WriteLine("<table class='table table-striped'>"); //Cabeçalho da tabela ws.WriteLine("<tr align='right'>"); ws.WriteLine("<th align='right' width='30px'>"); ws.WriteLine("ID"); ws.WriteLine("</th>"); ws.WriteLine("<th align='right' width='250px'>"); ws.WriteLine("NOME"); ws.WriteLine("</th>"); ws.WriteLine("<th align='right' width='150px'>"); ws.WriteLine("CPF"); ws.WriteLine("</th>"); ws.WriteLine("<th align='right' width='150px'>"); ws.WriteLine("SEXO"); ws.WriteLine("</th>"); ws.WriteLine("</tr>"); int cont = 0; float soma = 0; foreach (CAMADAS.MODEL.Clientes Clientes in lstClientes.OrderBy(o => o.id).ThenBy(t => t.id).ThenBy(w => w.nome)) { ws.WriteLine("<tr>"); ws.WriteLine("<td align='right' width='30px'>"); ws.WriteLine(Clientes.id); ws.WriteLine("</td>"); ws.WriteLine("<td align='right' width='250px'>"); ws.WriteLine(Clientes.nome); ws.WriteLine("</td>"); ws.WriteLine("<td align='right' width='150px'>"); ws.WriteLine(Clientes.cpf); ws.WriteLine("</td>"); ws.WriteLine("<td align='right' width='150px'>"); ws.WriteLine(Clientes.sexo); ws.WriteLine("</td>"); cont++; } ws.WriteLine(""); ws.WriteLine(""); ws.WriteLine("</table>"); ws.WriteLine("<hr align='left' border:'5px' />"); ws.WriteLine("<h2>"); ws.WriteLine("Total de Registros Impressos: " + cont.ToString()); ws.WriteLine("</br>"); ws.WriteLine("Total de clientes " + cont.ToString()); ws.WriteLine("</body>"); ws.WriteLine("</h2>"); ws.WriteLine("</html>"); } }
public static void relProduto() { CAMADAS.BLL.Carros bllCarros = new CAMADAS.BLL.Carros(); List <CAMADAS.MODEL.Carros> lstCarros = new List <CAMADAS.MODEL.Carros>(); lstCarros = bllCarros.Select(); string pasta = Funcoes.deretorioPasta(); string arquivo = pasta + @"\ReCarros_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".html"; StreamWriter sw = new StreamWriter(arquivo); using (sw) { sw.WriteLine("<html>"); sw.WriteLine("<head>"); sw.WriteLine("<meta http-equiv='Content-Type' " + "content='text/html; charset=utf-8'/>"); sw.WriteLine("<link rel='stylesheet' href='https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css' integrity='sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T' crossorigin='anonymous'>"); sw.WriteLine("</head>"); sw.WriteLine("<body>"); sw.WriteLine("<h1>Relatório de Carros</h1>"); sw.WriteLine("<hr align='left' border:'5px' />"); sw.WriteLine("<table class='table table-striped'>"); //Cabeçalho da tabela sw.WriteLine("<tr align='right'>"); sw.WriteLine("<th align='right' width='30px'>"); sw.WriteLine("ID"); sw.WriteLine("</th>"); sw.WriteLine("<th align='right' width='250px'>"); sw.WriteLine("MODELO"); sw.WriteLine("</th>"); sw.WriteLine("<th align='right' width='150px'>"); sw.WriteLine("MARCA"); sw.WriteLine("</th>"); sw.WriteLine("<th align='right' width='150px'>"); sw.WriteLine("CHASSI"); sw.WriteLine("</th>"); sw.WriteLine("<th align='right' width='150px'>"); sw.WriteLine("PLACA"); sw.WriteLine("</th>"); sw.WriteLine("</tr>"); int cont = 0; float soma = 0; foreach (CAMADAS.MODEL.Carros Carros in lstCarros.OrderBy(o => o.id).ThenBy(t => t.modelo).ThenBy(w => w.marca)) { sw.WriteLine("<tr>"); sw.WriteLine("<td align='right' width='30px'>"); sw.WriteLine(Carros.id); sw.WriteLine("</td>"); sw.WriteLine("<td align='right' width='250px'>"); sw.WriteLine(Carros.modelo); sw.WriteLine("</td>"); sw.WriteLine("<td align='right' width='150px'>"); sw.WriteLine(Carros.marca); sw.WriteLine("</td>"); sw.WriteLine("<td align='right' width='150px'>"); sw.WriteLine(Carros.chassi); sw.WriteLine("</td>"); sw.WriteLine("<td align='right' width='150px'>"); sw.WriteLine(Carros.placa); sw.WriteLine("</td>"); cont++; } sw.WriteLine(""); sw.WriteLine(""); sw.WriteLine("</table>"); sw.WriteLine("<hr align='left' border:'5px' />"); sw.WriteLine("<h2>"); sw.WriteLine("Total de Registros Impressos: " + cont.ToString()); sw.WriteLine("</br>"); sw.WriteLine("Total de carros alugados" + cont.ToString()); sw.WriteLine("</body>"); sw.WriteLine("</h2>"); sw.WriteLine("</html>"); } /* * System.Diagnostics.Process.Start(arquivo); * * var htmlToPdf = new NReco.PdfGenerator.HtmlToPdfConverter(); * htmlToPdf.CustomWkHtmlArgs = "--dpi 300"; * htmlToPdf.GeneratePdfFromFile(arquivo, null, arquivoPDF); */ }