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.sodocs.net/doc/9512542076.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.swUnitSystem, 0, swUnitSystem_e.swUnitSystem_Custom)
boolstatus = swModel2.Extension.SetUserPreferenceInteger(swUserPreferenceIntegerValue_e.swUnitsLinearFractionDenominator, 0, 0)
boolstatus = swModel2.Extension.SetUserPreferenceToggle(swUserPreferenceToggle_e.swUnitsLinearFeetAndInchesFormat, 0, False)
boolstatus = swModel2.Extension.SetUserPreferenceInteger(swUserPreferenceIntegerValue_e.swUnitsDualLinearFractionDenominator, 0, 0)
boolstatus = swModel2.Extension.SetUserPreferenceToggle(swUserPreferenceToggle_e.swUnitsDualLinearFeetAndInchesFormat, 0, False)
boolstatus = swModel2.Extension.SetUserPreferenceInteger(swUserPreferenceIntegerValue_e.swUnitsMassPropDecimalPlaces, 0, 1)
boolstatus = swModel2.Extension.SetUserPreferenceInteger(swUserPreferenceIntegerValue_e.swUnitsMassPropMass, 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