public AbonoBanco()
{
InitializeComponent();
AbonoForm = this;
objBancoDAO = new BancoDAO();
objComboBanco = new CuentaBanco();
objBancoDatos = new CuentaBanco();
objMonedaDao = new MonedaDAO();
objAbonoBancoDet = new AbonoBancoDet();
objAbonoBancoCab = new AbonoBancoCab();
objFacturaAbono = new FacturaAbono();
objAsientoDAO = new AsientoDAO();
objAsiento = new Asiento();
objAsientoDetalle = new AsientoDetalle();
cargarCmbBanco();
cmb_Banco.SelectedIndexChanged += Cmb_Banco_SelectedIndexChanged;
txt_Fecha.Text = DateTime.Now.ToString("dd/MM/yyyy");
objComboBanco = (CuentaBanco)cmb_Banco.SelectedItem;
objBancoDatos = objBancoDAO.listarBancoDatos(Ventas.UNIDADNEGOCIO, objComboBanco.Codigo, objComboBanco.Descripcion);
txt_Cuenta.Text = objBancoDatos.Cuenta;
txt_Moneda.Text = objBancoDatos.Moneda;
txt_Tcambio.Text = objMonedaDao.getTipoCambioVenta(DateTime.Now.ToShortDateString()).ToString().PadRight(5, '0');;
txt_MonedaCod.Text = objBancoDatos.MonedaCod;
//gridParams();
grd_Detalle.CellClick += Grd_Detalle_CellClick;
}
public String insertAbonoDet(AbonoBancoDet obj, int id)
{
Database db = DatabaseFactory.CreateDatabase("Conta");
DbCommand dbCommand = db.GetStoredProcCommand("sp_insertAbonoDet",
new object[] { id, obj.Serie, obj.Numero, obj.Importe });
try
{
db.ExecuteScalar(dbCommand);
if (obj.Tabla == "A")
{
updateSaldoAntiguo(obj.Serie, obj.Numero, Math.Round(obj.Importe, 2));
}
else
{
updateSaldoNuevo(obj.Serie, obj.Numero, obj.Importe);
}
return("true");
}
catch (Exception ex)
{
return(ex.Message);
}
}
private void Grd_Detalle_CellClick(object sender, DataGridViewCellEventArgs e)
{
index = grd_Detalle.SelectedCells[0].RowIndex;
objAbonoBancoDet = objListaAbonoBancoDet[index];
txt_Importe.Text = objAbonoBancoDet.Importe.ToString();
txt_NroDoc.Text = objAbonoBancoDet.Numero.ToString();
txt_Serie.Text = objAbonoBancoDet.Serie.ToString();
}
public void setDatos(List <FacturaAbono> objList)
{
objListaAbonoBancoDet = new List <AbonoBancoDet>();
if (grd_Detalle.Columns.Count > 1)
{
grd_Detalle.Columns.RemoveAt(0);
grd_Detalle.Columns.RemoveAt(0);
grd_Detalle.Columns.RemoveAt(0);
}
objListaFacturaAbono = objList;
grd_Detalle.AutoGenerateColumns = false;
DataGridViewTextBoxColumn idColumn1 = new DataGridViewTextBoxColumn();
idColumn1.Name = "Serie";
idColumn1.DataPropertyName = "Serie";
idColumn1.Width = 100;
grd_Detalle.Columns.Add(idColumn1);
DataGridViewTextBoxColumn idColumn2 = new DataGridViewTextBoxColumn();
idColumn2.Name = "Número";
idColumn2.DataPropertyName = "Numero";
idColumn2.Width = 100;
grd_Detalle.Columns.Add(idColumn2);
DataGridViewTextBoxColumn idColumn3 = new DataGridViewTextBoxColumn();
idColumn3.Name = "Importe";
idColumn3.DataPropertyName = "Importe";
idColumn3.Width = 120;
grd_Detalle.Columns.Add(idColumn3);
for (int i = 0; i < objListaFacturaAbono.Count; i++)
{
objAbonoBancoDet = new AbonoBancoDet();
objAbonoBancoDet.Serie = objListaFacturaAbono[i].Serie;
objAbonoBancoDet.Numero = objListaFacturaAbono[i].Numero;
if (txt_MonedaCod.Text == "USD")
{
objAbonoBancoDet.Importe = objListaFacturaAbono[i].ImporteDolares;
}
else
{
objAbonoBancoDet.Importe = objListaFacturaAbono[i].ImporteSoles;
}
objListaAbonoBancoDet.Add(objAbonoBancoDet);
}
grd_Detalle.DataSource = objListaAbonoBancoDet;
grd_Detalle.Refresh();
}
private void btn_Guardar_Click(object sender, EventArgs e)
{
objAbonoBancoDet = new AbonoBancoDet();
objAbonoBancoDet.Serie = txt_Serie.Text;
objAbonoBancoDet.Numero = txt_NroDoc.Text;
objAbonoBancoDet.Importe = objBancoDAO.convertToDouble(txt_Importe.Text);
objAbonoBancoDet.Tabla = txt_Tabla.Text;
objListaAbonoBancoDet[index] = objAbonoBancoDet;
habilitarCampos(false, true);
limpiaCampos();
listAbonoDet(objListaAbonoBancoDet);
cmb_Banco.Enabled = false;
operacion = "Q";
}
