frm_sqjz_xg.frm

来自「基于VB开发的一个连接数据库的人口管理系统 其中包括程序设计报告 使用说明等 源」· FRM 代码 · 共 553 行 · 第 1/2 页

FRM
553 行
字号
12
    ElseIf i = 1 Then
    frm_SQJZ_XGCT.Adodc1.RecordSource = "select * from Table_SQJZ_DBRY where " + Combo1.Text + "<'" + a + "'"
    frm_SQJZ_XGCT.Adodc1.Refresh
    ElseIf i = 2 Then
    frm_SQJZ_XGCT.Adodc1.RecordSource = "select * from Table_SQJZ_DBRY where " + Combo1.Text + "<='" + a + "'"
    frm_SQJZ_XGCT.Adodc1.Refresh
    ElseIf i = 3 Then
    frm_SQJZ_XGCT.Adodc1.RecordSource = "select * from Table_SQJZ_DBRY where " + Combo1.Text + ">'" + a + "'"
    frm_SQJZ_XGCT.Adodc1.Refresh
    ElseIf i = 4 Then
    frm_SQJZ_XGCT.Adodc1.RecordSource = "select * from Table_SQJZ_DBRY where " + Combo1.Text + ">='" + a + "'"
    frm_SQJZ_XGCT.Adodc1.Refresh
    ElseIf i = 5 Then
    frm_SQJZ_XGCT.Adodc1.RecordSource = "select * from Table_SQJZ_DBRY where " + Combo1.Text + " like '%" + a + "%'"
    frm_SQJZ_XGCT.Adodc1.Refresh
    Else
    End If
    frm_SQJZ_XGCT.Show
    frm_SQJZ_XGCT.Frame1(0).Visible = True
    frm_SQJZ_XGCT.Frame2(0).Visible = True
    frm_SQJZ_XGCT.Frame1(1).Visible = False
    frm_SQJZ_XGCT.Frame2(1).Visible = False
    frm_SQJZ_XGCT.Frame1(6).Visible = False
    frm_SQJZ_XGCT.Frame2(6).Visible = False
    frm_SQJZ_XGCT.Frame1(2).Visible = False
    frm_SQJZ_XGCT.Frame2(2).Visible = False
    frm_SQJZ_XGCT.Frame1(3).Visible = False
    frm_SQJZ_XGCT.Frame2(3).Visible = False
    frm_SQJZ_XGCT.Frame1(4).Visible = False
    frm_SQJZ_XGCT.Frame2(4).Visible = False
    frm_SQJZ_XGCT.Frame1(5).Visible = False
    frm_SQJZ_XGCT.Frame2(5).Visible = False
    Unload Me
ElseIf Option2.Value = True Then
    a = Text1.Text
    If i = 0 Then
    frm_SQJZ_XGCT.Adodc2.RecordSource = "select * from Table_SQJZ_SYRY where " + Combo1.Text + "='" + a + "'"
    frm_SQJZ_XGCT.Adodc2.Refresh
    ElseIf i = 1 Then
    frm_SQJZ_XGCT.Adodc2.RecordSource = "select * from Table_SQJZ_SYRY where " + Combo1.Text + "<'" + a + "'"
    frm_SQJZ_XGCT.Adodc2.Refresh
    ElseIf i = 2 Then
    frm_SQJZ_XGCT.Adodc2.RecordSource = "select * from Table_SQJZ_SYRY where " + Combo1.Text + "<='" + a + "'"
    frm_SQJZ_XGCT.Adodc2.Refresh
    ElseIf i = 3 Then
    frm_SQJZ_XGCT.Adodc2.RecordSource = "select * from Table_SQJZ_SYRY where " + Combo1.Text + ">'" + a + "'"
    frm_SQJZ_XGCT.Adodc2.Refresh
    ElseIf i = 4 Then
    frm_SQJZ_XGCT.Adodc2.RecordSource = "select * from Table_SQJZ_SYRY where " + Combo1.Text + ">='" + a + "'"
    frm_SQJZ_XGCT.Adodc2.Refresh
    ElseIf i = 5 Then
    frm_SQJZ_XGCT.Adodc2.RecordSource = "select * from Table_SQJZ_SYRY where " + Combo1.Text + " like '%" + a + "%'"
    frm_SQJZ_XGCT.Adodc2.Refresh
    Else
    End If
    frm_SQJZ_XGCT.Show
    frm_SQJZ_XGCT.Frame1(0).Visible = False
    frm_SQJZ_XGCT.Frame2(0).Visible = False
    frm_SQJZ_XGCT.Frame1(1).Visible = False
    frm_SQJZ_XGCT.Frame2(1).Visible = False
    frm_SQJZ_XGCT.Frame1(6).Visible = False
    frm_SQJZ_XGCT.Frame2(6).Visible = False
    frm_SQJZ_XGCT.Frame1(2).Visible = False
    frm_SQJZ_XGCT.Frame2(2).Visible = False
    frm_SQJZ_XGCT.Frame1(3).Visible = True
    frm_SQJZ_XGCT.Frame2(3).Visible = True
    frm_SQJZ_XGCT.Frame1(4).Visible = False
    frm_SQJZ_XGCT.Frame2(4).Visible = False
    frm_SQJZ_XGCT.Frame1(5).Visible = False
    frm_SQJZ_XGCT.Frame2(5).Visible = False
    Unload Me
ElseIf Option3.Value = True Then
    a = Text1.Text
    If i = 0 Then
    frm_SQJZ_XGCT.Adodc3.RecordSource = "select * from Table_SQJZ_YFRY where " + Combo1.Text + "='" + a + "'"
    frm_SQJZ_XGCT.Adodc3.Refresh
    ElseIf i = 1 Then
    frm_SQJZ_XGCT.Adodc3.RecordSource = "select * from Table_SQJZ_YFRY where " + Combo1.Text + "<'" + a + "'"
    frm_SQJZ_XGCT.Adodc3.Refresh
    ElseIf i = 2 Then
    frm_SQJZ_XGCT.Adodc3.RecordSource = "select * from Table_SQJZ_YFRY where " + Combo1.Text + "<='" + a + "'"
    frm_SQJZ_XGCT.Adodc3.Refresh
    ElseIf i = 3 Then
    frm_SQJZ_XGCT.Adodc3.RecordSource = "select * from Table_SQJZ_YFRY where " + Combo1.Text + ">'" + a + "'"
    frm_SQJZ_XGCT.Adodc3.Refresh
    ElseIf i = 4 Then
    frm_SQJZ_XGCT.Adodc3.RecordSource = "select * from Table_SQJZ_YFRY where " + Combo1.Text + ">='" + a + "'"
    frm_SQJZ_XGCT.Adodc3.Refresh
    ElseIf i = 5 Then
    frm_SQJZ_XGCT.Adodc3.RecordSource = "select * from Table_SQJZ_YFRY where " + Combo1.Text + " like '%" + a + "%'"
    frm_SQJZ_XGCT.Adodc3.Refresh
    Else
    End If
    frm_SQJZ_XGCT.Show
    frm_SQJZ_XGCT.Frame1(0).Visible = False
    frm_SQJZ_XGCT.Frame2(0).Visible = False
    frm_SQJZ_XGCT.Frame1(1).Visible = False
    frm_SQJZ_XGCT.Frame2(1).Visible = False
    frm_SQJZ_XGCT.Frame1(6).Visible = False
    frm_SQJZ_XGCT.Frame2(6).Visible = False
    frm_SQJZ_XGCT.Frame1(2).Visible = False
    frm_SQJZ_XGCT.Frame2(2).Visible = False
    frm_SQJZ_XGCT.Frame1(3).Visible = False
    frm_SQJZ_XGCT.Frame2(3).Visible = False
    frm_SQJZ_XGCT.Frame1(4).Visible = True
    frm_SQJZ_XGCT.Frame2(4).Visible = True
    frm_SQJZ_XGCT.Frame1(5).Visible = False
    frm_SQJZ_XGCT.Frame2(5).Visible = False
    Unload Me
