湖北水库：设备管理添加价格排序

shenyijian

2024-09-29 c036f64ea6f544ffeb7506325b04f5d4ec5d24b6

湖北水库：设备管理添加价格排序

 skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DO/SgDeviceDO.java

@@ -107,4 +107,9 @@

    private Integer status;

    /**
     * 价格
     */
    private String price;

}

 skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DO/SgProjectInfoDO.java

@@ -226,5 +226,10 @@
    private int seepageNum;
    private String seepageProgress;

    /**
     * 水库注册码
     */
    private String othRegCd;


}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgDeviceMapper.xml

@@ -17,6 +17,7 @@
        <if test="dto.deviceType != null and dto.deviceType != ''">
            and ds.device_type = #{dto.deviceType}
        </if>
        order by TO_NUMBER (ds.price) asc NULLS LAST
    </select>
    <select id="getSgDeviceById" resultType="cn.gistack.sm.sg.DO.SgDeviceDO">
        select ds.*,project.project_name as programName,dict."DICT_VALUE" as typeName from YWXT."SG_DEVICE" as ds left join YWXT."SG_PROJECT_INFO"  as project  on ds.program_id=project.id

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml

@@ -9,7 +9,8 @@
        dria."county_nm",
        dria."town_nm",
        dria."eng_scal",
        dria."bas_guid"
        dria."bas_guid",
        dria."oth_reg_cd"
        FROM
        YWXT.SG_PROJECT_INFO info
        LEFT JOIN SJZT_DW."dim_res_info_a" dria ON dria."res_cd" = info.sk_id