public void ConsultarFacturaRevisionCobro_Sugerido(ref FacturaRevisionCobro facturaRevisionCobro, string Conexion)
{
try
{
SqlDataReader dr = null;
CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(Conexion);
string[] Parametros =
{
"@Id_Emp",
"@Id_Cd",
"@Fecha",
"@Db"
};
object[] Valores =
{
facturaRevisionCobro.Id_Emp,
facturaRevisionCobro.Id_Cd,
facturaRevisionCobro.Frc_Fecha,
facturaRevisionCobro.DbName
};
SqlCommand sqlcmd = CapaDatos.GenerarSqlCommand("spProSeguimientoCobranzaRevision_Consultar", ref dr, Parametros, Valores);
while (dr.Read())
{
FacturaRevisionCobroDet facturaRevisionCobroDet = new FacturaRevisionCobroDet();
facturaRevisionCobroDet.Id_Emp = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Emp")));
facturaRevisionCobroDet.Id_Cd = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Cd")));
facturaRevisionCobroDet.Id_Frc = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Frc")));
facturaRevisionCobroDet.Id_FrcDet = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_FrcDet")));
facturaRevisionCobroDet.Id_Reg = dr.IsDBNull(dr.GetOrdinal("Id_Reg")) ? 0 : Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Reg")));
facturaRevisionCobroDet.Frc_Tipo = dr.GetValue(dr.GetOrdinal("Frc_Tipo")).ToString();
facturaRevisionCobroDet.Frc_TipoStr = dr.GetValue(dr.GetOrdinal("Frc_TipoStr")).ToString();
facturaRevisionCobroDet.Frc_Doc = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Frc_Doc")));
facturaRevisionCobroDet.Frc_Fecha = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("Frc_Fecha")));
facturaRevisionCobroDet.Id_Cte = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Cte")));
facturaRevisionCobroDet.Cte_NomComercial = dr.GetValue(dr.GetOrdinal("Cte_NomComercial")).ToString();
facturaRevisionCobroDet.Frc_Importe = Convert.ToDouble(dr.GetValue(dr.GetOrdinal("Frc_Importe")));
facturaRevisionCobroDet.Frc_EnviarA = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Frc_EnviarA")));
facturaRevisionCobroDet.Frc_EnviarAStr = dr.GetValue(dr.GetOrdinal("Frc_EnviarAStr")).ToString();
facturaRevisionCobroDet.Frc_Confirmado = Convert.ToBoolean(dr.GetValue(dr.GetOrdinal("Confirmado")));
facturaRevisionCobroDet.Frc_Seleccionado = Convert.ToBoolean(dr.GetValue(dr.GetOrdinal("Seleccionado")));
facturaRevisionCobro.ListaFacturaRevisionCobroDet.Add(facturaRevisionCobroDet);
}
CapaDatos.LimpiarSqlcommand(ref sqlcmd);
}
catch (Exception ex)
{
throw ex;
}
}
public void ConsultarFacturaRevisionCobro(ref FacturaRevisionCobro facturaRevisionCobro, string Conexion)
{
try
{
SqlDataReader dr = null;
CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(Conexion);
string[] Parametros =
{
"@Id_Emp"
, "@Id_Cd"
, "@Id_Frc"
};
object[] Valores =
{
facturaRevisionCobro.Id_Emp
, facturaRevisionCobro.Id_Cd
, facturaRevisionCobro.Id_Frc
};
SqlCommand sqlcmd = CapaDatos.GenerarSqlCommand("spCapFacRevCob_Consultar", ref dr, Parametros, Valores);
NotaCargo fac = new NotaCargo();
if (dr.HasRows)
{
dr.Read();
facturaRevisionCobro.Id_Emp = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Emp")));
facturaRevisionCobro.Id_Cd = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Cd")));
facturaRevisionCobro.Cd_Nombre = dr.GetValue(dr.GetOrdinal("Cd_Nombre")).ToString();
facturaRevisionCobro.Id_Frc = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Frc")));
facturaRevisionCobro.Id_Reg = dr.IsDBNull(dr.GetOrdinal("Id_Reg")) ? 0 : Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Reg")));
facturaRevisionCobro.Id_U = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_U")));
facturaRevisionCobro.Frc_Entrego = dr.GetValue(dr.GetOrdinal("Frc_Entrego")).ToString();
facturaRevisionCobro.Frc_Recibio = dr.GetValue(dr.GetOrdinal("Frc_Recibio")).ToString();
facturaRevisionCobro.Frc_Fecha = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("Frc_Fecha")));
if (dr.IsDBNull(dr.GetOrdinal("Frc_FecEnvio")))
{
facturaRevisionCobro.Frc_FecEnvio = null;
}
else
{
facturaRevisionCobro.Frc_FecEnvio = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("Frc_FecEnvio")));
}
if (dr.IsDBNull(dr.GetOrdinal("Frc_FecRecibio")))
{
facturaRevisionCobro.Frc_FecRecibio = null;
}
else
{
facturaRevisionCobro.Frc_FecRecibio = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("Frc_FecRecibio")));
}
facturaRevisionCobro.Frc_Estatus = dr.IsDBNull(dr.GetOrdinal("Frc_Estatus")) ? string.Empty : dr.GetValue(dr.GetOrdinal("Frc_Estatus")).ToString();
}
dr.Close();
facturaRevisionCobro.ListaFacturaRevisionCobroDet = new List <FacturaRevisionCobroDet>();
Parametros = new string[] {
"@Id_Emp"
, "@Id_Cd"
, "@Id_Frc"
, "@Db"
};
Valores = new object[] {
facturaRevisionCobro.Id_Emp
, facturaRevisionCobro.Id_Cd
, facturaRevisionCobro.Id_Frc
, facturaRevisionCobro.DbName
};
sqlcmd = CapaDatos.GenerarSqlCommand("spCapFacRevCobDetalle_Consultar", ref dr, Parametros, Valores);
while (dr.Read())
{
FacturaRevisionCobroDet facturaRevisionCobroDet = new FacturaRevisionCobroDet();
facturaRevisionCobroDet.Id_Emp = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Emp")));
facturaRevisionCobroDet.Id_Cd = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Cd")));
facturaRevisionCobroDet.Id_Frc = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Frc")));
facturaRevisionCobroDet.Id_FrcDet = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_FrcDet")));
facturaRevisionCobroDet.Id_Reg = dr.IsDBNull(dr.GetOrdinal("Id_Reg")) ? 0 : Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Reg")));
facturaRevisionCobroDet.Frc_Tipo = dr.GetValue(dr.GetOrdinal("Frc_Tipo")).ToString();
facturaRevisionCobroDet.Frc_TipoStr = dr.GetValue(dr.GetOrdinal("Frc_TipoStr")).ToString();
facturaRevisionCobroDet.Frc_Doc = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Frc_Doc")));
facturaRevisionCobroDet.Frc_Fecha = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("Frc_Fecha")));
facturaRevisionCobroDet.Id_Cte = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Cte")));
facturaRevisionCobroDet.Cte_NomComercial = dr.GetValue(dr.GetOrdinal("Cte_NomComercial")).ToString();
facturaRevisionCobroDet.Frc_Importe = Convert.ToDouble(dr.GetValue(dr.GetOrdinal("Frc_Importe")));
facturaRevisionCobroDet.Frc_EnviarA = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Frc_EnviarA")));
facturaRevisionCobroDet.Frc_EnviarAStr = dr.GetValue(dr.GetOrdinal("Frc_EnviarAStr")).ToString();
facturaRevisionCobroDet.Frc_Confirmado = Convert.ToBoolean(dr.GetValue(dr.GetOrdinal("Confirmado")));
facturaRevisionCobroDet.Frc_Seleccionado = Convert.ToBoolean(dr.GetValue(dr.GetOrdinal("Seleccionado")));
facturaRevisionCobroDet.Frc_Cheque = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Frc_Cheque")));
facturaRevisionCobroDet.Frc_Efectivo = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Frc_Efectivo")));
facturaRevisionCobro.ListaFacturaRevisionCobroDet.Add(facturaRevisionCobroDet);
}
CapaDatos.LimpiarSqlcommand(ref sqlcmd);
}
catch (Exception ex)
{
throw ex;
}
}
