Пример #1
0
        private ArrayList BuildParamInterface(EPerDepen value)
        {
            ArrayList arrPrm = new ArrayList();

             arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, value.IdEmpresa));
             arrPrm.Add(DataHelper.CreateParameter("@pidPersonal", SqlDbType.Char, 7, value.IdPersonal));
             arrPrm.Add(DataHelper.CreateParameter("@pnuSecuen", SqlDbType.SmallInt, value.NuSecuen));
             arrPrm.Add(DataHelper.CreateParameter("@pidTDocIden", SqlDbType.Char, 3, value.IdTDocIden));
             arrPrm.Add(DataHelper.CreateParameter("@pnuDocIden", SqlDbType.VarChar, 15, value.NuDocIden));
             arrPrm.Add(DataHelper.CreateParameter("@pidPaisEmiDoc", SqlDbType.Char, 3, value.IdPaisEmiDoc));
             arrPrm.Add(DataHelper.CreateParameter("@pfeNacimien", SqlDbType.DateTime, value.FeNacimien));
             arrPrm.Add(DataHelper.CreateParameter("@pdsAPaterno", SqlDbType.VarChar, 40, value.DsAPaterno));
             arrPrm.Add(DataHelper.CreateParameter("@pdsAMaterno", SqlDbType.VarChar, 40, value.DsAMaterno));
             arrPrm.Add(DataHelper.CreateParameter("@pdsNombres", SqlDbType.VarChar, 40, value.DsNombres));
             arrPrm.Add(DataHelper.CreateParameter("@pidSexo", SqlDbType.Char, 3, value.IdSexo));
             arrPrm.Add(DataHelper.CreateParameter("@pidVincFam", SqlDbType.Char, 3, value.IdVincFam));
             arrPrm.Add(DataHelper.CreateParameter("@pidTipoDocAcre", SqlDbType.Char, 3, value.IdTipoDocAcre));
             arrPrm.Add(DataHelper.CreateParameter("@pnuDocAcre", SqlDbType.VarChar, 20, value.NuDocAcre));
             arrPrm.Add(DataHelper.CreateParameter("@pnuMesConcep", SqlDbType.Char, 6, value.NuMesConcep));
             arrPrm.Add(DataHelper.CreateParameter("@pidTipoVia1", SqlDbType.Char, 3, value.IdTipoVia1));
             arrPrm.Add(DataHelper.CreateParameter("@pdsNombreVia1", SqlDbType.VarChar, 20, value.DsNombreVia1));
             arrPrm.Add(DataHelper.CreateParameter("@pnuVia1", SqlDbType.Char, 4, value.NuVia1));
             arrPrm.Add(DataHelper.CreateParameter("@pnuDepa1", SqlDbType.Char, 4, value.NuDepa1));
             arrPrm.Add(DataHelper.CreateParameter("@pnuInterior1", SqlDbType.VarChar, 4, value.NuInterior1));
             arrPrm.Add(DataHelper.CreateParameter("@pnuMz1", SqlDbType.Char, 4, value.NuMz1));
             arrPrm.Add(DataHelper.CreateParameter("@pnuLote1", SqlDbType.Char, 4, value.NuLote1));
             arrPrm.Add(DataHelper.CreateParameter("@pnuKm1", SqlDbType.Char, 4, value.NuKm1));
             arrPrm.Add(DataHelper.CreateParameter("@pnuBlock1", SqlDbType.Char, 4, value.NuBlock1));
             arrPrm.Add(DataHelper.CreateParameter("@pdsEtapa1", SqlDbType.Char, 4, value.DsEtapa1));
             arrPrm.Add(DataHelper.CreateParameter("@pidTipoZona1", SqlDbType.Char, 3, value.IdTipoZona1));
             arrPrm.Add(DataHelper.CreateParameter("@pdsNombZona1", SqlDbType.VarChar, 20, value.DsNombZona1));
             arrPrm.Add(DataHelper.CreateParameter("@pdsReferen1", SqlDbType.VarChar, 40, value.DsReferen1));
             arrPrm.Add(DataHelper.CreateParameter("@pidPais1", SqlDbType.Char, 4, value.IdPais1));
             arrPrm.Add(DataHelper.CreateParameter("@pidDepa1", SqlDbType.Char, 2, value.IdDepa1));
             arrPrm.Add(DataHelper.CreateParameter("@pidProv1", SqlDbType.Char, 2, value.IdProv1));
             arrPrm.Add(DataHelper.CreateParameter("@pidDist1", SqlDbType.Char, 2, value.IdDist1));
             arrPrm.Add(DataHelper.CreateParameter("@pidTipoVia2", SqlDbType.Char, 3, value.IdTipoVia2));
             arrPrm.Add(DataHelper.CreateParameter("@pdsNombreVia2", SqlDbType.VarChar, 20, value.DsNombreVia2));
             arrPrm.Add(DataHelper.CreateParameter("@pnuVia2", SqlDbType.Char, 4, value.NuVia2));
             arrPrm.Add(DataHelper.CreateParameter("@pnuDepa2", SqlDbType.Char, 4, value.NuDepa2));
             arrPrm.Add(DataHelper.CreateParameter("@pnuInterior2", SqlDbType.Char, 4, value.NuInterior2));
             arrPrm.Add(DataHelper.CreateParameter("@pnuMz2", SqlDbType.Char, 4, value.NuMz2));
             arrPrm.Add(DataHelper.CreateParameter("@pnuLote2", SqlDbType.Char, 4, value.NuLote2));
             arrPrm.Add(DataHelper.CreateParameter("@pnuKm2", SqlDbType.Char, 4, value.NuKm2));
             arrPrm.Add(DataHelper.CreateParameter("@pnuBlock2", SqlDbType.Char, 4, value.NuBlock2));
             arrPrm.Add(DataHelper.CreateParameter("@pdsEtapa2", SqlDbType.Char, 4, value.DsEtapa2));
             arrPrm.Add(DataHelper.CreateParameter("@pidTipoZona2", SqlDbType.Char, 3, value.IdTipoZona2));
             arrPrm.Add(DataHelper.CreateParameter("@pdsNombZona2", SqlDbType.Char, 20, value.DsNombZona2));
             arrPrm.Add(DataHelper.CreateParameter("@pdsReferen2", SqlDbType.VarChar, 40, value.DsReferen2));
             arrPrm.Add(DataHelper.CreateParameter("@pidPais2", SqlDbType.Char, 4, value.IdPais2));
             arrPrm.Add(DataHelper.CreateParameter("@pidDepa2", SqlDbType.Char, 2, value.IdDepa2));
             arrPrm.Add(DataHelper.CreateParameter("@pidProv2", SqlDbType.Char, 2, value.IdProv2));
             arrPrm.Add(DataHelper.CreateParameter("@pidDist2", SqlDbType.Char, 2, value.IdDist2));
             arrPrm.Add(DataHelper.CreateParameter("@pstAsisEsSalud", SqlDbType.Char, 1, value.StAsisEsSalud));
             arrPrm.Add(DataHelper.CreateParameter("@pnuTlfCodLDN", SqlDbType.Char, 3, value.NuTlfCodLDN));
             arrPrm.Add(DataHelper.CreateParameter("@pnuTelf", SqlDbType.VarChar, 10, value.NuTelf));
             arrPrm.Add(DataHelper.CreateParameter("@pdsEmail", SqlDbType.VarChar, 50, value.DsEmail));
             arrPrm.Add(DataHelper.CreateParameter("@pfeBaja", SqlDbType.DateTime, (value.FeBaja.HasValue ? (object)value.FeBaja : DBNull.Value)));
             arrPrm.Add(DataHelper.CreateParameter("@pidMotivBaja", SqlDbType.Char, 3, (value.IdMotivBaja != null ? value.IdMotivBaja : null)));
             arrPrm.Add(DataHelper.CreateParameter("@pstAnulado", SqlDbType.Char, 1, value.StAnulado));

             return arrPrm;
        }
Пример #2
0
        private ArrayList BuildParamInterface(EPerDepen value)
        {
            ArrayList arrPrm = new ArrayList();

            arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, value.IdEmpresa));
            arrPrm.Add(DataHelper.CreateParameter("@pidPersonal", SqlDbType.Char, 7, value.IdPersonal));
            arrPrm.Add(DataHelper.CreateParameter("@pnuSecuen", SqlDbType.SmallInt, value.NuSecuen));

            return arrPrm;
        }