note3

jqGrid增加按钮：
.navButtonAdd('#pager', { caption: "全部取消", buttonicon: "ui-icon-trash", onClickButton: function (id) {
cancelSelectedRows();
}, position: "last"
});

jqGrid单选选择行：
var curSelRow=-1
onSelectRow: function (id) {
curSelRow = id;
}
$("#list").getCell(curSelRow, "Id")


jqGrid多选选择行：
var ids = $("#list").getGridParam('selarrrow');
for (var i = 0; i < ids.length;i++ ) {
userid += $("#list").getCell(ids[i], "UserId") + ",";
}

var gr = $(this).getRowData(id);
$("#UserId").html(gr.UserId);

树节点的属性：productTreeInfo.tree.getSelectedNode().id;

换行：Environment.NewLine；


触发器-修改表：
if(update([CateName]))
select @count = count(*) from [MANAGER_CFG_CATEGORY] a left join [MANAGER_CFG_CATEGORY] b on a.[parentid] = b.[id] where b.[parentid] = 0 and a.pduid = @pduid and a.[catename]=@catename and a.[typename]=@typename

select @oldcatename = [catename] from deleted

SourceArea = Convert(varchar,Round(@pduid,0))

if(@status = 'PASS' and @isbaseline = 1) --注意TSql中不是==

js中转换数据库中的HTML内容：str.replace(/<\s+/g, "<")

$('#divEdit').dialog('option', 'title', "111" );

$.each(jdata.rows, function (index, item) {});

var mark = $("input[name='mark']:radio:checked").val();

var top = document.documentElement.scrollTop + 100;
dialog.dialog({ 'top': top });