代码提交

liusheng

2025-02-21 51b44b3c9278ce5aa970db2b04f23856bd364305

代码提交

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedOperationController.java

@@ -1,41 +1,32 @@
package com.ruoyi.web.controller.smartor;

import java.util.List;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;

import javax.servlet.http.HttpServletResponse;

import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.smartor.domain.PatMedOperation;
import com.smartor.service.IPatMedOperationService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
 * æ‚£è€…手术记录Controller
 *
 * @author lihu
 * @date 2024-08-05
 * @date 2025-02-21
 */
@Api("患者手术记录")
@RestController
@RequestMapping("/smartor/operation")
public class PatMedOperationController extends BaseController {
public class PatMedOperationController extends BaseController
{
    @Autowired
    private IPatMedOperationService patMedOperationService;

@@ -45,7 +36,8 @@
    @ApiOperation("查询患者手术记录列表")
    //@PreAuthorize("@ss.hasPermi('smartor:operation:list')")
    @GetMapping("/list")
    public TableDataInfo list(PatMedOperation patMedOperation) {
    public TableDataInfo list(PatMedOperation patMedOperation)
    {
        startPage();
        List<PatMedOperation> list = patMedOperationService.selectPatMedOperationList(patMedOperation);
        return getDataTable(list);
@@ -58,7 +50,8 @@
    //@PreAuthorize("@ss.hasPermi('smartor:operation:export')")
    @Log(title = "患者手术记录" , businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, PatMedOperation patMedOperation) {
    public void export(HttpServletResponse response, PatMedOperation patMedOperation)
    {
        List<PatMedOperation> list = patMedOperationService.selectPatMedOperationList(patMedOperation);
        ExcelUtil<PatMedOperation> util = new ExcelUtil<PatMedOperation>(PatMedOperation.class);
        util.exportExcel(response, list, "患者手术记录数据");
@@ -70,17 +63,20 @@
    @ApiOperation("获取患者手术记录详细信息")
    //@PreAuthorize("@ss.hasPermi('smartor:operation:query')")
    @GetMapping(value = "/getInfo/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(patMedOperationService.selectPatMedOperationById(id));
    }

    /**
     * æ–°å¢žæ‚£è€…手术记录
     */
    @ApiOperation("新增患者手术记录")
    //@PreAuthorize("@ss.hasPermi('smartor:operation:add')")
    @Log(title = "患者手术记录" , businessType = BusinessType.INSERT)
    @PostMapping("/add")
    public AjaxResult add(@RequestBody PatMedOperation patMedOperation) {
    public AjaxResult add(@RequestBody PatMedOperation patMedOperation)
    {
        return toAjax(patMedOperationService.insertPatMedOperation(patMedOperation));
    }

@@ -91,7 +87,8 @@
    //@PreAuthorize("@ss.hasPermi('smartor:operation:edit')")
    @Log(title = "患者手术记录" , businessType = BusinessType.UPDATE)
    @PostMapping("/edit")
    public AjaxResult edit(@RequestBody PatMedOperation patMedOperation) {
    public AjaxResult edit(@RequestBody PatMedOperation patMedOperation)
    {
        return toAjax(patMedOperationService.updatePatMedOperation(patMedOperation));
    }

@@ -102,7 +99,8 @@
    //@PreAuthorize("@ss.hasPermi('smartor:operation:remove')")
    @Log(title = "患者手术记录" , businessType = BusinessType.DELETE)
    @GetMapping("/remove/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids) {
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(patMedOperationService.deletePatMedOperationByIds(ids));
    }
}

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/PatMedOperationItemController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,113 @@
package com.ruoyi.web.controller.smartor;

import java.util.List;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import javax.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.smartor.domain.PatMedOperationItem;
import com.smartor.service.IPatMedOperationItemService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * æ‚£è€…检查检验记录子Controller
 *
 * @author lihu
 * @date 2025-02-21
 */
@Api("患者检查检验记录子")
@RestController
@RequestMapping("/smartor/item")
public class PatMedOperationItemController extends BaseController
{
    @Autowired
    private IPatMedOperationItemService patMedOperationItemService;

    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录子列表
     */
    @ApiOperation("查询患者检查检验记录子列表")
    //@PreAuthorize("@ss.hasPermi('smartor:item:list')")
    @GetMapping("/list")
    public TableDataInfo list(PatMedOperationItem patMedOperationItem)
    {
        startPage();
        List<PatMedOperationItem> list = patMedOperationItemService.selectPatMedOperationItemList(patMedOperationItem);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ‚£è€…检查检验记录子列表
     */
    @ApiOperation("导出患者检查检验记录子列表")
    //@PreAuthorize("@ss.hasPermi('smartor:item:export')")
    @Log(title = "患者检查检验记录子", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, PatMedOperationItem patMedOperationItem)
    {
        List<PatMedOperationItem> list = patMedOperationItemService.selectPatMedOperationItemList(patMedOperationItem);
        ExcelUtil<PatMedOperationItem> util = new ExcelUtil<PatMedOperationItem>(PatMedOperationItem.class);
        util.exportExcel(response, list, "患者检查检验记录子数据");
    }

    /**
     * èŽ·å–患者检查检验记录子详细信息
     */
    @ApiOperation("获取患者检查检验记录子详细信息")
    //@PreAuthorize("@ss.hasPermi('smartor:item:query')")
    @GetMapping(value = "/getInfo/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(patMedOperationItemService.selectPatMedOperationItemById(id));
    }

    /**
     * æ–°å¢žæ‚£è€…检查检验记录子
     */
    @ApiOperation("新增患者检查检验记录子")
    //@PreAuthorize("@ss.hasPermi('smartor:item:add')")
    @Log(title = "患者检查检验记录子", businessType = BusinessType.INSERT)
    @PostMapping("/add")
    public AjaxResult add(@RequestBody PatMedOperationItem patMedOperationItem)
    {
        return toAjax(patMedOperationItemService.insertPatMedOperationItem(patMedOperationItem));
    }

    /**
     * ä¿®æ”¹æ‚£è€…检查检验记录子
     */
    @ApiOperation("修改患者检查检验记录子")
    //@PreAuthorize("@ss.hasPermi('smartor:item:edit')")
    @Log(title = "患者检查检验记录子", businessType = BusinessType.UPDATE)
    @PostMapping("/edit")
    public AjaxResult edit(@RequestBody PatMedOperationItem patMedOperationItem)
    {
        return toAjax(patMedOperationItemService.updatePatMedOperationItem(patMedOperationItem));
    }

    /**
     * åˆ é™¤æ‚£è€…检查检验记录子
     */
    @ApiOperation("删除患者检查检验记录子")
    //@PreAuthorize("@ss.hasPermi('smartor:item:remove')")
    @Log(title = "患者检查检验记录子", businessType = BusinessType.DELETE)
    @GetMapping("/remove/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(patMedOperationItemService.deletePatMedOperationItemByIds(ids));
    }
}

 ruoyi-framework/src/main/java/com/ruoyi/framework/interceptor/HospitalFilterInterceptor.java

@@ -72,7 +72,13 @@
     * @return ä¿®æ”¹åŽçš„ SQL
     */
    private String modifySqlWithorgidId(String originalSql, String orgid) {
        if (originalSql.contains("insert into") || originalSql.contains("INSERT INTO") || originalSql.contains("from sys_menu") || originalSql.contains("update sys_menu")) {
        if (originalSql.contains("insert into")
                || originalSql.contains("INSERT INTO")
                || originalSql.contains("from sys_menu")
                || originalSql.contains("update sys_menu")
                || originalSql.contains("information_schema.tables")
                || originalSql.contains("information_schema.columns")
                || originalSql.contains("gen_table")) {
            return originalSql;
        }
        // æå– orgid çš„ WHERE å­å¥

 smartor/src/main/java/com/smartor/domain/PatMedOperation.java

@@ -13,7 +13,7 @@
 * æ‚£è€…手术记录对象 pat_med_operation
 *
 * @author lihu
 * @date 2024-08-05
 * @date 2025-02-21
 */
@Data
@ApiModel("患者手术记录")
@@ -24,28 +24,51 @@
     * è‡ªå¢žID
     */
    @ApiModelProperty("自增ID")
    //数据库自增改成@TableId(type = IdType.AUTO)
    private Long id;

    /**
     * å°±è¯Šæµæ°´å·
     * ç—…人ID
     */
    @ApiModelProperty("就诊流水号")
    @Excel(name = "就诊流水号")
    private String serialnum;

    /**
     * æ¡£æ¡ˆID
     */
    @ApiModelProperty("档案ID")
    @Excel(name = "档案ID")
    @ApiModelProperty("病人ID")
    @Excel(name = "病人ID")
    private Long patid;

    /**
     * æ‰‹æœ¯åç§°
     * ç—…人编号
     */
    @ApiModelProperty("手术名称")
    @Excel(name = "手术名称")
    private String operationname;
    @ApiModelProperty("病人编号")
    @Excel(name = "病人编号")
    private String patcode;

    /**
     * ç—…人姓名
     */
    @ApiModelProperty("病人姓名")
    @Excel(name = "病人姓名")
    private String paname;

    /**
     * æ‰‹æœ¯ç”³è¯·å•ID
     */
    @ApiModelProperty("手术申请单ID")
    @Excel(name = "手术申请单ID")
    private Long opreqid;

    /**
     * æ‰‹æœ¯ç”³è¯·å•å·
     */
    @ApiModelProperty("手术申请单号")
    @Excel(name = "手术申请单号")
    private String opreqcode;

    /**
     * æ‰‹æœ¯çŠ¶æ€ï¼šN－申请R－安排D－拒绝
     * C－取消 F－结束
     */
    @ApiModelProperty("手术状态：N－申请R－安排D－拒绝 C－取消 F－结束")
    @Excel(name = "手术状态：N－申请R－安排D－拒绝 C－取消 F－结束")
    private String opsstatus;

    /**
     * æ‰‹æœ¯ä»£ç 
@@ -55,26 +78,153 @@
    private String operationcode;

    /**
     * æ‰‹æœ¯ID
     * æ‰‹æœ¯åç§°
     */
    @ApiModelProperty("手术ID")
    @Excel(name = "手术ID")
    private Long operationid;
    @ApiModelProperty("手术名称")
    @Excel(name = "手术名称")
    private String operationname;

    /**
     * æ‰‹æœ¯æ—¶é—´
     * è¦æ±‚手术时间
     */
    @ApiModelProperty("手术时间")
    @ApiModelProperty("要求手术时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "手术时间" , width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date operationtime;
    @Excel(name = "要求手术时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date operatortime;

    /**
     * å°±è¯ŠID
     * æ‰‹æœ¯ç”³è¯·æ—¶é—´
     */
    @ApiModelProperty("就诊ID")
    @Excel(name = "就诊ID")
    private Long visitid;
    @ApiModelProperty("手术申请时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "手术申请时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date opreqtime;

    /**
     * ç”³è¯·åŒ»ç”Ÿç¼–号
     */
    @ApiModelProperty("申请医生编号")
    @Excel(name = "申请医生编号")
    private String reqdoccode;

    /**
     * ç”³è¯·åŒ»ç”Ÿå§“名
     */
    @ApiModelProperty("申请医生姓名")
    @Excel(name = "申请医生姓名")
    private String reqdocname;

    /**
     * ç”³è¯·ç§‘室编号
     */
    @ApiModelProperty("申请科室编号")
    @Excel(name = "申请科室编号")
    private String reqdeptcode;

    /**
     * ç”³è¯·ç§‘室名称
     */
    @ApiModelProperty("申请科室名称")
    @Excel(name = "申请科室名称")
    private String reqdeptname;

    /**
     * æ‰‹æœ¯ç§‘室编号
     */
    @ApiModelProperty("手术科室编号")
    @Excel(name = "手术科室编号")
    private String reqloccode;

    /**
     * æ‰‹æœ¯ç§‘室名称
     */
    @ApiModelProperty("手术科室名称")
    @Excel(name = "手术科室名称")
    private String reqlocname;

    /**
     * ä¸»åˆ€åŒ»ç”Ÿç¼–号
     */
    @ApiModelProperty("主刀医生编号")
    @Excel(name = "主刀医生编号")
    private String surgeoncode;

    /**
     * ä¸»åˆ€åŒ»ç”Ÿå§“名
     */
    @ApiModelProperty("主刀医生姓名")
    @Excel(name = "主刀医生姓名")
    private String surgeonname;

    /**
     * ä¸€åŠ©åŒ»ç”Ÿç¼–号
     */
    @ApiModelProperty("一助医生编号")
    @Excel(name = "一助医生编号")
    private String firasscode;

    /**
     * ä¸€åŠ©åŒ»ç”Ÿå§“名
     */
    @ApiModelProperty("一助医生姓名")
    @Excel(name = "一助医生姓名")
    private String firassname;

    /**
     * äºŒåŠ©åŒ»ç”Ÿç¼–号
     */
    @ApiModelProperty("二助医生编号")
    @Excel(name = "二助医生编号")
    private String secasscode;

    /**
     * äºŒåŠ©åŒ»ç”Ÿå§“名
     */
    @ApiModelProperty("二助医生姓名")
    @Excel(name = "二助医生姓名")
    private String secassname;

    /**
     * ä¸‰åŠ©åŒ»ç”Ÿç¼–号
     */
    @ApiModelProperty("三助医生编号")
    @Excel(name = "三助医生编号")
    private String thrasscode;

    /**
     * ä¸‰åŠ©åŒ»ç”Ÿå§“名
     */
    @ApiModelProperty("三助医生姓名")
    @Excel(name = "三助医生姓名")
    private String thrassname;

    /**
     * ä½œåºŸæ—¶é—´
     */
    @ApiModelProperty("作废时间")
    @Excel(name = "作废时间")
    private String canceltime;

    /**
     * ä½œåºŸåŽŸå› 
     */
    @ApiModelProperty("作废原因")
    @Excel(name = "作废原因")
    private String cancelreason;

    /**
     * ä½œåºŸç”³è¯·äººç¼–号
     */
    @ApiModelProperty("作废申请人编号")
    @Excel(name = "作废申请人编号")
    private String cancelcode;

    /**
     * ä½œåºŸç”³è¯·äººå§“名
     */
    @ApiModelProperty("作废申请人姓名")
    @Excel(name = "作废申请人姓名")
    private String cancelname;

    /**
     * å°±è¯Šç±»åž‹;1门诊 2住院 3体检
@@ -84,11 +234,12 @@
    private Long visittype;

    /**
     * æ‰‹æœ¯çŠ¶æ€;0未开始 1已完成
     * æ‰‹æœ¯çŠ¶æ€ï¼šN－申请R－安排D－拒绝
     * C－取消 F－结束
     */
    @ApiModelProperty("手术状态;0未开始 1已完成")
    @Excel(name = "手术状态;0未开始 1已完成")
    private Long status;
    @ApiModelProperty("手术状态：N－申请R－安排D－拒绝 C－取消 F－结束")
    @Excel(name = "手术状态：N－申请R－安排D－拒绝 C－取消 F－结束")
    private String status;

    /**
     * æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´
@@ -104,13 +255,6 @@
    @ApiModelProperty("是否生成计划;0未生成 1生成手术前 2生成手术后  9无匹配方案")
    @Excel(name = "是否生成计划;0未生成 1生成手术前 2生成手术后  9无匹配方案")
    private Long schemestatus;

    /**
     * æœºæž„ID
     */
    @ApiModelProperty("机构ID")
    @Excel(name = "机构ID")
    private String orgid;

    /**
     * åˆ é™¤æ ‡å¿—（0：未删除 1：已删除）
@@ -134,11 +278,11 @@
    private Date uploadTime;

    /**
     * çˆ¶ID
     * åŒ»é™¢æœºæž„ID
     */
    @ApiModelProperty("父ID")
    @Excel(name = "父ID")
    private Long pid;
    @ApiModelProperty("医院机构ID")
    @Excel(name = "医院机构ID")
    private String orgid;

    /**
     * GUID
@@ -147,5 +291,152 @@
    @Excel(name = "GUID")
    private String guid;

    /**
     * çˆ¶GUID
     */
    @ApiModelProperty("父GUID")
    @Excel(name = "父GUID")
    private String pguid;

    /**
     * çˆ¶ID
     */
    @ApiModelProperty("父ID")
    @Excel(name = "父ID")
    private Long pid;

    /**
     * å°±è¯Šç±»åž‹æ ‡è¯†ï¼š0：在院 1：出院 2：转科
     */
    @ApiModelProperty("就诊类型标识：0：在院 1：出院 2：转科")
    @Excel(name = "就诊类型标识：0：在院 1：出院 2：转科")
    private String inhospstate;

    /**
     * æ‚£è€…档案编号
     */
    @ApiModelProperty("患者档案编号")
    @Excel(name = "患者档案编号")
    private String patno;

    /**
     * ç—…人姓名
     */
    @ApiModelProperty("病人姓名")
    @Excel(name = "病人姓名")
    private String patname;

    /**
     * é—¨è¯Šå°±è¯ŠID
     */
    @ApiModelProperty("门诊就诊ID")
    @Excel(name = "门诊就诊ID")
    private Long visitid;

    /**
     * å°±è¯Šæµæ°´å·
     */
    @ApiModelProperty("就诊流水号")
    @Excel(name = "就诊流水号")
    private String serialnum;

    /**
     * ä½é™¢å·
     */
    @ApiModelProperty("住院号")
    @Excel(name = "住院号")
    private String inhospno;

    /**
     * åŒ»é™¢åç§°
     */
    @ApiModelProperty("医院名称")
    @Excel(name = "医院名称")
    private String hospitalname;

    /**
     * åŒ»é™¢ç¼–号
     */
    @ApiModelProperty("医院编号")
    @Excel(name = "医院编号")
    private String hospitalcode;

    /**
     * å°±è¯Šç§‘室ID
     */
    @ApiModelProperty("就诊科室ID")
    @Excel(name = "就诊科室ID")
    private String deptid;

    /**
     * ç§‘室代码
     */
    @ApiModelProperty("科室代码")
    @Excel(name = "科室代码")
    private String deptcode;

    /**
     * ç§‘室名称
     */
    @ApiModelProperty("科室名称")
    @Excel(name = "科室名称")
    private String deptname;

    /**
     * ç—…区编号
     */
    @ApiModelProperty("病区编号")
    @Excel(name = "病区编号")
    private String hospitaldistrictcode;

    /**
     * ç—…区名称
     */
    @ApiModelProperty("病区名称")
    @Excel(name = "病区名称")
    private String hospitaldistrictname;

    /**
     * æˆ¿é—´å·
     */
    @ApiModelProperty("房间号")
    @Excel(name = "房间号")
    private String roomno;

    /**
     * åºŠä½å·
     */
    @ApiModelProperty("床位号")
    @Excel(name = "床位号")
    private String bedNo;

    /**
     * ä¸»æ²»åŒ»ç”Ÿå·¥å·
     */
    @ApiModelProperty("主治医生工号")
    @Excel(name = "主治医生工号")
    private String drcode;

    /**
     * ä¸»æ²»åŒ»ç”Ÿåç§°
     */
    @ApiModelProperty("主治医生名称")
    @Excel(name = "主治医生名称")
    private String drname;

    /**
     * æŠ¤å£«ID
     */
    @ApiModelProperty("护士ID")
    @Excel(name = "护士ID")
    private String nurseId;

    /**
     * æŠ¤å£«å§“名
     */
    @ApiModelProperty("护士姓名")
    @Excel(name = "护士姓名")
    private String nurseName;

}


 smartor/src/main/java/com/smartor/domain/PatMedOperationItem.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,110 @@
package com.smartor.domain;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.Date;

/**
 * æ‚£è€…检查检验记录子对象 pat_med_operation_item
 *
 * @author lihu
 * @date 2025-02-21
 */
@Data
@ApiModel("患者检查检验记录子")
public class PatMedOperationItem extends BaseEntity
        {
private static final long serialVersionUID = 1L;

    /** è‡ªå¢žID */
    @ApiModelProperty("自增ID")
        //数据库自增改成@TableId(type = IdType.AUTO)
    private Long id;

    /** æ‰‹æœ¯ä¸»è¡¨id */
    @ApiModelProperty("手术主表id")
            @Excel(name = "手术主表id")
    private Long opid;

    /** æ‰‹æœ¯åç§°ID */
    @ApiModelProperty("手术名称ID")
            @Excel(name = "手术名称ID")
    private String opcode;

    /** æ‰‹æœ¯åç§° */
    @ApiModelProperty("手术名称")
            @Excel(name = "手术名称")
    private String opdesc;

    /** ä¸»æ‰‹æœ¯æ ‡è¯† */
    @ApiModelProperty("主手术标识")
            @Excel(name = "主手术标识")
    private String mainFlag;

    /** åˆ‡å£ç±»åˆ«ä»£ç  */
    @ApiModelProperty("切口类别代码")
            @Excel(name = "切口类别代码")
    private String incitypecode;

    /** åˆ‡å£ç±»åˆ«åç§° */
    @ApiModelProperty("切口类别名称")
            @Excel(name = "切口类别名称")
    private String incitypedesc;

    /** æ‰‹æœ¯çº§åˆ«ä»£ç  */
    @ApiModelProperty("手术级别代码")
            @Excel(name = "手术级别代码")
    private String oplevelcode;

    /** æ‰‹æœ¯çº§åˆ«åç§° */
    @ApiModelProperty("手术级别名称")
            @Excel(name = "手术级别名称")
    private String opleveldesc;

    /** æ‰‹æœ¯éƒ¨ä½ */
    @ApiModelProperty("手术部位")
            @Excel(name = "手术部位")
    private String opposition;

    /** åˆ é™¤æ ‡å¿—（0：未删除 1：已删除） */
    @ApiModelProperty("删除标志（0：未删除 1：已删除）")
    private String delFlag;

    /** ä¸Šä¼ æ ‡å¿—（0：未上传 1：已上传） */
    @ApiModelProperty("上传标志（0：未上传 1：已上传）")
            @Excel(name = "上传标志", readConverterExp = "0=：未上传,1=：已上传")
    private Long isupload;

    /** ä¸Šä¼ æ—¶é—´ */
    @ApiModelProperty("上传时间")
            @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
            @Excel(name = "上传时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date uploadTime;

    /** åŒ»é™¢æœºæž„ID */
    @ApiModelProperty("医院机构ID")
            @Excel(name = "医院机构ID")
    private String orgid;

    /** çˆ¶GUID */
    @ApiModelProperty("父GUID")
            @Excel(name = "父GUID")
    private String pguid;

    /** GUID */
    @ApiModelProperty("GUID")
            @Excel(name = "GUID")
    private String guid;

    /** çˆ¶ID */
    @ApiModelProperty("父ID")
            @Excel(name = "父ID")
    private Long pid;

        }


 smartor/src/main/java/com/smartor/mapper/PatMedOperationItemMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.smartor.mapper;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import com.smartor.domain.PatMedOperationItem;

/**
 * æ‚£è€…检查检验记录子Mapper接口
 *
 * @author lihu
 * @date 2025-02-21
 */
@Mapper
public interface PatMedOperationItemMapper
{
    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录子
     *
     * @param id æ‚£è€…检查检验记录子主键
     * @return æ‚£è€…检查检验记录子
     */
    public PatMedOperationItem selectPatMedOperationItemById(Long id);

    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录子列表
     *
     * @param patMedOperationItem æ‚£è€…检查检验记录子
     * @return æ‚£è€…检查检验记录子集合
     */
    public List<PatMedOperationItem> selectPatMedOperationItemList(PatMedOperationItem patMedOperationItem);

    /**
     * æ–°å¢žæ‚£è€…检查检验记录子
     *
     * @param patMedOperationItem æ‚£è€…检查检验记录子
     * @return ç»“æžœ
     */
    public int insertPatMedOperationItem(PatMedOperationItem patMedOperationItem);

    /**
     * ä¿®æ”¹æ‚£è€…检查检验记录子
     *
     * @param patMedOperationItem æ‚£è€…检查检验记录子
     * @return ç»“æžœ
     */
    public int updatePatMedOperationItem(PatMedOperationItem patMedOperationItem);

    /**
     * åˆ é™¤æ‚£è€…检查检验记录子
     *
     * @param id æ‚£è€…检查检验记录子主键
     * @return ç»“æžœ
     */
    public int deletePatMedOperationItemById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…检查检验记录子
     *
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deletePatMedOperationItemByIds(Long[] ids);
}

 smartor/src/main/java/com/smartor/mapper/PatMedOperationMapper.java

@@ -1,14 +1,15 @@
package com.smartor.mapper;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;

import com.smartor.domain.PatMedOperation;
import org.apache.ibatis.annotations.Mapper;

/**
 * æ‚£è€…手术记录Mapper接口
 *
 * @author lihu
 * @date 2024-08-05
 * @date 2025-02-21
 */
@Mapper
public interface PatMedOperationMapper

 smartor/src/main/java/com/smartor/service/IPatMedOperationItemService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.smartor.service;

import java.util.List;
import com.smartor.domain.PatMedOperationItem;

/**
 * æ‚£è€…检查检验记录子Service接口
 * 
 * @author lihu
 * @date 2025-02-21
 */
public interface IPatMedOperationItemService 
{
    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录子
     * 
     * @param id æ‚£è€…检查检验记录子主键
     * @return æ‚£è€…检查检验记录子
     */
    public PatMedOperationItem selectPatMedOperationItemById(Long id);

    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录子列表
     * 
     * @param patMedOperationItem æ‚£è€…检查检验记录子
     * @return æ‚£è€…检查检验记录子集合
     */
    public List<PatMedOperationItem> selectPatMedOperationItemList(PatMedOperationItem patMedOperationItem);

    /**
     * æ–°å¢žæ‚£è€…检查检验记录子
     * 
     * @param patMedOperationItem æ‚£è€…检查检验记录子
     * @return ç»“æžœ
     */
    public int insertPatMedOperationItem(PatMedOperationItem patMedOperationItem);

    /**
     * ä¿®æ”¹æ‚£è€…检查检验记录子
     * 
     * @param patMedOperationItem æ‚£è€…检查检验记录子
     * @return ç»“æžœ
     */
    public int updatePatMedOperationItem(PatMedOperationItem patMedOperationItem);

    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…检查检验记录子
     * 
     * @param ids éœ€è¦åˆ é™¤çš„患者检查检验记录子主键集合
     * @return ç»“æžœ
     */
    public int deletePatMedOperationItemByIds(Long[] ids);

    /**
     * åˆ é™¤æ‚£è€…检查检验记录子信息
     * 
     * @param id æ‚£è€…检查检验记录子主键
     * @return ç»“æžœ
     */
    public int deletePatMedOperationItemById(Long id);
}

 smartor/src/main/java/com/smartor/service/IPatMedOperationService.java

@@ -1,13 +1,14 @@
package com.smartor.service;

import java.util.List;
import com.smartor.domain.PatMedOperation;

import java.util.List;

/**
 * æ‚£è€…手术记录Service接口
 * 
 * @author lihu
 * @date 2024-08-05
 * @date 2025-02-21
 */
public interface IPatMedOperationService 
{

 smartor/src/main/java/com/smartor/service/impl/PatMedOperationItemServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.smartor.service.impl;

import java.util.List;
import com.ruoyi.common.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.smartor.mapper.PatMedOperationItemMapper;
import com.smartor.domain.PatMedOperationItem;
import com.smartor.service.IPatMedOperationItemService;

/**
 * æ‚£è€…检查检验记录子Service业务层处理
 * 
 * @author lihu
 * @date 2025-02-21
 */
@Service
public class PatMedOperationItemServiceImpl implements IPatMedOperationItemService 
{
    @Autowired
    private PatMedOperationItemMapper patMedOperationItemMapper;

    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录子
     * 
     * @param id æ‚£è€…检查检验记录子主键
     * @return æ‚£è€…检查检验记录子
     */
    @Override
    public PatMedOperationItem selectPatMedOperationItemById(Long id)
    {
        return patMedOperationItemMapper.selectPatMedOperationItemById(id);
    }

    /**
     * æŸ¥è¯¢æ‚£è€…检查检验记录子列表
     * 
     * @param patMedOperationItem æ‚£è€…检查检验记录子
     * @return æ‚£è€…检查检验记录子
     */
    @Override
    public List<PatMedOperationItem> selectPatMedOperationItemList(PatMedOperationItem patMedOperationItem)
    {
        return patMedOperationItemMapper.selectPatMedOperationItemList(patMedOperationItem);
    }

    /**
     * æ–°å¢žæ‚£è€…检查检验记录子
     * 
     * @param patMedOperationItem æ‚£è€…检查检验记录子
     * @return ç»“æžœ
     */
    @Override
    public int insertPatMedOperationItem(PatMedOperationItem patMedOperationItem)
    {
        patMedOperationItem.setCreateTime(DateUtils.getNowDate());
        return patMedOperationItemMapper.insertPatMedOperationItem(patMedOperationItem);
    }

    /**
     * ä¿®æ”¹æ‚£è€…检查检验记录子
     * 
     * @param patMedOperationItem æ‚£è€…检查检验记录子
     * @return ç»“æžœ
     */
    @Override
    public int updatePatMedOperationItem(PatMedOperationItem patMedOperationItem)
    {
        patMedOperationItem.setUpdateTime(DateUtils.getNowDate());
        return patMedOperationItemMapper.updatePatMedOperationItem(patMedOperationItem);
    }

    /**
     * æ‰¹é‡åˆ é™¤æ‚£è€…检查检验记录子
     * 
     * @param ids éœ€è¦åˆ é™¤çš„患者检查检验记录子主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatMedOperationItemByIds(Long[] ids)
    {
        return patMedOperationItemMapper.deletePatMedOperationItemByIds(ids);
    }

    /**
     * åˆ é™¤æ‚£è€…检查检验记录子信息
     * 
     * @param id æ‚£è€…检查检验记录子主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatMedOperationItemById(Long id)
    {
        return patMedOperationItemMapper.deletePatMedOperationItemById(id);
    }
}

 smartor/src/main/java/com/smartor/service/impl/PatMedOperationServiceImpl.java

@@ -2,17 +2,17 @@

import java.util.List;
import com.ruoyi.common.utils.DateUtils;
import com.smartor.domain.PatMedOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.smartor.mapper.PatMedOperationMapper;
import com.smartor.domain.PatMedOperation;
import com.smartor.service.IPatMedOperationService;

/**
 * æ‚£è€…手术记录Service业务层处理
 * 
 * @author lihu
 * @date 2024-08-05
 * @date 2025-02-21
 */
@Service
public class PatMedOperationServiceImpl implements IPatMedOperationService 

 smartor/src/main/java/com/smartor/service/impl/ServiceExternalServiceImpl.java

@@ -383,6 +383,7 @@

    @Override
    public Boolean addOperationInfo(Map dataMap) {
        //


        return null;

 smartor/src/main/resources/mapper/smartor/PatMedOperationItemMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,275 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.smartor.mapper.PatMedOperationItemMapper">

    <resultMap type="com.smartor.domain.PatMedOperationItem" id="PatMedOperationItemResult">
            <result property="id" column="id"/>
            <result property="opid" column="opid"/>
            <result property="opcode" column="opcode"/>
            <result property="opdesc" column="opdesc"/>
            <result property="mainFlag" column="main_flag"/>
            <result property="incitypecode" column="incitypecode"/>
            <result property="incitypedesc" column="incitypedesc"/>
            <result property="oplevelcode" column="oplevelcode"/>
            <result property="opleveldesc" column="opleveldesc"/>
            <result property="opposition" column="opposition"/>
            <result property="delFlag" column="del_flag"/>
            <result property="updateBy" column="update_by"/>
            <result property="updateTime" column="update_time"/>
            <result property="createBy" column="create_by"/>
            <result property="createTime" column="create_time"/>
            <result property="isupload" column="isupload"/>
            <result property="uploadTime" column="upload_time"/>
            <result property="orgid" column="orgid"/>
            <result property="pguid" column="pguid"/>
            <result property="guid" column="guid"/>
            <result property="pid" column="pid"/>
    </resultMap>

    <sql id="selectPatMedOperationItemVo">
        select id, opid, opcode, opdesc, main_flag, incitypecode, incitypedesc, oplevelcode, opleveldesc, opposition, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pguid, guid, pid
        from pat_med_operation_item
    </sql>

    <select id="selectPatMedOperationItemList" parameterType="com.smartor.domain.PatMedOperationItem"
            resultMap="PatMedOperationItemResult">
        <include refid="selectPatMedOperationItemVo"/>
        <where>
                        <if test="opid != null ">
                            and opid = #{opid}
                        </if>
                        <if test="opcode != null  and opcode != ''">
                            and opcode = #{opcode}
                        </if>
                        <if test="opdesc != null  and opdesc != ''">
                            and opdesc = #{opdesc}
                        </if>
                        <if test="mainFlag != null  and mainFlag != ''">
                            and main_flag = #{mainFlag}
                        </if>
                        <if test="incitypecode != null  and incitypecode != ''">
                            and incitypecode = #{incitypecode}
                        </if>
                        <if test="incitypedesc != null  and incitypedesc != ''">
                            and incitypedesc = #{incitypedesc}
                        </if>
                        <if test="oplevelcode != null  and oplevelcode != ''">
                            and oplevelcode = #{oplevelcode}
                        </if>
                        <if test="opleveldesc != null  and opleveldesc != ''">
                            and opleveldesc = #{opleveldesc}
                        </if>
                        <if test="opposition != null  and opposition != ''">
                            and opposition = #{opposition}
                        </if>
                        <if test="isupload != null ">
                            and isupload = #{isupload}
                        </if>
                        <if test="uploadTime != null ">
                            and upload_time = #{uploadTime}
                        </if>
                        <if test="orgid != null  and orgid != ''">
                            and orgid = #{orgid}
                        </if>
                        <if test="pguid != null  and pguid != ''">
                            and pguid = #{pguid}
                        </if>
                        <if test="guid != null  and guid != ''">
                            and guid = #{guid}
                        </if>
                        <if test="pid != null ">
                            and pid = #{pid}
                        </if>
        </where>
    </select>

    <select id="selectPatMedOperationItemById" parameterType="Long"
            resultMap="PatMedOperationItemResult">
            <include refid="selectPatMedOperationItemVo"/>
            where id = #{id}
    </select>

    <insert id="insertPatMedOperationItem" parameterType="com.smartor.domain.PatMedOperationItem">
        insert into pat_med_operation_item
        <trim prefix="(" suffix=")" suffixOverrides=",">
                    <if test="id != null">id,
                    </if>
                    <if test="opid != null">opid,
                    </if>
                    <if test="opcode != null">opcode,
                    </if>
                    <if test="opdesc != null">opdesc,
                    </if>
                    <if test="mainFlag != null">main_flag,
                    </if>
                    <if test="incitypecode != null">incitypecode,
                    </if>
                    <if test="incitypedesc != null">incitypedesc,
                    </if>
                    <if test="oplevelcode != null">oplevelcode,
                    </if>
                    <if test="opleveldesc != null">opleveldesc,
                    </if>
                    <if test="opposition != null">opposition,
                    </if>
                    <if test="delFlag != null">del_flag,
                    </if>
                    <if test="updateBy != null">update_by,
                    </if>
                    <if test="updateTime != null">update_time,
                    </if>
                    <if test="createBy != null">create_by,
                    </if>
                    <if test="createTime != null">create_time,
                    </if>
                    <if test="isupload != null">isupload,
                    </if>
                    <if test="uploadTime != null">upload_time,
                    </if>
                    <if test="orgid != null">orgid,
                    </if>
                    <if test="pguid != null">pguid,
                    </if>
                    <if test="guid != null">guid,
                    </if>
                    <if test="pid != null">pid,
                    </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
                    <if test="id != null">#{id},
                    </if>
                    <if test="opid != null">#{opid},
                    </if>
                    <if test="opcode != null">#{opcode},
                    </if>
                    <if test="opdesc != null">#{opdesc},
                    </if>
                    <if test="mainFlag != null">#{mainFlag},
                    </if>
                    <if test="incitypecode != null">#{incitypecode},
                    </if>
                    <if test="incitypedesc != null">#{incitypedesc},
                    </if>
                    <if test="oplevelcode != null">#{oplevelcode},
                    </if>
                    <if test="opleveldesc != null">#{opleveldesc},
                    </if>
                    <if test="opposition != null">#{opposition},
                    </if>
                    <if test="delFlag != null">#{delFlag},
                    </if>
                    <if test="updateBy != null">#{updateBy},
                    </if>
                    <if test="updateTime != null">#{updateTime},
                    </if>
                    <if test="createBy != null">#{createBy},
                    </if>
                    <if test="createTime != null">#{createTime},
                    </if>
                    <if test="isupload != null">#{isupload},
                    </if>
                    <if test="uploadTime != null">#{uploadTime},
                    </if>
                    <if test="orgid != null">#{orgid},
                    </if>
                    <if test="pguid != null">#{pguid},
                    </if>
                    <if test="guid != null">#{guid},
                    </if>
                    <if test="pid != null">#{pid},
                    </if>
        </trim>
    </insert>

    <update id="updatePatMedOperationItem" parameterType="com.smartor.domain.PatMedOperationItem">
        update pat_med_operation_item
        <trim prefix="SET" suffixOverrides=",">
                    <if test="opid != null">opid =
                        #{opid},
                    </if>
                    <if test="opcode != null">opcode =
                        #{opcode},
                    </if>
                    <if test="opdesc != null">opdesc =
                        #{opdesc},
                    </if>
                    <if test="mainFlag != null">main_flag =
                        #{mainFlag},
                    </if>
                    <if test="incitypecode != null">incitypecode =
                        #{incitypecode},
                    </if>
                    <if test="incitypedesc != null">incitypedesc =
                        #{incitypedesc},
                    </if>
                    <if test="oplevelcode != null">oplevelcode =
                        #{oplevelcode},
                    </if>
                    <if test="opleveldesc != null">opleveldesc =
                        #{opleveldesc},
                    </if>
                    <if test="opposition != null">opposition =
                        #{opposition},
                    </if>
                    <if test="delFlag != null">del_flag =
                        #{delFlag},
                    </if>
                    <if test="updateBy != null">update_by =
                        #{updateBy},
                    </if>
                    <if test="updateTime != null">update_time =
                        #{updateTime},
                    </if>
                    <if test="createBy != null">create_by =
                        #{createBy},
                    </if>
                    <if test="createTime != null">create_time =
                        #{createTime},
                    </if>
                    <if test="isupload != null">isupload =
                        #{isupload},
                    </if>
                    <if test="uploadTime != null">upload_time =
                        #{uploadTime},
                    </if>
                    <if test="orgid != null">orgid =
                        #{orgid},
                    </if>
                    <if test="pguid != null">pguid =
                        #{pguid},
                    </if>
                    <if test="guid != null">guid =
                        #{guid},
                    </if>
                    <if test="pid != null">pid =
                        #{pid},
                    </if>
        </trim>
        where id = #{id}
    </update>

                <update id="deletePatMedOperationItemById" parameterType="Long">
        update pat_med_operation_item
        <trim prefix="SET" suffixOverrides=",">
            del_flag =1
        </trim>
        where  id = #{id}
    </update>

                            <update id="deletePatMedOperationItemByIds" parameterType="String">
        update  pat_med_operation_item
        <trim prefix="SET" suffixOverrides=",">
            del_flag =1
        </trim>
        where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </update>




</mapper>

 smartor/src/main/resources/mapper/smartor/PatMedOperationMapper.xml

@@ -6,18 +6,39 @@

    <resultMap type="com.smartor.domain.PatMedOperation" id="PatMedOperationResult">
        <result property="id"    column="id"    />
        <result property="serialnum"    column="serialnum"    />
        <result property="patid"    column="patid"    />
        <result property="operationname"    column="operationname"    />
            <result property="patcode" column="patcode"/>
            <result property="paname" column="paname"/>
            <result property="opreqid" column="opreqid"/>
            <result property="opreqcode" column="opreqcode"/>
            <result property="opsstatus" column="opsstatus"/>
        <result property="operationcode"    column="operationcode"    />
        <result property="operationid"    column="operationid"    />
        <result property="operationtime"    column="operationtime"    />
        <result property="visitid"    column="visitid"    />
            <result property="operationname" column="operationname"/>
            <result property="operatortime" column="operatortime"/>
            <result property="opreqtime" column="opreqtime"/>
            <result property="reqdoccode" column="reqdoccode"/>
            <result property="reqdocname" column="reqdocname"/>
            <result property="reqdeptcode" column="reqdeptcode"/>
            <result property="reqdeptname" column="reqdeptname"/>
            <result property="reqloccode" column="reqloccode"/>
            <result property="reqlocname" column="reqlocname"/>
            <result property="remark" column="remark"/>
            <result property="surgeoncode" column="surgeoncode"/>
            <result property="surgeonname" column="surgeonname"/>
            <result property="firasscode" column="firasscode"/>
            <result property="firassname" column="firassname"/>
            <result property="secasscode" column="secasscode"/>
            <result property="secassname" column="secassname"/>
            <result property="thrasscode" column="thrasscode"/>
            <result property="thrassname" column="thrassname"/>
            <result property="canceltime" column="canceltime"/>
            <result property="cancelreason" column="cancelreason"/>
            <result property="cancelcode" column="cancelcode"/>
            <result property="cancelname" column="cancelname"/>
        <result property="visittype"    column="visittype"    />
        <result property="status"    column="status"    />
        <result property="schemetime"    column="schemetime"    />
        <result property="schemestatus"    column="schemestatus"    />
        <result property="orgid"    column="orgid"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
@@ -25,37 +46,217 @@
        <result property="createTime"    column="create_time"    />
        <result property="isupload"    column="isupload"    />
        <result property="uploadTime"    column="upload_time"    />
        <result property="pid"    column="pid"    />
            <result property="orgid" column="orgid"/>
        <result property="guid"    column="guid"    />
            <result property="pguid" column="pguid"/>
            <result property="pid" column="pid"/>
            <result property="inhospstate" column="inhospstate"/>
            <result property="patno" column="patno"/>
            <result property="patname" column="patname"/>
            <result property="visitid" column="visitid"/>
            <result property="serialnum" column="serialnum"/>
            <result property="inhospno" column="inhospno"/>
            <result property="hospitalname" column="hospitalname"/>
            <result property="hospitalcode" column="hospitalcode"/>
            <result property="deptid" column="deptid"/>
            <result property="deptcode" column="deptcode"/>
            <result property="deptname" column="deptname"/>
            <result property="hospitaldistrictcode" column="hospitaldistrictcode"/>
            <result property="hospitaldistrictname" column="hospitaldistrictname"/>
            <result property="roomno" column="roomno"/>
            <result property="bedNo" column="bed_no"/>
            <result property="drcode" column="drcode"/>
            <result property="drname" column="drname"/>
            <result property="nurseId" column="nurse_id"/>
            <result property="nurseName" column="nurse_name"/>
    </resultMap>

    <sql id="selectPatMedOperationVo">
        select id, serialnum, patid, operationname, operationcode, operationid, operationtime, visitid, visittype, status, schemetime, schemestatus, orgid, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, pid, guid from pat_med_operation
        select id, patid, patcode, paname, opreqid, opreqcode, opsstatus, operationcode, operationname,  operatortime, opreqtime, reqdoccode, reqdocname, reqdeptcode, reqdeptname, reqloccode, reqlocname, remark, surgeoncode, surgeonname, firasscode, firassname, secasscode, secassname, thrasscode, thrassname, canceltime, cancelreason, cancelcode, cancelname, visittype, status, schemetime, schemestatus, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, guid, pguid, pid, inhospstate, patno, patname, visitid, serialnum, inhospno, hospitalname, hospitalcode, deptid, deptcode, deptname, hospitaldistrictcode, hospitaldistrictname, roomno, bed_no, drcode, drname, nurse_id, nurse_name
        from pat_med_operation
    </sql>

    <select id="selectPatMedOperationList" parameterType="com.smartor.domain.PatMedOperation" resultMap="PatMedOperationResult">
    <select id="selectPatMedOperationList" parameterType="com.smartor.domain.PatMedOperation"
            resultMap="PatMedOperationResult">
        <include refid="selectPatMedOperationVo"/>
        <where>
            <if test="serialnum != null  and serialnum != ''"> and serialnum = #{serialnum}</if>
            <if test="patid != null "> and patid = #{patid}</if>
            <if test="operationname != null  and operationname != ''"> and operationname like concat('%', #{operationname}, '%')</if>
            <if test="operationcode != null  and operationcode != ''"> and operationcode = #{operationcode}</if>
            <if test="operationid != null "> and operationid = #{operationid}</if>
            <if test="operationtime != null "> and operationtime = #{operationtime}</if>
            <if test="visitid != null "> and visitid = #{visitid}</if>
            <if test="visittype != null "> and visittype = #{visittype}</if>
            <if test="status != null "> and status = #{status}</if>
            <if test="schemetime != null "> and schemetime = #{schemetime}</if>
            <if test="schemestatus != null "> and schemestatus = #{schemestatus}</if>
            <if test="orgid != null  and orgid != ''"> and orgid = #{orgid}</if>
            <if test="isupload != null "> and isupload = #{isupload}</if>
            <if test="uploadTime != null "> and upload_time = #{uploadTime}</if>
            <if test="pid != null "> and pid = #{pid}</if>
            <if test="guid != null  and guid != ''"> and guid = #{guid}</if>
                        <if test="patid != null ">
                            and patid = #{patid}
                        </if>
                        <if test="patcode != null  and patcode != ''">
                            and patcode = #{patcode}
                        </if>
                        <if test="paname != null  and paname != ''">
                            and paname like concat('%', #{paname}, '%')
                        </if>
                        <if test="opreqid != null ">
                            and opreqid = #{opreqid}
                        </if>
                        <if test="opreqcode != null  and opreqcode != ''">
                            and opreqcode = #{opreqcode}
                        </if>
                        <if test="opsstatus != null  and opsstatus != ''">
                            and opsstatus = #{opsstatus}
                        </if>
                        <if test="operationcode != null  and operationcode != ''">
                            and operationcode = #{operationcode}
                        </if>
                        <if test="operationname != null  and operationname != ''">
                            and operationname like concat('%', #{operationname}, '%')
                        </if>

                        <if test="operatortime != null ">
                            and operatortime = #{operatortime}
                        </if>
                        <if test="opreqtime != null ">
                            and opreqtime = #{opreqtime}
                        </if>
                        <if test="reqdoccode != null  and reqdoccode != ''">
                            and reqdoccode = #{reqdoccode}
                        </if>
                        <if test="reqdocname != null  and reqdocname != ''">
                            and reqdocname like concat('%', #{reqdocname}, '%')
                        </if>
                        <if test="reqdeptcode != null  and reqdeptcode != ''">
                            and reqdeptcode = #{reqdeptcode}
                        </if>
                        <if test="reqdeptname != null  and reqdeptname != ''">
                            and reqdeptname like concat('%', #{reqdeptname}, '%')
                        </if>
                        <if test="reqloccode != null  and reqloccode != ''">
                            and reqloccode = #{reqloccode}
                        </if>
                        <if test="reqlocname != null  and reqlocname != ''">
                            and reqlocname like concat('%', #{reqlocname}, '%')
                        </if>
                        <if test="surgeoncode != null  and surgeoncode != ''">
                            and surgeoncode = #{surgeoncode}
                        </if>
                        <if test="surgeonname != null  and surgeonname != ''">
                            and surgeonname like concat('%', #{surgeonname}, '%')
                        </if>
                        <if test="firasscode != null  and firasscode != ''">
                            and firasscode = #{firasscode}
                        </if>
                        <if test="firassname != null  and firassname != ''">
                            and firassname like concat('%', #{firassname}, '%')
                        </if>
                        <if test="secasscode != null  and secasscode != ''">
                            and secasscode = #{secasscode}
                        </if>
                        <if test="secassname != null  and secassname != ''">
                            and secassname like concat('%', #{secassname}, '%')
                        </if>
                        <if test="thrasscode != null  and thrasscode != ''">
                            and thrasscode = #{thrasscode}
                        </if>
                        <if test="thrassname != null  and thrassname != ''">
                            and thrassname like concat('%', #{thrassname}, '%')
                        </if>
                        <if test="canceltime != null  and canceltime != ''">
                            and canceltime = #{canceltime}
                        </if>
                        <if test="cancelreason != null  and cancelreason != ''">
                            and cancelreason = #{cancelreason}
                        </if>
                        <if test="cancelcode != null  and cancelcode != ''">
                            and cancelcode = #{cancelcode}
                        </if>
                        <if test="cancelname != null  and cancelname != ''">
                            and cancelname like concat('%', #{cancelname}, '%')
                        </if>
                        <if test="visittype != null ">
                            and visittype = #{visittype}
                        </if>
                        <if test="status != null  and status != ''">
                            and status = #{status}
                        </if>
                        <if test="schemetime != null ">
                            and schemetime = #{schemetime}
                        </if>
                        <if test="schemestatus != null ">
                            and schemestatus = #{schemestatus}
                        </if>
                        <if test="isupload != null ">
                            and isupload = #{isupload}
                        </if>
                        <if test="uploadTime != null ">
                            and upload_time = #{uploadTime}
                        </if>
                        <if test="orgid != null  and orgid != ''">
                            and orgid = #{orgid}
                        </if>
                        <if test="guid != null  and guid != ''">
                            and guid = #{guid}
                        </if>
                        <if test="pguid != null  and pguid != ''">
                            and pguid = #{pguid}
                        </if>
                        <if test="pid != null ">
                            and pid = #{pid}
                        </if>
                        <if test="inhospstate != null  and inhospstate != ''">
                            and inhospstate = #{inhospstate}
                        </if>
                        <if test="patno != null  and patno != ''">
                            and patno = #{patno}
                        </if>
                        <if test="patname != null  and patname != ''">
                            and patname like concat('%', #{patname}, '%')
                        </if>
                        <if test="visitid != null ">
                            and visitid = #{visitid}
                        </if>
                        <if test="serialnum != null  and serialnum != ''">
                            and serialnum = #{serialnum}
                        </if>
                        <if test="inhospno != null  and inhospno != ''">
                            and inhospno = #{inhospno}
                        </if>
                        <if test="hospitalname != null  and hospitalname != ''">
                            and hospitalname like concat('%', #{hospitalname}, '%')
                        </if>
                        <if test="hospitalcode != null  and hospitalcode != ''">
                            and hospitalcode = #{hospitalcode}
                        </if>
                        <if test="deptid != null  and deptid != ''">
                            and deptid = #{deptid}
                        </if>
                        <if test="deptcode != null  and deptcode != ''">
                            and deptcode = #{deptcode}
                        </if>
                        <if test="deptname != null  and deptname != ''">
                            and deptname like concat('%', #{deptname}, '%')
                        </if>
                        <if test="hospitaldistrictcode != null  and hospitaldistrictcode != ''">
                            and hospitaldistrictcode = #{hospitaldistrictcode}
                        </if>
                        <if test="hospitaldistrictname != null  and hospitaldistrictname != ''">
                            and hospitaldistrictname like concat('%', #{hospitaldistrictname}, '%')
                        </if>
                        <if test="roomno != null  and roomno != ''">
                            and roomno = #{roomno}
                        </if>
                        <if test="bedNo != null  and bedNo != ''">
                            and bed_no = #{bedNo}
                        </if>
                        <if test="drcode != null  and drcode != ''">
                            and drcode = #{drcode}
                        </if>
                        <if test="drname != null  and drname != ''">
                            and drname like concat('%', #{drname}, '%')
                        </if>
                        <if test="nurseId != null  and nurseId != ''">
                            and nurse_id = #{nurseId}
                        </if>
                        <if test="nurseName != null  and nurseName != ''">
                            and nurse_name like concat('%', #{nurseName}, '%')
                        </if>
        </where>
    </select>

    <select id="selectPatMedOperationById" parameterType="Long" resultMap="PatMedOperationResult">
    <select id="selectPatMedOperationById" parameterType="Long"
            resultMap="PatMedOperationResult">
        <include refid="selectPatMedOperationVo"/>
        where id = #{id}
    </select>
@@ -63,91 +264,483 @@
    <insert id="insertPatMedOperation" parameterType="com.smartor.domain.PatMedOperation">
        insert into pat_med_operation
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="serialnum != null">serialnum,</if>
            <if test="patid != null">patid,</if>
            <if test="operationname != null">operationname,</if>
            <if test="operationcode != null">operationcode,</if>
            <if test="operationid != null">operationid,</if>
            <if test="operationtime != null">operationtime,</if>
            <if test="visitid != null">visitid,</if>
            <if test="visittype != null">visittype,</if>
            <if test="status != null">status,</if>
            <if test="schemetime != null">schemetime,</if>
            <if test="schemestatus != null">schemestatus,</if>
            <if test="orgid != null">orgid,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="isupload != null">isupload,</if>
            <if test="uploadTime != null">upload_time,</if>
            <if test="pid != null">pid,</if>
            <if test="guid != null">guid,</if>
                    <if test="id != null">id,
                    </if>
                    <if test="patid != null">patid,
                    </if>
                    <if test="patcode != null">patcode,
                    </if>
                    <if test="paname != null">paname,
                    </if>
                    <if test="opreqid != null">opreqid,
                    </if>
                    <if test="opreqcode != null">opreqcode,
                    </if>
                    <if test="opsstatus != null">opsstatus,
                    </if>
                    <if test="operationcode != null">operationcode,
                    </if>
                    <if test="operationname != null">operationname,
                    </if>
                    <if test="operatortime != null">operatortime,
                    </if>
                    <if test="opreqtime != null">opreqtime,
                    </if>
                    <if test="reqdoccode != null">reqdoccode,
                    </if>
                    <if test="reqdocname != null">reqdocname,
                    </if>
                    <if test="reqdeptcode != null">reqdeptcode,
                    </if>
                    <if test="reqdeptname != null">reqdeptname,
                    </if>
                    <if test="reqloccode != null">reqloccode,
                    </if>
                    <if test="reqlocname != null">reqlocname,
                    </if>
                    <if test="remark != null">remark,
                    </if>
                    <if test="surgeoncode != null">surgeoncode,
                    </if>
                    <if test="surgeonname != null">surgeonname,
                    </if>
                    <if test="firasscode != null">firasscode,
                    </if>
                    <if test="firassname != null">firassname,
                    </if>
                    <if test="secasscode != null">secasscode,
                    </if>
                    <if test="secassname != null">secassname,
                    </if>
                    <if test="thrasscode != null">thrasscode,
                    </if>
                    <if test="thrassname != null">thrassname,
                    </if>
                    <if test="canceltime != null">canceltime,
                    </if>
                    <if test="cancelreason != null">cancelreason,
                    </if>
                    <if test="cancelcode != null">cancelcode,
                    </if>
                    <if test="cancelname != null">cancelname,
                    </if>
                    <if test="visittype != null">visittype,
                    </if>
                    <if test="status != null">status,
                    </if>
                    <if test="schemetime != null">schemetime,
                    </if>
                    <if test="schemestatus != null">schemestatus,
                    </if>
                    <if test="delFlag != null">del_flag,
                    </if>
                    <if test="updateBy != null">update_by,
                    </if>
                    <if test="updateTime != null">update_time,
                    </if>
                    <if test="createBy != null">create_by,
                    </if>
                    <if test="createTime != null">create_time,
                    </if>
                    <if test="isupload != null">isupload,
                    </if>
                    <if test="uploadTime != null">upload_time,
                    </if>
                    <if test="orgid != null">orgid,
                    </if>
                    <if test="guid != null">guid,
                    </if>
                    <if test="pguid != null">pguid,
                    </if>
                    <if test="pid != null">pid,
                    </if>
                    <if test="inhospstate != null">inhospstate,
                    </if>
                    <if test="patno != null">patno,
                    </if>
                    <if test="patname != null">patname,
                    </if>
                    <if test="visitid != null">visitid,
                    </if>
                    <if test="serialnum != null">serialnum,
                    </if>
                    <if test="inhospno != null">inhospno,
                    </if>
                    <if test="hospitalname != null">hospitalname,
                    </if>
                    <if test="hospitalcode != null">hospitalcode,
                    </if>
                    <if test="deptid != null">deptid,
                    </if>
                    <if test="deptcode != null">deptcode,
                    </if>
                    <if test="deptname != null">deptname,
                    </if>
                    <if test="hospitaldistrictcode != null">hospitaldistrictcode,
                    </if>
                    <if test="hospitaldistrictname != null">hospitaldistrictname,
                    </if>
                    <if test="roomno != null">roomno,
                    </if>
                    <if test="bedNo != null">bed_no,
                    </if>
                    <if test="drcode != null">drcode,
                    </if>
                    <if test="drname != null">drname,
                    </if>
                    <if test="nurseId != null">nurse_id,
                    </if>
                    <if test="nurseName != null">nurse_name,
                    </if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="serialnum != null">#{serialnum},</if>
            <if test="patid != null">#{patid},</if>
            <if test="operationname != null">#{operationname},</if>
            <if test="operationcode != null">#{operationcode},</if>
            <if test="operationid != null">#{operationid},</if>
            <if test="operationtime != null">#{operationtime},</if>
            <if test="visitid != null">#{visitid},</if>
            <if test="visittype != null">#{visittype},</if>
            <if test="status != null">#{status},</if>
            <if test="schemetime != null">#{schemetime},</if>
            <if test="schemestatus != null">#{schemestatus},</if>
            <if test="orgid != null">#{orgid},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="isupload != null">#{isupload},</if>
            <if test="uploadTime != null">#{uploadTime},</if>
            <if test="pid != null">#{pid},</if>
            <if test="guid != null">#{guid},</if>
                    <if test="id != null">#{id},
                    </if>
                    <if test="patid != null">#{patid},
                    </if>
                    <if test="patcode != null">#{patcode},
                    </if>
                    <if test="paname != null">#{paname},
                    </if>
                    <if test="opreqid != null">#{opreqid},
                    </if>
                    <if test="opreqcode != null">#{opreqcode},
                    </if>
                    <if test="opsstatus != null">#{opsstatus},
                    </if>
                    <if test="operationcode != null">#{operationcode},
                    </if>
                    <if test="operationname != null">#{operationname},
                    </if>
                    <if test="operatortime != null">#{operatortime},
                    </if>
                    <if test="opreqtime != null">#{opreqtime},
                    </if>
                    <if test="reqdoccode != null">#{reqdoccode},
                    </if>
                    <if test="reqdocname != null">#{reqdocname},
                    </if>
                    <if test="reqdeptcode != null">#{reqdeptcode},
                    </if>
                    <if test="reqdeptname != null">#{reqdeptname},
                    </if>
                    <if test="reqloccode != null">#{reqloccode},
                    </if>
                    <if test="reqlocname != null">#{reqlocname},
                    </if>
                    <if test="remark != null">#{remark},
                    </if>
                    <if test="surgeoncode != null">#{surgeoncode},
                    </if>
                    <if test="surgeonname != null">#{surgeonname},
                    </if>
                    <if test="firasscode != null">#{firasscode},
                    </if>
                    <if test="firassname != null">#{firassname},
                    </if>
                    <if test="secasscode != null">#{secasscode},
                    </if>
                    <if test="secassname != null">#{secassname},
                    </if>
                    <if test="thrasscode != null">#{thrasscode},
                    </if>
                    <if test="thrassname != null">#{thrassname},
                    </if>
                    <if test="canceltime != null">#{canceltime},
                    </if>
                    <if test="cancelreason != null">#{cancelreason},
                    </if>
                    <if test="cancelcode != null">#{cancelcode},
                    </if>
                    <if test="cancelname != null">#{cancelname},
                    </if>
                    <if test="visittype != null">#{visittype},
                    </if>
                    <if test="status != null">#{status},
                    </if>
                    <if test="schemetime != null">#{schemetime},
                    </if>
                    <if test="schemestatus != null">#{schemestatus},
                    </if>
                    <if test="delFlag != null">#{delFlag},
                    </if>
                    <if test="updateBy != null">#{updateBy},
                    </if>
                    <if test="updateTime != null">#{updateTime},
                    </if>
                    <if test="createBy != null">#{createBy},
                    </if>
                    <if test="createTime != null">#{createTime},
                    </if>
                    <if test="isupload != null">#{isupload},
                    </if>
                    <if test="uploadTime != null">#{uploadTime},
                    </if>
                    <if test="orgid != null">#{orgid},
                    </if>
                    <if test="guid != null">#{guid},
                    </if>
                    <if test="pguid != null">#{pguid},
                    </if>
                    <if test="pid != null">#{pid},
                    </if>
                    <if test="inhospstate != null">#{inhospstate},
                    </if>
                    <if test="patno != null">#{patno},
                    </if>
                    <if test="patname != null">#{patname},
                    </if>
                    <if test="visitid != null">#{visitid},
                    </if>
                    <if test="serialnum != null">#{serialnum},
                    </if>
                    <if test="inhospno != null">#{inhospno},
                    </if>
                    <if test="hospitalname != null">#{hospitalname},
                    </if>
                    <if test="hospitalcode != null">#{hospitalcode},
                    </if>
                    <if test="deptid != null">#{deptid},
                    </if>
                    <if test="deptcode != null">#{deptcode},
                    </if>
                    <if test="deptname != null">#{deptname},
                    </if>
                    <if test="hospitaldistrictcode != null">#{hospitaldistrictcode},
                    </if>
                    <if test="hospitaldistrictname != null">#{hospitaldistrictname},
                    </if>
                    <if test="roomno != null">#{roomno},
                    </if>
                    <if test="bedNo != null">#{bedNo},
                    </if>
                    <if test="drcode != null">#{drcode},
                    </if>
                    <if test="drname != null">#{drname},
                    </if>
                    <if test="nurseId != null">#{nurseId},
                    </if>
                    <if test="nurseName != null">#{nurseName},
                    </if>
         </trim>
    </insert>

    <update id="updatePatMedOperation" parameterType="com.smartor.domain.PatMedOperation">
        update pat_med_operation
        <trim prefix="SET" suffixOverrides=",">
            <if test="serialnum != null">serialnum = #{serialnum},</if>
            <if test="patid != null">patid = #{patid},</if>
            <if test="operationname != null">operationname = #{operationname},</if>
            <if test="operationcode != null">operationcode = #{operationcode},</if>
            <if test="operationid != null">operationid = #{operationid},</if>
            <if test="operationtime != null">operationtime = #{operationtime},</if>
            <if test="visitid != null">visitid = #{visitid},</if>
            <if test="visittype != null">visittype = #{visittype},</if>
            <if test="status != null">status = #{status},</if>
            <if test="schemetime != null">schemetime = #{schemetime},</if>
            <if test="schemestatus != null">schemestatus = #{schemestatus},</if>
            <if test="orgid != null">orgid = #{orgid},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="isupload != null">isupload = #{isupload},</if>
            <if test="uploadTime != null">upload_time = #{uploadTime},</if>
            <if test="pid != null">pid = #{pid},</if>
            <if test="guid != null">guid = #{guid},</if>
                    <if test="patid != null">patid =
                        #{patid},
                    </if>
                    <if test="patcode != null">patcode =
                        #{patcode},
                    </if>
                    <if test="paname != null">paname =
                        #{paname},
                    </if>
                    <if test="opreqid != null">opreqid =
                        #{opreqid},
                    </if>
                    <if test="opreqcode != null">opreqcode =
                        #{opreqcode},
                    </if>
                    <if test="opsstatus != null">opsstatus =
                        #{opsstatus},
                    </if>
                    <if test="operationcode != null">operationcode =
                        #{operationcode},
                    </if>
                    <if test="operationname != null">operationname =
                        #{operationname},
                    </if>
                    <if test="operatortime != null">operatortime =
                        #{operatortime},
                    </if>
                    <if test="opreqtime != null">opreqtime =
                        #{opreqtime},
                    </if>
                    <if test="reqdoccode != null">reqdoccode =
                        #{reqdoccode},
                    </if>
                    <if test="reqdocname != null">reqdocname =
                        #{reqdocname},
                    </if>
                    <if test="reqdeptcode != null">reqdeptcode =
                        #{reqdeptcode},
                    </if>
                    <if test="reqdeptname != null">reqdeptname =
                        #{reqdeptname},
                    </if>
                    <if test="reqloccode != null">reqloccode =
                        #{reqloccode},
                    </if>
                    <if test="reqlocname != null">reqlocname =
                        #{reqlocname},
                    </if>
                    <if test="remark != null">remark =
                        #{remark},
                    </if>
                    <if test="surgeoncode != null">surgeoncode =
                        #{surgeoncode},
                    </if>
                    <if test="surgeonname != null">surgeonname =
                        #{surgeonname},
                    </if>
                    <if test="firasscode != null">firasscode =
                        #{firasscode},
                    </if>
                    <if test="firassname != null">firassname =
                        #{firassname},
                    </if>
                    <if test="secasscode != null">secasscode =
                        #{secasscode},
                    </if>
                    <if test="secassname != null">secassname =
                        #{secassname},
                    </if>
                    <if test="thrasscode != null">thrasscode =
                        #{thrasscode},
                    </if>
                    <if test="thrassname != null">thrassname =
                        #{thrassname},
                    </if>
                    <if test="canceltime != null">canceltime =
                        #{canceltime},
                    </if>
                    <if test="cancelreason != null">cancelreason =
                        #{cancelreason},
                    </if>
                    <if test="cancelcode != null">cancelcode =
                        #{cancelcode},
                    </if>
                    <if test="cancelname != null">cancelname =
                        #{cancelname},
                    </if>
                    <if test="visittype != null">visittype =
                        #{visittype},
                    </if>
                    <if test="status != null">status =
                        #{status},
                    </if>
                    <if test="schemetime != null">schemetime =
                        #{schemetime},
                    </if>
                    <if test="schemestatus != null">schemestatus =
                        #{schemestatus},
                    </if>
                    <if test="delFlag != null">del_flag =
                        #{delFlag},
                    </if>
                    <if test="updateBy != null">update_by =
                        #{updateBy},
                    </if>
                    <if test="updateTime != null">update_time =
                        #{updateTime},
                    </if>
                    <if test="createBy != null">create_by =
                        #{createBy},
                    </if>
                    <if test="createTime != null">create_time =
                        #{createTime},
                    </if>
                    <if test="isupload != null">isupload =
                        #{isupload},
                    </if>
                    <if test="uploadTime != null">upload_time =
                        #{uploadTime},
                    </if>
                    <if test="orgid != null">orgid =
                        #{orgid},
                    </if>
                    <if test="guid != null">guid =
                        #{guid},
                    </if>
                    <if test="pguid != null">pguid =
                        #{pguid},
                    </if>
                    <if test="pid != null">pid =
                        #{pid},
                    </if>
                    <if test="inhospstate != null">inhospstate =
                        #{inhospstate},
                    </if>
                    <if test="patno != null">patno =
                        #{patno},
                    </if>
                    <if test="patname != null">patname =
                        #{patname},
                    </if>
                    <if test="visitid != null">visitid =
                        #{visitid},
                    </if>
                    <if test="serialnum != null">serialnum =
                        #{serialnum},
                    </if>
                    <if test="inhospno != null">inhospno =
                        #{inhospno},
                    </if>
                    <if test="hospitalname != null">hospitalname =
                        #{hospitalname},
                    </if>
                    <if test="hospitalcode != null">hospitalcode =
                        #{hospitalcode},
                    </if>
                    <if test="deptid != null">deptid =
                        #{deptid},
                    </if>
                    <if test="deptcode != null">deptcode =
                        #{deptcode},
                    </if>
                    <if test="deptname != null">deptname =
                        #{deptname},
                    </if>
                    <if test="hospitaldistrictcode != null">hospitaldistrictcode =
                        #{hospitaldistrictcode},
                    </if>
                    <if test="hospitaldistrictname != null">hospitaldistrictname =
                        #{hospitaldistrictname},
                    </if>
                    <if test="roomno != null">roomno =
                        #{roomno},
                    </if>
                    <if test="bedNo != null">bed_no =
                        #{bedNo},
                    </if>
                    <if test="drcode != null">drcode =
                        #{drcode},
                    </if>
                    <if test="drname != null">drname =
                        #{drname},
                    </if>
                    <if test="nurseId != null">nurse_id =
                        #{nurseId},
                    </if>
                    <if test="nurseName != null">nurse_name =
                        #{nurseName},
                    </if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deletePatMedOperationById" parameterType="Long">
        delete from pat_med_operation where id = #{id}
    </delete>
                <update id="deletePatMedOperationById" parameterType="Long">
        update pat_med_operation
        <trim prefix="SET" suffixOverrides=",">
            del_flag =1
        </trim>
        where  id = #{id}
    </update>

    <delete id="deletePatMedOperationByIds" parameterType="String">
        delete from pat_med_operation where id in
                            <update id="deletePatMedOperationByIds" parameterType="String">
        update  pat_med_operation
        <trim prefix="SET" suffixOverrides=",">
            del_flag =1
        </trim>
        where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
    </update>




</mapper>