NET-EnvioEstudios

🔁 Similar SQL queries found in other services:

,(SELECT CI2200.CI21CODPERSONA FROM CI2200 WHERE CI2200.CI22NUMHISTORIA = :numHis)…
→ also in NET-WS-CRM

INSERT INTO preq00(PREQNUMREG, PR04NUMACTPLAN, PREQINDREALIZADO,…
→ also in NET-AnonimizadorDICOM, NET-WS-Informes

AND PR0400.PR04NUMACTPLAN NOT IN (SELECT PR04NUMACTPLAN FROM PREQ00 WHERE PREQINDINFOVNA =…
→ also in NET-WS-Informes

🗄 Shared DB tables with other services:
CI2200PB1400

📋 Endpoints Overview (0)

Operation ⇅	Verb	Returns ⇅	Parameters	SQLs ⇅	Description	Flags

🔌 Endpoint Details

⚙ Internal Functions (8)

Helper methods inside the service implementation — not part of the public contract.

Private / Protected (8)

privateBooleanUpdateFechaImgPrc3()

privateList<Estudio>ObtenerEstudiosConInforme()

privateBooleanInsertarEstudioPREQ(string numActPlan, string numHistoria)

privateList<Estudio>ObtenerEstudios()

privateList<Estudio>ObtenerEstudiosTelegradiografia()

privateEstudioObtenerEstudioAnterior(Estudio estudioActual)

privateEstudioObtenerEstudioExterno(Estudio estudioActual)

privateBooleanInsertarEventoPB14(Estudio estudio)

🗄 All SQL Queries (8)

File	Query	Tables
Program.cs	UPDATE PRC300	PRC300
Program.cs	SELECT distinct(PR0400.PR04NUMACTPLAN), CI2200.CI22NUMHISTORIA
Program.cs	AND PR0400.PR04NUMACTPLAN NOT IN (SELECT PR04NUMACTPLAN FROM PREQ00 WHERE PREQINDINFOVNA = -1)	PREQ00
Program.cs	INSERT INTO PREQ00 (PREQNUMREG,PR04NUMACTPLAN,PREQINDREALIZADO,PREQDATOS, PREQINDINFOVNA)	PREQ00
Program.cs	SELECT PR0400.PR04NUMACTPLAN,CI2200.CI22NUMHISTORIA
Program.cs	AND PR04NUMACTPLAN NOT IN (SELECT PR04NUMACTPLAN FROM PREQ00)	PREQ00
Program.cs	INSERT INTO PB1400	PB1400
Program.cs	,(SELECT CI2200.CI21CODPERSONA FROM CI2200 WHERE CI2200.CI22NUMHISTORIA = :numHis)	CI2200

📋 Endpoints Overview (0)