⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 netmanage.dm1

📁 上网绑定功能
💻 DM1
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
1,1,1,1,1,"",-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,"",0,0,0,"","",0,99,0
1,1,2,2,2,"",-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,"",0,0,0,"","",0,118,0
1,3,1,5,5,"",-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,"",0,0,0,"","",0,341,0
1,3,2,6,6,"",-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,"",0,0,0,"","",0,352,0

Attribute
DiagramId,ModelId,EntityId,AttributeId,Attribute_ID,Entity_ID,UserDatatypeId,RuleId,DomainId,DefaultId,AttributeNameId,ColumnNameId,DefinitionId,NoteId,RoleNameId,LogicalRoleNameId,DatatypeId,Nullable,Length,Scale,IdentityColumn,IdentitySeed,IdentityIncrement,SequenceNo,CheckConstraintId,DefaultTextId,ColumnNameSet,RoleNameSet,LogicalRoleNameSet,GlobalId,UserDatatype,OverrideDataBits,DefaultNameId,AverageWidth,PercentNull,Flags,Global_User_ID,Row_Time_Stamp
1,1,2,8,13,2,0,0,0,0,44,44,0,0,0,0,11,1,50,-1,N,1,1,7,0,0,1,0,0,0,0,0,0,0,0,0,130,0
1,1,1,1,1,1,0,0,0,0,12,13,0,0,0,0,11,0,50,-1,N,1,1,1,0,0,1,0,0,0,0,0,0,0,0,0,103,0
1,1,1,2,2,1,0,0,0,0,14,15,0,0,0,0,11,0,50,-1,N,1,1,2,0,0,1,0,0,0,0,0,0,0,0,0,104,0
1,1,1,3,3,1,0,0,0,0,16,17,0,0,0,0,11,1,20,-1,N,1,1,3,0,0,1,0,0,0,0,0,0,0,0,0,106,0
1,1,1,4,4,1,0,0,0,0,18,19,0,0,0,0,11,1,20,-1,N,1,1,4,0,0,1,0,0,0,0,0,0,0,0,0,107,0
1,1,1,5,5,1,0,0,0,0,21,21,0,0,0,0,20,1,18,-1,N,1,1,5,0,0,1,0,0,0,0,0,0,0,0,0,108,0
1,3,2,1,32,6,0,0,0,0,32,33,0,0,0,0,11,0,50,-1,N,1,1,1,0,0,1,0,0,0,0,0,0,50,0,0,353,0
1,3,2,2,33,6,0,0,0,0,34,35,0,0,0,0,11,1,10,-1,N,1,1,2,0,0,1,0,0,0,0,0,0,10,0,0,354,0
1,3,2,3,34,6,0,0,0,0,36,37,0,0,0,0,11,1,20,-1,N,1,1,3,0,0,1,0,0,0,0,0,0,20,0,0,355,0
1,3,2,4,35,6,0,0,0,0,38,39,0,0,0,0,11,1,20,-1,N,1,1,4,0,0,1,0,0,0,0,0,0,20,0,0,356,0
1,3,2,5,36,6,0,0,0,0,21,21,0,0,0,0,11,1,10,-1,N,1,1,8,0,0,1,0,0,0,0,0,0,10,0,0,357,0
1,3,2,6,37,6,0,0,0,0,41,42,0,0,0,0,11,1,20,-1,N,1,1,5,0,0,1,0,0,0,0,0,0,20,0,0,358,0
1,3,2,7,38,6,0,0,0,0,18,43,0,0,0,0,11,1,20,-1,N,1,1,6,0,0,1,0,0,0,0,0,0,20,0,0,359,0
1,3,2,8,39,6,0,0,0,0,44,44,0,0,0,0,11,1,50,-1,N,1,1,7,0,0,1,0,0,0,0,0,0,50,0,0,360,0
1,3,1,1,27,5,0,0,0,0,12,13,0,0,0,0,11,0,50,-1,N,1,1,1,0,0,1,0,0,0,0,0,0,50,0,0,342,0
1,3,1,2,28,5,0,0,0,0,14,15,0,0,0,0,11,0,50,-1,N,1,1,2,0,0,1,0,0,0,0,0,0,50,0,0,343,0
1,3,1,3,29,5,0,0,0,0,16,17,0,0,0,0,11,1,20,-1,N,1,1,3,0,0,1,0,0,0,0,0,0,20,0,0,344,0
1,3,1,4,30,5,0,0,0,0,18,19,0,0,0,0,11,1,20,-1,N,1,1,4,0,0,1,0,0,0,0,0,0,20,0,0,345,0
1,3,1,5,31,5,0,0,0,0,21,21,0,0,0,0,20,1,-1,-1,N,1,1,5,0,0,1,0,0,0,0,0,0,2048,0,0,346,0
1,1,2,1,6,2,0,0,0,0,32,33,0,0,0,0,11,0,50,-1,N,1,1,1,0,0,1,0,0,0,0,0,0,0,0,0,122,0
1,1,2,2,7,2,0,0,0,0,34,35,0,0,0,0,11,1,10,-1,N,1,1,2,0,0,1,0,0,0,0,0,0,0,0,0,123,0
1,1,2,3,8,2,0,0,0,0,36,37,0,0,0,0,11,1,20,-1,N,1,1,3,0,0,1,0,0,0,0,0,0,0,0,0,124,0
1,1,2,4,9,2,0,0,0,0,38,39,0,0,0,0,11,1,20,-1,N,1,1,4,0,0,1,0,0,0,0,0,0,0,0,0,125,0
1,1,2,5,10,2,0,0,0,0,21,21,0,0,0,0,11,1,10,-1,N,1,1,8,0,0,1,0,0,0,0,0,0,0,0,0,127,0
1,1,2,6,11,2,0,0,0,0,41,42,0,0,0,0,11,1,20,-1,N,1,1,5,0,0,1,0,0,0,0,0,0,0,0,0,128,0
1,1,2,7,12,2,0,0,0,0,18,43,0,0,0,0,11,1,20,-1,N,1,1,6,0,0,1,0,0,0,0,0,0,0,0,0,129,0

