frm大病医疗记录.frm
资源名称:dbbase.rar [点击查看]
上传用户:xiao_xia32
上传日期:2022-07-21
资源大小:1174k
文件大小:24k
源码类别:
企业管理
开发平台:
Visual Basic
- VERSION 5.00
- Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
- Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "MSDATGRD.OCX"
- Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
- Object = "{0BA686C6-F7D3-101A-993E-0000C0EF6F5E}#1.0#0"; "THREED32.OCX"
- Begin VB.Form frm_DBYLJL
- BorderStyle = 3 'Fixed Dialog
- Caption = "大病医疗记录"
- ClientHeight = 5610
- ClientLeft = 1095
- ClientTop = 330
- ClientWidth = 7890
- ControlBox = 0 'False
- KeyPreview = -1 'True
- LinkTopic = "Form1"
- LockControls = -1 'True
- MaxButton = 0 'False
- MinButton = 0 'False
- ScaleHeight = 5610
- ScaleWidth = 7890
- ShowInTaskbar = 0 'False
- StartUpPosition = 2 '屏幕中心
- Begin VB.Frame Frame1
- Height = 5655
- Left = 0
- TabIndex = 10
- Top = -60
- Width = 7845
- Begin TabDlg.SSTab SSTab1
- Height = 5235
- Left = 90
- TabIndex = 11
- Top = 360
- Width = 7665
- _ExtentX = 13520
- _ExtentY = 9234
- _Version = 393216
- Style = 1
- Tabs = 2
- TabHeight = 520
- BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "宋体"
- Size = 9
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- TabCaption(0) = "录 入"
- TabPicture(0) = "frm大病医疗记录.frx":0000
- Tab(0).ControlEnabled= -1 'True
- Tab(0).Control(0)= "lblLabels(1)"
- Tab(0).Control(0).Enabled= 0 'False
- Tab(0).Control(1)= "lblLabels(2)"
- Tab(0).Control(1).Enabled= 0 'False
- Tab(0).Control(2)= "lblLabels(3)"
- Tab(0).Control(2).Enabled= 0 'False
- Tab(0).Control(3)= "lblLabels(4)"
- Tab(0).Control(3).Enabled= 0 'False
- Tab(0).Control(4)= "lblLabels(5)"
- Tab(0).Control(4).Enabled= 0 'False
- Tab(0).Control(5)= "lblLabels(6)"
- Tab(0).Control(5).Enabled= 0 'False
- Tab(0).Control(6)= "lblLabels(7)"
- Tab(0).Control(6).Enabled= 0 'False
- Tab(0).Control(7)= "lblLabels(8)"
- Tab(0).Control(7).Enabled= 0 'False
- Tab(0).Control(8)= "cmdClose"
- Tab(0).Control(8).Enabled= 0 'False
- Tab(0).Control(9)= "cmdClear"
- Tab(0).Control(9).Enabled= 0 'False
- Tab(0).Control(10)= "RQ"
- Tab(0).Control(10).Enabled= 0 'False
- Tab(0).Control(11)= "TXT_QYBH"
- Tab(0).Control(11).Enabled= 0 'False
- Tab(0).Control(12)= "TXT_ND"
- Tab(0).Control(12).Enabled= 0 'False
- Tab(0).Control(13)= "TXT_ZGRS"
- Tab(0).Control(13).Enabled= 0 'False
- Tab(0).Control(14)= "TXT_JS"
- Tab(0).Control(14).Enabled= 0 'False
- Tab(0).Control(15)= "TXT_DWYJE"
- Tab(0).Control(15).Enabled= 0 'False
- Tab(0).Control(16)= "TXT_GRYJE"
- Tab(0).Control(16).Enabled= 0 'False
- Tab(0).Control(17)= "TXT_YJHJ"
- Tab(0).Control(17).Enabled= 0 'False
- Tab(0).Control(18)= "Picture1"
- Tab(0).Control(18).Enabled= 0 'False
- Tab(0).Control(19)= "TXT_grbl"
- Tab(0).Control(19).Enabled= 0 'False
- Tab(0).Control(20)= "TXT_DWBL"
- Tab(0).Control(20).Enabled= 0 'False
- Tab(0).Control(21)= "cmdUpdate"
- Tab(0).Control(21).Enabled= 0 'False
- Tab(0).ControlCount= 22
- TabCaption(1) = "列 表"
- TabPicture(1) = "frm大病医疗记录.frx":001C
- Tab(1).ControlEnabled= 0 'False
- Tab(1).Control(0)= "Frame2"
- Tab(1).Control(1)= "DataGrid1"
- Tab(1).Control(2)= "CMD_DEL"
- Tab(1).ControlCount= 3
- Begin Threed.SSCommand cmdUpdate
- Height = 375
- Left = 3960
- TabIndex = 7
- Top = 4680
- Width = 975
- _Version = 65536
- _ExtentX = 1720
- _ExtentY = 661
- _StockProps = 78
- Caption = "&Y.保 存"
- End
- Begin VB.CommandButton CMD_DEL
- Caption = "删除"
- Height = 375
- Left = -68160
- TabIndex = 29
- Top = 4800
- Width = 765
- End
- Begin MSDataGridLib.DataGrid DataGrid1
- Height = 2895
- Left = -74850
- TabIndex = 25
- Top = 1830
- Width = 7455
- _ExtentX = 13150
- _ExtentY = 5106
- _Version = 393216
- AllowUpdate = 0 'False
- AllowArrows = -1 'True
- BackColor = -2147483624
- ForeColor = -2147483646
- HeadLines = 1
- RowHeight = 14
- FormatLocked = -1 'True
- BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "宋体"
- Size = 9
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "宋体"
- Size = 9
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- ColumnCount = 9
- BeginProperty Column00
- DataField = "ID"
- Caption = "ID"
- BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
- Type = 0
- Format = ""
- HaveTrueFalseNull= 0
- FirstDayOfWeek = 0
- FirstWeekOfYear = 0
- LCID = 2052
- SubFormatType = 0
- EndProperty
- EndProperty
- BeginProperty Column01
- DataField = "企业编号"
- Caption = "企业编号"
- BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
- Type = 0
- Format = ""
- HaveTrueFalseNull= 0
- FirstDayOfWeek = 0
- FirstWeekOfYear = 0
- LCID = 2052
- SubFormatType = 0
- EndProperty
- EndProperty
- BeginProperty Column02
- DataField = "年度"
- Caption = "年度"
- BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
- Type = 0
- Format = ""
- HaveTrueFalseNull= 0
- FirstDayOfWeek = 0
- FirstWeekOfYear = 0
- LCID = 2052
- SubFormatType = 0
- EndProperty
- EndProperty
- BeginProperty Column03
- DataField = "日期"
- Caption = "日期"
- BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
- Type = 0
- Format = ""
- HaveTrueFalseNull= 0
- FirstDayOfWeek = 0
- FirstWeekOfYear = 0
- LCID = 2052
- SubFormatType = 0
- EndProperty
- EndProperty
- BeginProperty Column04
- DataField = "在职职工数"
- Caption = "人数"
- BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
- Type = 0
- Format = ""
- HaveTrueFalseNull= 0
- FirstDayOfWeek = 0
- FirstWeekOfYear = 0
- LCID = 2052
- SubFormatType = 0
- EndProperty
- EndProperty
- BeginProperty Column05
- DataField = "上年月平均工资总额"
- Caption = "月平均工资"
- BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
- Type = 0
- Format = ""
- HaveTrueFalseNull= 0
- FirstDayOfWeek = 0
- FirstWeekOfYear = 0
- LCID = 2052
- SubFormatType = 0
- EndProperty
- EndProperty
- BeginProperty Column06
- DataField = "单位应缴额"
- Caption = "单位应缴额"
- BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
- Type = 0
- Format = ""
- HaveTrueFalseNull= 0
- FirstDayOfWeek = 0
- FirstWeekOfYear = 0
- LCID = 2052
- SubFormatType = 0
- EndProperty
- EndProperty
- BeginProperty Column07
- DataField = "个人应缴额"
- Caption = "个人应缴额"
- BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
- Type = 0
- Format = ""
- HaveTrueFalseNull= 0
- FirstDayOfWeek = 0
- FirstWeekOfYear = 0
- LCID = 2052
- SubFormatType = 0
- EndProperty
- EndProperty
- BeginProperty Column08
- DataField = "应缴金额合计"
- Caption = "应缴金额合计"
- BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
- Type = 0
- Format = ""
- HaveTrueFalseNull= 0
- FirstDayOfWeek = 0
- FirstWeekOfYear = 0
- LCID = 2052
- SubFormatType = 0
- EndProperty
- EndProperty
- SplitCount = 1
- BeginProperty Split0
- BeginProperty Column00
- Object.Visible = 0 'False
- ColumnWidth = 915.024
- EndProperty
- BeginProperty Column01
- Object.Visible = 0 'False
- ColumnWidth = 1140.095
- EndProperty
- BeginProperty Column02
- ColumnWidth = 915.024
- EndProperty
- BeginProperty Column03
- ColumnWidth = 1305.071
- EndProperty
- BeginProperty Column04
- ColumnWidth = 480.189
- EndProperty
- BeginProperty Column05
- ColumnWidth = 1019.906
- EndProperty
- BeginProperty Column06
- ColumnWidth = 1140.095
- EndProperty
- BeginProperty Column07
- ColumnWidth = 1065.26
- EndProperty
- BeginProperty Column08
- ColumnWidth = 1200.189
- EndProperty
- EndProperty
- End
- Begin VB.Frame Frame2
- Caption = "查询条件"
- Height = 1155
- Left = -74910
- TabIndex = 24
- Top = 420
- Width = 7515
- Begin VB.CommandButton Command1
- Caption = "查询"
- Height = 405
- Left = 6540
- TabIndex = 28
- Top = 690
- Width = 855
- End
- Begin VB.TextBox TXT_CXND
- Appearance = 0 'Flat
- Height = 300
- Left = 2010
- TabIndex = 27
- Top = 450
- Width = 1335
- End
- Begin VB.Label Label1
- Caption = "年度"
- Height = 195
- Left = 1440
- TabIndex = 26
- Top = 503
- Width = 555
- End
- End
- Begin VB.TextBox TXT_DWBL
- Appearance = 0 'Flat
- Height = 285
- Left = 2040
- TabIndex = 23
- Text = "Text2"
- Top = 4470
- Visible = 0 'False
- Width = 1035
- End
- Begin VB.TextBox TXT_grbl
- Appearance = 0 'Flat
- Height = 285
- Left = 930
- TabIndex = 22
- Top = 4470
- Visible = 0 'False
- Width = 945
- End
- Begin VB.PictureBox Picture1
- BackColor = &H00808000&
- Height = 3345
- Left = 210
- ScaleHeight = 3285
- ScaleWidth = 2295
- TabIndex = 21
- Top = 870
- Width = 2355
- End
- Begin VB.TextBox TXT_YJHJ
- Appearance = 0 'Flat
- DataField = "应缴金额合计"
- DataSource = "datPrimaryRS"
- Height = 285
- Left = 5190
- TabIndex = 6
- Top = 3750
- Width = 1905
- End
- Begin VB.TextBox TXT_GRYJE
- Appearance = 0 'Flat
- DataField = "个人应缴额"
- DataSource = "datPrimaryRS"
- Height = 285
- Left = 5190
- TabIndex = 5
- Top = 3420
- Width = 1905
- End
- Begin VB.TextBox TXT_DWYJE
- Appearance = 0 'Flat
- DataField = "单位应缴额"
- DataSource = "datPrimaryRS"
- Height = 285
- Left = 5190
- TabIndex = 4
- Top = 3060
- Width = 1905
- End
- Begin VB.TextBox TXT_JS
- Appearance = 0 'Flat
- DataSource = "datPrimaryRS"
- Height = 285
- Left = 5190
- TabIndex = 3
- Top = 2700
- Width = 1905
- End
- Begin VB.TextBox TXT_ZGRS
- Appearance = 0 'Flat
- DataField = "在职职工数"
- DataSource = "datPrimaryRS"
- Height = 285
- Left = 5190
- TabIndex = 2
- Top = 2310
- Width = 1905
- End
- Begin VB.TextBox TXT_ND
- Appearance = 0 'Flat
- DataField = "年度"
- DataSource = "datPrimaryRS"
- Height = 285
- Left = 5190
- TabIndex = 0
- Top = 1485
- Width = 1395
- End
- Begin VB.TextBox TXT_QYBH
- Appearance = 0 'Flat
- BackColor = &H8000000B&
- DataField = "企业编号"
- DataSource = "datPrimaryRS"
- Height = 285
- Left = 5190
- Locked = -1 'True
- TabIndex = 13
- Top = 1050
- Width = 1905
- End
- Begin MSComCtl2.DTPicker RQ
- Height = 285
- Left = 5190
- TabIndex = 1
- Top = 1890
- Width = 1365
- _ExtentX = 2408
- _ExtentY = 503
- _Version = 393216
- Format = 26869761
- CurrentDate = 36305
- End
- Begin Threed.SSCommand cmdClear
- Height = 375
- Left = 5160
- TabIndex = 8
- Top = 4680
- Width = 975
- _Version = 65536
- _ExtentX = 1720
- _ExtentY = 661
- _StockProps = 78
- Caption = "&C.清 除"
- End
- Begin Threed.SSCommand cmdClose
- Height = 375
- Left = 6360
- TabIndex = 9
- Top = 4680
- Width = 975
- _Version = 65536
- _ExtentX = 1720
- _ExtentY = 661
- _StockProps = 78
- Caption = "&Q.关 闭"
- End
- Begin VB.Label lblLabels
- Alignment = 2 'Center
- Caption = "应缴金额合计"
- Height = 255
- Index = 8
- Left = 2820
- TabIndex = 20
- Top = 3825
- Width = 1815
- End
- Begin VB.Label lblLabels
- Alignment = 2 'Center
- Caption = "个人应缴额"
- Height = 255
- Index = 7
- Left = 2820
- TabIndex = 19
- Top = 3495
- Width = 1815
- End
- Begin VB.Label lblLabels
- Alignment = 2 'Center
- Caption = "单位应缴额"
- Height = 255
- Index = 6
- Left = 2820
- TabIndex = 18
- Top = 3120
- Width = 1815
- End
- Begin VB.Label lblLabels
- Alignment = 2 'Center
- Caption = "上年月平均工资总额"
- Height = 255
- Index = 5
- Left = 2820
- TabIndex = 17
- Top = 2790
- Width = 1815
- End
- Begin VB.Label lblLabels
- Alignment = 2 'Center
- Caption = "在职职工数"
- Height = 255
- Index = 4
- Left = 2820
- TabIndex = 16
- Top = 2400
- Width = 1815
- End
- Begin VB.Label lblLabels
- Alignment = 2 'Center
- Appearance = 0 'Flat
- BackColor = &H8000000B&
- Caption = "填报日期"
- ForeColor = &H80000008&
- Height = 255
- Index = 3
- Left = 2820
- TabIndex = 15
- Top = 1980
- Width = 1815
- End
- Begin VB.Label lblLabels
- Alignment = 2 'Center
- Caption = "年 度"
- Height = 255
- Index = 2
- Left = 2820
- TabIndex = 14
- Top = 1590
- Width = 1815
- End
- Begin VB.Label lblLabels
- Alignment = 2 'Center
- Caption = "企业编号"
- Height = 255
- Index = 1
- Left = 2820
- TabIndex = 12
- Top = 1185
- Width = 1815
- End
- End
- End
- End
- Attribute VB_Name = "frm_DBYLJL"
- Attribute VB_GlobalNameSpace = False
- Attribute VB_Creatable = False
- Attribute VB_PredeclaredId = True
- Attribute VB_Exposed = False
- Private Sub CMD_DEL_Click()
- DataGrid1.AllowDelete = True
- End Sub
- Private Sub cmdclear_Click()
- Me.TXT_CXND = ""
- Me.TXT_DWBL = ""
- Me.TXT_DWYJE = ""
- Me.TXT_grbl = ""
- Me.TXT_GRYJE = ""
- Me.TXT_JS = ""
- Me.txt_ND = ""
- Me.TXT_QYBH = ""
- Me.TXT_YJHJ = ""
- Me.TXT_ZGRS = ""
- End Sub
- Private Sub cmdClose_Click()
- RSGL.Enabled = True
- Unload Me
- End Sub
- Private Sub cmdUpdate_Click()
- If MsgBox("确认要保存记录吗?", vbYesNo + vbQuestion, "系统提示") = vbNo Then Exit Sub
- sqlbc = "insert 大病医疗记录 (年度,日期,在职职工数,上年月平均工资总额,单位应缴额,个人应缴额,应缴金额合计) values('" & txt_ND & "','" & RQ & "'," & TXT_ZGRS & "," & TXT_JS & "," & TXT_DWYJE & "," & TXT_GRYJE & "," & TXT_YJHJ & ")"
- Set rsbc = ConnWZ.Execute(sqlbc)
- End Sub
- Private Sub Command1_Click()
- Dim sSQL As String
- If TXT_CXND = "" Then
- MsgBox "请选择查询条件!"
- Else
- sSQL = "select * from 大病医疗记录 where 年度=" & TXT_CXND & ""
- Set adoPrimaryRS = New Recordset
- adoPrimaryRS.Open sSQL, db, adOpenStatic, adLockOptimistic
- Set DataGrid1.DataSource = adoPrimaryRS
- DataGrid1.Refresh
- End If
- End Sub
- Private Sub Form_Load()
- Dim STRjs As Long
- RQ.Value = Date
- txt_ND = Year(RQ)
- Sql = "select * from 比例基数维护表 where 年度=" & Trim(txt_ND) & ""
- Set rs = ConnWZ.Execute(Sql)
- If Not rs.EOF Then
- STRjs = rs("大病医疗基数")
- TXT_grbl = rs("个人应缴比例")
- TXT_DWBL = rs("单位应缴比例")
- End If
- Sql = "select * from 大病统筹登记 where 是否停止='否'"
- Set rs = ConnWZ.Execute(Sql)
- TXT_ZGRS = rs.RecordCount
- TXT_JS = Val(TXT_ZGRS) * STRjs
- TXT_DWYJE = Val(TXT_ZGRS) * Val(TXT_JS) * Val(TXT_DWBL)
- TXT_GRYJE = Val(TXT_ZGRS) * Val(TXT_JS) * Val(TXT_grbl)
- TXT_YJHJ = Val(TXT_DWYJE) + Val(TXT_GRYJE)
- End Sub
- Private Sub RQ_KeyPress(KeyAscii As Integer)
- If KeyAscii = vbKeyReturn Then
- SendKeys "{TAB}"
- End If
- End Sub
- Private Sub TXT_ND_KeyPress(KeyAscii As Integer)
- If KeyAscii = vbKeyReturn Then
- SendKeys "{TAB}"
- End If
- End Sub