- Foxtable(狐表) (http://www.foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://www.foxtable.com/bbs/list.asp?boardid=2)
---- 未将对象引用到对象的实例 (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=126240)
-- 发布时间：2018/10/17 12:05:00
-- 未将对象引用到对象的实例
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
e.DataCol.NameCase "身份证号","工龄工资" \'验证"工龄补贴"
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
-- 发布时间：2018/10/17 12:12:00
--
Select Case e.DataCol.Name
Case "身份证号","工龄工资" \'验证"工龄补贴"
Dim Da_Sfz As DataRow = DataTables("基础信息表").Find("身份证号 = \'" & e.DataRow("身份证号") & "\'")
If Da_Sfz IsNot Nothing Then
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)("用工参数值")
e.DataRow("工龄工资") = Gl_Gzhsq * YGlbt
End If
End Select