实现医生工作站的历次处方功能的代码（八）

实现医生工作站的历次处方功能的代码（八）

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(