| | |
| | | <result property="createTime" column="create_time" /> |
| | | <result property="updateBy" column="update_by" /> |
| | | <result property="updateTime" column="update_time" /> |
| | | <result property="orgCode" column="org_code" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectApsGasPipelineCapacityPlanVo"> |
| | | select id, process_name, year, month, major, day_produce_type, day_produce_num, day_produce_unit, personnel_number, day_produce_all_num, days, month_produce_all_num, remark, create_by, create_time, update_by, update_time from aps_gas_pipeline_capacity_plan |
| | | select id, process_name, year, month, major, day_produce_type, day_produce_num, day_produce_unit, personnel_number, day_produce_all_num, days, month_produce_all_num, remark, create_by, create_time, update_by, update_time, org_code from aps_gas_pipeline_capacity_plan |
| | | </sql> |
| | | |
| | | <select id="selectApsGasPipelineCapacityPlanList" parameterType="ApsGasPipelineCapacityPlan" resultMap="ApsGasPipelineCapacityPlanResult"> |
| | |
| | | <if test="dayProduceAllNum != null "> and day_produce_all_num = #{dayProduceAllNum}</if> |
| | | <if test="days != null "> and days = #{days}</if> |
| | | <if test="monthProduceAllNum != null "> and month_produce_all_num = #{monthProduceAllNum}</if> |
| | | <if test="orgCode != null "> and org_code = #{orgCode}</if> |
| | | <!-- <if test="major != null and major != ''">--> |
| | | <!-- and process_name in (select process_name from aps_standard_process where major=#{major})--> |
| | | <!-- </if>--> |
| | |
| | | <if test="createTime != null">create_time,</if> |
| | | <if test="updateBy != null">update_by,</if> |
| | | <if test="updateTime != null">update_time,</if> |
| | | <if test="orgCode != null">org_code,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">#{id},</if> |
| | |
| | | <if test="createTime != null">#{createTime},</if> |
| | | <if test="updateBy != null">#{updateBy},</if> |
| | | <if test="updateTime != null">#{updateTime},</if> |
| | | <if test="orgCode != null">#{orgCode},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | |
| | | <if test="createTime != null">create_time = #{createTime},</if> |
| | | <if test="updateBy != null">update_by = #{updateBy},</if> |
| | | <if test="updateTime != null">update_time = #{updateTime},</if> |
| | | <if test="orgCode != null">org_code = #{orgCode},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |