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

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

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(