public override void OnLoad() { if (this.Registro != null) { this.Numero = System.Convert.ToInt32(m_Registro["numero"]); this.PV = System.Convert.ToInt32(m_Registro["pv"]); if (m_Registro["id_concepto"] != null) this.Concepto = new Lbl.Cajas.Concepto(this.Connection, this.GetFieldValue<int>("id_concepto")); else this.Concepto = null; if (m_Registro["concepto"] != null) this.ConceptoTexto = m_Registro["concepto"].ToString(); else this.ConceptoTexto = string.Empty; this.Cobros = new ColeccionDeCobros(); this.Pagos = new ColeccionDePagos(); // Cargo pagos asociados al registro // Pagos en efectivo using (System.Data.DataTable TablaPagos = Connection.Select("SELECT * FROM cajas_movim WHERE id_caja=" + Lfx.Workspace.Master.CurrentConfig.Empresa.CajaDiaria.ToString() + " AND id_recibo=" + Id.ToString())) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { decimal ImporteCaja = System.Convert.ToDecimal(Pago["importe"]); if (this.DePago && ImporteCaja < 0) { Pago Pg = new Pago(this.Connection, Lbl.Pagos.TiposFormasDePago.Efectivo, -ImporteCaja); Pg.Recibo = this; Pagos.Add(Pg); } else if (this.DePago == false && ImporteCaja > 0) { Cobro Cb = new Cobro(this.Connection, Lbl.Pagos.TiposFormasDePago.Efectivo, ImporteCaja); Cb.Recibo = this; Cobros.Add(Cb); } } } // Pagos con cheque using (System.Data.DataTable TablaPagos = this.Connection.Select("SELECT * FROM bancos_cheques WHERE (id_recibo=" + this.Id.ToString() + " OR id_recibo_pago=" + this.Id.ToString() + ")")) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { Bancos.Cheque Ch = new Lbl.Bancos.Cheque(Connection, (Lfx.Data.Row)Pago); if (this.DePago) Ch.ReciboPago = this; else Ch.ReciboCobro = this; if (this.DePago) Pagos.Add(new Pago(Ch)); else Cobros.Add(new Cobro(Ch)); } } // Pagos con Tarjetas de Crédito y Débito using (System.Data.DataTable TablaPagos = this.Connection.Select("SELECT id_cupon FROM tarjetas_cupones WHERE id_recibo=" + Id.ToString())) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { Pagos.Cupon Cp = new Pagos.Cupon(Connection, System.Convert.ToInt32(Pago["id_cupon"])); Cobros.Add(new Cobro(Cp)); } } // Acreditaciones en cuenta regular (excepto caja diaria) using (System.Data.DataTable TablaPagos = this.Connection.Select("SELECT * FROM cajas_movim WHERE auto=1 AND id_caja<>" + Lfx.Workspace.Master.CurrentConfig.Empresa.CajaDiaria.ToString() + " AND id_caja<>" + Lfx.Workspace.Master.CurrentConfig.Empresa.CajaCheques.ToString() + " AND id_recibo=" + this.Id.ToString())) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { if (this.DePago) { Pago Pg = new Pago(this.Connection, Lbl.Pagos.TiposFormasDePago.Caja, Math.Abs(System.Convert.ToDecimal(Pago["importe"]))); Pg.Recibo = this; Pg.CajaOrigen = new Cajas.Caja(Connection, System.Convert.ToInt32(Pago["id_caja"])); Pagos.Add(Pg); } else { Cobro Cb = new Cobro(this.Connection, Lbl.Pagos.TiposFormasDePago.Caja, System.Convert.ToDecimal(Pago["importe"])); Cb.Recibo = this; Cb.CajaDestino = new Cajas.Caja(Connection, System.Convert.ToInt32(Pago["id_caja"])); Cobros.Add(Cb); } } } // Otros valores using (System.Data.DataTable TablaPagos = this.Connection.Select("SELECT id_valor FROM pagos_valores WHERE id_recibo=" + Id.ToString())) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { Lbl.Pagos.Valor Vl = new Lbl.Pagos.Valor(Connection, System.Convert.ToInt32(Pago["id_valor"])); Vl.Recibo = this; if (this.DePago) Pagos.Add(new Pago(Vl)); else Cobros.Add(new Cobro(Vl)); } } } base.OnLoad(); }
public override void OnLoad() { if (this.Registro != null) { this.Numero = System.Convert.ToInt32(m_Registro["numero"]); this.PV = System.Convert.ToInt32(m_Registro["pv"]); if (m_Registro["id_concepto"] != null) { this.Concepto = new Lbl.Cajas.Concepto(this.Connection, this.GetFieldValue <int>("id_concepto")); } else { this.Concepto = null; } if (m_Registro["concepto"] != null) { this.ConceptoTexto = m_Registro["concepto"].ToString(); } else { this.ConceptoTexto = string.Empty; } this.Cobros = new ColeccionDeCobros(); this.Pagos = new ColeccionDePagos(); // Cargo pagos asociados al registro // Pagos en efectivo using (System.Data.DataTable TablaPagos = Connection.Select("SELECT * FROM cajas_movim WHERE id_caja=" + Lfx.Workspace.Master.CurrentConfig.Empresa.CajaDiaria.ToString() + " AND id_recibo=" + Id.ToString())) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { decimal ImporteCaja = System.Convert.ToDecimal(Pago["importe"]); if (this.DePago && ImporteCaja < 0) { Pago Pg = new Pago(this.Connection, Lbl.Pagos.TiposFormasDePago.Efectivo, -ImporteCaja); Pg.Recibo = this; Pagos.Add(Pg); } else if (this.DePago == false && ImporteCaja > 0) { Cobro Cb = new Cobro(this.Connection, Lbl.Pagos.TiposFormasDePago.Efectivo, ImporteCaja); Cb.Recibo = this; Cobros.Add(Cb); } } } // Pagos con cheque using (System.Data.DataTable TablaPagos = this.Connection.Select("SELECT * FROM bancos_cheques WHERE (id_recibo=" + this.Id.ToString() + " OR id_recibo_pago=" + this.Id.ToString() + ")")) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { Bancos.Cheque Ch = new Lbl.Bancos.Cheque(Connection, (Lfx.Data.Row)Pago); if (this.DePago) { Ch.ReciboPago = this; } else { Ch.ReciboCobro = this; } if (this.DePago) { Pagos.Add(new Pago(Ch)); } else { Cobros.Add(new Cobro(Ch)); } } } // Pagos con Tarjetas de Crédito y Débito using (System.Data.DataTable TablaPagos = this.Connection.Select("SELECT id_cupon FROM tarjetas_cupones WHERE id_recibo=" + Id.ToString())) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { Pagos.Cupon Cp = new Pagos.Cupon(Connection, System.Convert.ToInt32(Pago["id_cupon"])); Cobros.Add(new Cobro(Cp)); } } // Acreditaciones en cuenta regular (excepto caja diaria) using (System.Data.DataTable TablaPagos = this.Connection.Select("SELECT * FROM cajas_movim WHERE auto=1 AND id_caja<>" + Lfx.Workspace.Master.CurrentConfig.Empresa.CajaDiaria.ToString() + " AND id_caja<>" + Lfx.Workspace.Master.CurrentConfig.Empresa.CajaCheques.ToString() + " AND id_recibo=" + this.Id.ToString())) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { if (this.DePago) { Pago Pg = new Pago(this.Connection, Lbl.Pagos.TiposFormasDePago.Caja, Math.Abs(System.Convert.ToDecimal(Pago["importe"]))); Pg.Recibo = this; Pg.CajaOrigen = new Cajas.Caja(Connection, System.Convert.ToInt32(Pago["id_caja"])); Pagos.Add(Pg); } else { Cobro Cb = new Cobro(this.Connection, Lbl.Pagos.TiposFormasDePago.Caja, System.Convert.ToDecimal(Pago["importe"])); Cb.Recibo = this; Cb.CajaDestino = new Cajas.Caja(Connection, System.Convert.ToInt32(Pago["id_caja"])); Cobros.Add(Cb); } } } // Otros valores using (System.Data.DataTable TablaPagos = this.Connection.Select("SELECT id_valor FROM pagos_valores WHERE id_recibo=" + Id.ToString())) { foreach (System.Data.DataRow Pago in TablaPagos.Rows) { Lbl.Pagos.Valor Vl = new Lbl.Pagos.Valor(Connection, System.Convert.ToInt32(Pago["id_valor"])); Vl.Recibo = this; if (this.DePago) { Pagos.Add(new Pago(Vl)); } else { Cobros.Add(new Cobro(Vl)); } } } } base.OnLoad(); }
public Cobro(Pagos.Cupon cupon) : this(cupon.Connection, cupon.FormaDePago) { this.Cupon = cupon; }