コード例 #1
0
        void Check_OMManual()
        {
            //string _type = drpmanufacture.SelectedItem.Value.Substring(drpmanufacture.SelectedItem.Value.IndexOf("_T") + 2);
            // ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + (string)Session["type"] + "');", true);
            string _type = (string)Session["type"];

            if (myschedule_basket.Rows.Count > 0)
            {
                if (_type == "1")
                {
                    //ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('" + myschedule_basket.Rows[0].Cells[5].Text + "');", true);
                    int       Folder_Id = Convert.ToInt32(myschedule_basket.Rows[0].Cells[5].Text);
                    BLL_Dml   _objbll   = new BLL_Dml();
                    _database _objdb    = new _database();
                    _objdb.DBName = "dbCML";
                    _clstreefolder _objcls = new _clstreefolder();
                    _objcls.Folder_id = Folder_Id;
                    Session["status"] = "true";
                    btnDummy_ModalPopupExtender.Show();
                    //if (_objbll.CheckOMExist(_objcls,_objdb) == "0")
                    //{
                    //    btnDummy_ModalPopupExtender.Show();
                    //}
                    //else
                    //{
                    //    Session["Rev"] = "Revised";
                    //}
                }
                else
                {
                    Session["status"] = "false";
                }
            }
        }
コード例 #2
0
        private string GetDocNo_All()
        {
            BLL_Dml        _objbll = new BLL_Dml();
            _clstreefolder _objcls = new _clstreefolder();

            _objcls.Project_code = (string)Session["project"];
            _objcls.Folder_id    = Convert.ToInt16(Session["folderId"]);
            _database _objdb = new _database();

            _objdb.DBName = "dbCML";
            return(_objbll.Get_DBMsDoc_No_All(_objcls, _objdb));
        }
コード例 #3
0
        private void Update_User_ModulePermision()
        {
            BLL_Dml   _objbll = new BLL_Dml();
            _database _objdb  = new _database();

            _objdb.DBName = "DB_" + lblprj.Text;
            _clstreefolder _objcls = new _clstreefolder();

            _objcls.Folder_id        = Convert.ToInt32(Session["Id"].ToString());
            _objcls.Folder_possition = Convert.ToInt32(draccess.SelectedItem.Value);
            _objbll.Update_User_ModulePermision(_objcls, _objdb);
            btnDummy_ModalPopupExtender7.Hide();
            Load_User_AllModule();
        }
コード例 #4
0
        void load_Modules()
        {
            BLL_Dml   _objbll = new BLL_Dml();
            _database _objdb  = new _database();

            _objdb.DBName = "DB_" + lblprj.Text;
            _clstreefolder _objcls = new _clstreefolder();

            _objcls.Folder_type   = 0;
            ddlmodules.DataSource = _objbll.LOAD_PRJMAINMODULES(_objdb);

            ddlmodules.DataTextField  = "Module";
            ddlmodules.DataValueField = "Mod_Id";
            ddlmodules.DataBind();

            //ddlmodules.Items.Add();
        }
コード例 #5
0
        protected void populate_casTree()
        {
            mytree.Nodes.Clear();
            BLL_Dml   _objbll = new BLL_Dml();
            _database _objdb  = new _database();

            _objdb.DBName = "DB_" + Label1.Text;
            _clstreefolder _objcls = new _clstreefolder();

            _objcls.Folder_type = 0;
            DataTable _dt0 = _objbll.LOAD_PRJMAINMODULES(_objdb);
            //DataTable _dt0 = _objbll.Load_FolderTree_Cms(_objcls,_objdb);
            //_objcls.Folder_type = 1;
            //DataTable _dt1 = _objbll.Load_FolderTree_Cms(_objcls,_objdb);
            //_objcls.Folder_type = 2;
            //DataTable _dt2 = _objbll.Load_FolderTree_Cms(_objcls);
            //_objcls.Folder_type = 3;
            //DataTable _dt3 = _objbll.Load_FolderTree_Cms(_objcls);
            //_objcls.Folder_type = 4;
            //DataTable _dt4 = _objbll.Load_FolderTree_Cms(_objcls);
            var _0 = from o in _dt0.AsEnumerable()
                     select o;

            foreach (var row in _0)
            {
                TreeNode _n0 = new TreeNode();
                _n0.Text         = row[1].ToString();
                _n0.Value        = row[0].ToString();
                _n0.SelectAction = TreeNodeSelectAction.Expand;
                mytree.Nodes.Add(_n0);
                //var _1 = from o in _dt1.AsEnumerable()
                //         where o.Field<int>(2) == Convert.ToInt32(row[0].ToString())
                //         select o;
                //foreach (var row1 in _1)
                //{
                //    TreeNode _n1 = new TreeNode();
                //    _n1.Text = row1[1].ToString();
                //    _n1.Value = row1[0].ToString();
                //    _n1.SelectAction = TreeNodeSelectAction.Expand;
                //    _n0.ChildNodes.Add(_n1);
                //    //var _2 = from o in _dt2.AsEnumerable()
                //    //         where o.Field<int>(2) == Convert.ToInt32(row1[0].ToString())
                //    //         select o;
                //    //foreach (var row2 in _2)
                //    //{
                //    //    TreeNode _n2 = new TreeNode();
                //    //    _n2.Text = row2[1].ToString();
                //    //    _n2.Value = row2[0].ToString();
                //    //    _n2.SelectAction = TreeNodeSelectAction.Expand;
                //    //    _n1.ChildNodes.Add(_n2);
                //    //    var _3 = from o in _dt3.AsEnumerable()
                //    //             where o.Field<int>(2) == Convert.ToInt32(row2[0].ToString())
                //    //             select o;
                //    //    foreach (var row3 in _3)
                //    //    {
                //    //        TreeNode _n3 = new TreeNode();
                //    //        _n3.Text = row3[1].ToString();
                //    //        _n3.Value = row3[0].ToString();
                //    //        _n3.SelectAction = TreeNodeSelectAction.Expand;
                //    //        _n2.ChildNodes.Add(_n3);
                //    //        var _4 = from o in _dt4.AsEnumerable()
                //    //                 where o.Field<int>(2) == Convert.ToInt32(row3[0].ToString())
                //    //                 select o;
                //    //        foreach (var row4 in _4)
                //    //        {
                //    //            TreeNode _n4 = new TreeNode();
                //    //            _n4.Text = row4[1].ToString();
                //    //            _n4.Value = row4[0].ToString();
                //    //            _n3.ChildNodes.Add(_n4);
                //    //        }
                //    //    }
                //    //}
                //}
            }
            mytree.CollapseAll();
        }
