Beispiel #1
0
        public ActionResult List()
        {
            using (var db = DbAccess.DbFrameworkContext.Create())
            {
                //获取全部机构数据
                var items = db.T_QWF_Org.AsNoTracking().Where(w => w.IsDelete == 0).OrderBy(o => o.SortId).ThenBy(o => o.OrgName).AsQueryable().ToList();

                var tree = new Web.UI.TreeConverter <DbAccess.T_QWF_Org>();

                tree.GetId       = m => { return(m.OrgId.ToString()); };
                tree.GetParentId = m => { return(m.ParentId.ToString()); };

                var result = tree.ConvertTo(item => {
                    var node = new Models.OrganizactionTreeGrid();
                    node.id  = item.OrgId.ToString();

                    node.OrgId     = item.OrgId;
                    node.ParentId  = item.ParentId;
                    node.OrgName   = item.OrgName;
                    node.OrgCode   = item.OrgCode;
                    node.IsOutName = item.IsOut == 1 ? "外部" : "内部";
                    node.IsOut     = item.IsOut == 1?true:false;

                    node.Remarks    = item.Remarks;
                    node.CreateTime = item.CreateTime.ToString("yyyy-MM-dd HH:mm:ss");
                    node.UpdateTime = item.UpdateTime == null ? string.Empty : item.UpdateTime.Value.ToString("yyyy-MM-dd HH:mm:ss");

                    node.OrgAttribute     = item.OrgAttribute;
                    node.OrgAttributeName = ((QWF.Framework.Services.SvrModels.SvrOrgInfo.OrgAttributeEnum)item.OrgAttribute).ToString();
                    return(node);
                }, items, "0");

                return(this.Content(Newtonsoft.Json.JsonConvert.SerializeObject(result)));
            }
        }
Beispiel #2
0
        /// <summary>
        /// QWebFramework/Common/GetOrgTree
        /// </summary>
        /// <returns></returns>
        public ActionResult GetOrgTree()
        {
            using (var db = DbAccess.DbFrameworkContext.Create())
            {
                var rows = db.T_QWF_Org.AsNoTracking().Where(w => w.IsDelete == 0).OrderBy(o => o.SortId).ThenBy(o => o.OrgName).ToList();

                var tree = new Web.UI.TreeConverter <DbAccess.T_QWF_Org>();

                tree.ClosedLayer = 2;//这里要全部展开。否则是会异步加载

                tree.GetId       = m => { return(m.OrgId.ToString()); };
                tree.GetParentId = m => { return(m.ParentId.ToString()); };

                //映射字段
                var treeList = tree.ConvertTo(item =>
                {
                    var node = new Web.UI.BaseTreeNode();
                    node.id  = item.OrgId.ToString();

                    node.text = item.OrgName;
                    return(node);
                }, rows, "0");
                return(this.Content(JsonConvert.SerializeObject(treeList)));
            }
        }
Beispiel #3
0
        public ActionResult GetConfigTreeGrid()
        {
            using (var db = DbAccess.DbFrameworkContext.Create())
            {
                var rows = db.T_QWF_Config.AsNoTracking().Where(w => w.IsDelete == 0).OrderBy(o => o.SortId).ToList();

                var tree = new Web.UI.TreeConverter <DbAccess.T_QWF_Config>();

                tree.ClosedLayer = 2;//这里要全部展开。否则是会异步加载

                tree.GetId       = m => { return(m.ConfigId.ToString()); };
                tree.GetParentId = m => { return(m.ParentId.ToString()); };

                //映射字段
                var treeList = tree.ConvertTo(item =>
                {
                    var node  = new Models.ConfigTreeGrid();
                    node.id   = item.ConfigId.ToString();
                    node.text = item.ConfigName;

                    node.ConfigId    = item.ConfigId;
                    node.ConfigName  = item.ConfigName;
                    node.ConfigCode  = item.ConfigResourceCode;
                    node.ConfigValue = item.ConfigValue;
                    node.Remarks     = item.ConfigRemarks;
                    node.ValueType   = item.ConfigValueType;
                    node.CreateTime  = item.CreateTime.ToString("yyyy-MM-dd HH:mm:ss");
                    node.UpdateTime  = item.UpdateTime == null ? string.Empty : item.UpdateTime.Value.ToString("yyyy-MM-dd HH:mm:ss");

                    return(node);
                }, rows, "0");
                return(this.Content(Newtonsoft.Json.JsonConvert.SerializeObject(treeList)));
            }
        }
        public ActionResult GetMenuTree()
        {
            var roleId = this.Request["roleId"].SafeConvert().ToInt32(0);

            using (var db = DbAccess.DbFrameworkContext.Create())
            {
                var rows = (from a in db.T_QWF_Menu
                            join b in  db.T_QWF_RoleInMenu
                            on new { a.MenuId, RoleId = roleId } equals new { b.MenuId, b.RoleId } into cc
                            from d in cc.DefaultIfEmpty()
                            orderby a.SortId
                            select new Models.RoleInMenu
                {
                    IsSubNode = a.IsSubNode,
                    MenuName = a.MenuName,
                    ParentId = a.ParentId,
                    MenuId = a.MenuId,
                    RoleId = d.RoleId,
                }).ToList();

                var tree = new Web.UI.TreeConverter <Models.RoleInMenu>();

                tree.GetId       = m => { return(m.MenuId.ToString()); };
                tree.GetParentId = m => { return(m.ParentId.ToString()); };
                tree.GetCheckbox = m => { return(m.RoleId != null && m.IsSubNode == 0 ? true : (bool?)null); };

                //映射字段
                var treeList = tree.ConvertTo(item =>
                {
                    var node = new Web.UI.BaseTreeNode();
                    node.id  = item.MenuId.ToString();
                    //node.checkbox = item.RoleId
                    node.text = item.MenuName;
                    return(node);
                }, rows.ToList(), "0");
                return(this.Content(Newtonsoft.Json.JsonConvert.SerializeObject(treeList)));
            }
        }
Beispiel #5
0
        // GET: QWebFramework/Common/GetUserLeftMenu
        public ActionResult GetUserLeftMenu()
        {
            var curUser = QWF.Framework.Web.UserContext.GetCurrentInfo();

            using (var db = QWF.Framework.DbAccess.DbFrameworkContext.Create())
            {
                //权限过滤
                var qryMenuIds = (from a in db.T_QWF_RoleInMenu
                                  join b in db.T_QWF_UserInRole on a.RoleId equals b.RoleId
                                  join c in db.T_QWF_Menu on a.MenuId equals c.MenuId
                                  where b.UserId == curUser.CurrentUserId && c.IsShow == 1
                                  select c.MenuIdList).ToList();

                List <int> menuIds = new List <int>();
                foreach (var ids in qryMenuIds)
                {
                    ids.Split(new char[1] {
                        ','
                    }, StringSplitOptions.RemoveEmptyEntries).ToList().ForEach(id =>
                    {
                        if (id.Length > 0)
                        {
                            menuIds.Add(id.SafeConvert().ToInt32());
                        }
                    });
                }

                menuIds = menuIds.Distinct().ToList();



                var rows = db.T_QWF_Menu.Where(w => menuIds.Contains(w.MenuId)).OrderBy(o => o.SortId).Select(s => new Models.LeftMenuTree
                {
                    MenuId     = s.MenuId,
                    ParentId   = s.ParentId,
                    MenuName   = s.MenuName,
                    DefaultUrl = s.DefaultUrl,
                    IconCls    = s.IconCls,
                    Target     = s.Target
                }).ToList();

                var tree = new Web.UI.TreeConverter <Models.LeftMenuTree>();

                //设置树属性
                tree.ClosedLayer = 1;
                tree.GetId       = m => { return(m.MenuId.ToString()); };
                tree.GetParentId = m => { return(m.ParentId.ToString()); };
                //tree.SetSelectedId = "100005";

                //转化
                var treeList = tree.ConvertTo(item =>
                {
                    //设置每个树节点的数据
                    var node     = new Web.UI.BaseTreeNode();
                    node.id      = item.MenuId.ToString();
                    node.text    = item.MenuName;
                    node.iconCls = item.IconCls;
                    //扩展属性
                    dynamic attributes = new ExpandoObject();
                    attributes.url     = ConvertUrl(item.DefaultUrl);
                    attributes.menuId  = item.MenuId;
                    attributes.target  = item.Target;

                    node.attributes = attributes;

                    return(node);
                }, rows, "100000");

                return(this.Content(JsonConvert.SerializeObject(treeList)));
            }
        }