public void ActualizarEstado(EProcPlani value) { IDOUpdate objDO = new RHDOMnt.ProcPlani(); IDOQuery objDOQ = new RHDOQry.ProcPlani(); if (value.EntityState == EntityState.Unchanged) return; value = (EProcPlani)objDOQ.GetByKey(value); if (value != null) { value.StProceso = ConstEstadoProcePlani.CERRADA; objDO.Update(value); } }
private object[] UpdateMaster(EProcPlani entity) { IDOUpdate objDO = new RHDOMnt.ProcPlani(); 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(EProcPlani 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("@pidMes", SqlDbType.Char, 3, value.IdMes)); arrPrm.Add(DataHelper.CreateParameter("@pidMoneda", SqlDbType.Char, 3, value.IdMoneda)); arrPrm.Add(DataHelper.CreateParameter("@pmtTC", SqlDbType.Decimal, value.MtTC)); arrPrm.Add(DataHelper.CreateParameter("@pfeDesde", SqlDbType.DateTime, value.FeDesde)); arrPrm.Add(DataHelper.CreateParameter("@pfeHasta", SqlDbType.DateTime, value.FeHasta)); arrPrm.Add(DataHelper.CreateParameter("@pfeProceso", SqlDbType.DateTime, (value.FeProceso.HasValue ? (object)value.FeProceso : DBNull.Value))); arrPrm.Add(DataHelper.CreateParameter("@pstProceso", SqlDbType.Char, 3, value.StProceso)); arrPrm.Add(DataHelper.CreateParameter("@pstAnulado", SqlDbType.Char, 1, value.StAnulado)); return arrPrm; }
private void DeleteMaster(EProcPlani entity) { IDOUpdate objDO = new RHDOMnt.ProcPlani(); if (entity.EntityState == EntityState.Unchanged) return; objDO.Delete(entity); }
private ArrayList BuildParamInterface(EProcPlani 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("@pidMes", SqlDbType.Char, 3, DataHelper.IfNullString(value.IdMes))); arrPrm.Add(DataHelper.CreateParameter("@pidForPago", SqlDbType.Char, 3,DataHelper.IfNullString(value.IdForPago))); arrPrm.Add(DataHelper.CreateParameter("@pidPlanilla", SqlDbType.Char, 3, DataHelper.IfNullString(value.IdPlanilla))); arrPrm.Add(DataHelper.CreateParameter("@pnuProcAnual", SqlDbType.SmallInt, DataHelper.IfNullString(value.NuProcAnual))); return arrPrm; }