代码提交

liusheng

2024-08-05 89e166f18d6e33efde0dda97f1fb27f29e675660

代码提交

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,108 @@
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.PatMedOperation;
import com.smartor.service.IPatMedOperationService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

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

    /**
     * æŸ¥è¯¢æ‚£è€…手术记录列表
     */
    @ApiOperation("查询患者手术记录列表")
    @PreAuthorize("@ss.hasPermi('smartor:operation:list')")
    @GetMapping("/list")
    public TableDataInfo list(PatMedOperation patMedOperation) {
        startPage();
        List<PatMedOperation> list = patMedOperationService.selectPatMedOperationList(patMedOperation);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºæ‚£è€…手术记录列表
     */
    @ApiOperation("导出患者手术记录列表")
    @PreAuthorize("@ss.hasPermi('smartor:operation:export')")
    @Log(title = "患者手术记录" , businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    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, "患者手术记录数据");
    }

    /**
     * èŽ·å–患者手术记录详细信息
     */
    @ApiOperation("获取患者手术记录详细信息")
    @PreAuthorize("@ss.hasPermi('smartor:operation:query')")
    @GetMapping(value = "/getInfo/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        return success(patMedOperationService.selectPatMedOperationById(id));
    }

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

    /**
     * ä¿®æ”¹æ‚£è€…手术记录
     */
    @ApiOperation("修改患者手术记录")
    @PreAuthorize("@ss.hasPermi('smartor:operation:edit')")
    @Log(title = "患者手术记录" , businessType = BusinessType.UPDATE)
    @PostMapping("/edit")
    public AjaxResult edit(@RequestBody PatMedOperation patMedOperation) {
        return toAjax(patMedOperationService.updatePatMedOperation(patMedOperation));
    }

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

 ruoyi-generator/src/main/resources/vm/xml/mapper.xml.vm

@@ -12,7 +12,8 @@
#if($table.sub)

    <resultMap id="${ClassName}${subClassName}Result" type="${ClassName}" extends="${ClassName}Result">
        <collection property="${subclassName}List" notNullColumn="sub_${subTable.pkColumn.columnName}" javaType="java.util.List" resultMap="${subClassName}Result" />
            <collection property="${subclassName}List" notNullColumn="sub_${subTable.pkColumn.columnName}"
                        javaType="java.util.List" resultMap="${subClassName}Result"/>
    </resultMap>

    <resultMap type="${subClassName}" id="${subClassName}Result">
@@ -23,10 +24,12 @@
#end

    <sql id="select${ClassName}Vo">
        select#foreach($column in $columns) $column.columnName#if($foreach.count != $columns.size()),#end#end from ${tableName}
        select#foreach($column in $columns) $column.columnName#if($foreach.count != $columns.size()),#end#end
        from ${tableName}
    </sql>

    <select id="select${ClassName}List" parameterType="${packageName}.domain.${ClassName}" resultMap="${ClassName}Result">
    <select id="select${ClassName}List" parameterType="${packageName}.domain.${ClassName}"
            resultMap="${ClassName}Result">
        <include refid="select${ClassName}Vo"/>
        <where>
#foreach($column in $columns)
@@ -37,34 +40,52 @@
#set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})
#if($column.query)
#if($column.queryType == "EQ")
            <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName = #{$javaField}</if>
                        <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end">
                            and $columnName = #{$javaField}
                        </if>
#elseif($queryType == "NE")
            <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName != #{$javaField}</if>
                        <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end">
                            and $columnName != #{$javaField}
                        </if>
#elseif($queryType == "GT")
            <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName &gt; #{$javaField}</if>
                        <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end">
                            and $columnName &gt; #{$javaField}
                        </if>
#elseif($queryType == "GTE")
            <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName &gt;= #{$javaField}</if>
                        <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end">
                            and $columnName &gt;= #{$javaField}
                        </if>
#elseif($queryType == "LT")
            <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName &lt; #{$javaField}</if>
                        <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end">
                            and $columnName &lt; #{$javaField}
                        </if>
#elseif($queryType == "LTE")
            <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName &lt;= #{$javaField}</if>
                        <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end">
                            and $columnName &lt;= #{$javaField}
                        </if>
