📄 form3.frm
字号:
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form Form3
Caption = "Form3"
ClientHeight = 5445
ClientLeft = 60
ClientTop = 345
ClientWidth = 8250
LinkTopic = "Form3"
ScaleHeight = 5445
ScaleWidth = 8250
StartUpPosition = 3 '窗口缺省
Begin VB.Frame Frame2
Caption = "汇总"
Height = 1815
Left = 7080
TabIndex = 19
Top = 1080
Width = 1095
Begin VB.OptionButton Option7
Caption = "不汇总"
Height = 255
Left = 120
TabIndex = 23
Top = 1440
Width = 855
End
Begin VB.OptionButton Option6
Caption = "卖点"
Height = 255
Left = 120
TabIndex = 22
Top = 1080
Width = 855
End
Begin VB.OptionButton Option5
Caption = "办事处"
Height = 255
Left = 120
TabIndex = 21
Top = 720
Width = 855
End
Begin VB.OptionButton Option4
Caption = "全部"
Height = 255
Left = 120
TabIndex = 20
Top = 360
Width = 735
End
End
Begin VB.CommandButton DoubleDel
Caption = "删除"
Height = 375
Left = 5160
TabIndex = 18
Top = 2520
Visible = 0 'False
Width = 855
End
Begin VB.CommandButton DoubleAdd
Caption = "增加"
Height = 375
Left = 3720
TabIndex = 17
Top = 2520
Visible = 0 'False
Width = 855
End
Begin VB.ListBox DoubleList
Height = 1500
Left = 2880
TabIndex = 16
Top = 960
Visible = 0 'False
Width = 3975
End
Begin VB.ListBox SqlList
Height = 1950
Left = 2880
Style = 1 'Checkbox
TabIndex = 15
Top = 960
Visible = 0 'False
Width = 3975
End
Begin VB.TextBox WriteValue
Height = 270
Left = 4680
TabIndex = 13
Top = 1680
Visible = 0 'False
Width = 1575
End
Begin MSComCtl2.DTPicker DateEnd
Height = 375
Left = 4320
TabIndex = 10
Top = 2040
Visible = 0 'False
Width = 1935
_ExtentX = 3413
_ExtentY = 661
_Version = 393216
Format = 23592961
CurrentDate = 36383
End
Begin MSComCtl2.DTPicker DateBegin
Height = 375
Left = 4320
TabIndex = 9
Top = 1320
Visible = 0 'False
Width = 1935
_ExtentX = 3413
_ExtentY = 661
_Version = 393216
Format = 23592961
CurrentDate = 36383
End
Begin VB.CommandButton Command3
Caption = "报表"
Height = 495
Left = 5640
TabIndex = 8
Top = 4920
Width = 1215
End
Begin VB.CommandButton Command2
Caption = "图表"
Height = 495
Left = 3600
TabIndex = 7
Top = 4920
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "查询"
Height = 495
Left = 1680
TabIndex = 6
Top = 4920
Width = 1095
End
Begin VB.Frame Frame1
Caption = "类型"
Height = 735
Left = 120
TabIndex = 2
Top = 120
Width = 8055
Begin VB.OptionButton Option3
Caption = "Option3"
Height = 255
Left = 2760
TabIndex = 5
Top = 360
Width = 975
End
Begin VB.OptionButton Option2
Caption = "销售排行"
Height = 255
Left = 1560
TabIndex = 4
Top = 360
Width = 1095
End
Begin VB.OptionButton Option1
Caption = "销售明细"
Height = 255
Left = 240
TabIndex = 3
Top = 360
Width = 1095
End
End
Begin VB.ListBox DestList
Height = 1680
Left = 120
TabIndex = 1
Top = 3120
Width = 8055
End
Begin VB.ListBox SourceList
Height = 1950
Left = 120
Style = 1 'Checkbox
TabIndex = 0
Top = 960
Width = 2655
End
Begin VB.Line Line2
BorderColor = &H00FF8080&
BorderWidth = 2
X1 = 0
X2 = 8280
Y1 = 3000
Y2 = 3000
End
Begin VB.Line Line1
BorderColor = &H00FF8080&
BorderWidth = 2
X1 = 0
X2 = 8280
Y1 = 900
Y2 = 900
End
Begin VB.Label WriteValueLabel
AutoSize = -1 'True
Caption = "请输入关键字"
Height = 180
Left = 3240
TabIndex = 14
Top = 1680
Visible = 0 'False
Width = 1080
End
Begin VB.Label DateEndLabel
Caption = "至"
Height = 255
Left = 3600
TabIndex = 12
Top = 2160
Visible = 0 'False
Width = 615
End
Begin VB.Label DataBeginLabel
Caption = "日期从"
Height = 255
Left = 3600
TabIndex = 11
Top = 1440
Visible = 0 'False
Width = 615
End
End
Attribute VB_Name = "Form3"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim SourceRst As New ADODB.Recordset, DestRst As New ADODB.Recordset
Dim CurrentSource As Integer, DestArray() As String
Private Sub DoubleAdd_Click()
Dim s As String
SourceRst.Filter = "Class='" & SourceList.List(SourceList.ListIndex) & "'"
KillString SourceRst![valuedisplay]
s = FindSqlCodeDouble(SourceRst![DoSource], QuickTranArray(1), QuickTranArray(2), SourceRst![DisPlayHead])
Me.DoubleList.AddItem QuickTranArray(2)
End Sub
Private Sub DoubleDel_Click()
If DoubleList.SelCount > 0 Then
DoubleList.RemoveItem DoubleList.ListIndex
End If
End Sub
Private Sub Form_Load()
Dim i As Long, j As Long
SourceRst.Open "select * from XtQueryClass", GetConnect, adOpenStatic, adLockReadOnly
With DestRst
.Fields.Append "DoClass", adVarChar, 20
.Fields.Append "DoType", adVarChar, 10
.Fields.Append "DoValue", adVarChar, 100
.Fields.Append "DisValue", adVarChar, 100
.LockType = adLockOptimistic
.CursorLocation = adUseServer
.CursorType = adOpenStatic
.Open
End With
i = SourceRst.RecordCount
If i > 0 Then
SourceRst.MoveFirst
For j = 1 To i
SourceList.AddItem SourceRst![Class]
SourceRst.MoveNext
Next
End If
CurrentSource = -1
End Sub
Private Sub PrintSqlBox()
Dim i As Long, j As Long, s As String, l As String, Rst1 As New ADODB.Recordset
Dim a As Long, b As Long
Me.WriteValue.Visible = False
Me.WriteValueLabel.Visible = False
Me.SqlList.Visible = False
Me.DataBeginLabel.Visible = False
Me.DateBegin.Visible = False
Me.DateEnd.Visible = False
Me.DateEndLabel.Visible = False
Me.WriteValue.Visible = False
Me.WriteValueLabel.Visible = False
Me.DoubleList.Visible = False
Me.DoubleAdd.Visible = False
Me.DoubleDel.Visible = False
Me.SqlList.Clear
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -