jeesite调用框架自带的省市区(行政区)

16 篇文章 1 订阅

前端form页面代码:

<div class="col-xs-6">
						<div class="form-group">
							<label class="control-label col-sm-4" title="">
								<span class="required hide">*</span> ${text('户籍地区县')}:<i class="fa icon-question hide"></i></label>
							<div class="col-sm-8">
								<#form:treeselect id="area" title="${text('区域选择')}"
									path="censusRegion" labelName="area.areaName" labelValue="${pyNarcotics.area.treeNames!}"
									url="${ctx}/sys/area/treeData" returnFullName="true"
									class=" " allowClear="true" canSelectRoot="true" canSelectParent="true" readonly="false"/>
							</div>
						</div>
					</div>

实体类:

@Table(name="py_narcotics", alias="a", columns={
		@Column(name="narc_id", attrName="narcId", label="narc_id", isPK=true),
		@Column(name="name", attrName="name", label="姓名", queryType=QueryType.LIKE),
		@Column(name="photo", attrName="photo", label="照片"),
		@Column(name="id_card", attrName="idCard", label="身份证号"),
		@Column(name="phone", attrName="phone", label="手机号"),
		@Column(name="we_chat", attrName="weChat", label="微信号"),
		@Column(name="criminal_condition", attrName="criminalCondition", label="前科情况"),
		@Column(name="census_region", attrName="censusRegion", label="户籍地区县"),
		@Column(name="local_police", attrName="localPolice", label="现住址属地派出所"),
		@Column(name="present_address", attrName="presentAddress", label="现住址"),
		@Column(name="arrest_date", attrName="arrestDate", label="查获时间", isUpdateForce=true),
		@Column(name="state_num", attrName="stateNum", label="1", comment="1:在手人员 2:监控人员 3:社会人员"),
		@Column(name="control_time", attrName="controlTime", label="监控时间", isUpdateForce=true),
		@Column(name="screening_time", attrName="screeningTime", label="毛发初筛时间", isUpdateForce=true),
		@Column(name="tag", attrName="tag", label="标签"),
		@Column(name="count_num", attrName="countNum", label="次数"),
		@Column(name="create_by", attrName="createBy", label="创建者", isUpdate=false, isQuery=false),
		@Column(name="create_date", attrName="createDate", label="创建时间", isUpdate=false, isQuery=false),
		@Column(name="update_by", attrName="updateBy", label="更新者", isQuery=false),
		@Column(name="update_date", attrName="updateDate", label="更新时间", isQuery=false),
		@Column(name="remarks", attrName="remarks", label="备注信息", queryType=QueryType.LIKE),
		@Column(name="del_flag", attrName="delFlag", label="删除标记"),
	}, joinTable={
	@JoinTable(type=Type.LEFT_JOIN, entity=Area.class, alias="b",
		on="b.area_code = a.census_region",
			columns={
				@Column(name="area_code", label="区域代码", isPK=true),
				@Column(name="area_name", label="区域名称", isQuery=false),
				@Column(name="area_type", label="区域类型"),
				@Column(name="tree_names", label="区域全称"),
				}),
			}, orderBy="a.update_date DESC"
	)
private Area area; //地区
public Area getArea() {
		return area;
	}

	public void setArea(Area area) {
		this.area = area;
	}

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值