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