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;
}
