frm_yjmenu.frm

前些年帮人写的毕业设计

VERSION 5.00
Begin VB.Form Frm_yjmenu 
   Caption         =   "Form1"
   ClientHeight    =   3195
   ClientLeft      =   3615
   ClientTop       =   2625
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   StartUpPosition =   2  '屏幕中心
   Begin VB.Menu supply 
      Caption         =   "supply"
      Begin VB.Menu sty 
         Caption         =   "停用"
      End
      Begin VB.Menu sqy 
         Caption         =   "启用"
      End
   End
   Begin VB.Menu standard 
      Caption         =   "standard"
      Begin VB.Menu ty 
         Caption         =   "停用"
      End
      Begin VB.Menu qy 
         Caption         =   "启用"
      End
   End
End
Attribute VB_Name = "Frm_yjmenu"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub sqy_Click()
    On Error GoTo myerr
    Dim cn As ADODB.Connection
    msg = MsgBox("是否启用该供应商？", vbYesNo + vbQuestion, "提示")
    If msg = vbNo Then Exit Sub
    Set cn = GetCn
    cn.Execute "update supply set stop =0 where supply_id=" & Frm_Supply.ListView1.SelectedItem.SubItems(6)
    MsgBox "启用成功！", vbExclamation, "提示"
    Exit Sub
    Set cn = GetCn
myerr:
    MsgBox Error, vbExclamation, "提示"
End Sub

Private Sub sty_Click()
    On Error GoTo myerr
    Dim cn As ADODB.Connection
    msg = MsgBox("是否停用该供应商？", vbYesNo + vbQuestion, "提示")
    If msg = vbNo Then Exit Sub
    Set cn = GetCn
    cn.Execute "update supply set stop =1 where supply_id=" & Frm_Supply.ListView1.SelectedItem.SubItems(6)
    MsgBox "停用成功！", vbExclamation, "提示"
    Exit Sub
    Set cn = GetCn
myerr:
    MsgBox Error, vbExclamation, "提示"
End Sub

Private Sub ty_Click()
    On Error GoTo myerr
    Dim cn As ADODB.Connection
    msg = MsgBox("是否停用该药品？", vbYesNo + vbQuestion, "提示")
    If msg = vbNo Then Exit Sub
    Set cn = GetCn
    cn.Execute "update standard set stop =1 where part_id=" & Frm_Standard.ListView1.SelectedItem.SubItems(8)
    MsgBox "停用成功！", vbExclamation, "提示"
    Exit Sub
    Set cn = GetCn
myerr:
    MsgBox Error, vbExclamation, "提示"
    
End Sub
Private Sub qy_Click()
    On Error GoTo myerr
    Dim cn As ADODB.Connection
    msg = MsgBox("是否启用该药品？", vbYesNo + vbQuestion, "提示")
    If msg = vbNo Then Exit Sub
    Set cn = GetCn
    cn.Execute "update standard set stop =0 where part_id=" & Frm_Standard.ListView1.SelectedItem.SubItems(8)
    MsgBox "启用成功！", vbExclamation, "提示"
    Exit Sub
    Set cn = GetCn
myerr:
    MsgBox Error, vbExclamation, "提示"
End Sub