kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/BusinessRecordsMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.BusinessRecordsMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.BusinessRecordsMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,60 +11,60 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="id != null and id !=''"> and id = #{id} p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="recordTitle != null and recordTitle !=''"> and record_title = #{recordTitle} <if test="p.recordTitle != null and p.recordTitle !=''"> and record_title = #{p.recordTitle} </if> <if test="userId != null and userId !=''"> and user_id = #{userId} <if test="p.userId != null and p.userId !=''"> and user_id = #{p.userId} </if> <if test="userName != null and userName !=''"> and user_name = #{userName} <if test="p.userName != null and p.userName !=''"> and user_name = #{p.userName} </if> <if test="appId != null and appId !=''"> and app_id = #{appId} <if test="p.appId != null and p.appId !=''"> and app_id = #{p.appId} </if> <if test="appName != null and appName !=''"> and app_name = #{appName} <if test="p.appName != null and p.appName !=''"> and app_name = #{p.appName} </if> <if test="recordIp != null and recordIp !=''"> and record_ip = #{recordIp} <if test="p.recordIp != null and p.recordIp !=''"> and record_ip = #{p.recordIp} </if> <if test="recordDetail != null and recordDetail !=''"> and record_detail = #{recordDetail} <if test="p.recordDetail != null and p.recordDetail !=''"> and record_detail = #{p.recordDetail} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> </where> </sql> <!--定义根据-BusinessRecords当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.BusinessRecords"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.BusinessRecords"> select <include refid="Column_List"/> from business_records <include refid="where"/> @@ -72,7 +72,7 @@ </select> <!--定义根据-BusinessRecords当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.BusinessRecords"> <select id="findList" resultType="com.kidgrow.usercenter.model.BusinessRecords"> select <include refid="Column_List"/> from business_records order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/BusinessServerMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.BusinessServerMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.BusinessServerMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,54 +11,54 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="departmentId != null and departmentId !=''"> and department_id = #{departmentId} p.is_del=0 <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} </if> <if test="doctorCount != null and doctorCount !=''"> and doctor_count = #{doctorCount} <if test="p.doctorCount != null and p.doctorCount !=''"> and doctor_count = #{p.doctorCount} </if> <if test="serverEndDate != null and serverEndDate !=''"> and server_end_date = #{serverEndDate} <if test="p.serverEndDate != null and p.serverEndDate !=''"> and server_end_date = #{p.serverEndDate} </if> <if test="totalRayCount != null and totalRayCount !=''"> and total_ray_count = #{totalRayCount} <if test="p.totalRayCount != null and p.totalRayCount !=''"> and total_ray_count = #{p.totalRayCount} </if> <if test="totalRecordCount != null and totalRecordCount !=''"> and total_record_count = #{totalRecordCount} <if test="p.totalRecordCount != null and p.totalRecordCount !=''"> and total_record_count = #{p.totalRecordCount} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="tenantId != null and tenantId !=''"> and tenant_id = #{tenantId} <if test="p.tenantId != null and p.tenantId !=''"> and tenant_id = #{p.tenantId} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </sql> <!--定义根据-BusinessServer当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.BusinessServer"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.BusinessServer"> select <include refid="Column_List"/> from business_server <include refid="where"/> @@ -66,7 +66,7 @@ </select> <!--定义根据-BusinessServer当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.BusinessServer"> <select id="findList" resultType="com.kidgrow.usercenter.model.BusinessServer"> select <include refid="Column_List"/> from business_server order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/DataNeedMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.DataNeedMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.DataNeedMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,72 +11,72 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="id != null and id !=''"> and id = #{id} p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="needType != null and needType !=''"> and need_type = #{needType} <if test="p.needType != null and p.needType !=''"> and need_type = #{p.needType} </if> <if test="doctorId != null and doctorId !=''"> and doctor_id = #{doctorId} <if test="p.doctorId != null and p.doctorId !=''"> and doctor_id = #{p.doctorId} </if> <if test="doctorName != null and doctorName !=''"> and doctor_name = #{doctorName} <if test="p.doctorName != null and p.doctorName !=''"> and doctor_name = #{p.doctorName} </if> <if test="hospitalName != null and hospitalName !=''"> and hospital_name = #{hospitalName} <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} </if> <if test="departmentName != null and departmentName !=''"> and department_name = #{departmentName} <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} </if> <if test="doctorTel != null and doctorTel !=''"> and doctor_tel = #{doctorTel} <if test="p.doctorTel != null and p.doctorTel !=''"> and doctor_tel = #{p.doctorTel} </if> <if test="needBegintime != null and needBegintime !=''"> and need_begintime = #{needBegintime} <if test="p.needBegintime != null and p.needBegintime !=''"> and need_begintime = #{p.needBegintime} </if> <if test="needEndtime != null and needEndtime !=''"> and need_endtime = #{needEndtime} <if test="p.needEndtime != null and p.needEndtime !=''"> and need_endtime = #{p.needEndtime} </if> <if test="needTags != null and needTags !=''"> and need_tags = #{needTags} <if test="p.needTags != null and p.needTags !=''"> and need_tags = #{p.needTags} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="dataFile != null and dataFile !=''"> and data_file = #{dataFile} <if test="p.dataFile != null and p.dataFile !=''"> and data_file = #{p.dataFile} </if> <if test="downTime != null and downTime !=''"> and down_time = #{downTime} <if test="p.downTime != null and p.downTime !=''"> and down_time = #{p.downTime} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> </where> </sql> <!--定义根据-DataNeed当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DataNeed"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.DataNeed"> select <include refid="Column_List"/> from data_need <include refid="where"/> @@ -84,7 +84,7 @@ </select> <!--定义根据-DataNeed当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.DataNeed"> <select id="findList" resultType="com.kidgrow.usercenter.model.DataNeed"> select <include refid="Column_List"/> from data_need order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/DoctorAnswerMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.DoctorAnswerMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.DoctorAnswerMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,36 +11,36 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="createTime != null and createTime !=''"> and create_time = #{createTime} p.is_del=0 <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </sql> <!--定义根据-DoctorAnswer当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorAnswer"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.DoctorAnswer"> select <include refid="Column_List"/> from doctor_answer <include refid="where"/> @@ -48,7 +48,7 @@ </select> <!--定义根据-DoctorAnswer当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.DoctorAnswer"> <select id="findList" resultType="com.kidgrow.usercenter.model.DoctorAnswer"> select <include refid="Column_List"/> from doctor_answer order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/DoctorServerMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.DoctorServerMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.DoctorServerMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,45 +11,45 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="isAnswer != null and isAnswer !=''"> and is_answer = #{isAnswer} p.is_del=0 <if test="p.isAnswer != null and p.isAnswer !=''"> and is_answer = #{p.isAnswer} </if> <if test="isSigning != null and isSigning !=''"> and is_signing = #{isSigning} <if test="p.isSigning != null and p.isSigning !=''"> and is_signing = #{p.isSigning} </if> <if test="doctorState != null and doctorState !=''"> and doctor_state = #{doctorState} <if test="p.doctorState != null and p.doctorState !=''"> and doctor_state = #{p.doctorState} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </sql> <!--定义根据-DoctorServer当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorServer"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.DoctorServer"> select <include refid="Column_List"/> from doctor_server <include refid="where"/> @@ -57,7 +57,7 @@ </select> <!--定义根据-DoctorServer当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.DoctorServer"> <select id="findList" resultType="com.kidgrow.usercenter.model.DoctorServer"> select <include refid="Column_List"/> from doctor_server order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/DoctorSigningMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.DoctorSigningMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.DoctorSigningMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,36 +11,36 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="createTime != null and createTime !=''"> and create_time = #{createTime} p.is_del=0 <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </sql> <!--定义根据-DoctorSigning当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorSigning"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.DoctorSigning"> select <include refid="Column_List"/> from doctor_signing <include refid="where"/> @@ -48,7 +48,7 @@ </select> <!--定义根据-DoctorSigning当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.DoctorSigning"> <select id="findList" resultType="com.kidgrow.usercenter.model.DoctorSigning"> select <include refid="Column_List"/> from doctor_signing order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/DoctorTempleteMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.DoctorTempleteMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.DoctorTempleteMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,69 +11,69 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="id != null and id !=''"> and id = #{id} p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="hospitalId != null and hospitalId !=''"> and hospital_id = #{hospitalId} <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} </if> <if test="hospitalName != null and hospitalName !=''"> and hospital_name = #{hospitalName} <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} </if> <if test="departmentId != null and departmentId !=''"> and department_id = #{departmentId} <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} </if> <if test="departmentName != null and departmentName !=''"> and department_name = #{departmentName} <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} </if> <if test="doctorId != null and doctorId !=''"> and doctor_id = #{doctorId} <if test="p.doctorId != null and p.doctorId !=''"> and doctor_id = #{p.doctorId} </if> <if test="doctorName != null and doctorName !=''"> and doctor_name = #{doctorName} <if test="p.doctorName != null and p.doctorName !=''"> and doctor_name = #{p.doctorName} </if> <if test="publicType != null and publicType !=''"> and public_type = #{publicType} <if test="p.publicType != null and p.publicType !=''"> and public_type = #{p.publicType} </if> <if test="templeteType != null and templeteType !=''"> and templete_type = #{templeteType} <if test="p.templeteType != null and p.templeteType !=''"> and templete_type = #{p.templeteType} </if> <if test="templeteTitle != null and templeteTitle !=''"> and templete_title = #{templeteTitle} <if test="p.templeteTitle != null and p.templeteTitle !=''"> and templete_title = #{p.templeteTitle} </if> <if test="templeteNote != null and templeteNote !=''"> and templete_note = #{templeteNote} <if test="p.templeteNote != null and p.templeteNote !=''"> and templete_note = #{p.templeteNote} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> </where> </sql> <!--定义根据-DoctorTemplete当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorTemplete"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.DoctorTemplete"> select <include refid="Column_List"/> from doctor_templete <include refid="where"/> @@ -81,7 +81,7 @@ </select> <!--定义根据-DoctorTemplete当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.DoctorTemplete"> <select id="findList" resultType="com.kidgrow.usercenter.model.DoctorTemplete"> select <include refid="Column_List"/> from doctor_templete order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/HospitalScreeningMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.HospitalScreeningMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.HospitalScreeningMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,51 +11,51 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="hospitalId != null and hospitalId !=''"> and hospital_id = #{hospitalId} p.is_del=0 <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} </if> <if test="hospitalName != null and hospitalName !=''"> and hospital_name = #{hospitalName} <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} </if> <if test="hospitalLogo != null and hospitalLogo !=''"> and hospital_logo = #{hospitalLogo} <if test="p.hospitalLogo != null and p.hospitalLogo !=''"> and hospital_logo = #{p.hospitalLogo} </if> <if test="hospitalQrImage != null and hospitalQrImage !=''"> and hospital_qr_image = #{hospitalQrImage} <if test="p.hospitalQrImage != null and p.hospitalQrImage !=''"> and hospital_qr_image = #{p.hospitalQrImage} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="tenantId != null and tenantId !=''"> and tenant_id = #{tenantId} <if test="p.tenantId != null and p.tenantId !=''"> and tenant_id = #{p.tenantId} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </sql> <!--定义根据-HospitalScreening当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.HospitalScreening"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.HospitalScreening"> select <include refid="Column_List"/> from hospital_screening <include refid="where"/> @@ -63,7 +63,7 @@ </select> <!--定义根据-HospitalScreening当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.HospitalScreening"> <select id="findList" resultType="com.kidgrow.usercenter.model.HospitalScreening"> select <include refid="Column_List"/> from hospital_screening order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/ProductOrderDetailMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.ProductOrderDetailMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.ProductOrderDetailMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,63 +11,63 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="id != null and id !=''"> and id = #{id} p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="orderId != null and orderId !=''"> and order_id = #{orderId} <if test="p.orderId != null and p.orderId !=''"> and order_id = #{p.orderId} </if> <if test="proId != null and proId !=''"> and pro_id = #{proId} <if test="p.proId != null and p.proId !=''"> and pro_id = #{p.proId} </if> <if test="proName != null and proName !=''"> and pro_name = #{proName} <if test="p.proName != null and p.proName !=''"> and pro_name = #{p.proName} </if> <if test="isShare != null and isShare !=''"> and is_share = #{isShare} <if test="p.isShare != null and p.isShare !=''"> and is_share = #{p.isShare} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="ailightCount != null and ailightCount !=''"> and ailight_count = #{ailightCount} <if test="p.ailightCount != null and p.ailightCount !=''"> and ailight_count = #{p.ailightCount} </if> <if test="recordCount != null and recordCount !=''"> and record_count = #{recordCount} <if test="p.recordCount != null and p.recordCount !=''"> and record_count = #{p.recordCount} </if> <if test="proBegintime != null and proBegintime !=''"> and pro_begintime = #{proBegintime} <if test="p.proBegintime != null and p.proBegintime !=''"> and pro_begintime = #{p.proBegintime} </if> <if test="proEndtime != null and proEndtime !=''"> and pro_endtime = #{proEndtime} <if test="p.proEndtime != null and p.proEndtime !=''"> and pro_endtime = #{p.proEndtime} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> </where> </sql> <!--定义根据-ProductOrderDetail当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.ProductOrderDetail"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.ProductOrderDetail"> select <include refid="Column_List"/> from product_order_detail <include refid="where"/> @@ -75,7 +75,7 @@ </select> <!--定义根据-ProductOrderDetail当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.ProductOrderDetail"> <select id="findList" resultType="com.kidgrow.usercenter.model.ProductOrderDetail"> select <include refid="Column_List"/> from product_order_detail order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/ProductOrderMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.ProductOrderMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.ProductOrderMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,66 +11,66 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="id != null and id !=''"> and id = #{id} p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="hospitalId != null and hospitalId !=''"> and hospital_id = #{hospitalId} <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} </if> <if test="hospitalName != null and hospitalName !=''"> and hospital_name = #{hospitalName} <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} </if> <if test="departmentId != null and departmentId !=''"> and department_id = #{departmentId} <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} </if> <if test="departmentName != null and departmentName !=''"> and department_name = #{departmentName} <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} </if> <if test="contractNo != null and contractNo !=''"> and contract_no = #{contractNo} <if test="p.contractNo != null and p.contractNo !=''"> and contract_no = #{p.contractNo} </if> <if test="contractTitle != null and contractTitle !=''"> and contract_title = #{contractTitle} <if test="p.contractTitle != null and p.contractTitle !=''"> and contract_title = #{p.contractTitle} </if> <if test="contractBeginTime != null and contractBeginTime !=''"> and contract_begin_time = #{contractBeginTime} <if test="p.contractBeginTime != null and p.contractBeginTime !=''"> and contract_begin_time = #{p.contractBeginTime} </if> <if test="contractEndTime != null and contractEndTime !=''"> and contract_end_time = #{contractEndTime} <if test="p.contractEndTime != null and p.contractEndTime !=''"> and contract_end_time = #{p.contractEndTime} </if> <if test="contractTime != null and contractTime !=''"> and contract_time = #{contractTime} <if test="p.contractTime != null and p.contractTime !=''"> and contract_time = #{p.contractTime} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> </where> </sql> <!--定义根据-ProductOrder当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.ProductOrder"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.ProductOrder"> select <include refid="Column_List"/> from product_order <include refid="where"/> @@ -78,7 +78,7 @@ </select> <!--定义根据-ProductOrder当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.ProductOrder"> <select id="findList" resultType="com.kidgrow.usercenter.model.ProductOrder"> select <include refid="Column_List"/> from product_order order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/SysFeedbackMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.SysFeedbackMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.SysFeedbackMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,63 +11,63 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="id != null and id !=''"> and id = #{id} p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="doctorId != null and doctorId !=''"> and doctor_id = #{doctorId} <if test="p.doctorId != null and p.doctorId !=''"> and doctor_id = #{p.doctorId} </if> <if test="doctorName != null and doctorName !=''"> and doctor_name = #{doctorName} <if test="p.doctorName != null and p.doctorName !=''"> and doctor_name = #{p.doctorName} </if> <if test="doctorTel != null and doctorTel !=''"> and doctor_tel = #{doctorTel} <if test="p.doctorTel != null and p.doctorTel !=''"> and doctor_tel = #{p.doctorTel} </if> <if test="departmentId != null and departmentId !=''"> and department_id = #{departmentId} <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} </if> <if test="departmentName != null and departmentName !=''"> and department_name = #{departmentName} <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} </if> <if test="hospitalId != null and hospitalId !=''"> and hospital_id = #{hospitalId} <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} </if> <if test="hospitalName != null and hospitalName !=''"> and hospital_name = #{hospitalName} <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} </if> <if test="feedbackNote != null and feedbackNote !=''"> and feedback_note = #{feedbackNote} <if test="p.feedbackNote != null and p.feedbackNote !=''"> and feedback_note = #{p.feedbackNote} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> </where> </sql> <!--定义根据-SysFeedback当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.SysFeedback"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.SysFeedback"> select <include refid="Column_List"/> from sys_feedback <include refid="where"/> @@ -75,7 +75,7 @@ </select> <!--定义根据-SysFeedback当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.SysFeedback"> <select id="findList" resultType="com.kidgrow.usercenter.model.SysFeedback"> select <include refid="Column_List"/> from sys_feedback order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/SysLoggerMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.SysLoggerMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.SysLoggerMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,36 +11,36 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="applicationName != null and applicationName !=''"> and application_name = #{applicationName} p.is_del=0 <if test="p.applicationName != null and p.applicationName !=''"> and application_name = #{p.applicationName} </if> <if test="className != null and className !=''"> and class_name = #{className} <if test="p.className != null and p.className !=''"> and class_name = #{p.className} </if> <if test="methodName != null and methodName !=''"> and method_name = #{methodName} <if test="p.methodName != null and p.methodName !=''"> and method_name = #{p.methodName} </if> <if test="userId != null and userId !=''"> and user_id = #{userId} <if test="p.userId != null and p.userId !=''"> and user_id = #{p.userId} </if> <if test="userName != null and userName !=''"> and user_name = #{userName} <if test="p.userName != null and p.userName !=''"> and user_name = #{p.userName} </if> <if test="clientId != null and clientId !=''"> and client_id = #{clientId} <if test="p.clientId != null and p.clientId !=''"> and client_id = #{p.clientId} </if> <if test="operation != null and operation !=''"> and operation = #{operation} <if test="p.operation != null and p.operation !=''"> and operation = #{p.operation} </if> <if test="timestamp != null and timestamp !=''"> and timestamp = #{timestamp} <if test="p.timestamp != null and p.timestamp !=''"> and timestamp = #{p.timestamp} </if> </where> </sql> <!--定义根据-SysLogger当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.SysLogger"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.SysLogger"> select <include refid="Column_List"/> from sys_logger <include refid="where"/> @@ -48,7 +48,7 @@ </select> <!--定义根据-SysLogger当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.SysLogger"> <select id="findList" resultType="com.kidgrow.usercenter.model.SysLogger"> select <include refid="Column_List"/> from sys_logger order by id desc kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/SysProductMapper.xml
@@ -1,7 +1,7 @@ <?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.kidgrow.oprationcenter.mapper.SysProductMapper"> <mapper namespace="com.kidgrow.usercenter.mapper.SysProductMapper"> <!--定义查询列--> <sql id="Column_List"> * @@ -11,57 +11,57 @@ <sql id="where"> <where> <!--查询条件自行添加--> is_del=0 <if test="id != null and id !=''"> and id = #{id} p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="proName != null and proName !=''"> and pro_name = #{proName} <if test="p.proName != null and p.proName !=''"> and pro_name = #{p.proName} </if> <if test="proTime != null and proTime !=''"> and pro_time = #{proTime} <if test="p.proTime != null and p.proTime !=''"> and pro_time = #{p.proTime} </if> <if test="proType != null and proType !=''"> and pro_type = #{proType} <if test="p.proType != null and p.proType !=''"> and pro_type = #{p.proType} </if> <if test="proPrice != null and proPrice !=''"> and pro_price = #{proPrice} <if test="p.proPrice != null and p.proPrice !=''"> and pro_price = #{p.proPrice} </if> <if test="recordCount != null and recordCount !=''"> and record_count = #{recordCount} <if test="p.recordCount != null and p.recordCount !=''"> and record_count = #{p.recordCount} </if> <if test="ailightCount != null and ailightCount !=''"> and ailight_count = #{ailightCount} <if test="p.ailightCount != null and p.ailightCount !=''"> and ailight_count = #{p.ailightCount} </if> <if test="isDel != null and isDel !=''"> and is_del = #{isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="enabled != null and enabled !=''"> and enabled = #{enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="createUserId != null and createUserId !=''"> and create_user_id = #{createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="createUserName != null and createUserName !=''"> and create_user_name = #{createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="updateUserId != null and updateUserId !=''"> and update_user_id = #{updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="updateUserName != null and updateUserName !=''"> and update_user_name = #{updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="createTime != null and createTime !=''"> and create_time = #{createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="updateTime != null and updateTime !=''"> and update_time = #{updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> </where> </sql> <!--定义根据-SysProduct当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.SysProduct"> <select id="findByObject" resultType="com.kidgrow.usercenter.model.SysProduct"> select <include refid="Column_List"/> from sys_product <include refid="where"/> @@ -69,7 +69,7 @@ </select> <!--定义根据-SysProduct当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.SysProduct"> <select id="findList" resultType="com.kidgrow.usercenter.model.SysProduct"> select <include refid="Column_List"/> from sys_product order by id desc