52,797
社区成员
发帖
与我相关
我的任务
分享datagrid获取某一列的排序属性sortName和sortOrder
$('#dataList').datagrid({
title:'专业技术资格申请列表',
loadMsg: "正在努力为您加载数据...", //加载数据时向用户展示的语句
width : DataGrid.getWidth(),
height : 450,
url : "proskill/deptlist.action?empId=<%=empId%>&flowType=1000",
loadFilter:DataGrid.paginationFilter,
method:"post",
striped:true,
nowrap:false,
idField:"id",
singleSelect : false,
rowStyler: function(index,row){
if(row.pro.flowStatus==101||row.pro.flowStatus==201){
return 'background-color:#1C86EE';
}else if(row.pro.flowStatus==102||row.pro.flowStatus==202){
return 'background-color:#DC143C';
}
},
frozenColumns:[[
{field:'ck',checkbox:true,width:200},
{
title:'操作',
field:'operate',
width:80,
formatter:function(value,row,index){
var s = "<a href='javascript:void(0)' onclick='editRecord(\"" + row.id + "\",\"" + row.emp.name + "\")'>查看详细</a>";
return s;
}
},
{
title:'审核人',
field:'pro.deptCheckNames',
width:80,
formatter:function(value,row,index){
return row.pro.deptCheckNames;
}
},
{
title : '推荐排序',
field : 'pro.departmentSort',
sortable:true,
width : 100,
formatter:function(value,row,index){
if(row.pro.departmentSort==0){
return "";
}else{
/* if(row.pro.flowStatus==101||row.pro.flowStatus==201){
return "<font color='blue'>"+row.pro.departmentSort+"</font>";
}else if(row.pro.flowStatus==102||row.pro.flowStatus==202){
return "<font color='red'>"+row.pro.departmentSort+"</font>";
}
else */
return row.pro.departmentSort;
}
}
}
代码段如下，我现在想在jsp页面里的另一个函数export函数里获取推荐排序列的排序属性sortOrder，应该怎么写？
尝试以下两种方法都不行：
方法一：
var copts = $("#dataList").datagrid('getColumnOption', "pro.departmentSort");
alert(copts.sortOrder);
方法二：
var e = $("#dataList").datagrid('getColumnOption', "sortOrder");
alert(e);
烦请大神给出解答
title:'专业技术资格申请列表',
loadMsg: "正在努力为您加载数据...", //加载数据时向用户展示的语句
width : DataGrid.getWidth(),
height : 450,
url : "proskill/deptlist.action?empId=<%=empId%>&flowType=1000",
loadFilter:DataGrid.paginationFilter,
method:"post",
striped:true,
nowrap:false,
idField:"id",
singleSelect : false,
rowStyler: function(index,row){
if(row.pro.flowStatus==101||row.pro.flowStatus==201){
return 'background-color:#1C86EE';
}else if(row.pro.flowStatus==102||row.pro.flowStatus==202){
return 'background-color:#DC143C';
}
},
frozenColumns:[[
{field:'ck',checkbox:true,width:200},
{
title:'操作',
field:'operate',
width:80,
formatter:function(value,row,index){
var s = "<a href='javascript:void(0)' onclick='editRecord(\"" + row.id + "\",\"" + row.emp.name + "\")'>查看详细</a>";
return s;
}
},
{
title:'审核人',
field:'pro.deptCheckNames',
width:80,
formatter:function(value,row,index){
return row.pro.deptCheckNames;
}
},
{
title : '推荐排序',
field : 'pro.departmentSort',
sortable:true,
width : 100,
formatter:function(value,row,index){
if(row.pro.departmentSort==0){
return "";
}else{
/* if(row.pro.flowStatus==101||row.pro.flowStatus==201){
return "<font color='blue'>"+row.pro.departmentSort+"</font>";
}else if(row.pro.flowStatus==102||row.pro.flowStatus==202){
return "<font color='red'>"+row.pro.departmentSort+"</font>";
}
else */
return row.pro.departmentSort;
}
}
}
代码段如下，我现在想在jsp页面里的另一个函数export函数里获取推荐排序列的排序属性sortOrder，应该怎么写？
尝试以下两种方法都不行：
方法一：
var copts = $("#dataList").datagrid('getColumnOption', "pro.departmentSort");
alert(copts.sortOrder);
方法二：
var e = $("#dataList").datagrid('getColumnOption', "sortOrder");
alert(e);
烦请大神给出解答
...全文
请发表友善的回复…
发表回复
遥以寄北 2019-12-23
- 打赏
- 举报
var options = $("#datagrid").datagrid("options"); 中的 datagrid 要用你自己对应的列表id 不然怎么取得到值
java初学者0110 2019-07-03
- 打赏
- 举报
怎么我的不行呢var options = $("#datagrid").datagrid("options");这句报错TypeError: $.data(...) is undefined，id没写错，请大佬们分析一下
蛙鹏 2017-06-22
- 打赏
- 举报
var options = $("#datagrid").datagrid("options");
var sortName = option.sortName;
var sortOrder = option.sortOrder;
正好碰到这个问题 多谢楼主
JacksonMich 2016-07-27
- 打赏
- 举报
已解决。
var columns =$("#dataList").datagrid("options");
var order = columns.sortOrder;
如此即可。
[removed]
<!--
var listenerFieldsEditCount = 0;
jq(function(){
_listener_event_type=jq('#listenerEventType').combobox({
editable:false
});
_task_listener_fields_dg=jq('#task-listeners-fields-list').datagrid({
//title:"Listener",
//url:'${ctx}/wf/procdef/procdef!search.action',//加载表格数据的URL
singleSelect:true,
width:600,
height:300,
iconCls:'icon-edit',
//fit:true,
//idField:'id',
//pagination:true,
//pageSize:15,
//pageNumber:1,
//pageList:[10,15],
rownumbers:true,
//sortName:'id',
//sortOrder:'asc',
striped:true,
toolbar:[{
text:'New',
iconCls:'icon-add',
handler:function(){
if(listenerFieldsEditCount>0){
jq.messager.alert("error","有可编辑的单元格，不能添加!",'error');
return;
}
jq('#task-listeners-fields-list').datagrid('appendRow',{
id:'',
fieldName:'',
type:'',
value:'',
action:''
});
var index = jq('#task-listeners-fields-list').datagrid('getRows').length-1;
jq('#task-listeners-fields-list').datagrid('beginEdit', index);
}
}],
onDblClickRow:function(rowIndex,rowData){
editListenerField(rowIndex);
},
onBeforeEdit:function(index,row){
row.editing = true;
jq(this).datagrid('refreshRow', index);
listenerFieldsEditCount++;
},
onAfterEdit:function(index,row){
row.editing = false;
jq(this).datagrid('refreshRow', index);
listenerFieldsEditCount--;
},
onCancelEdit:function(index,row){
row.editing = false;
jq(this).datagrid('refreshRow', index);
listenerFieldsEditCount--;
}
});
jq('#fieldSaveBt').linkbutton({
iconCls:"icon-save"
});
jq('#fieldCancelBt').linkbutton({
iconCls:"icon-cancel"
});
jq("#listenerServiceClass").autocomplete(_process_def_provided_listeners, {
width: 450,
minChars: 0,
max: 10,
autoFill: true,
mustMatch: false,
matchContains: false,
scrollHeight: 220,
//multiple: true,
//multipleSeparator: " ",
scroll: true
});
populateListenerProperties();
});
function changeListenerServiceType(obj){
if(obj.value=='javaClass'){
jq('#listenerServiceLabel').html('Service Class:');
jq('#listenerServiceClass').show();
jq('#listenerServiceExpression').hide();
}else if(obj.value=='expression'){
jq('#listenerServiceLabel').html('Expression:');
jq('#listenerServiceClass').hide();
jq('#listenerServiceExpression').show();
}
}
function listenerFieldsActionFormatter(value,rowData,rowIndex){
var id = rowIndex;
var s='<img onclick="saveListenerField('+id+')" src="../../image/ok.png" title="'+"确定"+'" style="cursor:hand;"/>';
var c='<img onclick="cancelListenerField('+id+')" src="../../image/cancel.png" title="'+"取消"+'" style="cursor:hand;"/>';
var e='<img onclick="editListenerField('+id+')" src="../../image/modify.png" title="'+"修改"+'" style="cursor:hand;"/>';
var d='<img onclick="deleteListenerField('+id+')" src="../../image/delete.gif" title="'+"删除"+'" style="cursor:hand;"/>';
if(rowData.editing)
return s;
else
return e+' '+d;
}
function cancelListenerField(id){
_task_listener_fields_dg.datagrid('cancelEdit', id);
}
function editListenerField(id){
_task_listener_fields_dg.datagrid('beginEdit', id);
}
function saveListenerField(id){
//alert(id);
_task_listener_fields_dg.datagrid('endEdit', id);
//alert(editcount);
}
function deleteListenerField(id){
_task_listener_fields_dg.datagrid('deleteRow',id);
refreshAllListenerFields();
}
function refreshAllListenerFields(){
var rs = _task_listener_fields_dg.datagrid('getRows');
for(var i=0;i0){
jq.messager.alert("error","",'error');
return null;
}
var insertRows = _task_listener_fields_dg.datagrid('getChanges','inserted');
var updateRows = _task_listener_fields_dg.datagrid('getChanges','updated');
var deleteRows = _task_listener_fields_dg.datagrid('getChanges','deleted');
var changesRows = {
inserted : [],
updated : [],
deleted : []
};
if (insertRows.length>0) {
for (var i=0;i0) {
for (var k=0;k0) {
for (var j=0;j0){
jq.messager.alert("error","请先保存可编辑的表格!",'error');
return;
}
if(listenerId != "" && listenerId != null && listenerId!="null"&&listenerId;!="NULL"){
var listener = getExsitingListener();
var r = updateExistingListener(listener);
if(!r)return;
}else{
var listener = createNewListener();
var r = insertNewListener(listener);
if(!r)return;
}
_listener_win.window('close');
}
function insertNewListener(listener){
listener.event=_listener_event_type.combobox('getValue');
jq('input[name="listenerServiceType"]').each(function(i){
if(this.checked){
listener.serviceType=this.value;
return false;
}
});
listener.serviceClass=jq('#listenerServiceClass').val();
listener.serviceExpression=jq('#listenerServiceExpression').val();
var changesRows = getListenerFieldsGridChangeRows();
if(changesRows == null)return false;
var insertRows = changesRows['inserted'];
if (insertRows.length>0) {
for (var i=0;i0) {
for (var i=0;i0) {
for (var k=0;k0) {
for (var j=0;jdatagrid('loadData',_listener_fields_grid_data);
}
}
function closeTaskListenerWin(){
_listener_win.window('close');
}
//-->
[removed]
Event:
Create
Assignment
Complete
All
<input type="radio" id="listenerServiceType" name="listenerServiceType" value="javaClass" checked="checked" Class
<input type="radio" id="listenerServiceType" name="listenerServiceType" value="expression"
Service Class:
<input type="text" id="listenerServiceClass" name="listenerServiceClass" size="80" value=""/>
<input type="text" id="listenerServiceExpression" name="listenerServiceExpression" size="80" none;" value=""/>
Fields:
Field Name
Type
Value
Action