コード例 #6
0
        void Continue_()
        {
            //Label1.Text = mytree.SelectedNode.Depth.ToString();
//------------------------------------------------ Existing ----------------------------------------//

            //Label1.Text = Label1.Text.Substring(0, Label1.Text.IndexOf(">>") - 1).Trim();
            //string _temp = Label1.Text.Substring(Label1.Text.IndexOf(">>") + 2).Trim();
            //Label1.Text = _temp.Substring(_temp.IndexOf(">>") + 2).Trim();
            //BLL_Dml _objbll = new BLL_Dml();
            //_clsManageTree _objcls = new _clsManageTree();
            //string _menu = (string)Session["_menu"];
            //string _level = (string)Session["level"];
            //string _possition = (string)Session["possition"];

            //if (_menu == "1")//create new folder
            //{
            //    _objcls.desciption = txtfolder.Text;
            //    _objcls.possition = Convert.ToInt32(_possition);
            //    if (_level == "1")
            //    {
            //        _objcls.service = "";
            //        try
            //        {
            //            _objbll.Create_Service(_objcls);
            //        }
            //        catch (Exception ex)
            //        {
            //            Label1.Text = ex.ToString();
            //        }
            //    }
            //    else if (_level == "2")
            //    {
            //        _objcls.service = Label1.Text.Substring(0, Label1.Text.IndexOf(">>") - 1).Trim();
            //        try
            //        {
            //            _objbll.Create_Package(_objcls);
            //        }
            //        catch (Exception ex)
            //        {
            //            Label1.Text = ex.ToString();
            //        }
            //    }
            //    else if (_level == "3")
            //    {
            //        _objcls.service = "";
            //        try
            //        {
            //            _objbll.Create_DocType(_objcls);
            //        }
            //        catch (Exception ex)
            //        {
            //            Label1.Text = ex.ToString();
            //        }
            //    }
            //}
            //else if (_menu == "2")//create sub folder
            //{
            //    _objcls.desciption = txtfolder.Text;
            //    if (_level == "1")
            //    {
            //        _objcls.service = Label1.Text;
            //        _objcls.possition = 0;
            //        try
            //        {
            //            _objbll.Create_Package(_objcls);
            //        }
            //        catch (Exception ex)
            //        {
            //            Label1.Text = ex.ToString();
            //        }

            //    }
            //    else if (_level == "2")
            //    {
            //        _objcls.service = "";
            //        _objcls.possition = 0;
            //        try
            //        {
            //            _objbll.Create_DocType(_objcls);
            //        }
            //        catch (Exception ex)
            //        {
            //            Label1.Text = ex.ToString();
            //        }
            //    }
            //    else if (_level == "3")
            //    {
            //        string _temp = Label1.Text.Substring(Label1.Text.IndexOf(">>") + 2).Trim();
            //        //Label1.Text = _temp.Substring(_temp.IndexOf(">>") + 2).Trim();
            //        //string _temp = Label1.Text.Substring(0, Label1.Text.IndexOf(">>") - 1).Trim();
            //        _objcls.service = _temp.Substring(_temp.IndexOf(">>") + 3).Trim();
            //        _objcls.possition = 0;
            //        try
            //        {
            //            _objbll.Create_Group(_objcls);
            //        }
            //        catch (Exception ex)
            //        {
            //            Label1.Text = ex.ToString();
            //        }
            //    }
            //}
            //else if (_menu == "3")
            //{
            //    _objcls.desciption = txtfolder.Text;
            //    _objcls.possition =Convert.ToInt32(txtpossition.Text);
            //    if (_level == "1")
            //    {
            //        //Label1.Text = mytree.SelectedNode.Value.Substring(0, mytree.SelectedNode.Value.IndexOf("#"));
            //        _objcls.code = mytree.SelectedNode.Value.Substring(0,mytree.SelectedNode.Value.IndexOf("#"));
            //        _objcls.service = "";
            //        _objcls.mode = 1;
            //        try
            //        {
            //            _objbll.Edit_Service(_objcls);
            //        }
            //        catch (Exception ex)
            //        {
            //            Label1.Text = ex.ToString();
            //        }
            //    }
            //    else if (_level == "2")
            //    {
            //        _objcls.service = Label1.Text.Substring(0, Label1.Text.IndexOf(">>") - 1).Trim();
            //        _objcls.code = mytree.SelectedNode.Value.Substring(1, mytree.SelectedNode.Value.IndexOf("#") - 1);
            //        _objcls.mode = 1;
            //        //Label1.Text = Label1.Text.Substring(0, Label1.Text.IndexOf(">>") - 1).Trim();
            //        try
            //        {
            //            _objbll.Edit_Package(_objcls);
            //        }
            //        catch (Exception ex)
            //        {
            //            Label1.Text = ex.ToString();
            //        }
            //    }
            //    else if (_level == "3")
            //    {
            //        _objcls.service = "";
            //        try
            //        {
            //            _objbll.Create_DocType(_objcls);
            //        }
            //        catch (Exception ex)
            //        {
            //            Label1.Text = ex.ToString();
            //        }
            //    }
            //}
            //Populate_Tree();
            //txtfolder.Text = "";
//------------------------------------------------- end of existing -------------------------------//
            BLL_Dml   _objbll = new BLL_Dml();
            _database _objdb  = new _database();

            _objdb.DBName = "dbCML";
            _clstreefolder _objcls = new _clstreefolder();

            try
            {
                string _menu = (string)Session["_menu"];
                //string _level = (string)Session["level"];
                int _level = 1;
                //if (mytree.Nodes.Count > 0)
                //{
                //    _level = Convert.ToInt32(mytree.SelectedNode.Depth.ToString()) + 1;
                //}
                string _possition = (string)Session["possition"];
                if (_possition != "0")
                {
                    if (mytree.Nodes.Count > 0)
                    {
                        _level = Convert.ToInt32(mytree.SelectedNode.Depth.ToString()) + 1;
                    }
                }
                if (_menu == "1")//create new folder
                {
                    try
                    {
                        if (mytree.Nodes.Count == 0)
                        {
                            _possition = "0";
                            _level     = 1;
                        }
                        //_objcls.Folder_description = txtfolder.Text;
                        _objcls.Folder_type      = _level;
                        _objcls.Folder_possition = Convert.ToInt32(_possition);
                        _objcls.Enabled          = true;
                        _objcls.Project_code     = (string)Session["project"];
                        if (_level == 1)
                        {
                            _objcls.Parent_folder = "0";
                        }
                        else if (_level == 2)
                        {
                            _objcls.Parent_folder = mytree.SelectedNode.Parent.Value.Substring(0, mytree.SelectedNode.Parent.Value.IndexOf("#"));
                        }
                        else if (_level == 3)
                        {
                            //Label1.Text = Label1.Text.Substring(0, Label1.Text.IndexOf(">>") - 1).Trim();
                            _objcls.Parent_folder = mytree.SelectedNode.Parent.Value.Substring(0, mytree.SelectedNode.Parent.Value.IndexOf("#"));
                        }
                        else if (_level == 4)
                        {
                            //Label1.Text = "yes";
                            _objcls.Parent_folder = mytree.SelectedNode.Parent.Value.Substring(0, mytree.SelectedNode.Parent.Value.IndexOf("#"));
                        }
                        else if (_level == 5)
                        {
                            //Label1.Text = "yes";
                            _objcls.Parent_folder = mytree.SelectedNode.Parent.Value.Substring(0, mytree.SelectedNode.Parent.Value.IndexOf("#"));
                        }

                        _objbll.Create_TreeFolder(_objcls, _objdb);
                    }
                    catch (Exception ex)
                    {
                        //Label1.Text = ex.ToString();
                    }
                }
                else if (_menu == "2")//create sub folder
                {
                    if (mytree.Nodes.Count == 0)
                    {
                        return;
                    }
                    //_objcls.Folder_description = txtfolder.Text;
                    _objcls.Folder_type      = _level + 1;
                    _objcls.Folder_possition = 0;
                    _objcls.Enabled          = true;
                    _objcls.Project_code     = (string)Session["project"];
                    if (_level == 1)
                    {
                        _objcls.Parent_folder = mytree.SelectedNode.Value.Substring(0, mytree.SelectedNode.Value.IndexOf("#"));
                    }
                    else if (_level == 2)
                    {
                        _objcls.Parent_folder = mytree.SelectedNode.Value.Substring(0, mytree.SelectedNode.Value.IndexOf("#"));
                    }
                    else if (_level == 3)
                    {
                        _objcls.Parent_folder = mytree.SelectedNode.Value.Substring(0, mytree.SelectedNode.Value.IndexOf("#"));
                    }
                    else if (_level == 4)
                    {
                        _objcls.Parent_folder = mytree.SelectedNode.Value.Substring(0, mytree.SelectedNode.Value.IndexOf("#"));
                    }
                    else if (_level == 5)
                    {
                        _objcls.Parent_folder = mytree.SelectedNode.Value.Substring(0, mytree.SelectedNode.Value.IndexOf("#"));
                    }
                    //Label1.Text = mytree.SelectedNode.Value.Substring(0, mytree.SelectedNode.Value.IndexOf("#"));
                    _objbll.Create_TreeFolder(_objcls, _objdb);
                }
                else if (_menu == "3")//edit folder
                {
                    string _value = mytree.SelectedNode.Value.ToString();
                    int    _id    = Convert.ToInt32(_value.Substring(0, _value.IndexOf("#")));
                    _objcls.Folder_id = _id;
                    if ((string)Session["edit_type"] != "move")
                    {
                        //_objcls.Folder_description = txtrename.Text;
                        _objcls.mode = (string)Session["edit_type"];
                        _objbll.Edit_Tree_Folder(_objcls, _objdb);
                    }
                    else
                    {
                        // _objcls.Folder_possition = Convert.ToInt32(txtpossition.Text);
                        //Label1.Text = _id.ToString();
                        _objbll.Move_Tree_Folder(_objcls, _objdb);
                    }
                }
            }
            catch (Exception ex)
            {
                //Label1.Text = ex.ToString();
            }
            Populate_Tree();
            //txtfolder.Text = "";
        }
