예제 #1
0
        public static ENResultOperation Listar_Filtro(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM SERIE_FACTURACION WHERE SERIE_NUMERO = @SERIE ");

            CMD.Parameters.AddWithValue("@SERIE", Texto_Buscar);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #2
0
        public static ENResultOperation Listar(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM PAIS WHERE PAIS_ESTADO = 'Activo' AND PAIS_NOMBRE LIKE '" +
                                            Texto_Buscar + "%'");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #3
0
        public static ENResultOperation Listar(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM TIPO_PRODUCTO WHERE TIPO_PROD_ESTADO = 'Activo' AND TIPO_PROD_NOMBRE LIKE '" +
                                            Texto_Buscar + "%'  ORDER BY TIPO_PROD_NOMBRE");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #4
0
        public static ENResultOperation ListarTodos(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM TIPO_PRODUCTO WHERE TIPO_PROD_NOMBRE LIKE '" +
                                            Texto_Buscar + "%'");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #5
0
        public static ENResultOperation Listar_Filtro(string Texto_Buscar, Int32 Transportista_Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM  VW_TRANSPORTISTA_CONTACTO WHERE TRAN_IDE = " +
                                            Transportista_Ide.ToString() + " AND TRAN_CONT_PATERNO LIKE '" + Texto_Buscar + "%' ORDER BY TRAN_CONT_PATERNO");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #6
0
        public static ENResultOperation Listar_PuntoReparto(Int32 Reco_Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT DISTINCT RECO_DESTINATARIO,RECO_DIRECCION,LOCA_IDE,LOCA_NOMBRE,PAIS_NOMBRE FROM V_RECOJO_DETALLE WHERE RECO_IDE = @IDE");

            CMD.Parameters.AddWithValue("@IDE", Reco_Ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
        public static ENResultOperation Buscar_Registro(Int32 Reco_Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM V_MANTENIMIENTO_CORRECTIVO WHERE Mant_Ide = @IDE");

            CMD.Parameters.AddWithValue("@IDE", Reco_Ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #8
0
        public static ENResultOperation Listar(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM  V_MAESTRO_PERSONAL WHERE PERS_APELLIDO_PATERNO LIKE '%' + @TEXTO + '%' ORDER BY PERS_APELLIDO_PATERNO");

            CMD.Parameters.AddWithValue("@TEXTO", Texto_Buscar);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #9
0
        public static ENResultOperation Listar(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM COMBUSTIBLE_IMPORTE  WHERE PROV_IDE LIKE '" +
                                            Texto_Buscar + "%'");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #10
0
        public static ENResultOperation Listar(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM SERIE_ORDEN_RECOJO WHERE SERIE_NUMERO LIKE '" +
                                            Texto_Buscar + "%'");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #11
0
        public static ENResultOperation ListarTodos(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM MARCA_VEHICULO WHERE MARCA_VEHI_NOMBRE LIKE '" +
                                            Texto_Buscar + "%'");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
        public static ENResultOperation Obtener_Actividades_Grupo(Int32 Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM V_MANTENIMIENTO_GRUPO_ACTIVIDADES WHERE Mant_Grupo_Ide = @IDE ORDER BY MANT_GRUPO_IDE,MANT_ACTIVIDAD_CODIGO");

            CMD.Parameters.AddWithValue("@IDE", Ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #13
0
        public static ENResultOperation Buscar_Id(Int32 Fact_ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM V_FACTURA_CARGA_CABECERA WHERE FACT_IDE = @IDE");

            CMD.Parameters.AddWithValue("@IDE", Fact_ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #14
0
        public static ENResultOperation Listar(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM TRANSPORTISTA_VEHICULO WHERE TRAN_VEHI_PLACA LIKE '" +
                                            Texto_Buscar + "%'");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #15
0
        public static ENResultOperation ListarTodos(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM UNIDAD_MEDIDA WHERE UNID_MEDI_NOMBRE LIKE '" +
                                            Texto_Buscar + "%'");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #16
0
        public static ENResultOperation Listar(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT TOP 50 * FROM FACTURA_CARGA_CABECERA WHERE FACT_FACTURA_NUMERO LIKE '" +
                                            Texto_Buscar + "%'  ORDER BY FACT_IDE DESC");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #17
0
        public static ENResultOperation ListarTodos(string Texto_Buscar)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM CONCEPTO_FACTURA WHERE MERCA_NOMBRE LIKE '%" +
                                            Texto_Buscar + "%'");

            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #18
0
        public static ENResultOperation Buscar_Registro(Int32 nCons_Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM V_CONSUMO_LUBRICANTE  WHERE CONS_IDE = @IDE ");

            CMD.Parameters.AddWithValue("@IDE", nCons_Ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
        public static ENResultOperation Listar(Int32 Reco_ide)
        {
            string CmdSql = "SELECT RECO_IDE,RECO_IDE_DETALLE,RECO_NUMERO_APOYO,RECO_FECHA_EMISION,TRAN_IDE," +
                            "(SELECT TRAN_RAZON_SOCIAL FROM TRANSPORTISTA WHERE TRAN_IDE = RECOJO_APOYO_CABECERA.TRAN_IDE) AS TRAN_NOMBRE," +
                            "TRAN_CHOF_IDE,(SELECT TRAN_CHOF_NOMBRE FROM TRANSPORTISTA_CHOFER WHERE TRAN_IDE = RECOJO_APOYO_CABECERA.TRAN_IDE AND " +
                            "TRAN_CHOF_IDE = RECOJO_APOYO_CABECERA.TRAN_CHOF_IDE) AS CHOF_NOMBRE , " +
                            "TRAN_VEHI_IDE,(SELECT TRAN_VEHI_PLACA  FROM TRANSPORTISTA_VEHICULO WHERE TRAN_IDE = RECOJO_APOYO_CABECERA.TRAN_IDE AND " +
                            "TRAN_VEHI_IDE = RECOJO_APOYO_CABECERA.TRAN_VEHI_IDE) AS VEHI_PLACA, " +
                            "RECO_TONELAJE,RECO_VOLUMEN,RECO_UDOMETRO_INICIAL,RECO_UDOMETRO_FINAL,RECO_FECHA_TRASLADO," +
                            "RECO_HORA_SALIDA,RECO_FECHA_RETORNO,RECO_HORA_RETORNO FROM RECOJO_APOYO_CABECERA WHERE RECO_IDE = @IDE ";

            SqlCommand CMD = new SqlCommand(CmdSql);

            CMD.Parameters.AddWithValue("@IDE", Reco_ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));

            /*
             * SqlCommand CMD = new SqlCommand("PA_RECOJO_PEAJE_LISTAR");
             * CMD.Parameters.Add(Parametros_SQL.nombre_error, SqlDbType.VarChar).Value = DBNull.Value;
             * CMD.Parameters.Add(Parametros_SQL.ide, SqlDbType.Int).Value = Reco_ide;
             *
             * CMD.Parameters.Add("@RETURN", SqlDbType.Int);
             * CMD.Parameters["@RETURN"].Value = DBNull.Value;
             * CMD.Parameters["@RETURN"].Direction = ParameterDirection.ReturnValue;
             * return Recojo_PeajeDA.Acceder(CMD);
             */
        }
예제 #20
0
        public static ENResultOperation Obtener_Registro(Int32 Pers_Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM  V_MAESTRO_PERSONAL WHERE PERS_IDE = @IDE");

            CMD.Parameters.AddWithValue("@IDE", Pers_Ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #21
0
        public static ENResultOperation Existe_Personal_Documento(string Documento)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM  V_MAESTRO_PERSONAL WHERE PERS_DOCUMENTO = @DOCUMENTO");

            CMD.Parameters.AddWithValue("@DOCUMENTO", Documento);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #22
0
        public static ENResultOperation Obtener_Vehiculo(string Vehiculo_Ide, string Transportista_Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM  V_TRANSPORTISTA_VEHICULO WHERE TRAN_IDE = @TRAN_IDE AND TRAN_VEHI_IDE = @VEHI_IDE");

            CMD.Parameters.AddWithValue("@VEHI_IDE", Convert.ToInt32(Vehiculo_Ide));
            CMD.Parameters.AddWithValue("@TRAN_IDE", Convert.ToInt32(Transportista_Ide));
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
        public static ENResultOperation Obtener_Codigo(Int32 Ide, string Codigo)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM MANTENIMIENTO_GRUPO_ACTIVIDADES WHERE Mant_Grupo_Ide = @IDE AND Mant_Actividad_Codigo = @CODIGO");

            CMD.Parameters.AddWithValue("@IDE", Ide);
            CMD.Parameters.AddWithValue("@CODIGO", Codigo);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #24
0
        public static ENResultOperation Buscar_Filtro(string ApPaterno, string ApMaterno)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM  V_MAESTRO_PERSONAL WHERE PERS_APELLIDO_PATERNO LIKE '%' + @PATERNO + '%' AND PERS_APELLIDO_MATERNO LIKE '%' + @MATERNO + '%' ORDER BY PERS_APELLIDO_PATERNO");

            CMD.Parameters.AddWithValue("@PATERNO", ApPaterno);
            CMD.Parameters.AddWithValue("@MATERNO", ApMaterno);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
        public static ENResultOperation Obtener_Registro(Int32 nComp_Ide, Int32 nComp_Detalle_Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM V_COMPRA_PRODUCTOS_DETALLE  WHERE COMP_IDE = @IDE AND COMP_DETALLE_IDE = @IDE_DETALLE");

            CMD.Parameters.AddWithValue("@IDE", nComp_Ide);
            CMD.Parameters.AddWithValue("@IDE_DETALLE", nComp_Detalle_Ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #26
0
        public static ENResultOperation Buscar_Por_Documento(string NroDoc, Int32 Transportista_Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM  VW_TRANSPORTISTA_CONTACTO WHERE TRAN_IDE = @IDE AND TRAN_CONT_DOCUMENTO = @NRODOC");

            CMD.Parameters.AddWithValue("@NRODOC", NroDoc);
            CMD.Parameters.AddWithValue("@IDE", Transportista_Ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }
예제 #27
0
        public static ENResultOperation Listar_Filtro(string Texto_Buscar, Int32 Transportista_Ide)
        {
            SqlCommand CMD = new SqlCommand("SELECT * FROM  V_TRANSPORTISTA_VEHICULO WHERE TRAN_IDE = @TRAN_IDE AND " +
                                            "TRAN_VEHI_PLACA LIKE '%' + @BUSCAR ORDER BY TRAN_VEHI_PLACA");

            CMD.Parameters.AddWithValue("@BUSCAR", Texto_Buscar);
            CMD.Parameters.AddWithValue("@TRAN_IDE", Transportista_Ide);
            return(ProcesarSQLDA.Procesar_SQL(CMD));
        }