代码提交

liusheng

2025-02-26 7f8b679d1643c546bb061882f99668d9639d56cc

代码提交

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/BaseDictOperationController.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.BaseDictOperation;
import com.smartor.service.IBaseDictOperationService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * æ‰‹æœ¯åŸºç¡€ä¿¡æ¯Controller
 *
 * @author lihu
 * @date 2025-02-26
 */
@Api("手术基础信息")
@RestController
@RequestMapping("/smartor/baseopera")
public class BaseDictOperationController extends BaseController
{
    @Autowired
    private IBaseDictOperationService baseDictOperationService;

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

    /**
     * å¯¼å‡ºæ‚£è€…检查检验记录子列表
     */
    @ApiOperation("导出患者检查检验记录子列表")
    //@PreAuthorize("@ss.hasPermi('smartor:operation:export')")
    @Log(title = "患者检查检验记录子", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, BaseDictOperation baseDictOperation)
    {
        List<BaseDictOperation> list = baseDictOperationService.selectBaseDictOperationList(baseDictOperation);
        ExcelUtil<BaseDictOperation> util = new ExcelUtil<BaseDictOperation>(BaseDictOperation.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(baseDictOperationService.selectBaseDictOperationById(id));
    }

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

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

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

 ruoyi-admin/src/main/resources/application-druid.yml

@@ -13,10 +13,10 @@
        #        å…¬å¸
        #        url: jdbc:mysql://192.168.2.9:3308/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        #        ä¸½æ°´
        url: jdbc:mysql://127.0.0.1:3308/smartor-lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: smartor
        password: Smartor.2023
        driverClassName: com.mysql.cj.jdbc.Driver
#        url: jdbc:mysql://127.0.0.1:3308/smartor-lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
      #        username: smartor
      #        password: Smartor.2023
      #        driverClassName: com.mysql.cj.jdbc.Driver
        # æ–°åŽ
#        url: jdbc:mysql://192.168.191.181:3308/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        #        username: smartor
@@ -24,10 +24,10 @@
        #        driverClassName: com.mysql.cj.jdbc.Driver

        #        å…¬å¸äº‘
#        url: jdbc:mysql://116.62.18.175:6002/smartor_lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
#        username: hxsoft
#        password: Hxerp2000
#        driverClassName: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://116.62.18.175:6002/smartor_lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: hxsoft
        password: Hxerp2000
        driverClassName: com.mysql.cj.jdbc.Driver

      # ä»Žåº“数据源
      slave:

 smartor/smartor.iml

@@ -32,7 +32,6 @@
    <orderEntry type="library" name="Maven: com.aliyun:tea:1.2.0" level="project" />
    <orderEntry type="library" name="Maven: com.aliyun:tea-rpc-util:0.1.2" level="project" />
    <orderEntry type="library" name="Maven: dom4j:dom4j:1.6.1" level="project" />
    <orderEntry type="library" name="Maven: xml-apis:xml-apis:1.0.b2" level="project" />
    <orderEntry type="library" name="Maven: com.sun.xml.bind:jaxb-core:2.3.0" level="project" />
    <orderEntry type="library" name="Maven: com.sun.xml.bind:jaxb-impl:2.3.0" level="project" />
    <orderEntry type="library" name="Maven: com.aliyun:tea-openapi:0.2.8" level="project" />

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,105 @@
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;

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

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

    /** his手术id */
    @ApiModelProperty("his手术id")
            @Excel(name = "his手术id")
    private Long opid;

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

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

    /** åˆ‡å£ç±»åˆ«ä»£ç  */
    @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/BaseDictOperationMapper.java

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 smartor/src/main/java/com/smartor/service/impl/BaseDictOperationServiceImpl.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.BaseDictOperationMapper;
import com.smartor.domain.BaseDictOperation;
import com.smartor.service.IBaseDictOperationService;

/**
 * æ‚£è€…检查检验记录子Service业务层处理
 * 
 * @author lihu
 * @date 2025-02-26
 */
@Service
public class BaseDictOperationServiceImpl implements IBaseDictOperationService 
{
    @Autowired
    private BaseDictOperationMapper baseDictOperationMapper;

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

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

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

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

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

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

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

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

    <resultMap type="com.smartor.domain.BaseDictOperation" id="BaseDictOperationResult">
            <result property="id" column="id"/>
            <result property="opid" column="opid"/>
            <result property="opcode" column="opcode"/>
            <result property="opdesc" column="opdesc"/>
            <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="selectBaseDictOperationVo">
        select id, opid, opcode, opdesc, incitypecode, incitypedesc, oplevelcode, opleveldesc, opposition, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pguid, guid, pid
        from base_dict_operation
    </sql>

    <select id="selectBaseDictOperationList" parameterType="com.smartor.domain.BaseDictOperation"
            resultMap="BaseDictOperationResult">
        <include refid="selectBaseDictOperationVo"/>
        <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="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="selectBaseDictOperationById" parameterType="Long"
            resultMap="BaseDictOperationResult">
            <include refid="selectBaseDictOperationVo"/>
            where id = #{id}
    </select>

    <insert id="insertBaseDictOperation" parameterType="com.smartor.domain.BaseDictOperation">
        insert into base_dict_operation
        <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="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="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="updateBaseDictOperation" parameterType="com.smartor.domain.BaseDictOperation">
        update base_dict_operation
        <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="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="deleteBaseDictOperationById" parameterType="Long">
        update base_dict_operation
        <trim prefix="SET" suffixOverrides=",">
            del_flag =1
        </trim>
        where  id = #{id}
    </update>

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




</mapper>