Пример #1
0
        private ArrayList BuildParamInterface(ESubsidio value)
        {
            ArrayList arrPrm = new ArrayList();

            arrPrm.Add(DataHelper.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, value.IdPeriodo));
            arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, value.IdEmpresa));
            arrPrm.Add(DataHelper.CreateParameter("@pidForPago", SqlDbType.Char, 3, value.IdForPago));
            arrPrm.Add(DataHelper.CreateParameter("@pidPlanilla", SqlDbType.Char, 3, value.IdPlanilla));
            arrPrm.Add(DataHelper.CreateParameter("@pnuProcAnual", SqlDbType.SmallInt, value.NuProcAnual));
            arrPrm.Add(DataHelper.CreateParameter("@pidPersonal", SqlDbType.Char, 7, value.IdPersonal));
            arrPrm.Add(DataHelper.CreateParameter("@pidSubsidio", SqlDbType.Char, 4, value.IdSubsidio));

            return arrPrm;
        }
Пример #2
0
        private object[] UpdateMaster(ESubsidio entity)
        {
            IDOUpdate objDO = new RHDOMnt.Subsidio();

            if (entity.EntityState == EntityState.Unchanged)
                return null;

            object[] objRet = null;

            switch (entity.EntityState)
            {

                case EntityState.Added:
                    objRet = objDO.Insert(entity);
                    break;

                case EntityState.Modified:
                    if (entity.StAnulado == ConstFlagEstado.DESACTIVADO)
                        objDO.Update(entity);
                    else
                        objDO.Delete(entity);
                    break;

                case EntityState.Deleted:
                    objDO.Delete(entity);
                    break;

            }

            return objRet;
        }
Пример #3
0
        private ArrayList BuildParamInterface(ESubsidio value)
        {
            ArrayList arrPrm = new ArrayList();

            arrPrm.Add(DataHelper.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, value.IdPeriodo));
            arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, value.IdEmpresa));
            arrPrm.Add(DataHelper.CreateParameter("@pidForPago", SqlDbType.Char, 3, value.IdForPago));
            arrPrm.Add(DataHelper.CreateParameter("@pidPlanilla", SqlDbType.Char, 3, value.IdPlanilla));
            arrPrm.Add(DataHelper.CreateParameter("@pnuProcAnual", SqlDbType.SmallInt, value.NuProcAnual));
            arrPrm.Add(DataHelper.CreateParameter("@pidPersonal", SqlDbType.Char, 7, value.IdPersonal));
            arrPrm.Add(DataHelper.CreateParameter("@pidSubsidio", SqlDbType.Char, 4, value.IdSubsidio));
            arrPrm.Add(DataHelper.CreateParameter("@pidTipoSubsidio", SqlDbType.Char, 3, value.IdTipoSubsidio));
            arrPrm.Add(DataHelper.CreateParameter("@pfeSubsidio", SqlDbType.DateTime, value.FeSubsidio));
            arrPrm.Add(DataHelper.CreateParameter("@pfeInicioPerioIncapa", SqlDbType.DateTime, value.FeInicioPerioIncapa));
            arrPrm.Add(DataHelper.CreateParameter("@pfeFinPerioIncapa", SqlDbType.DateTime, value.FeFinPerioIncapa));
            arrPrm.Add(DataHelper.CreateParameter("@pdsObserva", SqlDbType.VarChar, 500, value.DsObserva));
            arrPrm.Add(DataHelper.CreateParameter("@pstAnulado", SqlDbType.Char, 1, value.StAnulado));

            return arrPrm;
        }
Пример #4
0
        private void DeleteMaster(ESubsidio entity)
        {
            IDOUpdate objDO = new RHDOMnt.Subsidio();

            if (entity.EntityState == EntityState.Unchanged)
                return;

            objDO.Delete(entity);
        }