#elseif($queryType == "LIKE")
            <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end"> and $columnName like concat('%', #{$javaField}, '%')</if>
                        <if test="$javaField != null #if($javaType == 'String' ) and $javaField.trim() != ''#end">
                            and $columnName like concat('%', #{$javaField}, '%')
                        </if>
#elseif($queryType == "BETWEEN")
            <if test="params.begin$AttrName != null and params.begin$AttrName != '' and params.end$AttrName != null and params.end$AttrName != ''"> and $columnName between #{params.begin$AttrName} and #{params.end$AttrName}</if>
                        <if test="params.begin$AttrName != null and params.begin$AttrName != '' and params.end$AttrName != null and params.end$AttrName != ''">
                            and $columnName between #{params.begin$AttrName} and #{params.end$AttrName}
                        </if>
#end
#end
#end
        </where>
    </select>

    <select id="select${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}" resultMap="#if($table.sub)${ClassName}${subClassName}Result#else${ClassName}Result#end">
    <select id="select${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}"
            resultMap="#if($table.sub)${ClassName}${subClassName}Result#else${ClassName}Result#end">
#if($table.crud || $table.tree)
        <include refid="select${ClassName}Vo"/>
        where ${pkColumn.columnName} = #{${pkColumn.javaField}}
#elseif($table.sub)
        select#foreach($column in $columns) a.$column.columnName#if($foreach.count != $columns.size()),#end#end,
           #foreach($column in $subTable.columns) b.$column.columnName as sub_$column.columnName#if($foreach.count != $subTable.columns.size()),#end#end
            #foreach($column in $subTable.columns) b.$column.columnName as
                sub_$column.columnName#if($foreach.count != $subTable.columns.size()),#end#end

        from ${tableName} a
        left join ${subTableName} b on b.${subTableFkName} = a.${pkColumn.columnName}
@@ -72,19 +93,24 @@
#end
    </select>

    <insert id="insert${ClassName}" parameterType="${packageName}.domain.${ClassName}"#if($pkColumn.increment) useGeneratedKeys="true" keyProperty="$pkColumn.javaField"#end>
    <insert id="insert${ClassName}" parameterType="${packageName}.domain.${ClassName}"#if($pkColumn.increment)
            useGeneratedKeys="true" keyProperty="$pkColumn.javaField"#end>
        insert into ${tableName}
        <trim prefix="(" suffix=")" suffixOverrides=",">
#foreach($column in $columns)
#if($column.columnName != $pkColumn.columnName || !$pkColumn.increment)
            <if test="$column.javaField != null#if($column.javaType == 'String' && $column.required) and $column.javaField != ''#end">$column.columnName,</if>
                    <if test="$column.javaField != null#if($column.javaType ==
                        'String' && $column.required) and $column.javaField != ''#end">$column.columnName,
                    </if>
#end
#end
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
#foreach($column in $columns)
#if($column.columnName != $pkColumn.columnName || !$pkColumn.increment)
            <if test="$column.javaField != null#if($column.javaType == 'String' && $column.required) and $column.javaField != ''#end">#{$column.javaField},</if>
                    <if test="$column.javaField != null#if($column.javaType ==
                        'String' && $column.required) and $column.javaField != ''#end">#{$column.javaField},
                    </if>
#end
#end
         </trim>
@@ -95,23 +121,47 @@
        <trim prefix="SET" suffixOverrides=",">
#foreach($column in $columns)
#if($column.columnName != $pkColumn.columnName)
            <if test="$column.javaField != null#if($column.javaType == 'String' && $column.required) and $column.javaField != ''#end">$column.columnName = #{$column.javaField},</if>
                    <if test="$column.javaField != null#if($column.javaType ==
                        'String' && $column.required) and $column.javaField != ''#end">$column.columnName =
                        #{$column.javaField},
                    </if>
#end
#end
        </trim>
        where ${pkColumn.columnName} = #{${pkColumn.javaField}}
    </update>

    <delete id="delete${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}">
        delete from ${tableName} where ${pkColumn.columnName} = #{${pkColumn.javaField}}
    </delete>
    ##    <delete id="delete${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}">
    ##        delete from ${tableName} where ${pkColumn.columnName} = #{${pkColumn.javaField}}
    ##    </delete>
    <update id="delete${ClassName}By${pkColumn.capJavaField}" parameterType="${pkColumn.javaType}">
        update ${tableName}
        <trim prefix="SET" suffixOverrides=",">
            del_flag =1
        </trim>
        where  ${pkColumn.columnName} = #{${pkColumn.javaField}}
    </update>

    <delete id="delete${ClassName}By${pkColumn.capJavaField}s" parameterType="String">
        delete from ${tableName} where ${pkColumn.columnName} in
    ##    <delete id="delete${ClassName}By${pkColumn.capJavaField}s" parameterType="String">
    ##        delete from ${tableName} where ${pkColumn.columnName} in
    ##        <foreach item="${pkColumn.javaField}" collection="array" open="(" separator="," close=")">
    ##            #{${pkColumn.javaField}}
    ##        </foreach>
    ##    </delete>
    <update id="delete${ClassName}By${pkColumn.capJavaField}s" parameterType="String">
        update  ${tableName}
        <trim prefix="SET" suffixOverrides=",">
            del_flag =1
        </trim>
        where ${pkColumn.columnName} in
        <foreach item="${pkColumn.javaField}" collection="array" open="(" separator="," close=")">
            #{${pkColumn.javaField}}
        </foreach>
    </delete>
    </update>




