Select Case
![图片点击可在新窗口打开查看](file:///C:/Users/杨福义/AppData/Local/Temp/%25W@GJ$ACOF(TYDYECOKVDYB.png)
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
![dvubb 图片点击可在新窗口打开查看](skins/default/filetype/jpg.gif)
此主题相关图片如下:qq图片20181017120327.jpg