<?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.dxhy.core.job.dao.ScheduleJobDao">

    <!-- 批量更新状态 -->
    <update id="updateBatch">
        update schedule_job

        set status= #{status},
            job_status = '0'
        where job_id = #{jobId}
    </update>

    <!--<select id="getUserApplyKey" resultType="java.util.Map" databaseId="mysql">
        SELECT dept.ace_id  aceId,
               dept.ace_key aceKey,
               dept.taxno   taxno
        FROM sys_dept dept,
             sys_user us,
             sys_user_org uOrg
        WHERE uOrg.dept_id = dept.dept_id
          and uOrg.userid = us.user_id
          and us.loginname = #{loginname}
          and dept.org_type = '5' limit 1
    </select>

    <select id="getUserApplyKey" resultType="java.util.Map" databaseId="oracle">
        SELECT dept.ace_id  aceId,
               dept.ace_key aceKey,
               dept.taxno   taxno
        FROM sys_dept dept,
             sys_user us,
             sys_user_org uOrg
        WHERE uOrg.dept_id = dept.dept_id
          and uOrg.userid = us.user_id
          and us.loginname = #{loginname}
          and dept.org_type = '5'
          and rownum = 1
    </select>-->


</mapper>
