加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

结账之SSTab

发布时间:2020-12-17 07:44:34 所属栏目:百科 来源:网络整理
导读:刚打开结账窗体,就看到一个既陌生又亲切的控件---SSTab,记得在敲VB百例的时候,用过这个控件,今天看到它的时候一点都想不起来它叫什么来着,通过翻阅师姐的博客,才知道原来它就叫做SStab,是部件中的一个控件。 加载 : 工程→部件→控件 中勾

刚打开结账窗体,就看到一个既陌生又亲切的控件---SSTab,记得在敲VB百例的时候,用过这个控件,今天看到它的时候一点都想不起来它叫什么来着,通过翻阅师姐的博客,才知道原来它就叫做SStab,是部件中的一个控件。


加载工程→部件→控件 中勾选“Microsoft Tabbed Dialog Control”控件,点击应用

介绍SSTab控件提供了一组选项卡,每个都充当一个容器,包含了其他的控件。控件中每次只有一个选项卡是活动的,给用户提供了其所包含的控件,而其他选项卡都是隐藏的。


用法:

Private Sub SSTab1_Click(PreviousTab As Integer)

Dim sum As Long,sum1 As Long,sum2 As Long
Dim i As Long
<span style="color:#009900;">'选择sstab的各个选项卡</span>
<strong>Select Case SSTab1.Tab
    Case 0   <span style="color:#009900;">'购卡</span></strong>
    <span style="color:#009900;">'从数据库中选择对应用户的内容</span>
    txtSQL1 = "select * from student_info where userid='" & Trim(combouserID.Text) & "'"
    Set mrc1 = ExecuteSQL(txtSQL1,Msgtext)
    
        With myflexgrid1
            .Rows = 1
            .TextMatrix(0,0) = "学号"
            .TextMatrix(0,1) = "卡号"
            .TextMatrix(0,2) = "日期"
            .TextMatrix(0,3) = "时间"
            .TextMatrix(0,4) = "金额"
            Do While Not mrc1.EOF
                .Rows = .Rows + 1
                .CellAlignment = 4
                .TextMatrix(.Rows - 1,0) = mrc1.Fields(1)
                .TextMatrix(.Rows - 1,1) = mrc1.Fields(0)
                .TextMatrix(.Rows - 1,2) = mrc1.Fields(12)
                .TextMatrix(.Rows - 1,3) = mrc1.Fields(13)
                .TextMatrix(.Rows - 1,4) = mrc1.Fields(7)
                mrc1.MoveNext
                Call AdjustColWidth(frmcheckoutaccount,myflexgrid1)  <span style="color:#009900;">'自定调节myflexgrid的列宽</span>
           Loop
        End With
            
    <strong>Case 1      <span style="color:#009900;">'充值</span></strong>
    txtSQL2 = "select * from recharge_info where userid='" & Trim(combouserID.Text) & "'"
    Set mrc2 = ExecuteSQL(txtSQL2,Msgtext)
       
        With myflexgrid2
            .Rows = 1
            .TextMatrix(0,2) = "充值金额"
            .TextMatrix(0,3) = "日期"
            .TextMatrix(0,4) = "时间"
            Do While Not mrc2.EOF
                .Rows = .Rows + 1
                .CellAlignment = 4
                .TextMatrix(.Rows - 1,0) = mrc2.Fields(1)
                .TextMatrix(.Rows - 1,1) = mrc2.Fields(2)
                .TextMatrix(.Rows - 1,2) = mrc2.Fields(3)
                .TextMatrix(.Rows - 1,3) = mrc2.Fields(4)
                .TextMatrix(.Rows - 1,4) = mrc2.Fields(5)
                 mrc2.MoveNext
                Call AdjustColWidth(frmcheckoutaccount,myflexgrid2) <span style="color:#009900;"> '自定调节myflexgrid的列宽</span>
           Loop
            
       End With
   <strong> Case 2      <span style="color:#009900;"> '退卡</span></strong>
    txtSQL3 = "select * from cancelcard_info where userid='" & Trim(combouserID.Text) & "'"
    Set mrc3 = ExecuteSQL(txtSQL3,Msgtext)
    
        With myflexgrid3
            .Rows = 1
            .TextMatrix(0,4) = "退卡金额"
            Do While Not mrc3.EOF
                .Rows = .Rows + 1
                .CellAlignment = 4
                .TextMatrix(.Rows - 1,0) = mrc3.Fields(0)
                .TextMatrix(.Rows - 1,1) = mrc3.Fields(1)
                .TextMatrix(.Rows - 1,2) = mrc3.Fields(3)
                .TextMatrix(.Rows - 1,3) = mrc3.Fields(4)
                .TextMatrix(.Rows - 1,4) = mrc3.Fields(2)
                 mrc3.MoveNext
                Call AdjustColWidth(frmcheckoutaccount,myflexgrid3)  <span style="color:#009900;">'自定调节myflexgrid的列宽</span>
           Loop
        
        End With
   <strong> Case 3      <span style="color:#009900;">'临时用户</span></strong>
    txtSQL4 = "select * from student_info where userid='" & Trim(combouserID.Text) & "' and type='临时用户'"
    Set mrc4 = ExecuteSQL(txtSQL4,Msgtext)
    
        With myflexgrid4
            .Rows = 1
            .TextMatrix(0,4) = "金额"
            Do While Not mrc4.EOF
                .Rows = .Rows + 1
                .CellAlignment = 4
                .TextMatrix(.Rows - 1,0) = mrc4.Fields(1)
                .TextMatrix(.Rows - 1,1) = mrc4.Fields(0)
                .TextMatrix(.Rows - 1,2) = mrc4.Fields(12)
                .TextMatrix(.Rows - 1,3) = mrc4.Fields(13)
                .TextMatrix(.Rows - 1,4) = mrc4.Fields(7)
                mrc4.MoveNext
                Call AdjustColWidth(frmcheckoutaccount,myflexgrid4)  <span style="color:#009900;">'自定调节myflexgrid的列宽</span>
           Loop
           
        End With
    
 <strong>   Case 4  <span style="background-color: rgb(255,255);"><span style="color:#009900;"> '汇总</span></span></strong>
        txtsellcardcount.Text = myflexgrid1.Rows - 1    <span style="background-color: rgb(255,255);"><span style="color:#009900;"> '售卡数</span></span>
        txtcancelcardcount.Text = myflexgrid3.Rows - 1    <span style="color:#009900;"> '退卡数</span>
        txtallsellcard.Text = Val(txtsellcardcount.Text) - Val(txtcancelcardcount.Text)  <span style="color:#009900;"> '总售卡数</span>
        <span style="color:#009900;">'充值金额</span>
        For i = 1 To myflexgrid2.Rows - 1
        sum = sum + Val(myflexgrid2.TextMatrix(i,2))
        Next
        txtpay.Text = sum
       <span style="color:#009900;">  '退卡金额</span>
        For i = 1 To myflexgrid3.Rows - 1
        sum1 = sum1 + Val(myflexgrid3.TextMatrix(i,4))
        Next
        txtcancelcardpay.Text = sum1
        <span style="color:#009900;">'临时收取金额</span>
        For i = 1 To myflexgrid4.Rows - 1
        sum2 = sum2 + Val(myflexgrid4.TextMatrix(i,4))
        Next
        txtlspay.Text = sum2
        txtcountpay.Text = sum - sum1
    <strong>Case 5   </strong><span style="color:#009900;">'退出</span>
        Unload Me
<strong>End Select
End Sub</strong>

总结:当遇到一个陌生的事物时,就要慢慢去摸索、探究,在我们的不断努力下,它们就会甘拜下风,为我们所用,学习是这样,生活亦是这样,加油!

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读