📄 frm_kaoqihesuan2.frm
字号:
gs_ZG = gs_ZG + 0
Else
If iEarlyT > tZaoTui Then
If b11 Then
gs_SJ = Round(DateDiff("n", Dtmp, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1)
Else
gs_SJ = Round(DateDiff("n", bgntm1, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1)
End If
Else
If b11 Then
gs_SJ = Round(DateDiff("n", Dtmp, endtm1) / 60, 1)
Else
gs_SJ = Round(DateDiff("n", bgntm1, endtm1) / 60, 1)
End If
End If
gs_ZG = Round(DateDiff("n", Dtmp, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1)
End If
by = True
''''2
''''3
ElseIf adoprimaryRS4.Fields("cdatetime").Value >= endtm1 And adoprimaryRS4.Fields("cdatetime").Value < bgntm2 Then
adoPrimaryRS5.Fields("wktmend1").Value = endtm1 ''''下班时间
adoPrimaryRS5.Fields("drawtmend1").Value = adoprimaryRS4.Fields("cdatetime").Value '''下班刷卡
adoPrimaryRS5.Fields("earlytime1").Value = 0 '''' 早退时间
'adoPrimaryRS5.Fields("wktmend1dec").Value = "早退"
'ElseIf adoPrimaryRS4.Fields("cdatetime").Value > endtm1 Then
If bw1 Then
gs_SJ = gs_SJ + 0
gs_ZG = gs_ZG + 0
Else
If b11 Then
gs_SJ = Round(DateDiff("n", Dtmp, endtm1) / 60, 1)
Else
gs_SJ = Round(DateDiff("n", bgntm1, endtm1) / 60, 1)
End If
gs_ZG = Round(DateDiff("n", Dtmp, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1)
End If
by = True
ElseIf adoprimaryRS4.Fields("cdatetime").Value > bgntm2 Then
tmpMemo = tmpMemo & "无刷卡2；"
n = n + 1
'adoprimaryRS4.MovePrevious
b2 = True
GoTo GoTo1
End If
Else
adoPrimaryRS5.Fields("wktmend1").Value = endtm1 ''''下班时间
adoPrimaryRS5.Fields("drawtmend1").Value = adoprimaryRS4.Fields("cdatetime").Value ''' "00:00:00" '''下班刷卡
adoPrimaryRS5.Fields("earlytime1").Value = 0 '''' 早退时间
gs_SJ = gs_SJ + 0
gs_ZG = gs_ZG + 0
b2 = False
by = True
End If
'''''''''''''\\\\\\\\\\\\\\\******************/////////////////////////
'''''''''''''\\\\\\\\\\\\\\\******************/////////////////////////
Case 3
'If .Fields("emplyid").Value = "00101073" Then
If adoprimaryRS4.Fields("cdatetime").Value < DateAdd("n", 5, endtm1) Then
'''If adoprimaryRS4.Fields("cdatetime").Value < endtm1 Then
n = n - 2
GoTo Goto2
End If
'End If
'''''''''''''''''''''*****************************************
If adoprimaryRS4.Fields("cdatetime").Value >= DateAdd("n", -60, endtm2) Then
tmpMemo = tmpMemo & "无刷卡3；"
n = 4
GoTo GoTo1
End If
'''''''''''''''''''''*****************************************
If adoprimaryRS4.Fields("cdatetime").Value <= bgntm2 Then
''''1
adoPrimaryRS5.Fields("wktmbg2").Value = bgntm2 '''' 上班时间
adoPrimaryRS5.Fields("drawtmbg2").Value = adoprimaryRS4.Fields("cdatetime").Value ''''上班刷卡
adoPrimaryRS5.Fields("latertime2").Value = 0 '''' 迟到时间
'adoPrimaryRS5.Fields("wktmbg2dec").Value = 上班描述
b3 = True
b33 = False ''''迟到
bw2 = False
''''2
''''3
ElseIf adoprimaryRS4.Fields("cdatetime").Value > bgntm2 And adoprimaryRS4.Fields("cdatetime").Value < endtm2 Then
adoPrimaryRS5.Fields("wktmbg2").Value = bgntm2 '''' 上班时间
adoPrimaryRS5.Fields("drawtmbg2").Value = adoprimaryRS4.Fields("cdatetime").Value ''''上班刷卡
iLaterT = DateDiff("n", bgntm2, adoprimaryRS4.Fields("cdatetime").Value) '''' 迟到时间
If iLaterT > tChiDao Then
adoPrimaryRS5.Fields("latertime2").Value = iLaterT '''' DateDiff("n", bgntm2, adoprimaryRS4.Fields("cdatetime").Value) '''' 迟到时间
adoPrimaryRS5.Fields("wktmbg2dec").Value = "迟到"
b3 = True
b33 = True ''''迟到
Else
adoPrimaryRS5.Fields("latertime2").Value = 0 '''' 迟到时间
b3 = True
b33 = False ''''迟到
End If
bw2 = False
''ElseIf adoprimaryRS4.Fields("cdatetime").Value > endtm2 Then
''adoPrimaryRS5.Fields("wktmbg2").Value = bgntm2 '''' 上班时间
''adoPrimaryRS5.Fields("drawtmbg2").Value = "00:00:00" ''''上班刷卡
''adoPrimaryRS5.Fields("latertime2").Value = 0 '''' 迟到时间
''adoPrimaryRS5.Fields("wktmbg2dec").Value = "无刷卡"
''b33 = False ''''迟到
ElseIf adoprimaryRS4.Fields("cdatetime").Value > endtm2 Then
tmpMemo = tmpMemo & "无刷卡3；"
n = n + 1
'adoprimaryRS4.MovePrevious
b3 = True
bw2 = True
tmpMemo = tmpMemo & "无刷卡2；"
GoTo GoTo1
'GoTo Goto2
'n = n + 1
End If
'''''''''''''\\\\\\\\\\\\\\\******************/////////////////////////
'''''''''''''\\\\\\\\\\\\\\\******************/////////////////////////
Case 4
If adoprimaryRS4.Fields("cdatetime").Value < bgntm22 Then
'If adoprimaryRS4.Fields("cdatetime").Value < bgntm2 Then
n = n - 2
GoTo Goto2
End If
If b3 Then
If adoprimaryRS4.Fields("cdatetime").Value < endtm2 Then
''''1
adoPrimaryRS5.Fields("wktmend2").Value = endtm2 ''''下班时间
adoPrimaryRS5.Fields("drawtmend2").Value = adoprimaryRS4.Fields("cdatetime").Value '''下班刷卡
iEarlyT = DateDiff("n", adoprimaryRS4.Fields("cdatetime").Value, endtm2) '''' 早退时间
If iEarlyT > tZaoTui Then
adoPrimaryRS5.Fields("earlytime2").Value = iEarlyT ''''DateDiff("n", adoprimaryRS4.Fields("cdatetime").Value, endtm2) '''' 早退时间
adoPrimaryRS5.Fields("wktmend2dec").Value = "早退"
Else
adoPrimaryRS5.Fields("earlytime2").Value = 0
End If
If bw2 Then
gs_SJ = gs_SJ + 0
gs_ZG = gs_ZG + 0
Else
''''早退
If iEarlyT > tZaoTui Then
If b33 Then ''''早退 而且 迟到
gs_SJ = gs_SJ + Round(DateDiff("n", Dtmp, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1)
Else
gs_SJ = gs_SJ + Round(DateDiff("n", bgntm2, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1)
End If
Else
If b33 Then
gs_SJ = gs_SJ + Round(DateDiff("n", Dtmp, endtm2) / 60, 1)
Else
gs_SJ = gs_SJ + Round(DateDiff("n", bgntm2, endtm2) / 60, 1)
End If
End If
gs_ZG = gs_ZG + Round(DateDiff("n", Dtmp, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1)
End If
''''2
''''3
ElseIf adoprimaryRS4.Fields("cdatetime").Value >= endtm2 Then
adoPrimaryRS5.Fields("wktmend2").Value = endtm2 ''''下班时间
adoPrimaryRS5.Fields("drawtmend2").Value = adoprimaryRS4.Fields("cdatetime").Value '''下班刷卡
adoPrimaryRS5.Fields("earlytime2").Value = 0 '''' 早退时间
'adoPrimaryRS5.Fields("wktmend1dec").Value = "早退"
'ElseIf adoPrimaryRS4.Fields("cdatetime").Value > endtm1 Then
If bw2 Then
gs_SJ = gs_SJ + 0
gs_ZG = gs_ZG + 0
Else
If b33 Then
gs_SJ = gs_SJ + Round(DateDiff("n", Dtmp, endtm2) / 60, 1)
Else
gs_SJ = gs_SJ + Round(DateDiff("n", bgntm2, endtm2) / 60, 1)
End If
gs_ZG = gs_ZG + Round(DateDiff("n", Dtmp, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1)
End If
End If
Else ''''无下午上班刷卡；
If b1 Then
If bw23 Then ''''早晚两次刷卡
If adoprimaryRS4.Fields("cdatetime").Value < endtm2 Then '''' ''''早退
''''1
adoPrimaryRS5.Fields("wktmend2").Value = endtm2 ''''下班时间
adoPrimaryRS5.Fields("drawtmend2").Value = adoprimaryRS4.Fields("cdatetime").Value '''下班刷卡
iEarlyT = DateDiff("n", adoprimaryRS4.Fields("cdatetime").Value, endtm2) '''' 早退时间
If iEarlyT > tZaoTui Then
adoPrimaryRS5.Fields("earlytime2").Value = iEarlyT ''''DateDiff("n", adoprimaryRS4.Fields("cdatetime").Value, endtm2) '''' 早退时间
adoPrimaryRS5.Fields("wktmend2dec").Value = "早退"
Else
adoPrimaryRS5.Fields("earlytime2").Value = 0
End If
''''早退
If iEarlyT > tZaoTui Then
If b11 Then ''''早退 而且 迟到
gs_SJ = gs_SJ + Round(DateDiff("n", Dtmp, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1) - Round(DateDiff("n", endtm1, bgntm2) / 60, 1)
Else
gs_SJ = gs_SJ + Round(DateDiff("n", bgntm1, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1) - Round(DateDiff("n", endtm1, bgntm2) / 60, 1)
End If
Else
If b11 Then
gs_SJ = gs_SJ + Round(DateDiff("n", Dtmp, endtm2) / 60, 1) - Round(DateDiff("n", endtm1, bgntm2) / 60, 1)
Else
gs_SJ = gs_SJ + Round(DateDiff("n", bgntm1, endtm2) / 60, 1) - Round(DateDiff("n", endtm1, bgntm2) / 60, 1)
End If
End If
gs_ZG = gs_ZG + Round(DateDiff("n", Dtmp, adoprimaryRS4.Fields("cdatetime").Value) / 60, 1)
''''2
''''3
ElseIf adoprimaryRS4.Fields("cdatetime").Value >= endtm2 Then
adoPrimaryRS5.Fields("wktmend2").Value = endt⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -