项目管理sql修改

xieb

2024-06-07 9a2eb9aaca17fca4ee501b157ad6e4cd48046453

项目管理sql修改

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbProjectMapper.xml

@@ -67,7 +67,7 @@
        <if test="vo.endTime!=null and vo.endTime!=''">
            and tb."check_date" &lt;= #{vo.endTime}
        </if>
        order by guid,city_code,county_code asc
        order by CAST(city_code AS number) asc,CAST(county_code AS number) asc,CAST(guid AS number) desc
    </select>

    <resultMap id="dto" type="cn.gistack.sm.sjztmd.dto.TbProjectDTO">