workflow树控件checkbox列表用法
树绑定sql语句如下所示:
select id,id as pid,displayname as caption from yzh_auth_user
order by sj desc
表单加载后脚本js写法
var roleid = GetUrlJson().roleid;
SetValue('textbox1',roleid);
SetValue('textbox2',GetValueBySQL2("select caption from yzh_auth_role where id='"+roleid+"'"));
var t = GetObject('tree1');
t.RefreshViewData()
setTimeout(function(){
var roleid = GetUrlJson().roleid;
var t = GetObject('tree1');
var roleStr = GetValueBySQL2("select userid from yzh_auth_roleuser where roleid='"+roleid+"'");
var roleArray = roleStr.split(';');
if(roleArray && roleArray.length>0)
{
var id = '';
for(var index in roleArray)
{
id = roleArray[index];
if(id!='')
{
t.SetChecked(id);
}
}
}
},500);
全选/全不选checkbox的数据已改变脚本js写法
var t_val = GetValue('checkbox1');
var t = GetObject('tree1');
//alert(t_val);
if(t_val=='true')
{
t.SetCheckedALL(true);
}
else{
t.SetCheckedALL(false);
}
树型checkbox列表选中项保存脚本js写法
var roleid = GetValue('textbox1');
var rolemc = GetValue('textbox2');
function saveRoleUserRelData(){
var vs = GetObject('tree1').GetNodesChecked();
if(vs)
{
for(var index in vs)
{
var userid = vs[index].id;
var dbfieldStr = "id,roleid,userid,usertype,remark";
var dbfieldV = "'"+GetNewGuid2()+"'";
dbfieldV+=",'"+roleid+"'";
dbfieldV+=",'"+userid+"'";
dbfieldV+=",'1'";
dbfieldV+=",'角色:"+rolemc+"<=拥有用户权限:"+vs[index].text+"'";
DataInsert("yzh_auth_roleuser",dbfieldStr,dbfieldV,null,null,"");
}
}
parent.GetObject('grid1').RefreshViewData();
parent.CloseForm(true);
};
DataDelete("yzh_auth_roleuser","roleid='"+roleid+"'",saveRoleUserRelData,null);
—the—end—