public void ConsultaFacturaRevisionCobro_Buscar(FacturaRevisionCobro facturaRevCob, ref List <FacturaRevisionCobro> listaFacturaRevCob, string Conexion
, int?Id_U
, DateTime?Frc_Fecha_inicio
, DateTime?Frc_Fecha_fin
, string Frc_Estatus
, int?Id_Frc_inicio
, int?Id_Frc_fin
, int?Id_Cte
)
{
try
{
new CD_CapFacturaRevisionCobro().ConsultaFacturaRevisionCobro_Buscar(facturaRevCob, ref listaFacturaRevCob, Conexion
, Id_U
, Frc_Fecha_inicio
, Frc_Fecha_fin
, Frc_Estatus
, Id_Frc_inicio
, Id_Frc_fin
, Id_Cte);
}
catch (Exception ex)
{
throw ex;
}
}
public void ConfirmarRevision(FacturaRevisionCobro FacturaRevisionCobro, ref int verificador, string Conexion, string dbname)
{
CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(Conexion);
try
{
CapaDatos.StartTrans();
SqlCommand sqlcmd = new SqlCommand();
string[] Parametros = { "@Id_Emp", "@Id_Cd", "@Id_Fac", "@Id_Frc", "@EnviarA", "@Frc_Cheque", "@Frc_Efectivo", "@Db" };
foreach (FacturaRevisionCobroDet revision in FacturaRevisionCobro.ListaFacturaRevisionCobroDet)
{
object[] Valores = { revision.Id_Emp, revision.Id_Cd, revision.Frc_Doc, revision.Id_Frc, revision.Frc_EnviarA,
revision.Frc_Cheque, revision.Frc_Efectivo, dbname };
sqlcmd = CapaDatos.GenerarSqlCommand("spProSeguimientoCobranza_ConfirmarRevision", ref verificador, Parametros, Valores);
}
CapaDatos.CommitTrans();
CapaDatos.LimpiarSqlcommand(ref sqlcmd);
verificador = 1;
}
catch (Exception ex)
{
CapaDatos.RollBackTrans();
throw ex;
}
}
public void ModificarEstatusFacturaRevisionCobro(FacturaRevisionCobro facturaRevisionCobro, string Conexion, ref int verificador)
{
CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(Conexion);
try
{
CapaDatos.StartTrans();
string[] Parametros =
{
"@Id_Emp"
, "@Id_Cd"
, "@Id_Frc"
, "@Frc_Estatus"
};
object[] Valores =
{
facturaRevisionCobro.Id_Emp
, facturaRevisionCobro.Id_Cd
, facturaRevisionCobro.Id_Frc
, facturaRevisionCobro.Frc_Estatus
};
SqlCommand sqlcmd = new SqlCommand();
sqlcmd = CapaDatos.GenerarSqlCommand("spCapFacRevCob_ModificarEstatus", ref verificador, Parametros, Valores);
//ordenCompra.Id_Ord = verificador; //identity de orden de compra
CapaDatos.CommitTrans();
CapaDatos.LimpiarSqlcommand(ref sqlcmd);
}
catch (Exception ex)
{
CapaDatos.RollBackTrans();
throw ex;
}
}
private void FacturaRevCobImpresion_NeedDataSource(object sender, EventArgs e)
{
try
{
this.sqlConnection1.ConnectionString = this.ReportParameters["@Conexion"].Value.ToString();
//Transfer the ReportParameter value to the parameter of the select command
this.sqlDataAdapter1.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["@Id_Emp"].Value;
this.sqlDataAdapter1.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["@Id_Cd"].Value;
this.sqlDataAdapter1.SelectCommand.Parameters["@Id_Frc"].Value = this.ReportParameters["@Folio"].Value;
//Take the Telerik.Reporting.Processing.Report instance and set the adapter as it's DataSource
Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
report.DataSource = this.sqlDataAdapter1;
// ---------------------------------------------------------------------------------------------
// Si se asigno correctamente el origen de datos, se actualiza el estatus de la orden de compra
// ---------------------------------------------------------------------------------------------
//actualiza estatus de orden de compra a Impreso (I)
int verificador = 0;
FacturaRevisionCobro facturaRevisionCobro = new FacturaRevisionCobro();
facturaRevisionCobro.Id_Emp = Convert.ToInt32(this.ReportParameters["@Id_Emp"].Value);
facturaRevisionCobro.Id_Cd = Convert.ToInt32(this.ReportParameters["@Id_Cd"].Value);
facturaRevisionCobro.Id_Frc = Convert.ToInt32(this.ReportParameters["@Folio"].Value);
facturaRevisionCobro.Frc_Estatus = "I";
new CN_CapFacturaRevisionCobro().ModificarEstatusFacturaRevisionCobro(facturaRevisionCobro, this.ReportParameters["@Conexion"].Value.ToString(), ref verificador);
}
catch (Exception ex)
{
throw ex;
}
}
private List <FacturaRevisionCobro> GetList()
{
try
{
Sesion sesion = (Sesion)Session["Sesion" + Session.SessionID];
listFacturaRevisionCobro = new List <FacturaRevisionCobro>();
FacturaRevisionCobro facturaRevisionCobro = new FacturaRevisionCobro();
facturaRevisionCobro.Id_Emp = sesion.Id_Emp;
facturaRevisionCobro.Id_Cd = sesion.Id_Cd_Ver;
int? objectInt = null;
DateTime?objectDateTime = null;
new CN_CapFacturaRevisionCobro().ConsultaFacturaRevisionCobro_Buscar(facturaRevisionCobro, ref listFacturaRevisionCobro, sesion.Emp_Cnx
, sesion.Propia ? sesion.Id_U : objectInt
, this.txtFecha1.SelectedDate == null ? objectDateTime : Convert.ToDateTime(this.txtFecha1.SelectedDate)
, this.txtFecha2.SelectedDate == null ? objectDateTime : Convert.ToDateTime(this.txtFecha2.SelectedDate)
, this.cmbEstatus.SelectedValue == "-1" ? string.Empty : this.cmbEstatus.SelectedValue
, this.txtFolio1.Text == string.Empty ? objectInt : Convert.ToInt32(this.txtFolio1.Text)
, this.txtFolio2.Text == string.Empty ? objectInt : Convert.ToInt32(this.txtFolio2.Text)
, this.txtCliente.Text == string.Empty ? objectInt : Convert.ToInt32(this.txtCliente.Text)
);
return(listFacturaRevisionCobro);
}
catch (Exception ex)
{
throw ex;
}
}
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_Sugerido(ref FacturaRevisionCobro facturaRevisionCobro, string Conexion)
{
try
{
new CD_CapFacturaRevisionCobro().ConsultarFacturaRevisionCobro_Sugerido(ref facturaRevisionCobro, Conexion);
}
catch (Exception ex)
{
throw ex;
}
}
public void ModificarEstatusFacturaRevisionCobro(FacturaRevisionCobro facturaRevisionCobro, string Conexion, ref int verificador)
{
try
{
new CD_CapFacturaRevisionCobro().ModificarEstatusFacturaRevisionCobro(facturaRevisionCobro, Conexion, ref verificador);
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertarFacturaRevisionCobro(ref FacturaRevisionCobro facturaRevisionCobro, string Conexion, ref int verificador)
{
try
{
new CD_CapFacturaRevisionCobro().InsertarFacturaRevisionCobro(ref facturaRevisionCobro, Conexion, ref verificador);
}
catch (Exception ex)
{
throw ex;
}
}
private void CancelarFacturaRevisionCobro(int Id_Emp, int Id_Cd, int Id_Frc)
{
Sesion sesion = (Sesion)Session["Sesion" + Session.SessionID];
FacturaRevisionCobro facturaRevisionCobro = new FacturaRevisionCobro();
int verificador = 0;
facturaRevisionCobro.Id_Emp = Id_Emp;
facturaRevisionCobro.Id_Cd = Id_Cd;
facturaRevisionCobro.Id_Frc = Id_Frc;
new CN_CapFacturaRevisionCobro().EliminarFacturaRevisionCobro(facturaRevisionCobro, sesion.Emp_Cnx, ref verificador);
this.rgFacturaRev.Rebind();
}
public void ConfirmarRevision(FacturaRevisionCobro FacturaRevisionCobro, ref int verificador, string Conexion, string dbname)
{
try
{
CD_GestorCobranza cd_cob = new CD_GestorCobranza();
cd_cob.ConfirmarRevision(FacturaRevisionCobro, ref verificador, Conexion, dbname);
}
catch (Exception ex)
{
throw ex;
}
}
private void ImpresionFacturaRevisionCobro(int Id_Emp, int Id_Cd, int Id_Frc)
{
try
{
Sesion sesion = (Sesion)Session["Sesion" + Session.SessionID];
ArrayList ALValorParametrosInternos = new ArrayList();
FacturaRevisionCobro facturaRevCob = new FacturaRevisionCobro();
facturaRevCob.Id_Emp = Id_Emp;
facturaRevCob.Id_Cd = Id_Cd;
facturaRevCob.Id_Frc = Id_Frc;
new CN_CapFacturaRevisionCobro().ConsultarFacturaRevisionCobro(ref facturaRevCob, sesion.Emp_Cnx);
ALValorParametrosInternos.Add(Id_Emp);
ALValorParametrosInternos.Add(Id_Cd);
ALValorParametrosInternos.Add(Id_Frc);
ALValorParametrosInternos.Add(facturaRevCob.Cd_Nombre);
ALValorParametrosInternos.Add(sesion.U_Nombre);
ALValorParametrosInternos.Add(DateTime.Now.ToShortDateString());
string horaActual = DateTime.Now.Hour.ToString();
string minActual = DateTime.Now.Minute.ToString();
string segActual = DateTime.Now.Second.ToString();
horaActual = string.Concat(horaActual, ":", minActual.Length == 1 ? string.Concat("0", minActual) : minActual);
horaActual = string.Concat(horaActual, ":", segActual.Length == 1 ? string.Concat("0", segActual) : segActual);
ALValorParametrosInternos.Add(horaActual);
ALValorParametrosInternos.Add(facturaRevCob.Frc_Entrego);
ALValorParametrosInternos.Add(facturaRevCob.Frc_Recibio);
ALValorParametrosInternos.Add(sesion.Emp_Cnx);
Type instance = null;
instance = typeof(LibreriaReportes.FacturaRevCobImpresion);
Session["InternParameter_Values" + Session.SessionID + HF_ClvPag.Value] = ALValorParametrosInternos;
Session["assembly" + Session.SessionID + HF_ClvPag.Value] = instance.AssemblyQualifiedName;
//NOTA: El estatus de impresión, lo pone cuando el reporte se carga
RAM1.ResponseScripts.Add("AbrirReporteCve('" + HF_ClvPag.Value + "');");
}
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;
}
}
public void ModificarFacturaRevisionCobro(ref FacturaRevisionCobro facturaRevisionCobro, string Conexion, ref int verificador)
{
CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(Conexion);
try
{
CapaDatos.StartTrans();
string[] Parametros =
{
"@Id_Emp"
, "@Id_Cd"
, "@Id_Frc"
, "@Id_Reg"
, "@Id_U"
, "@Frc_Entrego"
, "@Frc_Recibio"
, "@Frc_Fecha"
, "@Frc_FecEnvio"
, "@Frc_FecRecibio"
, "@Frc_Estatus"
};
object[] Valores =
{
facturaRevisionCobro.Id_Emp
, facturaRevisionCobro.Id_Cd
, facturaRevisionCobro.Id_Frc
, null //notaCredito.Id_Reg
, facturaRevisionCobro.Id_U
, facturaRevisionCobro.Frc_Entrego
, facturaRevisionCobro.Frc_Recibio
, facturaRevisionCobro.Frc_Fecha
, facturaRevisionCobro.Frc_FecEnvio
, facturaRevisionCobro.Frc_FecRecibio
, facturaRevisionCobro.Frc_Estatus
};
SqlCommand sqlcmd = CapaDatos.GenerarSqlCommand(
"spCapFacRevCob_Modificar", ref verificador, Parametros, Valores);
//facturaRevisionCobro.Id_Frc = verificador; //folio nuevo
// -----------------------------------------------------------------
// Insertar detalle de nota de credito
// -----------------------------------------------------------------
string[] ParametrosDet =
{
"@Id_Emp"
, "@Id_Cd"
, "@Id_Frc"
, "@Id_FrcDet"
, "@Id_Reg"
, "@Frc_Tipo"
, "@Frc_Doc"
, "@Frc_Fecha"
, "@Id_Cte"
, "@Frc_Importe"
, "@Frc_EnviarA"
};
int i = 1;
foreach (FacturaRevisionCobroDet facturaRevisionCobroDet in facturaRevisionCobro.ListaFacturaRevisionCobroDet)
{
facturaRevisionCobroDet.Id_FrcDet = i;
object[] ValoresDet =
{
facturaRevisionCobroDet.Id_Emp
, facturaRevisionCobroDet.Id_Cd
, facturaRevisionCobro.Id_Frc
, facturaRevisionCobroDet.Id_FrcDet
, null
, facturaRevisionCobroDet.Frc_Tipo
, facturaRevisionCobroDet.Frc_Doc
, facturaRevisionCobroDet.Frc_Fecha
, facturaRevisionCobroDet.Id_Cte
, facturaRevisionCobroDet.Frc_Importe
, facturaRevisionCobroDet.Frc_EnviarA
};
sqlcmd = CapaDatos.GenerarSqlCommand("spCapFacRevCobDetalle_Insertar", ref verificador, ParametrosDet, ValoresDet);
i += 1;
}
CapaDatos.CommitTrans();
CapaDatos.LimpiarSqlcommand(ref sqlcmd);
}
catch (Exception ex)
{
CapaDatos.RollBackTrans();
throw ex;
}
}
public void ConsultaFacturaRevisionCobro_Buscar(FacturaRevisionCobro facturaRevCob, ref List <FacturaRevisionCobro> listaFacturaRevCob, string Conexion
, int?Id_U
, DateTime?Frc_Fecha_inicio
, DateTime?Frc_Fecha_fin
, string Frc_Estatus
, int?Id_Frc_inicio
, int?Id_Frc_fin
, int?Id_Cte
)
{
try
{
SqlDataReader dr = null;
CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(Conexion);
string[] Parametros =
{
"@Id_Emp"
, "@Id_Cd"
, "@Id_U"
, "@Frc_Fecha_inicio"
, "@Frc_Fecha_fin"
, "@Frc_Estatus"
, "@Id_Frc_inicio"
, "@Id_Frc_fin"
, "@Id_Cte"
};
object[] Valores =
{
facturaRevCob.Id_Emp
, facturaRevCob.Id_Cd
, Id_U
, Frc_Fecha_inicio
, Frc_Fecha_fin
, Frc_Estatus == string.Empty ? null : Frc_Estatus
, Id_Frc_inicio
, Id_Frc_fin
, Id_Cte
};
SqlCommand sqlcmd = CapaDatos.GenerarSqlCommand("spCapFacRevCob_Buscar", ref dr, Parametros, Valores);
listaFacturaRevCob = new List <FacturaRevisionCobro>();
while (dr.Read())
{
facturaRevCob = new FacturaRevisionCobro();
facturaRevCob.Id_Emp = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Emp")));
facturaRevCob.Id_Cd = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Cd")));
facturaRevCob.Id_Frc = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("Id_Frc")));
facturaRevCob.Frc_Fecha = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("Frc_Fecha")));
facturaRevCob.Frc_Estatus = dr.GetValue(dr.GetOrdinal("Frc_Estatus")).ToString();
facturaRevCob.Frc_EstatusStr = dr.GetValue(dr.GetOrdinal("Frc_EstatusStr")).ToString();
facturaRevCob.Frc_Entrego = dr.GetValue(dr.GetOrdinal("Frc_Entrego")).ToString();
facturaRevCob.Frc_Recibio = dr.GetValue(dr.GetOrdinal("Frc_Recibio")).ToString();
listaFacturaRevCob.Add(facturaRevCob);
}
CapaDatos.LimpiarSqlcommand(ref sqlcmd);
}
catch (Exception ex)
{
throw ex;
}
}
