实现医生工作站的历次处方功能的代码(八)
3.2.4历次处方
历次处方这个模块可以实现查询所有处方单。可以根据处方单号、病人姓名、处方事件等进行多条件查询处方单。每点击一条处方单,处方明细的表就会显示出该单的辅助检查项目和所开的药品信息。
主界面截图:
3.2.4(图1)
功能代码实现
多条件查询历次处方信息:
(1)、存储过程代码:
--查询处方单
IF(@Type='FRM_LiCiChuFang_Load_SelectOrdonnance')
BEGIN
SELECT LTRIM(RTRIM(PW_OrdonnanceTable.OrdonnanceID)) AS OrdonnanceID,
LTRIM(RTRIM(PW_OrdonnanceTable.OrdonnanceNumber)) AS OrdonnanceNumber,
LTRIM(RTRIM(PW_OrdonnanceTable.PatientID)) AS PatientID,
LTRIM(RTRIM(BT_PatientTable.PatientName)) AS PatientName,
LTRIM(RTRIM(BT_PatientTable.AS_SexID)) AS AS_SexID,
LTRIM(RTRIM(BT_AttributeDetailsTable.AttributeDetailsName)) AS Sex,
LTRIM(RTRIM(BT_PatientTable.Age)) AS Age,
LTRIM(RTRIM(PW_OrdonnanceTable.PrescriptionDate)) AS PrescriptionDate,
LTRIM(RTRIM(PW_OrdonnanceTable.ClinicTechnicalOffices_TechnicalOfficesID)) AS ClinicTechnicalOffices_TechnicalOfficesID,
LTRIM(RTRIM(BT_TechnicalOfficesTable.TechnicalOfficesName)) AS TechnicalOfficesName,
LTRIM(RTRIM(PW_OrdonnanceTable.TreatmentDoctor_StaffID)) AS TreatmentDoctor_StaffID,
LTRIM(RTRIM(BT_StaffTable.StaffName)) AS StaffName,
LTRIM(RTRIM(PW_OrdonnanceTable.AS_ChargeStatusID)) AS AS_ChargeStatusID,
LTRIM(RTRIM(BT_AttributeDetailsTable_1.AttributeDetailsName)) AS ChargeStatus,
LTRIM(RTRIM(PW_OrdonnanceTable.AS_TakeMedicineStatusID)) AS AS_TakeMedicineStatusID,
LTRIM(RTRIM(BT_AttributeDetailsTable_2.AttributeDetailsName)) AS TakeMedicineStatus,
LTRIM(