public List <vwct_cbtecble_Con_Saldo_Info> Get_list_ObtenerCbtecble_OG_otrosPagos(int IdEmpresa, decimal IdCbteCble, int IdTipoCbte, ref string MensajeError)
{
List <vwct_cbtecble_Con_Saldo_Info> lM = new List <vwct_cbtecble_Con_Saldo_Info>();
try
{
EntitiesDBConta OECbtecble_det = new EntitiesDBConta();
var select_ = from c in OECbtecble_det.vwct_cbtecble_Con_Saldo
join cc in OECbtecble_det.ct_cbtecble
on new { c.IdEmpresa, c.IdCbteCble, c.IdTipoCbte } equals new { cc.IdEmpresa, cc.IdCbteCble, cc.IdTipoCbte }
join cte in OECbtecble_det.ct_cbtecble_tipo
on new { c.IdEmpresa, c.IdTipoCbte } equals new { cte.IdEmpresa, cte.IdTipoCbte }
where c.IdEmpresa == IdEmpresa && c.IdTipoCbte == IdTipoCbte && c.IdCbteCble == IdCbteCble
select new
{
c.IdEmpresa,
c.IdTipoCbte,
c.IdCbteCble,
c.dc_Valor,
c.MontoOG,
c.SaldoDiario,
c.Detalle,
cc.cb_Observacion,
cte.tc_TipoCbte,
cc.cb_Fecha
};
foreach (var item in select_)
{
vwct_cbtecble_Con_Saldo_Info dato = new vwct_cbtecble_Con_Saldo_Info();
dato.Detalle = item.Detalle;
dato.IdCbteCble = item.IdCbteCble;
dato.IdEmpresa = item.IdEmpresa;
dato.IdTipoCbte = item.IdTipoCbte;
dato.MontoOG = item.MontoOG;
dato.Observacion = item.cb_Observacion;
dato.SaldoDiario = item.SaldoDiario;
dato.TipoCbte = item.tc_TipoCbte;
dato.ValorDiario = item.dc_Valor;
dato.Fecha = item.cb_Fecha;
dato.chek = true;
lM.Add(dato);
}
return(lM);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "",
"", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.ToString();
lM = new List <vwct_cbtecble_Con_Saldo_Info>();
throw new Exception(ex.ToString());
}
}
void LimpiarDatos()
{
try
{
Lst_OGP_I = new List <vwba_ordenGiroPendientes_Info>();
gridControl_OrdenGiro.DataSource = Lst_OGP_I;
gridCbte.DataSource = new List <vwct_cbtecble_Con_Saldo_Info>();
detCbt_I = null;
SaldoCblDisponible = 0;
txt_saldo.EditValue = 0;
txt_NCbte.Text = "";
txt_tipoCbte.Text = "";
lbl_NPago.Text = ".";
sumaOG = 0;
txt_SumOG.EditValue = 0;
txt_diferencia.EditValue = Convert.ToDecimal(txt_saldo.EditValue) - Convert.ToDecimal(txt_SumOG.EditValue);
btn_grabar.Enabled = true;
btn_grabarysalir.Enabled = true;
_Accion = Cl_Enumeradores.eTipo_action.grabar;
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void UltraGrid_OrdenGiroPagos_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
info = (vwct_cbtecble_Con_Saldo_Info)UltraGrid_OrdenGiroPagos.GetRow(e.FocusedRowHandle);
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void gridViewCbte_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
if (e.Column.FieldName == "chek")
{
(from q in Lst_OGP_I select q).ToList().ForEach(OD => { OD.chek = false; OD.valorAplicado = 0; OD.saldo = OD.saldo2; });
gridControl_OrdenGiro.DataSource = null;
foreach (var item in Lst_OGP_I)
{
item.valorAPagar = Math.Round(Convert.ToDouble(item.valorAPagar), 2);
item.saldo = Convert.ToDouble(Math.Round(Convert.ToDecimal(item.saldo), 2));
item.valorAplicado = Math.Round(Convert.ToDecimal(item.valorAplicado), 2);
}
gridControl_OrdenGiro.DataSource = Lst_OGP_I;
if (Convert.ToBoolean(gridViewCbte.GetRowCellValue(e.RowHandle, "chek")) == false)
{
for (int i = 0; i < gridViewCbte.RowCount; i++)
{
gridViewCbte.SetRowCellValue(i, "chek", false);
}
gridViewCbte.SetRowCellValue(gridViewCbte.GetFocusedDataSourceRowIndex(), "chek", true);
detCbt_I = (vwct_cbtecble_Con_Saldo_Info)gridViewCbte.GetRow(e.RowHandle);
SaldoCblDisponible = Convert.ToDecimal(detCbt_I.SaldoDiario);
txt_saldo.EditValue = Convert.ToDecimal(detCbt_I.SaldoDiario);
txt_NCbte.Text = detCbt_I.IdCbteCble.ToString();
txt_tipoCbte.Text = detCbt_I.TipoCbte.ToString();
}
else
{
gridViewCbte.SetRowCellValue(gridViewCbte.GetFocusedDataSourceRowIndex(), "chek", false);
detCbt_I = null;
SaldoCblDisponible = 0;
txt_saldo.EditValue = 0;
txt_NCbte.Text = "";
txt_tipoCbte.Text = "";
}
sumaOG = 0;
txt_SumOG.EditValue = 0;
txt_diferencia.EditValue = Convert.ToDecimal(txt_saldo.EditValue) - Convert.ToDecimal(txt_SumOG.EditValue);
}
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PrepararForm(Cl_Enumeradores.eTipo_action Accion, vwct_cbtecble_Con_Saldo_Info info)
{
try
{
frm = new frmCP_OrdenGiro_CanceXOtrosMoti();
frm.event_frmCP_OrdenGiro_CanceXOtrosMoti_FormClosing += new frmCP_OrdenGiro_CanceXOtrosMoti.delegate_frmCP_OrdenGiro_CanceXOtrosMoti_FormClosing(frm_event_frmCP_OrdenGiro_CanceXOtrosMoti_FormClosing);
frm.set_Accion(Accion);
frm.MdiParent = this.MdiParent;
if (!(Accion == Cl_Enumeradores.eTipo_action.grabar))
{
frm.set_CbteCble(info);
}
frm.Show();
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void set_CbteCble(vwct_cbtecble_Con_Saldo_Info info)
{
try
{
string MensajeError = "";
lbl_NPago.Text = "Pago de O.G. # " + info.IdCancelacion;
List <vwct_cbtecble_Con_Saldo_Info> consul = detCbt_B.Get_list_Cbtecble_OG_otrosPagos(info.IdEmpresa, info.IdCbteCble, info.IdTipoCbte, ref MensajeError);
foreach (var item in consul)
{
item.ValorDiario = Convert.ToDouble(Math.Round(Convert.ToDecimal(item.ValorDiario), 2));
item.MontoOG = Convert.ToDouble(Math.Round(Convert.ToDecimal(item.MontoOG), 2));
item.SaldoDiario = Convert.ToDouble(Math.Round(Convert.ToDecimal(item.SaldoDiario), 2));
}
gridCbte.DataSource = consul;
List <vwba_ordenGiroPendientes_Info> Consulta = CbtPagosOG_B.Get_List_PgCheque(info.IdEmpresa, info.IdTipoCbte, info.IdCbteCble);
foreach (var item in Consulta)
{
item.valorAPagar = Math.Round(Convert.ToDouble(item.valorAPagar), 2);
item.saldo = Convert.ToDouble(Math.Round(Convert.ToDecimal(item.saldo), 2));
item.valorAplicado = Math.Round(Convert.ToDecimal(item.valorAplicado), 2);
}
gridControl_OrdenGiro.DataSource = Consulta;
detCbt_I = info;
SaldoCblDisponible = Convert.ToDecimal(detCbt_I.SaldoDiario);
txt_saldo.EditValue = Convert.ToDecimal(detCbt_I.ValorDiario);
txt_SumOG.EditValue = Convert.ToDecimal(detCbt_I.MontoOG);
txt_diferencia.EditValue = Convert.ToDecimal(detCbt_I.SaldoDiario);
txt_NCbte.Text = detCbt_I.IdCbteCble.ToString();
txt_tipoCbte.Text = detCbt_I.TipoCbte.ToString();
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
