baozhangfang/WebRoot/WEB-INF/jsp/column/columnList.jsp

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<jsp:include page="../../common/include.jsp" />
<% String basePath = request.getScheme()+ "://" + request.getServerName() + ":" +request.getServerPort() + request.getContextPath(); %>

<script type="text/javascript">

	/**数据字典显示区*/
	$(function() {
		$('#columnDataGrid').datagrid({
			rownumbers:true,
			fit:true,
			pageSize:10,
			pageList : [ 10, 20, 30, 40, 50 ],
			fitColumns:false,
			border:false,
			sortOrder:'desc',
			pagination:true,
			idField:'id',
			url:whzl.basePath + '/columnAction_listColumn',
			toolbar:'#searchtool',
			checkOnSelect:true,
			selectOnCheck:false,
			nowrap:true,
			loadFilter:function(result){
					if(result.success){
						return result.obj;
					}else{
						$.messager.alert("提示",result.message);
						return ;
					}							
				}
			}
		);
	});
	
	/**查询*/
	function searchFun(){
		var params = encodeURI("column.title="+trim($("#tblQuery").find("input[id='title']").val())+
	             "&column.tname="+trim($("#tblQuery").find("input[id='tname']").val()));
		$('#columnDataGrid').datagrid({url:whzl.basePath + '/columnAction_listColumn?'+params,pageNumber:1});
	}
	
	/**查询*/
	function searchOrder(){
		var params = encodeURI("column.title="+trim($("#tblQuery").find("input[id='title']").val())+
	             "&column.tname="+trim($("#tblQuery").find("input[id='tname']").val()));
		$('#columnDataGrid').datagrid({url:whzl.basePath + '/columnAction_listColumn?sort=id&order=desc&'+params,pageNumber:1});
	}
	
	/*清除查询条件**/
    function ClearQuery() {
        $("#tblQuery").find("input").val("");
        $("#tblQuery").find("select").val("-1");
    }
	
	/**更新*/
	var updateFormatter = function(value , row , index){
		return "<img src='<%=basePath%>/js/easyui/themes/itemicon/update.png' title='修改' onclick=updateRow(" + row.id + ") style='cursor:pointer' />";
	};
	
	/**更新事件*/
	function updateRow(id){
		var updateIndex = $('#columnDataGrid').datagrid('getRowIndex', id);
		$('#updateColumnDialog').dialog(
			{
				buttons : [
					{
						text : '提交', 
						iconCls : 'icon-ok', 
						handler : function(){
							$('#updateColumnForm').form('submit',
								{
									url : whzl.basePath+'/columnAction_updateColumn',
									success : function(result){
										var parseResult = $.parseJSON(result);
										if(parseResult.success){
											//修改完数据，更新对应行的数据
											$('#columnDataGrid').datagrid('updateRow',
												{
													index : updateIndex,
													row : parseResult.obj
												}
											);
											$("#updateColumnDialog").dialog("close");
											//$('#columnDataGrid').datagrid('reload');
										}else{
											$.messager.alert("提示",parseResult.message);
										}
									}
								}
							);
						}
					},
					{
						text : '取消', 
						iconCls : 'icon-cancel', 
						handler : function(){ 
							$("#updateColumnDialog").dialog("close");
						}
					}
				],
				onLoad : function(){
					$.ajax({
			            type: "post",//使用get方法访问后台
			            dataType: "json",//返回json格式的数据
			            url: "columnAction_findById",//要访问的后台地址
			            data: "column.id="+id,//要发送的数据
			            complete :function(){$("#load").hide();},//AJAX请求完成时隐藏loading提示
			            success: function(msg){//msg为返回的数据，在这里做数据绑定
			            	$("#id_update").val(msg.obj.id);
			            	$("#title_update").val(msg.obj.title);
			            	$("#tname_update").val(msg.obj.tname);
			            	$("#field_update").val(msg.obj.field);
			            	$("#num_update").val(msg.obj.num);
			            	$("#formatter_update").val(msg.obj.formatter);
			            }
				 	});
				}
			}
		);
	}
	
	
	/**删除*/
	var delFormatter = function(value , row , index){
		return "<img src='<%=basePath%>/js/easyui/themes/itemicon/delete.png' title='删除' onclick=deleteRow(" + row.id + ") style='cursor:pointer' />";
	};
	
	/**删除功能*/
	function deleteRow(id){
		$.messager.confirm('删除提示', '确定删除这条记录吗？', function(r){
			if (r){
				$.ajax({
		            type: "post",//使用get方法访问后台
		            dataType: "json",//返回json格式的数据
		            url: "columnAction_deleteColumn",//要访问的后台地址
		            data: "column.id="+id,//要发送的数据
		            complete :function(){$("#load").hide();},//AJAX请求完成时隐藏loading提示
		            success: function(msg){//msg为返回的数据，在这里做数据绑定
		            	if(msg.success){
		            		$.messager.alert('提示','删除成功！');
		            		//$('#columnDataGrid').datagrid('reload');
		            		searchFun();
		            	}else{
		            		$.messager.alert('提示','删除失败！');
		            	}
		            }
			 	});
			}
		});
	}
	
	/**增加数据字典*/
	function columnAdd(){
		$('#addColumnDialog').dialog(
				{
					buttons : [
						{
							text : '提交', 
							iconCls : 'icon-ok', 
							handler : function(){
								$('#addColumnForm').form('submit',
									{
										url : whzl.basePath+'/columnAction_addColumn',
										success : function(result){
											var parseResult = $.parseJSON(result);
											if(parseResult.success){
												$("#addColumnDialog").dialog("close");
												searchOrder();
											}else{
												$.messager.alert("提示",parseResult.message);
											}
										}
									}
								);
							}
						},
						{
							text : '取消', 
							iconCls : 'icon-cancel', 
							handler : function(){ 
								$("#addColumnDialog").dialog("close");
							}
						}
					]
				}
			);
	}

</script>

<div class="easyui-layout" data-options="fit:true,border:false">

	<div data-options="region:'center',border:false">
		<div id="searchtool" data-options="region:'north' , border:false">
			<div class="clear"></div>
			<table id="tblQuery" style="width:100%;font-size:12px;">
				<tr>
					<td align="right" width="80px"><span>表名</span></td><td width="100px"><input id="tname" name="column.tname" type="text"/></td>
					<td align="right" width="60px"><span>名称</span></td><td width="240px"><input id="title" name="column.title" type="text"/></td>
					<td align="left">
						<a href="javascript:searchFun();" class="easyui-linkbutton" data-options="iconCls:'icon-search',plain:true">查询</a>
						<a href="javascript:ClearQuery();" class="easyui-linkbutton" data-options="iconCls:'icon-emptied',plain:true">清空</a>
						<a href="javascript:columnAdd();" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true">增加</a>
					</td>
				</tr>
			</table>
			<div class="clear"></div>
		</div>
	
		<table id="columnDataGrid">
			<thead frozen="true">
        		<tr>
        			<th data-options="field:'id',checkbox:true,width:30">ID</th>
        		</tr>
        	</thead>
        	<thead>  
        		<tr>
            		<th data-options="field:'tname',width:100,editor:'textbox'">表名</th>
            		<th data-options="field:'title',width:90,editor:'textbox'">名称</th>
            		<th data-options="field:'field',width:100,editor:'textbox'">属性</th>
            		<th data-options="field:'num',width:120">排序</th>
            		<th data-options="field:'formatter',width:120">格式化</th>
            		<th data-options="field:'update',align:'center',width:38,formatter:updateFormatter">修改</th>
            		<th data-options="field:'delete',align:'center',width:38,formatter:delFormatter">删除</th>
        		</tr>  
    		</thead>
		</table>
		
	</div>
</div>
<div id="updateColumnDialog" data-options="title:'&nbsp;修改数据字典信息',iconCls:'icon-edit',width:700,height:250,modal:true,href:'<%=basePath %>/columnAction_toUpdate'">
</div>
<div id="addColumnDialog" data-options="title:'&nbsp;增加数据字典信息',iconCls:'icon-add',width:700,height:250,modal:true,href:'<%=basePath %>/columnAction_toAdd'">
</div>
<script type="text/javascript">
<!--
$(function(){
	parent.$.messager.progress('close');
});
//-->
</script>