Пример #1
0
        public static void relOrdem()
        {
            Camadas.BLL.Ordens          bllOrdem  = new Camadas.BLL.Ordens();
            List <Camadas.MODEL.Ordens> lstOrdens = new List <Camadas.MODEL.Ordens>();

            lstOrdens = bllOrdem.Select();

            string pasta      = Funcoes.diretorioPasta();
            string arquivo    = pasta + @"\RelOrdens_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".html";
            string arquivoPDF = pasta + @"\RelOrdens_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".pdf";

            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 ORDEM DE SERVIÇO</h1>");
                sw.WriteLine("<h6> <i>");
                sw.WriteLine("Gerado em " + DateTime.Now.ToString());
                sw.WriteLine("</i></h6>");
                sw.WriteLine("</br>");
                sw.WriteLine("<hr align='left' border:'5px' />");
                sw.WriteLine("<table class='table table-striped'>");
                sw.WriteLine("<tr align='right'>");
                sw.WriteLine("<th align='center' width='50px'>");
                sw.WriteLine("ORDEM Nº");
                sw.WriteLine("</th>");
                sw.WriteLine("<th align='center' width='100px'>");
                sw.WriteLine("CLIENTE");
                sw.WriteLine("</th>");
                sw.WriteLine("<th align='center' width='100px'>");
                sw.WriteLine("EQUIPAMENTO");
                sw.WriteLine("</th>");
                sw.WriteLine("<th align='center' width='100px'>");
                sw.WriteLine("DEFEITO");
                sw.WriteLine("</th>");
                sw.WriteLine("<th  align='center' width='100px'>");
                sw.WriteLine("VALOR");
                sw.WriteLine("</th>");
                sw.WriteLine("<th align='center' width='50px'>");
                sw.WriteLine("SITUAÇÃO");
                sw.WriteLine("</th>");
                sw.WriteLine("</tr>");

                int   cont = 0;
                float soma = 0;
                foreach (Camadas.MODEL.Ordens ordem in lstOrdens.OrderBy(o => o.idOrd))
                {
                    sw.WriteLine("<tr>");
                    sw.WriteLine("<td align='center' width='50px'>");
                    sw.WriteLine(ordem.idOrd);
                    sw.WriteLine("</td>");
                    sw.WriteLine("<td align='center' width='100px'>");
                    sw.WriteLine(ordem.nomeCli);
                    sw.WriteLine("</td>");
                    sw.WriteLine("<td align='center' width='100px'>");
                    sw.WriteLine(ordem.equipamento);
                    sw.WriteLine("</td>");
                    sw.WriteLine("<td align='center' width='100px'>");
                    sw.WriteLine(ordem.defeito);
                    sw.WriteLine("</td>");
                    sw.WriteLine("<td  align='right' width='100px'>");
                    sw.WriteLine(string.Format("{0:C2}", ordem.valor));
                    sw.WriteLine("</td>");
                    sw.WriteLine("<td align='center' width='50px'>");
                    sw.WriteLine(ordem.situacao);
                    sw.WriteLine("</td>");
                    sw.WriteLine("</tr>");
                    soma = soma + ordem.valor;
                    cont++;
                }

                sw.WriteLine("");
                sw.WriteLine("");
                sw.WriteLine("</table>");
                sw.WriteLine("<hr align='left' border:'5px' />");
                sw.WriteLine("<h5>");
                sw.WriteLine("Total de Registros: " + cont.ToString());
                sw.WriteLine("</br>");
                sw.WriteLine("Valor Total dos Registros: " + string.Format("{0:C2}", soma));
                sw.WriteLine("</h5>");
                sw.WriteLine("</body>");

                sw.WriteLine("</html>");
            }
            System.Diagnostics.Process.Start(arquivo);

            var htmlToPdf = new NReco.PdfGenerator.HtmlToPdfConverter();

            htmlToPdf.CustomWkHtmlArgs = "--dpi 300";
            htmlToPdf.GeneratePdfFromFile(arquivo, null, arquivoPDF);
        }
        public static void relCliente()
        {
            Camadas.DAL.Clientes          bllCliente  = new Camadas.DAL.Clientes();
            List <Camadas.MODEL.Clientes> lstClientes = new List <Camadas.MODEL.Clientes>();

            lstClientes = bllCliente.Select();

            string pasta      = Funcoes.diretorioPasta();
            string arquivo    = pasta + @"\RelClientes_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".html";
            string arquivoPDF = pasta + @"\RelClientes_" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + DateTime.Now.ToLongTimeString().Replace(":", "_") + ".pdf";

            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 CLIENTES</h1>");
                sw.WriteLine("<h6> <i>");
                sw.WriteLine("Gerado em " + DateTime.Now.ToString());
                sw.WriteLine("</i></h6>");
                sw.WriteLine("</br>");
                sw.WriteLine("<hr align='left' border:'5px' />");
                sw.WriteLine("<table class='table table-striped'>");
                sw.WriteLine("<tr align='center'>");
                sw.WriteLine("<th align='center' width='30px'>");
                sw.WriteLine("ID");
                sw.WriteLine("</th>");
                sw.WriteLine("<th align='left' width='150px'>");
                sw.WriteLine("NOME");
                sw.WriteLine("</th>");
                sw.WriteLine("<th align='left' width='150px'>");
                sw.WriteLine("ENDERECO");
                sw.WriteLine("</th>");
                sw.WriteLine("<th align='center' width='150px'>");
                sw.WriteLine("FONE");
                sw.WriteLine("</th>");
                sw.WriteLine("</tr>");

                int cont = 0;
                foreach (Camadas.MODEL.Clientes cliente in lstClientes.OrderBy(o => o.nome))
                {
                    sw.WriteLine("<tr>");
                    sw.WriteLine("<td align='center' width='30px'>");
                    sw.WriteLine(cliente.idCli);
                    sw.WriteLine("</td>");
                    sw.WriteLine("<td align='left' width='150px'>");
                    sw.WriteLine(cliente.nome);
                    sw.WriteLine("</td>");
                    sw.WriteLine("<td align='left' width='150px'>");
                    sw.WriteLine(cliente.endereco);
                    sw.WriteLine("</td>");
                    sw.WriteLine("<td  align='center' width='150px'>");
                    sw.WriteLine(cliente.fone);
                    sw.WriteLine("</td>");
                    sw.WriteLine("</tr>");
                    cont++;
                }

                sw.WriteLine("");
                sw.WriteLine("");
                sw.WriteLine("</table>");
                sw.WriteLine("<hr align='left' border:'5px' />");
                sw.WriteLine("<h5>");
                sw.WriteLine("Total de Clientes: " + cont.ToString());
                sw.WriteLine("</br>");
                sw.WriteLine("</h5>");
                sw.WriteLine("</body>");

                sw.WriteLine("</html>");
            }
            System.Diagnostics.Process.Start(arquivo);

            var htmlToPdf = new NReco.PdfGenerator.HtmlToPdfConverter();

            htmlToPdf.CustomWkHtmlArgs = "--dpi 300";
            htmlToPdf.GeneratePdfFromFile(arquivo, null, arquivoPDF);
        }