solidworks模型自定义属性的批量处理的宏代码

Attribute VB_Name = "利用子件处理属性1"

'利用子件进行自定义属性的批量处理的VBA代码

'比较完善的第一版完成时间2012.11.05，作者：张中锋

'适用于深圳东风有限公司solidworks老模型属性更改满足金蝶公司PLM系统要求实例'测试通过环境：2012.11.05 windows XP SP3 ;solidworks 2010 SP02（32bit）

'''''''''''''''' '''''''''''''''' '''''''''''''''' '

'版本更新日志

'1.0 2012.10.29 ①对属性中，存在空白情况处理时数据异常进行修复；②对于已经存在的自定义属性值，保护其值不被处理

'已知的bug记录

Public swModel2 As SldWorks.ModelDoc2

Public PARTNAME_Value_temp As String

Public MATERIAL_Value2_temp As String

Public swApp As SldWorks.SldWorks

Sub main()

Dim swModel As SldWorks.ModelDoc2

Dim swModelDocExt As SldWorks.ModelDocExtension

Dim swSelMgr As SldWorks.SelectionMgr

Dim swBOMAnnotation As SldWorks.BomTableAnnotation

Dim swBOMFeature As SldWorks.BomFeature

Dim swBomTable As Variant

Dim boolstatus As Boolean

Dim BomType As Long

Dim Configuration As String

Dim TemplateName As String

Dim i, j, n, k As Integer

Dim swBOM_name As String

Dim component As Component2

Dim value_temp As Integer

Dim time_start As String

Dim txt_path As String

Set swApp = Application.SldWorks

Set swModel = swApp.ActiveDoc

txt_path = swModel.GetPathName() & " .csv"

Open txt_path For Output Shared As #400

Print #400, "图样代号"; ","; "零件名称"; ","; "零件材料"; Chr(10);

Configuration = swModel.GetActiveConfiguration().Name

If swModel.GetType = 1 Then

Set swModel2 = swApp.ActiveDoc

Call Custominfo_change(Configuration)

ElseIf swModel.GetType = 2 Then

value_temp = swModel.ResolveAllLightWeightComponents(False) '轻化取消到还原状态

Dim Components As Variant

Dim SingleComponent As Variant

Dim swComponent As https://www.360docs.net/doc/2c8399555.html,ponent2

Components = swModel.GetComponents(False) '获取整个装配体的组成部件（零件或者装配体）

For Each SingleComponent In Components '遍历

Set swComponent = SingleComponent

If Not swComponent Is Nothing Then

If swComponent.GetModelDoc() Is Nothing Then '判断子件对象模型是否存在；轻化状态下

获取不到，为空

Debug.Print "没有通过"

Else

Dim x As Integer

Do '此循环实现处理当前模型和子件属

性

If Not swComponent Is Nothing And x < 99 Then '一个很原始的方法强制使用

当前的模型

Set swModel2 = swModel

x = 100

Else

Set swModel2 = swComponent.GetModelDoc() '取得子件对象模型

x = 101

End If

Call Custominfo_change(swModel2.GetActiveConfiguration().Name)

Loop Until x = 101

End If

Else

Debug.Print " 不能获取到子件"

End If

Next

Else

MsgBox "不是零件或者装配体模型"

End If

swModel.Save '保存文件

Close #400

MsgBox "属性转换完毕"

End Sub

Private Function Custominfo_change(ByVal vConfigName As String)

'处理模型的属性

Dim vConfigNameArr As Variant

Dim vCustInfoNameArr As Variant

Dim vCustInfoName As Variant

Dim vCustInfoName2 As Variant

Dim vCustInfoNameArr2 As Variant

Dim vCustInfoName2_temp As String

Dim vCustInfoName_temp As String

Dim a() As String

Dim b() As String

Dim m, n As Integer

vCustInfoNameArr = swModel2.GetCustomInfoNames2(vConfigName)

vCustInfoNameArr2 = swModel2.GetCustomInfoNames

m = 0

If Not IsEmpty(vCustInfoNameArr2) Then '取得自定义属性表的属性数据

For Each vCustInfoName2 In vCustInfoNameArr2

vCustInfoName2_temp = CStr(vCustInfoName2)

If vCustInfoName2_temp = "" Then '处理属性表中的空白数据行m = m - 1

ReDim Preserve a(1, m)

Exit For

End If

vCustInfoName_temp_value2 = swModel2.CustomInfo(vCustInfoName2)

ReDim Preserve a(1, m)

a(0, m) = Trim(vCustInfoName2_temp)

a(1, m) = Trim(vCustInfoName_temp_value2)

m = m + 1

ReDim Preserve a(1, m)

Next

End If

n = 0

If Not IsEmpty(vCustInfoNameArr) Then '取

得配置特定属性表的属性数据

For Each vCustInfoName In vCustInfoNameArr

vCustInfoName_temp = CStr(vCustInfoName)

If vCustInfoName_temp = "" Then '处理属性表中的空白数据行

n = n - 1

ReDim Preserve b(1, n)

Exit For

End If

vCustInfoName_temp_value = swModel2.CustomInfo2(vConfigName, vCustInfoName)

ReDim Preserve b(1, n)

b(0, n) = Trim(vCustInfoName_temp)

b(1, n) = Trim(vCustInfoName_temp_value)

n = n + 1

ReDim Preserve b(1, n)

Next

End If

Dim s, t As Integer

If m > 0 Then '当数组a中有数据时

For s = 0 To UBound(a, 2) '循环取出a中存储的每一条数据

If a(0, s) <> "" And a(1, s) <> "" Then '当数据有效时

Call OldCustominfo_Value(a(0, s), a(1, s), "PARTNAME")

ElseIf a(0, s) = "" Then '当数据无效时（此情况只会是取得最后一条数据时）

Exit For

End If

Next s

If PARTNAME_Value_temp = "" Then '在a中没有获取到合适的数据

If n > 0 Then

For t = 0 To UBound(b, 2) '循环取出b中存储的每一条数据

If b(0, t) <> "" And b(1, t) <> "" Then '当数据有效时

Call OldCustominfo_Value(b(0, t), b(1, t), "PARTNAME")

ElseIf b(0, t) = "" Then '当数据无效时（此情况只会是取得最后一条数据时）

Exit For

End If

Next t

End If

End If

End If

If m > 0 Then

For s = 0 To UBound(a, 2)

If a(0, s) <> "" And a(1, s) <> "" Then

Call OldCustominfo_Value(a(0, s), a(1, s), "MATERIAL")

ElseIf a(0, s) = "" Then

Exit For

End If

Next s

If MATERIAL_Value2_temp = "" Then

If n > 0 Then

For t = 0 To UBound(b, 2)

If b(0, t) <> "" And b(1, t) <> "" Then

Call OldCustominfo_Value(b(0, t), b(1, t), "MATERIAL")

ElseIf b(0, t) = "" Then

Exit For

End If

Next t

End If

End If

End If

Dim DRAWNO_value As String

Dim PARTNAME_value As String

Dim MATERIAL_value As String

PARTNAME_value = Trim(PARTNAME_Value_temp)

MATERIAL_value = Trim(MATERIAL_Value2_temp)

'使用模型的绝对路径获取文件图号，比使用标题更安全

Dim DRAWNO_value1, DRAWNO_value2, DRAWNO_value13 As String

Dim DRAWNO_value_N As Integer

DRAWNO_value1 = swModel2.GetPathName

DRAWNO_value2 = StrReverse(DRAWNO_value1)

DRAWNO_value_N = InStr(1, DRAWNO_value2, "\")

DRAWNO_value3 = Mid

(DRAWNO_value2, 8, DRAWNO_value_N - 8)

DRAWNO_value = StrReverse(DRAWNO_value3)

If Not IsEmpty(vCustInfoNameArr2) Then

For Each vCustInfoName2 In vCustInfoNameArr2 '删除自定义属性

bRet = swModel2.DeleteCustomInfo(vCustInfoName2)

Next

End If

swModel2.AddCustomInfo3 "", "DRAWNO", swCustomInfoText, DRAWNO_value '写入图样代号DRAWNO

swModel2.AddCustomInfo3 "", "PARTNAME", swCustomInfoText, PARTNAME_value '写入零件名称PARTNAME

Call new_unit

If Trim(Left(DRAWNO_value, 1)) <> "Q" And Trim(Left(DRAWNO_value, 2)) <> "GB" Then '检查标准件

swModel2.AddCustomInfo3 "", "MATERIAL", swCustomInfoText,

MATERIAL_value '写入零件材料MATERIAL

Call new_Material

Weight_value = Show_mass(swModel2.GetPathName) '获取零件重量的数值

swModel2.AddCustomInfo3 "", "Weight", swCustomInfoText,

Format(Weight_value, "0.0") '写入零件重量Weight,使用1位小数

"

swModel2.AddCustomInfo3 "", "SPEC", swCustomInfoText, "

"

swModel2.AddCustomInfo3 "", "REMARK", swCustomInfoText, "

"

End If

Print #400, DRAWNO_value; ","; PARTNAME_value; ",";

MATERIAL_value; Chr(10);

PARTNAME_Value_temp = ""

MATERIAL_Value2_temp = ""

End Function

Private Function new_unit() '更改单位

Dim boolstatus As Boolean

boolstatus =

swModel2.Extension.SetUserPreferenceInteger(swUserPreferenceIntegerValue_e.swUni

tSystem, 0, swUnitSystem_e.swUnitSystem_Custom)

boolstatus =

swModel2.Extension.SetUserPreferenceInteger(swUserPreferenceIntegerValue_e.swUni tsLinearFractionDenominator, 0, 0)

boolstatus =

swModel2.Extension.SetUserPreferenceToggle(swUserPreferenceToggle_e.swUnitsLinea rFeetAndInchesFormat, 0, False)

boolstatus =

swModel2.Extension.SetUserPreferenceInteger(swUserPreferenceIntegerValue_e.swUni tsDualLinearFractionDenominator, 0, 0)

boolstatus =

swModel2.Extension.SetUserPreferenceToggle(swUserPreferenceToggle_e.swUnitsDualL inearFeetAndInchesFormat, 0, False)

boolstatus =

swModel2.Extension.SetUserPreferenceInteger(swUserPreferenceIntegerValue_e.swUni tsMassPropDecimalPlaces, 0, 1)

boolstatus =

swModel2.Extension.SetUserPreferenceInteger(swUserPreferenceIntegerValue_e.swUni tsMassPropMass, 0, swUnitsMassPropMass_e.swUnitsMassPropMass_Kilograms)

End Function

Private Function new_Material() '更改材质

Dim matDbs As Variant

Dim swPart As Object

Dim MaterialDatabase As String

Dim MATERIAL_value_temp As String

Dim reval As Boolean

'判断当前的模型文件类型

If swModel2.GetType() = 1 Then 'swModel_filename_value 值为1时，打开零件模型

matDbs = swApp.GetMaterialDatabas

es

Set swPart = swModel2

MaterialDatabase = matDbs(0)

MATERIAL_value_temp = swPart.GetMaterialPropertyName2(Configuration_Name, MaterialDatabase) '获取模型树中的材质值

If MATERIAL_value_temp = "" Then '如果没有指定材质，材质默认为普通碳钢

reval = swModel2.SetMaterialPropertyName2(Configuration_Name, MaterialDatabase,

"普通碳钢")

swModel2.ClearSelection2 True

End If

End If

End Function

Private Function OldCustominfo_Value(ByVal temp11 As String, ByVal temp22 As String,

ByVal temp23) As String '处理旧自定义属性及值

OldCustominfo_Value = ""

If Trim(temp22) <> "" And Left(Trim(temp22), 1) <> Chr(34) Then

If temp23 = "PARTNAME" Then '如果调用的参数为PARTNAME，需要处理的变量为 PARTNAME_value_temp，赋相关值

If temp11 = "PARTNAME" And Left(Trim(temp22), 1) <> "名" And Left(Trim(temp22), 1) <> "D" And Left(Trim(temp22), 1) <> "零" Then

PARTNAME_Value_temp = Trim(temp22)

OldCustominfo_Value = PARTNAME_Value_temp

ElseIf temp11 = "图样名称" Or temp11 = "零件名称" Or temp11 = "名称" Then

If Left(Trim(temp22), 1) <> "D" And Left(Trim(temp22), 1) <> "零" And Left(Trim(temp22), 1) <> "装" And Left(Trim(temp22), 1) <> "名" Then

PARTNAME_Value_temp = Trim(temp22)

OldCustominfo_Value = PARTNAME_Value_temp

Else

OldCustominfo_Value = ""

End If

Else

OldCustominfo_Value = ""

End If

ElseIf temp23 = "MATERIAL" Then '如果调用的参数为MATERIAL，要处理的变量为 MATERIAL_value_temp，赋相关值

If temp11 = "MATERIAL" And Left(Trim(temp22), 1) <> "材" And Left(Trim(temp22), 1) <> "D" And Left(Trim(temp22), 1) <> "零" Then

MATERIAL_Value2_temp = Trim(temp22)

OldCustominfo_Value = MATERIAL_Value2_temp

ElseIf temp11 = "材料名称" Or temp11 = "零件材料" Or temp11 = "材料" Then

temp33 = Left(Trim(temp22), 1)

If temp33 = "钢" Or temp33 = "4" Or temp33 = "1" Or temp33 = "2" Or temp33 = "Q" Or temp33 = "总" Or temp33 = "部" Or temp33 = "橡" _

Or temp33 = "尼" Or temp33 = "组" Or temp33 = "圆" Or temp33 = "方" Or temp33 = "焊" Or temp33 = "装" Or temp33 = "合" Or temp33 = "高" _

Or temp33 = "角" Or temp33 = "扁" Or temp33 = "热" Or temp33 = "冷" Or temp33 = "外" Or temp33 = "分" Or temp23 = "有" Then

MATERIAL_Value2_temp = value_G(Trim(temp22))

OldCustominfo_Value = MATERIAL_Value2_temp

Else

OldCustominfo_Value = ""

End If

Else

Ol

dCustominfo_Value = ""

End If

End If

Else

OldCustominfo_Value = ""

End If

End Function

Private Function value_G(ByVal value_G_in As String) As String '处理零件材料的值中的国标号

Dim value_G_temp As String

Dim value_G_out As String

Dim G_nomber As Integer

value_G_temp = Trim(value_G_in) '删除变量中开头和结尾的空白字符

G_nomber = InStr(value_G_temp, "G") '查找字符“G”的第一次出现的位置

If G_nomber > 1 Then '如果获得“G”value_G_out = Left(value_G_temp, G_nomber - 1) '获得字符“G”之前的字符串

If value_G_out = "" Then

value_G = "" '返回一个空值，

没有取得值"

Else

value_G = value_G_out

End If

Else '没有字符“G”

value_G = value_G_temp

End If

End Function

Private Function Show_mass(ByVal DRAWNO_value11 As String) As String '获取质量的数值

Dim DRAWNO_value12, DRAWNO_value113 As String

Dim DRAWNO_value1_N As Integer

DRAWNO_value12 = StrReverse(DRAWNO_value11)

DRAWNO_value1_N = InStr(1, DRAWNO_value12, "\")

DRAWNO_value13 = Mid(DRAWNO_value12, 1, DRAWNO_value1_N)

DRAWNO_value1 = StrReverse(DRAWNO_value13)

Show_mass = Chr(34) & "SW-Mass@" & DRAWNO_value1 + Chr(34)

End Function