/// <summary> /// 表格组件 /// </summary> /// <param name="fid"></param> /// <param name="multi"></param> /// <returns></returns> public IActionResult GridComponent(string fid, string multi) { FapComponent fc = _dbContext.Get <FapComponent>(fid); JqGridViewModel model = this.GetJqGridModel(fc.GridTableName, (q) => { q.QueryCols = fc.GridDisplayFields; q.InitWhere = fc.TableCondition; }); model.JqgridId = fid; model.IsMulti = multi.ToBool(); model.TempData.Add("returnfields", fc.ReturnFields); return(View(model)); }
public IActionResult TreeGridComponent(string fid, string multi) { FapComponent fc = _dbContext.Get <FapComponent>(fid); TreeGridViewModel model = new TreeGridViewModel(); model.TreeGridId = fid; model.IsMulti = multi.ToBool(); model.TreeFilterCondition = fc.TreeFilterCondition; model.TreeTitle = fc.TreeTitle; model.GridTitle = fc.GridTitle; #region 表 QuerySet qs = new QuerySet(); qs.TableName = fc.GridTableName; qs.QueryCols = fc.GridDisplayFields; qs.InitWhere = fc.TableCondition; model.GridModel = new JqGridViewModel { QuerySet = qs }; model.TempData.Add("returnfields", fc.ReturnFields); #endregion #region 树 //将List<dynamic>转换成List<TreeDataView> List <TreeDataView> treeList = new List <TreeDataView>(); string icon = "icon-folder ace-icon fa fa-folder blue"; if (!fc.TreeTableName.EqualsWithIgnoreCase("orgdept")) { if (!string.IsNullOrWhiteSpace(fc.TreeNodeIcon)) { icon = fc.TreeNodeIcon; } string sql = string.Format("select Fid as Id,{0} as Text,Pid,'{1}' as Icon from {2} ", fc.TreeDisplayField, icon, fc.TreeTableName); if (!string.IsNullOrWhiteSpace(fc.TreeCondition)) { sql += " where " + fc.TreeCondition; } if (!string.IsNullOrWhiteSpace(fc.TreeOrder)) { sql += " order by " + fc.TreeOrder; } var dataList = _dbContext.Query(sql); foreach (var data in dataList) { treeList.Add(new TreeDataView() { Id = data.Id, Text = data.Text, Pid = data.Pid, Icon = data.Icon, Data = new { selectable = true } }); } } else { IEnumerable <OrgDept> powerDepts = _rbacService.GetDeptInfoAuthority(_applicationContext.CurrentRoleUid); if (powerDepts != null && powerDepts.Any()) { foreach (var data in powerDepts) { TreeDataView tdv = new TreeDataView() { Id = data.Fid, Text = data.DeptName, State = new NodeState { Opened = false }, Pid = data.Pid, Icon = icon, Data = new { selectable = !data.HasPartPower } }; if (data.HasPartPower) { tdv.Icon = "icon-folder ace-icon fa fa-ban orange"; } treeList.Add(tdv); } } } List <TreeDataView> tree = new List <TreeDataView>(); TreeDataView treeRoot = new TreeDataView() { Id = "0", Text = "请选择", State = new NodeState { Opened = true }, Icon = "icon-folder purple ace-icon fa fa-flag", }; TreeViewHelper.MakeTree(treeRoot.Children, treeList, treeRoot.Id); tree.Add(treeRoot); string rej = tree.ToJsonIgnoreNullValue(); model.JsonData = rej; #endregion return(View(model)); }