ElseIf Option4.Value = True Then
    a = Text1.Text
    If i = 0 Then
    frm_SQJZ_XGCT.Adodc4.RecordSource = "select * from Table_SQJZ_LLRY where " + Combo1.Text + "='" + a + "'"
    frm_SQJZ_XGCT.Adodc4.Refresh
    ElseIf i = 1 Then
    frm_SQJZ_XGCT.Adodc4.RecordSource = "select * from Table_SQJZ_LLRY where " + Combo1.Text + "<'" + a + "'"
    frm_SQJZ_XGCT.Adodc4.Refresh
    ElseIf i = 2 Then
    frm_SQJZ_XGCT.Adodc4.RecordSource = "select * from Table_SQJZ_LLRY where " + Combo1.Text + "<='" + a + "'"
    frm_SQJZ_XGCT.Adodc4.Refresh
    ElseIf i = 3 Then
    frm_SQJZ_XGCT.Adodc4.RecordSource = "select * from Table_SQJZ_LLRY where " + Combo1.Text + ">'" + a + "'"
    frm_SQJZ_XGCT.Adodc4.Refresh
    ElseIf i = 4 Then
    frm_SQJZ_XGCT.Adodc4.RecordSource = "select * from Table_SQJZ_LLRY where " + Combo1.Text + ">='" + a + "'"
    frm_SQJZ_XGCT.Adodc4.Refresh
    ElseIf i = 5 Then
    frm_SQJZ_XGCT.Adodc4.RecordSource = "select * from Table_SQJZ_LLRY where " + Combo1.Text + " like '%" + a + "%'"
    frm_SQJZ_XGCT.Adodc4.Refresh
    Else
    End If
    frm_SQJZ_XGCT.Show
    frm_SQJZ_XGCT.Frame1(0).Visible = False
    frm_SQJZ_XGCT.Frame2(0).Visible = False
    frm_SQJZ_XGCT.Frame1(1).Visible = False
    frm_SQJZ_XGCT.Frame2(1).Visible = False
    frm_SQJZ_XGCT.Frame1(6).Visible = False
    frm_SQJZ_XGCT.Frame2(6).Visible = False
    frm_SQJZ_XGCT.Frame1(2).Visible = False
    frm_SQJZ_XGCT.Frame2(2).Visible = False
    frm_SQJZ_XGCT.Frame1(3).Visible = False
    frm_SQJZ_XGCT.Frame2(3).Visible = False
    frm_SQJZ_XGCT.Frame1(4).Visible = False
    frm_SQJZ_XGCT.Frame2(4).Visible = False
    frm_SQJZ_XGCT.Frame1(5).Visible = True
    frm_SQJZ_XGCT.Frame2(5).Visible = True
    Unload Me
