easyUI datagrid的一些问题

关于datagrid表格的一些适用性的小功能点：

1.列隐藏

$('表格ID').datagrid('hideColumn','索要隐藏的字段');

2.合计总数（单独一行）

var tre = 0，tres = 0，tat = 0， heji = "合计:";

$('表格ID').datagrid('appendRow', { contracttotal: '合计', costamount: tres,  pasunmsurplus: tat,aa:"123"});

3.获取treegrid选中的内容

$("#ID").treegrid("getSelections")

treegrid 加载完成自己刷新

$('#dgproject').treegrid('load');

4、列增加事件

<th field="aa" width="80" align="center" formatter="formatEdit">操作</th>

function formatEdit(val, row) {

return "<a  class=\"easyui-linkbutton fapiao\" href=\"javascript:openFapiao('" + row.roles + "'," + row.id +")\">操作</a>";

}

5、treegrid列数据翻页以及选中

$('#dgproject').treegrid({
		queryParams:{ //传递额外的值
			auditState: 0,
		},
		url: '/admin/purchasecontractlist/projectandpuclistJsonMapStringinfoonecopy',
		method: 'post',
		pageSize: 100,
		pageList: [5,10,20,30,50,100,150,200,300,500,1000],
		loadFilter: function(data){ //过滤原始数据
			return data;
		},
		onLoadSuccess: function(row, data){
			$('#dgproject').treegrid('expand', loadprojectId); //项目文件夹  打开
			$('#dgproject').treegrid('select', loadprojectId); //项目文件夹  选中
			$('#dgproject').treegrid('select', processId); //项目  选中
			
			$('#dgproject').treegrid('select', processId_bj);//项目  选中
			$('#dgproject').treegrid('expand', loadprojectId_bj);//项目文件夹  打开
			$('#dgproject').treegrid('select', loadprojectId_bj);//项目文件夹  选中
		},
		success:function (data) {  //写入表格中的数据
			$("#dgproject").treegrid({data});
		},
	});
	var pagerFilter= function (data) {
		if ($.isArray(data)) { // is array  
			data = {
				total: data.length,
				rows: data
			}
		}
		var target = this;
		var tg = $(target);
		var state = tg.data('treegrid');
		var opts = tg.treegrid('options');
		if (!state.allRows) {
			state.allRows = data.rows;
		}
		if (!opts.remoteSort && opts.sortName) {
			var names = opts.sortName.split(',');
			var orders = opts.sortOrder.split(',');
			state.allRows.sort(function(r1, r2) {
				var r = 0;
				for (var i = 0; i < names.length; i++) {
					var sn = names[i];
					var so = orders[i];
					var col = $(target).treegrid('getColumnOption', sn);
					var sortFunc = col.sorter || function(a, b) {
						return a == b ? 0 : (a > b ? 1 : -1);
					};
					r = sortFunc(r1[sn], r2[sn]) * (so == 'asc' ? 1 : -1);
					if (r != 0) {
						return r;
					}
				}
				return r;
			});
		}
		var topRows = [];
		var childRows = [];
		$.map(state.allRows, function(row) {
			row._parentId ? childRows.push(row) : topRows.push(row);
			row.children = null;
		});
		data.total = topRows.length;
		var pager = tg.treegrid('getPager');
		pager.pagination('refresh', {
			total: data.total,
			pageNumber: opts.pageNumber
		});
		opts.pageNumber = pager.pagination('options').pageNumber || 1;
		var start = (opts.pageNumber - 1) * parseInt(opts.pageSize);
		var end = start + parseInt(opts.pageSize);
		data.rows = topRows.slice(start, end).concat(childRows);
		return data;
	}
	$.extend($.fn.treegrid.methods, {
		clientPaging: function(jq) {
			return jq.each(function() {
				var tg = $(this);
				var state = tg.data('treegrid');
				var opts = state.options;
				opts.loadFilter = pagerFilter;
				var onBeforeLoad = opts.onBeforeLoad;
				opts.onBeforeLoad = function(row, param) {
					state.allRows = null;
					return onBeforeLoad.call(this, row, param);
				}
				var pager = tg.treegrid('getPager');
				pager.pagination({
					onSelectPage: function(pageNum, pageSize) {
						opts.pageNumber = pageNum;
						opts.pageSize = pageSize;
						pager.pagination('refresh', {
							pageNumber: pageNum,
							pageSize: pageSize
						});
						tg.treegrid('loadData', state.allRows);
					}
				});
				tg.treegrid('loadData', state.data);
				if (opts.url) {
					tg.treegrid('reload');
				}
			});
		},
	});
	$('#dgproject').treegrid().treegrid('clientPaging');

6、datagrid存取数据

$("#id").框的属性名称（“setValue”,"存入的值"）

$("#id").框的属性名称（“getValue”）获取的值