示例#1
0
      public List <GestionArticulos> InformeGestionArticulosFiltroArticuloTiempo(string articulo, DateTime desde, DateTime hasta)
      {
          List <GestionArticulos> gaList = new List <GestionArticulos>();

          try
          {
              OpenConnection();
              NpgsqlCommand cmdSel = new NpgsqlCommand("select * from suma_stock " +
                                                       "inner join articulos on id = id_articulo " +
                                                       "where fecha_suma BETWEEN @desde and @hasta and nombre LIKE '%' ||  @filtro || '%' " +
                                                       "UNION " +
                                                       "select * from perdida_stock " +
                                                       " inner join articulos on id = id_articulo " +
                                                       " where fecha_perdida BETWEEN @desde and @hasta and nombre LIKE '%' ||  @filtro || '%' order by fecha_suma DESC ", npgsqlConn);

              cmdSel.Parameters.Add("@filtro", NpgsqlTypes.NpgsqlDbType.Varchar, 50).Value = articulo;
              cmdSel.Parameters.Add("@desde", NpgsqlTypes.NpgsqlDbType.Date).Value         = desde;
              cmdSel.Parameters.Add("@hasta", NpgsqlTypes.NpgsqlDbType.Date).Value         = hasta;
              NpgsqlDataReader drArt = cmdSel.ExecuteReader();

              while (drArt.Read())
              {
                  GestionArticulos ga = new GestionArticulos();
                  ga.ID               = (string)drArt["id_articulo"];
                  ga.Nombre           = (string)drArt["nombre"];
                  ga.Fecha_movimiento = (DateTime)drArt["fecha_suma"];
                  ga.Descripcion      = (string)drArt["razon_de_suma"] + " (" + (int)drArt["cantidad"] + " " + (string)drArt["unidad"] + ")";
                  ga.Signo            = Convert.ToChar((string)drArt["signo"]);
                  gaList.Add(ga);
              }
          }
          finally { CloseConnection(); }
          return(gaList);
      }
示例#2
0
      public List <GestionArticulos> InformeGestionArticulos()
      {
          List <GestionArticulos> gaList = new List <GestionArticulos>();

          try
          {
              OpenConnection();
              NpgsqlCommand cmdSel = new NpgsqlCommand("select * from suma_stock " +
                                                       "inner join articulos on id = id_articulo where EXTRACT(YEAR FROM  fecha_suma) = EXTRACT(YEAR FROM current_date) " +
                                                       "UNION " +
                                                       " select * from perdida_stock " +
                                                       "inner join articulos on id = id_articulo where EXTRACT(YEAR FROM  fecha_perdida) = EXTRACT(YEAR FROM current_date) order by fecha_suma DESC ", npgsqlConn);

              NpgsqlDataReader drArt = cmdSel.ExecuteReader();

              while (drArt.Read())
              {
                  GestionArticulos ga = new GestionArticulos();
                  ga.ID               = (string)drArt["id_articulo"];
                  ga.Nombre           = (string)drArt["nombre"];
                  ga.Fecha_movimiento = (DateTime)drArt["fecha_suma"];
                  ga.Descripcion      = (string)drArt["razon_de_suma"] + " (" + (int)drArt["cantidad"] + " " + (string)drArt["unidad"] + ")";
                  ga.Signo            = Convert.ToChar((string)drArt["signo"]);
                  gaList.Add(ga);
              }
          }
          finally { CloseConnection(); }
          return(gaList);
      }
示例#3
0
        private void _ControlBotones(string obj)
        {
            Visible1 = Visibility.Visible;
            Visible2 = Visibility.Hidden;
            RaisePropertyChanged("Visible1");
            RaisePropertyChanged("Visible2");
            switch (obj)
            {
            case "btnUsuarios":
                VistaContenida = new GestionUsuarios();
                RaisePropertyChanged("VistaContenida");
                break;

            case "btnClientes":
                VistaContenida = new GestionClientes();
                RaisePropertyChanged("VistaContenida");
                break;

            case "btnMascotas":
                VistaContenida = new GestionMascotas();
                RaisePropertyChanged("VistaContenida");
                break;

            case "btnProveedores":
                VistaContenida = new GestionProveedores();
                RaisePropertyChanged("VistaContenida");
                break;

            case "btnArticulos":
                VistaContenida = new GestionArticulos();
                RaisePropertyChanged("Vistacontenida");
                break;

            case "btnServicios":
                VistaContenida = new GestionServicios();
                RaisePropertyChanged("Vistacontenida");
                break;

            case "btnPedirCita":
                VistaContenida = new PedirCita();
                RaisePropertyChanged("Vistacontenida");
                break;

            case "btnVerCita":
                VistaContenida = new VerCita();
                RaisePropertyChanged("Vistacontenida");
                break;

            case "btmCobrar":
                VistaContenida = new Cobrar();
                RaisePropertyChanged("Vistacontenida");
                break;

            default:
                Console.WriteLine("boton no implementado, date caña julian");
                break;
            }
        }