コード例 #7
0
        void Continue_()
        {
            BLL_Dml   _objbll = new BLL_Dml();
            _database _objdb  = new _database();

            _objdb.DBName = "dbCML";
            _clstreefolder _objcls = new _clstreefolder();
            int            chk     = 0;

            if (chkdoc.Visible == true)
            {
                if (chkdoc.Checked == true)
                {
                    chk = 1;
                }
                else
                {
                    chk = 0;
                }
            }
            try
            {
                string _menu      = draction.SelectedItem.Value;
                int    _level     = Convert.ToInt32((string)Session["level"]);
                string _possition = (string)Session["pos"];
                if (_possition != "0")
                {
                    //if (mytree.Nodes.Count > 0)
                    //{
                    //    _level = Convert.ToInt32(mytree.SelectedNode.Depth.ToString()) + 1;
                    //}
                }
                if (_menu == "1")//create new folder
                {
                    try
                    {
                        //if (mytree.Nodes.Count == 0)
                        //{
                        //    _possition = "0";
                        //    _level = 1;
                        //}
                        _objcls.Folder_description = txtfolder.Text;
                        _objcls.Folder_type        = _level;
                        _objcls.Folder_possition   = Convert.ToInt32(_possition);
                        _objcls.Enabled            = true;
                        _objcls.Project_code       = (string)Session["project"];
                        _objcls.Parent_folder      = (string)Session["parent"];
                        _objcls.auto = chk;
                        _objbll.Create_TreeFolder(_objcls, _objdb);
                        ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('New Folder Created!');", true);
                    }
                    catch (Exception ex)
                    {
                        //Label1.Text = ex.ToString();
                    }
                }
                else if (_menu == "2")//create sub folder
                {
                    // ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('"+ chk.ToString() +"');", true);
                    //if (mytree.Nodes.Count == 0) return;

                    _objcls.Folder_description = txtfolder.Text;
                    _objcls.Folder_type        = _level + 1;
                    _objcls.Folder_possition   = 0;
                    _objcls.Enabled            = true;
                    _objcls.Project_code       = (string)Session["project"];
                    _objcls.Parent_folder      = (string)Session["fid"];
                    _objcls.auto = chk;
                    _objbll.Create_TreeFolder(_objcls, _objdb);
                    ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Sub Folder Created!');", true);
                }
                else if (_menu == "3")//edit folder
                {
                    //string _value = mytree.SelectedNode.Value.ToString();
                    //int _id = Convert.ToInt32(_value.Substring(0, _value.IndexOf("#")));
                    // _objcls.Folder_id = _id;
                    //string _id = (string)Session["fid"];
                    _objcls.Folder_id = Convert.ToInt32((string)Session["fid"]);
                    string _mode = draction0.SelectedItem.Text;
                    if (_mode != "Move to")
                    {
                        _objcls.Folder_description = txtrename.Text;
                        _objcls.mode = _mode;
                        _objbll.Edit_Tree_Folder(_objcls, _objdb);
                    }
                    else
                    {
                        _objcls.Folder_possition = Convert.ToInt32(txtrename.Text);
                        _objbll.Move_Tree_Folder(_objcls, _objdb);
                    }
                    ScriptManager.RegisterStartupScript(this, typeof(string), "close", "alert('Folder has been Changed');", true);
                }
            }
            catch (Exception ex)
            {
                //Label1.Text = ex.ToString();
            }

            //txtfolder.Text = "";
        }
