public static void relFretes()
{
CAMADAS.BLL.Frete bllFrete = new CAMADAS.BLL.Frete();
List <CAMADAS.MODEL.Frete> lstFrete = new List <CAMADAS.MODEL.Frete>();
lstFrete = bllFrete.Select();
string folder = Funcoes.Pasta();
string arquivo = folder + @"\RelFrete_" + 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 FRETES<h1>");
sw.WriteLine("<hr / >");
sw.WriteLine("<table>");
sw.WriteLine("<table class='table table-striped'>");
sw.WriteLine("<tr>");
sw.WriteLine("<th align='rignt'>");
sw.WriteLine("ID");
sw.WriteLine("</th>");
sw.WriteLine("<th align='rignt'>");
sw.WriteLine("PRODUTO");
sw.WriteLine("</th>");
sw.WriteLine("<th align='rignt'>");
sw.WriteLine("LOCAL DE PARTIDA");
sw.WriteLine("</th>");
sw.WriteLine("<th align='rignt'>");
sw.WriteLine("LOCAL DE ENTREGA");
sw.WriteLine("</th>");
sw.WriteLine("<th align='rignt'>");
sw.WriteLine("VALOR");
sw.WriteLine("</th>"); sw.WriteLine("<th align='rignt'>");
sw.WriteLine("TRANSPORTADORA");
sw.WriteLine("</th>"); sw.WriteLine("<th align='rignt'>");
sw.WriteLine("MOTORISTA");
sw.WriteLine("</th>");
sw.WriteLine("</tr>");
float total = 0;
foreach (CAMADAS.MODEL.Frete frete in lstFrete)
{
sw.WriteLine("<tr>");
sw.WriteLine("<td align='rignt' width ='40px'>");
sw.WriteLine(frete.id);
sw.WriteLine("</td>");
sw.WriteLine("<td align='rignt' width ='100px'>");
sw.WriteLine(frete.produto);
sw.WriteLine("</td>");
sw.WriteLine("<td align='rignt' width ='80px'>");
sw.WriteLine(frete.localPartida);
sw.WriteLine("</td>");
sw.WriteLine("<td align='rignt' width ='80px'>");
sw.WriteLine(frete.localEntrega);
sw.WriteLine("</td>");
sw.WriteLine("<td align='rignt' width ='50px'>");
sw.WriteLine(string.Format("{0:C2}", frete.valor));
sw.WriteLine("</td>");
sw.WriteLine("<td align='rignt' width ='50px'>");
sw.WriteLine(frete.nomeTransportadora);
sw.WriteLine("</td>");
sw.WriteLine("<td align='rignt' width ='100px'>");
sw.WriteLine(frete.nomeMotorista);
sw.WriteLine("</td>");
sw.WriteLine("</tr>");
total += frete.valor;
}
sw.WriteLine("</table>");
sw.WriteLine("Total de Fretes R$:" + string.Format("{0:#.#,00}", total + "</h3>"));
sw.WriteLine("<hr />");
sw.WriteLine("</body>");
sw.WriteLine("</html>");
}
System.Diagnostics.Process.Start(arquivo);
}
public static void relCombustivel()
{
CAMADAS.BLL.Combustivel bllCombustivel = new CAMADAS.BLL.Combustivel();
List <CAMADAS.MODEL.Combustivel> lstcombustivel = new List <CAMADAS.MODEL.Combustivel>();
lstcombustivel = bllCombustivel.Select();
string folder = Funcoes.Pasta();
string arquivo = folder + @"\RelCombustivel_" + 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 ENTRADAS E SAIDAS DE COMBUSTIVEL<h1>");
sw.WriteLine("<hr / >");
sw.WriteLine("<table>");
sw.WriteLine("<table class='table table-striped'>");
sw.WriteLine("<tr>");
sw.WriteLine("<th align='rignt'>");
sw.WriteLine("ID");
sw.WriteLine("</th>");
sw.WriteLine("<th align='rignt'>");
sw.WriteLine("ENTRA/SAÍDA");
sw.WriteLine("</th>");
sw.WriteLine("<th align='rignt'>");
sw.WriteLine("PLACA");
sw.WriteLine("</th>");
sw.WriteLine("<th align='rignt'>");
sw.WriteLine("NOME MOTORISTA");
sw.WriteLine("</th>");
sw.WriteLine("</tr>");
int entrada = 0;
int saida = 0;
foreach (CAMADAS.MODEL.Combustivel combustivel in lstcombustivel)
{
sw.WriteLine("<tr>");
sw.WriteLine("<td align='rignt' width ='15px'>");
sw.WriteLine(combustivel.id);
sw.WriteLine("</td>");
sw.WriteLine("<td align='rignt' width ='60px'>");
sw.WriteLine(combustivel.estoque);
sw.WriteLine("</td>");
sw.WriteLine("<td align='rignt' width ='60px'>");
sw.WriteLine(combustivel.placaCaminhao);
sw.WriteLine("</td>");
sw.WriteLine("<td align='rignt' width ='200px'>");
sw.WriteLine(combustivel.nomeMotorista);
sw.WriteLine("</td>");
sw.WriteLine("</tr>");
if (combustivel.estoque > 0)
{
entrada += combustivel.estoque;
}
else
{
saida -= combustivel.estoque;
}
}
sw.WriteLine("</table>");
sw.WriteLine("<h3>Total de Entradas de Combustivel: " + entrada.ToString() + "<br>");
sw.WriteLine("Total de saídas de Combustivel: " + saida.ToString() + "</h3>");
sw.WriteLine("<hr />");
sw.WriteLine("</body>");
sw.WriteLine("</html>");
}
System.Diagnostics.Process.Start(arquivo);
}