[泛微]顶部菜单,菜单排序

——
顶部菜单,菜单排序
SELECT c.labelname,a.* FROM HrmUserMenuStatictics a,LeftMenuInfo b,HtmlLabelInfo c
WHERE a.menuid=b.id and b.labelid=c.indexid and c.languageid=7 and a.userid=123
order by clickCnt desc, menuid

update HrmUserMenuStatictics set clickcnt =600 where id = 22 –1
update HrmUserMenuStatictics set clickcnt =500 where id = 81 –2
update HrmUserMenuStatictics set clickcnt =400 where id = 176 –4
update HrmUserMenuStatictics set clickcnt =300 where id = 51 –5
update HrmUserMenuStatictics set clickcnt =200 where id = 314 –6
update HrmUserMenuStatictics set clickcnt =100 where id = 219 –7

发表评论