コード例 #8
0
        protected void populate_casTree()
        {
            mytree.Nodes.Clear();
            BLL_Dml   _objbll = new BLL_Dml();
            _database _objdb  = new _database();

            _objdb.DBName = "dbCML";
            _clstreefolder _objcls = new _clstreefolder();

            _objcls.Folder_type = 0;
            DataTable _dt0 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);

            _objcls.Folder_type = 1;
            DataTable _dt1 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);

            _objcls.Folder_type = 2;
            DataTable _dt2 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);

            _objcls.Folder_type = 3;
            DataTable _dt3 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);

            _objcls.Folder_type = 4;
            DataTable _dt4 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);
            var       _0   = from o in _dt0.AsEnumerable()
                             select o;

            foreach (var row in _0)
            {
                TreeNode _n0 = new TreeNode();
                _n0.Text  = row[1].ToString();
                _n0.Value = row[0].ToString();
                string _prm = row[0].ToString() + "_M" + row[0].ToString() + "_MN" + row[1].ToString();
                if (_n0.Value == "2")
                {
                    _n0.NavigateUrl = "javascript:load('" + _prm + "')";
                }
                else
                {
                    _n0.SelectAction = TreeNodeSelectAction.Expand;
                }
                mytree.Nodes.Add(_n0);
                var _1 = from o in _dt1.AsEnumerable()
                         where o.Field <int>(2) == Convert.ToInt32(row[0].ToString())
                         select o;
                foreach (var row1 in _1)
                {
                    TreeNode _n1 = new TreeNode();
                    _n1.Text         = row1[1].ToString();
                    _n1.Value        = row1[0].ToString();
                    _n1.SelectAction = TreeNodeSelectAction.Expand;
                    _prm             = row1[0].ToString() + "_M" + row[0].ToString() + "_MN" + row[1].ToString();
                    if (_n0.Value == "5")
                    {
                        _n1.NavigateUrl = "javascript:load('" + _prm + "')";
                    }
                    else if (_n0.Value == "6")
                    {
                        _n1.NavigateUrl = "javascript:load('" + _prm + "')";
                    }
                    _n0.ChildNodes.Add(_n1);
                    var _2 = from o in _dt2.AsEnumerable()
                             where o.Field <int>(2) == Convert.ToInt32(row1[0].ToString())
                             select o;
                    foreach (var row2 in _2)
                    {
                        TreeNode _n2 = new TreeNode();
                        _n2.Text  = row2[1].ToString();
                        _n2.Value = row2[0].ToString();
                        _n1.ChildNodes.Add(_n2);
                        var _3 = from o in _dt3.AsEnumerable()
                                 where o.Field <int>(2) == Convert.ToInt32(row2[0].ToString())
                                 select o;
                        foreach (var row3 in _3)
                        {
                            TreeNode _n3 = new TreeNode();
                            _n3.Text  = row3[1].ToString();
                            _n3.Value = row3[0].ToString();
                            _n2.ChildNodes.Add(_n3);
                            var _4 = from o in _dt4.AsEnumerable()
                                     where o.Field <int>(2) == Convert.ToInt32(row3[0].ToString())
                                     select o;
                            foreach (var row4 in _4)
                            {
                                TreeNode _n4 = new TreeNode();
                                _n4.Text        = row4[1].ToString();
                                _n4.Value       = row4[0].ToString();
                                _prm            = row4[0].ToString() + "_M" + row[0].ToString() + "_MN" + row[1].ToString();
                                _n4.NavigateUrl = "javascript:load('" + _prm + "');";
                                //_n4.Target = "myframe1";
                                _n3.ChildNodes.Add(_n4);
                            }
                        }
                    }
                }
            }
            mytree.CollapseAll();
        }