PrimaryKey
DiagramId,ModelId,EntityId,AttributeId,PrimaryKey_ID,Attribute_ID,SequenceNo,Global_User_ID,Row_Time_Stamp
1,1,1,1,1,1,1,0,0
1,3,2,1,4,32,1,0,0
1,3,1,1,3,27,1,0,0
1,1,2,1,2,6,1,0,0

Indexes
DiagramId,ModelId,EntityId,IndexId,Indexes_ID,Entity_ID,IsUniqueId,IndexTypeId,KeyType,HashSize,HashSizeTypeId,IgnoreDupKeyId,DupRowId,NoSortId,SortOrderingId,IndexNameId,Flags,Global_User_ID,Row_Time_Stamp
1,1,1,1,1,1,7,0,P,0,0,0,0,0,0,27,0,100,0
1,3,2,1,6,6,7,0,P,0,0,0,0,0,0,40,0,361,0
1,3,1,1,5,5,7,0,P,0,0,0,0,0,0,27,0,347,0
1,1,2,1,2,2,7,0,P,0,0,0,0,0,0,40,0,119,0

IndexStorage
DiagramId,ModelId,EntityId,IndexId,IndexStorage_ID,Indexes_ID,Location,FillfactorPercent,MaximumRowsPerPage,PercentFree,PercentUsed,MinimumExtents,MaximumExtents,InitialExtentSize,NextExtentSize,ExtentGrowthFactor,MinimumTransactions,MaximumTransactions,LockModeSetting,Global_User_ID,Row_Time_Stamp
1,1,1,1,1,1,"",-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,"",101,0
1,3,2,1,6,6,"",-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,"",362,0
1,3,1,1,5,5,"",-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,"",348,0
1,1,2,1,2,2,"",-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,"",120,0

IndexColumn
DiagramId,ModelId,EntityId,IndexId,AttributeId,IndexColumn_ID,Attribute_ID,Indexes_ID,SequenceNo,SortOrdering,Global_User_ID,Row_Time_Stamp
1,3,1,1,1,5,27,5,1,A,349,0
1,1,2,1,1,2,6,2,1,A,126,0
1,1,1,1,1,1,1,1,1,A,105,0
1,3,2,1,1,6,32,6,1,A,363,0

