Dim hqbm As WinForm.CheckedComboBox = e.Form.Controls("CheckedComboBox1")
Dim ss As String = hqbm.value
Dim r As Row = Tables("上传").Current
Dim vals() As String = ss.Split(",") '开始赋值
Dim dict As new Dictionary(of String ,String)
dict.Add("总经办","杨俏琼,yangqiaoqiong@bdcom.com.cn")
dict.Add("研发部","冯文羽,fengwenyu@bdcom.com.cn")
dict.Add("制造部","邓虓,dengxiao@bdcom.com.cn")
dict.Add("供应部","吴慧,wuhui@bdcom.com.cn")
For Each s As String In vals
If r(s & "审批") = True Then
Dim ars() As String = dict(s).split(",")
r(s) = ars(0)
r(s & "邮箱") = ars(1)
Else
r(s) = Nothing
r(s & "邮箱") = Nothing
End If
Next
r.save