コード例 #9
0
        protected void populate_casTree()
        {
            BLL_Dml   _objbll = new BLL_Dml();
            _database _objdb  = new _database();

            _objdb.DBName = "dbCML";
            _clstreefolder _objcls = new _clstreefolder();

            _objcls.Folder_type = 0;
            DataTable _dt0 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);

            _objcls.Folder_type = 1;
            DataTable _dt1 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);

            _objcls.Folder_type = 2;
            DataTable _dt2 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);

            _objcls.Folder_type = 3;
            DataTable _dt3 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);

            _objcls.Folder_type = 4;
            DataTable _dt4 = _objbll.Load_FolderTree_Cms(_objcls, _objdb);
            var       _0   = from o in _dt0.AsEnumerable()
                             select o;

            foreach (var row in _0)
            {
                TreeNode _n0 = new TreeNode();
                _n0.Text  = row[1].ToString();
                _n0.Value = row[0].ToString();
                string _prm = row[0].ToString() + "_P" + row[1].ToString() + " > " + "";
                if (_n0.Value == "1" || _n0.Value == "4" || _n0.Value == "5" || _n0.Value == "6")
                {
                    _n0.SelectAction = TreeNodeSelectAction.Expand;
                }
                else if (_n0.Value == "2")
                {
                    _n0.NavigateUrl = "javascript:callcms('" + _prm + "','1')";
                }
                else if (_n0.Value == "3")
                {
                    _n0.NavigateUrl = "javascript:callcms('" + row[1].ToString() + "','3')";
                }
                else if (_n0.Value == "7")
                {
                    _n0.NavigateUrl = "javascript:callcms('" + row[1].ToString() + "','8')";
                }
                mytree.Nodes.Add(_n0);
                var _1 = from o in _dt1.AsEnumerable()
                         where o.Field <int>(2) == Convert.ToInt32(row[0].ToString())
                         select o;
                foreach (var row1 in _1)
                {
                    TreeNode _n1 = new TreeNode();
                    _n1.Text         = row1[1].ToString();
                    _n1.Value        = row1[0].ToString();
                    _n1.SelectAction = TreeNodeSelectAction.Expand;
                    _prm             = row1[0].ToString() + "_P" + row[1].ToString() + " > " + row1[1].ToString();
                    if (_n0.Value == "5")
                    {
                        _n1.NavigateUrl = "javascript:callcms('" + _prm + "','6')";
                    }
                    else if (_n0.Value == "6")
                    {
                        _n1.NavigateUrl = "javascript:callcms('" + _prm + "','7')";
                    }
                    //else if (_n0.Value == "1")
                    //{
                    //    _prm=row1[0].ToString() ;
                    //    _n1.NavigateUrl = "javascript:callcms('" + _prm + "','0')";
                    //}
                    _n0.ChildNodes.Add(_n1);
                    var _2 = from o in _dt2.AsEnumerable()
                             where o.Field <int>(2) == Convert.ToInt32(row1[0].ToString())
                             select o;
                    foreach (var row2 in _2)
                    {
                        TreeNode _n2 = new TreeNode();
                        _n2.Text  = row2[1].ToString();
                        _n2.Value = row2[0].ToString();
                        _prm      = row2[0].ToString() + "_S" + row1[0].ToString();
                        if (_n0.Value == "1")
                        {
                            //_prm = row1[0].ToString();
                            _n2.NavigateUrl = "javascript:callcms('" + _prm + "','0')";
                        }
                        else
                        {
                            _n2.SelectAction = TreeNodeSelectAction.Expand;
                        }
                        _n1.ChildNodes.Add(_n2);

                        if (_n2.Value == "21")
                        {
                            TreeNode _a = new TreeNode();
                            _a.Text        = "Add";
                            _a.Value       = "Add";
                            _a.NavigateUrl = "javascript:callcms('" + _prm + "','0')";
                            _n2.ChildNodes.Add(_a);

                            TreeNode _b = new TreeNode();
                            _b.Text        = "Edit";
                            _b.Value       = "Edit";
                            _b.NavigateUrl = "../lveletesting.aspx";
                            _b.Target      = "myframe";
                            _n2.ChildNodes.Add(_b);

                            TreeNode _c = new TreeNode();
                            _c.Text        = "View";
                            _c.Value       = "View";
                            _c.NavigateUrl = "CMS/caslvreport.aspx";
                            _c.Target      = "myframe";
                            _n2.ChildNodes.Add(_c);
                        }



                        var _3 = from o in _dt3.AsEnumerable()
                                 where o.Field <int>(2) == Convert.ToInt32(row2[0].ToString())
                                 select o;
                        foreach (var row3 in _3)
                        {
                            TreeNode _n3 = new TreeNode();
                            _n3.Text         = row3[1].ToString();
                            _n3.Value        = row3[0].ToString();
                            _n3.SelectAction = TreeNodeSelectAction.Expand;
                            _n2.ChildNodes.Add(_n3);
                            var _4 = from o in _dt4.AsEnumerable()
                                     where o.Field <int>(2) == Convert.ToInt32(row3[0].ToString())
                                     select o;
                            foreach (var row4 in _4)
                            {
                                TreeNode _n4 = new TreeNode();
                                _n4.Text  = row4[1].ToString();
                                _n4.Value = row4[0].ToString();
                                string _path = row4[0].ToString() + "_P" + row[1].ToString() + " > " + row1[1].ToString() + " > " + row2[1].ToString() + " > " + row3[1].ToString() + " > " + row4[1].ToString();
                                _path           = _path.Replace("&", "^");
                                _n4.NavigateUrl = "javascript:callcms('" + _path + "','4')";
                                _n3.ChildNodes.Add(_n4);
                            }
                        }
                    }
                }
            }
            mytree.CollapseAll();
        }