jeecg一些用法

jeecg一些用法

1. 获取当前登录人

	//获取当前登录人
	TSUser user = ResourceUtil.getSessionUser();
	String departid = user.getDepartid();
	//获取当前组织
	TSDepart tsDepart = systemService.getEntity(TSDepart.class, departid);
	String sysOrgCode = tsDepart.getOrgCode();

	//根据sql 转换为List<Entity>形式
	 String sql= "SELECT * FROM tableName WHERE id= '"+id+"'";
     RowMapper<Entity> rowMapper1=new BeanPropertyRowMapper<Entity>(Entity.class);
     List<Entity> invoiceList= jdbcTemplate.query(sql, rowMapper1);
	
	 //datagrid中添加自定义sql方法
	 cq.add(Restrictions.sqlRestriction("is_state <> 1 ")); 

2. 在t:datagrid 中使用数据字典的方法

<-- 直接调用定义的数据字典 -->
<t:dgCol title="网点类型"  field="scType"  queryMode="group"  dictionary="nodetypes"  width="120"></t:dgCol>

<-- 可以传三个参数：第一个为表名；第二个为映射的字段，这个字段不能重复，是唯一的；第三个参数为需要展示映射表中的一个字段 -->
<t:dgCol title="所在国id"  field="locationCountryid"  queryMode="group" dictionary="tablename(表明),field1(映射的字段),field2(需要展示出的字段)"  width="120"></t:dgCol>

3. 在t:formvalid 中使用数据字典

<t:dictSelect id="scType" field="scType"  typeGroupCode="nodetypes"  datatype="*" hasLabel="false" title="网点类型"  defaultVal="${doorSubcenterPage.scType}"></t:dictSelect> 

<!--radio形式-->
<t:dictSelect id="scType" field="scType"  type="radio" typeGroupCode="nodetypes"  datatype="*" hasLabel="false" title="网点类型"  defaultVal="${doorSubcenterPage.scType}"></t:dictSelect> 

4. 使用select2 变成选择框

 //首先引入依赖
 <link rel="stylesheet" href="plug-in/select2/css/select2.min.css">
 <script type="text/javascript" src="plug-in/select2/js/select2.full.min.js"></script> 

 $.ajax({
	url : 'doorSubcenterZoneController.do?getSubCenter',
	type : 'GET',
	dataType : 'JSON',
	delay : 250,
	cache : true,
	success : function(data) {
		var pcname = new Array();
		for (var i = 0; i < data.length; i++) {
			var pcnameObj = {};
			pcnameObj.id = data[i].id;
			pcnameObj.text = data[i].sc_name;
			pcname.push(pcnameObj);
		}
		$("#szSubcenterId").select2({
			data : pcname,
			placeholder : '请选择网点',// 默认文字提示
			language : "zh-CN",// 汉化
			allowClear : true
		// 允许清空
		});
		
		 $("#szSubcenterId").change(function(){
			  var temp = $(this).select2("data");
			  var name = temp[0].text;
			  $("#szSubcenterWccode").val(name);
		});
	}
}); 

5. 三级联动

<!-- 联动 -->
<script src="plug-in/jquery/jquery.regionselect.js" type="text/javascript"></script>
 <fieldset>
 <legend>联动下拉省市区</legend>
 	<div style="width:80%;margin:5px 0 0 10px;">
	  <input type="text" id="province" style="width:32%;" value=""/> 
	  <input type="text" id="city" style="width:32%;" value=""/> 
	  <input type="text" id="area" style="width:32%;" value=""/> 
 	</div>
 </fieldset>
 <script type="text/javascript">
	$(function() {
		//省市区下拉
	 	$("#province").regionselect({
	 			url:'<%=basePath%>/jeecgFormDemoController.do?regionSelect'
	 	});
   })
 </script>

联动js

/**
 *省市区下拉框
 */
