public Planillas GetOne(Int16 EMPR_Codigo, String PLAN_Tipo, String PLAN_Codigo) { try { if (EMPR_Codigo == null || PLAN_Tipo == null || PLAN_Codigo == null) { return(null); } Entities.Planillas _planilla = SelectOne(EMPR_Codigo, PLAN_Tipo, PLAN_Codigo); if (_planilla != null) { ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> _listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@psinEMPR_Codigo", FilterValue = _planilla.EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 2 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pchrPLAN_Tipo", FilterValue = _planilla.PLAN_Tipo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 3 }); _listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pvchPLAN_Codigo", FilterValue = _planilla.PLAN_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Varchar, FilterSize = 20 }); _planilla.ListMovimiento = BL_Movimiento.GetAllFilter("CAJ_MOVISS_EgresosPorPlanilla", _listFilters); _planilla.ListDetCtaCte = BL_DetCtaCte.GetAllFilter("CAJ_DCCTSS_TodosPorPlanilla", _listFilters); _planilla.Monto = _planilla.ListDetCtaCte.Sum(Det => Det.CCCT_Pendiente).Value; } return(_planilla); } catch (Exception) { throw; } }
public Transferencia GetOne(Int16 EMPR_Codigo, Int32 TRAN_Codigo) { try { if (EMPR_Codigo == null || TRAN_Codigo == null) { return(null); } Transferencia _transferencia = SelectOne(EMPR_Codigo, TRAN_Codigo); if (_transferencia != null) { /* * Cargar los detalles */ ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL> listFilters = new ObservableCollection <Infrastructure.Aspect.DataAccess.DataAccessFilterSQL>(); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@psinEMPR_Codigo", FilterValue = EMPR_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int16, FilterSize = 2 }); listFilters.Add(new Infrastructure.Aspect.DataAccess.DataAccessFilterSQL() { FilterName = "@pintTRAN_Codigo", FilterValue = TRAN_Codigo, FilterType = Infrastructure.Aspect.DataAccess.DataAccessFilterTypes.Int32, FilterSize = 4 }); _transferencia.ListEgresos = BL_Movimiento.GetAllFilter("CAJ_MOVISS_EgresosPorTransferencia", listFilters); _transferencia.ListIngresos = BL_Movimiento.GetAllFilter("CAJ_MOVISS_IngresosPorTransferencia", listFilters); _transferencia.ListGastosBancarios = BL_GastosBancarios.GetAllFilter("CAJ_GBANSS_TodosPorTransferencia", listFilters); } return(_transferencia); } catch (Exception) { throw; } }