ElseIf Option5.Value = True Then
    a = Text1.Text
    If i = 0 Then
    frm_SQJZ_XGCT.Adodc5.RecordSource = "select * from Table_SQJZ_GZDX where " + Combo1.Text + "='" + a + "'"
    frm_SQJZ_XGCT.Adodc5.Refresh
    ElseIf i = 1 Then
    frm_SQJZ_XGCT.Adodc5.RecordSource = "select * from Table_SQJZ_GZDX where " + Combo1.Text + "<'" + a + "'"
    frm_SQJZ_XGCT.Adodc5.Refresh
    ElseIf i = 2 Then
    frm_SQJZ_XGCT.Adodc5.RecordSource = "select * from Table_SQJZ_GZDX where " + Combo1.Text + "<='" + a + "'"
    frm_SQJZ_XGCT.Adodc5.Refresh
    ElseIf i = 3 Then
    frm_SQJZ_XGCT.Adodc5.RecordSource = "select * from Table_SQJZ_GZDX where " + Combo1.Text + ">'" + a + "'"
    frm_SQJZ_XGCT.Adodc5.Refresh
    ElseIf i = 4 Then
    frm_SQJZ_XGCT.Adodc5.RecordSource = "select * from Table_SQJZ_GZDX where " + Combo1.Text + ">='" + a + "'"
    frm_SQJZ_XGCT.Adodc5.Refresh
    ElseIf i = 5 Then
    frm_SQJZ_XGCT.Adodc5.RecordSource = "select * from Table_SQJZ_GZDX where " + Combo1.Text + " like '%" + a + "%'"
    frm_SQJZ_XGCT.Adodc5.Refresh
    Else
    End If
    frm_SQJZ_XGCT.Show
    frm_SQJZ_XGCT.Frame1(0).Visible = False
    frm_SQJZ_XGCT.Frame2(0).Visible = False
    frm_SQJZ_XGCT.Frame1(1).Visible = False
    frm_SQJZ_XGCT.Frame2(1).Visible = False
    frm_SQJZ_XGCT.Frame1(6).Visible = False
    frm_SQJZ_XGCT.Frame2(6).Visible = False
    frm_SQJZ_XGCT.Frame1(2).Visible = True
    frm_SQJZ_XGCT.Frame2(2).Visible = True
    frm_SQJZ_XGCT.Frame1(3).Visible = False
    frm_SQJZ_XGCT.Frame2(3).Visible = False
    frm_SQJZ_XGCT.Frame1(4).Visible = False
    frm_SQJZ_XGCT.Frame2(4).Visible = False
    frm_SQJZ_XGCT.Frame1(5).Visible = False
    frm_SQJZ_XGCT.Frame2(5).Visible = False
    Unload Me
ElseIf Option6.Value = True Then
    a = Text1.Text
    If i = 0 Then
    frm_SQJZ_XGCT.Adodc6.RecordSource = "select * from Table_SQJZ_OLD where " + Combo1.Text + "='" + a + "'"
    frm_SQJZ_XGCT.Adodc6.Refresh
    ElseIf i = 1 Then
    frm_SQJZ_XGCT.Adodc6.RecordSource = "select * from Table_SQJZ_OLD where " + Combo1.Text + "<'" + a + "'"
    frm_SQJZ_XGCT.Adodc6.Refresh
    ElseIf i = 2 Then
    frm_SQJZ_XGCT.Adodc6.RecordSource = "select * from Table_SQJZ_OLD where " + Combo1.Text + "<='" + a + "'"
    frm_SQJZ_XGCT.Adodc6.Refresh
    ElseIf i = 3 Then
    frm_SQJZ_XGCT.Adodc6.RecordSource = "select * from Table_SQJZ_OLD where " + Combo1.Text + ">'" + a + "'"
    frm_SQJZ_XGCT.Adodc6.Refresh
    ElseIf i = 4 Then
    frm_SQJZ_XGCT.Adodc6.RecordSource = "select * from Table_SQJZ_OLD where " + Combo1.Text + ">='" + a + "'"
    frm_SQJZ_XGCT.Adodc6.Refresh
    ElseIf i = 5 Then
    frm_SQJZ_XGCT.Adodc6.RecordSource = "select * from Table_SQJZ_OLD where " + Combo1.Text + " like '%" + a + "%'"
    frm_SQJZ_XGCT.Adodc6.Refresh
    Else
    End If
    frm_SQJZ_XGCT.Show
    frm_SQJZ_XGCT.Frame1(0).Visible = False
    frm_SQJZ_XGCT.Frame2(0).Visible = False
    frm_SQJZ_XGCT.Frame1(1).Visible = False
    frm_SQJZ_XGCT.Frame2(1).Visible = False
    frm_SQJZ_XGCT.Frame1(6).Visible = True
    frm_SQJZ_XGCT.Frame2(6).Visible = True
    frm_SQJZ_XGCT.Frame1(2).Visible = False
    frm_SQJZ_XGCT.Frame2(2).Visible = False
    frm_SQJZ_XGCT.Frame1(3).Visible = False
    frm_SQJZ_XGCT.Frame2(3).Visible = False
    frm_SQJZ_XGCT.Frame1(4).Visible = False
    frm_SQJZ_XGCT.Frame2(4).Visible = False
    frm_SQJZ_XGCT.Frame1(5).Visible = False
    frm_SQJZ_XGCT.Frame2(5).Visible = False
    Unload Me
