public DataTable GetAllChildNodeIncludeSelf()
        {
            DataTable citys = TreeTableBLL.GetAllChildNodeByNodes("MCS_SYS.dbo.Addr_OrganizeCity", "ID", "SuperID", _m.ID.ToString()).Copy();
            DataRow   dr    = citys.NewRow();

            dr["ID"]      = _m.ID;
            dr["Name"]    = _m.Name;
            dr["SuperID"] = _m.SuperID;
            citys.Rows.Add(dr);
            return(citys);
        }
        public string GetAllSuperNodeIDs()
        {
            DataTable dt  = TreeTableBLL.GetAllSuperNodeIDs("MCS_SYS.dbo.Addr_OfficialCity", "SuperID", "ID", _m.ID.ToString());
            string    ids = "";

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (ids != "")
                {
                    ids += ",";
                }
                ids += dt.Rows[i]["SuperID"];
            }

            return(ids);
        }
Exemplo n.º 3
0
        public string GetAllChildPosition()
        {
            DataTable dt  = TreeTableBLL.GetAllChildByNodes("MCS_SYS.dbo.Org_Position", "ID", "SuperID", _m.ID.ToString());
            string    ids = "";

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (ids != "")
                {
                    ids += ",";
                }
                ids += dt.Rows[i]["ID"];
            }

            return(ids);
        }
        //获取所有下级行政城市
        public DataTable GetAllChildNode()
        {
            DataTable dt = TreeTableBLL.GetAllChildByNodes("MCS_SYS.dbo.Addr_OfficialCity", "ID", "SuperID", _m.ID.ToString());

            return(dt);
        }
 public DataTable GetAllChildNode()
 {
     return(TreeTableBLL.GetAllChildByNodes("MCS_SYS.dbo.Addr_OrganizeCity", "ID", "SuperID", _m.ID.ToString()));
 }
        public DataTable GetFullPath()
        {
            DataTable dt = TreeTableBLL.GetFullPath("MCS_SYS.dbo.Addr_OrganizeCity", "ID", "SuperID", _m.ID);

            return(dt);
        }
Exemplo n.º 7
0
        public static DataTable GetAllChildPositionList(int ID)
        {
            DataTable dt = TreeTableBLL.GetAllChildByNodes("MCS_SYS.dbo.Org_Position", "ID", "SuperID", ID.ToString());

            return(dt);
        }