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; } }