CheckConstraints
DiagramId,ModelId,EntityId,CheckId,CheckConstraints_ID,Entity_ID,Attribute_ID,AttributeId,ConstraintNameId,CheckTextId,Global_User_ID,Row_Time_Stamp

ForeignKey
DiagramId,ModelId,RelationshipId,ForeignKey_ID,New_Child_Entity_ID,New_Parent_Entity_ID,ParentEntityId,ChildEntityId,Parent_Index_ID,RelationshipTypeId,ParentConstraintTypeId,ParentCardinalityId,ParentCardinalityNo,ChildCardinalityId,ChildCardinalityNo,ParentOptionalityId,ChildOptionalityId,ParentInsertId,ParentUpdateId,ParentDeleteId,ChildInsertId,ChildUpdateId,ChildDeleteId,DefinitionId,InversePhraseId,VerbPhraseId,NoteId,RelationshipNameId,Flags,LogicalRelationshipNameId,Global_User_ID,Row_Time_Stamp

ForeignKeyColumn
ForeignKeyColumn_Id,DiagramId,ModelId,RelationshipId,ForeignKey_ID,SequenceNo,ParentEntityId,ParentAttributeId,ChildEntityId,ChildAttributeId,OriginalParentId,OriginalAttributeId,Global_User_ID,Row_Time_Stamp

Supertype
DiagramId,ModelId,SupertypeId,Supertype_ID,Entity_ID,EntityId,Type,Discriminator,Global_User_ID,Row_Time_Stamp

Subtype
DiagramId,ModelId,SupertypeId,SubtypeId,Subtype_ID,Supertype_ID,ForeignKey_ID,EntityId,RelationshipId,Global_User_ID,Row_Time_Stamp

DbView
DbView_ID,Model_ID,Inter_Model_View_ID,NameId,Is_User_Defined,DefinitionId,NotesId,OwnerId,Global_User_ID,Row_Time_Stamp

View_Field
View_Field_ID,DbView_ID,Alias,Inter_Model_View_Field_ID,Column_Expression,SequenceNo,Global_User_ID,Row_Time_Stamp

View_Component
View_Component_ID,DbView_ID,Component_Type,bIsCurrent,SQL,Global_User_ID,Row_Time_Stamp

View_Table
View_Table_ID,DbView_ID,Entity_ID,Parent_View_ID,Alias,Inter_Model_View_Table_ID,Type,SequenceNo,Global_User_ID,Row_Time_Stamp

Field_Column
Field_Column_ID,View_Column_ID,View_Field_ID,Global_User_ID,Row_Time_Stamp

View_Column
View_Column_ID,View_Table_ID,Attribute_ID,Parent_View_Field_ID,Inter_Model_View_Column_ID,Global_User_ID,Row_Time_Stamp

Column_Usage
Column_Usage_ID,View_Column_ID,Usage_Type,SequenceNo,Global_User_ID,Row_Time_Stamp

EntityDisplay
DiagramId,ModelId,SubmodelId,EntityId,EntityDisplay_ID,Submodel_ID,Entity_ID,HorizontalPosition,VerticalPosition,cxEntity,cyEntity,cxEntityNode,cyEntityNode,xEntityNode,yEntityNode,DisplayBkgColor,BackgroundColor,Global_User_ID,Row_Time_Stamp
1,1,1,1,1,1,1,558,-273,-1,-1,0,0,0,0,0,0,102,0
1,1,1,2,2,1,2,350,-266,-1,-1,0,0,0,0,0,0,121,0
1,3,1,1,5,3,5,558,-273,-1,-1,0,0,0,0,0,0,350,0
1,3,1,2,6,3,6,350,-266,-1,-1,0,0,0,0,0,0,364,0

View_Display
View_Display_ID,Submodel_ID,DbView_ID,DisplayBkgColor,View_Background_Color,Default_Horz_Position,Default_Vert_Position,cxView,cyView,cxViewNode,cyViewNode,xViewNode,yViewNode,Global_User_ID,Row_Time_Stamp

