main_kcgl_kcpd.frm

基于VB的医药进销存管理系统源程序

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form main_kcgl_kcpd 
   BackColor       =   &H00C0C0C0&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "库存管理——【库存盘点】"
   ClientHeight    =   7575
   ClientLeft      =   525
   ClientTop       =   1770
   ClientWidth     =   9870
   Icon            =   "main_kcgl_kcpd.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   7575
   ScaleWidth      =   9870
   StartUpPosition =   1  'CenterOwner
   Begin VB.CommandButton Command2 
      BackColor       =   &H0080C0FF&
      Caption         =   "退出"
      Height          =   495
      Left            =   7320
      Style           =   1  'Graphical
      TabIndex        =   0
      Top             =   6960
      Width           =   1305
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access"
      DatabaseName    =   ""
      DefaultCursorType=   0  'DefaultCursor
      DefaultType     =   2  'UseODBC
      Exclusive       =   0   'False
      Height          =   345
      Left            =   8400
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   "kc"
      Top             =   6120
      Visible         =   0   'False
      Width           =   1140
   End
   Begin MSFlexGridLib.MSFlexGrid MS1 
      Bindings        =   "main_kcgl_kcpd.frx":000C
      Height          =   6630
      Left            =   15
      TabIndex        =   2
      Top             =   15
      Width           =   9675
      _ExtentX        =   17066
      _ExtentY        =   11695
      _Version        =   393216
   End
   Begin VB.CommandButton Command1 
      Caption         =   "盘点"
      Height          =   495
      Left            =   5520
      TabIndex        =   1
      Top             =   6960
      Width           =   1305
   End
   Begin VB.Label Label1 
      Caption         =   "备注：库存盘点，筛选库存数量大于零的库存商品信息"
      Height          =   240
      Left            =   45
      TabIndex        =   3
      Top             =   7080
      Width           =   4485
   End
End
Attribute VB_Name = "main_kcgl_kcpd"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False


Private Sub Form_Activate()
'设置ms1表格的列宽
 MS1.ColWidth(0) = 12 * 25 * 0: MS1.ColWidth(1) = 12 * 25 * 8
 MS1.ColWidth(2) = 12 * 25 * 0: MS1.ColWidth(5) = 12 * 25 * 5
 MS1.ColWidth(9) = 12 * 25 * 3: MS1.ColWidth(10) = 12 * 25 * 0
End Sub
Private Sub Form_Load()
 Data1.DatabaseName = App.Path & "\yyjxc.mdb"     '自动识别数据库路径
End Sub
Private Sub Form_Unload(Cancel As Integer)
 frm_main.Enabled = True
End Sub
Private Sub Command1_Click()
'盘点库存大于零的库存信息
  Data1.RecordSource = "select * from kc where kc.库存>0 "
  Data1.Refresh
  MS1.Col = 9: MS1.Sort = flexSortNumericAscending     '第9行按升序排序
End Sub
Private Sub Command2_Click()
 frm_main.Enabled = True
 Unload Me
End Sub