} // DataTableToGrid() public JObject DataTableToJSON(DataTable DT, bool Editable = false, string GroupByCol = "", CswEnumExtJsXType GroupByColType = null) { CswExtJsGrid grid = DataTableToGrid(DT, Editable, GroupByCol, GroupByColType); return(grid.ToJson()); } // DataTableToJSON()
} // _getUniquePrefix() public JObject TreeToJson(string Title, CswNbtView View, ICswNbtTree Tree, bool IsPropertyGrid = false, string GroupByCol = "") { JObject Ret = new JObject(); if (null != View) { string gridUniquePrefix = _getUniquePrefix(View); CswExtJsGrid grid = new CswExtJsGrid(gridUniquePrefix); if (string.IsNullOrEmpty(GroupByCol)) { GroupByCol = View.GridGroupByCol; } grid.groupfield = GroupByCol; grid.title = Title; if (_CswNbtResources.CurrentNbtUser != null && _CswNbtResources.CurrentNbtUser.PageSize > 0) { grid.PageSize = _CswNbtResources.CurrentNbtUser.PageSize; } if (IsPropertyGrid && Tree.getChildNodeCount() > 0) { Tree.goToNthChild(0); } grid.Truncated = Tree.getCurrentNodeChildrenTruncated(); CswExtJsGridDataIndex nodeIdDataIndex = new CswExtJsGridDataIndex(gridUniquePrefix, "nodeId"); { CswExtJsGridField nodeIdFld = new CswExtJsGridField { dataIndex = nodeIdDataIndex }; grid.fields.Add(nodeIdFld); CswExtJsGridColumn nodeIdCol = new CswExtJsGridColumn { header = "Internal ID", dataIndex = nodeIdDataIndex, hidden = true }; grid.columns.Add(nodeIdCol); } CswExtJsGridDataIndex nodekeyDataIndex = new CswExtJsGridDataIndex(gridUniquePrefix, "nodekey"); { CswExtJsGridField nodekeyFld = new CswExtJsGridField { dataIndex = nodekeyDataIndex }; grid.fields.Add(nodekeyFld); CswExtJsGridColumn nodekeyCol = new CswExtJsGridColumn { header = "Internal Key", dataIndex = nodekeyDataIndex, hidden = true }; grid.columns.Add(nodekeyCol); } CswExtJsGridDataIndex nodenameDataIndex = new CswExtJsGridDataIndex(gridUniquePrefix, "nodename"); { CswExtJsGridField nodenameFld = new CswExtJsGridField { dataIndex = nodenameDataIndex }; grid.fields.Add(nodenameFld); CswExtJsGridColumn nodenameCol = new CswExtJsGridColumn { header = "Internal Name", dataIndex = nodenameDataIndex, hidden = true }; grid.columns.Add(nodenameCol); } CswExtJsGridDataIndex NodeTypeDataIndex = new CswExtJsGridDataIndex(gridUniquePrefix, "nodetypeid"); { CswExtJsGridField NodeTypeField = new CswExtJsGridField { dataIndex = NodeTypeDataIndex }; grid.fields.Add(NodeTypeField); CswExtJsGridColumn NodeTypeColumn = new CswExtJsGridColumn { header = "Internal Type ID", dataIndex = NodeTypeDataIndex, hidden = true }; grid.columns.Add(NodeTypeColumn); } CswExtJsGridDataIndex ObjectClassDataIndex = new CswExtJsGridDataIndex(gridUniquePrefix, "objectclassid"); { CswExtJsGridField ObjectClassField = new CswExtJsGridField { dataIndex = ObjectClassDataIndex }; grid.fields.Add(ObjectClassField); CswExtJsGridColumn ObjectClassColumn = new CswExtJsGridColumn { header = "Internal Parent Type ID", dataIndex = ObjectClassDataIndex, hidden = true }; grid.columns.Add(ObjectClassColumn); } // View Properties determine Columns and Fields foreach (CswNbtViewProperty ViewProp in View.getOrderedViewProps(true)) { if (null != ViewProp) { ICswNbtMetaDataProp MetaDataProp = null; if (ViewProp.Type == CswEnumNbtViewPropType.NodeTypePropId) { MetaDataProp = ViewProp.NodeTypeProp; } else if (ViewProp.Type == CswEnumNbtViewPropType.ObjectClassPropId) { MetaDataProp = ViewProp.ObjectClassProp; } // Because properties in the view might be by object class, but properties on the tree will always be by nodetype, // we have to use name, not id, as the dataIndex if (null != MetaDataProp) { string header = MetaDataProp.PropNameWithQuestionNo; CswExtJsGridDataIndex dataIndex = new CswExtJsGridDataIndex(gridUniquePrefix, MetaDataProp.PropName); // don't use PropNameWithQuestionNo here, because it won't match the propname from the tree // Potential bug here! // If the same property is added to the view more than once, we'll only use the grid definition for the first instance if (false == grid.columnsContains(header)) { CswExtJsGridField fld = new CswExtJsGridField { dataIndex = dataIndex }; CswExtJsGridColumn col = new CswExtJsGridColumn { header = header, dataIndex = dataIndex, hidden = (false == ViewProp.ShowInGrid) }; switch (ViewProp.FieldType) { case CswEnumNbtFieldType.Button: col.MenuDisabled = true; col.IsSortable = false; break; case CswEnumNbtFieldType.Number: fld.type = "number"; col.xtype = CswEnumExtJsXType.numbercolumn; break; case CswEnumNbtFieldType.DateTime: fld.type = "date"; col.xtype = CswEnumExtJsXType.datecolumn; // case 26782 - Set dateformat as client date format string dateformat = string.Empty; string DateDisplayMode = CswEnumNbtDateDisplayMode.Date.ToString(); if (ViewProp.Type == CswEnumNbtViewPropType.NodeTypePropId && ViewProp.NodeTypeProp != null) { DateDisplayMode = ViewProp.NodeTypeProp.DesignNode.getAttributeValueByName(CswNbtFieldTypeRuleDateTime.AttributeName.DateType); } else if (ViewProp.Type == CswEnumNbtViewPropType.ObjectClassPropId && ViewProp.ObjectClassProp != null) { DateDisplayMode = ViewProp.ObjectClassProp.Extended; } if (DateDisplayMode == string.Empty || DateDisplayMode == CswEnumNbtDateDisplayMode.Date.ToString() || DateDisplayMode == CswEnumNbtDateDisplayMode.DateTime.ToString()) { dateformat += CswTools.ConvertNetToPHP(_CswNbtResources.CurrentNbtUser.DateFormat); if (DateDisplayMode == CswEnumNbtDateDisplayMode.DateTime.ToString()) { dateformat += " "; } } if (DateDisplayMode == CswEnumNbtDateDisplayMode.Time.ToString() || DateDisplayMode == CswEnumNbtDateDisplayMode.DateTime.ToString()) { dateformat += CswTools.ConvertNetToPHP(_CswNbtResources.CurrentNbtUser.TimeFormat); } col.dateformat = dateformat; break; } if (ViewProp.Width > 0) { col.width = ViewProp.Width * 7; // approx. characters to pixels } grid.columns.Add(col); grid.fields.Add(fld); } // if( false == grid.columnsContains( header ) ) } // if(null != MetaDataProp ) } // if( ViewProp != null ) } // foreach( CswNbtViewProperty ViewProp in View.getOrderedViewProps() ) // Nodes in the Tree determine Rows for (Int32 c = 0; c < Tree.getChildNodeCount(); c++) { CswExtJsGridRow gridrow = new CswExtJsGridRow(c, gridUniquePrefix); Tree.goToNthChild(c); CswNbtTreeNode TreeNode = Tree.getCurrentTreeNode(); gridrow.data.Add(nodeIdDataIndex, Tree.getNodeIdForCurrentPosition().ToString()); gridrow.data.Add(nodekeyDataIndex, Tree.getNodeKeyForCurrentPosition().ToString()); gridrow.data.Add(nodenameDataIndex, Tree.getNodeNameForCurrentPosition().ToString()); gridrow.data.Add(NodeTypeDataIndex, TreeNode.NodeTypeId.ToString()); gridrow.data.Add(ObjectClassDataIndex, TreeNode.ObjectClassId.ToString()); CswNbtMetaDataNodeType NodeType = _CswNbtResources.MetaData.getNodeType(Tree.getNodeKeyForCurrentPosition().NodeTypeId); gridrow.canView = _CswNbtResources.Permit.canNodeType(CswEnumNbtNodeTypePermission.View, NodeType) && _CswNbtResources.Permit.isNodeWritable(CswEnumNbtNodeTypePermission.View, NodeType, Tree.getNodeIdForCurrentPosition()); gridrow.canEdit = (_CswNbtResources.Permit.canNodeType(CswEnumNbtNodeTypePermission.Edit, NodeType) && (_CswNbtResources.CurrentNbtUser.IsAdministrator() || _CswNbtResources.Permit.isNodeWritable(CswEnumNbtNodeTypePermission.Edit, NodeType, NodeId: Tree.getNodeIdForCurrentPosition())) && false == Tree.getNodeLockedForCurrentPosition()); gridrow.canDelete = (_CswNbtResources.Permit.canNodeType(CswEnumNbtNodeTypePermission.Delete, NodeType) && _CswNbtResources.Permit.isNodeWritable(CswEnumNbtNodeTypePermission.Delete, NodeType, NodeId: Tree.getNodeIdForCurrentPosition()) ); gridrow.isLocked = Tree.getNodeLockedForCurrentPosition(); gridrow.isDisabled = (false == Tree.getNodeIncludedForCurrentPosition()); if (null != _CswNbtResources.CurrentNbtUser) { gridrow.isFavorite = Tree.getNodeFavoritedForCurrentPosition(); } _TreeNodeToGrid(View, Tree, grid, gridrow); Tree.goToParentNode(); grid.rowData.rows.Add(gridrow); } Ret = grid.ToJson(); } return(Ret); } // TreeToJson()