?? frm_失業保險記錄.frm
字號:
EndProperty
Height = 285
Left = 4710
TabIndex = 10
Top = 2775
Width = 2895
End
Begin VB.TextBox TXT_YJZJ
DataField = "季度應繳總計"
BeginProperty DataFormat
Type = 1
Format = """￥""#,##0.00"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 2
EndProperty
DataSource = "datPrimaryRS"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 4710
TabIndex = 8
Top = 3615
Width = 2895
End
Begin VB.TextBox TXT_GZZE
DataField = "應繳職工年工資總額"
BeginProperty DataFormat
Type = 0
Format = """￥""#,##0.00"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
DataSource = "datPrimaryRS"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 4710
TabIndex = 6
Top = 2010
Width = 2895
End
Begin VB.TextBox TXT_ND
DataField = "年度"
DataSource = "datPrimaryRS"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 4710
TabIndex = 3
Top = 1215
Width = 2895
End
Begin VB.Label lblLabels
Caption = "全年應繳金額:"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 8
Left = 2790
TabIndex = 15
Top = 4035
Width = 1725
End
Begin VB.Label lblLabels
Caption = "季度個人應繳額:"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 7
Left = 2790
TabIndex = 13
Top = 3255
Width = 1725
End
Begin VB.Label lblLabels
Caption = "季度繳費人數:"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 6
Left = 2790
TabIndex = 11
Top = 2460
Width = 1725
End
Begin VB.Label lblLabels
Caption = "季度單位應繳額:"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 5
Left = 2790
TabIndex = 9
Top = 2835
Width = 1725
End
Begin VB.Label lblLabels
Caption = "季度應繳總計:"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 4
Left = 2790
TabIndex = 7
Top = 3645
Width = 1725
End
Begin VB.Label lblLabels
Caption = "應繳職工年工資總額:"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 3
Left = 2790
TabIndex = 5
Top = 2070
Width = 1725
End
Begin VB.Label lblLabels
Caption = "日期："
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 2
Left = 2790
TabIndex = 4
Top = 1665
Width = 1725
End
Begin VB.Label lblLabels
Caption = "年度:"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 1
Left = 2790
TabIndex = 2
Top = 1290
Width = 1725
End
End
End
End
Attribute VB_Name = "frm_SYBXJL"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdClose_Click()
RSGL.Enabled = True
Unload Me
End Sub
Private Sub Form_Load()
RQ = Date
TXT_ND = Year(RQ)
SQL = "SELECT * FROM 員工基本信息 where 檔案轉入時間<'" & TXT_ND & "'"
Set rs = ConnWZ.Execute(SQL)
If rs.EOF Then Exit Sub
TXT_JFRS = rs.RecordCount
SQL = "select * from 比例基數維護表 where 年度=" & Val(TXT_ND) & ""
Set rs = ConnWZ.Execute(SQL)
If rs.EOF Then Exit Sub
TXT_GZZE = rs("年工資總額")
TXT_DWYJE = FormatCurrency(Val(TXT_GZZE) * rs("失業單位比例") / 4)
TXT_GRYJE = FormatCurrency(Val(rs("失業保險扣款") * Val(TXT_JFRS) * 3))
TXT_YJZJ = FormatCurrency(Val(Format(TXT_GRYJE)) + Val(Format(TXT_DWYJE)))
TXT_YJJE = FormatCurrency(Val(Format(TXT_YJZJ)) * 4)
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -