public void Actualizar() { try { Item = null; Items = null; if (LView != null) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@FecIni", FilterValue = F_FecIni, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@FecFin", FilterValue = F_FecFin, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@Tipo", FilterValue = F_TipoResultado, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 1 }); Items = Client.GetDTCtaCte("CAJ_REPOSS_DocOtrosTraficos", listFilters); LView.ShowItems(); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void Actualizar() { try { Item = null; Items = null; if (LView != null) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@F_TIPO_Flujo", FilterValue = F_TIPO_Flujo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 1 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@F_TIPO_Movimiento", FilterValue = F_TIPO_Movimiento, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 1 }); Items = Client.GetAllFlujoFilter("CAJ_FLUJSS_Todos_ByFilters", _listFilters); LView.ShowItems(); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void CargarProspectos() { try { if (ItemEjecutivoActual != null) { if (FechaAsignacion.HasValue) { if (ItemAgenteCarga != null) { Items = Client.GetAllProspectosByEjecutivo(Controls.Entorno.ItemEmpresa.EMPR_Codigo, Controls.Entorno.ItemSucursal.SUCR_Codigo, ItemEjecutivoActual.ENTC_Codigo, ItemAgenteCarga.ENTC_Codigo, FechaAsignacion.Value, null, null); } else { Items = Client.GetAllProspectosByEjecutivo(Controls.Entorno.ItemEmpresa.EMPR_Codigo, Controls.Entorno.ItemSucursal.SUCR_Codigo, ItemEjecutivoActual.ENTC_Codigo, null, FechaAsignacion.Value, null, null); } LView.ShowItems(true); } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar una Fecha de Asignación."); LView.ShowItems(false); } } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar un Ejecutivo."); LView.ShowItems(false); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error al cargar los prospectos.", ex); } }
public void CargarReporte(Nullable <DateTime> CCOT_FechaDesde, Nullable <DateTime> CCOT_FechaHasta, Nullable <Int32> ENTC_CodCliente, Nullable <Int32> ENTC_CodTransportista, String TIPO_TabCDT, String TIPO_CodCDT, String TIPO_TabTRF, String TIPO_CodTRF, Nullable <Int32> PUER_Codigo) { try { if (CCOT_FechaDesde.HasValue) { if (CCOT_FechaHasta.HasValue) { DTReporte = Client.GetAllCab_Cotizacion_OVReporteFletamiento(CCOT_FechaDesde.Value, CCOT_FechaHasta.Value, ENTC_CodCliente, ENTC_CodTransportista, TIPO_TabCDT, TIPO_CodCDT, TIPO_TabTRF, TIPO_CodTRF, PUER_Codigo); if (DTReporte != null && DTReporte.Rows.Count > 0) { LView.ShowItems(); } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "No se encontraron resultados."); } } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar la fecha Hasta."); } } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar la fecha Desde."); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); } }
public void Actualizar() { try { Item = null; Items = null; if (LView != null) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrCABP_Ano", FilterValue = F_CABP_Ano, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 4 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pvchCABP_Codigo", FilterValue = F_CABP_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 3 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrTIPO_CodREG", FilterValue = F_TIPO_CodREG, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 3 }); Items = Client.GetAllCabPerfilAsientosFilter("CON_CABPSS_TodosBusqueda", _listFilters); LView.ShowItems(); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void CargarReporte(Nullable <DateTime> FEC_IniConcluye, Nullable <DateTime> FEC_FinConcluye, String DOOV_HBL, String CCOT_NumDoc, Nullable <Int32> ENTC_Ejecutivo, Nullable <Int32> ENTC_Cliente) { try { DTReporte = new System.Data.DataTable(); Int16 EMPR_Codigo = Delfin.Controls.Entorno.ItemEmpresa.EMPR_Codigo; Int16 SUCR_Codigo = Delfin.Controls.Entorno.ItemSucursal.SUCR_Codigo; //DTReporte = Client.GetAllCab_Cotizacion_OVByProfitNegativo String _mensaje = String.Empty; DTReporte = Client.GetAllCab_Cotizacion_OVByComEjecutivo(EMPR_Codigo, SUCR_Codigo, FEC_IniConcluye, FEC_FinConcluye, DOOV_HBL, CCOT_NumDoc, ENTC_Ejecutivo, ENTC_Cliente, ref _mensaje); if (!String.IsNullOrEmpty(_mensaje)) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Ha ocurrido un error cargando el reporte.", _mensaje); } else if (DTReporte != null && DTReporte.Rows.Count > 0) { LView.FormatDataGrid(); LView.ShowItems(DTReporte); } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "No se encontraron resultados."); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); } }
public void Actualizar() { try { Items = null; if (LView != null) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@psinEMPR_Codigo", FilterValue = Controls.Entorno.ItemEmpresa.EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 2 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrPLAN_Tipo", FilterValue = Planillas.GetTipoPlanilla(TPlanilla), FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 3 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@FecIni", FilterValue = F_FecIni, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@FecFin", FilterValue = F_FecFin, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); Items = Client.GetAllPlanillasFilter("CAJ_PLANSS_Todos", _listFilters); LView.ShowItems(); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void AsignarEjecutivo() { try { if (ItemEjecutivo != null) { ObservableCollection <Prospecto> _itemsSeleccionados = Items.Where(pros => pros.PROS_Asignar).ToObservableCollection(); foreach (Prospecto _itemSeleccionado in _itemsSeleccionados) { _itemSeleccionado.ENTC_CodEjecutivo = ItemEjecutivo.ENTC_Codigo; _itemSeleccionado.ENTC_NomCompletoEjecutivo = ItemEjecutivo.ENTC_NomCompleto; } Int16 _EMPR_Codigo = Controls.Entorno.ItemEmpresa.EMPR_Codigo; Int16 _SUCR_Codigo = Controls.Entorno.ItemSucursal.SUCR_Codigo; DateTime _PROS_FecAsignacion = DateTime.Now; String _AUDI_Usuario = "NEXTSOFT"; Client.AsignarProspectos(_itemsSeleccionados.ToTableValuedParameter(), _EMPR_Codigo, _SUCR_Codigo, _PROS_FecAsignacion, _AUDI_Usuario); Items = Items.Where(pros => !pros.PROS_Asignar).ToObservableCollection(); LView.ShowItems(true); } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar un Ejecutivo."); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error al asignar el Ejecutivo.", ex); } }
public void Actualizar() { try { Item = null; Items = null; if (LView != null) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@psinEMPR_Codigo", FilterValue = Controls.Entorno.ItemEmpresa.EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 2 }); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pintTRAN_Codigo", FilterValue = F_TRAN_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 10 }); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pdtmTRAN_Fecha_Ini", FilterValue = F_FecIni, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pdtmTRAN_Fecha_Fin", FilterValue = F_FecFin, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); Items = Client.GetAllTransferenciaFilter("CAJ_TRANSS_TodosBusqueda", listFilters); LView.ShowItems(); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void CargarReporte(String x_REBA_Tipo, ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> x_filters)//(Nullable<Int32> ENTC_CodTransportista, Nullable<Int32> ENTC_CodCliente, Nullable<DateTime> FEC_IniEmbarque, Nullable<DateTime> FEC_FinEmbarque, Nullable<DateTime> FEC_IniLlegada, Nullable<DateTime> FEC_FinLlegada, String NRO_HBL, String NRO_OV) { try { DTReporte = new System.Data.DataTable(); Int16 EMPR_Codigo = Delfin.Controls.Entorno.ItemEmpresa.EMPR_Codigo; Int16 SUCR_Codigo = Delfin.Controls.Entorno.ItemSucursal.SUCR_Codigo; String _mensaje = String.Empty; DTReporte = Client.GetAllCab_Cotizacion_OVByReporteRebateHapagHamburg(x_REBA_Tipo, x_filters, ref _mensaje);//(EMPR_Codigo,SUCR_Codigo,ENTC_CodTransportista, ENTC_CodCliente, FEC_IniEmbarque, FEC_FinEmbarque, FEC_IniLlegada, FEC_FinLlegada, NRO_HBL, NRO_OV, ref _mensaje); if (!String.IsNullOrEmpty(_mensaje)) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Ha ocurrido un error cargando el reporte.", _mensaje); } else if (DTReporte != null && DTReporte.Rows.Count > 0) { LView.FormatDataGrid(); LView.ShowItems(DTReporte); } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "No se encontraron resultados."); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); } }
public void Actualizar() { try { Item = null; Items = null; String CONS_TabVia = null; String CONS_CodVia = null; String CONS_TabRGM = null; String CONS_CodRGM = null; String CONS_TabLNG = null; String CONS_CodLNG = null; String SERV_TipoMov = null; Boolean SERV_AfeIgv = false; if (FILTROItemIGV != null) { SERV_AfeIgv = FILTROItemIGV; } Boolean SERV_AfeDet = false; if (FILTROItemDetraccion != null) { SERV_AfeDet = FILTROItemDetraccion; } if (FILTROItemRegimen != null) { CONS_TabRGM = FILTROItemRegimen.CONS_CodTabla; CONS_CodRGM = FILTROItemRegimen.CONS_CodTipo; } if (FILTROItemVia != null) { CONS_TabVia = FILTROItemVia.CONS_CodTabla; CONS_CodVia = FILTROItemVia.CONS_CodTipo; } if (FILTROItemLineaNegocio != null) { CONS_TabLNG = FILTROItemLineaNegocio.CONS_CodTabla; CONS_CodLNG = FILTROItemLineaNegocio.CONS_CodTipo; } if (FILTROItemTipoServicio != null) { SERV_TipoMov = FILTROItemTipoServicio.CONS_CodTipo; } Items = Client.GetAllServicioByFiltros(true, CONS_TabVia, CONS_CodVia, CONS_TabRGM, CONS_CodRGM, CONS_TabLNG, CONS_CodLNG, SERV_TipoMov, SERV_AfeIgv, SERV_AfeDet); LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void Buscar(DateTime FecEmi_Desde, DateTime FecEmi_Hasta, DateTime FecArr_Desde, DateTime FecArr_Hasta, String HBL, String MBL, Int32 CodCliente, Int32 LineaN, Int32 DepTemporal, Int16 Nave) { try { _dtDireccionamiento = Client.GetAllCab_Direccionamiento(FecEmi_Desde, FecEmi_Hasta, FecArr_Desde, FecArr_Hasta, HBL, MBL, CodCliente, LineaN, DepTemporal, Nave); LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, Infrastructure.Aspect.Constants.Mensajes.LoadPresenter, ex); } }
public void LimpiarReporte() { try { DTReporte = new System.Data.DataTable(); LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error limpiando el reporte.", ex); } }
public void CargarXLS() { try { OpenFileDialog ofdialog = new OpenFileDialog(); //ofdialog.InitialDirectory = "c:\\"; ofdialog.Filter = "Archivos de Excel (*.xls)|*.xls|Archivos de Excel (*.xlsx)|*.xlsx"; ofdialog.FilterIndex = 2; String Archivo = "", MensajeConciliacion = ""; //ofdialog.RestoreDirectory = true; if (ofdialog.ShowDialog() == DialogResult.OK) { Archivo = Path.GetFileName(ofdialog.FileName); ImportarExcel excel = new ImportarExcel(); String _message = ""; System.Data.DataTable DataTableImportacion = excel.ReadExcel(ofdialog.FileName, 5, 1000, ref _message); foreach (System.Data.DataRow item in DataTableImportacion.Rows) { #region Validar Nro de Operación String _nroOperacion = ""; Int32 _value = 0; if (Int32.TryParse(item[4].ToString(), out _value)) { _nroOperacion = _value.ToString("########"); } else { _nroOperacion = item[4].ToString(); } Entities.Movimiento _movi = Items.Where(Movi => !String.IsNullOrEmpty(Movi.MOVI_NroOperacion) && Movi.MOVI_NroOperacion.Contains(_nroOperacion) && !Movi.Seleccionar).FirstOrDefault(); if (_movi != null) { MensajeConciliacion += String.Format("- Se concilio el Nro de Operación: {1}, con el movimiento de banco con codigo interno {2} .{0}", Environment.NewLine, _movi.MOVI_NroOperacion, _movi.MOVI_Codigo); _movi.Seleccionar = true; _movi.CONC_MontoBCO = _movi.Monto; _movi.CONC_FecConciliacion = Fecha; _movi.ItemConciliacion.CONC_MontoBCO = _movi.CONC_MontoBCO; _movi.ItemConciliacion.CONC_FecConciliacion = _movi.CONC_FecConciliacion; } #endregion } Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeSatisfactorio(Title, String.Format("Se realizo la conciliación del archivo: {0}", Archivo)); LView.ShowConciliacion(MensajeConciliacion); LView.ShowItems(); } } catch (Exception) { throw; } }
public void Actualizar() { try { ItemCajaCuentas = null; ItemsCajaCuentas = null; _DT = Client.GetAllCajaCuentas(); LView.ShowItems(); } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void Actualizar() { try { Item = null; Items = null; if (LView != null) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@psinEMPR_Codigo", FilterValue = Controls.Entorno.ItemEmpresa.EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrCUBA_Codigo", FilterValue = F_CUBA_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 3 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pvchCONC_Periodo", FilterValue = F_CONC_Periodo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 10 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@FecIni", FilterValue = F_FecIni, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@FecFin", FilterValue = F_FecFin, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); Items = Client.GetAllMovimientoFilter("CAJ_MOVISS_TodosConciliacion", _listFilters); if (Items != null) { foreach (Entities.Movimiento iMov in Items) { iMov.ItemConciliacion = new Conciliacion(); iMov.ItemConciliacion.EMPR_Codigo = iMov.EMPR_Codigo; iMov.ItemConciliacion.MOVI_Codigo = iMov.MOVI_Codigo; iMov.ItemConciliacion.CONC_Codigo = iMov.CONC_Codigo; iMov.ItemConciliacion.CONC_MontoBCO = iMov.CONC_MontoBCO; iMov.ItemConciliacion.CONC_Periodo = iMov.CONC_Periodo; iMov.ItemConciliacion.CONC_FecConciliacion = iMov.CONC_FecConciliacion; } } LView.ShowItems(); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
/// <summary> /// Realiza la busqueda de registros del LView /// </summary> public void Actualizar() { try { Item = null; Items = null; if (LView != null) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@psinEMPR_Codigo", FilterValue = Controls.Entorno.ItemEmpresa.EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 22 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@psinSUCR_Codigo", FilterValue = SUCR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 22 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrCUBA_Codigo", FilterValue = CUBA_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 3 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrCUBA_TipoCuenta", FilterValue = CUBA_TipoCuenta, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 1 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pbitCUBA_Bloqueo", FilterValue = CUBA_Bloqueo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Boolean, FilterSize = 1 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@FecIni", FilterValue = FecIni, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@FecFin", FilterValue = FecFin, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); Items = Client.GetAllCuentasBancariasFilter("CAJ_CUBASS_Busqueda", _listFilters); if (Items == null || Items.Count == 0) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "No se encontraron coincidencias "); } LView.ShowItems(); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void LimpiarReporteOrdenVentaExpo() { try { ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptCOM007OrdenVentaExpo.rdlc"; this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[37]; LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error limpiando el reporte.", ex); } }
public void Actualizar() { try { ItemCab_Seguimientos = null; ItemsCab_Seguimientos = null; LView.FiltrosLView(); ItemsCab_Seguimientos = Client.GetAllByCabSeguimientoByFiltros(FILTRO_FecEmiDesde, FILTRO_FecEmiHasta, FILTRONave); LView.ShowItems(); } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void Actualizar() { try { Item = null; Items = null; Items = Client.GetAllContrato(Delfin.Controls.Entorno.ItemEmpresa.EMPR_Codigo); LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void Actualizar() { try { Item = null; Items = null; Items = Client.GetAllSucursales(); LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void CargarReporte(String CONS_TabRGM, String CONS_CodRGM, String CONS_TabVIA, String CONS_CodVIA, DateTime CONT_FecEmiDesde, DateTime CONT_FecEmiHasta, Nullable <Int32> ENTC_CodTransportista, Nullable <Int32> PUER_CodOrigen, Nullable <Int32> PUER_CodDestino) { try { DTReporte = Client.GetAllCab_Cotizacion_OVByReporteOV(Delfin.Controls.Entorno.ItemEmpresa.EMPR_Codigo, Delfin.Controls.Entorno.ItemSucursal.SUCR_Codigo, CONS_TabRGM, CONS_CodRGM, CONS_TabVIA, CONS_CodVIA, CONT_FecEmiDesde, CONT_FecEmiHasta, ENTC_CodTransportista, PUER_CodOrigen, PUER_CodDestino); if (DTReporte != null && DTReporte.Rows.Count > 0) { foreach (System.Data.DataColumn column in DTReporte.Columns) { column.AllowDBNull = true; } Int32 Numero = 0; Int16 Item = 0; foreach (System.Data.DataRow row in DTReporte.Rows) { Int32 _Numero = 0; Int16 _Item = 0; if (Int32.TryParse(row["NUMERO"].ToString(), out _Numero)) { if (Numero == _Numero) { row["ORDEN VENTA"] = DBNull.Value; row["FECHA EMISISON"] = DBNull.Value; row["PUERTO ORIGEN"] = DBNull.Value; row["PUERTO DESTINO"] = DBNull.Value; row["TRANSPORTISTA"] = DBNull.Value; row["EJECUTIVO"] = DBNull.Value; } else { Numero = _Numero; } } } DTReporte.Columns.Remove("NUMERO"); DTReporte.Columns.Remove("ITEM"); LView.ShowItems(); } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "No se encontraron resultados."); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); } }
public void Actualizar() { try { Item = null; Items = null; if (FILTRO_ENTC_CodTransportista != null) { if (!String.IsNullOrEmpty(FILTRO_REBA_Tipo)) { if (FILTRO_REBA_FecIni != null) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _filters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _filters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pintENTC_CodTransportista", FilterValue = FILTRO_ENTC_CodTransportista, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4 }); _filters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrREBA_Tipo", FilterValue = FILTRO_REBA_Tipo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 1 }); _filters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pdtmREBA_FecIni", FilterValue = FILTRO_REBA_FecIni, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); Items = Client.GetAllGRRFilter("COM_REBASS_Todos", _filters); } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe ingresar Fecha de Inicio."); } } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar el tipo."); } } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Debe seleccionar un transportista."); } LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void Sincronizar(System.Data.DataTable x_FleteCostoExcel) { try { DS_Resultado = new System.Data.DataSet(); DS_Resultado = Client.OPE_CCOTSS_ComparaFleteCosto(x_FleteCostoExcel); DT_NoEncontrados = new System.Data.DataTable(); DT_NoEncontrados = DS_Resultado.Tables[0]; DT_Diferentes = new System.Data.DataTable(); DT_Diferentes = DS_Resultado.Tables[1]; LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando el reporte.", ex); } }
public void Actualizar() { try { Item = null; Items = null; Items = Client.GetAllResultGestion(); // if (ItemTabla != null) // { Items = Client.GetAllByRESGCodigo(ItemTabla.RESGCodigo); } LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void Actualizar() { try { ItemLView = null; ItemCAB_Tarifa = null; ItemsCAB_Tarifa = null; LView.FiltrosLView(); ItemsCAB_Tarifa = Client.GetAllByFiltrosTarifario(FILTROLineaNaviera, FILTROAgMaritimo, FILTRODepTemporal, FILTRODepVacio, FILTROAgAduana, FILTROTransporte, FILTRO_FecEmiDesde, FILTRO_FecEmiHasta, TipoTarifa); LView.ShowItems(); } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void Actualizar() { try { ItemCab_Tarjas = null; ItemsCab_Tarjas = null; LView.FiltrosLView(); FiltroFecIni = DateTime.Now; FiltroFecFin = DateTime.Now; ItemsCab_Tarjas = Client.GetAllTarjasPorFiltros(FiltroFecIni, FiltroFecFin); LView.ShowItems(); } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void CargarReporte(String x_TipoConsulta, String x_NumeroOV, Nullable <Int32> x_NumeroViaje, Boolean x_ChangeControl) { try { System.Data.DataTable DTConultaServicio = new System.Data.DataTable(); ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pvchNVIA_Codigo", FilterValue = x_NumeroViaje, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 50 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pvchCCOT_NumDoc", FilterValue = x_NumeroOV, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 20 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pbitSCOT_ChageControl", FilterValue = x_ChangeControl, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Boolean, FilterSize = 4 }); DTConultaServicio = Client.GetDTAnexos("COM_SCOTSS_Consulta_Servicios", _listFilters); if (DTConultaServicio != null && DTConultaServicio.Rows.Count > 0) { //Si solo tiene una columna es el mensaje de Error if (DTConultaServicio.Columns["MENSAJE_ERROR"] != null) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "Faltan ingresar Tipo de Cambio", DTConultaServicio.Rows[0]["MENSAJE_ERROR"].ToString()); } else { ReportPath = System.Windows.Forms.Application.StartupPath + @"\Reportes\rptOPE005ConsultaServicios.rdlc"; RepDataSource = new Microsoft.Reporting.WinForms.ReportDataSource(); RepDataSource.Name = "DTConsultaServicios"; RepDataSource.Value = DTConultaServicio; this.Parameters = new Microsoft.Reporting.WinForms.ReportParameter[1]; Parameters[0] = new Microsoft.Reporting.WinForms.ReportParameter("TReporte", x_TipoConsulta); LView.ShowItems(); } } else { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeInformacion(Title, "No se encontraron resultados."); } } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error cargando la consulta.", ex); } }
public void Actualizar() { try { Item = null; Items = null; if (ItemTabla != null) { Items = Client.GetAllTiposByTipoCodTabla(ItemTabla.TIPO_CodTipo); } LView.ShowItems(); } catch (Exception ex) { Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }
public void Actualizar() { try { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pvchDOCV_Numero", FilterValue = F_NroNotaCreditoFiltro, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 20 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pvchDOCV_NumeroPadre", FilterValue = F_NroFacturaFiltro, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 20 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrTIPO_TabTDO", FilterValue = "TDO", FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 3 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrTIPO_CodTDO", FilterValue = "007", FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Char, FilterSize = 3 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pintENTC_Codigo", FilterValue = F_Entc_CodigoFiltro, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pdtmDOCV_FechaEmisionIni", FilterValue = F_FecEmisionIniFiltro, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pdtmDOCV_FechaEmisionFin", FilterValue = F_FecEmisionFinFiltro, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.DateTime, FilterSize = 8 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pvchDOCV_Serie", FilterValue = F_DOCV_Serie, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 10 }); ItemsNotaCreditoDS = Client.GetDSDocsVta("VEN_DOCV_ByFilters", _listFilters); LView.FiltrosLView(); LView.ShowItems(); } catch (Exception ex) { Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); } }