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