库存报警设置.frm

随着市场经济的发展

VERSION 5.00
Begin VB.Form 库存报警设置 
   Caption         =   "库存报警设置"
   ClientHeight    =   5430
   ClientLeft      =   4620
   ClientTop       =   2280
   ClientWidth     =   7110
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   ScaleHeight     =   5430
   ScaleWidth      =   7110
   Begin VB.CommandButton Command2 
      Caption         =   "退出"
      BeginProperty Font 
         Name            =   "楷体_GB2312"
         Size            =   12
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   4440
      TabIndex        =   7
      Top             =   4320
      Width           =   1215
   End
   Begin VB.Frame Frame1 
      Caption         =   "库存下限设置"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   3375
      Left            =   240
      TabIndex        =   1
      Top             =   600
      Width           =   6615
      Begin VB.ListBox List1 
         Height          =   1860
         Left            =   360
         TabIndex        =   8
         Top             =   840
         Width           =   2055
      End
      Begin VB.TextBox Text1 
         Height          =   270
         Left            =   4440
         TabIndex        =   6
         Top             =   1800
         Width           =   1215
      End
      Begin VB.ComboBox Combo1 
         Height          =   300
         Left            =   4440
         TabIndex        =   5
         Top             =   720
         Width           =   1695
      End
      Begin VB.Label Label3 
         Caption         =   "库存下限"
         BeginProperty Font 
            Name            =   "楷体_GB2312"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   255
         Left            =   3000
         TabIndex        =   4
         Top             =   1800
         Width           =   1095
      End
      Begin VB.Label Label2 
         BackStyle       =   0  'Transparent
         Caption         =   "商品名称"
         BeginProperty Font 
            Name            =   "楷体_GB2312"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   255
         Left            =   360
         TabIndex        =   3
         Top             =   480
         Width           =   1095
      End
      Begin VB.Label Label1 
         Caption         =   "商品编号"
         BeginProperty Font 
            Name            =   "楷体_GB2312"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   255
         Left            =   3000
         TabIndex        =   2
         Top             =   720
         Width           =   975
      End
   End
   Begin VB.CommandButton Command1 
      Caption         =   "确定设置"
      BeginProperty Font 
         Name            =   "楷体_GB2312"
         Size            =   12
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   1320
      TabIndex        =   0
      Top             =   4320
      Width           =   1215
   End
   Begin VB.Image Image1 
      Height          =   6300
      Left            =   0
      Picture         =   "库存报警设置.frx":0000
      Top             =   0
      Width           =   9150
   End
End
Attribute VB_Name = "库存报警设置"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False


Private Sub Combo1_click()
Dim rs As ADODB.Recordset
Dim sql As String
  sql = "select * from spxxb where spbh=" & Trim(Combo1.Text)
  Set rs = exesql(sql)
 If rs.RecordCount > 0 Then '将选中商品编号的商品名称在列表框中选定
             List1.Text = Trim(rs.Fields("spmc"))
 End If
         Set rs = Nothing
End Sub

Private Sub list1_click()
Dim rs As ADODB.Recordset
Dim sql As String
  sql = "select * from spxxb where spmc='" & Trim(List1.Text) & "'"
  Set rs = exesql(sql)
 If rs.RecordCount > 0 Then '将选中的商品的商品编号加到复选框中
             Combo1.Text = Trim(rs.Fields("spbh"))
 End If
         Set rs = Nothing
End Sub

Private Sub Command1_Click()
Dim sql As String
Dim i As String
Dim rs As ADODB.Recordset
  i = MsgBox("确定保存此设置吗？", 1, "")
  If i = 1 Then
  If Trim(Text1.Text) <> "" Then '判断库存下限文本框是否为空
     If Trim(Combo1.Text) <> "" Then '判断商品编号复选框是否为空
        If Trim(List1.Text) <> "" Then '判断商品名称列表框是否为空
           sql = "select * from spxxb where spbh=" & Trim(Combo1.Text)
           Set rs = exesql(sql)
           If rs.RecordCount > 0 Then '判断商品编号是否存在
              If Trim(rs.Fields("spmc")) = Trim(List1.Text) Then '判断商品名称和编号是否对应
                 rs.Fields("kcxx") = Trim(Text1.Text) '保存设置
                 rs.Update
                 MsgBox "设置已保存！"
                 Set rs = Nothing
              Else: MsgBox "商品名称和编号不对应！"
              List1.SetFocus
              End If
           Else: MsgBox "商品编号不存在！"
           Combo1.SetFocus
           End If
        Else: MsgBox "商品名称不能为空！"
        List1.SetFocus
        End If
     Else: MsgBox "商品编号不能为空！"
     Combo1.SetFocus
     End If
  Else: MsgBox "库存下限设置为空！"
  Text1.SetFocus
  End If
End If
End Sub

Private Sub Command2_Click()
Unload 库存报警设置
End Sub

Private Sub Form_Load()
Call listinitial("spmc", List1)
Call listinitial("spbh", Combo1)
End Sub