问题描述
当前的代码可以根据数据库自动生成目录，但是注销登陆后，以其他角色用户登录时，目录没有重新生成，还是第一次登陆时生成的目录，代码中有Clear（）函数，但是没起作用，不知道该在什么地方调用。希望各位前辈指导！usingSystem;usingSystem.Web;usingSystem.Web.UI;usingSystem.Data.SqlClient;usingSystem.Collections.Specialized;usingSystem.Configuration;usingSystem.Web.Configuration;usingSystem.Collections.Generic;usingSystem.Configuration.Provider;usingSystem.Security.Permissions;usingSystem.Data.Common;usingSystem.Data;usingSystem.Web.Security;//用于获取用户权限usingSystem.Web.UI.WebControls;usingSystem.Web.SessionState;///<summary>///SqlSiteMapProvider///</summary>publicclassSqlSiteMapProvider:StaticSiteMapProvider{privatestring_strCon;privateint_indexID,_indexTitle,_indexUrl,_indexDesc,_indexParent;//节点privateSiteMapNode_node;//节点字典表privateDictionary<int,SiteMapNode>_nodes=newDictionary<int,SiteMapNode>();//for线程安全privatereadonlyobject_lock=newobject();///<summary>///初始化///</summary>///<paramname="name">name</param>///<paramname="config">config</param>publicoverridevoidInitialize(stringname,NameValueCollectionconfig){//验证是否有configif(config==null)thrownewArgumentNullException("config不能是null");//没有provider则设置为默认的if(String.IsNullOrEmpty(name))name="SqlSiteMapProvider";//没有描述就增加一个描述if(string.IsNullOrEmpty(config["description"])){config.Remove("description");config.Add("description","SqlSiteMapProvider");}//调用基类的初始化方法base.Initialize(name,config);//初始化连接字符串stringconStringName=config["connectionStringName"];if(String.IsNullOrEmpty(conStringName))thrownewProviderException("没找到connectionStringName");config.Remove("connectionStringName");if(WebConfigurationManager.ConnectionStrings[conStringName]==null)thrownewProviderException("根据connectionStringName没找到连接字符串");//获得连接字符串_strCon=WebConfigurationManager.ConnectionStrings[conStringName].ConnectionString;if(String.IsNullOrEmpty(_strCon))thrownewProviderException("连接字符串是空的");Clear();}///<summary>///从持久性存储区加载站点地图信息，并在内存中构建它///</summary>///<returns></returns>publicoverrideSiteMapNodeBuildSiteMap(){string[]roles;stringstrRoles;stringuserName;stringsqlStr;stringsqlCondtion;lock(_lock){//线程安全的实现if(_node!=null)return_node;SqlConnectionconnection=newSqlConnection(_strCon);try{//SqlCommandcommand=newSqlCommand("sp_GetSiteMap",connection);//command.CommandType=CommandType.StoredProcedure;userName=System.Web.HttpContext.Current.Session["LoginUserName"].ToString();roles=System.Web.Security.Roles.GetRolesForUser(userName);strRoles=string.Join("','",roles);//if(roles.Length>0)//strRoles=",'"+strRoles+"'";//for(inti=0;i<roles.Length;i++)//sqlStr="SELECT[ID],[Title],[Description],[Url],[Roles],[ParentID]FROM[SiteMap]whererolesin('*'"+strRoles+")";sqlStr="";for(inti=0;i<roles.Length;i++){sqlCondtion="whereroleslike'%,"+roles[i]+"'orroleslike'%,"+roles[i]+",%'orroleslike'"+roles[i]+",%'orroleslike'"+roles[i]+"'orroleslike'*'";if(i==0)sqlStr="SELECT[ID],[Title],[Description],[Url],[Roles],[ParentID]FROM[SiteMap]"+sqlCondtion;elsesqlStr=sqlStr+"unionallSELECT[ID],[Title],[Description],[Url],[Roles],[ParentID]FROM[SiteMap]"+sqlCondtion;}sqlStr="selectdistinct*from("+sqlStr+")temp";connection.Open();//SqlCommandcommand=newSqlCommand("SELECT[ID],[Title],[Description],[Url],[Roles],[ParentID]FROM[SiteMap]whererolesin('*'"+strRoles+")",connection);//SqlCommandcommand=newSqlCommand("SELECT[ID],[Title],[Description],[Url],[Roles],[ParentID]FROM[SiteMap]",connection);SqlCommandcommand=newSqlCommand(sqlStr,connection);SqlDataReaderreader=command.ExecuteReader();//获得各个字段的索引_indexID=reader.GetOrdinal("ID");_indexUrl=reader.GetOrdinal("Url");_indexTitle=reader.GetOrdinal("Title");_indexDesc=reader.GetOrdinal("Description");_indexParent=reader.GetOrdinal("ParentID");if(reader.Read()){//把第一条记录作为根节点添加_node=CreateSiteMapNodeFromDataReader(reader);AddNode(_node,null);//构造节点树while(reader.Read()){//在站点地图中增加一个节点SiteMapNodenode=CreateSiteMapNodeFromDataReader(reader);AddNode(node,GetParentNodeFromDataReader(reader));}}reader.Close();}catch(Exceptionex){thrownewException(ex.ToString());}finally{connection.Close();}//返回SiteMapNodereturn_node;}}privatestringGetRolesForUser(stringp){thrownewNotImplementedException();}///<summary>///将检索目前由当前提供程序管理的所有节点的根节点///</summary>///<returns></returns>protectedoverrideSiteMapNodeGetRootNodeCore(){lock(_lock){returnBuildSiteMap();}}protectedoverridevoidClear(){lock(_lock){_nodes=newDictionary<int,SiteMapNode>();base.Clear();}}///<summary>///根据DataReader读出来的数据返回SiteMapNode///</summary>///<paramname="reader">DbDataReader</param>///<returns></returns>privateSiteMapNodeCreateSiteMapNodeFromDataReader(DbDataReaderreader){if(reader.IsDBNull(_indexID))thrownewProviderException("没找到ID");intid=reader.GetInt32(_indexID);if(_nodes.ContainsKey(id))thrownewProviderException("不能有重复ID");//根据字段索引获得相应字段的值stringtitle=reader.IsDBNull(_indexTitle)?null:reader.GetString(_indexTitle).Trim();stringurl=reader.IsDBNull(_indexUrl)?null:reader.GetString(_indexUrl).Trim();stringdescription=reader.IsDBNull(_indexDesc)?null:reader.GetString(_indexDesc).Trim();//新建一个SiteMapNodeSiteMapNodenode=newSiteMapNode(this,id.ToString(),url,title,description);//把这个SiteMapNode添加进节点字典表里_nodes.Add(id,node);//返回这个SiteMapNodereturnnode;}///<summary>///得到父节点的SiteMapNode///</summary>///<paramname="reader"></param>///<returns></returns>privateSiteMapNodeGetParentNodeFromDataReader(DbDataReaderreader){//if(reader.IsDBNull(_indexParent))//thrownewProviderException("父节点不能是空");intpid=reader.GetInt32(_indexParent);//if(!_nodes.ContainsKey(pid))//thrownewProviderException("有重复节点ID");//返回父节点的SiteMapNodereturn_nodes[pid];}}
<siteMapenabled="true"defaultProvider="SqlSiteMapProvider"><providers><addname="SqlSiteMapProvider"type="SqlSiteMapProvider"connectionStringName="ApplicationServices"/></providers></siteMap>