form5.frm

来自「MIS系统开发实例（VB+SQL SERVER2000）」· FRM 代码 · 共 128 行

VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form Form5 
   BackColor       =   &H00808080&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "销售报表"
   ClientHeight    =   2610
   ClientLeft      =   45
   ClientTop       =   450
   ClientWidth     =   5805
   LinkTopic       =   "Form5"
   MaxButton       =   0   'False
   ScaleHeight     =   2610
   ScaleWidth      =   5805
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      BackColor       =   &H0080C0FF&
      Caption         =   "：：生成报表：："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   15
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   1440
      Style           =   1  'Graphical
      TabIndex        =   5
      Top             =   1680
      Width           =   3015
   End
   Begin MSComCtl2.DTPicker DTPicker2 
      Height          =   255
      Left            =   3480
      TabIndex        =   4
      Top             =   960
      Width           =   1575
      _ExtentX        =   2778
      _ExtentY        =   450
      _Version        =   393216
      Format          =   65470465
      CurrentDate     =   39085
   End
   Begin MSComCtl2.DTPicker DTPicker1 
      Height          =   255
      Left            =   1080
      TabIndex        =   1
      Top             =   960
      Width           =   1695
      _ExtentX        =   2990
      _ExtentY        =   450
      _Version        =   393216
      Format          =   65470465
      CurrentDate     =   39085
   End
   Begin VB.Image Image1 
      Height          =   375
      Left            =   360
      Picture         =   "Form5.frx":0000
      Stretch         =   -1  'True
      Top             =   240
      Width           =   375
   End
   Begin VB.Label Label3 
      BackStyle       =   0  'Transparent
      Caption         =   "至"
      ForeColor       =   &H00E0E0E0&
      Height          =   255
      Left            =   3000
      TabIndex        =   3
      Top             =   960
      Width           =   255
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "从"
      ForeColor       =   &H00E0E0E0&
      Height          =   255
      Left            =   600
      TabIndex        =   2
      Top             =   960
      Width           =   375
   End
   Begin VB.Label Label1 
      BackStyle       =   0  'Transparent
      Caption         =   "销售报表"
      BeginProperty Font 
         Name            =   "幼圆"
         Size            =   15.75
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00E0E0E0&
      Height          =   375
      Left            =   840
      TabIndex        =   0
      Top             =   240
      Width           =   1455
   End
End
Attribute VB_Name = "Form5"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Call adoopen
adocon.Execute "if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[xiaoshoubb]') and OBJECTPROPERTY(id, N'IsView') = 1)" & _
               "drop view [dbo].[xiaoshoubb]"
adocon.Execute "create view xiaoshoubb as select yname,SUM(ZONGE) AS ZONGE from yaopinjbxx,changjiazidian,namezidian,xiaosdingjia,xiaoshou where yaopinjbxx.pk=xiaosdingjia.pk and yaopinjbxx.pk=xiaoshou.pk and yaopinjbxx.yno=namezidian.yno and yaopinjbxx.cno=changjiazidian.cno AND TYINF='0'   and shoushi between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "' GROUP BY  YNAME"
adocon.Close
Set adocon = Nothing
DataReport2.Sections(2).Controls.Item("Label3").Caption = DTPicker1.Value & "至" & DTPicker2.Value & "  销售统计表"
DataReport2.Show 1
DataEnvironment1.rsCommand2.Close
End Sub

Private Sub Form_Load()
  Move MDIForm1.Left + (MDIForm1.Width - Me.Width) / 2, MDIForm1.Top + 3000

End Sub