frmmain.frm

vbsql做的销售管理课程设计样本不完全仅为范例

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.MDIForm frmMain 
   BackColor       =   &H8000000C&
   Caption         =   "产品信息管理系统"
   ClientHeight    =   9240
   ClientLeft      =   1200
   ClientTop       =   1095
   ClientWidth     =   13335
   Begin MSComctlLib.StatusBar sbStatusBar 
      Align           =   2  'Align Bottom
      Height          =   270
      Left            =   0
      TabIndex        =   0
      Top             =   8970
      Width           =   13335
      _ExtentX        =   23521
      _ExtentY        =   476
      _Version        =   393216
      BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628} 
         NumPanels       =   3
         BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            AutoSize        =   1
            Object.Width           =   17886
            Text            =   "Status"
            TextSave        =   "Status"
         EndProperty
         BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Style           =   6
            AutoSize        =   2
            TextSave        =   "2006-12-30"
         EndProperty
         BeginProperty Panel3 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Style           =   5
            AutoSize        =   2
            TextSave        =   "16:01"
         EndProperty
      EndProperty
   End
   Begin VB.Menu frmlogin 
      Caption         =   "登录"
   End
   Begin VB.Menu menu_1 
      Caption         =   "产品信息管理"
      Begin VB.Menu menu_11 
         Caption         =   "添加"
      End
      Begin VB.Menu menu_12 
         Caption         =   "修改"
      End
      Begin VB.Menu menu_13 
         Caption         =   "删除"
      End
      Begin VB.Menu menu_14 
         Caption         =   "查询"
      End
   End
   Begin VB.Menu menu_2 
      Caption         =   "销售商信息管理"
      Begin VB.Menu menu_21 
         Caption         =   "添加"
      End
      Begin VB.Menu menu_22 
         Caption         =   "修改"
      End
      Begin VB.Menu menu_23 
         Caption         =   "删除"
      End
      Begin VB.Menu menu_24 
         Caption         =   "查询"
      End
   End
   Begin VB.Menu menu_3 
      Caption         =   "销售信息管理"
      Begin VB.Menu menu_31 
         Caption         =   "添加"
      End
      Begin VB.Menu menu_32 
         Caption         =   "删除"
      End
      Begin VB.Menu menu_33 
         Caption         =   "查询"
         Begin VB.Menu query1 
            Caption         =   "按产品名称查询"
         End
         Begin VB.Menu query2 
            Caption         =   "按销售商查询"
         End
         Begin VB.Menu query3 
            Caption         =   "按销售时间查询"
         End
      End
   End
   Begin VB.Menu menuexit 
      Caption         =   "退出"
   End
End
Attribute VB_Name = "frmMain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub frmlogin_Click()
Dim fLogin As New frmlogin
    fLogin.Show vbModal
     
      If flag = 1 Then
        menu_1.Enabled = True
        menu_2.Enabled = True
        menu_3.Enabled = True
        Else  '登录失败
          End
      End If
End Sub

Private Sub MDIForm_Load()
     If flag = 0 Then
     menu_1.Enabled = False
   menu_2.Enabled = False
  menu_3.Enabled = False
   End If
End Sub

Private Sub menuAddreturn_Click()
   brflagadd = 2
   frmBorrow1.Show
End Sub

Private Sub menuDeletebook_Click()
      bflagadd = 3
    frmBook1.Show vbModal
    
End Sub




Private Sub menuDeletereader_Click()
        flagadd = 3
      frmReader1.Show vbModal
   End Sub

Private Sub menuDeletereadertype_Click()
    Dim txtSQL As String
    Dim intCount As Integer
    Dim mrc As ADODB.Recordset
    Dim MsgText As String
    
    
    If flagRTedit Then
        If frmReadertype.msgList.Rows > 1 Then
            If MsgBox("真的要删除这条文件记录么？", vbOKCancel + vbExclamation, "警告") = vbOK Then
                intCount = frmReadertype.msgList.Row
                txtSQL = "delete from readertype where typeno='" & Trim(frmReadertype.msgList.TextMatrix(intCount, 1)) & "'"
                Set mrc = ExecuteSQL(txtSQL, MsgText)
                
                Unload frmReadertype
                frmReadertype.txtSQL = "select * from readertype"
                frmReadertype.Show
            End If
        End If
    End If
End Sub

Private Sub menuInquirebook_Click()
    bflagadd = 4
    frmBook1.Show vbModal
   
End Sub

Private Sub menuInquireborrow_Click()
    frmBorrow2.Show
End Sub

Private Sub menuInquirereader_Click()
    flagadd = 4
      frmReader1.Show vbModal
End Sub

Private Sub menuInquirereturn1_Click()
 brflagadd = 4
form4.txtSQL = "select cpbh,cpmc,jg,kcl"
        form4.Show vbModal
End Sub

Private Sub menuModifybook_Click()
    
             bflagadd = 2
    frmBook1.Show vbModal
    
End Sub
Private Sub menu_11_Click()
    flagadd = 1 '添加产品信息
    form1.Show vbModal
End Sub

Private Sub menu_12_Click()
flagadd = 2 '编辑产品信息
form1.Show vbModal
End Sub

Private Sub menu_13_Click()
flagadd = 3 '删除产品信息
form1.Show vbModal
End Sub

Private Sub menu_14_Click()
brflagadd = 1
form3.txtSQL = "select cpbh,cpmc,jg,kcl from cp"
       form3.Show vbModal
End Sub

Private Sub menu_21_Click()
flagadd = 1 '添加销售商信息
    form2.Show vbModal
End Sub

Private Sub menu_22_Click()
flagadd = 2 '修改销售商信息
form2.Show vbModal

End Sub

Private Sub menu_23_Click()
flagadd = 3 '删除销售商信息
form2.Show vbModal
End Sub

Private Sub menu_24_Click()
brflagadd = 2
form3.txtSQL = "select * from xss"
       form3.Show vbModal

End Sub

Private Sub menu_31_Click()
 flagadd = 1 '添加产品销售信息
  form4.Show vbModal
End Sub

Private Sub menu_32_Click()
 '删除产品销售信息
  Form8.txtSQL = "select cp.cpbh,cpmc,jg,kcl, xss.xsbh,xsmc,dq,fzr,dh,bz,xssj,sl,je from cp,xss,xscp where cp.cpbh=xscp.cpbh and xss.xsbh=xscp.xsbh"
       Form8.Show vbModal
End Sub


Private Sub menuexit_Click()
Unload Me
End Sub

Private Sub query1_Click()
 '按产品名称查询
 Form6.Show vbModal
End Sub

Private Sub query2_Click()
'按销售商查询
 Form5.Show vbModal
End Sub

Private Sub query3_Click()
'按销售时间查询
 Form7.Show vbModal

End Sub