#if($table.sub)

    <delete id="delete${subClassName}By${subTableFkClassName}s" parameterType="String">
@@ -122,13 +172,17 @@
    </delete>

    <delete id="delete${subClassName}By${subTableFkClassName}" parameterType="${pkColumn.javaType}">
        delete from ${subTableName} where ${subTableFkName} = #{${subTableFkclassName}}
            delete
            from ${subTableName} where ${subTableFkName} = #{${subTableFkclassName}}
    </delete>

    <insert id="batch${subClassName}">
        insert into ${subTableName}(#foreach($column in $subTable.columns) $column.columnName#if($foreach.count != $subTable.columns.size()),#end#end) values
            insert into ${subTableName}
            (#foreach($column in $subTable.columns) $column.columnName#if($foreach.count != $subTable.columns.size())
            ,#end#end) values
        <foreach item="item" index="index" collection="list" separator=",">
            (#foreach($column in $subTable.columns) #{item.$column.javaField}#if($foreach.count != $subTable.columns.size()),#end#end)
                (#foreach($column in $subTable.columns) #{item.$column.javaField
                }#if($foreach.count != $subTable.columns.size()),#end#end)
        </foreach>
    </insert>
#end

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,151 @@
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
 *
 * @author lihu
 * @date 2024-08-05
 */
@Data
@ApiModel("患者手术记录")
public class PatMedOperation extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /**
     * è‡ªå¢žID
     */
    @ApiModelProperty("自增ID")
    private Long id;

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

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

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

    /**
     * æ‰‹æœ¯ä»£ç 
     */
    @ApiModelProperty("手术代码")
    @Excel(name = "手术代码")
    private String operationcode;

    /**
     * æ‰‹æœ¯ID
     */
    @ApiModelProperty("手术ID")
    @Excel(name = "手术ID")
    private Long operationid;

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

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

    /**
     * å°±è¯Šç±»åž‹;1门诊 2住院 3体检
     */
    @ApiModelProperty("就诊类型;1门诊 2住院 3体检")
    @Excel(name = "就诊类型;1门诊 2住院 3体检")
    private Long visittype;

    /**
     * æ‰‹æœ¯çŠ¶æ€;0未开始 1已完成
     */
    @ApiModelProperty("手术状态;0未开始 1已完成")
    @Excel(name = "手术状态;0未开始 1已完成")
    private Long status;

    /**
     * æ–¹æ¡ˆçŠ¶æ€æ“ä½œæ—¶é—´
     */
    @ApiModelProperty("方案状态操作时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "方案状态操作时间" , width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date schemetime;

    /**
     * æ˜¯å¦ç”Ÿæˆè®¡åˆ’;0未生成 1生成手术前 2生成手术后  9无匹配方案
     */
    @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：已删除）
     */
    @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 Long pid;

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

}


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

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

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

/**
 * æ‚£è€…手术记录Mapper接口
 *
 * @author lihu
 * @date 2024-08-05
 */
@Mapper
public interface PatMedOperationMapper
{
    /**
     * æŸ¥è¯¢æ‚£è€…手术记录
     *
     * @param id æ‚£è€…手术记录主键
     * @return æ‚£è€…手术记录
     */
    public PatMedOperation selectPatMedOperationById(Long id);

    /**
     * æŸ¥è¯¢æ‚£è€…手术记录列表
     *
     * @param patMedOperation æ‚£è€…手术记录
     * @return æ‚£è€…手术记录集合
     */
    public List<PatMedOperation> selectPatMedOperationList(PatMedOperation patMedOperation);

    /**
     * æ–°å¢žæ‚£è€…手术记录
     *
     * @param patMedOperation æ‚£è€…手术记录
     * @return ç»“æžœ
     */
    public int insertPatMedOperation(PatMedOperation patMedOperation);

    /**
     * ä¿®æ”¹æ‚£è€…手术记录
     *
     * @param patMedOperation æ‚£è€…手术记录
     * @return ç»“æžœ
     */
    public int updatePatMedOperation(PatMedOperation patMedOperation);

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

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

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

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

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

/**
 * æ‚£è€…手术记录Service接口
 * 
 * @author lihu
 * @date 2024-08-05
 */
public interface IPatMedOperationService 
{
    /**
     * æŸ¥è¯¢æ‚£è€…手术记录
     * 
     * @param id æ‚£è€…手术记录主键
     * @return æ‚£è€…手术记录
     */
    public PatMedOperation selectPatMedOperationById(Long id);

    /**
     * æŸ¥è¯¢æ‚£è€…手术记录列表
     * 
     * @param patMedOperation æ‚£è€…手术记录
     * @return æ‚£è€…手术记录集合
     */
    public List<PatMedOperation> selectPatMedOperationList(PatMedOperation patMedOperation);

    /**
     * æ–°å¢žæ‚£è€…手术记录
     * 
     * @param patMedOperation æ‚£è€…手术记录
     * @return ç»“æžœ
     */
    public int insertPatMedOperation(PatMedOperation patMedOperation);

    /**
     * ä¿®æ”¹æ‚£è€…手术记录
     * 
     * @param patMedOperation æ‚£è€…手术记录
     * @return ç»“æžœ
     */
    public int updatePatMedOperation(PatMedOperation patMedOperation);

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

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

 smartor/src/main/java/com/smartor/service/impl/PatMedOperationServiceImpl.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.PatMedOperationMapper;
import com.smartor.domain.PatMedOperation;
import com.smartor.service.IPatMedOperationService;

/**
 * æ‚£è€…手术记录Service业务层处理
 * 
 * @author lihu
 * @date 2024-08-05
 */
@Service
public class PatMedOperationServiceImpl implements IPatMedOperationService 
{
    @Autowired
    private PatMedOperationMapper patMedOperationMapper;

    /**
     * æŸ¥è¯¢æ‚£è€…手术记录
     * 
     * @param id æ‚£è€…手术记录主键
     * @return æ‚£è€…手术记录
     */
    @Override
    public PatMedOperation selectPatMedOperationById(Long id)
    {
        return patMedOperationMapper.selectPatMedOperationById(id);
    }

    /**
     * æŸ¥è¯¢æ‚£è€…手术记录列表
     * 
     * @param patMedOperation æ‚£è€…手术记录
     * @return æ‚£è€…手术记录
     */
    @Override
    public List<PatMedOperation> selectPatMedOperationList(PatMedOperation patMedOperation)
    {
        return patMedOperationMapper.selectPatMedOperationList(patMedOperation);
    }

    /**
     * æ–°å¢žæ‚£è€…手术记录
     * 
     * @param patMedOperation æ‚£è€…手术记录
     * @return ç»“æžœ
     */
    @Override
    public int insertPatMedOperation(PatMedOperation patMedOperation)
    {
        patMedOperation.setCreateTime(DateUtils.getNowDate());
        return patMedOperationMapper.insertPatMedOperation(patMedOperation);
    }

    /**
     * ä¿®æ”¹æ‚£è€…手术记录
     * 
     * @param patMedOperation æ‚£è€…手术记录
     * @return ç»“æžœ
     */
    @Override
    public int updatePatMedOperation(PatMedOperation patMedOperation)
    {
        patMedOperation.setUpdateTime(DateUtils.getNowDate());
        return patMedOperationMapper.updatePatMedOperation(patMedOperation);
    }

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

    /**
     * åˆ é™¤æ‚£è€…手术记录信息
     * 
     * @param id æ‚£è€…手术记录主键
     * @return ç»“æžœ
     */
    @Override
    public int deletePatMedOperationById(Long id)
    {
        return patMedOperationMapper.deletePatMedOperationById(id);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,153 @@
<?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.PatMedOperationMapper">

    <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="operationcode"    column="operationcode"    />
        <result property="operationid"    column="operationid"    />
        <result property="operationtime"    column="operationtime"    />
        <result property="visitid"    column="visitid"    />
        <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"    />
        <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="pid"    column="pid"    />
        <result property="guid"    column="guid"    />
    </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
    </sql>

    <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>
        </where>
    </select>

    <select id="selectPatMedOperationById" parameterType="Long" resultMap="PatMedOperationResult">
        <include refid="selectPatMedOperationVo"/>
        where id = #{id}
    </select>

    <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>
         </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>
         </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>
        </trim>
        where id = #{id}
    </update>

    <delete id="deletePatMedOperationById" parameterType="Long">
        delete from pat_med_operation where id = #{id}
    </delete>

    <delete id="deletePatMedOperationByIds" parameterType="String">
        delete from pat_med_operation where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>