?? frmsum.frm
字號:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form frmsum
Caption = "匯總"
ClientHeight = 4725
ClientLeft = 60
ClientTop = 345
ClientWidth = 6300
LinkTopic = "Form1"
MaxButton = 0 'False
ScaleHeight = 4725
ScaleWidth = 6300
StartUpPosition = 2 '屏幕中心
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 2895
Left = 600
TabIndex = 0
Top = 720
Width = 4575
_ExtentX = 8070
_ExtentY = 5106
_Version = 393216
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "按匯總"
Height = 195
Left = 720
TabIndex = 1
Top = 240
Width = 540
End
End
Attribute VB_Name = "frmsum"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim rs_sum As New ADODB.Recordset
Dim addup As Double
Private Sub Form_Load()
Dim sql As String
Select Case summary_menu
Case "check" '按入庫單號匯總
Label1.Caption = "按入庫單號匯總"
sql = "select 入庫單號,sum(金額) as 總金額 from 車輛資料 group by 入庫單號 order by sum(金額)"
rs_sum.CursorLocation = adUseClient
rs_sum.Open sql, conn, adOpenKeyset, adLockPessimistic
addup = 0
MSFlexGrid1.Rows = rs_sum.RecordCount + 2
MSFlexGrid1.Cols = 2
' 設置表頭
MSFlexGrid1.Row = 0
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = "入庫單號"
MSFlexGrid1.Col = 1
MSFlexGrid1.Text = "總金額"
'MSFlexGrid1.Col = 2
'MSFlexGrid1.Text = "情況"
If rs_sum.EOF = False Then
rs_sum.MoveFirst
Do While Not rs_sum.EOF
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = rs_sum.Fields(0)
MSFlexGrid1.Col = 1
If CDbl(rs_sum.Fields(1)) < 0 Then
MSFlexGrid1.Text = Replace(rs_sum.Fields(1), "-", "")
'MSFlexGrid1.Col = 2
'MSFlexGrid1.Text = "出庫"
Else
MSFlexGrid1.Text = rs_sum.Fields(1)
'MSFlexGrid1.Col = 2
'MSFlexGrid1.Text = "入庫"
End If
addup = addup + CDbl(rs_sum.Fields(1))
rs_sum.MoveNext
Loop
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = "(總計)"
MSFlexGrid1.Col = 1
MSFlexGrid1.Text = addup
End If
rs_sum.Close
Case "date" '按日期匯總
Label1.Caption = "按日期匯總"
sql = "select 日期,sum(金額) as 總金額 from 車輛資料 group by 日期 order by sum(金額)"
rs_sum.CursorLocation = adUseClient
rs_sum.Open sql, conn, adOpenKeyset, adLockPessimistic
addup = 0
MSFlexGrid1.Rows = rs_sum.RecordCount + 2
MSFlexGrid1.Cols = 2
MSFlexGrid1.Row = 0
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = "日期"
MSFlexGrid1.Col = 1
MSFlexGrid1.Text = "總金額"
'MSFlexGrid1.Col = 2
' MSFlexGrid1.Text = "情況"
If rs_sum.EOF = False Then
rs_sum.MoveFirst
Do While Not rs_sum.EOF
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = rs_sum.Fields(0)
MSFlexGrid1.Col = 1
If CDbl(rs_sum.Fields(1)) < 0 Then
MSFlexGrid1.Text = Replace(rs_sum.Fields(1), "-", "")
'MSFlexGrid1.Col = 2
'MSFlexGrid1.Text = "出庫"
Else
MSFlexGrid1.Text = rs_sum.Fields(1)
'MSFlexGrid1.Col = 2
'MSFlexGrid1.Text = "入庫"
End If
addup = addup + CDbl(rs_sum.Fields(1))
rs_sum.MoveNext
Loop
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = "(總計)"
MSFlexGrid1.Col = 1
MSFlexGrid1.Text = addup
End If
rs_sum.Close
Case "custom" '按供應商匯總
Label1.Caption = "按供應商匯總"
sql = "select 供應商名稱,sum(金額) as 總金額 from 車輛資料 group by 供應商名稱 order by sum(金額)"
rs_sum.CursorLocation = adUseClient
rs_sum.Open sql, conn, adOpenKeyset, adLockPessimistic
addup = 0
MSFlexGrid1.Rows = rs_sum.RecordCount + 2
MSFlexGrid1.Cols = 2
MSFlexGrid1.Row = 0
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = "供應商"
MSFlexGrid1.Col = 1
MSFlexGrid1.Text = "總金額"
'MSFlexGrid1.Col = 2
'MSFlexGrid1.Text = "情況"
If rs_sum.EOF = False Then
rs_sum.MoveFirst
Do While Not rs_sum.EOF
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = rs_sum.Fields(0)
MSFlexGrid1.Col = 1
If CDbl(rs_sum.Fields(1)) < 0 Then
MSFlexGrid1.Text = Replace(rs_sum.Fields(1), "-", "")
'MSFlexGrid1.Col = 2
'MSFlexGrid1.Text = "出庫"
Else
MSFlexGrid1.Text = rs_sum.Fields(1)
'MSFlexGrid1.Col = 2
'MSFlexGrid1.Text = "入庫"
End If
addup = addup + CDbl(rs_sum.Fields(1))
rs_sum.MoveNext
Loop
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = "(總計)"
MSFlexGrid1.Col = 1
MSFlexGrid1.Text = addup
End If
rs_sum.Close
Case "check_date" '按入庫單+日期匯總
Label1.Caption = "按入庫單+日期匯總"
sql = "select 入庫單號,日期,sum(金額) as 總金額 from 車輛資料 " & _
"group by 入庫單號,日期 order by sum(金額)"
rs_sum.CursorLocation = adUseClient
rs_sum.Open sql, conn, adOpenKeyset, adLockPessimistic
addup = 0
MSFlexGrid1.MergeCells = flexMergeRestrictRows
MSFlexGrid1.MergeCol(0) = True
MSFlexGrid1.Rows = rs_sum.RecordCount + 2
MSFlexGrid1.Rows = rs_sum.RecordCount + 2
MSFlexGrid1.Cols = 3
MSFlexGrid1.Row = 0
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = "入庫單"
MSFlexGrid1.Col = 1
MSFlexGrid1.Text = "日期"
MSFlexGrid1.Col = 2
MSFlexGrid1.Text = "總金額"
'MSFlexGrid1.Col = 3
'MSFlexGrid1.Text = "情況"
If rs_sum.EOF = False Then
rs_sum.MoveFirst
Do While Not rs_sum.EOF
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = rs_sum.Fields(0)
MSFlexGrid1.Col = 1
MSFlexGrid1.Text = rs_sum.Fields(1)
MSFlexGrid1.Col = 2
If CDbl(rs_sum.Fields(2)) < 0 Then
MSFlexGrid1.Text = Replace(rs_sum.Fields(2), "-", "")
'MSFlexGrid1.Col = 3
'MSFlexGrid1.Text = "出庫"
Else
MSFlexGrid1.Text = rs_sum.Fields(2)
'MSFlexGrid1.Col = 3
'MSFlexGrid1.Text = "入庫"
End If
addup = addup + CDbl(rs_sum.Fields(2))
rs_sum.MoveNext
Loop
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = "(總計)"
MSFlexGrid1.Col = 2
MSFlexGrid1.Text = addup
End If
rs_sum.Close
End Select
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -