结账之SSTab

来源：互联网发布：stm32用ucos还是linux 编辑：程序博客网时间：2024/04/26 08:09

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

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

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

用法：

Private Sub SSTab1_Click(PreviousTab As Integer)

Dim sum As Long, sum1 As Long, sum2 As LongDim 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, 0) = "学号"            .TextMatrix(0, 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, 0) = "学号"            .TextMatrix(0, 1) = "卡号"            .TextMatrix(0, 2) = "日期"            .TextMatrix(0, 3) = "时间"            .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, 0) = "学号"            .TextMatrix(0, 1) = "卡号"            .TextMatrix(0, 2) = "日期"            .TextMatrix(0, 3) = "时间"            .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, 255);"><span style="color:#009900;"> '汇总</span></span></strong>        txtsellcardcount.Text = myflexgrid1.Rows - 1    <span style="background-color: rgb(255, 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 SelectEnd Sub</strong>

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

0 0