Submodel_SchemaObj_Link
Submodel_SchemaObj_Link_ID,Submodel_ID,MetaTable_ID,Table_Row_ID,cxNode,cyNode,xNode,yNode,cxNodeBackup,cyNodeBackup,xNodeBackup,yNodeBackup,Flags,Global_User_ID

RelationshipDisplay
DiagramId,ModelId,SubmodelId,RelationshipId,RelationshipDisplay_ID,ForeignKey_ID,Submodel_ID,ElbowPosition,DisplayVerbs,DisplayCardinality,PhysicalEntityId,VerbOffsetX,VerbOffsetY,InverseVerbOffsetX,InverseVerbOffsetY,DesiredRoutingStyle,ParentConnectorFlags,ParentConnectorOffsetX,ParentConnectorOffsetY,ParentConnectorPerMils,ChildConnectorFlags,ChildConnectorOffsetX,ChildConnectorOffsetY,ChildConnectorPerMils,NameOffsetX,NameOffsetY,LogicalNameOffsetX,LogicalNameOffsetY,Global_User_ID,Row_Time_Stamp

Docking_Position
Docking_Position_ID,View_Relationship_Display_ID,Child_View_Display_ID,Parent_View_Display_ID,RelationshipDisplay_ID,Parent_Entity_Display,Child_Entity_Display,Parent_Supertype_Display,Child_Supertype_Display,Supertype_Display_ID,Docking_Type,Global_User_ID,Row_Time_Stamp

Dock_Pos_Disp_Level
Dock_Pos_Disp_Level_ID,Docking_Position_ID,Display_Level,Parent_Side,Child_Side,Parent_Relative_Position,Child_Relative_Position,Global_User_ID,Row_Time_Stamp

Path_Node
Path_Node_ID,RelationshipDisplay_ID,View_Relationship_Display_ID,SupertypeDisplay_ID,SchemaObj_Edge_ID,Shape_Edge_Display_ID,X,Y,SequenceNo

View_Relationship_Display
View_Relationship_Display_ID,Entity_ID,Parent_View_ID,Submodel_ID,Child_View_ID,ElbowPosition,Inter_Model_View_Rel_Disp_ID,DesiredRoutingStyle,ParentConnectorFlags,ParentConnectorOffsetX,ParentConnectorOffsetY,ParentConnectorPerMils,ChildConnectorFlags,ChildConnectorOffsetX,ChildConnectorOffsetY,ChildConnectorPerMils,Global_User_ID,Row_Time_Stamp

SchemaObj_Edge
SchemaObj_Edge_ID,Parent_Entity_Disp_ID,Parent_View_Disp_ID,Parent_SchemaObj_Link_ID,Child_SchemaObj_Link_ID,Submodel_ID,DesiredRoutingStyle,ParentConnectorFlags,ParentConnectorOffsetX,ParentConnectorOffsetY,ParentConnectorPerMils,ChildConnectorFlags,ChildConnectorOffsetX,ChildConnectorOffsetY,ChildConnectorPerMils,DockingType,Global_User_ID

SupertypeDisplay
DiagramId,ModelId,SubmodelId,SupertypeId,SupertypeDisplay_ID,Supertype_ID,Submodel_ID,EntityId,HorizontalPosition,VerticalPosition,ElbowPosition,DesiredRoutingStyle,ParentConnectorFlags,ParentConnectorOffsetX,ParentConnectorOffsetY,ParentConnectorPerMils,ChildConnectorFlags,ChildConnectorOffsetX,ChildConnectorOffsetY,ChildConnectorPerMils,xSupertypeSymbolNode,ySupertypeSymbolNode,cxSupertypeSymbolNode,cySupertypeSymbolNode,Global_User_ID,Row_Time_Stamp

GraphicObject
DiagramId,ModelId,SubmodelId,ObjectId,GraphicObject_ID,Submodel_ID,GraphicsType,LeftPosition,TopPosition,RightPosition,BottomPosition,RawData,xNodeBackup,yNodeBackup,cxNodeBackup,cyNodeBackup,Global_User_ID,Row_Time_Stamp

