//FIM CUPONS //RELATORIOS VENDAS public static void relVendas() { CAMADAS.BLL.Vendas bllVendas = new CAMADAS.BLL.Vendas(); List <CAMADAS.MODEL.Vendas> lstVendas = new List <CAMADAS.MODEL.Vendas>(); lstVendas = bllVendas.SelectWithInnerJoin(); string pasta = Funcoes.deretorioPasta(); string arquivo = pasta + @"\RelVendas_" + 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("<table class='table table-hover'>"); //Cabeçalho da tabela sw.WriteLine("<thead class='thead-dark'>"); sw.WriteLine("<tr>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine("ID VENDA"); sw.WriteLine("</th>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine("DESCONTO"); sw.WriteLine("</th>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine("VALOR FINAL"); sw.WriteLine("</th>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine("DATA"); sw.WriteLine("</th>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine("CLIENTE"); sw.WriteLine("</th>"); sw.WriteLine("</th>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine("VENDEDOR"); sw.WriteLine("</th>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine("TOTAL ARRECADADO"); sw.WriteLine("</th>"); sw.WriteLine("</tr>"); sw.WriteLine("</thead>"); int cont = 0; float soma = 0; foreach (CAMADAS.MODEL.Vendas vendas in lstVendas) { sw.WriteLine("<tbody>"); sw.WriteLine("<tr>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine(vendas.id_venda); sw.WriteLine("</td>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine(vendas.desconto); sw.WriteLine("</td>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine(string.Format("{0:C2}", vendas.valor_final)); sw.WriteLine("</td>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine(vendas.data); sw.WriteLine("</td>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine(vendas.desc_cliente); sw.WriteLine("</td>"); sw.WriteLine("<th scope='col'>"); sw.WriteLine(vendas.desc_vendedor); sw.WriteLine("</td>"); soma = soma + vendas.valor_final; cont++; sw.WriteLine("<th scope='col'>"); sw.WriteLine("VENDA " + cont + ": " + soma); sw.WriteLine("</td>"); sw.WriteLine("</tr>"); } sw.WriteLine("</tbody>"); sw.WriteLine("</table>"); sw.WriteLine("</body>"); sw.WriteLine("</html>"); } System.Diagnostics.Process.Start(arquivo); }