ElseIf Option7.Value = True Then
    a = Text1.Text
    If i = 0 Then
    frm_SQJZ_XGCT.Adodc7.RecordSource = "select * from Table_SQJZ_CJRB where " + Combo1.Text + "='" + a + "'"
    frm_SQJZ_XGCT.Adodc7.Refresh
    ElseIf i = 1 Then
    frm_SQJZ_XGCT.Adodc7.RecordSource = "select * from Table_SQJZ_CJRB where " + Combo1.Text + "<'" + a + "'"
    frm_SQJZ_XGCT.Adodc7.Refresh
    ElseIf i = 2 Then
    frm_SQJZ_XGCT.Adodc7.RecordSource = "select * from Table_SQJZ_CJRB where " + Combo1.Text + "<='" + a + "'"
    frm_SQJZ_XGCT.Adodc7.Refresh
    ElseIf i = 3 Then
    frm_SQJZ_XGCT.Adodc7.RecordSource = "select * from Table_SQJZ_CJRB where " + Combo1.Text + ">'" + a + "'"
    frm_SQJZ_XGCT.Adodc7.Refresh
    ElseIf i = 4 Then
    frm_SQJZ_XGCT.Adodc7.RecordSource = "select * from Table_SQJZ_CJRB where " + Combo1.Text + ">='" + a + "'"
    frm_SQJZ_XGCT.Adodc7.Refresh
    ElseIf i = 5 Then
    frm_SQJZ_XGCT.Adodc7.RecordSource = "select * from Table_SQJZ_CJRB where " + Combo1.Text + " like '%" + a + "%'"
    frm_SQJZ_XGCT.Adodc7.Refresh
    Else
    End If
    frm_SQJZ_XGCT.Show
    frm_SQJZ_XGCT.Frame1(0).Visible = False
    frm_SQJZ_XGCT.Frame2(0).Visible = False
    frm_SQJZ_XGCT.Frame1(1).Visible = True
    frm_SQJZ_XGCT.Frame2(1).Visible = True
    frm_SQJZ_XGCT.Frame1(6).Visible = False
    frm_SQJZ_XGCT.Frame2(6).Visible = False
    frm_SQJZ_XGCT.Frame1(2).Visible = False
    frm_SQJZ_XGCT.Frame2(2).Visible = False
    frm_SQJZ_XGCT.Frame1(3).Visible = False
    frm_SQJZ_XGCT.Frame2(3).Visible = False
    frm_SQJZ_XGCT.Frame1(4).Visible = False
    frm_SQJZ_XGCT.Frame2(4).Visible = False
    frm_SQJZ_XGCT.Frame1(5).Visible = False
    frm_SQJZ_XGCT.Frame2(5).Visible = False
    Unload Me
Else
End If
End If
End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub Form_Load()
Me.Left = (Screen.Width - Me.Width) / 2
Me.Top = (Screen.Height - Me.Height) / 2
End Sub
12

frm_sqjz_xg.frm - 源码说明

本页面展示了「基于VB开发的一个连接数据库的人口管理系统 其中包括程序设计报告 使用说明等 源码」中的 frm_sqjz_xg.frm 源码文件，采用 FRM 编程语言编写，共 553 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与连接相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?