Shape_Display
Shape_Display_ID,Submodel_ID,Shape_ID,xNode,yNode,cxNode,cyNode,xNodeBackup,yNodeBackup,cxNodeBackup,cyNodeBackup,zOrder,IsContainer,HorizontalTextJustification,VerticalTextJustification,WrapText,FitShape,Global_User_ID

Shape_Edge_Display
Shape_Edge_Display_ID,Shape_Edge_ID,Submodel_ID,LineWidth,PenStyle,CurvatureStyle,SourceArrowHeadStyle,TargetArrowHeadStyle,DesiredRoutingStyle,ParentConnectorFlags,ParentConnectorOffsetX,ParentConnectorOffsetY,ParentConnectorPerMils,ChildConnectorFlags,ChildConnectorOffsetX,ChildConnectorOffsetY,ChildConnectorPerMils,DockingType,VerbOffsetX,VerbOffsetY,InverseVerbOffsetX,InverseVerbOffsetY,Global_User_ID

SmallString
String_Id,Data,Overflow,ConstantString,Row_Time_Stamp
1,Main,0,0,0
2,Diagram specific data dictionary.,0,0,0
3,Logical,0,0,0
4,Main Model,0,0,0
5,Data Movement Rules,0,0,0
6,Entity1,0,0,0
7,Y,0,0,0
8,管理员,0,0,0
9,Manager,0,0,0
10,CH,0,0,0
11,VAR,0,0,0
12,登陆名称,0,0,0
13,Login_Name,0,0,0
14,登陆密码,0,0,0
15,LoginPass,0,0,0
16,真实姓名,0,0,0
17,RealName,0,0,0
18,联系电话,0,0,0
19,Phone,0,0,0
20,DTX,0,0,0
21,Other,0,0,0
22,NETManage_DD,0,0,0
23,NETManage.DM1,0,0,0
24,Sobey,0,0,0
25,1.0,0,0,0
26,NameOnly,0,0,0
27,PK1,0,0,0
28,Entity2,0,0,0
29,上网用户,0,0,0
30,OnlinePC,0,0,0
31,在线电脑,0,0,0
32,MAC地址,0,0,0
33,MAC,0,0,0
34,IP地址,0,0,0
35,IP,0,0,0
36,房间号,0,0,0
37,RoomNum,0,0,0
38,当前状态,0,0,0
39,State,0,0,0
40,PK2,0,0,0
41,户主,0,0,0
42,HouseMaster,0,0,0
43,Telephone,0,0,0
44,Email,0,0,0
45,NETManange,0,0,0
46,NETManage,0,0,0
47,SSUpdtTrigLib,0,0,0
48,"",1,0,0
49,SSDelTrigLib,0,0,0
50,"",1,0,0
51,SSInsTrigLib,0,0,0
52,"",1,0,0
53,SSUpdtTrigger,0,0,0
54,"",1,0,0
55,SSDelTrigger,0,0,0
56,"",1,0,0
57,SSInsTrigger,0,0,0
58,"",1,0,0

LargeString
String_Id,Data,Row_Time_Stamp
50,"

Function SSDefParDelSN( Rel As Relationship ) As String

	Dim ParentEntity As Entity
	Dim	ChildEntity As Entity
	Dim Result As String
	Dim FKColumn As FKColumnPair

	ParentCount% = 0
	ChildCount% = 0

	For Each FKColumn In Rel.FKColumnPairs

		If FKColumn.ParentAttribute.Hidden = False Then ParentCount = ParentCount + 1
		If FKColumn.ChildAttribute.Hidden = False Then ChildCount = ChildCount + 1

		if ParentCount <> ChildCount Then Exit Function
	Next FKColumn

	Result = ""-- Parent Delete: SET NULL"" &  vbCrLf & vbCrLf
	Result = Result & ""    UPDATE "" & Rel.ChildEntity.TableName & "" SET"" & vbCrLf

	Count% = 0

	For Each FKColumn In Rel.FKColumnPairs

		Count% = Count% + 1
		Result = Result & ""            "" & FKColumn.ChildAttribute.ColumnName & "" = NULL""

		if Count < Rel.FKColumnPairs.Count Then Result = Result & "",""

		Result = Result & vbCrLf
	Next FKColumn

	Result = Result & ""        FROM "" & Rel.ChildEntity.TableName
	Result = Result & "" ch, deleted"" & vbCrLf & ""        WHERE"" & vbCrLf

	Count% = 0

	For Each FKColumn In Rel.FKColumnPairs

		Count% = Count% + 1
		Result = Result & ""            ch."" & FKColumn.ChildAttribute.ColumnName
		Result = Result & "" = deleted."" & FKColumn.ParentAttribute.ColumnName

		if Count < Rel.FKColumnPairs.Count Then Result = Result & "" AND""

		Result = Result & vbCrLf
	Next FKColumn


	SSDefParDelSN = Result

