form11.frm

本文介绍了药品进销存管理系统的开发过程。论文详尽论述了从需求分析、系统分析、概要设计、详细设计、以及测试与调试的整个开发过程

VERSION 5.00
Begin VB.Form Form11 
   Caption         =   "售价销售分析"
   ClientHeight    =   6270
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   6810
   LinkTopic       =   "Form11"
   ScaleHeight     =   6270
   ScaleWidth      =   6810
   StartUpPosition =   3  '窗口缺省
End
Attribute VB_Name = "Form11"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
s1 = DataCombo1.Text

Adodc1.RecordSource = "select * from ck_hj where 库存号='" + s1 + "'"
Adodc1.Refresh

Adodc3.RecordSource = "SELECT  Avg(单价) AS 平均单价, Min(单价) AS 最低单价, Max(单价) AS 最高单价 from ck_hj where 库存号='" + s1 + "'"
Adodc3.Refresh

End Sub