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