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
{
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 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
{
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); }
}
public void Actualizar()
{
try
{
ItemMovimiento = null;
_DT = null;
LView.FiltrosLView();
ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>();
_listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL()
{
FilterName = "psinEMPR_CODIGO", FilterValue = Session.EmpresaCodigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 22
});
_DT = Client.GetDTMovimiento("", _listFilters);
LView.ShowItems();
}
catch (Exception ex)
{ Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); }
}
public void Actualizar(bool ActualizarBaseDatos = true)
{
try
{
if (ActualizarBaseDatos)
{
ItemLView = null;
ItemCtaCte = null;
ItemsCtaCte = null;
LView.FiltrosLView();
_DT = Client.GetCtaCteFiltros(CCCT_Desde, CCCT_Hasta, ENTC_Codigo, TipoFiltroFechas);
}
else
{
if (ItemCtaCte.Instance == InstanceEntity.Added)
{
if (_DT == null)
{
_DT = new DataTable();
_DT.Columns.Add(new DataColumn("EMPR_Codigo", typeof(Int16)));
_DT.Columns.Add(new DataColumn("CCCT_Codigo", typeof(Int32)));
_DT.Columns.Add(new DataColumn("CCCT_FechaEmision", typeof(DateTime)));
_DT.Columns.Add(new DataColumn("CCCT_Serie", typeof(String)));
_DT.Columns.Add(new DataColumn("CCCT_Numero", typeof(String)));
_DT.Columns.Add(new DataColumn("CCCT_ValVta", typeof(Decimal)));
_DT.Columns.Add(new DataColumn("CCCT_Imp1", typeof(Decimal)));
_DT.Columns.Add(new DataColumn("ENTC_Codigo", typeof(Int32)));
_DT.Columns.Add(new DataColumn("CCCT_Monto", typeof(Decimal)));
_DT.Columns.Add(new DataColumn("COPE_NumDoc", typeof(String)));
_DT.Columns.Add(new DataColumn("COPE_HBL", typeof(String)));
_DT.Columns.Add(new DataColumn("ENTC_CodCliente", typeof(Int32)));
_DT.Columns.Add(new DataColumn("COPE_Estado", typeof(String)));
_DT.Columns.Add(new DataColumn("TIPO_Moneda", typeof(String)));
_DT.Columns.Add(new DataColumn("TIPO_Documento", typeof(String)));
_DT.Columns.Add(new DataColumn("Proveedor", typeof(String)));
_DT.Columns.Add(new DataColumn("CCCT_Saldo", typeof(Decimal)));
_DT.Columns.Add(new DataColumn("Cliente", typeof(String)));
_DT.Columns.Add(new DataColumn("CCCT_FecReg", typeof(DateTime)));
_DT.Columns.Add(new DataColumn("TIPO", typeof(String)));
_DT.Columns.Add(new DataColumn("SERVICIO", typeof(String)));
_DT.Columns.Add(new DataColumn("Detraccion", typeof(String)));
}
DataRow NuevoRegistro = _DT.NewRow();
DataTable DT = Client.GetOneCtaCteDT(Entorno.ItemEmpresa.EMPR_Codigo, ItemCtaCte.CCCT_Codigo);
if (DT != null)
{
for (int i = 0; i < _DT.Columns.Count; i++)
{
NuevoRegistro[_DT.Columns[i].ColumnName] = DT.Rows[0][_DT.Columns[i].ColumnName];
}
_DT.Rows.Add(NuevoRegistro);
}
}
else if (ItemCtaCte.Instance == InstanceEntity.Modified)
{
var ItemResultado = _DT.Select("CCCT_Codigo =" + ItemCtaCte.CCCT_Codigo);
if (ItemResultado != null)
{
Position = _DT.Rows.IndexOf(ItemResultado[0]);
var Result = Client.GetOneCtaCteDT(Entorno.ItemEmpresa.EMPR_Codigo, Int32.Parse(ItemResultado[0]["CCCT_Codigo"].ToString()));
if (Result != null)
{
for (int i = 0; i < _DT.Columns.Count; i++)
{
_DT.Rows[Position][_DT.Columns[i].ColumnName] = Result.Rows[0][_DT.Columns[i].ColumnName];
}
}
}
}
}
LView.ShowItems();
}
catch (Exception ex)
{ Dialogos.MostrarMensajeError(Title, "Ha ocurrido un error actualizando.", ex); }
}