24,923
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
xibo0925 2017-03-17
- 打赏
- 举报
能具体点吗
xibo0925 2017-03-16
- 打赏
- 举报
具体怎么看验证类型指定没指定
xibo0925 2017-03-16
- 打赏
- 举报
<?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.thinkgem.jeesite.modules.wm.dao.WmBorrowDao">
<sql id="wmBorrowColumns">
a.id AS "id",
a.tool_by AS "toolBy.id",
a.out_date AS "outDate",
a.return_date AS "returnDate",
a.purpose AS "purpose",
a.use_address AS "useAddress",
a.out_user AS "outUser.id",
a.apply_return_user AS "applyReturnUser.id",
a.apply_return_time AS "applyReturnTime",
a.delay_num AS "delayNum",
a.delay_reasion AS "delayReasion",
a.alarm_flag AS "alarmFlag",
a.confirm_user AS "confirmUser.id",
a.create_by AS "createBy.id",
a.create_date AS "createDate",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.del_flag AS "delFlag",
a.confirm_time AS "confirmTime",
a.status AS "status",
u7.name AS "outUser.name",
u8.name AS "applyReturnUser.name",
u13.name AS "confirmUser.name",
u14.name AS "createBy.name",
u16.name AS "updateBy.name",
u17.name AS "toolBy.name"
</sql>
<sql id="wmBorrowJoins">
LEFT JOIN sys_user u7 ON u7.id = a.out_user
LEFT JOIN sys_user u8 ON u8.id = a.apply_return_user
LEFT JOIN sys_user u13 ON u13.id = a.confirm_user
LEFT JOIN sys_user u14 ON u14.id = a.create_by
LEFT JOIN sys_user u16 ON u16.id = a.update_by
LEFT JOIN wm_tool u17 ON u17.id = a.tool_by
</sql>
<select id="get" resultType="WmBorrow">
SELECT
<include refid="wmBorrowColumns"/>
FROM wm_borrow a
<include refid="wmBorrowJoins"/>
WHERE a.id = #{id}
</select>
<select id="findList" resultType="WmBorrow">
SELECT
<include refid="wmBorrowColumns"/>
FROM wm_borrow a
<include refid="wmBorrowJoins"/>
<where>
a.del_flag = #{DEL_FLAG_NORMAL}
<if test="toolBy != null and toolBy != ''">
AND a.tool_by LIKE
<if test="dbName == 'oracle'">'%'||#{toolBy.id}||'%'</if>
<if test="dbName == 'mssql'">'%'+#{toolBy.id}+'%'</if>
<if test="dbName == 'mysql'">concat('%',#{toolBy.id},'%')</if>
</if>
<if test="beginOutDate != null and endOutDate != null and beginOutDate != '' and endOutDate != ''">
AND a.out_date BETWEEN #{beginOutDate} AND #{endOutDate}
</if>
<if test="outUser != null and outUser.id != null and outUser.id != ''">
AND a.out_user = #{outUser.id}
</if>
<if test="alarmFlag != null and alarmFlag != ''">
AND a.alarm_flag = #{alarmFlag}
</if>
</where>
<choose>
<when test="page !=null and page.orderBy != null and page.orderBy != ''">
ORDER BY ${page.orderBy}
</when>
<otherwise>
ORDER BY a.update_date DESC
</otherwise>
</choose>
</select>
<select id="findAllList" resultType="WmBorrow">
SELECT
<include refid="wmBorrowColumns"/>
FROM wm_borrow a
<include refid="wmBorrowJoins"/>
<where>
a.del_flag = #{DEL_FLAG_NORMAL}
</where>
<choose>
<when test="page !=null and page.orderBy != null and page.orderBy != ''">
ORDER BY ${page.orderBy}
</when>
<otherwise>
ORDER BY a.update_date DESC
</otherwise>
</choose>
</select>
<insert id="insert">
INSERT INTO wm_borrow(
id,
tool_by,
out_date,
return_date,
purpose,
use_address,
out_user,
apply_return_user,
apply_return_time,
delay_num,
delay_reasion,
confirm_user,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
confirm_time,
status
) VALUES (
#{id},
#{toolBy.id},
#{outDate},
#{returnDate},
#{purpose},
#{useAddress},
#{outUser.id},
#{applyReturnUser.id},
#{applyReturnTime},
#{delayNum},
#{delayReasion},
#{confirmUser.id},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{confirmTime},
#{status}
)
</insert>
<update id="update">
UPDATE wm_borrow SET
tool_by = #{toolBy.id},
out_date = #{outDate},
return_date = #{returnDate},
purpose = #{purpose},
use_address = #{useAddress},
out_user = #{outUser.id},
apply_return_user = #{applyReturnUser.id},
apply_return_time = #{applyReturnTime},
delay_num = #{delayNum},
delay_reasion = #{delayReasion},
confirm_user = #{confirmUser.id},
create_by = #{createBy.id},
create_date = #{createDate},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
confirm_time = #{confirmTime},
status = #{status}
WHERE id = #{id}
</update>
<update id="delete">
UPDATE wm_borrow SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
</update>
</mapper>
设计师Linda 2017-03-15
- 打赏
- 举报
看看是不是验证类型没指定
设计师Linda 2017-03-15
- 打赏
- 举报
toolBy的配置文件
xibo0925 2017-03-15
- 打赏
- 举报
这个问题 我要添加数据 最后点保存后出现的 ，
之前的问题是 我的字段名本来是toolId 后来改成了toolBy 能该的地方我都改了
就是不知道还掉了哪里 后台没有报错 请大家看看 可能问题出在大约什么地方我可以找找
