Exemple #1
0
        private static AuthorInfo AuthorFromrdr(NullableDataReader rdr)
        {
            AuthorInfo info = new AuthorInfo();

            info.Id          = rdr.GetInt32("ID");
            info.UserId      = rdr.GetInt32("UserID");
            info.Type        = rdr.GetString("Type");
            info.Name        = rdr.GetString("Name");
            info.Passed      = rdr.GetBoolean("Passed");
            info.OnTop       = rdr.GetBoolean("onTop");
            info.Elite       = rdr.GetBoolean("IsElite");
            info.Hits        = rdr.GetInt32("Hits");
            info.LastUseTime = rdr.GetDateTime("LastUseTime");
            info.TemplateId  = rdr.GetInt32("TemplateID");
            info.Photo       = rdr.GetString("Photo");
            info.Intro       = rdr.GetString("Intro");
            info.Address     = rdr.GetString("Address");
            info.Tel         = rdr.GetString("Tel");
            info.Fax         = rdr.GetString("Fax");
            info.Mail        = rdr.GetString("Mail");
            info.Email       = rdr.GetString("Email");
            info.ZipCode     = rdr.GetInt32("ZipCode");
            info.HomePage    = rdr.GetString("HomePage");
            info.Imeeting    = rdr.GetString("Im");
            info.Sex         = rdr.GetInt16("Sex");
            info.BirthDay    = rdr.GetDateTime("BirthDay");
            info.Company     = rdr.GetString("Company");
            info.Department  = rdr.GetString("Department");
            return(info);
        }
Exemple #2
0
        /// <summary>
        /// 通过数据读取器生成实体类
        /// </summary>
        /// <param name="rdr"></param>
        /// <returns></returns>
        private static DeliverTypeEntity GetEntityFromrdr(NullableDataReader rdr)
        {
            DeliverTypeEntity info = new DeliverTypeEntity();

            info.TypeID         = rdr.GetInt32("TypeID");
            info.TypeName       = rdr.GetString("TypeName");
            info.Intro          = rdr.GetString("Intro");
            info.ChargeType     = rdr.GetInt32("ChargeType");
            info.IsDefault      = rdr.GetBoolean("IsDefault");
            info.IsDisabled     = rdr.GetBoolean("IsDisabled");
            info.OrderSort      = rdr.GetInt32("OrderSort");
            info.ReleaseType    = rdr.GetInt32("ReleaseType");
            info.MinMoney1      = rdr.GetDecimal("MinMoney1");
            info.ReleaseCharge  = rdr.GetDecimal("ReleaseCharge");
            info.Minmoney2      = rdr.GetDecimal("Minmoney2");
            info.MaxCharge      = rdr.GetDecimal("MaxCharge");
            info.MinMoney3      = rdr.GetDecimal("MinMoney3");
            info.Charge_Min     = rdr.GetDecimal("Charge_Min");
            info.Charge_Max     = rdr.GetDecimal("Charge_Max");
            info.Charge_Percent = rdr.GetInt16("Charge_Percent");
            info.IncludeTax     = rdr.GetInt32("IncludeTax");
            info.TaxRate        = rdr.GetDouble("TaxRate");
            info.StoreID        = rdr.GetInt32("StoreID");
            return(info);
        }
Exemple #3
0
        /// <summary>
        /// 通过数据读取器生成实体类
        /// </summary>
        /// <param name="rdr"></param>
        /// <returns></returns>
        private static AuthorEntity GetEntityFromrdr(NullableDataReader rdr)
        {
            AuthorEntity info = new AuthorEntity();

            info.ID          = rdr.GetInt32("ID");
            info.UserID      = rdr.GetInt32("UserID");
            info.Type        = rdr.GetString("Type");
            info.Name        = rdr.GetString("Name");
            info.IsPassed    = rdr.GetBoolean("IsPassed");
            info.IsTop       = rdr.GetBoolean("IsTop");
            info.IsElite     = rdr.GetBoolean("IsElite");
            info.Hits        = rdr.GetInt32("Hits");
            info.LastUseTime = rdr.GetNullableDateTime("LastUseTime");
            info.TemplateID  = rdr.GetInt32("TemplateID");
            info.AuthorPic   = rdr.GetString("AuthorPic");
            info.AuthorIntro = rdr.GetString("AuthorIntro");
            info.Address     = rdr.GetString("Address");
            info.Tel         = rdr.GetString("Tel");
            info.Fax         = rdr.GetString("Fax");
            info.Mail        = rdr.GetString("Mail");
            info.Email       = rdr.GetString("Email");
            info.ZipCode     = rdr.GetInt32("ZipCode");
            info.HomePage    = rdr.GetString("HomePage");
            info.Im          = rdr.GetString("Im");
            info.Sex         = rdr.GetInt16("Sex");
            info.BirthDay    = rdr.GetNullableDateTime("BirthDay");
            info.Company     = rdr.GetString("Company");
            info.Department  = rdr.GetString("Department");
            return(info);
        }
Exemple #4
0
 private void Fill(out IndicadorPorSolicitudesPrestaciones oObj, NullableDataReader dr)
 {
     oObj = new IndicadorPorSolicitudesPrestaciones(dr.GetString("totalPrestacion")
                                                    , dr.GetString("porcentualPrestacion")
                                                    , dr.GetInt16("codPrestacion")
                                                    , dr.GetString("DPrestacion")
                                                    );
 }
Exemple #5
0
 private void Fill(out IndicadorPorSolicitudesPaisConvenio oObj, NullableDataReader dr)
 {
     oObj = new IndicadorPorSolicitudesPaisConvenio(dr.GetString("totalPais")
                                                    , dr.GetString("porcentualPais")
                                                    , dr.GetInt16("pais_PK")
                                                    , dr.GetString("DPais")
                                                    );
 }
Exemple #6
0
 private void Fill(out SolicitudesEFechasSolicitud oObj, NullableDataReader dr)
 {
     oObj = new SolicitudesEFechasSolicitud(
         dr.GetInt64("id_Beneficiario")
         , dr.GetInt16("codPrestacion")
         , dr.GetString("ApeNomCompleto")
         , dr.GetNullableString("cuip") == null ? "" : dr.GetString("cuip")
         , dr.GetString("DescripcionPrestacion")
         , dr.GetInt16("pais_PK")
         , dr.GetString("PaisDescCompleto")
         , dr.GetBoolean("Mercosur")
         , dr.GetString("referencia_exterior")
         , dr.GetString("ubicacion_Fisica")
         , dr.GetDateTime("fAMSolicitud")
         , dr.GetDateTime("fechaIngreso")
         );
 }
Exemple #7
0
 private void Fill(out Banco oObj, NullableDataReader dr)
 {
     oObj = new Banco(dr.GetInt16("id_Banco"),
                      dr.GetNullableString("descripcion") == null  ? "" : dr.GetString("descripcion"),
                      dr.GetBoolean("frecuente"),
                      dr.GetNullableString("webSite") == null ?"":dr.GetString("webSite")
                      );
 }
Exemple #8
0
 private void Fill(out Pais oObj, NullableDataReader dr)
 {
     oObj = new Pais(dr.GetInt16("codigoPais"),
                     dr.GetNullableString("descripcion") == null ? "" : dr.GetString("descripcion"),
                     dr.GetNullableString("gentilicio") == null ? "" : dr.GetString("gentilicio"),
                     dr.GetBoolean("tieneConvenio"),
                     dr.GetBoolean("mercosur")
                     );
 }
Exemple #9
0
 private void Fill(out NotificacionesVencidas oObj, NullableDataReader dr)
 {
     oObj = new NotificacionesVencidas(dr.GetInt64("id_Beneficiario")
                                       , dr.GetString("NomApe")
                                       , dr.GetInt16("codPrestacion")
                                       , dr.GetString("DescripcionPrestacion")
                                       , dr.GetDateTime("fechaMovimiento")
                                       , dr.GetString("destino")
                                       , dr.GetString("observaciones")
                                       , dr.GetString("certificado")
                                       , dr.GetNullableDateTime("fechaNotificacion")
                                       );
 }
Exemple #10
0
 private void Fill(out Documento_Causante oObj, NullableDataReader dr)
 {
     oObj = new Documento_Causante(dr.GetInt64("id_Beneficiario"),
                                   dr.GetString("numDoc"),
                                   dr.GetInt16("codigoDocumento"),
                                   dr.GetString("abrevDTDoc"),
                                   dr.GetBoolean("docADP"),
                                   dr.GetNullableString("abrevPais") == null ? "" : dr.GetString("abrevPais"),
                                   dr.GetNullableInt16("PaisPK"),
                                   dr.GetDateTime("fechaAlta"),
                                   dr.GetNullableDateTime("fechaBaja")
                                   );
 }
Exemple #11
0
        private void Fill(out Ingresos oObj, NullableDataReader dr)
        {
            AuxiliaresDatos oAuxDao = new AuxiliaresDatos();

            oObj = new Ingresos(dr.GetNullableByte("idTipoIngreso") == null ? null : oAuxDao.Traer_TipoIngreso(dr.GetByte("idTipoIngreso")),
                                dr.GetNullableDateTime("fechaIngreso"),
                                this.TraeIngresadosXFechaMovimiento(dr.GetInt64("id_Beneficiario"), dr.GetInt16("codPrestacion"), dr.GetDateTime("fechaIngreso")),
                                dr.GetNullableString("observacion") == null ? "" : dr.GetString("observacion")
                                );
        }
Exemple #12
0
 private void Fill(out Devolucion oObj, NullableDataReader dr)
 {
     oObj = new Devolucion(dr.GetDateTime("fechaMovimiento"),
                           dr.GetNullableString("destino") == null  ? "" : dr.GetString("destino"),
                           dr.GetNullableString("Observaciones") == null?"":dr.GetString("Observaciones"),
                           dr.GetNullableString("Certificado") == null ? "" : dr.GetString("Certificado"),
                           this.TraeFaltanteDevolucionXFechaMovimiento(dr.GetInt64("id_Beneficiario"), dr.GetInt16("codPrestacion"), dr.GetDateTime("fechaMovimiento").ToShortDateString()),
                           dr.GetNullableDateTime("fechaNotificacion"),
                           dr.GetNullableDateTime("fechaPresentacion")
                           );
 }