End Function

Function SSDefParDelRstr( Rel As Relationship, TriggerName As String ) As String

	Dim Result As String
	Dim FKColumn As FKColumnPair

	ParentCount% = 0
	ChildCount% = 0

	For Each FKColumn In Rel.FKColumnPairs

		If FKColumn.ParentAttribute.Hidden = False Then ParentCount = ParentCount + 1
		If FKColumn.ChildAttribute.Hidden = False Then ChildCount = ChildCount + 1

		if ParentCount <> ChildCount Then Exit Function
	Next FKColumn

	Result = ""-- Parent Delete: RESTRICT"" &  vbCrLf & vbCrLf
	Result = Result & ""    IF ((SELECT COUNT(*)"" & vbCrLf
	Result = Result & ""         FROM "" & Rel.ChildEntity.TableName & "" ch, deleted"" & vbCrLf
	Result = Result & ""         WHERE ""

	Count% = 0

	For Each FKColumn In Rel.FKColumnPairs

		Count% = Count% + 1

		Result = Result & ""ch."" & FKColumn.ChildAttribute.ColumnName
		Result = Result & "" = deleted."" & FKColumn.ParentAttribute.ColumnName

		if Count% < Rel.FKColumnPairs.Count Then
			Result = Result & "" AND"" & vbCrLf & ""           ""
		Else
			Result = Result & "") != 0)"" & vbCrlf
		End If
	Next FKColumn

	Result = Result & ""    BEGIN"" & vbCrLf & ""        RAISERROR 30002 '"" & TriggerName
	Result = Result & ""Cannot delete because foreign keys still exist in ""
	Result = Result & Rel.ChildEntity.TableName & ""'"" & vbCrLf
	Result = Result & ""        ROLLBACK TRAN"" & vbCrLf
	Result = Result & ""    END"" & vbCrLf


	SSDefParDelRstr = Result

End Function

Function SSDefParDelCasc( Rel As Relationship ) As String

	Dim Result As String
	Dim FKColumn As FKColumnPair

	ParentCount% = 0
	ChildCount% = 0

	For Each FKColumn In Rel.FKColumnPairs

		If FKColumn.ParentAttribute.Hidden = False Then ParentCount = ParentCount + 1
		If FKColumn.ChildAttribute.Hidden = False Then ChildCount = ChildCount + 1

		if ParentCount <> ChildCount Then Exit Function
	Next FKColumn


	Result = ""-- Parent Delete: CASCADE"" & vbCrLf & vbCrLf

	Result = Result & ""    DELETE "" & Rel.ChildEntity.TableName & vbCrLf
	Result = Result & ""        FROM "" & Rel.ChildEntity.TableName & "" ch, deleted"" & vbCrLf
	Result = Result & ""        WHERE ""

	Count% = 0

	For Each FKColumn In Rel.FKColumnPairs

		Count% = Count% + 1

		Result = Result & ""ch."" & FKColumn.ChildAttribute.ColumnName
		Result = Result & "" = deleted."" & FKColumn.ParentAttribute.ColumnName

		if Count% < Rel.FKColumnPairs.Count Then
			Result = Result & "" AND"" & vbCrLf & ""           ""
		Else
			Result = Result & vbCrLf
		End If
	Next FKColumn

	SSDefParDelCasc = Result
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -