Select Case

e.DataCol.Name
Case "身份证号","工龄工资" '验证"工龄补贴"
Dim Da_Sfz As DataRow = DataTables("基础信息表").Find("身份证号 = '" & e.DataRow("身份证号") & "'")
Dim StarWork As Date = Da_Sfz("入职日期")
Dim Gzhsq As Date = e.DataRow("核算月份")
Dim WorkDay As TimeSpan = Gzhsq - StarWork
Dim Gl_Gzhsq As Integer = WorkDay.TotalDays\365
Dim YGlbt As Double = DataTables("参数补充表").DataRows(4)("用工参数值")
If Da_Sfz IsNot Nothing Then
e.DataRow("工龄工资") = Gl_Gzhsq * YGlbt
End If
End Select

此主题相关图片如下:qq图片20181017120327.jpg