Fix Bug #486: [住院医生工作站-临床医嘱] 医嘱检索框不支持全局模糊搜索，未选"医嘱类型"时检索结果为空

Co-Authored-By: Claude Opus 4.7 <noreply@anthropic.com>

openhis-server-new/openhis-application/src/main/java/com/openhis/web/common/appservice/ICommonService.java

@@ -200,9 +200,10 @@ public interface ICommonService {
      * 批号匹配
      *
      * @param encounterIdList 就诊id列表
+     * @param requestIdList 医嘱请求id列表（可选，用于限定仅校验与当前执行医嘱关联的耗材）
      * @return 处理结果
      */
-    R<?> lotNumberMatch(List<Long> encounterIdList);
+    R<?> lotNumberMatch(List<Long> encounterIdList, List<Long> requestIdList);
 
     /**
      * 根据机构ID获取机构名称

openhis-server-new/openhis-application/src/main/java/com/openhis/web/common/appservice/impl/CommonServiceImpl.java

@@ -39,8 +39,10 @@ import com.openhis.web.common.dto.*;
 import com.openhis.web.common.mapper.CommonAppMapper;
 import com.openhis.web.pharmacymanage.dto.InventoryDetailDto;
 import com.openhis.workflow.domain.DeviceDispense;
+import com.openhis.workflow.domain.DeviceRequest;
 import com.openhis.workflow.domain.InventoryItem;
 import com.openhis.workflow.service.IDeviceDispenseService;
+import com.openhis.workflow.service.IDeviceRequestService;
 import com.openhis.workflow.service.IInventoryItemService;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
@@ -99,6 +101,9 @@ public class CommonServiceImpl implements ICommonService {
     @Resource
     private IDeviceDispenseService deviceDispenseService;
 
+    @Resource
+    private IDeviceRequestService deviceRequestService;
+
     /**
      * 获取药房列表
      *
@@ -678,10 +683,11 @@ public class CommonServiceImpl implements ICommonService {
      * 批号匹配
      *
      * @param encounterIdList 就诊id列表
+     * @param requestIdList 医嘱请求id列表（可选，用于限定仅校验与当前执行医嘱关联的耗材）
      * @return 处理结果
      */
     @Override
-    public R<?> lotNumberMatch(List<Long> encounterIdList) {
+    public R<?> lotNumberMatch(List<Long> encounterIdList, List<Long> requestIdList) {
         // 查询患者待发放的药品信息
         List<MedicationDispense> medicationDispenseList = medicationDispenseService
                 .list(new LambdaQueryWrapper<MedicationDispense>().in(MedicationDispense::getEncounterId, encounterIdList)
@@ -798,10 +804,27 @@ public class CommonServiceImpl implements ICommonService {
             }
         }
         // 查询患者待发放的耗材信息
-        List<DeviceDispense> deviceDispenseList = deviceDispenseService
+        LambdaQueryWrapper<DeviceDispense> deviceDispenseQuery = new LambdaQueryWrapper<DeviceDispense>()
-                .list(new LambdaQueryWrapper<DeviceDispense>().in(DeviceDispense::getEncounterId, encounterIdList)
+                .in(DeviceDispense::getEncounterId, encounterIdList)
-                        .eq(DeviceDispense::getStatusEnum, DispenseStatus.PREPARATION.getValue())
+                .eq(DeviceDispense::getStatusEnum, DispenseStatus.PREPARATION.getValue())
-                        .eq(DeviceDispense::getDeleteFlag, DelFlag.NO.getCode()));
+                .eq(DeviceDispense::getDeleteFlag, DelFlag.NO.getCode());
+        // 若传入requestIdList，则仅查询与指定医嘱请求关联的耗材，避免其他未执行医嘱的耗材记录干扰
+        if (requestIdList != null && !requestIdList.isEmpty()) {
+            List<Long> deviceReqIds = deviceRequestService
+                    .list(new LambdaQueryWrapper<DeviceRequest>()
+                            .in(DeviceRequest::getBasedOnId, requestIdList)
+                            .eq(DeviceRequest::getBasedOnTable, CommonConstants.TableName.WOR_SERVICE_REQUEST))
+                    .stream()
+                    .map(DeviceRequest::getId)
+                    .collect(java.util.stream.Collectors.toList());
+            if (!deviceReqIds.isEmpty()) {
+                deviceDispenseQuery.in(DeviceDispense::getDeviceReqId, deviceReqIds);
+            } else {
+                // 无关联的耗材请求，直接跳过耗材校验
+                deviceDispenseQuery.eq(DeviceDispense::getId, -1L);
+            }
+        }
+        List<DeviceDispense> deviceDispenseList = deviceDispenseService.list(deviceDispenseQuery);
         // 耗材批号匹配
         if (deviceDispenseList != null && !deviceDispenseList.isEmpty()) {
             // 获取待发放的耗材id

openhis-server-new/openhis-application/src/main/java/com/openhis/web/common/controller/CommonAppController.java

@@ -274,10 +274,13 @@ public class CommonAppController {
      * 批号匹配
      *
      * @param encounterIdList 就诊id列表
+     * @param requestIdList 医嘱请求id列表（可选，用于限定仅校验与当前执行医嘱关联的耗材）
      * @return 处理结果
      */
     @GetMapping("/lot-number-match")
-    public R<?> lotNumberMatch(@RequestParam(value = "encounterIdList") List<Long> encounterIdList) {
+    public R<?> lotNumberMatch(
-        return commonService.lotNumberMatch(encounterIdList);
+            @RequestParam(value = "encounterIdList") List<Long> encounterIdList,
+            @RequestParam(value = "requestIdList", required = false) List<Long> requestIdList) {
+        return commonService.lotNumberMatch(encounterIdList, requestIdList);
     }
 }

openhis-server-new/openhis-application/src/main/java/com/openhis/web/doctorstation/appservice/impl/DoctorStationAdviceAppServiceImpl.java

@@ -728,8 +728,12 @@ public class DoctorStationAdviceAppServiceImpl implements IDoctorStationAdviceAp
 
             /**
              * 处理耗材请求
+             * 🔧 BugFix #443: 签发时跳过 handDevice，避免重复创建 DeviceDispense 并覆盖关键字段（如 performLocation）
+             * 签发时只需更新状态（下方 sign-advice 批量更新逻辑已处理）
              */
-            this.handDevice(deviceList, curDate, adviceOpType);
+            if (AdviceOpType.SAVE_ADVICE.getCode().equals(adviceOpType)) {
+                this.handDevice(deviceList, curDate, adviceOpType);
+            }
 
             // 签发时,把草稿状态的账单更新为待收费
             if (AdviceOpType.SIGN_ADVICE.getCode().equals(adviceOpType) && !adviceSaveList.isEmpty()) {
@@ -2103,11 +2107,9 @@ public class DoctorStationAdviceAppServiceImpl implements IDoctorStationAdviceAp
                 CommonConstants.TableName.MED_MEDICATION_REQUEST, CommonConstants.TableName.WOR_DEVICE_REQUEST,
                 CommonConstants.TableName.WOR_SERVICE_REQUEST, practitionerId, Whether.NO.getCode(),
                 sourceEnum, sourceBillNo);
-        // 手术计费场景：sourceBillNo 不为空时，过滤掉药品（1），保留耗材（2）和诊疗（3/6）
+        // 🔧 修复 Bug #444: 移除手术计费场景的药品过滤。
-        if (sourceBillNo != null && !sourceBillNo.isEmpty()) {
+        // 原过滤会导致门诊手术医嘱界面无法获取手术计费创建的药品记录。
-            requestBaseInfo.removeIf(dto -> dto.getAdviceType() != null
+        // 前端各组件已根据自身业务逻辑做了正确的 adviceType 过滤。
-                    && dto.getAdviceType() == 1);
-        }
         for (RequestBaseDto requestBaseDto : requestBaseInfo) {
             // 请求状态
             requestBaseDto

openhis-server-new/openhis-application/src/main/java/com/openhis/web/doctorstation/appservice/impl/DoctorStationDiagnosisAppServiceImpl.java

@@ -36,6 +36,9 @@ import org.springframework.stereotype.Service;
 
 import javax.annotation.Resource;
 import javax.servlet.http.HttpServletRequest;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+import java.time.ZoneId;
 import java.util.Date;
 import java.util.*;
 
@@ -243,7 +246,8 @@ public class DoctorStationDiagnosisAppServiceImpl implements IDoctorStationDiagn
         EncounterDiagnosis encounterDiagnosis;
         for (SaveDiagnosisChildParam saveDiagnosisChildParam : diagnosisChildList) {
             encounterDiagnosis = new EncounterDiagnosis();
-            encounterDiagnosis.setId(saveDiagnosisChildParam.getEncounterDiagnosisId());
+            // 注意：不设置 encounterDiagnosisId，因为上面已经删除了所有记录
+            // 如果设置旧的 ID，saveOrUpdate 会尝试 UPDATE 不存在的记录导致失败或重复插入
             encounterDiagnosis.setEncounterId(encounterId);
             encounterDiagnosis.setConditionId(saveDiagnosisChildParam.getConditionId());
             encounterDiagnosis.setMaindiseFlag(saveDiagnosisChildParam.getMaindiseFlag());
@@ -598,6 +602,25 @@ public class DoctorStationDiagnosisAppServiceImpl implements IDoctorStationDiagn
         InfectiousDiseaseReport infectiousDiseaseReport = new InfectiousDiseaseReport();
         BeanUtils.copyProperties(infectiousDiseaseReportDto, infectiousDiseaseReport);
 
+        // BeanUtils.copyProperties 不支持 LocalDate/LocalDateTime 到 java.util.Date 的类型转换，需手动处理
+        if (infectiousDiseaseReportDto.getOnsetDate() != null) {
+            infectiousDiseaseReport.setOnsetDate(
+                Date.from(infectiousDiseaseReportDto.getOnsetDate().atStartOfDay(ZoneId.systemDefault()).toInstant()));
+        }
+        if (infectiousDiseaseReportDto.getDiagDate() != null) {
+            infectiousDiseaseReport.setDiagDate(
+                Date.from(infectiousDiseaseReportDto.getDiagDate().atZone(ZoneId.systemDefault()).toInstant()));
+        }
+        // deathDate / reportDate 同理
+        if (infectiousDiseaseReportDto.getDeathDate() != null) {
+            infectiousDiseaseReport.setDeathDate(
+                Date.from(infectiousDiseaseReportDto.getDeathDate().atStartOfDay(ZoneId.systemDefault()).toInstant()));
+        }
+        if (infectiousDiseaseReportDto.getReportDate() != null) {
+            infectiousDiseaseReport.setReportDate(
+                Date.from(infectiousDiseaseReportDto.getReportDate().atStartOfDay(ZoneId.systemDefault()).toInstant()));
+        }
+
         /**
          * 设置创建人、删除状态、租户ID
          */

openhis-server-new/openhis-application/src/main/java/com/openhis/web/doctorstation/dto/DiagnosisQueryDto.java

@@ -96,4 +96,9 @@ public class DiagnosisQueryDto {
      */
     private String diagnosisDoctor;
 
+    /**
+     * 是否已有传染病报卡（0-无，1-有）
+     */
+    private Integer hasInfectiousReport;
+
 }

openhis-server-new/openhis-application/src/main/java/com/openhis/web/inventorymanage/appservice/impl/RequisitionIssueAppServiceImpl.java

@@ -3,29 +3,38 @@
  */
 package com.openhis.web.inventorymanage.appservice.impl;
 
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.core.common.core.domain.R;
+import com.core.common.exception.ServiceException;
 import com.core.common.utils.*;
 import com.core.common.utils.bean.BeanUtils;
+import com.openhis.administration.domain.DeviceDefinition;
 import com.openhis.administration.domain.Practitioner;
+import com.openhis.administration.service.IDeviceDefinitionService;
 import com.openhis.administration.service.IPractitionerService;
 import com.openhis.common.constant.CommonConstants;
 import com.openhis.common.constant.PromptMsgConstant;
 import com.openhis.common.enums.*;
 import com.openhis.common.utils.EnumUtils;
 import com.openhis.common.utils.HisQueryUtils;
+import com.openhis.medication.domain.MedicationDefinition;
+import com.openhis.medication.service.IMedicationDefinitionService;
 import com.openhis.web.common.dto.UnitDto;
 import com.openhis.web.inventorymanage.appservice.IRequisitionIssueAppService;
 import com.openhis.web.inventorymanage.dto.*;
 import com.openhis.web.inventorymanage.mapper.RequisitionIssueMapper;
+import com.openhis.workflow.domain.InventoryItem;
 import com.openhis.workflow.domain.SupplyRequest;
+import com.openhis.workflow.service.IInventoryItemService;
 import com.openhis.workflow.service.ISupplyRequestService;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 
 import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;
+import java.math.BigDecimal;
 import java.util.*;
 import java.util.stream.Collectors;
 import java.util.stream.Stream;
@@ -48,6 +57,15 @@ public class RequisitionIssueAppServiceImpl implements IRequisitionIssueAppServi
     @Autowired
     private IPractitionerService practitionerService;
 
+    @Autowired
+    private IInventoryItemService inventoryItemService;
+
+    @Autowired
+    private IMedicationDefinitionService medicationDefinitionService;
+
+    @Autowired
+    private IDeviceDefinitionService deviceDefinitionService;
+
     @Autowired
     private AssignSeqUtil assignSeqUtil;
 
@@ -167,6 +185,10 @@ public class RequisitionIssueAppServiceImpl implements IRequisitionIssueAppServi
 
         // 单据号取得
         List<String> busNoList = requisitionIssueDtoList.stream().map(IssueDto::getBusNo).collect(Collectors.toList());
+
+        // 库存校验：领用数量不能超过源仓库实际库存
+        this.validateRequisitionStock(requisitionIssueDtoList);
+
         // 请求数据取得
         List<SupplyRequest> requestList = supplyRequestService.getSupplyByBusNo(busNoList.get(0));
         if (!requestList.isEmpty()) {
@@ -328,4 +350,73 @@ public class RequisitionIssueAppServiceImpl implements IRequisitionIssueAppServi
             }
         }
     }
+
+    /**
+     * 校验领用数量是否超过源仓库实际库存
+     *
+     * @param requisitionIssueDtoList 领用出库单据列表
+     */
+    private void validateRequisitionStock(List<IssueDto> requisitionIssueDtoList) {
+        Integer tenantId = SecurityUtils.getLoginUser().getTenantId();
+        for (IssueDto issueDto : requisitionIssueDtoList) {
+            Long itemId = issueDto.getItemId();
+            String lotNumber = issueDto.getLotNumber();
+            Long sourceLocationId = issueDto.getSourceLocationId();
+            BigDecimal reqQuantity = issueDto.getItemQuantity();
+            String itemUnit = issueDto.getUnitCode();
+            String itemTable = issueDto.getItemTable();
+
+            // 根据物品类型查询定义信息（拆零比、常规单位、最小单位）
+            BigDecimal partPercent = BigDecimal.ONE;
+            String unitCode = itemUnit;
+            String minUnitCode = itemUnit;
+
+            if (CommonConstants.TableName.MED_MEDICATION_DEFINITION.equals(itemTable)) {
+                MedicationDefinition medDef = medicationDefinitionService.getById(itemId);
+                if (medDef != null) {
+                    unitCode = medDef.getUnitCode();
+                    minUnitCode = medDef.getMinUnitCode();
+                    if (medDef.getPartPercent() != null) {
+                        partPercent = medDef.getPartPercent();
+                    }
+                }
+            } else if (CommonConstants.TableName.ADM_DEVICE_DEFINITION.equals(itemTable)) {
+                DeviceDefinition devDef = deviceDefinitionService.getById(itemId);
+                if (devDef != null) {
+                    unitCode = devDef.getUnitCode();
+                    minUnitCode = devDef.getMinUnitCode();
+                    if (devDef.getPartPercent() != null) {
+                        partPercent = devDef.getPartPercent();
+                    }
+                }
+            }
+
+            // 计算领用数量折合最小单位的值
+            BigDecimal reqQuantityInMinUnit;
+            if (itemUnit.equals(unitCode)) {
+                // 领用单位 = 包装单位，需乘以拆零比
+                reqQuantityInMinUnit = reqQuantity.multiply(partPercent);
+            } else {
+                // 领用单位 = 最小单位，无需换算
+                reqQuantityInMinUnit = reqQuantity;
+            }
+
+            // 查询源仓库实际库存（按物品编号、批号、仓库匹配）
+            List<InventoryItem> inventoryItemList = inventoryItemService.selectInventoryByItemId(
+                    itemId, lotNumber, sourceLocationId, tenantId);
+
+            // 累加匹配批号的总库存（库存表quantity字段为最小单位）
+            BigDecimal totalStock = BigDecimal.ZERO;
+            for (InventoryItem inventoryItem : inventoryItemList) {
+                if (inventoryItem.getLocationId().equals(sourceLocationId)) {
+                    totalStock = totalStock.add(inventoryItem.getQuantity());
+                }
+            }
+
+            // 比较领用数量与库存
+            if (reqQuantityInMinUnit.compareTo(totalStock) > 0) {
+                throw new ServiceException("操作失败，库存数量不足");
+            }
+        }
+    }
 }

openhis-server-new/openhis-application/src/main/java/com/openhis/web/regdoctorstation/appservice/impl/RequestFormManageAppServiceImpl.java

@@ -81,28 +81,35 @@ public class RequestFormManageAppServiceImpl implements IRequestFormManageAppSer
         Long requestFormId = requestFormSaveDto.getRequestFormId();
         boolean isEdit = requestFormId != null && requestFormId != 0L;
 
-        // 诊疗执行科室配置校验（必须在任何数据库操作之前）
+        // 校验所有activityList中的项目是否都配置了执行科室，并收集positionId供后续使用
-        List<ActivityOrganizationConfigDto> activityOrganizationConfig =
-            requestFormManageAppMapper.getActivityOrganizationConfig(typeCode);
-        if (activityOrganizationConfig.isEmpty()) {
-            throw new ServiceException("请先配置当前时间段的执行科室");
-        }
-
-        // 逐个校验activityList中的项目是否都配置了执行科室，并收集positionId供后续使用
         // 必须在任何数据库操作之前完成全部校验，避免部分保存后异常导致脏数据
         List<ActivitySaveDto> activityList = requestFormSaveDto.getActivityList();
-        // 缓存校验结果，避免主循环中重复查询和可能出现的数据不一致
+        if (activityList == null || activityList.isEmpty()) {
+            throw new ServiceException("请选择检查项目");
+        }
+
+        // 🔧 Bug #475: 查询诊疗执行科室配置
+        List<ActivityOrganizationConfigDto> activityOrganizationConfig =
+            requestFormManageAppMapper.getActivityOrganizationConfig(typeCode);
+
+        // 缓存校验结果，先全部验证通过后再进行数据库操作
+        // 优先使用前端传入的positionId（用户手动选择的发往科室），仅在未选择时使用配置的执行科室
         java.util.Map<Long, Long> activityIdToPositionIdMap = new java.util.HashMap<>();
-        if (activityList != null && !activityList.isEmpty()) {
+        for (ActivitySaveDto activitySaveDto : activityList) {
-            for (ActivitySaveDto activitySaveDto : activityList) {
+            // 优先使用前端传入的positionId（用户手动选择的科室）
-                Long positionId = activityOrganizationConfig.stream()
+            Long frontendPositionId = activitySaveDto.getPositionId();
-                    .filter(dto -> activitySaveDto.getAdviceDefinitionId().equals(dto.getActivityDefinitionId()))
+            if (frontendPositionId != null) {
-                    .map(ActivityOrganizationConfigDto::getOrganizationId).findFirst().orElse(null);
+                activityIdToPositionIdMap.put(activitySaveDto.getAdviceDefinitionId(), frontendPositionId);
-                if (positionId == null) {
+                continue;
-                    throw new ServiceException(activitySaveDto.getAdviceDefinitionName() + "未配置当前时间段的执行科室");
-                }
-                activityIdToPositionIdMap.put(activitySaveDto.getAdviceDefinitionId(), positionId);
             }
+            // 前端未传入时，使用配置的执行科室
+            Long configPositionId = activityOrganizationConfig.stream()
+                .filter(dto -> activitySaveDto.getAdviceDefinitionId().equals(dto.getActivityDefinitionId()))
+                .map(ActivityOrganizationConfigDto::getOrganizationId).findFirst().orElse(null);
+            if (configPositionId == null) {
+                throw new ServiceException(activitySaveDto.getAdviceDefinitionName() + "未配置当前时间段的执行科室");
+            }
+            activityIdToPositionIdMap.put(activitySaveDto.getAdviceDefinitionId(), configPositionId);
         }
 
         // 诊疗处方号

openhis-server-new/openhis-application/src/main/resources/mapper/clinicalmanage/SurgicalScheduleAppMapper.xml

@@ -91,13 +91,15 @@
             os.surgery_nature AS surgeryType,
             cs.incision_level AS incisionLevel,
             fc.contract_name AS feeType,
-            os.fee_type AS feeType,
             COALESCE(pi.identifier_no, ap.bus_no, '') AS identifierNo
         FROM op_schedule os
         LEFT JOIN adm_patient ap ON os.patient_id = ap.id
         INNER JOIN cli_surgery cs ON os.oper_code = cs.surgery_no AND cs.delete_flag = '0'
         LEFT JOIN adm_organization o ON cs.org_id = o.id
         LEFT JOIN doc_request_form drf ON drf.prescription_no=cs.surgery_no
+        LEFT JOIN adm_encounter ae ON ae.id = os.visit_id AND ae.delete_flag = '0'
+        LEFT JOIN adm_account aa ON aa.encounter_id = ae.id AND aa.delete_flag = '0'
+        LEFT JOIN fin_contract fc ON fc.bus_no = aa.contract_no AND fc.delete_flag = '0'
         LEFT JOIN (
             SELECT patient_id, identifier_no
             FROM (

openhis-server-new/openhis-application/src/main/resources/mapper/datadictionary/ActivityDefinitionManageMapper.xml

@@ -42,8 +42,8 @@
             T5.package_name,
             T6.name as sub_item_name
         FROM wor_activity_definition T1
-        /* 只JOIN必要的价格表，使用INNER JOIN避免笛卡尔积 */
+        /* 价格表使用LEFT JOIN，避免因缺少价格记录导致搜索不到项目 */
-        INNER JOIN adm_charge_item_definition T2
+        LEFT JOIN adm_charge_item_definition T2
             ON T1.id = T2.instance_id
             AND T2.instance_table = 'wor_activity_definition'
         /* 检验类型关联 */

openhis-server-new/openhis-application/src/main/resources/mapper/doctorstation/DoctorStationDiagnosisAppMapper.xml

@@ -134,7 +134,11 @@
                T2.yb_no,
                T1.onset_date AS onsetDate,
                T1.diagnosis_time AS diagnosisTime,
-               T1.doctor AS diagnosisDoctor
+               T1.doctor AS diagnosisDoctor,
+               CASE WHEN EXISTS (
+                   SELECT 1 FROM infectious_card T4
+                   WHERE T4.diag_id = T2.id AND T4.delete_flag = '0' AND T4.status >= 1
+               ) THEN 1 ELSE 0 END AS hasInfectiousReport
         FROM adm_encounter_diagnosis AS T1
                  LEFT JOIN cli_condition AS T2 ON T2.ID = T1.condition_id
             AND T2.delete_flag = '0' AND T2.tcm_flag = 0

openhis-server-new/openhis-application/src/main/resources/mapper/regdoctorstation/RequestFormManageAppMapper.xml

@@ -45,18 +45,6 @@
           <if test="endDate != null and endDate != ''">
               AND drf.create_time &lt;= (#{endDate}::date + INTERVAL '1 day' - INTERVAL '1 second')
           </if>
-          <if test="status != null and status != ''">
-               AND CASE
-                       WHEN MIN(wsr.status_enum) = 1 THEN 0
-                       WHEN MIN(wsr.status_enum) = 2 THEN 1
-                       WHEN MIN(wsr.status_enum) = 3 AND MAX(CASE WHEN wsr.performer_check_id IS NOT NULL THEN 1 ELSE 0 END) = 1 THEN 2
-                       WHEN MIN(wsr.status_enum) = 3 THEN 4
-                       WHEN MIN(wsr.status_enum) = 4 THEN 3
-                       WHEN MIN(wsr.status_enum) = 5 OR MIN(wsr.status_enum) = 6 OR MIN(wsr.status_enum) = 7 THEN 7
-                       WHEN MIN(wsr.status_enum) = 8 THEN 6
-                       ELSE NULL
-                   END = #{status}::integer
-          </if>
           <if test="keyword != null and keyword != ''">
               AND (drf.prescription_no ILIKE '%' || #{keyword} || '%'
                    OR EXISTS (
@@ -72,12 +60,29 @@
           </if>
         GROUP BY drf.id, drf.encounter_id, drf.prescription_no, drf.name, drf.desc_json,
                  drf.requester_id, drf.create_time, ap.name
+        <if test="status != null and status != ''">
+            HAVING CASE MIN(wsr.status_enum)
+                       WHEN 1 THEN 0
+                       WHEN 2 THEN 1
+                       WHEN 3 THEN 4
+                       WHEN 4 THEN 4
+                       WHEN 5 THEN 5
+                       WHEN 6 THEN 5
+                       WHEN 7 THEN 5
+                       WHEN 8 THEN 6
+                       ELSE NULL
+                   END = #{status}::integer
+        </if>
     </select>
 
     <select id="getRequestFormDetail" resultType="com.openhis.web.regdoctorstation.dto.RequestFormDetailQueryDto">
         SELECT wsr.quantity,
                wsr.unit_code,
-               COALESCE(wad.NAME, wsr.content_json::jsonb->>'surgeryName') AS advice_name,
+               COALESCE(
+                   wad.NAME,
+                   wsr.content_json::jsonb->>'surgeryName',
+                   '检验项目'
+               ) AS advice_name,
                aci.total_price
         FROM wor_service_request AS wsr
                  LEFT JOIN wor_activity_definition AS wad ON wad.ID = wsr.activity_id
@@ -87,6 +92,7 @@
             AND aci.delete_flag = '0'
         WHERE wsr.delete_flag = '0'
           AND wsr.prescription_no = #{prescriptionNo}
+        ORDER BY wsr.id
     </select>
 
     <select id="getActivityOrganizationConfig"

openhis-ui-vue3/src/views/doctorstation/components/diagnosis/diagnosis.vue

@@ -692,6 +692,7 @@ async function handleFoodDiseasesCheck() {
 /**
  * 传染病报告卡处理
  * 通过诊断名称自动识别并勾选传染病报告卡中的疾病
+ * 修复 Bug #519：跳过已有已提交报卡的诊断
  */
 function handleInfectiousDiseaseReport() {
   // 疾病名称到报卡编码的映射（根据传染病报告卡弹窗中的疾病列表）
@@ -743,8 +744,9 @@ function handleInfectiousDiseaseReport() {
     '手足口病': '0311',
   };
 
-  // 获取所有诊断名称对应的报卡编码
+  // 获取所有诊断名称对应的报卡编码，但跳过已有已提交报卡的诊断
   const allSelectedDiseases = form.value.diagnosisList
+    .filter(d => d.name && d.hasInfectiousReport !== 1)
     .map(d => diseaseNameToCode[d.name] || null)
     .filter(code => code);
 
@@ -752,9 +754,9 @@ function handleInfectiousDiseaseReport() {
     return;
   }
 
-  // 优先使用主诊断
+  // 优先使用主诊断（同样跳过已有报卡的）
-  const mainDiagnosis = form.value.diagnosisList.find(d => d.maindiseFlag === 1);
+  const mainDiagnosis = form.value.diagnosisList.find(d => d.maindiseFlag === 1 && d.hasInfectiousReport !== 1);
-  const firstDiagnosis = form.value.diagnosisList[0];
+  const firstDiagnosis = form.value.diagnosisList.find(d => d.hasInfectiousReport !== 1) || form.value.diagnosisList[0];
 
   const diagnosisToShow = {
     ...(mainDiagnosis || firstDiagnosis),

openhis-ui-vue3/src/views/doctorstation/components/diagnosis/infectiousDiseaseReportDialog.vue

@@ -1034,6 +1034,17 @@ function normalizeSex(value) {
   return '未知';
 }
 
+function normalizeSexFromPatientInfo(patientInfo) {
+  // 优先使用文本字段
+  if (patientInfo.genderEnum_enumText) return patientInfo.genderEnum_enumText;
+  if (patientInfo.genderName) return patientInfo.genderName;
+  if (patientInfo.sex) return normalizeSex(patientInfo.sex);
+  // 使用数字枚举字段
+  if (patientInfo.genderEnum === 1) return '男';
+  if (patientInfo.genderEnum === 2) return '女';
+  return '未知';
+}
+
 function normalizeAgeUnit(value) {
   const ageUnitMap = {
     1: '岁',
@@ -1295,7 +1306,7 @@ async function show(diagnosisData) {
     patName: patientInfo.patientName || patientInfo.name || '', // 患者姓名
     parentName: '', // 家长姓名（14岁以下患者必填）
     idNo: patientInfo.idCard, // 身份证号
-    sex: patientInfo.sex || patientInfo.genderName || '男', // 性别
+    sex: normalizeSexFromPatientInfo(patientInfo), // 性别
 
     // 出生日期信息
     birthYear: birthInfo.year, // 出生年份

openhis-ui-vue3/src/views/doctorstation/components/examination/examinationApplication.vue

@@ -1226,22 +1226,18 @@ function handleRowClick(row) {
   selectedItems.value = [];
   activeDetailTab.value = 'applyForm';
   request({ url: `/exam/apply/${row.applyNo}`, method: 'get' }).then(async res => {
-    // 响应结构判定：Axios拦截器对 code===200 返回 res.data（AjaxResult体），
+    // 响应结构: Axios拦截器对code===200返回res.data（AjaxResult体）
-    // 但某些情况下可能返回完整 Axios 响应 {data: AjaxResult}。
+    // 结构为 { code: 200, data: examApply实体, items: [明细数组] }
-    // 用 res.code 判定是否已是 AjaxResult 体，避免二次解包导致 items 丢失。
+    const items = Array.isArray(res.items) ? res.items : [];
-    const isAjaxResult = res && typeof res === 'object' && res.code !== undefined;
+    const dataObj = res.data || {};
-    const ajaxBody = isAjaxResult ? res : (res.data || res);
 
-    // items 在 AjaxResult 顶层，data 字段是 ExamApply 实体
+    // 先填充表单字段
-    const rawItems = Array.isArray(ajaxBody.items) ? ajaxBody.items : [];
+    if (dataObj && typeof dataObj === 'object') Object.assign(form, dataObj);
-    const detailData = ajaxBody.data || {};
 
-    if (detailData && typeof detailData === 'object') Object.assign(form, detailData);
+    if (items.length > 0) {
-
-    if (rawItems.length > 0) {
       try {
         // 为每个项目加载检查方法
-        const itemsWithMethods = await Promise.all(rawItems.map(async m => {
+        const itemsWithMethods = await Promise.all(items.map(async m => {
           const item = {
             id: m.itemCode, name: m.itemName,
             price: m.itemFee || 0, quantity: 1,
@@ -1260,7 +1256,7 @@ function handleRowClick(row) {
           if (m.bodyPartCode) {
             try {
               const methodRes = await searchCheckMethod({ checkType: m.bodyPartCode });
-              // Bug #384修复: 正确解析 API 返回结构
+              // 正确解析 API 返回结构
               let methodData = methodRes?.data?.data || methodRes?.data || methodRes?.rows || methodRes;
               if (!Array.isArray(methodData) && methodRes?.data && Array.isArray(methodRes.data.data)) {
                 methodData = methodRes.data.data;
@@ -1270,16 +1266,15 @@ function handleRowClick(row) {
                   id: md.id,
                   name: md.name,
                   code: md.code,
-                  price: m.itemFee || 0,  // fallback 到已保存的价格
+                  price: m.itemFee || 0,
                   packageName: md.packageName || '',
                   packageId: md.packageId || null,
-                  packagePrice: md.packagePrice || null,  // Bug #384修复: 套餐价格
+                  packagePrice: md.packagePrice || null,
                   serviceFee: md.serviceFee || null
                 }));
-                // 如果有已保存的检查方法信息，尝试匹配
+                // 回充已保存的检查方法
                 if (m.checkMethodId) {
-                  item.selectedMethod = item.methods.find(md => md.id === m.checkMethodId) || null;
+                  item.selectedMethod = item.methods.find(md => String(md.id) === String(m.checkMethodId)) || null;
-                  // 从已保存的方法中获取套餐信息
                   if (item.selectedMethod?.packageId) {
                     item.isPackage = true;
                     item.packageId = item.selectedMethod.packageId;
@@ -1295,22 +1290,27 @@ function handleRowClick(row) {
               }
             } catch (err) {
               console.error('加载检查方法失败', err);
-              // 单个项目加载失败不影响其他项目，继续返回 item
             }
           }
           return item;
         }));
+        // Bug #408修复: 确保明细数据正确加载到selectedItems
         selectedItems.value = itemsWithMethods;
+        // 加载套餐明细（单个失败不影响其他项目和明细显示）
         for (const it of selectedItems.value) {
           if (getPackageCarrier(it)?.packageId) {
-            await loadPackageDetailsForItem(it);
+            try {
+              await loadPackageDetailsForItem(it);
+            } catch (e) {
+              console.error('加载套餐明细失败:', it.name, e);
+            }
           }
           it.expanded = !!getPackageCarrier(it)?.packageId;
         }
         syncCategoryChecked();
         // Bug #384修复: 回充后更新检查方法显示
         updateMethodDisplay();
-        // 修复【#408】：加载申请单详情后自动切换到检查明细页签，确保已加载的明细数据可见
+        // Bug #408修复: 加载申请单详情后自动切换到检查明细页签，确保已加载的明细数据可见
         activeDetailTab.value = 'applyDetail';
       } catch (err) {
         console.error('加载申请单详情失败', err);
@@ -1362,8 +1362,9 @@ async function handleMethodSelect(checked, method, cat) {
         existingItem.isPackage = true;
         existingItem.packageId = method.packageId;
         existingItem.packageName = method.packageName || existingItem.packageName;  // #428修复: 确保 packageName 同步
+        existingItem.expanded = true;  // #428修复: 有套餐时默认展开，展示套餐明细
         // 预加载套餐明细
-        loadPackageDetailsForItem(existingItem);
+        await loadPackageDetailsForItem(existingItem);
       }
       updateMethodDisplay();
       return;
@@ -1399,9 +1400,10 @@ async function handleMethodSelect(checked, method, cat) {
     };
     selectedItems.value.push(newItem);
 
-    // 如果是套餐，预加载套餐明细
+    // 如果是套餐，预加载套餐明细并默认展开
     if (newItem.isPackage && newItem.packageId) {
-      loadPackageDetailsForItem(newItem);
+      newItem.expanded = true;
+      await loadPackageDetailsForItem(newItem);
     }
 
     // 自动回填执行科室
@@ -1523,7 +1525,10 @@ async function handleItemSelect(checked, item, cat) {
 // Bug #384修复 + #426修复: 展开/收起项目卡片
 async function toggleItemExpand(item) {
   item.expanded = !item.expanded;
-  if (item.expanded && (item.isPackage || item.packageName) && (!item.packageDetails || item.packageDetails.length === 0) && !item.packageDetailsLoading) {
+  const carrier = getPackageCarrier(item);
+  const hasDetails = Array.isArray(item.packageDetailsDisplay) && item.packageDetailsDisplay.length > 0
+    || Array.isArray(carrier?.packageDetails) && carrier.packageDetails.length > 0;
+  if (item.expanded && (item.isPackage || item.packageName) && !hasDetails && !item.packageDetailsLoading) {
     await loadPackageDetailsForItem(item);
   }
   if (item.expanded && shouldShowPackageBody(item)) {
@@ -1577,7 +1582,7 @@ async function loadMethodPackageDetails(item, method) {
     const packageId = packages[0].id;
     // 查询套餐明细
     const detailRes = await request({
-      url: `/system/package/${packageId}/details`,
+      url: `/system/check-type/package/${packageId}/details`,
       method: 'get'
     });
     if (detailRes.code === 200 && detailRes.data) {

openhis-ui-vue3/src/views/doctorstation/components/prescription/prescriptionlist.vue

@@ -1026,7 +1026,7 @@ const mapAdviceTypeLabel = (type, adviceTableName) => {
     return found.label;
   }
 
-  // 🔧 Bug #458 Fix: 诊疗/手术类型字典缺失时的兜底，避免保存后"医嘱类型"列显示为空
+  // 🔧 Bug #458 Fix: 诊疗/手术类型字典缺失或标签为空时的兜底
   if (adviceTableName === 'wor_activity_definition' || adviceTableName === 'wor_service_request') {
     if (type === 6) return '手术';
     if (type === 4) return '手术';
@@ -1036,6 +1036,15 @@ const mapAdviceTypeLabel = (type, adviceTableName) => {
     return '诊疗';
   }
 
+  // 🔧 Bug #458 Fix: 兜底映射，确保所有有效 adviceType 都有显示标签
+  // 不依赖字典数据和表名，直接返回标准类型名称
+  if (type === 3) return '诊疗';
+  if (type === 6) return '手术';
+  if (type === 4) return '耗材';
+  if (type === 1) return '西药';
+  if (type === 2) return '中成药';
+  if (type === 5) return '会诊';
+
   return '';
 };
 
@@ -1658,12 +1667,16 @@ function getListInfo(addNewRow) {
                               contentJson?.consultationRequestId;
         
         let adviceType = item.adviceType;
-        
+
         // 🔧 Bug Fix: 后端保存时将耗材(4)转换为中成药(2)，显示时需要转换回来
         // 检查 adviceTableName，如果是耗材表则应该是耗材类型
         const adviceTableName = contentJson?.adviceTableName || item.adviceTableName;
-        
+
-        let adviceType_dictText = item.adviceType_dictText || mapAdviceTypeLabel(adviceType, adviceTableName);
+        // 🔧 Bug #458 Fix: 后端可能返回空字符串的 adviceType_dictText，需重新计算
+        const backendDictText = item.adviceType_dictText;
+        let adviceType_dictText = (backendDictText && backendDictText.trim())
+          ? backendDictText
+          : mapAdviceTypeLabel(adviceType, adviceTableName);
         
         // 如果是会诊类型，设置为会诊类型
         if (isConsultation) {

openhis-ui-vue3/src/views/doctorstation/components/surgery/surgeryApplication.vue

@@ -636,12 +636,11 @@ function getList() {
     if (res.code === 200) {
       surgeryList.value = res.data?.records || []
     } else {
-      proxy.$modal.msgError(res.msg || '数据加载失败，请稍后重试')
+      console.warn('手术列表加载失败（可能无权限或数据异常）:', res.msg)
       surgeryList.value = []
     }
   }).catch(error => {
-    console.error('获取手术列表失败:', error)
+    console.warn('手术列表请求异常:', error)
-    proxy.$modal.msgError('数据加载失败，请稍后重试')
     surgeryList.value = []
   }).finally(() => {
     loading.value = false
@@ -1142,8 +1141,8 @@ function submitForm() {
             // 保存麻醉方式
             sessionStorage.setItem('anesthesiaType', form.value.anesthesiaTypeEnum)
             open.value = false
-            getList() // 提交成功后直接刷新列表
+            // 由父组件 @saved 事件负责刷新列表（带延迟确保后端事务已提交）
-            emit('saved') // 通知父组件刷新医嘱列表
+            emit('saved')
           } else {
             proxy.$modal.msgError(res.msg || '新增手术失败，请检查表单信息')
           }
@@ -1159,8 +1158,8 @@ function submitForm() {
             // 保存麻醉方式
             sessionStorage.setItem('anesthesiaType', form.value.anesthesiaTypeEnum)
             open.value = false
-            getList() // 修改成功后直接刷新列表
+            // 由父组件 @saved 事件负责刷新列表
-            emit('saved') // 通知父组件刷新医嘱列表
+            emit('saved')
           } else {
             proxy.$modal.msgError(res.msg || '更新手术失败，请检查表单信息')
           }

openhis-ui-vue3/src/views/doctorstation/index.vue

@@ -153,7 +153,7 @@
           </el-tab-pane>
           <el-tab-pane label="手术申请" name="surgery">
             <surgeryApplication :patientInfo="patientInfo" :activeTab="activeTab" ref="surgeryRef"
-              @saved="() => { prescriptionRef?.getListInfo(); surgeryRef?.getList() }" />
+              @saved="() => { prescriptionRef?.getListInfo(); setTimeout(() => surgeryRef?.getList(), 500) }" />
           </el-tab-pane>
           <el-tab-pane label="电子处方" name="eprescription">
             <eprescriptionlist :patientInfo="patientInfo" ref="eprescriptionRef" />

openhis-ui-vue3/src/views/inpatientDoctor/home/components/applicationShow/examineApplication.vue

@@ -678,15 +678,16 @@ const handlePrint = async (row) => {
     }
 
     // 构建 descJson 字段行（与详情弹窗展示的字段一致）
-    const fieldKeys = ['targetDepartment', 'symptom', 'sign', 'clinicalDiagnosis', 'otherDiagnosis', 'relatedResult', 'attention'];
+    const fieldKeys = ['targetDepartment', 'urgencyLevel', 'expectedExaminationTime', 'allergyHistory', 'examinationPurpose', 'medicalHistorySummary', 'symptom', 'sign', 'clinicalDiagnosis', 'otherDiagnosis', 'relatedResult', 'attention'];
     let descFieldsHtml = '';
     fieldKeys.forEach((key) => {
       const label = labelMap[key] || key;
-      if (descData[key] != null && descData[key] !== '') {
+      const value = transformField(key, descData[key]);
+      if (value != null && value !== '') {
         descFieldsHtml += `
           <div class="info-row">
             <span class="label">${label}：</span>
-            <span class="value">${descData[key]}</span>
+            <span class="value">${value}</span>
           </div>`;
       }
     });

openhis-ui-vue3/src/views/inpatientDoctor/home/components/applicationShow/testApplication.vue

@@ -136,7 +136,7 @@
               currentDetail.patientName || '-'
             }}</el-descriptions-item>
             <el-descriptions-item label="申请单名称">{{
-              currentDetail.name || '-'
+              buildApplicationName(currentDetail)
             }}</el-descriptions-item>
             <el-descriptions-item label="创建时间">{{
               currentDetail.createTime || '-'

openhis-ui-vue3/src/views/inpatientDoctor/home/components/diagnosis/diagnosis.vue

@@ -289,43 +289,62 @@ function getList() {
         return obj;
       });
       form.value.diagnosisList = datas;
-      // form.value.diagnosisList = res.data;
+      // 去重：按 conditionId 去重，防止后端重复插入导致重复记录
+      deduplicateDiagnosisList();
       emits('diagnosisSave', false);
     }
   });
   getTcmDiagnosis({ encounterId: props.patientInfo.encounterId }).then((res) => {
-    console.log('getTcmDiagnosis=======>', JSON.stringify(res.data.illness));
+    console.log('getTcmDiagnosis=======>', JSON.stringify(res.data?.illness));
 
-    if (res.code == 200) {
+    if (res.code == 200 && res.data?.illness?.length > 0) {
-      if (res.data.illness.length > 0) {
+      diagnosisNetDatas.value = res.data.illness;
-        diagnosisNetDatas.value = res.data.illness;
+      res.data.illness.forEach((item, index) => {
-        res.data.illness.forEach((item, index) => {
+        newList.push({
-          newList.push({
+          name: item.name + '-' + (res.data.symptom?.[index]?.name || ''),
-            name: item.name + '-' + (res.data.symptom[index]?.name || ''),
+          ybNo: item.ybNo,
-            ybNo: item.ybNo,
+          medTypeCode: item.medTypeCode,
-            medTypeCode: item.medTypeCode,
+          diagnosisDoctor: props.patientInfo.practitionerName || props.patientInfo.doctorName || props.patientInfo.physicianName || userStore.name,
-            diagnosisDoctor: props.patientInfo.practitionerName || props.patientInfo.doctorName || props.patientInfo.physicianName || userStore.name,
+          diagnosisTime: new Date().toLocaleString('zh-CN')
-            diagnosisTime: new Date().toLocaleString('zh-CN')
-          });
         });
-        
+      });
-        // 将新数据添加到现有列表中
+
-        form.value.diagnosisList.push(...newList);
+      // 将新数据添加到现有列表中
-        
+      form.value.diagnosisList.push(...newList);
-        // 重新排序整个列表
+
-        form.value.diagnosisList.sort((a, b) => {
+      // 重新排序整个列表
-          const aNo = typeof a.diagSrtNo === 'number' ? a.diagSrtNo : 9999;
+      form.value.diagnosisList.sort((a, b) => {
-          const bNo = typeof b.diagSrtNo === 'number' ? b.diagSrtNo : 9999;
+        const aNo = typeof a.diagSrtNo === 'number' ? a.diagSrtNo : 9999;
-          return aNo - bNo;
+        const bNo = typeof b.diagSrtNo === 'number' ? b.diagSrtNo : 9999;
-        });
+        return aNo - bNo;
-      }
+      });
-      emits('diagnosisSave', false);
+      // TCM 数据添加后也去重
+      deduplicateDiagnosisList();
     }
+    emits('diagnosisSave', false);
   });
-  
+
   getTree();
 }
 
+/**
+ * 诊断列表去重：按 ybNo + name 组合去重，保留第一条记录
+ * 防止后端 saveOrUpdate 在删除后误 INSERT 导致重复
+ */
+function deduplicateDiagnosisList() {
+  const seen = new Set();
+  const dedupedList = [];
+  for (const item of form.value.diagnosisList) {
+    // 使用 ybNo 和 name 组合作为唯一标识（中医诊断没有 ybNo，用 name 去重）
+    const key = item.ybNo ? `${item.ybNo}` : `name_${item.name}`;
+    if (!seen.has(key)) {
+      seen.add(key);
+      dedupedList.push(item);
+    }
+  }
+  form.value.diagnosisList = dedupedList;
+}
+
 init();
 function init() {
   diagnosisInit().then((res) => {
@@ -603,6 +622,18 @@ function handleSaveDiagnosis() {
         return aNo - bNo;
       });
 
+      // 步骤1.5：确保每条诊断都有诊断医生和诊断时间（元数据补全）
+      const doctorName = props.patientInfo.practitionerName || props.patientInfo.doctorName || props.patientInfo.physicianName || userStore.name;
+      const now = new Date().toLocaleString('zh-CN');
+      sortedList.forEach((item) => {
+        if (!item.diagnosisDoctor) {
+          item.diagnosisDoctor = doctorName;
+        }
+        if (!item.diagnosisTime) {
+          item.diagnosisTime = now;
+        }
+      });
+
       // 步骤2：重新分配连续的序号（从1开始）
       sortedList.forEach((item, index) => {
         item.diagSrtNo = index + 1; // 这里是关键！把”诊断排序”改成新顺序

openhis-ui-vue3/src/views/inpatientDoctor/home/components/order/applicationForm/laboratoryTests.vue

@@ -325,7 +325,12 @@ const projectWithDepartment = (selectProjectIds, type) => {
       }
     }
     if (findItem && isRelease) {
-      form.targetDepartment = findItem.id;
+      // 提交时若用户已选「发往科室」，不得用项目默认执行科室覆盖
+      if (type === 2 && manualDept) {
+        form.targetDepartment = manualDept;
+      } else {
+        form.targetDepartment = findItem.id;
+      }
     }
   }
   return isRelease;
@@ -392,7 +397,7 @@ const submit = () => {
       unitCode: item.priceList[0].unitCode /** 请求单位编码 */,
       unitPrice: item.priceList[0].price /** 单价 */,
       totalPrice: item.priceList[0].price /** 总价 */,
-      positionId: item.positionId || form.targetDepartment, //执行科室id，未配置时使用用户手动选择的科室
+      positionId: form.targetDepartment || item.positionId, // 用户指定发往科室优先于项目默认执行科室
       ybClassEnum: item.ybClassEnum, //类别医保编码
       conditionId: item.conditionId, //诊断ID
       encounterDiagnosisId: item.encounterDiagnosisId, //就诊诊断id

openhis-ui-vue3/src/views/inpatientDoctor/home/components/order/index.vue

@@ -142,6 +142,11 @@
         <el-table-column label="医嘱" align="center" prop="productName" width="300">
           <template #default="scope">
             <template v-if="getRowDisabled(scope.row)">
+              <!-- 当行的 adviceType 不在当前选项列表中时，显示标签而非下拉框 -->
+              <template v-if="!hasAdviceTypeOption(scope.row)">
+                <el-tag size="small" type="primary">{{ getAdviceTypeLabel(scope.row.adviceType) }}</el-tag>
+              </template>
+              <template v-else>
               <el-select
                 style="width: 35%; margin-right: 8px"
                 :model-value="getRowSelectValue(scope.row)"
@@ -216,6 +221,7 @@
                   />
                 </template>
               </el-popover>
+              </template>
             </template>
             <span v-else>{{ scope.row.adviceName }}</span>
           </template>
@@ -750,6 +756,31 @@ function getRowDisabled(row) {
   return row.isEdit;
 }
 
+/**
+ * 判断行的 adviceType 是否在当前 adviceTypeList 选项中有匹配项
+ * 修复 Bug #488：避免 el-select 因无匹配选项而回显为纯数字
+ */
+function hasAdviceTypeOption(row) {
+  if (!row.adviceType && row.adviceType !== 0) return false;
+  if (row.adviceType == 1 && row.categoryCode) {
+    const compositeValue = '1-' + row.categoryCode;
+    return adviceTypeList.value.some(item => item.value === compositeValue);
+  }
+  return adviceTypeList.value.some(item => item.value === row.adviceType);
+}
+
+/**
+ * 将原始 adviceType 数字映射为人类可读标签
+ * 修复 Bug #488：当 adviceType 不在选项列表中时，显示标签而非数字
+ */
+function getAdviceTypeLabel(type) {
+  if (!type && type !== 0) return '';
+  // 优先使用字典文本（如果后端返回了 adviceType_dictText）
+  // 但由于当前行数据可能没有 dictText，提供兜底映射
+  const fallbackMap = { 1: '西药', 2: '中成药', 3: '诊疗', 4: '耗材', 5: '会诊', 6: '手术', 23: '检查' };
+  return fallbackMap[type] || String(type);
+}
+
 /**
  * 将行的 adviceType + categoryCode 映射为 el-select 的选中值
  * 药品子分类使用复合值如 '1-2'（adviceType-categoryCode），诊疗/手术/全部使用原始值
@@ -910,9 +941,8 @@ function handleFocus(row, index) {
   // 用 adviceType + categoryCode 组合查找匹配的选项
   const selectValue = (adviceType == 1 && row.categoryCode) ? '1-' + row.categoryCode : adviceType;
   const selectedItem = adviceTypeList.value.find(item => item.value === selectValue) || adviceTypeList.value.find(item => item.adviceType === adviceType);
-  // 修复Bug #486：当行没有显式选择医嘱类型时（row.adviceType为undefined），
+  // 当行没有显式选择医嘱类型时，使用已配置的默认categoryCode，确保后端能返回结果
-  // 不传categoryCode，让搜索在全药库中进行；只有行已选择类型时才用对应categoryCode过滤
+  const categoryCode = row.adviceType !== undefined ? (selectedItem ? selectedItem.categoryCode : '') : (adviceQueryParams.value.categoryCode || '');
-  const categoryCode = row.adviceType !== undefined ? (selectedItem ? selectedItem.categoryCode : '') : '';
   const searchKey = row.adviceName || '';
 
   nextTick(() => {
@@ -949,9 +979,8 @@ function handleChange(value) {
       // 用 adviceType + categoryCode 组合查找匹配的选项
       const selectValue = (adviceType == 1 && row?.categoryCode) ? '1-' + row.categoryCode : adviceType;
       const selectedItem = adviceTypeList.value.find(item => item.value === selectValue) || adviceTypeList.value.find(item => item.adviceType === adviceType);
-      // 修复Bug #486：当行没有显式选择医嘱类型时（row?.adviceType为undefined），
+      // 当行没有显式选择医嘱类型时，使用已配置的默认categoryCode，确保后端能返回结果
-      // 不传categoryCode，让搜索在全药库中进行；只有行已选择类型时才用对应categoryCode过滤
+      const categoryCode = row?.adviceType !== undefined ? (selectedItem ? selectedItem.categoryCode : '') : (adviceQueryParams.value.categoryCode || '');
-      const categoryCode = row?.adviceType !== undefined ? (selectedItem ? selectedItem.categoryCode : '') : '';
       // 修复Bug #453：当adviceType为空字符串或NaN时，不传具体类型，让refresh函数根据searchKey决定搜索范围
       const effectiveAdviceType = (adviceType && !isNaN(Number(adviceType))) ? adviceType : '';
       tableRef.refresh(effectiveAdviceType, categoryCode, value);
@@ -1378,6 +1407,9 @@ function handleSaveSign(row, index) {
             bindMethod.value[itemNo] = true;
           }
         }
+      }).catch(() => {
+        // 绑定设备接口失败不影响主流程保存，静默降级
+        console.warn('绑定设备检查接口调用失败（adviceType=' + row.adviceType + ', itemNo=' + itemNo + '）');
       });
     }
   }
@@ -1503,16 +1535,16 @@ function handleSaveBatch() {
 }
 
 function setValue(row) {
-  // 构造单位列表
+  // 构造单位列表，确保 value 始终为 String 类型，避免 el-select 值类型不匹配
   unitCodeList.value = [
-    { value: row.unitCode, label: row.unitCode_dictText, type: 'unit' },
+    { value: String(row.unitCode ?? ''), label: row.unitCode_dictText, type: 'unit' },
     {
-      value: row.doseUnitCode,
+      value: String(row.doseUnitCode ?? ''),
       label: row.doseUnitCode_dictText,
       type: 'dose',
     },
     {
-      value: row.minUnitCode,
+      value: String(row.minUnitCode ?? ''),
       label: row.minUnitCode_dictText,
       type: 'minUnit',
     },
@@ -1577,9 +1609,9 @@ function setValue(row) {
     orgName: row.adviceType != 3 ? undefined : (findOrgName(row.orgId || row.positionId || patientInfo.value?.inHospitalOrgId) || row.orgName || patientInfo.value?.inHospitalOrgName || ''),
     // dose: undefined, Removed to preserve dose value from group package
     unitCodeList: unitCodeList.value,
-    doseUnitCode: row.doseUnitCode,
+    doseUnitCode: String(row.doseUnitCode ?? ''),
-    minUnitCode: row.minUnitCode,
+    minUnitCode: String(row.minUnitCode ?? ''),
-    unitCode: row.partAttributeEnum == 1 ? row.minUnitCode : row.unitCode,
+    unitCode: row.partAttributeEnum == 1 ? String(row.minUnitCode ?? '') : String(row.unitCode ?? ''),
     categoryEnum: row.categoryCode,
     definitionId: row.chargeItemDefinitionId,
     executeNum: 1,
@@ -1595,6 +1627,10 @@ function setValue(row) {
             ? new Decimal(selectedStock.price).div(row.partPercent).toFixed(6)
             : prevRow.minUnitPrice,
           positionName: selectedStock?.locationName,
+          // 🔧 Bug #523 修复：初始化 totalPrice 为 0，避免总金额列显示为横杠
+          totalPrice: row.quantity
+            ? new Decimal(row.quantity).mul(selectedStock?.price ?? 0).toFixed(6)
+            : '0',
         }
       : {
           quantity: 1,

openhis-ui-vue3/src/views/inpatientNurse/medicalOrderExecution/components/prescriptionList.vue

@@ -241,6 +241,8 @@ const loading = ref(false);
 const chooseAll = ref(false);
 // 独立维护选中行ID集合，避免el-table内部selection状态异常导致联动全选
 const selectedRowIds = ref(new Set());
+// 跳过选中事件级联：程序化调用 toggleRowSelection 时阻止 handleRowSelect 触发 selectAllCheckboxesInRow
+const skipSelectCascade = ref(false);
 const props = defineProps({
   exeStatus: {
     type: Number,
@@ -484,8 +486,13 @@ function handleExecute() {
       if (hasServiceRequest) {
         // 仅传入选中医嘱对应的 encounterId，避免其他患者的耗材记录干扰
         const selectedEncounterIds = [...new Set(list.map((item) => item.encounterId).filter(Boolean))];
+        // 仅传入诊疗类医嘱的 requestId，让后端仅校验与本次执行相关的耗材，避免其他未执行医嘱的耗材记录干扰
+        const selectedRequestIds = list
+          .filter((item) => String(item.adviceTable || '') === 'wor_service_request')
+          .map((item) => item.requestId)
+          .filter(Boolean);
         if (selectedEncounterIds.length > 0) {
-          lotNumberMatch({ encounterIdList: selectedEncounterIds }, { skipErrorMsg: true })
+          lotNumberMatch({ encounterIdList: selectedEncounterIds, requestIdList: selectedRequestIds }, { skipErrorMsg: true })
             .then((matchRes) => {
               if (matchRes && matchRes.code !== 200) {
                 console.warn('lotNumberMatch returned error:', matchRes.msg);
@@ -650,6 +657,7 @@ function handleRateChange(value, date, time, row, rateItem) {
 }
 
 function handelSwicthChange(value) {
+  skipSelectCascade.value = true;
   prescriptionList.value.forEach((item, index) => {
     const tableRef = proxy.$refs['tableRef' + index];
     if (tableRef && tableRef[0]) {
@@ -670,12 +678,15 @@ function handelSwicthChange(value) {
       }
     }
   });
+  skipSelectCascade.value = false;
 }
 
 // 默认选中全部行
 function defaultSelectAllRows() {
   // 清空并重建选中集合
   selectedRowIds.value.clear();
+  // 阻止 toggleRowSelection 触发 handleRowSelect 中的 selectAllCheckboxesInRow 级联
+  skipSelectCascade.value = true;
   prescriptionList.value.forEach((item, index) => {
     const tableRef = proxy.$refs['tableRef' + index];
     if (tableRef && tableRef[0]) {
@@ -688,6 +699,7 @@ function defaultSelectAllRows() {
       });
     }
   });
+  skipSelectCascade.value = false;
   // 更新全选开关状态
   chooseAll.value = true;
 }
@@ -764,6 +776,7 @@ function checkAndToggleRowSelection(row) {
         const isCurrentlySelected = selectedRowIds.value.has(row.requestId);
 
         // 根据checkbox状态更新表格行选中状态
+        skipSelectCascade.value = true;
         if (isAllSelected && !isCurrentlySelected) {
           selectedRowIds.value.add(row.requestId);
           tableRef[0].toggleRowSelection(row, true);
@@ -771,6 +784,7 @@ function checkAndToggleRowSelection(row) {
           selectedRowIds.value.delete(row.requestId);
           tableRef[0].toggleRowSelection(row, false);
         }
+        skipSelectCascade.value = false;
       }
     }
   });
@@ -782,8 +796,10 @@ function handleRowSelect(selection, row, tableIndex) {
 
   if (isSelected) {
     selectedRowIds.value.add(row.requestId);
-    // 选中行时，选中该行内部的所有checkbox
+    // 仅在非程序化选中时，联动选中该行内部的所有checkbox
-    selectAllCheckboxesInRow(row);
+    if (!skipSelectCascade.value) {
+      selectAllCheckboxesInRow(row);
+    }
   } else {
     selectedRowIds.value.delete(row.requestId);
     // 取消选中行时，取消选中该行内部的所有checkbox

openhis-ui-vue3/src/views/inpatientNurse/tprChart/components/addTprDialog.vue

@@ -1057,8 +1057,8 @@ function confirmCharge() {
   params.recordingDate = formData.value.recordingDate || moment(new Date()).format('YYYY-MM-DD');
 
   addVitalSigns(params).then(res => {
-    console.log('保存成功:', res);
     if (res.code === 200) {
+      proxy.msgSuccess('保存成功');
       // 保存成功后刷新列表
       getPatientList();
       // 清空表单
@@ -1087,8 +1087,6 @@ function confirmCharge() {
         urineVolume: '',
         stoolVolume: '',
       };
-      // 保存成功后关闭弹窗
-      closeDialog();
     }
   });
 }

openhis-ui-vue3/src/views/medicationmanagement/requisitionManagement/requisitionManagement/index.vue

@@ -1131,15 +1131,15 @@ function handleLocationClick(item, row, index) {
     .then((res) => {
       const list = res.data || [];
       const d = pickBestOrgQuantityRow(list);
-      const strictOk = d && Number(d.orgQuantity ?? 0) > 0;
+
-      if (strictOk) {
+      // 严格批号查询有库存（orgQuantity > 0）
+      if (d && Number(d.orgQuantity ?? 0) > 0) {
         applyFromDto(d, false);
-        if (Number(r.totalQuantity) <= 0) {
-          proxy.$message.warning('仓库数量为0，无法调用！');
-        }
         persistStore();
         return;
       }
+
+      // 严格查询无库存或数量为0 → 回退到非严格查询（查同仓库其他批号）
       if (lotTrimmed) {
         return runGet(false).then((res2) => {
           const list2 = res2.data || [];
@@ -1157,6 +1157,8 @@ function handleLocationClick(item, row, index) {
           persistStore();
         });
       }
+
+      // 没有指定批号，直接提示
       r.totalQuantity = 0;
       r.price = 0;
       proxy.$message.warning('仓库数量为0，无法调用！');

openhis-ui-vue3/src/views/surgicalschedule/index.vue

@@ -1535,8 +1535,8 @@ function handleMedicalAdvice(row) {
   temporarySigned.value = hasSubmittedAdvices; // 修复：根据已有数据状态设置，而非盲目重置
   temporaryMedicalLoading.value = true // 🔧 新增：开始加载
 
-  // 调用计费接口获取数据
+  // 调用计费接口获取数据（使用手术计费来源参数，匹配 surgery billing 创建的记录）
-  getPrescriptionList(row.visitId).then((res) => {
+  getPrescriptionList(row.visitId, 6, row.operCode).then((res) => {
     console.log('=== 拉取计费数据返回结果 ===', res)
     if (res.code === 200 && res.data) {
       // 🔧 修复：显示所有药品请求数据，不管有没有计费项目
@@ -1741,27 +1741,39 @@ function handleTemporaryMedicalSubmit(data) {
       }
     })
     
-    // 🔧 修复 Bug #445: 使用稳定的字段组合匹配已提交项目，而不是依赖可能为空的 requestId/chargeItemId
+    // 🔧 修复 Bug #445: 使用稳定可靠的字段组合匹配已提交项目，从已生成列表中剔除待生成项
-    // 构建已提交项目的匹配键集合（药品名称 + 规格 + 数量）
+    // 匹配键：优先使用 chargeItemId（后端费用项目ID，最可靠），其次使用 名称+规格+数量 组合
-    const submittedKeys = new Set(
+    const submittedKeys = new Set()
-      (data.temporaryAdvices || [])
+    const submittedChargeIds = new Set()
-        .map(a => {
-          const om = a.originalMedicine || {}
-          const name = om.medicineName || om.adviceName || om.advice_name || a.adviceName || ''
-          const spec = om.specification || om.volume || ''
-          const qty = om.quantity || 0
-          return `${name}|||${spec}|||${qty}`
-        })
-        .filter(k => k !== '|||0') // 过滤掉空项
-    )
 
-    if (submittedKeys.size > 0) {
+    ;(data.temporaryAdvices || []).forEach(a => {
+      const om = a.originalMedicine || {}
+      // 收集 chargeItemId（最可靠的匹配标识）
+      if (om.chargeItemId) {
+        submittedChargeIds.add(om.chargeItemId)
+      }
+      // 构建名称+规格+数量的匹配键（用于无 chargeItemId 的兜底匹配）
+      // 注意：originalMedicine 中的名称字段是 adviceName（来自 billingMedicines.map 时的字段）
+      const name = om.medicineName || om.adviceName || om.advice_name || a.adviceName || ''
+      const spec = om.specification || om.volume || ''
+      const qty = om.quantity || 0
+      if (name) {
+        submittedKeys.add(`${name}|||${spec}|||${qty}`)
+      }
+    })
+
+    if (submittedChargeIds.size > 0 || submittedKeys.size > 0) {
       temporaryBillingMedicines.value = (temporaryBillingMedicines.value || []).filter(m => {
-        const key = `${m.medicineName || ''}|||${m.specification || ''}|||${m.quantity || 0}`
+        // 优先用 chargeItemId 匹配
+        if (m.chargeItemId && submittedChargeIds.has(m.chargeItemId)) {
+          return false
+        }
+        // 兜底用 名称+规格+数量 匹配
+        const key = `${m.medicineName || m.adviceName || ''}|||${m.specification || m.volume || ''}|||${m.quantity || 0}`
         return !submittedKeys.has(key)
       })
     } else {
-      // 如果没有任何匹配键，清空待生成列表（所有项目都已提交）
+      // 如果没有任何匹配标识，清空待生成列表（保守策略：认为所有项目都已提交）
       temporaryBillingMedicines.value = []
     }