Ejemplo n.º 1
0
        private void nueva_tarea()
        {
            Models.Reports.nuevo_db nuevo = new Models.Reports.nuevo_db();
            using (nuevo)
            {
                //nuevo.ejecuta(" ALTER TABLE `tbafolios` ADD `ticket` INT NOT NULL AFTER `factura`;");
                //nuevo.ejecuta("ALTER TABLE `tbatickets` ADD `folio` INT NOT NULL AFTER `id`;");
                int            ultimo  = 0;
                Models.Tickets tickets = new Models.Tickets();
                using (tickets)
                {
                    List <Models.Tickets> tick = tickets.getTickets();
                    foreach (Models.Tickets it in tick)
                    {
                        nuevo.ejecuta("update tbatickets set folio='" + it.Id + "' where id='" + it.Id + "'");
                        ultimo = it.Id;
                    }
                }
                nuevo.ejecuta("update tbafolios set ticket='" + (ultimo + 1) + "'");
            }


            System.IO.File.Delete(@"nueva.txt");
        }