public object[] Insert(IEntityBase value) { ESubsidio objE = (ESubsidio)value; //----------- Generacion de Codigos ------------------ TablaCorre objDO = new TablaCorre(); ETablaCorre objECorre = new ETablaCorre(); objECorre.IdPeriodo = objE.IdPeriodo; objECorre.IdEmpresa = objE.IdEmpresa; objECorre.IdTabla = "RH_Subsidio"; string strNewCode = objDO.GenNewCode(objECorre); objE.IdSubsidio = strNewCode; //---------------------------------------------------- ArrayList arrPrm = BuildParamInterface(objE); try { int intRes = this.ExecuteNonQuery("RH_Subsidio_mnt01", arrPrm); return new object[] { objE.IdSubsidio }; } catch (Exception ex) { ServerObjectException objEx = (ServerObjectException)this.GetException(MethodBase.GetCurrentMethod(), ex); throw objEx; } }
public object[] Insert(IEntityBase value) { EPlanilla objE = (EPlanilla)value; //----------- Generacion de Codigos ------------------ TablaCorre objDO = new TablaCorre(); ETablaCorre objECorre = new ETablaCorre(); objECorre.IdPeriodo = ConstDefaultValue.PERIODO; objECorre.IdEmpresa = ConstDefaultValue.EMPRESA; objECorre.IdTabla = "RH_Planilla"; string strNewCode = objDO.GenNewCode(objECorre); objE.IdPlanilla = strNewCode; //---------------------------------------------------- ArrayList arrPrm = BuildParamInterface(objE); try { int intRes = this.ExecuteNonQuery("RH_Planilla_mnt01", arrPrm); return new object[] { objE.IdPlanilla }; } catch (Exception ex) { ServerObjectException objEx = (ServerObjectException)this.GetException(MethodBase.GetCurrentMethod(), ex); throw objEx; } }
private ArrayList BuildParamInterface(ETablaCorre 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("@pidTabla", SqlDbType.VarChar, 30, value.IdTabla)); arrPrm.Add(DataHelper.CreateParameter("@pnuIni", SqlDbType.Int, value.NuIni)); arrPrm.Add(DataHelper.CreateParameter("@pnuFin", SqlDbType.Int, value.NuFin)); arrPrm.Add(DataHelper.CreateParameter("@pnuIntervalo", SqlDbType.Int, value.NuIntervalo)); arrPrm.Add(DataHelper.CreateParameter("@pnuUltGen", SqlDbType.Int, value.NuUltGen)); arrPrm.Add(DataHelper.CreateParameter("@pdsFormato", SqlDbType.VarChar, 10, value.DsFormato)); return arrPrm; }