form11.frm

来自「本文介绍了药品进销存管理系统的开发过程。论文详尽论述了从需求分析、系统分析、概要」· FRM 代码 · 共 29 行

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