WCF service integrating with the PACS radiology imaging system
Last commit: 2025-09-02
TestConnection also in → NET-WS-PruebasPDF, NET-WS-FuncionesGenerales, NET-WS-HL7Broker, NET-WS-LaboratorioObtenerDatosPacienteFS also in → NET-WS-LaboratorioObtenerDatosPaciente also in → NET-WS-LaboratorioUPDATE CA1200 SET CA12ESTADO = :estado WHERE CA12NUMREG = :numReg…UPDATE IM0100 SET IM08CODESTDOC = :estado, IM01FECFINMECA = :fecFinMeca, SG02COD_FINMECA …(select PR04NUMACTPLAN_PP from prc100 where pr04numactplan_aso = pr04numactplan) PR04NUMAC…SELECT 1 FROM PR0400,PR0100 WHERE PR04NUMACTPLAN = :numActPlan AND PR0400.PR01CODACTUACION…| Operation ⇅ | Verb | Returns ⇅ | Parameters | SQLs ⇅ | Description | Flags |
|---|---|---|---|---|---|---|
| GetConfig | SOAP | String | 0 | Devuelve la cadena de conexión | ✓ 🔁 | |
| TestConnection | SOAP | String | 0 | Prueba que la conexión puede hacerse | ✓ 🔁 | |
| ActualizarPb09Vna | SOAP | RespVoid | historia, numActPlan, siuid | 0 | ✓ | |
| ObtenerDatosPaciente | SOAP | RespPacienteEntity | numActPlan, codPersona | 1 | ✓ 🔁 | |
| ExisteCita | SOAP | RespBool | numActPlan | 1 | ✓ | |
| ObtenerDatosPersonaBasico | SOAP | RespPersonaEntity | codPersona | 1 | ✓ 🔁 | |
| ObtenerFecImg | SOAP | RespDateTime | numActPlan | 1 | ✓ | |
| UpdateFecImg | SOAP | RespVoid | numActPlan | 1 | ✓ | |
| ObtenerPrueba | SOAP | RespPruebaEntity | numActPlan | 1 | ✓ 🔁 | |
| ObtenerEstadoPrueba | SOAP | RespString | numActPlan | 1 | Obtiene el estado de una prueba (numactplan de PR04) | ✓ 🔁 |
| ActualizarFecImgPrueba | SOAP | RespVoid | numActPlan | 5 | ✓ | |
| ActualizarFecImgPruebasSinFecha | SOAP | RespString | numActPlan | 4 | Método que recibe un numActPlan y revisa si es principal y sus secundarias. Luego actualiza la fecim… | ⚠ |
| ObtenerDatosPacienteWLDoc | SOAP | RespPacienteEntity | numDoc, codPersona | 1 | ✓ 🔁 | |
| ObtenerDatosPacienteWL | SOAP | RespPacienteEntity | numActPlan, codPersona | 1 | ✓ 🔁 | |
| ObtenerNuevoAetDesdobleAgenda | SOAP | RespString | codRecurso, codTipoGrupo, codActuacion | 1 | Método que obtiene en nuevo AET para un recurso/actuación que pertenece al tipo de grupo pasado como… | ⚠ |
| ObtenerDatosPacienteWLSec | SOAP | RespPacienteEntity | numActPlan, codPersona | 1 | ✓ | |
| ExisteRegistroFecImg | SOAP | RespBool | numActPlan | 1 | ✓ | |
| EsMamografiaMadrid | SOAP | RespBool | numActPlan | 2 | ✓ | |
| EsPruebaCentricity | SOAP | RespBool | numActPlan | 2 | ✓ | |
| CountRastreo | SOAP | RespInt | numActPlan | 1 | ✓ | |
| ObtenerDatosPacienteDoc | SOAP | RespPacienteEntity | numDoc, codPersona | 1 | ✓ | |
| ObtenerDatosPacienteSinCita | SOAP | RespPacienteEntity | numActPlan, codPersona | 1 | ✓ | |
| ContarSinProcesar | SOAP | RespInt | 1 | Devuelve los registros sin procesar | ✓ 🔁 | |
| ObtenerDatosPacienteIM | SOAP | RespPacienteEntity | numDoc | 1 | ✓ | |
| ActualizarEstadoDoc | SOAP | RespVoid | numDoc, estado | 1 | ✓ 🔁 | |
| ActualizarEstadoPrueba | SOAP | RespVoid | numActPlan, estado | 1 | ✓ | |
| CrearIM29 | SOAP | RespVoid | numDoc, accion, codDpto, indProcesada | 2 | ✓ | |
| ObtenerTipoPaciente | SOAP | RespString | numActplan, codDpto | 3 | ✓ | |
| EsUrgente | SOAP | RespString | numActplan | 1 | ✓ 🔁 | |
| ObtenerDepartamento | SOAP | RespString | numActPlan | 0 | ✓ 🔁 | |
| EsToraxAbdomen | SOAP | RespBool | numActplan | 0 | ✓ | |
| ObtenerDoctorExterno | SOAP | RespString | numActplan | 1 | ✓ 🔁 | |
| ObtenerNumActAsociado | SOAP | RespString | numActplan | 0 | ✓ 🔁 | |
| ObtenerListaNumActAsociado | SOAP | RespListString | numActplan | 1 | Obtiene una lista con los numactplan asociados | ✓ |
| ObtenerCodPersonaByHistoria | SOAP | RespString | numHistoria | 1 | Obtiene el código de persona a través del numHistoria | ✓ |
| InsertarPB14 | SOAP | RespVoid | numActplan, codPersona, tipoEvento, estado, tipo | 1 | Inserta un registro en la PB1400 | ✓ |
| ComprobarEstadoNumact | SOAP | RespBool | numActplan | 1 | ✓ | |
| ComprobarNumActDeHistoria | SOAP | RespBool | numActPlan, historia | 1 | Comprobamos que el número de actuación planificada corresponde a la historia. | ✓ 🔁 |
| PerteneceNumactAGrupo | SOAP | RespBool | numActPlan, grupo | 2 | Comprobamos que el número de actuación planificada corresponde a la historia. | ✓ |
| ObtenerPruebasDeGrupoParaHoy | SOAP | RespListPruebaEntity | grupo | 1 | Obtiene una lista con los numactplan asociados | ✓ |
| ObtenerMotivo | SOAP | RespString | numactplan | 1 | Obtiene una lista con los numactplan asociados | ✓ |
| EsNumactAsociado | SOAP | RespInt | numActPlan | 1 | ✓ | |
| EsIntervencion | SOAP | RespBool | numActPlan | 1 | ✓ | |
| ObtenerPruebaMismaAsist | SOAP | RespPruebaEntity | numActPlan, codAct | 2 | ✓ 🔁 | |
| InsertarRegistroPRGL00 | SOAP | RespString | studyInstanceUID, numActPlan, modalidad, tipoDoc, aetitle | 1 | Inserta un registro en PRGL00 que guarda info sobre los estudios que se guardan en el Pacs (IN-4152) | ✓ |
| ObtenerNumactPrincipal | SOAP | RespString | numActPlan | 1 | ✓ | |
| ActualizarPRC100 | SOAP | RespVoid | numActPlanPP, numActPlanASO, numActPPToUpdate, numActASOToUpdate | 2 | Actualiza la PRC100 con el PACS principal y Asociado que se le pase. Modifica el registro que coinci… | ✓ |
| EsAudiometriaMadrid | SOAP | RespBool | numActPlan | 2 | ✓ | |
| ObtenerStationName | SOAP | RespString | numActPlan | 1 | Obtiene el StationName a partir del numactplan | ✓ |
| ObtenerTipoEconomicoNumActPlan | SOAP | RespString | numActPlan | 1 | Obtiene el tipo económico a partir de un numActPlan | ✓ |
| ObtenerDocumento | SOAP | RespDocEntity | numActPlan | 1 | ✓ 🔁 | |
| CrearRelacionDocActuacion | SOAP | RespVoid | numActPlan, numDoc | 1 | ✓ 🔁 | |
| InsertarAdemdum | SOAP | RespString | informe, numActPlan | 1 | ✓ 🔁 | |
| InsertarIM15 | SOAP | RespVoid | numeroDocumento | 0 | ✓ 🔁 | |
| ActualizarDocumento | SOAP | RespVoid | informe, numeroDocumento | 1 | ✓ 🔁 | |
| ActualizarDocumentoVna | SOAP | RespVoid | informe, numeroDocumento, vna | 1 | ✓ 🔁 | |
| FirmarDocumento | SOAP | RespVoid | informe, numActPlan, numeroDocumento | 2 | ✓ 🔁 | |
| FirmarDocumentoVna | SOAP | RespVoid | informe, numActPlan, numeroDocumento, vna | 2 | ✓ 🔁 | |
| ActualizarFechaInformePR04 | SOAP | RespVoid | numActPlan | 1 | ✓ 🔁 | |
| ObtenerFechaFinAct | SOAP | RespString | numActPlan | 1 | ✓ | |
| InsertarDoc | SOAP | RespString | de | 0 | ✓ 🔁 | |
| ObtenerDocumentoFirmar | SOAP | RespDocEntity | numActPlan | 2 | ✓ 🔁 | |
| ObtenerDatosCabecera | SOAP | RespCabeceraWord | numActPlan, numeroDocumento | 0 | ⚠ 🔁 | |
| InsertarRegistroPDF | SOAP | RespString | numActPlan, fechaPDF | 1 | Inserta un registro en PRER00 | ✓ 🔁 |
| CheckRegistroPDF | SOAP | RespBool | numActPlan | 1 | Comprueba si hay registro en PRER00 | ✓ 🔁 |
| ObtenerCodUser | SOAP | RespString | codWindows | 1 | ✓ 🔁 | |
| ObtenerFechaActo | SOAP | RespString | numActPlan | 1 | ✓ 🔁 | |
| ObtenerFechaPeticion | SOAP | RespString | numActPlan | 2 | ✓ 🔁 | |
| ObtenerCoUser | SOAP | RespString | numActPlan | 1 | ✓ | |
| ObtenerDesPrueba | SOAP | RespString | numActPlan | 1 | ✓ 🔁 | |
| ActualizarFechaArchivo | SOAP | RespVoid | numActPlan | 2 | ✓ 🔁 |
Devuelve la cadena de conexión
/// <summary> /// Devuelve la cadena de conexión /// </summary> /// <returns>String</returns>
[TestMethod]
public void Test_GetConfig_ReturnsSuccess()
{
// Arrange
var client = new WSPacs();
// Act
var result = client.GetConfig();
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_GetConfig_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
// Act
var result = client.GetConfig();
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Prueba que la conexión puede hacerse
cysnet.common.utils/// <summary> /// Prueba que la conexión puede hacerse /// </summary> /// <returns>String</returns>
[TestMethod]
public void Test_TestConnection_ReturnsSuccess()
{
// Arrange
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
// Act
var result = client.TestConnection();
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_TestConnection_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
// Act
var result = client.TestConnection();
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.core/// <summary> /// Actualiza actualizar pb09 vna /// </summary> /// <param name="historia">TODO: describe historia</param> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="siuid">TODO: describe siuid</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_ActualizarPb09Vna_ReturnsSuccess()
{
// Arrange
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var historia = "test_value";
var numActPlan = "test_value";
var siuid = "test_value";
// Act
var result = client.ActualizarPb09Vna(historia, numActPlan, siuid);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarPb09Vna_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var historia = null;
var numActPlan = null;
var siuid = null;
// Act
var result = client.ActualizarPb09Vna(historia, numActPlan, siuid);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
SELECT CI2200.CI22NUMHISTORIA,CI2200.CI22NOMBRE,CI2200.CI22PRIAPEL,CI2200.CI22SEGAPEL,CI2200.CI30CODSEXO,PR0400.AD01CODASISTENCI,
/// <summary> /// Obtiene obtener datos paciente /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="codPersona">TODO: describe codPersona</param> /// <returns>RespPacienteEntity</returns>
[TestMethod]
public void Test_ObtenerDatosPaciente_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
var codPersona = "test_value";
// Act
var result = client.ObtenerDatosPaciente(numActPlan, codPersona);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDatosPaciente_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
var codPersona = null;
// Act
var result = client.ObtenerDatosPaciente(numActPlan, codPersona);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT 1 FROM CI0100
/// <summary> /// Executes existe cita /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_ExisteCita_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ExisteCita(numActPlan);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ExisteCita_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ExisteCita(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT CI22NUMHISTORIA,CI22NOMBRE,CI22PRIAPEL,CI22SEGAPEL,CI30CODSEXO,CI22FECNACIM,CI22FECUPD
/// <summary> /// Obtiene obtener datos persona basico /// </summary> /// <param name="codPersona">TODO: describe codPersona</param> /// <returns>RespPersonaEntity</returns>
[TestMethod]
public void Test_ObtenerDatosPersonaBasico_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var codPersona = "test_value";
// Act
var result = client.ObtenerDatosPersonaBasico(codPersona);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDatosPersonaBasico_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var codPersona = null;
// Act
var result = client.ObtenerDatosPersonaBasico(codPersona);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT prc3fecimg FROM prc300
/// <summary> /// Obtiene obtener fec img /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespDateTime</returns>
[TestMethod]
public void Test_ObtenerFecImg_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerFecImg(numActPlan);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerFecImg_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerFecImg(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreUPDATE prc300 SET prc3fecimg = sysdate
/// <summary> /// Updates update fec img /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_UpdateFecImg_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.UpdateFecImg(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_UpdateFecImg_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.UpdateFecImg(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT pr04fecimg, pr04feciniact, pr04fecfinact, ci21codpersona FROM pr0400
/// <summary> /// Obtiene obtener prueba /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespPruebaEntity</returns>
[TestMethod]
public void Test_ObtenerPrueba_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerPrueba(numActPlan);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerPrueba_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerPrueba(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Obtiene el estado de una prueba (numactplan de PR04)
cysnet.cun.coreSELECT pr37codestado FROM pr0400
/// <summary> /// Obtiene el estado de una prueba (numactplan de PR04) /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerEstadoPrueba_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerEstadoPrueba(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerEstadoPrueba_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerEstadoPrueba(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.sharedUPDATE pr0400 SET pr04fecimg = sysdate WHERE pr04numactplan = :numActPlan
Ejecutando consulta (primer update)
UPDATE pr0400 SET pr04fecimg = sysdate WHERE pr04numactplan in
(SELECT pr04numactplan_aso FROM prc100 WHERE pr04numactplan_pp = :numActPlan)
Ejecutando consulta (segundo update)
/// <summary> /// Actualiza actualizar fec img prueba /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_ActualizarFecImgPrueba_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ActualizarFecImgPrueba(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarFecImgPrueba_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ActualizarFecImgPrueba(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Método que recibe un numActPlan y revisa si es principal y sus secundarias. Luego actualiza la fecimg de todos los pr04numactplan que no la tengan, con la fecha de pr04fecfinact.
select 1 from prc100 where PR04NUMACTPLAN_PP = :numActPlan
select PR04NUMACTPLAN_PP from prc100 where PR04NUMACTPLAN_ASO = :numActPlan
select PR04NUMACTPLAN_ASO from prc100 where PR04NUMACTPLAN_PP = :principal
update pr0400 set pr04fecimg = pr04fecfinact where pr04numactplan in (
/// <summary> /// Método que recibe un numActPlan y revisa si es principal y sus secundarias. Luego actualiza la fecimg de todos los pr04numactplan que no la tengan, con la fecha de pr04fecfinact. /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ActualizarFecImgPruebasSinFecha_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ActualizarFecImgPruebasSinFecha(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarFecImgPruebasSinFecha_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ActualizarFecImgPruebasSinFecha(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
SELECT CI2200.CI22NUMHISTORIA,CI2200.CI22NOMBRE,CI2200.CI22PRIAPEL,CI2200.CI22SEGAPEL,CI2200.CI30CODSEXO,IM2700.AD01CODASISTENCI,
/// <summary> /// Obtiene obtener datos paciente w l doc /// </summary> /// <param name="numDoc">TODO: describe numDoc</param> /// <param name="codPersona">TODO: describe codPersona</param> /// <returns>RespPacienteEntity</returns>
[TestMethod]
public void Test_ObtenerDatosPacienteWLDoc_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numDoc = "test_value";
var codPersona = "test_value";
// Act
var result = client.ObtenerDatosPacienteWLDoc(numDoc, codPersona);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDatosPacienteWLDoc_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numDoc = null;
var codPersona = null;
// Act
var result = client.ObtenerDatosPacienteWLDoc(numDoc, codPersona);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
SELECT PR0400.AD02CODDPTO pr04CodDpto, PR0900.AD02CODDPTO pr09CodDpto,
/// <summary> /// Obtiene obtener datos paciente w l /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="codPersona">TODO: describe codPersona</param> /// <returns>RespPacienteEntity</returns>
[TestMethod]
public void Test_ObtenerDatosPacienteWL_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
var codPersona = "test_value";
// Act
var result = client.ObtenerDatosPacienteWL(numActPlan, codPersona);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDatosPacienteWL_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
var codPersona = null;
// Act
var result = client.ObtenerDatosPacienteWL(numActPlan, codPersona);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Método que obtiene en nuevo AET para un recurso/actuación que pertenece al tipo de grupo pasado como parámetro.
cysnet.cun.coreSELECT ag6000.AG60AET
/// <summary> /// Método que obtiene en nuevo AET para un recurso/actuación que pertenece al tipo de grupo pasado como parámetro. /// </summary> /// <param name="codRecurso">TODO: describe codRecurso</param> /// <param name="codTipoGrupo">TODO: describe codTipoGrupo</param> /// <param name="codActuacion">TODO: describe codActuacion</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerNuevoAetDesdobleAgenda_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var codRecurso = "test_value";
var codTipoGrupo = "test_value";
var codActuacion = "test_value";
// Act
var result = client.ObtenerNuevoAetDesdobleAgenda(codRecurso, codTipoGrupo, codActuacion);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerNuevoAetDesdobleAgenda_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var codRecurso = null;
var codTipoGrupo = null;
var codActuacion = null;
// Act
var result = client.ObtenerNuevoAetDesdobleAgenda(codRecurso, codTipoGrupo, codActuacion);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
SELECT PR0400.AD02CODDPTO pr04CodDpto, PR0900.AD02CODDPTO pr09CodDpto,
/// <summary> /// Obtiene obtener datos paciente w l sec /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="codPersona">TODO: describe codPersona</param> /// <returns>RespPacienteEntity</returns>
[TestMethod]
public void Test_ObtenerDatosPacienteWLSec_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
var codPersona = "test_value";
// Act
var result = client.ObtenerDatosPacienteWLSec(numActPlan, codPersona);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDatosPacienteWLSec_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
var codPersona = null;
// Act
var result = client.ObtenerDatosPacienteWLSec(numActPlan, codPersona);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT 1 FROM prc300
/// <summary> /// Executes existe registro fec img /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_ExisteRegistroFecImg_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ExisteRegistroFecImg(numActPlan);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ExisteRegistroFecImg_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ExisteRegistroFecImg(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT 1 FROM pr0400
(SELECT pr01codactuacion FROM pr1700 WHERE pr16codgrupo = 1130)
pr1700 also used in: NET-WS-Informes/// <summary> /// Executes es mamografia madrid /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_EsMamografiaMadrid_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.EsMamografiaMadrid(numActPlan);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_EsMamografiaMadrid_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.EsMamografiaMadrid(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT 1 FROM pr0400
(SELECT pr01codactuacion FROM pr1700 WHERE pr16codgrupo = 1261)
pr1700 also used in: NET-WS-Informes/// <summary> /// Executes es prueba centricity /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_EsPruebaCentricity_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = 1;
// Act
var result = client.EsPruebaCentricity(numActPlan);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_EsPruebaCentricity_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = -1;
// Act
var result = client.EsPruebaCentricity(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect count(*) resultado from pr0400, ad.ad2500
/// <summary> /// Executes count rastreo /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespInt</returns>
[TestMethod]
public void Test_CountRastreo_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.CountRastreo(numActPlan);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_CountRastreo_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.CountRastreo(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
SELECT IM2700.IM27FECADD,IM2700.IM27FECDOC,IM2700.IM27DESCRIPCION,IM2700.IM27NUMDOC,CI2200.CI22NUMHISTORIA,CI2200.CI22NOMBRE,CI2200.CI22PRIAPEL,
/// <summary> /// Obtiene obtener datos paciente doc /// </summary> /// <param name="numDoc">TODO: describe numDoc</param> /// <param name="codPersona">TODO: describe codPersona</param> /// <returns>RespPacienteEntity</returns>
[TestMethod]
public void Test_ObtenerDatosPacienteDoc_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numDoc = "test_value";
var codPersona = "test_value";
// Act
var result = client.ObtenerDatosPacienteDoc(numDoc, codPersona);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDatosPacienteDoc_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numDoc = null;
var codPersona = null;
// Act
var result = client.ObtenerDatosPacienteDoc(numDoc, codPersona);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
SELECT CI2200.CI22NUMHISTORIA,CI2200.CI22NOMBRE,CI2200.CI22PRIAPEL,CI2200.CI22SEGAPEL,CI2200.CI30CODSEXO,PR0400.AD01CODASISTENCI,
/// <summary> /// Obtiene obtener datos paciente sin cita /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="codPersona">TODO: describe codPersona</param> /// <returns>RespPacienteEntity</returns>
[TestMethod]
public void Test_ObtenerDatosPacienteSinCita_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
var codPersona = "test_value";
// Act
var result = client.ObtenerDatosPacienteSinCita(numActPlan, codPersona);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDatosPacienteSinCita_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
var codPersona = null;
// Act
var result = client.ObtenerDatosPacienteSinCita(numActPlan, codPersona);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Devuelve los registros sin procesar
cysnet.cun.coreSELECT COUNT(*) resultado FROM pb1400 WHERE PB14INDREALIZADO=0
/// <summary> /// Devuelve los registros sin procesar /// </summary> /// <returns>RespInt</returns>
[TestMethod]
public void Test_ContarSinProcesar_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
// Act
var result = client.ContarSinProcesar();
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ContarSinProcesar_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
// Act
var result = client.ContarSinProcesar();
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT ci2200.ci22numhistoria, ci22nombre, ci22priapel || ' ' || ci22segapel APELLIDOS,
/// <summary> /// Obtiene obtener datos paciente i m /// </summary> /// <param name="numDoc">TODO: describe numDoc</param> /// <returns>RespPacienteEntity</returns>
[TestMethod]
public void Test_ObtenerDatosPacienteIM_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numDoc = "test_value";
// Act
var result = client.ObtenerDatosPacienteIM(numDoc);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDatosPacienteIM_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numDoc = null;
// Act
var result = client.ObtenerDatosPacienteIM(numDoc);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreUPDATE IM0100 SET IM08CodEstDoc = :estado WHERE IM01NumDoc = :numDoc
IM0100 also used in: NET-WS-Informes/// <summary> /// Actualiza actualizar estado doc /// </summary> /// <param name="numDoc">TODO: describe numDoc</param> /// <param name="estado">TODO: describe estado</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_ActualizarEstadoDoc_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numDoc = "test_value";
var estado = "test_value";
// Act
var result = client.ActualizarEstadoDoc(numDoc, estado);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarEstadoDoc_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numDoc = null;
var estado = null;
// Act
var result = client.ActualizarEstadoDoc(numDoc, estado);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreUPDATE PR0400 SET PR37CodEstado = :estado, PR04FecInform = NULL WHERE PR04NumActPlan = :numActPlan
/// <summary> /// Actualiza actualizar estado prueba /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="estado">TODO: describe estado</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_ActualizarEstadoPrueba_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
var estado = "test_value";
// Act
var result = client.ActualizarEstadoPrueba(numActPlan, estado);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarEstadoPrueba_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
var estado = null;
// Act
var result = client.ActualizarEstadoPrueba(numActPlan, estado);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
select IM29NumSec from IM2900 where IM01NumDoc = :numDoc
INSERT INTO IM2900(IM01NumDoc, IM29NumSec, IM29Accion, AD02CodDpto, IM29IndProcesada) VALUES(:numDoc, :numSecuencia, :accion, :codDpto, :indProcesada)
/// <summary> /// Crea crear i m29 /// </summary> /// <param name="numDoc">TODO: describe numDoc</param> /// <param name="accion">TODO: describe accion</param> /// <param name="codDpto">TODO: describe codDpto</param> /// <param name="indProcesada">TODO: describe indProcesada</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_CrearIM29_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numDoc = "test_value";
var accion = "test_value";
var codDpto = "test_value";
var indProcesada = "test_value";
// Act
var result = client.CrearIM29(numDoc, accion, codDpto, indProcesada);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_CrearIM29_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numDoc = null;
var accion = null;
var codDpto = null;
var indProcesada = null;
// Act
var result = client.CrearIM29(numDoc, accion, codDpto, indProcesada);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
select DECODE(PR0400.AD02CODDPTO, PR0900.AD02CODDPTO, 'E', DECODE(AD12CODTIPOASIST, 1, 'H', 'A')) TIPO
select DECODE(AD12CODTIPOASIST,1, 'H', 'A') TIPO
select DECODE(PR0400.AD02CODDPTO, PR0900.AD02CODDPTO, 'E', 'A') TIPO
/// <summary> /// Obtiene obtener tipo paciente /// </summary> /// <param name="numActplan">TODO: describe numActplan</param> /// <param name="codDpto">TODO: describe codDpto</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerTipoPaciente_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActplan = "test_value";
var codDpto = "test_value";
// Act
var result = client.ObtenerTipoPaciente(numActplan, codDpto);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerTipoPaciente_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActplan = null;
var codDpto = null;
// Act
var result = client.ObtenerTipoPaciente(numActplan, codDpto);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect DECODE(PR0900.AD02CODDPTO,216,1, NVL(PR0400.PR48CODURGENCIA,0)) URGENCIA
/// <summary> /// Executes es urgente /// </summary> /// <param name="numActplan">TODO: describe numActplan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_EsUrgente_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActplan = "test_value";
// Act
var result = client.EsUrgente(numActplan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_EsUrgente_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActplan = null;
// Act
var result = client.EsUrgente(numActplan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.common/// <summary> /// Obtiene obtener departamento /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerDepartamento_ReturnsSuccess()
{
// Arrange
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerDepartamento(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerDepartamento_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerDepartamento(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.core/// <summary> /// Executes es torax abdomen /// </summary> /// <param name="numActplan">TODO: describe numActplan</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_EsToraxAbdomen_ReturnsSuccess()
{
// Arrange
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActplan = "test_value";
// Act
var result = client.EsToraxAbdomen(numActplan);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_EsToraxAbdomen_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActplan = null;
// Act
var result = client.EsToraxAbdomen(numActplan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect ci22priapel||' '||ci22segapel||', '||ci22nombre NOMBRE
/// <summary> /// Obtiene obtener doctor externo /// </summary> /// <param name="numActplan">TODO: describe numActplan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerDoctorExterno_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActplan = "test_value";
// Act
var result = client.ObtenerDoctorExterno(numActplan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerDoctorExterno_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActplan = null;
// Act
var result = client.ObtenerDoctorExterno(numActplan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.core/// <summary> /// Obtiene obtener num act asociado /// </summary> /// <param name="numActplan">TODO: describe numActplan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerNumActAsociado_ReturnsSuccess()
{
// Arrange
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActplan = "test_value";
// Act
var result = client.ObtenerNumActAsociado(numActplan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerNumActAsociado_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActplan = null;
// Act
var result = client.ObtenerNumActAsociado(numActplan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Obtiene una lista con los numactplan asociados
cysnet.cun.coreSELECT PR04NUMACTPLAN_ASO FROM prc100 WHERE PR04NUMACTPLAN_PP = :numactplan
/// <summary> /// Obtiene una lista con los numactplan asociados /// </summary> /// <param name="numActplan">TODO: describe numActplan</param> /// <returns>RespListString</returns>
[TestMethod]
public void Test_ObtenerListaNumActAsociado_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActplan = "test_value";
// Act
var result = client.ObtenerListaNumActAsociado(numActplan);
// Assert
Assert.IsNotNull(result.Resultado);
}
[TestMethod]
public void Test_ObtenerListaNumActAsociado_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActplan = null;
// Act
var result = client.ObtenerListaNumActAsociado(numActplan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Obtiene el código de persona a través del numHistoria
cysnet.cun.coreSELECT CI21CODPERSONA FROM CI2200 WHERE CI22NUMHISTORIA = :numHistoria
/// <summary> /// Obtiene el código de persona a través del numHistoria /// </summary> /// <param name="numHistoria">TODO: describe numHistoria</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerCodPersonaByHistoria_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numHistoria = "test_value";
// Act
var result = client.ObtenerCodPersonaByHistoria(numHistoria);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerCodPersonaByHistoria_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numHistoria = null;
// Act
var result = client.ObtenerCodPersonaByHistoria(numHistoria);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Inserta un registro en la PB1400
cysnet.cun.coreINSERT INTO PB1400 (pb14numreg, pr04numactplan, ci21codpersona, pb14indrealizado, pb14tipoevento, pb14estado, pb14tipo)
PB1400 also used in: NET-EnvioEstudios/// <summary> /// Inserta un registro en la PB1400 /// </summary> /// <param name="numActplan">TODO: describe numActplan</param> /// <param name="codPersona">TODO: describe codPersona</param> /// <param name="tipoEvento">TODO: describe tipoEvento</param> /// <param name="estado">TODO: describe estado</param> /// <param name="tipo">TODO: describe tipo</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_InsertarPB14_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActplan = "test_value";
var codPersona = "test_value";
var tipoEvento = "test_value";
var estado = "test_value";
var tipo = "test_value";
// Act
var result = client.InsertarPB14(numActplan, codPersona, tipoEvento, estado, tipo);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_InsertarPB14_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActplan = null;
var codPersona = null;
var tipoEvento = null;
var estado = null;
var tipo = null;
// Act
var result = client.InsertarPB14(numActplan, codPersona, tipoEvento, estado, tipo);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
select pr37codestado
/// <summary> /// Executes comprobar estado numact /// </summary> /// <param name="numActplan">TODO: describe numActplan</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_ComprobarEstadoNumact_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActplan = "test_value";
// Act
var result = client.ComprobarEstadoNumact(numActplan);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ComprobarEstadoNumact_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActplan = null;
// Act
var result = client.ComprobarEstadoNumact(numActplan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Comprobamos que el número de actuación planificada corresponde a la historia.
cysnet.cun.coreSelect 1 from pr0400, ci2200
/// <summary> /// Comprobamos que el número de actuación planificada corresponde a la historia. /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="historia">TODO: describe historia</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_ComprobarNumActDeHistoria_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
var historia = "test_value";
// Act
var result = client.ComprobarNumActDeHistoria(numActPlan, historia);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ComprobarNumActDeHistoria_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
var historia = null;
// Act
var result = client.ComprobarNumActDeHistoria(numActPlan, historia);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Comprobamos que el número de actuación planificada corresponde a la historia.
cysnet.cun.coreSelect 1 from pr0400, ci0100 where
select pr01codactuacion from pr1700 where pr1700.pr16codgrupo = :grupo)
pr1700 also used in: NET-WS-Informes/// <summary> /// Comprobamos que el número de actuación planificada corresponde a la historia. /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="grupo">TODO: describe grupo</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_PerteneceNumactAGrupo_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = 1;
var grupo = 1;
// Act
var result = client.PerteneceNumactAGrupo(numActPlan, grupo);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_PerteneceNumactAGrupo_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = -1;
var grupo = -1;
// Act
var result = client.PerteneceNumactAGrupo(numActPlan, grupo);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Obtiene una lista con los numactplan asociados
cysnet.cun.coreSELECT pr0400.pr04numactplan, pr0400.ci21codpersona
/// <summary> /// Obtiene una lista con los numactplan asociados /// </summary> /// <param name="grupo">TODO: describe grupo</param> /// <returns>RespListPruebaEntity</returns>
[TestMethod]
public void Test_ObtenerPruebasDeGrupoParaHoy_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var grupo = 1;
// Act
var result = client.ObtenerPruebasDeGrupoParaHoy(grupo);
// Assert
Assert.IsNotNull(result.Resultado);
}
[TestMethod]
public void Test_ObtenerPruebasDeGrupoParaHoy_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var grupo = -1;
// Act
var result = client.ObtenerPruebasDeGrupoParaHoy(grupo);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Obtiene una lista con los numactplan asociados
cysnet.cun.coreselect pr41respuesta
/// <summary> /// Obtiene una lista con los numactplan asociados /// </summary> /// <param name="numactplan">TODO: describe numactplan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerMotivo_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numactplan = 1;
// Act
var result = client.ObtenerMotivo(numactplan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerMotivo_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numactplan = -1;
// Act
var result = client.ObtenerMotivo(numactplan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect 1 from prc100 where PR04NUMACTPLAN_ASO = :numactplan
/// <summary> /// Executes es numact asociado /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespInt</returns>
[TestMethod]
public void Test_EsNumactAsociado_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.EsNumactAsociado(numActPlan);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_EsNumactAsociado_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.EsNumactAsociado(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT 1 FROM pb1400, pr0400,pr0100 WHERE pr0400.pr01codactuacion = pr0100.pr01codactuacion AND pr12codactividad = 207 AND pr0400.pr04numactplan = pb1400.pr04numactplan and pb1400.pr04numactplan = :numactplan
/// <summary> /// Executes es intervencion /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_EsIntervencion_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.EsIntervencion(numActPlan);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_EsIntervencion_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.EsIntervencion(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.clinical.commonSELECT AD01CODASISTENCI FROM PR0400
SELECT PR0400.PR04NUMACTPLAN, pr0400.PR01CODACTUACION, pr0400.PR37CODESTADO, PR0100.PR01DESCORTA FROM PR0400, PR0100
/// <summary> /// Obtiene obtener prueba misma asist /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="codAct">TODO: describe codAct</param> /// <returns>RespPruebaEntity</returns>
[TestMethod]
public void Test_ObtenerPruebaMismaAsist_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = 1;
var codAct = 1;
// Act
var result = client.ObtenerPruebaMismaAsist(numActPlan, codAct);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerPruebaMismaAsist_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = -1;
var codAct = -1;
// Act
var result = client.ObtenerPruebaMismaAsist(numActPlan, codAct);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Inserta un registro en PRGL00 que guarda info sobre los estudios que se guardan en el Pacs (IN-4152)
cysnet.cun.coreINSERT INTO PRGL00 (PRGLSTUDYINSTANCEUID, PR04NUMACTPLAN, PRGLMODALIDAD, PRGLTIPODOC, PRGLAET) VALUES (:studyInstanceUID, :numActPlan, :modalidad, :tipoDoc, :aetitle)
/// <summary> /// Inserta un registro en PRGL00 que guarda info sobre los estudios que se guardan en el Pacs (IN-4152) /// </summary> /// <param name="studyInstanceUID">TODO: describe studyInstanceUID</param> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="modalidad">TODO: describe modalidad</param> /// <param name="tipoDoc">TODO: describe tipoDoc</param> /// <param name="aetitle">TODO: describe aetitle</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_InsertarRegistroPRGL00_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var studyInstanceUID = "test_value";
var numActPlan = "test_value";
var modalidad = "test_value";
var tipoDoc = "test_value";
var aetitle = "test_value";
// Act
var result = client.InsertarRegistroPRGL00(studyInstanceUID, numActPlan, modalidad, tipoDoc, aetitle);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_InsertarRegistroPRGL00_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var studyInstanceUID = null;
var numActPlan = null;
var modalidad = null;
var tipoDoc = null;
var aetitle = null;
// Act
var result = client.InsertarRegistroPRGL00(studyInstanceUID, numActPlan, modalidad, tipoDoc, aetitle);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect PR04NUMACTPLAN_PP from prc100 where PR04NUMACTPLAN_ASO = :numactplan
/// <summary> /// Obtiene obtener numact principal /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerNumactPrincipal_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerNumactPrincipal(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerNumactPrincipal_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerNumactPrincipal(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Actualiza la PRC100 con el PACS principal y Asociado que se le pase. Modifica el registro que coincida PR04NUMACTPLAN_PP con numActToUpdate
cysnet.cun.coreUPDATE PRC100 SET PR04NUMACTPLAN_PP = :numActPlanPP, PR04NUMACTPLAN_ASO = :numActPlanASO WHERE PR04NUMACTPLAN_PP = :numActPPToUpdate AND PR04NUMACTPLAN_ASO = :numActASOToUpdate
Ejecutando consulta (update PRC100)
/// <summary> /// Actualiza la PRC100 con el PACS principal y Asociado que se le pase. Modifica el registro que coincida PR04NUMACTPLAN_PP con numActToUpdate /// </summary> /// <param name="numActPlanPP">TODO: describe numActPlanPP</param> /// <param name="numActPlanASO">TODO: describe numActPlanASO</param> /// <param name="numActPPToUpdate">TODO: describe numActPPToUpdate</param> /// <param name="numActASOToUpdate">TODO: describe numActASOToUpdate</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_ActualizarPRC100_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlanPP = "test_value";
var numActPlanASO = "test_value";
var numActPPToUpdate = "test_value";
var numActASOToUpdate = "test_value";
// Act
var result = client.ActualizarPRC100(numActPlanPP, numActPlanASO, numActPPToUpdate, numActASOToUpdate);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarPRC100_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlanPP = null;
var numActPlanASO = null;
var numActPPToUpdate = null;
var numActASOToUpdate = null;
// Act
var result = client.ActualizarPRC100(numActPlanPP, numActPlanASO, numActPPToUpdate, numActASOToUpdate);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT 1 FROM pr0400
(SELECT pr01codactuacion FROM pr1700 WHERE pr16codgrupo = 1263)
pr1700 also used in: NET-WS-Informes/// <summary> /// Executes es audiometria madrid /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_EsAudiometriaMadrid_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.EsAudiometriaMadrid(numActPlan);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_EsAudiometriaMadrid_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.EsAudiometriaMadrid(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Obtiene el StationName a partir del numactplan
cysnet.cun.coreSELECT pr28observ FROM pr0400, pr4100, pr2800
/// <summary> /// Obtiene el StationName a partir del numactplan /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerStationName_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerStationName(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerStationName_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerStationName(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Obtiene el tipo económico a partir de un numActPlan
cysnet.cun.coreSELECT CI32CODTIPECON FROM AD1100 WHERE AD01CODASISTENCI = (SELECT AD01CODASISTENCI FROM PR0400 WHERE PR04NUMACTPLAN = :numActPlan)
AD1100 also used in: NET-WS-Telemedicina/// <summary> /// Obtiene el tipo económico a partir de un numActPlan /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerTipoEconomicoNumActPlan_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerTipoEconomicoNumActPlan(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerTipoEconomicoNumActPlan_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerTipoEconomicoNumActPlan(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect im0100.im01numdoc, im0100.im08codestdoc, im0100.im01indvna from im1600, im0100 where pr04numactplan = :numActPlan and im1600.IM01NUMDOC = im0100.IM01NUMDOC
im1600 also used in: NET-WS-Informes/// <summary> /// Obtiene obtener documento /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespDocEntity</returns>
[TestMethod]
public void Test_ObtenerDocumento_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerDocumento(numActPlan);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDocumento_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerDocumento(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreinsert into im1600 (im01numdoc,pr04numactplan) values (:numDoc,:numActPlan)
im1600 also used in: NET-WS-Informes/// <summary> /// Crea crear relacion doc actuacion /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="numDoc">TODO: describe numDoc</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_CrearRelacionDocActuacion_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
var numDoc = "test_value";
// Act
var result = client.CrearRelacionDocActuacion(numActPlan, numDoc);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_CrearRelacionDocActuacion_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
var numDoc = null;
// Act
var result = client.CrearRelacionDocActuacion(numActPlan, numDoc);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
/// <summary> /// Inserts insertar ademdum /// </summary> /// <param name="informe">TODO: describe informe</param> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_InsertarAdemdum_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var informe = null;
var numActPlan = "test_value";
// Act
var result = client.InsertarAdemdum(informe, numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_InsertarAdemdum_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var informe = -1;
var numActPlan = null;
// Act
var result = client.InsertarAdemdum(informe, numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.core/// <summary> /// Inserts insertar i m15 /// </summary> /// <param name="numeroDocumento">TODO: describe numeroDocumento</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_InsertarIM15_ReturnsSuccess()
{
// Arrange
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numeroDocumento = "test_value";
// Act
var result = client.InsertarIM15(numeroDocumento);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_InsertarIM15_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numeroDocumento = null;
// Act
var result = client.InsertarIM15(numeroDocumento);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.clinical.commonUPDATE IM0100 SET IM08CODESTDOC = :estado, IM01FECFINMECA = :fecFinMeca, SG02COD_FINMECA = :finMeca, IM01INDVNA = -1
IM0100 also used in: NET-WS-Informes/// <summary> /// Actualiza actualizar documento /// </summary> /// <param name="informe">TODO: describe informe</param> /// <param name="numeroDocumento">TODO: describe numeroDocumento</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_ActualizarDocumento_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var informe = null;
var numeroDocumento = "test_value";
// Act
var result = client.ActualizarDocumento(informe, numeroDocumento);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarDocumento_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var informe = -1;
var numeroDocumento = null;
// Act
var result = client.ActualizarDocumento(informe, numeroDocumento);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.clinical.commonUPDATE IM0100 SET IM08CODESTDOC = :estado, IM01FECFINMECA = :fecFinMeca, SG02COD_FINMECA = :finMeca
IM0100 also used in: NET-WS-Informes/// <summary> /// Actualiza actualizar documento vna /// </summary> /// <param name="informe">TODO: describe informe</param> /// <param name="numeroDocumento">TODO: describe numeroDocumento</param> /// <param name="vna">TODO: describe vna</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_ActualizarDocumentoVna_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var informe = null;
var numeroDocumento = "test_value";
var vna = 1;
// Act
var result = client.ActualizarDocumentoVna(informe, numeroDocumento, vna);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarDocumentoVna_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var informe = -1;
var numeroDocumento = null;
var vna = -1;
// Act
var result = client.ActualizarDocumentoVna(informe, numeroDocumento, vna);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.clinical.commonUPDATE IM0100 SET IM08CODESTDOC = 4, IM01FECFINMECA = SYSDATE, SG02COD_RESP = :codResp, SG02COD_FIRMA = :firma, IM01FECFIRMA= :fecFirma, IM01IndFirmDig = -1 WHERE IM01NUMDOC = :numeroDocumento
UPDATE IM0100 SET IM08CODESTDOC = 4, IM01FECFINMECA = :fecFinMeca, SG02COD_RESP = :codResp, SG02COD_FIRMA = :firma, IM01FECFIRMA= :fecFirma, IM01IndFirmDig = -1, im01indvna=-1
IM0100 also used in: NET-WS-Informes/// <summary> /// Executes firmar documento /// </summary> /// <param name="informe">TODO: describe informe</param> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="numeroDocumento">TODO: describe numeroDocumento</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_FirmarDocumento_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var informe = null;
var numActPlan = "test_value";
var numeroDocumento = "test_value";
// Act
var result = client.FirmarDocumento(informe, numActPlan, numeroDocumento);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_FirmarDocumento_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var informe = -1;
var numActPlan = null;
var numeroDocumento = null;
// Act
var result = client.FirmarDocumento(informe, numActPlan, numeroDocumento);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.clinical.commonUPDATE IM0100 SET IM08CODESTDOC = 4, IM01FECFINMECA = SYSDATE, SG02COD_RESP = :codResp, SG02COD_FIRMA = :firma, IM01FECFIRMA= :fecFirma, IM01IndFirmDig = -1 WHERE IM01NUMDOC = :numeroDocumento
UPDATE IM0100 SET IM08CODESTDOC = 4, IM01FECFINMECA = :fecFinMeca, SG02COD_RESP = :codResp, SG02COD_FIRMA = :firma, IM01FECFIRMA= :fecFirma, IM01IndFirmDig = -1
IM0100 also used in: NET-WS-Informes/// <summary> /// Executes firmar documento vna /// </summary> /// <param name="informe">TODO: describe informe</param> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="numeroDocumento">TODO: describe numeroDocumento</param> /// <param name="vna">TODO: describe vna</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_FirmarDocumentoVna_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var informe = null;
var numActPlan = "test_value";
var numeroDocumento = "test_value";
var vna = 1;
// Act
var result = client.FirmarDocumentoVna(informe, numActPlan, numeroDocumento, vna);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_FirmarDocumentoVna_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var informe = -1;
var numActPlan = null;
var numeroDocumento = null;
var vna = -1;
// Act
var result = client.FirmarDocumentoVna(informe, numActPlan, numeroDocumento, vna);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
update pr0400 set pr04fecinform = SYSDATE, pr37codestado = 5
/// <summary> /// Actualiza actualizar fecha informe p r04 /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_ActualizarFechaInformePR04_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ActualizarFechaInformePR04(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarFechaInformePR04_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ActualizarFechaInformePR04(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect pr04feciniact from pr0400 where pr04numactplan = :numActPlan
/// <summary> /// Obtiene obtener fecha fin act /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerFechaFinAct_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerFechaFinAct(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerFechaFinAct_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerFechaFinAct(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.core/// <summary> /// Inserts insertar doc /// </summary> /// <param name="de">TODO: describe de</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_InsertarDoc_ReturnsSuccess()
{
// Arrange
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var de = null;
// Act
var result = client.InsertarDoc(de);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_InsertarDoc_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var de = -1;
// Act
var result = client.InsertarDoc(de);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
select im0100.im01numdoc, im0100.im08codestdoc, im0100.im01indvna from im1600, im0100 where pr04numactplan = :numActPlan and im1600.IM01NUMDOC = im0100.IM01NUMDOC
select im0100.im01numdoc, im0100.im08codestdoc, im0100.im01indvna, im0100.im01titulodoc, im0100.sg02cod_resp, im0100.sg02cod_ayu1, im0100.sg02cod_ayu2,
im1600 also used in: NET-WS-Informes/// <summary> /// Obtiene obtener documento firmar /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespDocEntity</returns>
[TestMethod]
public void Test_ObtenerDocumentoFirmar_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerDocumentoFirmar(numActPlan);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDocumentoFirmar_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerDocumentoFirmar(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
/// <summary> /// Obtiene obtener datos cabecera /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="numeroDocumento">TODO: describe numeroDocumento</param> /// <returns>RespCabeceraWord</returns>
[TestMethod]
public void Test_ObtenerDatosCabecera_ReturnsSuccess()
{
// Arrange
var client = new WSPacs();
var numActPlan = "test_value";
var numeroDocumento = "test_value";
// Act
var result = client.ObtenerDatosCabecera(numActPlan, numeroDocumento);
// Assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_ObtenerDatosCabecera_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
var numeroDocumento = null;
// Act
var result = client.ObtenerDatosCabecera(numActPlan, numeroDocumento);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Inserta un registro en PRER00
cysnet.cun.coreINSERT INTO PRER00 (PR04NUMACTPLAN, PRERFECPDF) VALUES (:numActPlan, :fechaPDF)
/// <summary> /// Inserta un registro en PRER00 /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <param name="fechaPDF">TODO: describe fechaPDF</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_InsertarRegistroPDF_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
var fechaPDF = "test_value";
// Act
var result = client.InsertarRegistroPDF(numActPlan, fechaPDF);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_InsertarRegistroPDF_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
var fechaPDF = null;
// Act
var result = client.InsertarRegistroPDF(numActPlan, fechaPDF);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Comprueba si hay registro en PRER00
cysnet.cun.coreSELECT 1 FROM PRER00 WHERE PR04NUMACTPLAN = :numActPlan
/// <summary> /// Comprueba si hay registro en PRER00 /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespBool</returns>
[TestMethod]
public void Test_CheckRegistroPDF_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.CheckRegistroPDF(numActPlan);
// Assert
Assert.IsTrue(result.Exito);
}
[TestMethod]
public void Test_CheckRegistroPDF_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.CheckRegistroPDF(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreSELECT SG02COD FROM SG0200 WHERE SG02CODWINDOWS = :codWindows
/// <summary> /// Obtiene obtener cod user /// </summary> /// <param name="codWindows">TODO: describe codWindows</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerCodUser_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var codWindows = "test_value";
// Act
var result = client.ObtenerCodUser(codWindows);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerCodUser_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var codWindows = null;
// Act
var result = client.ObtenerCodUser(codWindows);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect pr04feciniact from pr0400 where pr04numactplan = :numActPlan
/// <summary> /// Obtiene obtener fecha acto /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerFechaActo_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerFechaActo(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerFechaActo_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerFechaActo(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect pr04feciniact from pr0400 where pr04numactplan = :numActPlan
SELECT pr09fecpeticion FROM PR0300,PR0900,PR0400
/// <summary> /// Obtiene obtener fecha peticion /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerFechaPeticion_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerFechaPeticion(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerFechaPeticion_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerFechaPeticion(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect pr04feciniact from pr0400 where pr04numactplan = :numActPlan
/// <summary> /// Obtiene obtener co user /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerCoUser_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerCoUser(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerCoUser_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerCoUser(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreselect PR01DESCORTA from PR0100, PR0400 where PR0100.PR01CODACTUACION = PR0400.PR01CODACTUACION AND PR0400.PR04NUMACTPLAN = :numActPlan
PR0100 also used in: NET-WS-Informes/// <summary> /// Obtiene obtener des prueba /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespString</returns>
[TestMethod]
public void Test_ObtenerDesPrueba_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = "test_value";
// Act
var result = client.ObtenerDesPrueba(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ObtenerDesPrueba_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = null;
// Act
var result = client.ObtenerDesPrueba(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
cysnet.cun.coreINSERT INTO PRGB00 (PR04NUMACTPLAN, PRGBFECARCHIVADO) VALUES (:numactplan, sysdate)
Ejecutando consulta (primer update)
PRGB00 also used in: NET-WS-Informes/// <summary> /// Actualiza actualizar fecha archivo /// </summary> /// <param name="numActPlan">TODO: describe numActPlan</param> /// <returns>RespVoid</returns>
[TestMethod]
public void Test_ActualizarFechaArchivo_ReturnsSuccess()
{
// Arrange
// NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
// NOTE: external dependency detected — consider mocking: Oracle DB
var client = new WSPacs();
var numActPlan = 1;
// Act
var result = client.ActualizarFechaArchivo(numActPlan);
// Assert
Assert.IsNotNull(result);
}
[TestMethod]
public void Test_ActualizarFechaArchivo_WithInvalidInput_ReturnsFailure()
{
// Arrange
var client = new WSPacs();
var numActPlan = -1;
// Act
var result = client.ActualizarFechaArchivo(numActPlan);
// Assert
Assert.IsFalse(result?.Exito ?? true);
}
Helper methods inside the service implementation — not part of the public contract.
| File | Query | Tables |
|---|---|---|
| WSPacs.svc.cs | select DECODE(PR0400.AD02CODDPTO, PR0900.AD02CODDPTO, 'E', DECODE(AD12CODTIPOASIST, 1, 'I', 'O')) TIPO |
|
| WSPacs.svc.cs | select DECODE(AD12CODTIPOASIST,1, 'I', 'O') TIPO |
|
| WSPacs.svc.cs | select ci22priapel||' '||ci22segapel||', '||ci22nombre NOMBRE |
|
| WSPacs.svc.cs | select sg02txtfirma, ad02desdpto, pr09fecpeticion, ad0200.ad02coddpto coddpto |
|
| WSPacs.svc.cs | select sg0200.sg02cod ,sg02txtfirma, ad02desdpto, TO_CHAR(pr04fecfinact, 'DD/MM/YYYY') Fecha |
|
| WSPacs.svc.cs | select SG02COD_Firma, SG02COD_resp, SG02COD_ayu1, SG02COD_Ayu2, SG02COD_iniMeca, SG02COD_FinMeca |
|
| WSPacs.svc.cs | select sg02txtfirma from sg0200 where Sg02Cod = :codUsuario |
sg0200 |
| WSPacs.svc.cs | select 1 from ad0300 where ad31codpuesto = 4 and ad03fecfin is null and sg02cod = :codAyudante |
ad0300 |
| WSPacs.svc.cs | SELECT CI2200.CI22NUMHISTORIA,CI2200.CI22NOMBRE,CI2200.CI22PRIAPEL,CI2200.CI22SEGAPEL,CI2200.CI30CODSEXO,PR0400.AD01CODASISTENCI, |
|
| WSPacs.svc.cs | SELECT 1 FROM CI0100 |
CI0100 |
| WSPacs.svc.cs | SELECT CI22NUMHISTORIA,CI22NOMBRE,CI22PRIAPEL,CI22SEGAPEL,CI30CODSEXO,CI22FECNACIM,CI22FECUPD |
|
| WSPacs.svc.cs | SELECT prc3fecimg FROM prc300 |
prc300 |
| WSPacs.svc.cs | UPDATE prc300 SET prc3fecimg = sysdate |
prc300 |
| WSPacs.svc.cs | SELECT pr04fecimg, pr04feciniact, pr04fecfinact, ci21codpersona FROM pr0400 |
pr0400 |
| WSPacs.svc.cs | SELECT pr37codestado FROM pr0400 |
pr0400 |
| WSPacs.svc.cs | UPDATE pr0400 SET pr04fecimg = sysdate WHERE pr04numactplan = :numActPlan |
pr0400 |
| WSPacs.svc.cs | Ejecutando consulta (primer update) |
|
| WSPacs.svc.cs | UPDATE pr0400 SET pr04fecimg = sysdate WHERE pr04numactplan in |
pr0400 |
| WSPacs.svc.cs | (SELECT pr04numactplan_aso FROM prc100 WHERE pr04numactplan_pp = :numActPlan) |
prc100 |
| WSPacs.svc.cs | Ejecutando consulta (segundo update) |
|
| WSPacs.svc.cs | select 1 from prc100 where PR04NUMACTPLAN_PP = :numActPlan |
prc100 |
| WSPacs.svc.cs | select PR04NUMACTPLAN_PP from prc100 where PR04NUMACTPLAN_ASO = :numActPlan |
prc100 |
| WSPacs.svc.cs | select PR04NUMACTPLAN_ASO from prc100 where PR04NUMACTPLAN_PP = :principal |
prc100 |
| WSPacs.svc.cs | update pr0400 set pr04fecimg = pr04fecfinact where pr04numactplan in ( |
pr0400 |
| WSPacs.svc.cs | SELECT PR0400.AD02CODDPTO pr04CodDpto, PR0900.AD02CODDPTO pr09CodDpto, |
|
| WSPacs.svc.cs | SELECT ag6000.AG60AET |
|
| WSPacs.svc.cs | SELECT 1 FROM prc300 |
prc300 |
| WSPacs.svc.cs | SELECT 1 FROM pr0400 |
pr0400 |
| WSPacs.svc.cs | (SELECT pr01codactuacion FROM pr1700 WHERE pr16codgrupo = 1130) |
pr1700 |
| WSPacs.svc.cs | (SELECT pr01codactuacion FROM pr1700 WHERE pr16codgrupo = 1261) |
pr1700 |
| WSPacs.svc.cs | select count(*) resultado from pr0400, ad.ad2500 |
pr0400 |
| WSPacs.svc.cs | SELECT IM2700.IM27FECADD,IM2700.IM27FECDOC,IM2700.IM27DESCRIPCION,IM2700.IM27NUMDOC,CI2200.CI22NUMHISTORIA,CI2200.CI22NOMBRE,CI2200.CI22PRIAPEL, |
|
| WSPacs.svc.cs | SELECT COUNT(*) resultado FROM pb1400 WHERE PB14INDREALIZADO=0 |
pb1400 |
| WSPacs.svc.cs | SELECT ci2200.ci22numhistoria, ci22nombre, ci22priapel || ' ' || ci22segapel APELLIDOS, |
|
| WSPacs.svc.cs | UPDATE IM0100 SET IM08CodEstDoc = :estado WHERE IM01NumDoc = :numDoc |
IM0100 |
| WSPacs.svc.cs | UPDATE PR0400 SET PR37CodEstado = :estado, PR04FecInform = NULL WHERE PR04NumActPlan = :numActPlan |
PR0400 |
| WSPacs.svc.cs | select IM29NumSec from IM2900 where IM01NumDoc = :numDoc |
IM2900 |
| WSPacs.svc.cs | INSERT INTO IM2900(IM01NumDoc, IM29NumSec, IM29Accion, AD02CodDpto, IM29IndProcesada) VALUES(:numDoc, :numSecuencia, :accion, :codDpto, :indProcesada) |
IM2900 |
| WSPacs.svc.cs | select DECODE(AD12CODTIPOASIST,1, 'H', 'A') TIPO |
|
| WSPacs.svc.cs | select DECODE(PR0400.AD02CODDPTO, PR0900.AD02CODDPTO, 'E', 'A') TIPO |
|
| WSPacs.svc.cs | select DECODE(PR0900.AD02CODDPTO,216,1, NVL(PR0400.PR48CODURGENCIA,0)) URGENCIA |
|
| WSPacs.svc.cs | SELECT PR04NUMACTPLAN_ASO FROM prc100 WHERE PR04NUMACTPLAN_PP = :numactplan |
prc100 |
| WSPacs.svc.cs | SELECT CI21CODPERSONA FROM CI2200 WHERE CI22NUMHISTORIA = :numHistoria |
CI2200 |
| WSPacs.svc.cs | INSERT INTO PB1400 (pb14numreg, pr04numactplan, ci21codpersona, pb14indrealizado, pb14tipoevento, pb14estado, pb14tipo) |
PB1400 |
| WSPacs.svc.cs | select pr37codestado |
|
| WSPacs.svc.cs | Select 1 from pr0400, ci2200 |
pr0400 |
| WSPacs.svc.cs | Select 1 from pr0400, ci0100 where |
pr0400 |
| WSPacs.svc.cs | select pr01codactuacion from pr1700 where pr1700.pr16codgrupo = :grupo) |
pr1700 |
| WSPacs.svc.cs | SELECT pr0400.pr04numactplan, pr0400.ci21codpersona |
|
| WSPacs.svc.cs | select pr41respuesta |
|
| WSPacs.svc.cs | select 1 from prc100 where PR04NUMACTPLAN_ASO = :numactplan |
prc100 |
| WSPacs.svc.cs | SELECT 1 FROM pb1400, pr0400,pr0100 WHERE pr0400.pr01codactuacion = pr0100.pr01codactuacion AND pr12codactividad = 207 AND pr0400.pr04numactplan = pb1400.pr04numactplan and pb1400.pr04numactplan = :numactplan |
pb1400 |
| WSPacs.svc.cs | SELECT AD01CODASISTENCI FROM PR0400 |
PR0400 |
| WSPacs.svc.cs | SELECT PR0400.PR04NUMACTPLAN, pr0400.PR01CODACTUACION, pr0400.PR37CODESTADO, PR0100.PR01DESCORTA FROM PR0400, PR0100 |
PR0400 |
| WSPacs.svc.cs | INSERT INTO PRGL00 (PRGLSTUDYINSTANCEUID, PR04NUMACTPLAN, PRGLMODALIDAD, PRGLTIPODOC, PRGLAET) VALUES (:studyInstanceUID, :numActPlan, :modalidad, :tipoDoc, :aetitle) |
PRGL00 |
| WSPacs.svc.cs | UPDATE PRC100 SET PR04NUMACTPLAN_PP = :numActPlanPP, PR04NUMACTPLAN_ASO = :numActPlanASO WHERE PR04NUMACTPLAN_PP = :numActPPToUpdate AND PR04NUMACTPLAN_ASO = :numActASOToUpdate |
PRC100 |
| WSPacs.svc.cs | Ejecutando consulta (update PRC100) |
PRC100 |
| WSPacs.svc.cs | SELECT pr28observ FROM pr0400, pr4100, pr2800 |
pr0400 |
| WSPacs.svc.cs | SELECT CI32CODTIPECON FROM AD1100 WHERE AD01CODASISTENCI = (SELECT AD01CODASISTENCI FROM PR0400 WHERE PR04NUMACTPLAN = :numActPlan) |
AD1100 PR0400 |
| WSPacs.svc.cs | select pr01codactuacion from pr0400 where pr04numactplan = :numactplan |
pr0400 |
| WSPacs.svc.cs | select ad02coddpto from pr0400 where PR04NUMACTPLAN = :numactplan |
pr0400 |
| WSPacs.svc.cs | select im0100.im01numdoc, im0100.im08codestdoc, im0100.im01indvna from im1600, im0100 where pr04numactplan = :numActPlan and im1600.IM01NUMDOC = im0100.IM01NUMDOC |
im1600 |
| WSPacs.svc.cs | insert into im1600 (im01numdoc,pr04numactplan) values (:numDoc,:numActPlan) |
im1600 |
| WSPacs.svc.cs | INSERT INTO IM0100 ( |
IM0100 |
| WSPacs.svc.cs | UPDATE IM0100 SET IM08CODESTDOC = :estado, IM01FECFINMECA = :fecFinMeca, SG02COD_FINMECA = :finMeca, IM01INDVNA = -1 |
IM0100 |
| WSPacs.svc.cs | UPDATE IM0100 SET IM08CODESTDOC = 4, IM01FECFINMECA = SYSDATE, SG02COD_RESP = :codResp, SG02COD_FIRMA = :firma, IM01FECFIRMA= :fecFirma, IM01IndFirmDig = -1 WHERE IM01NUMDOC = :numeroDocumento |
IM0100 |
| WSPacs.svc.cs | UPDATE IM0100 SET IM08CODESTDOC = 4, IM01FECFINMECA = :fecFinMeca, SG02COD_RESP = :codResp, SG02COD_FIRMA = :firma, IM01FECFIRMA= :fecFirma, IM01IndFirmDig = -1, im01indvna=-1 |
IM0100 |
| WSPacs.svc.cs | update pr0400 set pr04fecinform = SYSDATE, pr37codestado = 5 |
pr0400 |
| WSPacs.svc.cs | select pr04feciniact from pr0400 where pr04numactplan = :numActPlan |
pr0400 |
| WSPacs.svc.cs | INSERT INTO PRER00 (PR04NUMACTPLAN, PRERFECPDF) VALUES (:numActPlan, :fechaPDF) |
PRER00 |
| WSPacs.svc.cs | SELECT 1 FROM PRER00 WHERE PR04NUMACTPLAN = :numActPlan |
PRER00 |
| WSPacs.svc.cs | SELECT SG02COD FROM SG0200 WHERE SG02CODWINDOWS = :codWindows |
SG0200 |
| WSPacs.svc.cs | SELECT pr09fecpeticion FROM PR0300,PR0900,PR0400 |
PR0300 |
| WSPacs.svc.cs | select PR01DESCORTA from PR0100, PR0400 where PR0100.PR01CODACTUACION = PR0400.PR01CODACTUACION AND PR0400.PR04NUMACTPLAN = :numActPlan |
PR0100 |
| WSPacs.svc.cs | INSERT INTO PRGB00 (PR04NUMACTPLAN, PRGBFECARCHIVADO) VALUES (:numactplan, sysdate) |
PRGB00 |
| WSPacs.svc.cs | SELECT IM01NumDoc_SEQUENCE.NEXTVAL NUMDOC FROM DUAL |
DUAL |
| WSPacs.svc.cs | SELECT SG02COD_RESP FROM IM0100 WHERE IM01NUMDOC = :numDoc |
IM0100 |
| WSPacs.svc.cs | select 1 from ad0300 where ad31codpuesto = 6 and ad03fecfin is null and sg02cod = :codAyudante |
ad0300 |
| WSPacs.svc.cs | select 1 from im0100 where SG02COD_ayu1 is not null and IM01NUMDOC = :numeroDocumento |
im0100 |
| WSPacs.svc.cs | select SG02COD_ayu1 from im0100 where IM01NUMDOC = :numeroDocumento |
im0100 |
| WSPacs.svc.cs | INSERT INTO IM1500 (IM01NumDoc, IM15CodEstado) VALUES (:numdoc, 1) |
IM1500 |
| WSPacs.svc.cs | select pr04feciniact, pr04fecfinact from pr0400 where pr04numactplan = :numActPlan |
pr0400 |
| WSPacs.svc.cs | select im01fecinimeca from im0100 where im01numdoc = :numdoc |
im0100 |
| WSPacs.svc.cs | select sg02cod_finmeca from im0100 where im01numdoc = :numdoc |
im0100 |