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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}
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);
*/
}
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));
}
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));
}
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));
}
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));
}
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));
}
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));
}