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);
}
/// <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);
}
/// <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);
}
private void Fill(out IndicadorPorSolicitudesPrestaciones oObj, NullableDataReader dr)
{
oObj = new IndicadorPorSolicitudesPrestaciones(dr.GetString("totalPrestacion")
, dr.GetString("porcentualPrestacion")
, dr.GetInt16("codPrestacion")
, dr.GetString("DPrestacion")
);
}
private void Fill(out IndicadorPorSolicitudesPaisConvenio oObj, NullableDataReader dr)
{
oObj = new IndicadorPorSolicitudesPaisConvenio(dr.GetString("totalPais")
, dr.GetString("porcentualPais")
, dr.GetInt16("pais_PK")
, dr.GetString("DPais")
);
}
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")
);
}
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")
);
}
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")
);
}
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")
);
}
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")
);
}
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")
);
}
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")
);
}