frmmodiusertype.frm

一个关于进销存的源代码

VERSION 5.00
Begin VB.Form frmmodiusertype 
   BackColor       =   &H00FF8080&
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "修改用户类型"
   ClientHeight    =   1650
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   3465
   Icon            =   "frmmodiusertype.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   1650
   ScaleWidth      =   3465
   ShowInTaskbar   =   0   'False
   Begin VB.CommandButton Command2 
      Caption         =   "Command2"
      Height          =   375
      Left            =   2280
      Picture         =   "frmmodiusertype.frx":030A
      TabIndex        =   4
      Top             =   1080
      Width           =   975
   End
   Begin VB.CommandButton Command1 
      Caption         =   "Command1"
      Height          =   375
      Left            =   2280
      Picture         =   "frmmodiusertype.frx":CCF8
      TabIndex        =   3
      Top             =   600
      Width           =   975
   End
   Begin VB.Frame Frame1 
      BackColor       =   &H00FF8080&
      Caption         =   "Frame1"
      Height          =   1215
      Left            =   120
      TabIndex        =   0
      Top             =   240
      Width           =   1935
      Begin VB.OptionButton Option2 
         BackColor       =   &H00FF8080&
         Caption         =   "Option2"
         Height          =   375
         Left            =   240
         TabIndex        =   2
         Top             =   720
         Width           =   1335
      End
      Begin VB.OptionButton Option1 
         BackColor       =   &H00FF8080&
         Caption         =   "Option1"
         Height          =   255
         Left            =   240
         TabIndex        =   1
         Top             =   360
         Width           =   1215
      End
   End
End
Attribute VB_Name = "frmmodiusertype"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
    Dim rdst As New ADODB.Recordset
    If Option1.Value = True Then
         rdst.Open "update userlist set 用户类型 = 0 where 用户名='" & frmuser.List1.Text & "'", g_conn
    Else
         rdst.Open "update userlist set 用户类型 = 1 where 用户名='" & frmuser.List1.Text & "'", g_conn
        
    End If
        tishi = MsgBox("用户类型修改成功！", vbOKOnly, "用户类型修改")
        Unload frmmodiusertype
        frmuser.Show
End Sub

Private Sub Command2_Click()
Unload Me

End Sub

Private Sub Form_Load()
        'askn.ApplySkin Me.hWnd
        Me.Left = 6000
        Me.Top = 3900
        Dim rdst As New ADODB.Recordset
            rdst.Open "select * from userlist where 用户名 ='" & frmuser.List1.Text & "'", g_conn
        If rdst!用户类型 = 0 Then
             Option1.Value = True
        Else
             Option2.Value = True
        End If
        
        Frame1.Caption = "--请选择用户类型--"
        Option1.Caption = "管理人员"
        Option2.Caption = "浏览人员"
        Command1.Caption = "确定"
        Command2.Caption = "取消"


End Sub