private ArrayList BuildParamInterface(EPerContrato value)
        {
            ArrayList arrPrm = new ArrayList();

             arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, value.IdEmpresa));
             arrPrm.Add(DataHelper.CreateParameter("@pidPersonal", SqlDbType.Char, 7, value.IdPersonal));
             arrPrm.Add(DataHelper.CreateParameter("@pnuSecuen", SqlDbType.SmallInt, value.NuSecuen));
             arrPrm.Add(DataHelper.CreateParameter("@pfeSuscripcion", SqlDbType.DateTime, value.FeSuscripcion));
             arrPrm.Add(DataHelper.CreateParameter("@pfeInicio", SqlDbType.DateTime, value.FeInicio));
             arrPrm.Add(DataHelper.CreateParameter("@pfeFin", SqlDbType.DateTime, value.FeFin));
             arrPrm.Add(DataHelper.CreateParameter("@pidMotivFin", SqlDbType.Char, 3, value.IdMotivFin));
             arrPrm.Add(DataHelper.CreateParameter("@pfeCese", SqlDbType.DateTime, (value.FeCese.HasValue ? (object)value.FeCese : DBNull.Value)));
             arrPrm.Add(DataHelper.CreateParameter("@pdsObservacion", SqlDbType.Text, value.DsObservacion));
             arrPrm.Add(DataHelper.CreateParameter("@pidPuesto", SqlDbType.Char, 3, value.IdPuesto));
             arrPrm.Add(DataHelper.CreateParameter("@pdsFuncion", SqlDbType.VarChar, 300, value.DsFuncion));
             arrPrm.Add(DataHelper.CreateParameter("@pidRegLaboral", SqlDbType.Char, 3, value.IdRegLaboral));
             arrPrm.Add(DataHelper.CreateParameter("@pstMype", SqlDbType.Char, 1, value.StMype));
             arrPrm.Add(DataHelper.CreateParameter("@pstDiscapacid", SqlDbType.Char, 1, value.StDiscapacid));
             arrPrm.Add(DataHelper.CreateParameter("@pidModalidad", SqlDbType.Char, 3, value.IdModalidad));
             arrPrm.Add(DataHelper.CreateParameter("@pidSubModal", SqlDbType.Char, 3, value.IdSubModal));
             arrPrm.Add(DataHelper.CreateParameter("@pidTipo", SqlDbType.Char, 3, value.IdTipo));
             arrPrm.Add(DataHelper.CreateParameter("@pidGrpOcupac", SqlDbType.Char, 3, value.IdGrpOcupac));
             arrPrm.Add(DataHelper.CreateParameter("@pidMoneda", SqlDbType.Char, 3, value.IdMoneda));
             arrPrm.Add(DataHelper.CreateParameter("@pidPeriRemu", SqlDbType.Char, 3, value.IdPeriRemu));
             arrPrm.Add(DataHelper.CreateParameter("@pmtRemunera", SqlDbType.Decimal, value.MtRemunera));
             arrPrm.Add(DataHelper.CreateParameter("@pidRemVariable", SqlDbType.Char, 3, value.IdRemVariable));
             arrPrm.Add(DataHelper.CreateParameter("@pstRemuEspecie", SqlDbType.Char, 1, value.StRemuEspecie));
             arrPrm.Add(DataHelper.CreateParameter("@pstRemuMinima", SqlDbType.Char, 1, value.StRemuMinima));
             arrPrm.Add(DataHelper.CreateParameter("@pstProrroga", SqlDbType.Char, 1, value.StProrroga));
             arrPrm.Add(DataHelper.CreateParameter("@pstContrato", SqlDbType.Char, 1, value.StContrato));
             arrPrm.Add(DataHelper.CreateParameter("@pstAnulado", SqlDbType.Char, 1, value.StAnulado));
             arrPrm.Add(DataHelper.CreateParameter("@pdsAdenda", SqlDbType.NVarChar, 4000, value.DsAdenda));
             return arrPrm;
        }
예제 #2
0
        public string[] UpdateDataPerContrato(IEntityBase value)
        {
            EPersonalSet objE = (EPersonalSet)value;
            object[] objRet = null;

            try
            {

                using (TransactionScope tx = new TransactionScope())
                {

                    this.UpdateDetailB(objE.ColPerContrato, objRet);
                    IDOUpdate objDO = new RHDOMnt.PerContrato();
                    RHDOQry.PerContrato objEPC = new RHDOQry.PerContrato();

                    foreach (EPerContrato colobjE in objE.ColPerContrato)
                    {
                        EPerContrato colobjENew = new EPerContrato();
                        colobjE.NuSecuen = colobjE.NuSecuen - 1;
                        colobjENew = (EPerContrato)objEPC.GetByKey(colobjE);
                        if (colobjENew != null)
                        {
                            colobjENew.StContrato = ConstFlagEstado.ACTIVADO;
                            colobjENew.IdMotivFin = ConstMotivoCese.TERMINO;
                            objDO.Update(colobjENew);
                        }

                    }

                    tx.Complete();

                }

                if (objRet == null)
                    return null;

                return new String[] { objRet[0].ToString() };

            }
            catch (Exception ex)
            {

                throw ex;

            }
        }
        private ArrayList BuildParamInterface(EPerContrato value)
        {
            ArrayList arrPrm = new ArrayList();

            arrPrm.Add(DataHelper.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, value.IdEmpresa));
            arrPrm.Add(DataHelper.CreateParameter("@pidPersonal", SqlDbType.Char, 7, value.IdPersonal));
            arrPrm.Add(DataHelper.CreateParameter("@pnuSecuen", SqlDbType.SmallInt, value.NuSecuen));

            return arrPrm;
        }