public bool InsertarPlanSolicitud_DTH(PlanDetalleConsumer objDetalle, ref string rMsg)
{
DAABRequest.Parameter[] arrParam =
{
new DAABRequest.Parameter("P_RESULTADO", DbType.Int64, ParameterDirection.Output),
new DAABRequest.Parameter("P_SOLIN_CODIGO", DbType.Int64, ParameterDirection.Input),
new DAABRequest.Parameter("P_SOPLC_MONTO_TOTAL", DbType.Double, ParameterDirection.Input),
new DAABRequest.Parameter("P_SOPLN_MONTO_UNIT", DbType.Double, ParameterDirection.Input),
new DAABRequest.Parameter("P_PLANC_CODIGO", DbType.String, 4,ParameterDirection.Input),
new DAABRequest.Parameter("P_TPROC_CODIGO", DbType.String, 2,ParameterDirection.Input),
new DAABRequest.Parameter("P_SOPLN_CANTIDAD", DbType.Int64, ParameterDirection.Input)
};
for (int i = 0; i < arrParam.Length; i++)
{
arrParam[i].Value = DBNull.Value;
}
arrParam[1].Value = objDetalle.SOLIN_CODIGO;
arrParam[2].Value = objDetalle.SOPLC_MONTO_TOTAL;
arrParam[3].Value = objDetalle.SOPLN_MONTO_UNIT;
arrParam[4].Value = objDetalle.PLANC_CODIGO;
arrParam[5].Value = objDetalle.TPROC_CODIGO;
arrParam[6].Value = objDetalle.SOPLN_CANTIDAD;
bool salida = false;
BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT);
DAABRequest obRequest = obj.CreaRequest();
obRequest.CommandType = CommandType.StoredProcedure;
obRequest.Command = BaseDatos.PKG_SISACT_DTH + ".SISACT_INSERTAR_SOL_PLANES_DTH";
obRequest.Parameters.AddRange(arrParam);
obRequest.Transactional = true;
try
{
obRequest.Factory.ExecuteNonQuery(ref obRequest);
obRequest.Factory.CommitTransaction();
salida = true;
}
catch (Exception ex)
{
obRequest.Factory.RollBackTransaction();
rMsg = "Error al Insertar la Solicitud. \nMensaje : " + ex.Message;
throw ex;
}
finally
{
IDataParameter pSalida1;
pSalida1 = (IDataParameter)obRequest.Parameters[0];
rMsg = Funciones.CheckStr(pSalida1.Value);
obRequest.Factory.Dispose();
}
return(salida);
}
public bool InsertarPlanSolicitud_DTH(PlanDetalleConsumer objDetalle, ref string rMsg)
{
return(new PlanDetalleConsDatos().InsertarPlanSolicitud_DTH(objDetalle, ref rMsg));
}
public bool InsertarPlanSolicitud(PlanDetalleConsumer objDetalle)
{
return(new SolicitudDatos().InsertarPlanSolicitud(objDetalle));
}
