📄 xsqk.frm
字号:
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Object = "{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0"; "MSHFLXGD.OCX"
Begin VB.Form xsqk
BorderStyle = 1 'Fixed Single
Caption = "销售情况"
ClientHeight = 6405
ClientLeft = 45
ClientTop = 300
ClientWidth = 9015
LinkTopic = "Form2"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 6405
ScaleWidth = 9015
WindowState = 2 'Maximized
Begin VB.PictureBox Picture6
Appearance = 0 'Flat
BackColor = &H80000005&
ForeColor = &H80000008&
Height = 6405
Left = 0
Picture = "xsqk.frx":0000
ScaleHeight = 6375
ScaleWidth = 8985
TabIndex = 0
Top = 0
Width = 9015
Begin MSComCtl2.DTPicker DTPicker1
Height = 255
Left = 2640
TabIndex = 16
Top = 1080
Width = 1575
_ExtentX = 2778
_ExtentY = 450
_Version = 393216
Format = 66191361
UpDown = -1 'True
CurrentDate = 37566
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid MSHFlexGrid1
Bindings = "xsqk.frx":AE9A
Height = 1935
Left = 960
TabIndex = 1
Top = 3480
Width = 7095
_ExtentX = 12515
_ExtentY = 3413
_Version = 393216
Rows = 10
Cols = 6
ScrollBars = 2
AllowUserResizing= 3
RowSizingMode = 1
_NumberOfBands = 1
_Band(0).Cols = 6
End
Begin MSAdodcLib.Adodc Adodc1
Height = 375
Left = 2880
Top = 5760
Visible = 0 'False
Width = 1335
_ExtentX = 2355
_ExtentY = 661
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dzqch;Data Source=CZMK-SERVER"
OLEDBString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dzqch;Data Source=CZMK-SERVER"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "SELECT * from jlk where hwm like '%煤%'"
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.Label Label1
Caption = "查询日期"
Height = 255
Left = 960
TabIndex = 15
Top = 1080
Width = 1455
End
Begin VB.Image Image2
Appearance = 0 'Flat
BorderStyle = 1 'Fixed Single
Height = 510
Left = 8400
Picture = "xsqk.frx":AEAF
ToolTipText = "关闭"
Top = 120
Width = 510
End
Begin VB.Label Label15
Alignment = 2 'Center
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "销售情况"
BeginProperty Font
Name = "宋体"
Size = 18
Charset = 134
Weight = 400
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 3420
TabIndex = 14
Top = 480
Width = 1455
End
Begin VB.Shape Shape1
Height = 1455
Left = 960
Top = 1440
Width = 7095
End
Begin VB.Line Line1
X1 = 960
X2 = 8040
Y1 = 1920
Y2 = 1920
End
Begin VB.Line Line2
X1 = 2400
X2 = 2400
Y1 = 1440
Y2 = 2880
End
Begin VB.Line Line3
X1 = 6360
X2 = 6360
Y1 = 1440
Y2 = 2880
End
Begin VB.Line Line4
X1 = 4560
X2 = 4560
Y1 = 1440
Y2 = 2880
End
Begin VB.Line Line5
X1 = 960
X2 = 8040
Y1 = 2400
Y2 = 2400
End
Begin VB.Label Label19
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "本日发运"
Height = 255
Left = 2640
TabIndex = 13
Top = 1560
Width = 1695
End
Begin VB.Label Label20
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "本月累计"
Height = 255
Index = 0
Left = 4800
TabIndex = 12
Top = 1560
Width = 1335
End
Begin VB.Label Label21
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "本年累计"
Height = 255
Index = 0
Left = 6600
TabIndex = 11
Top = 1560
Width = 1575
End
Begin VB.Label Label22
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "汽运"
Height = 255
Left = 1080
TabIndex = 10
Top = 2040
Width = 855
End
Begin VB.Label Label23
Caption = "Label23"
Height = 255
Left = 2640
TabIndex = 9
Top = 2040
Width = 1455
End
Begin VB.Label Label24
Caption = "Label24"
Height = 255
Left = 4680
TabIndex = 8
Top = 2040
Width = 1455
End
Begin VB.Label Label25
Caption = "Label25"
Height = 255
Left = 6480
TabIndex = 7
Top = 2040
Width = 1215
End
Begin VB.Label Label26
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "船运"
Height = 255
Left = 960
TabIndex = 6
Top = 2520
Width = 1095
End
Begin VB.Label Label27
Caption = "Label27"
Height = 255
Left = 2640
TabIndex = 5
Top = 2520
Width = 1455
End
Begin VB.Label Label28
Caption = "Label28"
Height = 255
Left = 4680
TabIndex = 4
Top = 2520
Width = 1455
End
Begin VB.Label Label29
Caption = "Label29"
Height = 255
Left = 6480
TabIndex = 3
Top = 2520
Width = 1215
End
Begin VB.Label Label30
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "分类统计"
BeginProperty Font
Name = "宋体"
Size = 18
Charset = 134
Weight = 400
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 2640
TabIndex = 2
Top = 3000
Width = 2775
End
End
End
Attribute VB_Name = "xsqk"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'CODE Manger By BcodeXRose
Dim sj2 As String
'##################################################################
'## 过程名称：DTPicker1_Change
'## 参数： 无
'##################################################################
Private Sub DTPicker1_Change()
sj2 = Format(DTPicker1.Value, "yyyy-mm-dd")
Call refresh1
End Sub
'##################################################################
'## 过程名称：Form_Load
'## 参数： 无
'##################################################################
Private Sub Form_Load()
sj2 = Now
Call refresh1
End Sub
Private Sub Form_Unload(Cancel As Integer)
'MDIForm1.Toolbar1.Visible = True
End Sub
'##################################################################
'## 过程名称：Image2_Click
'## 参数： 无
'##################################################################
Private Sub Image2_Click()
Unload Me
End Sub
'##################################################################
'## 过程名称：refresh1
'## 参数： 无
'##################################################################
Private Sub refresh1()
Label15.Caption = Format(sj2, "yyyy年m月d日") & "销售情况"
Dim hwm(9) As String
Dim jelj, bylj, bnlj As Long
Adodc1.RecordSource = "SELECT sum(jz) from jlk where hwm like '%煤%' and sj like'%" & sj2 & "%'"
Adodc1.refresh
If IsNull(Adodc1.Recordset.Fields(0)) Or Adodc1.Recordset.EOF Then
Label23.Caption = "0"
Else
Label23.Caption = Adodc1.Recordset.Fields(0)
End If
Adodc1.RecordSource = "SELECT sum(jz) from jlk where hwm like '%煤%' and sj like '%" & Format(sj2, "yyyy-mm") & "%'"
Adodc1.refresh
If IsNull(Adodc1.Recordset.Fields(0)) Or Adodc1.Recordset.EOF Then
Label24.Caption = "0"
Else
Label24.Caption = Adodc1.Recordset.Fields(0)
End If
Adodc1.RecordSource = "SELECT sum(jz) from jlk where hwm like '%煤%' and sj like '%" & Format(sj2, "yyyy") & "%'"
Adodc1.refresh
If IsNull(Adodc1.Recordset.Fields(0)) Or Adodc1.Recordset.EOF Then
Label25.Caption = "0"
Else
Label25.Caption = Adodc1.Recordset.Fields(0)
End If
Adodc1.RecordSource = "SELECT sum(实装吨位) from total where 煤种 like '%煤%' and 装船日期 = '%" & sj2 & "%'"
Adodc1.refresh
If IsNull(Adodc1.Recordset.Fields(0)) Or Adodc1.Recordset.EOF Then
Label27.Caption = "0"
Else
Label27.Caption = Adodc1.Recordset.Fields(0)
End If
Adodc1.RecordSource = "SELECT sum(实装吨位) from total where 煤种 like '%煤%' and 装船日期 like '%" & Format(sj2, "yyyy-mm") & "%'"
Adodc1.refresh
If IsNull(Adodc1.Recordset.Fields(0)) Or Adodc1.Recordset.EOF Then
Label28.Caption = "0"
Else
Label28.Caption = Adodc1.Recordset.Fields(0)
End If
Adodc1.RecordSource = "SELECT sum(实装吨位) from total where 煤种 like '%煤%' and 装船日期 like '%" & Format(sj2, "yyyy") & "%'"
Adodc1.refresh
If IsNull(Adodc1.Recordset.Fields(0)) Or Adodc1.Recordset.EOF Then
Label29.Caption = "0"
Else
Label29.Caption = Adodc1.Recordset.Fields(0)
End If
Adodc1.RecordSource = "SELECT fhr as 发货人,hwm as 煤种,sum(jz) as 数量 from jlk where hwm like '%煤%' and sj='" & sj2 & "'group by fhr,hwm "
Adodc1.refresh
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -