❄️SQL查询项目信息

通过数据库，直接查询测试项目信息

SQL查询语句

SELECT
	  l.LabID AS 实验室
	, l.LotID AS 批号
	, l.LabLotTestID AS 项目ID

	, a.name AS 项目英文名
	, ins.name AS 仪器
	, rea.Name AS 试剂
	, m.Name AS 方法学
	, tem.name  As 温度 
	, u.Name AS URT单位

FROM LabLotTest l


INNER JOIN Test t ON t.TestID =  l.TestID
INNER JOIN Analyte a  ON  a.AnalyteID  =  t.AnalyteID 

INNER JOIN Method m  ON  m.MethodID  =  t.MethodID
INNER JOIN Unit u  ON  u.UnitID  =  t.UnitID


INNER JOIN  Instrument ins ON t.InstrumentID = ins.InstrumentID
INNER JOIN  Reagent  rea  ON  t.ReagentID =  rea.ReagentID 
INNER JOIN  Temperature  tem  ON t.TemperatureID =  tem.TemperatureID 


INNER JOIN LabLot ll  ON  ll.labid = l.LabID and ll.lotid = l.LotID
where l.Status = 1  and ll.Status = 1

ORDER BY l.LabID,l.LotID,l.LabLotTestID

查询结果

实验室	批号	项目ID	项目英文名	仪器	试剂	方法学	温度	URT单位
103183	45830	31196	AST (ASAT/GOT)	Roche cobas 8000	Dedicated Reagent	UV without P5P	37° C	U/L
103183	45830	31197	ALT (ALAT/GPT)	Roche cobas 8000	Dedicated Reagent	UV without P5P	37° C	U/L