201 lines
11 KiB
C#
201 lines
11 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace ADSUtileriasService.Conexion.Local.Estructura
|
|
{
|
|
class RHTablas
|
|
{
|
|
public static string Checador
|
|
{
|
|
get
|
|
{
|
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.Append("CREATE TABLE [RH_Checador] (");
|
|
strSQL.Append(" ROWID INTEGER primary key autoincrement,");
|
|
strSQL.Append(" [cveChecador] INTEGER NULL,");
|
|
strSQL.Append(" [checador] TEXT NULL,");
|
|
strSQL.Append(" [cveSubProyecto] INTEGER NULL,");
|
|
strSQL.Append(" [cveModelo] INTEGER NULL,");
|
|
strSQL.Append(" [iPLocal] TEXT NULL,");
|
|
strSQL.Append(" [puerto] TEXT NULL,");
|
|
strSQL.Append(" [cveUsuario] INTEGER NULL,");
|
|
strSQL.Append(" [fechaIng] DATETIME NULL,");
|
|
strSQL.Append(" [CveEmpresa] INTEGER NULL,");
|
|
strSQL.Append(" [estatus] INT DEFAULT 0) ");
|
|
return strSQL.ToString();
|
|
}
|
|
}
|
|
|
|
public static string RH_RegistroPersonalChecador
|
|
{
|
|
get
|
|
{
|
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.Append("CREATE TABLE [RH_RegistroPersonalChecador] (");
|
|
strSQL.Append(" [fecha] DateTime) ");
|
|
return strSQL.ToString();
|
|
}
|
|
}
|
|
|
|
|
|
|
|
/*
|
|
*
|
|
|
|
public class RegistroPersonalChecador
|
|
{
|
|
public string IdPersonal;
|
|
public string idwWorkcode;
|
|
public DateTime fecha;
|
|
public int idwInOutMode;
|
|
public int idwVerifyMode;
|
|
}
|
|
*
|
|
*/
|
|
public static string Personal
|
|
{
|
|
get
|
|
{
|
|
StringBuilder strSQL = new StringBuilder();
|
|
strSQL.Append("CREATE TABLE [RH_Personal] (");
|
|
strSQL.Append(" ROWID INTEGER primary key autoincrement,");
|
|
strSQL.Append(" [CvePersonal] int NOT NULL,");
|
|
strSQL.Append(" [Codigo] varchar(12)NOT NULL,");
|
|
strSQL.Append(" [Nombre] varchar(112)NOT NULL,");
|
|
strSQL.Append(" [Correo] varchar(50)NULL,");
|
|
strSQL.Append(" [NombreCompleto] varchar(112)NOT NULL,");
|
|
strSQL.Append(" [APaterno] varchar(30)NOT NULL,");
|
|
strSQL.Append(" [AMaterno] varchar(30)NOT NULL,");
|
|
strSQL.Append(" [Nombres] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [NombreCompletoNombre] varchar(112)NOT NULL,");
|
|
strSQL.Append(" [CodigoNombreCompleto] varchar(127)NOT NULL,");
|
|
strSQL.Append(" [NSS] varchar(25)NOT NULL,");
|
|
strSQL.Append(" [FechaIngreso] date NOT NULL,");
|
|
strSQL.Append(" [NumeroSS] varchar(25)NOT NULL,");
|
|
strSQL.Append(" [SeInscribioSS] bit NOT NULL,");
|
|
strSQL.Append(" [SalarioDiarioPago] money NOT NULL,");
|
|
strSQL.Append(" [SalarioDiario] money NOT NULL,");
|
|
strSQL.Append(" [SDI] money NOT NULL,");
|
|
strSQL.Append(" [SalarioDiarioSS] money NOT NULL,");
|
|
strSQL.Append(" [Bono] money NOT NULL,");
|
|
strSQL.Append(" [NumDiasAguinaldo] int NOT NULL,");
|
|
strSQL.Append(" [PorPrimaVacacional] float(53) NOT NULL,");
|
|
strSQL.Append(" [CveMetodoPago] int NOT NULL,");
|
|
strSQL.Append(" [MetodoPago] varchar(40)NOT NULL,");
|
|
strSQL.Append(" [MetodoPagoSAT] varchar(2)NULL,");
|
|
strSQL.Append(" [CveSATRegimenContratacion] int NULL,");
|
|
strSQL.Append(" [RegimenContratacion] varchar(300)NULL,");
|
|
strSQL.Append(" [CveRegimenContratacion] varchar(2)NULL,");
|
|
strSQL.Append(" [CveSATRiesgoPuesto] int NULL,");
|
|
strSQL.Append(" [RiesgoPuesto] varchar(50)NULL,");
|
|
strSQL.Append(" [CveRiesgoPuesto] varchar(10)NULL,");
|
|
strSQL.Append(" [CveSATBanco] int NULL,");
|
|
strSQL.Append(" [Banco] varchar(150)NULL,");
|
|
strSQL.Append(" [CveBanco] varchar(50)NULL,");
|
|
strSQL.Append(" [CveTipoPeriodo] int NOT NULL,");
|
|
strSQL.Append(" [TipoPeriodo] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [FechaInicioContrato] date NOT NULL,");
|
|
strSQL.Append(" [FechaFinContrato] date NULL,");
|
|
strSQL.Append(" [CveTipoContrato] int NOT NULL,");
|
|
strSQL.Append(" [TipoContrato] varchar(100)NOT NULL,");
|
|
strSQL.Append(" [CodigoTipoContrato] varchar(2)NULL,");
|
|
strSQL.Append(" [Ubicacion] varchar(50)NULL,");
|
|
strSQL.Append(" [CveSubProyectoZona] int NULL,");
|
|
strSQL.Append(" [CveTurno] int NOT NULL,");
|
|
strSQL.Append(" [Turno] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CvePuesto] int NOT NULL,");
|
|
strSQL.Append(" [Puesto] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CveDepartamento] int NOT NULL,");
|
|
strSQL.Append(" [Departamento] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CveRuta] int NOT NULL,");
|
|
strSQL.Append(" [Ruta] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CveEscolaridad] int NOT NULL,");
|
|
strSQL.Append(" [Escolaridad] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CveEstadoCivil] int NOT NULL,");
|
|
strSQL.Append(" [EstadoCivil] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CveGenero] int NOT NULL,");
|
|
strSQL.Append(" [Genero] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CveMotivoBaja] int NOT NULL,");
|
|
strSQL.Append(" [MotivoBaja] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CvePeriodoFiniquito] int NULL,");
|
|
strSQL.Append(" [FechaBaja] date NULL,");
|
|
strSQL.Append(" [CveEstatusPersonal] int NOT NULL,");
|
|
strSQL.Append(" [EstatusPersonal] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [FechaNacimiento] date NOT NULL,");
|
|
strSQL.Append(" [LugarNacimiento] varchar(70)NULL,");
|
|
strSQL.Append(" [Calle] varchar(70)NULL,");
|
|
strSQL.Append(" [NumExt] varchar(10)NULL,");
|
|
strSQL.Append(" [NumInt] varchar(10)NULL,");
|
|
strSQL.Append(" [Colonia] varchar(30)NULL,");
|
|
strSQL.Append(" [Direccion] varchar(70)NULL,");
|
|
strSQL.Append(" [CP] varchar(5)NULL,");
|
|
strSQL.Append(" [Ciudad] varchar(30)NULL,");
|
|
strSQL.Append(" [CveEstado] int NULL,");
|
|
strSQL.Append(" [Estado] varchar(30)NULL,");
|
|
strSQL.Append(" [Telefono] varchar(10)NULL,");
|
|
strSQL.Append(" [Celular] varchar(10)NULL,");
|
|
strSQL.Append(" [RFC] varchar(13)NULL,");
|
|
strSQL.Append(" [CURP] varchar(18)NULL,");
|
|
strSQL.Append(" [NombrePadre] varchar(50)NULL,");
|
|
strSQL.Append(" [NombreMadre] varchar(50)NULL,");
|
|
strSQL.Append(" [CveJornada] int NULL,");
|
|
strSQL.Append(" [Jornada] varchar(50)NULL,");
|
|
strSQL.Append(" [ClaveTipoJornada] varchar(2)NULL,");
|
|
strSQL.Append(" [CveClienteAsignado] int NOT NULL,");
|
|
strSQL.Append(" [ClienteAsignado] varchar(150)NOT NULL,");
|
|
strSQL.Append(" [CveSubProyecto] int NOT NULL,");
|
|
strSQL.Append(" [SubProyecto] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CveProyecto] int NOT NULL,");
|
|
strSQL.Append(" [Proyecto] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [CveSupervisor] int NOT NULL,");
|
|
strSQL.Append(" [Supervisor] varchar(50)NOT NULL,");
|
|
strSQL.Append(" [FechaIng] datetime NOT NULL,");
|
|
strSQL.Append(" [URL] varchar(50)NULL,");
|
|
strSQL.Append(" [CveUsuario] int NOT NULL,");
|
|
strSQL.Append(" [Usuario] varchar(50)NULL,");
|
|
strSQL.Append(" [CveEmpresa] int NOT NULL,");
|
|
strSQL.Append(" [CLABE] varchar(18)NULL,");
|
|
strSQL.Append(" [BancoNumCuenta] varchar(20)NULL,");
|
|
strSQL.Append(" [IdCtaContPersonal] int NULL,");
|
|
strSQL.Append(" [IdCtaContPersonalSIG] int NULL,");
|
|
strSQL.Append(" [CtaContPersonal] varchar(50)NULL,");
|
|
strSQL.Append(" [IdCtaContPrestamos] int NULL,");
|
|
strSQL.Append(" [IdCtaContPrestamosSIG] int NULL,");
|
|
strSQL.Append(" [CtaContPrestamos] varchar(50)NULL,");
|
|
strSQL.Append(" [CvePersonalPadre] int NULL,");
|
|
strSQL.Append(" [ClaveEstado] varchar(5)NULL,");
|
|
strSQL.Append(" [TipoPerioricidadPago] varchar(2)NULL,");
|
|
strSQL.Append(" [CveChecadorHorario] int NULL,");
|
|
strSQL.Append(" [ChecadorHorario] varchar(50)NULL,");
|
|
strSQL.Append(" [CveUsuarioNomina] int NULL,");
|
|
strSQL.Append(" [NombreAbreviatura] varchar(10)NULL,");
|
|
strSQL.Append(" [CveUniforme] int NULL,");
|
|
strSQL.Append(" [NumeroTarjeta] int NULL,");
|
|
strSQL.Append(" [Sucursal] varchar(50)NULL,");
|
|
strSQL.Append(" [CuentaBancaria] varchar(50)NULL,");
|
|
strSQL.Append(" [TelefonoExtension] varchar(15)NULL,");
|
|
strSQL.Append(" [CelularPersonal] varchar(10)NULL,");
|
|
strSQL.Append(" [TelefonoMarcadoRapido] varchar(10)NULL,");
|
|
strSQL.Append(" [ContactoAlterno] varchar(10)NULL,");
|
|
strSQL.Append(" [FechaActivo] date NULL,");
|
|
strSQL.Append(" [FechaReingreso] date NULL,");
|
|
strSQL.Append(" [esTemporal] int NOT NULL,");
|
|
strSQL.Append(" [RFCValidado] int NOT NULL,");
|
|
strSQL.Append(" [MaiReciboNomina] varchar(255)NOT NULL,");
|
|
strSQL.Append(" [CveTipodeSalario] int NOT NULL,");
|
|
strSQL.Append(" [CveChecador] int NULL,");
|
|
strSQL.Append(" [ChecadorID] int NULL,");
|
|
strSQL.Append(" [CveUsuarioUpdate] int NULL,");
|
|
strSQL.Append(" [FechaUpdate] DATETIME NULL,");
|
|
strSQL.Append(" [SincronizadoSig] int NULL DEFAULT 1,");
|
|
strSQL.Append(" [SincronizadoChecador] int NULL DEFAULT 1");
|
|
strSQL.Append(") ");
|
|
return strSQL.ToString();
|
|
}
|
|
}
|
|
}
|
|
}
|