<%if(Session["rights"].ToString().IndexOf("qx_xxcbj")!=-1){%>
                <img id="imgbutton" src="../images/editword.png" alt="" title="编辑词条" style="cursor: pointer;" 
                onmouseover="this.src='../images/editword1.png'" onmouseout="this.src='../images/editword.png'" onclick="editAll();"/>
                <%}else{ %>
                <img src="../images/editword_disabled.png" alt="" title="编辑词条"/>
                <%} %>  

public string idinfo = "";
        public string name = "";
        public string namepronode = "";
        string nodeid = "";
        string Aid = "";
        string PreNode = "";
        public bool check = false;


        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["UserID"] == null)
            {
                Response.Redirect("/index/Default.aspx", true);
            }
            else
            {
                DataTable dt = DAL.BMarea_DAL.GetUserArea(Session["UserID"].ToString());// 用户所在的部门
                idinfo = dt.Rows[0][0].ToString();
                Aid = dt.Rows[0][2].ToString(); //登录用户的所在部门编号
                PreNode = dt.Rows[0][1].ToString();
            }

            if (Request.QueryString["name"] != null)
            {
                name = Request.QueryString["name"].ToString().Trim();
                DataTable dt1 = DAL.BMarea_DAL.GetNameId(name);

                namepronode = dt1.Rows[0][0].ToString(); //得到传递值（所在部门）的上一级编号

                if (name != "XX区")
                {
                    nodeid = DAL.BMarea_DAL.GetParentID(namepronode).ToString();
                }
                wordtitle.Value = name;
            }

            if (!string.IsNullOrEmpty(idinfo))
            {
                if (idinfo == name || (namepronode == Aid) || (nodeid == Aid))
                {
                    check = true;
                }

            }



        }

public static DataTable GetUserArea(string userid)
        {
            DbHelperSQLP db = new DbHelperSQLP();
            db.connectionString = PubConstant.GetConnectionString("Users");
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select top 1 Aid from BMuserlist where userid = '" + userid + "'");
            DataTable ds = db.Query(strSql.ToString()).Tables[0];
            if (ds.Rows.Count > 0)
            {
                string aid = ds.Rows[0][0].ToString();
                StringBuilder strSql2 = new StringBuilder();
                strSql2.Append("select top 1 areaname,pre,Aid from BMarea where Aid = '" + aid + "'");
                DataTable da = db.Query(strSql2.ToString()).Tables[0];
                if (da.Rows.Count > 0)
                {
                    return da;

                }
                else
                {
                    return null;
                }

            }
            else
            {
                return null;
            }
            
        }

//通过区域名称获取信息表（id）
        public static DataTable GetNameId(string name)
        {
            DbHelperSQLP db = new DbHelperSQLP();
            db.connectionString = PubConstant.GetConnectionString("Users");
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select top 1 pre,Aid from  BMarea where areaname = '" + name + "'");
            DataTable dt = db.Query(strSql.ToString()).Tables[0];
            if (dt.Rows.Count > 0)
            {

                return dt;
            }
            else
            {

                return null;
            }

        }

        //通过id得到上级部门的id

        public static string GetParentID(string aid)
        {
            string parentID = "";

            DbHelperSQLP db = new DbHelperSQLP();
            db.connectionString = PubConstant.GetConnectionString("Users");
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select top 1 pre from  BMarea where Aid = '" + aid + "'");
            DataTable ds = db.Query(strSql.ToString()).Tables[0];
            if (ds.Rows.Count > 0)
            {
                parentID = ds.Rows[0][0].ToString();
                return parentID;
            }
            else
            {
                return "";
            }

        }

select u.Aid,u.username,a.Aid,a.pre from BMuserlist as u,BMarea as a where u.Aid=a.Aid