资源描述:
《基础字典发送菜单》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、基础字典发送菜单ifnotexists(select*fromsyscolumnswherename='IsMenu'andobject_Name(id)='SYS_TableGUI')altertableSYS_TableGUIaddIsMenutinyint,SetupPathvarchar(128)--Script88--增加分类GOIFnotEXISTS(SELECT*FROMSYS_ScriptCategoriesWHEREid=1)insertintoSYS_ScriptCategories(ID
2、,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)Values(1,'SC1','HOMaster基础管理',1,0,0,0,Null)elseprint'SYS_ScriptCategories.id=1已经存在.'GO--删除旧记录deletefromSYS_Scriptswhereid=88--删除脚本内容GOGOinsertintoSYS_Scripts(ID,CategoryID,Code,Name,Description,xTyp
3、e,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate)Values(88,4,'PubBasic003',Null,'基础资料归类管理-获取所有的基础资料数据表信息',1,1,Null,1,'selectst.ID,st.TName,st.Name,st.DescriptionA,st.xType,st.ReadOnly,st.Standard,st.Enabled,stg.IsMenu,stg.SetupPath,Category=Casewhenstg.
4、Category=''''then''未分类''elseisnull(stg.Category,''未分类'')end,CASEWHEN(stg.DataISNULL)THEN0ELSE1ENDASIsConfigfromSYS_TablesstleftjoinSYS_TableGUIstgonst.ID=stg.IDwherest.xType>2','2011-03-0910:48:52')GO--增加分类GOIFnotEXISTS(SELECT*FROMSYS_ScriptCategoriesWHEREi
5、d=1)insertintoSYS_ScriptCategories(ID,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)Values(1,'SC1','HOMaster基础管理',1,0,0,0,Null)elseprint'SYS_ScriptCategories.id=1已经存在.'GO--删除旧记录deletefromSYS_Scriptswhereid=102--删除脚本内容GOGOinsertintoSYS_Scripts(ID
6、,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate)Values(102,4,'PubBasic004',Null,'基础资料归类管理-更改分类信息',1,1,'',1,'selectID,Category,IsMenu,SetupPathfromSYS_TableGUIwhereid=%d','2011-03-0910:53:52')GO--增加分类GOIFnotEXISTS(S
7、ELECT*FROMSYS_ScriptCategoriesWHEREid=25)insertintoSYS_ScriptCategories(ID,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)Values(25,'SC25','配置管理HOHMID',2,0,0,0,Null)elseprint'SYS_ScriptCategories.id=25已经存在.'GO--删除旧记录deletefromSYS_Scriptswhereid=-
8、1--删除脚本内容GOGOinsertintoSYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate)Values(-1,25,'Login_Menus',Null,'获取登录菜单',1,1,'SELECTCm.ID,Cm.ParentID,Cm.