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(); } } } }