修改农户查询接口返回驼峰命名,修改农户修改SQL语句
| | |
| | | private String villageName; |
| | | |
| | | @Schema(title = "片区ID") |
| | | private String blockid; |
| | | private String blockId; |
| | | @Schema(title = "片区名称") |
| | | private String bolckName; |
| | | private String blockName; |
| | | |
| | | @Schema(title = "分水房ID") |
| | | private String divideId; |
| | |
| | | private String phone; |
| | | |
| | | @Schema(title = "身份证号") |
| | | private String idcard; |
| | | private String idCard; |
| | | |
| | | @Schema(title = "种植面积") |
| | | private Double area; |
| | |
| | | address = #{address,jdbcType=VARCHAR}, |
| | | remarks = #{remarks,jdbcType=VARCHAR}, |
| | | `operator` = #{operator,jdbcType=BIGINT}, |
| | | operateDt = #{operatedt,jdbcType=TIMESTAMP}, |
| | | operateDt = #{operatedt,jdbcType=TIMESTAMP} |
| | | <!-- disabled = #{disabled,jdbcType=TINYINT},--> |
| | | <!-- deleted = #{deleted,jdbcType=TINYINT}--> |
| | | where id = #{id,jdbcType=BIGINT} |
| | |
| | | CAST(cli.villageId AS char) AS villageId, |
| | | dis_village.name AS villageName, |
| | | CAST(cli.blockId AS char) AS blockId, |
| | | blo.name AS bolckName, |
| | | blo.name AS blockName, |
| | | CAST(cli.divideId AS char) AS divideId, |
| | | divi.name AS divideName, |
| | | CAST(cli.typeId AS char) AS waterTypeId, |