| | |
| | | <if test="zc.type != null and zc.type != '' "> |
| | | and type like CONCAT('%',#{zc.type},'%') |
| | | </if> |
| | | <if test="zc.cardid != null and zc.cardid != '' "> |
| | | and cardid like CONCAT('%',#{zc.cardid},'%') |
| | | </if> |
| | | and type != 1 |
| | | </select> |
| | | |
| | | |
| | | <!--注册新增--> |
| | | <insert id="inster"> |
| | | insert into act_zc(username,password,sname,sex,phone,zctime,deptid,parent_id,jurisdiction) values(#{username},#{password},#{sname},#{sex},#{phone},#{zctime},#{deptid},#{parentId},#{jurisdiction}) |
| | | insert into act_zc(username,password,sname,sex,phone,zctime,deptid,parent_id,jurisdiction,cardid) values(#{username},#{password},#{sname},#{sex},#{phone},#{zctime},#{deptid},#{parentId},#{jurisdiction},#{cardid}) |
| | | </insert> |
| | | |
| | | <select id="selectType" resultType="String"> |