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; }
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; }
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; }
private void DeleteMaster(ESubsidio entity) { IDOUpdate objDO = new RHDOMnt.Subsidio(); if (entity.EntityState == EntityState.Unchanged) return; objDO.Delete(entity); }