public static DataTable EMPLEADO_NOMBRE()
{
if (Main_Menu.TIPO_RRHH == "ADMIN")
{
DataTable dt2 = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT EM.NOMBRE FROM [EXACTUS].[dismo].[EMPLEADO_JERARQUIA] as EJ INNER JOIN [EXACTUS].[dismo].[EMPLEADO] as EM on EJ.SUBORDINADO = EM.EMPLEADO INNER JOIN [DM].[CORRECT].[USUARIOS] as DMUSER ON EJ.SUPERIOR = DMUSER.COD_EMPLEADO ";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt2);
coned.con.Close();
return(dt2);
}
else
{
DataTable dt2 = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT EM.NOMBRE FROM [EXACTUS].[dismo].[EMPLEADO_JERARQUIA] as EJ INNER JOIN [EXACTUS].[dismo].[EMPLEADO] as EM on EJ.SUBORDINADO = EM.EMPLEADO INNER JOIN [DM].[CORRECT].[USUARIOS] as DMUSER ON EJ.SUPERIOR = DMUSER.COD_EMPLEADO where DMUSER.COD_EMPLEADO = '" + Main_Menu.COD_EMPLEADO + "'";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt2);
coned.con.Close();
return(dt2);
}
}
public static DataTable PLACAS()
{
DataTable dt2 = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT PLACA FROM [DM].[CORRECT].[VEHICULOS] ORDER BY PLACA";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt2);
coned.con.Close();
return(dt2);
}
public static DataTable EMPRESAS()
{
DataTable dt9 = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT NOMRE FROM [DM].[CORRECT].[EMPRESAS] order by ID desc";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt9);
coned.con.Close();
return(dt9);
}
public static DataTable CUENTA_BAT()
{
DataTable dt5 = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT CUENTA FROM [DM].[CORRECT].[ACTIVIDADES_BAT] order by ID desc";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt5);
coned.con.Close();
return(dt5);
}
public static DataTable REGISTRO()
{
DataTable dt2 = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT Registro FROM [DM].[CORRECT].[Proveedores] ORDER BY Registro";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt2);
coned.con.Close();
return(dt2);
}
public static DataTable RUTAS()
{
DataTable dt = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT [RUTA] FROM [DM].[CORRECT].[RUTA_REGALIAS] ORDER BY RUTA";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt);
coned.con.Close();
return(dt);
}
public static DataTable FORMA_PAGO()
{
DataTable dt2 = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT TIPO FROM [DM].[CORRECT].[FORMA_PAGO_GAS] ORDER BY TIPO";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt2);
coned.con.Close();
return(dt2);
}
public static DataTable EMPLEADOS_CODIGO()
{
if (Main_Menu.TIPO_RRHH == "ADMIN")
{
DataTable dt2 = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT EJ.[SUBORDINADO] FROM [EXACTUS].[dismo].[EMPLEADO_JERARQUIA] as EJ INNER JOIN [EXACTUS].[dismo].[EMPLEADO] as EM on EJ.SUBORDINADO = EM.EMPLEADO INNER JOIN [DM].[CORRECT].[USUARIOS] as DMUSER ON EJ.SUPERIOR = DMUSER.COD_EMPLEADO ";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt2);
coned.con.Close();
return(dt2);
}
else
{
DataTable dt2 = new DataTable();
Conexion2 coned = new Conexion2();
coned.con.Open();
string consulta = "SELECT EJ.[SUBORDINADO] FROM [EXACTUS].[dismo].[EMPLEADO_JERARQUIA] as EJ INNER JOIN [EXACTUS].[dismo].[EMPLEADO] as EM on EJ.SUBORDINADO = EM.EMPLEADO INNER JOIN [DM].[CORRECT].[USUARIOS] as DMUSER ON EJ.SUPERIOR = DMUSER.COD_EMPLEADO where DMUSER.COD_EMPLEADO ='" + Main_Menu.COD_EMPLEADO + "'";
SqlCommand comando = new SqlCommand(consulta, coned.con);
SqlDataAdapter adap = new SqlDataAdapter(comando);
adap.Fill(dt2);
if (Main_Menu.autoev == "S")
{
if (dt2.Rows.Count > 0)
{
DataRow Row = dt2.NewRow();
Row["SUBORDINADO"] = Main_Menu.COD_EMPLEADO;
dt2.Rows.Add(Row);
}
}
coned.con.Close();
return(dt2);
}
}