salearray.frm

音像制品管理系统共分为四个功能模块

      Height          =   4500
      Left            =   120
      TabIndex        =   0
      Top             =   550
      Width           =   9732
      _ExtentX        =   17171
      _ExtentY        =   7938
      _Version        =   393216
      AllowUpdate     =   0   'False
      AllowArrows     =   0   'False
      BackColor       =   16777215
      HeadLines       =   1
      RowHeight       =   19
      FormatLocked    =   -1  'True
      BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "楷体_GB2312"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "楷体_GB2312"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Caption         =   "最新专辑排名榜"
      ColumnCount     =   5
      BeginProperty Column00 
         DataField       =   "盘号"
         Caption         =   "盘号"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column01 
         DataField       =   "专辑名"
         Caption         =   "专辑名"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column02 
         DataField       =   "价格"
         Caption         =   "价格"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   1
            Format          =   """￥""#,##0.00"
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column03 
         DataField       =   "数量"
         Caption         =   "数量"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   1
            Format          =   "0"
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column04 
         DataField       =   "发行时间"
         Caption         =   "发行时间"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   1
            Format          =   "dddddd"
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      SplitCount      =   1
      BeginProperty Split0 
         ScrollBars      =   3
         BeginProperty Column00 
            ColumnWidth     =   1005.165
         EndProperty
         BeginProperty Column01 
            ColumnWidth     =   2805.166
         EndProperty
         BeginProperty Column02 
            ColumnWidth     =   1604.976
         EndProperty
         BeginProperty Column03 
            ColumnWidth     =   1590.236
         EndProperty
         BeginProperty Column04 
            ColumnWidth     =   2085.166
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   0
      Top             =   2280
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   16
      ImageHeight     =   16
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   4
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "salearray.frx":09BB
            Key             =   ""
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "salearray.frx":0E13
            Key             =   ""
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "salearray.frx":126B
            Key             =   ""
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "salearray.frx":16C3
            Key             =   ""
         EndProperty
      EndProperty
   End
End
Attribute VB_Name = "salearray"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim param(1)

Private Sub Command1_Click()
If DTPicker2.Value < DTPicker1.Value Then
MsgBox "比较日期出错", 64, "比较日期出错"
Else
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select 盘号,专辑名,价格,数量,发行时间 from 总表 where 发行时间> # " & DTPicker1.Value & " # order by 发行时间 desc  "
Adodc1.Refresh
End If
End Sub

Private Sub Command1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "最新专辑排名"
End Sub

Private Sub DataGrid1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "最新专辑速递"
End Sub

Private Sub DTPicker1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = "选择发行的日期"
End Sub

Private Sub DTPicker2_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)
MDIForm1.StatusBar1.Panels(1) = "系统当前日期"
End Sub

Private Sub Form_GotFocus()
MDIForm1.Combo1.Text = "[近期新歌速递]"
DTPicker2.Value = Date
End Sub

Private Sub Form_Load()
MDIForm1.Combo1.Text = "[近期新歌速递]"
DTPicker2.Value = Date
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select 盘号,专辑名,价格,数量,发行时间 from 总表 order by 发行时间 desc"
Adodc1.Refresh
End Sub

Private Sub Form_LostFocus()
Unload Me
End Sub

Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
MDIForm1.StatusBar1.Panels(1) = ""
End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Index
       Case 1:
       salearray.Hide
       formpayout.Show
       formpayout.Combo1.Text = "歌碟销售"
       Set salearray = Nothing
       Case 2:
       Adodc1.CommandType = adCmdText
       Adodc1.RecordSource = "select 盘号,专辑名,价格,数量,发行时间 from 总表 order by 发行时间 desc"
       Adodc1.Refresh
       End Select
End Sub