private string _makeRealKey(string InKey) { CswDelimitedString RealKey = new CswDelimitedString('_'); RealKey.Add(InKey); RealKey.Add(_SessionId); return(RealKey.ToString()); }
public override string ToString() { CswDelimitedString DelimStr = new CswDelimitedString(_Delimiter); DelimStr.Add(Role.Name.Text); DelimStr.Add(NodeType.NodeTypeName); return(DelimStr.ToString()); }
public static string makeId(string Prefix, string ID, string Suffix) { CswDelimitedString ElementId = new CswDelimitedString(_Delimiter) { { Prefix, false }, { ID, false }, { Suffix, false } }; return(ElementId.ToString(false)); }
public override string ToString() { CswDelimitedString delimstr = new CswDelimitedString(_delimiter); if (isSet()) { delimstr[0] = _StringPrefix; delimstr[1] = _ViewId.ToString(); } return(delimstr.ToString()); }
void _NodeCountPath_OnChange() { if (null != _NodeCountPath) { _DelimitedString[7] = _NodeCountPath.ToString(); } else { _DelimitedString[7] = String.Empty; } }
} // _runTreeNodesRecursive() public JObject getNode(string NodeId) { CswDelimitedString NodeStr = new CswDelimitedString('_'); NodeStr.FromString(NodeId); if (NodeStr[0] == "nodeid") { NodeStr.RemoveAt(0); } string NodePk = NodeStr.ToString(); JObject Ret = new JObject(); Ret.Add(_getNode(NodePk, true)); return(Ret); }
public override void update() { CswNbtMetaDataObjectClass GhsOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswEnumNbtObjectClass.GHSClass ); foreach( CswNbtMetaDataNodeType GhsNT in GhsOC.getNodeTypes() ) { CswNbtMetaDataNodeTypeProp GhsPictogramsNTP = GhsNT.getNodeTypePropByObjectClassProp( CswNbtObjClassGHS.PropertyName.Pictograms ); CswDelimitedString PictoPaths = new CswDelimitedString( '\n' ) { "Images/cispro/ghs/512/rondflam.jpg", "Images/cispro/ghs/512/flamme.jpg", "Images/cispro/ghs/512/explos.jpg", "Images/cispro/ghs/512/skull.jpg", "Images/cispro/ghs/512/acid.jpg", "Images/cispro/ghs/512/bottle.jpg", "Images/cispro/ghs/512/silhouet.jpg", "Images/cispro/ghs/512/pollut.jpg", "Images/cispro/ghs/512/exclam.jpg" }; GhsPictogramsNTP.ValueOptions = PictoPaths.ToString(); foreach( CswNbtObjClassGHS GhsNode in GhsNT.getNodes( false, true ) ) { if( GhsNode.Pictograms.Value.Contains( "/ghs/600/" ) ) { GhsNode.Pictograms.Value.Replace( "/ghs/600/", "/ghs/512/" ); } else { GhsNode.Pictograms.Value.Replace( "/ghs/", "/ghs/512/" ); } GhsNode.postChanges( false ); } } // foreach( CswNbtMetaDataNodeType GhsNT in GhsOC.getNodeTypes() ) } // update()
public static void getDemoDataGrid(ICswResources CswResources, CswNbtDemoDataReturn Return, object Request) { CswNbtResources CswNbtResources = (CswNbtResources)CswResources; //Build table infrastructure DataTable GridTable = new DataTable("demodatatable"); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.NodeId, typeof(Int32)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.Name, typeof(string)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.Type, typeof(string)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.IsUsedBy, typeof(int)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.IsRequiredBy, typeof(int)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.ConvertToNonDemo, typeof(Boolean)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.Delete, typeof(Boolean)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.MenuOptions, typeof(string)); _ColumnTypeOverrides.Clear(); _ColumnTypeOverrides.Add(CswNbtDemoDataReturn.ColumnNames.IsUsedBy.ToString(), typeof(sbyte)); _ColumnTypeOverrides.Add(CswNbtDemoDataReturn.ColumnNames.IsRequiredBy.ToString(), typeof(sbyte)); //***************************** //Populate views string ViewQuery = @"select v.viewname, v.nodeviewid from node_views v where isdemo = '1' and visibility <> 'Property' and visibility <> 'Hidden' order by lower(viewname)"; CswArbitrarySelect ArbitraryViewsSelect = CswNbtResources.makeCswArbitrarySelect("select_demo_nodes", ViewQuery); DataTable DemoViewsTable = ArbitraryViewsSelect.getTable(); foreach (DataRow CurrentDemoViewRow in DemoViewsTable.Rows) { DataRow NewGridRowOfDemoViews = GridTable.NewRow(); GridTable.Rows.Add(NewGridRowOfDemoViews); NewGridRowOfDemoViews[CswNbtDemoDataReturn.ColumnNames.NodeId] = CurrentDemoViewRow["nodeviewid"].ToString(); NewGridRowOfDemoViews[CswNbtDemoDataReturn.ColumnNames.Name] = CurrentDemoViewRow["viewname"].ToString(); NewGridRowOfDemoViews[CswNbtDemoDataReturn.ColumnNames.Type] = "View"; NewGridRowOfDemoViews[CswNbtDemoDataReturn.ColumnNames.IsUsedBy] = 0; NewGridRowOfDemoViews[CswNbtDemoDataReturn.ColumnNames.IsRequiredBy] = 0; } //iterate demo views rows //***************************** //Populate views string NodesQuery = @"select n." + CswNbtDemoDataReturn.ColumnNames.NodeId + @",n.nodename,t.nodetypename, t.enabled from nodes n join nodetypes t on (n.nodetypeid=t.nodetypeid ) where n.isdemo = '1' order by lower( n.nodename ), lower( t.nodetypename )"; CswArbitrarySelect ArbitraryNodesSelect = CswNbtResources.makeCswArbitrarySelect("select_demo_nodes", NodesQuery); DataTable DemoNodesTable = ArbitraryNodesSelect.getTable(); foreach (DataRow CurrentDemoNodeRow in DemoNodesTable.Rows) { bool NodeEnabled = CswConvert.ToBoolean(CurrentDemoNodeRow["enabled"].ToString()); String DisabledLabel = NodeEnabled ? "" : "(Disabled) "; DataRow NewGridRowOfNodes = GridTable.NewRow(); GridTable.Rows.Add(NewGridRowOfNodes); NewGridRowOfNodes[CswNbtDemoDataReturn.ColumnNames.NodeId] = CurrentDemoNodeRow["nodeid"].ToString(); NewGridRowOfNodes[CswNbtDemoDataReturn.ColumnNames.Name] = CurrentDemoNodeRow["nodename"].ToString(); NewGridRowOfNodes[CswNbtDemoDataReturn.ColumnNames.Type] = DisabledLabel + CurrentDemoNodeRow["nodetypename"].ToString(); CswDelimitedString UsedByNodeIds = new CswDelimitedString(','); Int32 UsedByCount = 0; CswDelimitedString RequiredByNodeIds = new CswDelimitedString(','); Int32 RequiredByCount = 0; string nodeid = CurrentDemoNodeRow["nodeid"].ToString(); string node_used_by_query = @"select n." + CswNbtDemoDataReturn.ColumnNames.NodeId + @", n.nodename,t.nodetypename,n.isdemo, p.isrequired from jct_nodes_props j join nodetype_props p on (j.nodetypepropid=p.nodetypepropid) join field_types f on ( p.fieldtypeid = f.fieldtypeid ) join nodes n on (j.nodeid=n.nodeid) join nodetypes t on (n.nodetypeid=t.nodetypeid) where ( f.fieldtype='Relationship' or f.fieldtype='Location' ) and j.field1_fk='" + nodeid + "'"; CswArbitrarySelect ArbitraryUsedBySelect = CswNbtResources.makeCswArbitrarySelect("select_nodesusedby_nodeid_" + nodeid, node_used_by_query); DataTable NodesUsedByTable = ArbitraryUsedBySelect.getTable(); foreach (DataRow CurrentUsedByRow in NodesUsedByTable.Rows) { string CurrentNodeId = CurrentUsedByRow["nodeid"].ToString(); if (true == CswConvert.ToBoolean(CurrentUsedByRow["isrequired"].ToString())) { RequiredByNodeIds.Add(CurrentNodeId); RequiredByCount++; } else { UsedByNodeIds.Add(CurrentNodeId); UsedByCount++; } //if-else it's required } //iterate nodes used by rows NewGridRowOfNodes[CswNbtDemoDataReturn.ColumnNames.MenuOptions] = "{ \"requiredby\" : [" + RequiredByNodeIds.ToString() + "],\"usedby\" :[" + UsedByNodeIds.ToString() + "], \"nodename\": \" " + CurrentDemoNodeRow["nodename"].ToString() + "\" }"; NewGridRowOfNodes[CswNbtDemoDataReturn.ColumnNames.IsUsedBy] = UsedByCount; NewGridRowOfNodes[CswNbtDemoDataReturn.ColumnNames.IsRequiredBy] = RequiredByCount; } //iterate node rows CswNbtGrid Grid = new CswNbtGrid(CswNbtResources); Return.Data.Grid = Grid.DataTableToGrid(GridTable, IncludeEditFields: false, ColumnTypeOverrides: _ColumnTypeOverrides); } //getDemoDataGrid()
}//ToXml() public override string ToString() { return(_RootString.ToString()); }
public override void update() { // Add graphics to storage compatibility property on Materials. CswNbtMetaDataObjectClass MaterialOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswNbtMetaDataObjectClass.NbtObjectClass.MaterialClass ); CswNbtMetaDataObjectClassProp StorCompatOCP = MaterialOC.getObjectClassProp( CswNbtObjClassMaterial.StorageCompatibilityPropertyName ); CswDelimitedString ImageNames = new CswDelimitedString( '\n' ) { "0 - None", "1 - Inorganic Acids", "2 - Organic Acids", "3 - Bases", "4 - Oxidizing Inorganic Acids", "5 - Oxidizers", "6 - Toxics", "7 - Flammables" }; CswDelimitedString ImageUrls = new CswDelimitedString( '\n' ) { "/NbtWebApp/Images/cispro/0w.gif", "/NbtWebApp/Images/cispro/1o.gif", "/NbtWebApp/Images/cispro/2y.gif", "/NbtWebApp/Images/cispro/3g.gif", "/NbtWebApp/Images/cispro/4b.gif", "/NbtWebApp/Images/cispro/5l.gif", "/NbtWebApp/Images/cispro/6p.gif", "/NbtWebApp/Images/cispro/7r.gif" }; _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( StorCompatOCP, CswNbtMetaDataObjectClassProp.ObjectClassPropAttributes.listoptions, ImageNames.ToString() ); _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( StorCompatOCP, CswNbtMetaDataObjectClassProp.ObjectClassPropAttributes.valueoptions, ImageUrls.ToString() ); _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( StorCompatOCP, CswNbtMetaDataObjectClassProp.ObjectClassPropAttributes.textarearows, 50 ); _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( StorCompatOCP, CswNbtMetaDataObjectClassProp.ObjectClassPropAttributes.textareacols, 50 ); }//Update()
public override void update() { CswNbtMetaDataObjectClass GenericOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswNbtMetaDataObjectClass.NbtObjectClass.GenericClass ); CswNbtMetaDataObjectClass MaterialOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswNbtMetaDataObjectClass.NbtObjectClass.MaterialClass ); CswNbtMetaDataFieldType TextFT = _CswNbtSchemaModTrnsctn.MetaData.getFieldType( CswNbtMetaDataFieldType.NbtFieldType.Text ); CswNbtMetaDataFieldType ListFT = _CswNbtSchemaModTrnsctn.MetaData.getFieldType( CswNbtMetaDataFieldType.NbtFieldType.List ); CswNbtMetaDataFieldType GridFT = _CswNbtSchemaModTrnsctn.MetaData.getFieldType( CswNbtMetaDataFieldType.NbtFieldType.Grid ); CswNbtMetaDataFieldType ImageListFT = _CswNbtSchemaModTrnsctn.MetaData.getFieldType( CswNbtMetaDataFieldType.NbtFieldType.ImageList ); CswNbtMetaDataFieldType RelationshipFT = _CswNbtSchemaModTrnsctn.MetaData.getFieldType( CswNbtMetaDataFieldType.NbtFieldType.Relationship ); //// Jurisdiction NodeType //CswNbtMetaDataNodeType JurisdictionNT = _CswNbtSchemaModTrnsctn.MetaData.makeNewNodeType( new CswNbtWcfMetaDataModel.NodeType( GenericOC ) //{ // NodeTypeName = "Jurisdiction", // Category = "System", // IconFileName = "globe.gif" //} ); //CswNbtMetaDataNodeTypeProp JurisdictionNameNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( JurisdictionNT, TextFT, "Name" ) ); //JurisdictionNT.setNameTemplateText( CswNbtMetaData.MakeTemplateEntry( "Name" ) ); //// Default Jurisdictions //CswNbtNode JurisNorthAmericaNode = _CswNbtSchemaModTrnsctn.Nodes.makeNodeFromNodeTypeId( JurisdictionNT.NodeTypeId, CswNbtNodeCollection.MakeNodeOperation.WriteNode ); //JurisNorthAmericaNode.Properties[JurisdictionNameNTP].AsText.Text = "North America"; //JurisNorthAmericaNode.postChanges( false ); //CswNbtNode JurisEuropeNode = _CswNbtSchemaModTrnsctn.Nodes.makeNodeFromNodeTypeId( JurisdictionNT.NodeTypeId, CswNbtNodeCollection.MakeNodeOperation.WriteNode ); //JurisEuropeNode.Properties[JurisdictionNameNTP].AsText.Text = "Europe"; //JurisEuropeNode.postChanges( false ); // GHS Phrase NodeType CswNbtMetaDataNodeType GHSPhraseNT = _CswNbtSchemaModTrnsctn.MetaData.makeNewNodeType( new CswNbtWcfMetaDataModel.NodeType( GenericOC ) { NodeTypeName = "GHS Phrase", Category = "System", IconFileName = "group.gif" } ); CswNbtMetaDataNodeTypeProp GHSPhraseCodeNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSPhraseNT, TextFT, "Code" ) ); CswNbtMetaDataNodeTypeProp GHSPhraseCategoryNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSPhraseNT, ListFT, "Category" ) ); CswNbtMetaDataNodeTypeProp GHSPhraseEnglishNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSPhraseNT, TextFT, "English" ) ); CswNbtMetaDataNodeTypeProp GHSPhraseChineseNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSPhraseNT, TextFT, "Chinese" ) ); CswNbtMetaDataNodeTypeProp GHSPhraseDanishNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSPhraseNT, TextFT, "Danish" ) ); CswNbtMetaDataNodeTypeProp GHSPhraseDutchNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSPhraseNT, TextFT, "Dutch" ) ); CswNbtMetaDataNodeTypeProp GHSPhraseFrenchNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSPhraseNT, TextFT, "French" ) ); CswNbtMetaDataNodeTypeProp GHSPhraseGermanNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSPhraseNT, TextFT, "German" ) ); CswNbtMetaDataNodeTypeProp GHSPhraseSpanishNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSPhraseNT, TextFT, "Spanish" ) ); GHSPhraseCategoryNTP.ListOptions = "Physical,Health,Environmental"; GHSPhraseNT.setNameTemplateText( CswNbtMetaData.MakeTemplateEntry( "Code" ) ); _CswNbtSchemaModTrnsctn.createModuleNodeTypeJunction( CswNbtResources.CswNbtModule.CISPro, GHSPhraseNT.NodeTypeId ); // GHS NodeType CswNbtMetaDataNodeType GHSNT = _CswNbtSchemaModTrnsctn.MetaData.makeNewNodeType( new CswNbtWcfMetaDataModel.NodeType( GenericOC ) { NodeTypeName = "GHS", Category = "Materials", IconFileName = "ball_redS.gif" } ); CswNbtMetaDataNodeTypeProp GHSTypeNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSNT, ListFT, "Type" ) { IsRequired = true } ); CswNbtMetaDataNodeTypeProp GHSMaterialNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSNT, RelationshipFT, "Material" ) { IsRequired = true } ); CswNbtMetaDataNodeTypeProp GHSGHSPhraseNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSNT, RelationshipFT, "GHS Phrase" ) { IsRequired = true } ); //CswNbtMetaDataNodeTypeProp GHSJurisdictionNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSNT, RelationshipFT, "Jurisdiction" ) { IsRequired = true } ); CswNbtMetaDataNodeTypeProp GHSJurisdictionNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GHSNT, ListFT, "Jurisdiction" ) { IsRequired = true } ); GHSTypeNTP.ListOptions = "Class Code, Label Code"; GHSMaterialNTP.SetFK( NbtViewRelatedIdType.ObjectClassId.ToString(), MaterialOC.ObjectClassId ); GHSGHSPhraseNTP.SetFK( NbtViewRelatedIdType.NodeTypeId.ToString(), GHSPhraseNT.NodeTypeId ); //GHSJurisdictionNTP.SetFK( NbtViewRelatedIdType.NodeTypeId.ToString(), JurisdictionNT.NodeTypeId ); GHSJurisdictionNTP.ListOptions = "North America, China, Europe, Japan"; _CswNbtSchemaModTrnsctn.createModuleNodeTypeJunction( CswNbtResources.CswNbtModule.CISPro, GHSNT.NodeTypeId ); // Chemical GHS Tab CswNbtMetaDataNodeType ChemicalNT = _CswNbtSchemaModTrnsctn.MetaData.getNodeType( "Chemical" ); if( null != ChemicalNT ) { foreach( CswNbtMetaDataNodeTypeTab Tab in ChemicalNT.getNodeTypeTabs() ) { if( Tab.TabOrder >= 3 ) Tab.TabOrder += 1; } CswNbtMetaDataNodeTypeTab GHSTab = ChemicalNT.getNodeTypeTab( "GHS" ); if( null == GHSTab ) { GHSTab = _CswNbtSchemaModTrnsctn.MetaData.makeNewTab( ChemicalNT, "GHS", 3 ); } GHSTab.TabOrder = 3; // Chemical GHS properties CswNbtMetaDataNodeTypeProp ChemicalGHSClassificationNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( ChemicalNT, ListFT, "GHS Classification" ) ); CswNbtMetaDataNodeTypeProp ChemicalGHSClassCodesNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( ChemicalNT, GridFT, "GHS Class Codes" ) ); CswNbtMetaDataNodeTypeProp ChemicalGHSSignalWordNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( ChemicalNT, ListFT, "GHS Signal Word" ) ); CswNbtMetaDataNodeTypeProp ChemicalGHSLabelCodesNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( ChemicalNT, GridFT, "GHS Label Codes" ) ); CswNbtMetaDataNodeTypeProp ChemicalGHSPictosNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( ChemicalNT, ImageListFT, "GHS Pictos" ) ); CswCommaDelimitedString GHSClasses = new CswCommaDelimitedString(){ "Category 1", "Category 1 / 1A / 1B", "Category 1A", "Category 1A / 1B", "Category 1A / 1B / 1C", "Category 1B", "Category 2", "Category 2 (skin)/2A (eye)", "Category 2A", "Category 2B", "Category 3", "Category 4", "Category 5", "Type A", "Type B", "Type C&D", "Type E&F", "Compressed Gas", "Liquified Gas", "Dissolved Gas", "Refridgerated Liquidified Gas" }; ChemicalGHSClassificationNTP.ListOptions = GHSClasses.ToString(); ChemicalGHSSignalWordNTP.ListOptions = "Danger,Warning"; ChemicalGHSClassificationNTP.removeFromLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add ); ChemicalGHSClassCodesNTP.removeFromLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add ); ChemicalGHSSignalWordNTP.removeFromLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add ); ChemicalGHSLabelCodesNTP.removeFromLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add ); ChemicalGHSPictosNTP.removeFromLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add ); ChemicalGHSClassificationNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GHSTab.TabId, 1, 1, "Hazard Classification" ); ChemicalGHSClassCodesNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GHSTab.TabId, 2, 1, "Hazard Classification" ); ChemicalGHSSignalWordNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GHSTab.TabId, 3, 1, "Hazard Label" ); ChemicalGHSLabelCodesNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GHSTab.TabId, 4, 1, "Hazard Label" ); ChemicalGHSPictosNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GHSTab.TabId, 5, 1, "Hazard Label" ); // Grid Views CswNbtView GHSClassCodesView = _CswNbtSchemaModTrnsctn.restoreView( ChemicalGHSClassCodesNTP.ViewId ); GHSClassCodesView.Root.ChildRelationships.Clear(); CswNbtViewRelationship ChemicalVR1 = GHSClassCodesView.AddViewRelationship( ChemicalNT, false ); CswNbtViewRelationship GHSVR1 = GHSClassCodesView.AddViewRelationship( ChemicalVR1, NbtViewPropOwnerType.Second, GHSMaterialNTP, true ); CswNbtViewRelationship GHSPhraseVR1 = GHSClassCodesView.AddViewRelationship( GHSVR1, NbtViewPropOwnerType.First, GHSGHSPhraseNTP, true ); GHSClassCodesView.AddViewProperty( GHSPhraseVR1, GHSPhraseCodeNTP ); GHSClassCodesView.AddViewProperty( GHSPhraseVR1, GHSPhraseCategoryNTP ); GHSClassCodesView.AddViewProperty( GHSPhraseVR1, GHSPhraseEnglishNTP ); GHSClassCodesView.AddViewProperty( GHSPhraseVR1, GHSPhraseChineseNTP ); GHSClassCodesView.AddViewProperty( GHSPhraseVR1, GHSPhraseDanishNTP ); GHSClassCodesView.AddViewProperty( GHSPhraseVR1, GHSPhraseDutchNTP ); GHSClassCodesView.AddViewProperty( GHSPhraseVR1, GHSPhraseFrenchNTP ); GHSClassCodesView.AddViewProperty( GHSPhraseVR1, GHSPhraseGermanNTP ); GHSClassCodesView.AddViewProperty( GHSPhraseVR1, GHSPhraseSpanishNTP ); GHSClassCodesView.AddViewPropertyAndFilter( GHSVR1, GHSTypeNTP, Value: "Class Code" ); GHSClassCodesView.AddViewPropertyAndFilter( GHSVR1, GHSJurisdictionNTP, Value: "North America", ShowAtRuntime: true ); GHSClassCodesView.save(); CswNbtView GHSLabelCodesView = _CswNbtSchemaModTrnsctn.restoreView( ChemicalGHSLabelCodesNTP.ViewId ); GHSLabelCodesView.Root.ChildRelationships.Clear(); CswNbtViewRelationship ChemicalVR2 = GHSLabelCodesView.AddViewRelationship( ChemicalNT, false ); CswNbtViewRelationship GHSVR2 = GHSLabelCodesView.AddViewRelationship( ChemicalVR2, NbtViewPropOwnerType.Second, GHSMaterialNTP, true ); CswNbtViewRelationship GHSPhraseVR2 = GHSLabelCodesView.AddViewRelationship( GHSVR2, NbtViewPropOwnerType.First, GHSGHSPhraseNTP, true ); GHSLabelCodesView.AddViewProperty( GHSPhraseVR2, GHSPhraseCodeNTP ); GHSLabelCodesView.AddViewProperty( GHSPhraseVR2, GHSPhraseCategoryNTP ); GHSLabelCodesView.AddViewProperty( GHSPhraseVR2, GHSPhraseEnglishNTP ); GHSLabelCodesView.AddViewProperty( GHSPhraseVR2, GHSPhraseChineseNTP ); GHSLabelCodesView.AddViewProperty( GHSPhraseVR2, GHSPhraseDanishNTP ); GHSLabelCodesView.AddViewProperty( GHSPhraseVR2, GHSPhraseDutchNTP ); GHSLabelCodesView.AddViewProperty( GHSPhraseVR2, GHSPhraseFrenchNTP ); GHSLabelCodesView.AddViewProperty( GHSPhraseVR2, GHSPhraseGermanNTP ); GHSLabelCodesView.AddViewProperty( GHSPhraseVR2, GHSPhraseSpanishNTP ); GHSLabelCodesView.AddViewPropertyAndFilter( GHSVR2, GHSTypeNTP, Value: "Label Code" ); GHSLabelCodesView.AddViewPropertyAndFilter( GHSVR2, GHSJurisdictionNTP, Value: "North America", ShowAtRuntime: true ); GHSLabelCodesView.save(); // Picto Options ChemicalGHSPictosNTP.Extended = "true"; // allow multiple values ChemicalGHSPictosNTP.TextAreaColumns = 100; ChemicalGHSPictosNTP.TextAreaRows = 100; CswDelimitedString PictoNames = new CswDelimitedString( '\n' ) { "Chemical", "Explosive", "Flammable", "Natural", "Oxidizer", "Danger", "X" }; CswDelimitedString PictoPaths = new CswDelimitedString( '\n' ) { //"Images/cispro/1-1.gif", //"Images/cispro/1-2.gif", //"Images/cispro/1-3.gif", //"Images/cispro/1-4.gif", //"Images/cispro/1-5.gif", //"Images/cispro/1-6.gif", //"Images/cispro/5-2.gif", "Images/cispro/acide.gif", //"Images/cispro/acide2.gif", //"Images/cispro/blan-red.gif", //"Images/cispro/bleu4.gif", //"Images/cispro/bleu4-noir.gif", "Images/cispro/bottle.gif", "Images/cispro/exclam.gif", "Images/cispro/explos.gif", "Images/cispro/flamme.gif", //"Images/cispro/jaune5-1.gif", "Images/cispro/pollu.gif", "Images/cispro/rondflam.gif", //"Images/cispro/rouge2.gif", //"Images/cispro/rouge2_noir.gif", //"Images/cispro/rouge3.gif", //"Images/cispro/rouge3_noir.gif", "Images/cispro/silouete.gif", "Images/cispro/skull.gif" //"Images/cispro/skull_2.gif", //"Images/cispro/skull6.gif", //"Images/cispro/stripes.gif", //"Images/cispro/vert.gif" }; ChemicalGHSPictosNTP.ListOptions = PictoNames.ToString(); ChemicalGHSPictosNTP.ValueOptions = PictoPaths.ToString(); } //GHS Phrase nodes Dictionary<Int32, string> GHSPhraseCodes = new Dictionary<Int32, string>(); //Physical GHSPhraseCodes.Add( 200, "Unstable explosive" ); GHSPhraseCodes.Add( 201, "Explosive; mass explosion hazard" ); GHSPhraseCodes.Add( 202, "Explosive; severe projection hazard" ); GHSPhraseCodes.Add( 203, "Explosive; fire, blast or projection hazard" ); GHSPhraseCodes.Add( 204, "Fire or projection hazard" ); GHSPhraseCodes.Add( 205, "May mass explode in fire" ); GHSPhraseCodes.Add( 220, "Extremely flammable gas" ); GHSPhraseCodes.Add( 221, "Flammable gas" ); GHSPhraseCodes.Add( 222, "Extremely flammable material" ); GHSPhraseCodes.Add( 223, "Flammable material" ); GHSPhraseCodes.Add( 224, "Extremely flammable liquid and vapour" ); GHSPhraseCodes.Add( 225, "Highly flammable liquid and vapour" ); GHSPhraseCodes.Add( 226, "Flammable liquid and vapour" ); GHSPhraseCodes.Add( 227, "Combustible liquid" ); GHSPhraseCodes.Add( 228, "Flammable solid" ); GHSPhraseCodes.Add( 240, "Heating may cause an explosion" ); GHSPhraseCodes.Add( 241, "Heating may cause a fire or explosion" ); GHSPhraseCodes.Add( 242, "Heating may cause a fire" ); GHSPhraseCodes.Add( 250, "Catches fire spontaneously if exposed to air" ); GHSPhraseCodes.Add( 251, "Self-heating; may catch fire" ); GHSPhraseCodes.Add( 252, "Self-heating in large quantities; may catch fire" ); GHSPhraseCodes.Add( 260, "In contact with water releases flammable gases which may ignite spontaneously" ); GHSPhraseCodes.Add( 261, "In contact with water releases flammable gas" ); GHSPhraseCodes.Add( 270, "May cause or intensify fire; oxidizer" ); GHSPhraseCodes.Add( 271, "May cause fire or explosion; strong oxidizer" ); GHSPhraseCodes.Add( 272, "May intensify fire; oxidizer" ); GHSPhraseCodes.Add( 280, "Contains gas under pressure; may explode if heated" ); GHSPhraseCodes.Add( 281, "Contains refrigerated gas; may cause cryogenic burns or injury" ); GHSPhraseCodes.Add( 290, "May be corrosive to metals" ); //Health GHSPhraseCodes.Add( 300, "Fatal if swallowed" ); GHSPhraseCodes.Add( 301, "Toxic if swallowed" ); GHSPhraseCodes.Add( 302, "Harmful if swallowed" ); GHSPhraseCodes.Add( 303, "May be harmful if swallowed" ); GHSPhraseCodes.Add( 304, "May be fatal if swallowed and enters airways" ); GHSPhraseCodes.Add( 305, "May be harmful if swallowed and enters airways" ); GHSPhraseCodes.Add( 310, "Fatal in contact with skin" ); GHSPhraseCodes.Add( 311, "Toxic in contact with skin" ); GHSPhraseCodes.Add( 312, "Harmful in contact with skin" ); GHSPhraseCodes.Add( 313, "May be harmful in contact with skin" ); GHSPhraseCodes.Add( 314, "Causes severe skin burns and eye damage" ); GHSPhraseCodes.Add( 315, "Causes skin irritation" ); GHSPhraseCodes.Add( 316, "Causes mild skin irritation" ); GHSPhraseCodes.Add( 317, "May cause an allergic skin reaction" ); GHSPhraseCodes.Add( 318, "Causes serious eye damage" ); GHSPhraseCodes.Add( 319, "Causes serious eye irritation" ); GHSPhraseCodes.Add( 320, "Causes eye irritation" ); GHSPhraseCodes.Add( 330, "Fatal if inhaled" ); GHSPhraseCodes.Add( 331, "Toxic if inhaled" ); GHSPhraseCodes.Add( 332, "Harmful if inhaled" ); GHSPhraseCodes.Add( 333, "May be harmful if inhaled" ); GHSPhraseCodes.Add( 334, "May cause allergy or asthma symptoms of breathing difficulties if inhaled" ); GHSPhraseCodes.Add( 335, "May cause respiratory irritation" ); GHSPhraseCodes.Add( 336, "May cause drowsiness or dizziness" ); GHSPhraseCodes.Add( 340, "May cause genetic defects" ); GHSPhraseCodes.Add( 341, "Suspected of causing genetic defects" ); GHSPhraseCodes.Add( 350, "May cause cancer" ); GHSPhraseCodes.Add( 351, "Suspected of causing cancer" ); GHSPhraseCodes.Add( 360, "May damage fertility or the unborn child" ); GHSPhraseCodes.Add( 361, "Suspected of damaging fertility or the unborn child" ); GHSPhraseCodes.Add( 362, "May cause harm to breast-fed children" ); GHSPhraseCodes.Add( 370, "Causes damage to organs" ); GHSPhraseCodes.Add( 371, "May cause damage to organs" ); GHSPhraseCodes.Add( 372, "Causes damage to organs through prolonged or repeated exposure" ); GHSPhraseCodes.Add( 373, "May cause damage to organs through prolonged or repeated exposure" ); // Environmental GHSPhraseCodes.Add( 400, "Very toxic to aquatic life" ); GHSPhraseCodes.Add( 401, "Toxic to aquatic life" ); GHSPhraseCodes.Add( 402, "Harmful to aquatic life" ); GHSPhraseCodes.Add( 410, "Very toxic to aquatic life with long lasting effects" ); GHSPhraseCodes.Add( 411, "Toxic to aquatic life with long lasting effects" ); GHSPhraseCodes.Add( 412, "Harmful to aquatic life with long lasting effects" ); GHSPhraseCodes.Add( 413, "May cause long lasting harmful effects to aquatic life" ); foreach( Int32 Code in GHSPhraseCodes.Keys ) { string Category = "Physical"; if( Code > 299 ) { Category = "Health"; } else if( Code > 399 ) { Category = "Environmental"; } CswNbtNode GHSPhraseNode = _CswNbtSchemaModTrnsctn.Nodes.makeNodeFromNodeTypeId( GHSPhraseNT.NodeTypeId, CswNbtNodeCollection.MakeNodeOperation.WriteNode ); GHSPhraseNode.Properties[GHSPhraseCodeNTP].AsText.Text = "H" + Code.ToString(); GHSPhraseNode.Properties[GHSPhraseCategoryNTP].AsList.Value = Category; GHSPhraseNode.Properties[GHSPhraseEnglishNTP].AsText.Text = GHSPhraseCodes[Code]; GHSPhraseNode.postChanges( false ); } // foreach( Int32 Code in GHSPhraseCodes.Keys ) }//Update()
public CswNbtViewRoot(CswNbtResources CswNbtResources, CswNbtView View, CswDelimitedString RootString) : base(CswNbtResources, View) { _RootString = RootString; _RootString.OnChange += new CswDelimitedString.DelimitedStringChangeHandler(_RootString_OnChange); if (ViewNodeType != CswEnumNbtViewNodeType.CswNbtViewRoot) { throw new CswDniException(CswEnumErrorType.Error, "Invalid View Root", "CswNbtViewRoot was given an invalid RootString: " + RootString.ToString()); } }
public override void update() { // add some objclass calls CswNbtMetaDataObjectClassProp locCodeOcp = _CswNbtSchemaModTrnsctn.createObjectClassProp( CswNbtMetaDataObjectClass.NbtObjectClass.LocationClass, "Location Code", CswNbtMetaDataFieldType.NbtFieldType.Text, IsUnique: true ); CswNbtMetaDataObjectClassProp allowInvOcp = _CswNbtSchemaModTrnsctn.createObjectClassProp( CswNbtMetaDataObjectClass.NbtObjectClass.LocationClass, "Allow Inventory", CswNbtMetaDataFieldType.NbtFieldType.Logical ); CswNbtMetaDataObjectClassProp storCompatOcp = _CswNbtSchemaModTrnsctn.createObjectClassProp( CswNbtMetaDataObjectClass.NbtObjectClass.LocationClass, "Storage Compatability", CswNbtMetaDataFieldType.NbtFieldType.ImageList ); CswDelimitedString listOpts = new CswDelimitedString( '\n' ); listOpts.FromArray( new string[] { "None", "Inorganic Acids", "Organic Acids", "Bases", "Oxidizing Inorganic Acids", "Oxidizers", "Toxics", "Flammables" } ); // storCompatOcp.ListOptions = listOpts.ToString(); _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( storCompatOcp, CswNbtMetaDataObjectClassProp.ObjectClassPropAttributes.listoptions, listOpts.ToString() ); CswDelimitedString valOpts = new CswDelimitedString( '\n' ); valOpts.FromArray( new string[] { "Images/cispro/0w.gif", "Images/cispro/1o.gif", "Images/cispro/2y.gif", "Images/cispro/3g.gif", "Images/cispro/4b.gif", "Images/cispro/5l.gif", "Images/cispro/6p.gif", "Images/cispro/7r.gif" } ); _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( storCompatOcp, CswNbtMetaDataObjectClassProp.ObjectClassPropAttributes.valueoptions, valOpts.ToString() ); _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( storCompatOcp, CswNbtMetaDataObjectClassProp.ObjectClassPropAttributes.textarearows, "32" ); _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( storCompatOcp, CswNbtMetaDataObjectClassProp.ObjectClassPropAttributes.textareacols, "32" ); }//Update()
public override void update() { #region Create DSD Phrase OC CswNbtMetaDataObjectClass DSDPhraseOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswEnumNbtObjectClass.DSDPhraseClass ); if( null == DSDPhraseOC ) { DSDPhraseOC = _CswNbtSchemaModTrnsctn.createObjectClass( CswEnumNbtObjectClass.DSDPhraseClass, "warning.png", false ); _CswNbtSchemaModTrnsctn.createObjectClassProp( DSDPhraseOC, new CswNbtWcfMetaDataModel.ObjectClassProp( DSDPhraseOC ) { PropName = CswNbtObjClassDSDPhrase.PropertyName.Code, FieldType = CswEnumNbtFieldType.Text } ); _CswNbtSchemaModTrnsctn.createObjectClassProp( DSDPhraseOC, new CswNbtWcfMetaDataModel.ObjectClassProp( DSDPhraseOC ) { PropName = CswNbtObjClassDSDPhrase.PropertyName.Category, FieldType = CswEnumNbtFieldType.List, ListOptions = "Risk,Safety,Hazard" } ); foreach( string Language in CswNbtPropertySetPhrase.SupportedLanguages.All ) { _CswNbtSchemaModTrnsctn.createObjectClassProp( DSDPhraseOC, new CswNbtWcfMetaDataModel.ObjectClassProp( DSDPhraseOC ) { PropName = Language, FieldType = CswEnumNbtFieldType.Text } ); } } #endregion #region Create DSD Chemical Props CswNbtMetaDataObjectClass ChemicalOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswEnumNbtObjectClass.ChemicalClass ); const string _pre = "Images/cispro/DSD/"; CswDelimitedString dsdImgs = new CswDelimitedString( '\n' ) { _pre + "none.gif", _pre + "e.gif", _pre + "o.gif", _pre + "f.gif", _pre + "f_plus.gif", _pre + "t.gif", _pre + "t_plus.gif", _pre + "xn.gif", _pre + "xi.gif", _pre + "c.gif", _pre + "n.gif" }; CswDelimitedString dsdValues = new CswDelimitedString( '\n' ) { "None","Explosive","Oxidizing","Highly flammable","Extremely flammable","Toxic","Very Toxic","Harmful","Irritant","Corrosive","Dangerous for the environment" }; CswNbtMetaDataObjectClassProp PictorgramsOCP = ChemicalOC.getObjectClassProp( CswNbtObjClassChemical.PropertyName.Pictograms ) ?? _CswNbtSchemaModTrnsctn.createObjectClassProp( ChemicalOC, new CswNbtWcfMetaDataModel.ObjectClassProp( ChemicalOC ) { PropName = CswNbtObjClassChemical.PropertyName.Pictograms, FieldType = CswEnumNbtFieldType.ImageList, ListOptions = dsdValues.ToString(), ValueOptions = dsdImgs.ToString(), Extended = true.ToString() } ); CswNbtMetaDataObjectClassProp LabelCodesOCP = ChemicalOC.getObjectClassProp( CswNbtObjClassChemical.PropertyName.LabelCodes ) ?? _CswNbtSchemaModTrnsctn.createObjectClassProp( ChemicalOC, new CswNbtWcfMetaDataModel.ObjectClassProp( ChemicalOC ) { PropName = CswNbtObjClassChemical.PropertyName.LabelCodes, FieldType = CswEnumNbtFieldType.MultiList, ListOptions = "" //Intentionally empty - will be dynamic } ); CswNbtView DSDLabelCodesView = _CswNbtSchemaModTrnsctn.makeSafeView( "DSD Label Codes Property Grid", CswEnumNbtViewVisibility.Hidden ); DSDLabelCodesView.SetViewMode( CswEnumNbtViewRenderingMode.Grid ); DSDLabelCodesView.AddViewRelationship( DSDPhraseOC, false ); DSDLabelCodesView.save(); CswNbtMetaDataObjectClassProp LabelCodesGridOCP = ChemicalOC.getObjectClassProp( CswNbtObjClassChemical.PropertyName.LabelCodesGrid ) ?? _CswNbtSchemaModTrnsctn.createObjectClassProp( ChemicalOC, new CswNbtWcfMetaDataModel.ObjectClassProp( ChemicalOC ) { PropName = CswNbtObjClassChemical.PropertyName.LabelCodesGrid, FieldType = CswEnumNbtFieldType.Grid, ViewXml = DSDLabelCodesView.ToString(), Extended = "Small" } ); #endregion } // update()
/// <summary> /// Convert the NodeKey information into a delimited string /// </summary> public override string ToString() { return(_DelimitedString.ToString()); }
public override void update() { // Fix graphics URLs for Storage Compatibility (remove "/NbtWebApp") CswDelimitedString ImageUrls = new CswDelimitedString( '\n' ) { "Images/cispro/0w.gif", "Images/cispro/1o.gif", "Images/cispro/2y.gif", "Images/cispro/3g.gif", "Images/cispro/4b.gif", "Images/cispro/5l.gif", "Images/cispro/6p.gif", "Images/cispro/7r.gif" }; CswNbtMetaDataObjectClass ChemicalOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswEnumNbtObjectClass.ChemicalClass ); CswNbtMetaDataObjectClass LocationOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswEnumNbtObjectClass.LocationClass ); CswNbtMetaDataObjectClassProp ChemStorCompatOCP = ChemicalOC.getObjectClassProp( CswNbtObjClassChemical.PropertyName.StorageCompatibility ); CswNbtMetaDataObjectClassProp LocStorCompatOCP = LocationOC.getObjectClassProp( CswNbtObjClassLocation.PropertyName.StorageCompatibility ); _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( ChemStorCompatOCP, CswEnumNbtObjectClassPropAttributes.valueoptions, ImageUrls.ToString() ); _CswNbtSchemaModTrnsctn.MetaData.UpdateObjectClassProp( LocStorCompatOCP, CswEnumNbtObjectClassPropAttributes.valueoptions, ImageUrls.ToString() ); }//Update()
public override void update() { // Fix DSD Picto Paths CswNbtMetaDataObjectClass ChemicalOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswEnumNbtObjectClass.ChemicalClass ); foreach( CswNbtMetaDataNodeType ChemicalNT in ChemicalOC.getNodeTypes() ) { CswDelimitedString PictoPaths = new CswDelimitedString( '\n' ) { "Images/cispro/DSD/512/none.gif", "Images/cispro/DSD/512/e.gif", "Images/cispro/DSD/512/o.gif", "Images/cispro/DSD/512/f.gif", "Images/cispro/DSD/512/f_plus.gif", "Images/cispro/DSD/512/t.gif", "Images/cispro/DSD/512/t_plus.gif", "Images/cispro/DSD/512/xn.gif", "Images/cispro/DSD/512/xi.gif", "Images/cispro/DSD/512/c.gif", "Images/cispro/DSD/512/n.gif" }; CswNbtMetaDataNodeTypeProp PictogramsNTP = ChemicalNT.getNodeTypePropByObjectClassProp( CswNbtObjClassChemical.PropertyName.Pictograms ); PictogramsNTP.DesignNode.AttributeProperty[CswNbtFieldTypeRuleImageList.AttributeName.ImageUrls].AsMemo.Text = PictoPaths.ToString(); PictogramsNTP.DesignNode.AttributeProperty[CswNbtFieldTypeRuleImageList.AttributeName.HeightInPixels].AsNumber.Value = 77; PictogramsNTP.DesignNode.AttributeProperty[CswNbtFieldTypeRuleImageList.AttributeName.WidthInPixels].AsNumber.Value = 77; PictogramsNTP.DesignNode.postChanges( false ); foreach( CswNbtObjClassChemical ChemicalNode in ChemicalNT.getNodes( false, true ) ) { CswDelimitedString oldVals = ChemicalNode.Pictograms.Value; CswDelimitedString newVals = new CswDelimitedString( CswNbtNodePropImageList.Delimiter ); foreach( string oldVal in oldVals ) { if( oldVal.IndexOf( "/DSD/" ) >= 0 && oldVal.IndexOf( "/DSD/512" ) == 0 ) { newVals.Add( oldVal.Replace( "/DSD/", "/DSD/512/" ) ); } else { newVals.Add( oldVal ); } } ChemicalNode.Pictograms.Value = newVals; ChemicalNode.postChanges( false ); } // foreach( CswNbtObjClassChemical ChemicalNode in ChemicalNT.getNodes( false, true ) ) } // foreach( CswNbtMetaDataNodeType ChemicalNT in ChemicalOC.getNodeTypes() ) // Example DSD Print Label CswNbtMetaDataObjectClass ContainerOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswEnumNbtObjectClass.ContainerClass ); CswNbtMetaDataObjectClass PrintLabelOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( CswEnumNbtObjectClass.PrintLabelClass ); if( null != PrintLabelOC ) { CswNbtMetaDataNodeType PrintLabelNT = PrintLabelOC.FirstNodeType; if( null != PrintLabelNT ) { CswNbtObjClassPrintLabel DsdLabel = _CswNbtSchemaModTrnsctn.Nodes.makeNodeFromNodeTypeId( PrintLabelNT.NodeTypeId ); DsdLabel.LabelName.Text = "Example DSD Label"; if( null != ContainerOC ) { foreach(CswNbtMetaDataNodeType ContainerNT in ContainerOC.getNodeTypes()) { DsdLabel.NodeTypes.SelectedNodeTypeIds.Add( ContainerNT.NodeTypeId.ToString() ); } } DsdLabel.EplText.Text = @"I8,0,001 S2 OD JF WN D12 ZB q375 N A25,15,0,2,1,1,N,""{Material}"" B25,45,0,1,3,6,40,N,""{Barcode}"" A25,80,0,2,1,1,N,""{Barcode}"" A25,130,0,2,1,1,N,""{NBTDSDB}"" GW0,160,{NBTDSDPICTOS} GW128,160,{NBTDSDPICTOS_2} GW256,160,{NBTDSDPICTOS_3} P1"; DsdLabel.postChanges( false ); } } } // update()
} //getDemoDataGrid() public static void getDemoDataNodesAsGrid(ICswResources CswResources, CswNbtDemoDataReturn Return, CswNbtDemoDataRequests.CswDemoNodesGridRequest Request) { CswNbtResources CswNbtResources = (CswNbtResources)CswResources; //Build table infrastructure DataTable GridTable = new DataTable("depdendentnodestable"); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.NodeId, typeof(Int32)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.Name, typeof(string)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.Type, typeof(string)); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.IsDemo, typeof(string)); // GridTable.Columns.Add( CswNbtDemoDataReturn.ColumnNames.Action, typeof( sbyte ) ); GridTable.Columns.Add(CswNbtDemoDataReturn.ColumnNames.MenuOptions, typeof(string)); string DependentNodesQuery = "select n.nodeid, t.nodetypeid, n.nodename as \"name\" ,n.isdemo \"Is Demo\", t.nodetypename as \"type\" "; DependentNodesQuery += "from nodes n "; DependentNodesQuery += "join nodetypes t on (n.nodetypeid=t.nodetypeid) "; //We have to cope with oracle's limit of 1000 on lists //as per case 29811 DependentNodesQuery += " where "; List <string> AllNodeIds = Request.NodeIds; int NumberoFInClauses = (AllNodeIds.Count / 1000) + 1; //we _only_ want the whole-number result here for (int idx = 0; idx < NumberoFInClauses; idx++) { if (idx > 0) { DependentNodesQuery += " or "; } List <string> CurrentList = null; if (AllNodeIds.Count > 1000) { CurrentList = AllNodeIds.GetRange(0, 1000); AllNodeIds.RemoveRange(0, 1000); } else { CurrentList = AllNodeIds; } CswDelimitedString DepdendentNodeIds = new CswDelimitedString(','); DepdendentNodeIds.FromArray(CurrentList.ToArray()); DependentNodesQuery += " n.nodeid in (" + DepdendentNodeIds.ToString() + ") "; } DependentNodesQuery += "order by lower(n.nodename), lower(t.nodetypename)"; CswArbitrarySelect DependentNodesSelect = CswNbtResources.makeCswArbitrarySelect("select_depdendent_nodes", DependentNodesQuery); DataTable DepdendentNodesTableTable = DependentNodesSelect.getTable(); foreach (DataRow CurrentDependentNodeRow in DepdendentNodesTableTable.Rows) { DataRow NewGridRowOfDependentNodes = GridTable.NewRow(); GridTable.Rows.Add(NewGridRowOfDependentNodes); NewGridRowOfDependentNodes[CswNbtDemoDataReturn.ColumnNames.NodeId] = CurrentDependentNodeRow[CswNbtDemoDataReturn.ColumnNames.NodeId]; NewGridRowOfDependentNodes[CswNbtDemoDataReturn.ColumnNames.Name] = CurrentDependentNodeRow[CswNbtDemoDataReturn.ColumnNames.Name]; NewGridRowOfDependentNodes[CswNbtDemoDataReturn.ColumnNames.Type] = CurrentDependentNodeRow[CswNbtDemoDataReturn.ColumnNames.Type]; NewGridRowOfDependentNodes[CswNbtDemoDataReturn.ColumnNames.IsDemo] = ("1" == CurrentDependentNodeRow[CswNbtDemoDataReturn.ColumnNames.IsDemo].ToString()) ? "yes" : "no"; CswPrimaryKey cswPrimaryKey = new CswPrimaryKey(); cswPrimaryKey.FromString("nodes_" + CurrentDependentNodeRow[CswNbtDemoDataReturn.ColumnNames.NodeId].ToString()); CswNbtNodeKey CswNbtNodeKey = new CswNbtNodeKey(); CswNbtNodeKey.NodeId = cswPrimaryKey; CswNbtNodeKey.NodeTypeId = CswConvert.ToInt32(CurrentDependentNodeRow["nodetypeid"]); string menu_options = "{ "; menu_options += "\"nodeid\" : \"nodes_" + CurrentDependentNodeRow[CswNbtDemoDataReturn.ColumnNames.NodeId].ToString() + "\","; menu_options += "\"nodename\" : \" " + CurrentDependentNodeRow[CswNbtDemoDataReturn.ColumnNames.Name].ToString() + "\","; menu_options += "\"nodekey\" : \" " + CswNbtNodeKey.ToString() + "\""; menu_options += " }"; NewGridRowOfDependentNodes[CswNbtDemoDataReturn.ColumnNames.MenuOptions] = menu_options; }//iterate result rows CswNbtGrid Grid = new CswNbtGrid(CswNbtResources); Return.Data.Grid = Grid.DataTableToGrid(GridTable, IncludeEditFields: false); }//getDemoDataNodesAsGrid()
public override void SyncGestalt() { CswDelimitedString NewGestalt = new CswDelimitedString(Delimiter); foreach (string Key in Value) { if (Options.ContainsKey(Key)) { NewGestalt.Add(Options[Key]); } } SetPropRowValue(CswEnumNbtSubFieldName.Gestalt, CswEnumNbtPropColumn.Gestalt, NewGestalt.ToString()); } // _setGestalt()
public override void update() { // Jurisdiction Nodes CswNbtMetaDataObjectClass JurisdictionOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( NbtObjectClass.JurisdictionClass ); CswNbtMetaDataNodeType JurisdictionNT = JurisdictionOC.FirstNodeType; if( null != JurisdictionNT ) { StringCollection Jurisdictions = new StringCollection { "North America", "China", "Europe", "Japan" }; foreach( string j in Jurisdictions ) { CswNbtObjClassJurisdiction jNode = _CswNbtSchemaModTrnsctn.Nodes.makeNodeFromNodeTypeId( JurisdictionNT.NodeTypeId, CswNbtNodeCollection.MakeNodeOperation.WriteNode ); jNode.Name.Text = j; jNode.postChanges( false ); } } //CswNbtMetaDataObjectClass GhsOC = _CswNbtSchemaModTrnsctn.MetaData.getObjectClass( NbtObjectClass.GHSClass ); //CswNbtMetaDataObjectClassProp GhsMaterialOCP = GhsOC.getObjectClassProp( CswNbtObjClassGHS.PropertyName.Material ); //CswNbtMetaDataObjectClassProp GhsJurisdictionOCP = GhsOC.getObjectClassProp( CswNbtObjClassGHS.PropertyName.Jurisdiction ); //CswNbtMetaDataObjectClassProp GhsLabelCodesOCP = GhsOC.getObjectClassProp( CswNbtObjClassGHS.PropertyName.LabelCodes ); //CswNbtMetaDataObjectClassProp GhsSignalWordOCP = GhsOC.getObjectClassProp( CswNbtObjClassGHS.PropertyName.SignalWord ); // Chemical GHS tab CswNbtMetaDataNodeType ChemicalNT = _CswNbtSchemaModTrnsctn.MetaData.getNodeType( "Chemical" ); if( null != ChemicalNT ) { //CswNbtMetaDataNodeTypeTab ChemicalGhsTab = ChemicalNT.getNodeTypeTab( "GHS" ) ?? _CswNbtSchemaModTrnsctn.MetaData.makeNewTab( ChemicalNT, "GHS", 3 ); // Clear out old GHS tab _CswNbtSchemaModTrnsctn.MetaData.DeleteNodeTypeProp( ChemicalNT.getNodeTypeProp( "GHS Classification" ) ); _CswNbtSchemaModTrnsctn.MetaData.DeleteNodeTypeProp( ChemicalNT.getNodeTypeProp( "GHS Class Codes" ) ); _CswNbtSchemaModTrnsctn.MetaData.DeleteNodeTypeProp( ChemicalNT.getNodeTypeProp( "GHS Signal Word" ) ); _CswNbtSchemaModTrnsctn.MetaData.DeleteNodeTypeProp( ChemicalNT.getNodeTypeProp( "GHS Label Codes" ) ); _CswNbtSchemaModTrnsctn.MetaData.DeleteNodeTypeProp( ChemicalNT.getNodeTypeProp( "GHS Pictos" ) ); //// Add a new grid //CswNbtMetaDataNodeTypeProp ChemicalGhsGridNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( ChemicalNT, _CswNbtSchemaModTrnsctn.MetaData.getFieldType( CswNbtMetaDataFieldType.NbtFieldType.Grid ), "GHS" ) ); //CswNbtView ChemicalGhsGridView = _CswNbtSchemaModTrnsctn.restoreView( ChemicalGhsGridNTP.ViewId ); //ChemicalGhsGridView.Root.ChildRelationships.Clear(); //CswNbtViewRelationship ChemRel = ChemicalGhsGridView.AddViewRelationship( ChemicalNT, false ); //CswNbtViewRelationship GhsRel = ChemicalGhsGridView.AddViewRelationship( ChemRel, NbtViewPropOwnerType.Second, GhsMaterialOCP, true ); //CswNbtViewProperty JurisVP = ChemicalGhsGridView.AddViewProperty( GhsRel, GhsJurisdictionOCP ); //CswNbtViewProperty SignalVP = ChemicalGhsGridView.AddViewProperty( GhsRel, GhsSignalWordOCP ); //CswNbtViewProperty LabelVP = ChemicalGhsGridView.AddViewProperty( GhsRel, GhsLabelCodesOCP ); //JurisVP.Order = 1; //SignalVP.Order = 2; //LabelVP.Order = 3; //ChemicalGhsGridView.save(); //ChemicalGhsGridNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, ChemicalGhsTab.TabId ); } // if(null != ChemicalNT) CswNbtMetaDataNodeType GhsNT = _CswNbtSchemaModTrnsctn.MetaData.getNodeType( "GHS" ); if( null != GhsNT ) { // Tabs CswNbtMetaDataNodeTypeTab GhsGhsTab = GhsNT.getNodeTypeTab( "GHS" ) ?? _CswNbtSchemaModTrnsctn.MetaData.makeNewTab( GhsNT, "GHS", 1 ); // Properties CswNbtMetaDataNodeTypeProp GhsJurisdictionNTP = GhsNT.getNodeTypePropByObjectClassProp( CswNbtObjClassGHS.PropertyName.Jurisdiction ); CswNbtMetaDataNodeTypeProp GhsMaterialNTP = GhsNT.getNodeTypePropByObjectClassProp( CswNbtObjClassGHS.PropertyName.Material ); CswNbtMetaDataNodeTypeProp GhsSignalWordNTP = GhsNT.getNodeTypePropByObjectClassProp( CswNbtObjClassGHS.PropertyName.SignalWord ); CswNbtMetaDataNodeTypeProp GhsLabelCodesNTP = GhsNT.getNodeTypePropByObjectClassProp( CswNbtObjClassGHS.PropertyName.LabelCodes ); CswNbtMetaDataNodeTypeProp GhsClassCodesNTP = GhsNT.getNodeTypePropByObjectClassProp( CswNbtObjClassGHS.PropertyName.ClassCodes ); CswNbtMetaDataNodeTypeProp GhsLabelCodesGridNTP = GhsNT.getNodeTypePropByObjectClassProp( CswNbtObjClassGHS.PropertyName.LabelCodesGrid ); CswNbtMetaDataNodeTypeProp GhsClassCodesGridNTP = GhsNT.getNodeTypePropByObjectClassProp( CswNbtObjClassGHS.PropertyName.ClassCodesGrid ); CswNbtMetaDataNodeTypeProp GhsPictogramsNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GhsNT, _CswNbtSchemaModTrnsctn.MetaData.getFieldType( CswNbtMetaDataFieldType.NbtFieldType.ImageList ), "Pictograms" ) ); CswNbtMetaDataNodeTypeProp GhsClassificationNTP = _CswNbtSchemaModTrnsctn.MetaData.makeNewProp( new CswNbtWcfMetaDataModel.NodeTypeProp( GhsNT, _CswNbtSchemaModTrnsctn.MetaData.getFieldType( CswNbtMetaDataFieldType.NbtFieldType.List ), "Classification" ) ); // Property Configuration GhsSignalWordNTP.ListOptions = "Danger,Warning"; GhsSignalWordNTP.IsRequired = true; GhsMaterialNTP.IsRequired = true; GhsMaterialNTP.ReadOnly = true; GhsPictogramsNTP.Extended = "true"; GhsPictogramsNTP.TextAreaColumns = 77; GhsPictogramsNTP.TextAreaRows = 77; CswDelimitedString PictoNames = new CswDelimitedString( '\n' ) { "Oxidizer", "Flammable", "Explosive", "Acute Toxicity (severe)", "Corrosive", "Gases Under Pressure", "Target Organ Toxicity", "Environmental Toxicity", "Irritant" }; CswDelimitedString PictoPaths = new CswDelimitedString( '\n' ) { "Images/cispro/ghs/rondflam.jpg", "Images/cispro/ghs/flamme.jpg", "Images/cispro/ghs/explos.jpg", "Images/cispro/ghs/skull.jpg", "Images/cispro/ghs/acid.jpg", "Images/cispro/ghs/bottle.jpg", "Images/cispro/ghs/silhouet.jpg", "Images/cispro/ghs/pollut.jpg", "Images/cispro/ghs/exclam.jpg" }; GhsPictogramsNTP.ListOptions = PictoNames.ToString(); GhsPictogramsNTP.ValueOptions = PictoPaths.ToString(); GhsLabelCodesGridNTP.Extended = CswNbtNodePropGrid.GridPropMode.Small.ToString(); GhsLabelCodesGridNTP.MaxValue = 10; GhsClassCodesGridNTP.Extended = CswNbtNodePropGrid.GridPropMode.Small.ToString(); GhsClassCodesGridNTP.MaxValue = 10; const string LabelingTabGroup = "Labeling"; const string ClassificationTabGroup = "Classification"; // Add Layout GhsMaterialNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add, true, DisplayRow: 1, DisplayColumn: 1 ); GhsJurisdictionNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add, true, DisplayRow: 2, DisplayColumn: 1 ); GhsSignalWordNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add, true, DisplayRow: 3, DisplayColumn: 1, TabGroup: LabelingTabGroup ); GhsPictogramsNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add, true, DisplayRow: 4, DisplayColumn: 1, TabGroup: LabelingTabGroup ); GhsLabelCodesNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add, true, DisplayRow: 5, DisplayColumn: 1, TabGroup: LabelingTabGroup ); GhsClassificationNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add, true, DisplayRow: 6, DisplayColumn: 1, TabGroup: ClassificationTabGroup ); GhsClassCodesNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add, true, DisplayRow: 7, DisplayColumn: 1, TabGroup: ClassificationTabGroup ); GhsLabelCodesGridNTP.removeFromLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add ); GhsClassCodesGridNTP.removeFromLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Add ); // Preview Layout GhsJurisdictionNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Preview, true, DisplayRow: 1, DisplayColumn: 1 ); GhsSignalWordNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Preview, true, DisplayRow: 2, DisplayColumn: 1 ); GhsPictogramsNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Preview, true, DisplayRow: 3, DisplayColumn: 1 ); GhsLabelCodesNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Preview, true, DisplayRow: 4, DisplayColumn: 1 ); // Edit Layout GhsMaterialNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GhsGhsTab.TabId, DisplayRow: 1, DisplayColumn: 1 ); GhsJurisdictionNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GhsGhsTab.TabId, DisplayRow: 2, DisplayColumn: 1 ); GhsSignalWordNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GhsGhsTab.TabId, DisplayRow: 3, DisplayColumn: 1, TabGroup: LabelingTabGroup ); GhsPictogramsNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GhsGhsTab.TabId, DisplayRow: 4, DisplayColumn: 1, TabGroup: LabelingTabGroup ); GhsLabelCodesNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GhsGhsTab.TabId, DisplayRow: 5, DisplayColumn: 1, TabGroup: LabelingTabGroup ); GhsLabelCodesGridNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GhsGhsTab.TabId, DisplayRow: 6, DisplayColumn: 1, TabGroup: LabelingTabGroup ); GhsClassificationNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GhsGhsTab.TabId, DisplayRow: 7, DisplayColumn: 1, TabGroup: ClassificationTabGroup ); GhsClassCodesNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GhsGhsTab.TabId, DisplayRow: 8, DisplayColumn: 1, TabGroup: ClassificationTabGroup ); GhsClassCodesGridNTP.updateLayout( CswNbtMetaDataNodeTypeLayoutMgr.LayoutType.Edit, true, GhsGhsTab.TabId, DisplayRow: 9, DisplayColumn: 1, TabGroup: ClassificationTabGroup ); } // if( null != GhsNT ) //CswNbtMetaDataNodeType GhsPhraseNT = _CswNbtSchemaModTrnsctn.MetaData.getNodeType( "GHS Phrase" ); //if( null != GhsPhraseNT ) //{ // CswNbtMetaDataNodeTypeProp GhsPhraseCodeNTP = GhsPhraseNT.getNodeTypePropByObjectClassProp( CswNbtObjClassGHSPhrase.PropertyName.Code ); // CswNbtMetaDataNodeTypeProp GhsPhraseEnglishNTP = GhsPhraseNT.getNodeTypeProp( "English" ); // string NameTemplate = CswNbtMetaData.MakeTemplateEntry( GhsPhraseCodeNTP.PropName ) + " "; // if(null != GhsPhraseEnglishNTP) // { // NameTemplate += CswNbtMetaData.MakeTemplateEntry( GhsPhraseEnglishNTP.PropName ); // } // GhsPhraseNT.setNameTemplateText( NameTemplate ); // foreach(CswNbtNode Node in GhsPhraseNT.getNodes( false, false )) // { // Node.postChanges( true ); // } //} // if( null != GhsPhraseNT ) } //Update()
public static CswNbtViewNode makeViewNode( CswNbtResources CswNbtResources, CswNbtView View, CswDelimitedString ViewNodeString ) { CswNbtViewNode newNode = null; CswEnumNbtViewNodeType type = (CswEnumNbtViewNodeType) ViewNodeString[0]; if( type == CswEnumNbtViewNodeType.CswNbtViewRelationship ) { newNode = new CswNbtViewRelationship( CswNbtResources, View, ViewNodeString ); } else if( type == CswEnumNbtViewNodeType.CswNbtViewProperty ) { newNode = new CswNbtViewProperty( CswNbtResources, View, ViewNodeString ); } else if( type == CswEnumNbtViewNodeType.CswNbtViewPropertyFilter ) { newNode = new CswNbtViewPropertyFilter( CswNbtResources, View, ViewNodeString ); } else if( type == CswEnumNbtViewNodeType.CswNbtViewRoot ) { newNode = new CswNbtViewRoot( CswNbtResources, View, ViewNodeString ); } else { throw new CswDniException( CswEnumErrorType.Error, "Invalid ViewNode", "CswNbtViewNode.makeViewNode() got an invalid ViewNodeString: " + ViewNodeString.ToString() ); } return newNode; } // makeViewNode()