// url:'',actionurl:"jeecgAdvanceCmptController.do?regionSelect",
(function($) {
    $.fn.regionselect = function(argoptions) {
    	var argdefault={
 			   pid:"1",
 			   proname:'province',
 			   cityname:'city',
 			   areaname:'area',
 			   proid:'province',
 			   cityid:'city',
 			   areaid:'area',
 			   proval:'',
 			   cityval:'',
 			   areaval:'',
 			   level:3
    	};
    	var ajaxmethod=function(url,pid,selectionclass){
    		param={pid:pid};
			$.get(url,param,function(data){
				var jsonData=JSON.parse(data);
				$.each(jsonData,function(i,value){
					if($('#'+selectionclass).val()==value['name']){
						$("."+selectionclass).append("<option selected='selected' idq='"+value['id']+"' value='"+value['name']+"'>"+value['name']+"</option>");
						$("."+selectionclass).trigger('change');
					}else{
						$("."+selectionclass).append("<option idq='"+value['id']+"' value='"+value['name']+"'>"+value['name']+"</option>");	
					}
				});
			});
    	};
        var options = $.fn.extend({},argdefault,argoptions);
        //options.url=options.basepath+options.actionurl;
        return this.each(function() {
			var oo = $(this);
			//var a=oo.offset();
			var oowidth=oo.css("width");
			//console.info(oowidth);

			oo.after("<select class='form-control "+options.proid+"' name='"+options.proname+"' style='display:inline-block;font-size:12px;line-height:1em;height:26px;width:"+oowidth+"'><option value='' idq=''>--全国--</option></select>");
			oo.css("display","none");
			
			var cityobj=$("#"+options.cityid);
			var citywidth=cityobj.css("width");
			cityobj.after("<select class='form-control "+options.cityid+"' name='"+options.cityname+"' style='display:inline-block;font-size:12px;line-height:1em;height:26px;width:"+citywidth+"'></select>");
			cityobj.css("display","none");
			
			var areaobj=$("#"+options.areaid);
			var areawidth=areaobj.css("width");
			areaobj.after("<select class='form-control "+options.areaid+"' name='"+options.areaname+"' style='display:inline-block;font-size:12px;line-height:1em;height:26px;width:"+areawidth+"'></select>");
			areaobj.css("display","none");

			ajaxmethod(options['url'],options['pid'],options['proid']);
			
			$("."+options.proid).bind("change",function(){
				var provselected=$("."+options.proid+" option:selected").attr("idq");
				if($("."+options.cityid).length>0){
					$("."+options.cityid).empty();
					$("."+options.cityid).append("<option value=''>-- --</option>");
					ajaxmethod(options['url'],provselected,options['cityid']);
				}
				if($("."+options.areaid).length>0){
					$("."+options.areaid).empty();
				}
			});
			
			$("."+options.cityid).bind("change",function(){
				var cityselected=$("."+options.cityid+" option:selected").attr("idq");
				if($("."+options.areaid).length>0){
					$("."+options.areaid).empty();
					$("."+options.areaid).append("<option value=''>-- --</option>");
					ajaxmethod(options['url'],cityselected,options['areaid']);
				}
				
			});
			
        });
	};
})(jQuery);

6. textarea 输入框和日期的选择控件和正则的使用

<!--textarea--> 
<td align="right">
	<label class="Validform_label">
		内部备注:
	</label>
</td>
<td class="value" colspan="3">
	<textarea style="width:-webkit-fill-available;height: 45px" class="inputxt" rows="2" id="priceInsideNote" name="priceInsideNote"  ignore="ignore" ></textarea>
	<span class="Validform_checktip"></span>
	<label class="Validform_label" style="display: none;">内部备注</label>
</td>

<!--日期--> 
<input id="priceStartdate" name="priceStartdate" type="text" style="width: 150px"  class="Wdate" onClick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})"  ignore="ignore" value='<fmt:formatDate value='${priceStartdate}' type="date" pattern="yyyy-MM-dd hh:mm:ss"/>'/>

<!--只选择时间--> 
<input id="mytime" name="mytime" type="text" style="width: 150px"  class="Wdate" onClick="WdatePicker({dateFmt:'HH:mm:ss'})"  ignore="ignore" value='${kpiPointPage.mytime}'/>

<!--使用正则校验填值是否正确--> 
<input id="score" name="score" type="text" maxlength="22" style="width: 150px" class="inputxt"  datatype="/^(-?\d+)(\.\d+)?$/"  ignore="ignore"  value='${kpiPointPage.score}'/>