kufangguanli.frm

大学好的可设内容

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "msflxgrd.ocx"
Begin VB.Form kufangguanli 
   BackColor       =   &H00FFC0C0&
   Caption         =   "库房管理"
   ClientHeight    =   3090
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   4680
   Icon            =   "kufangguanli.frx":0000
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   3090
   ScaleWidth      =   4680
   Begin VB.CommandButton Command1 
      Caption         =   "退出"
      Height          =   375
      Left            =   4560
      TabIndex        =   4
      Top             =   2520
      Width           =   975
   End
   Begin VB.TextBox Text1 
      BackColor       =   &H80000018&
      Height          =   375
      Left            =   4560
      TabIndex        =   3
      Top             =   2520
      Width           =   975
   End
   Begin VB.ComboBox Combol 
      BackColor       =   &H80000018&
      Height          =   300
      Left            =   2160
      TabIndex        =   2
      Top             =   2520
      Width           =   1095
   End
   Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1 
      Height          =   1455
      Left            =   1800
      TabIndex        =   0
      Top             =   960
      Width           =   4095
      _ExtentX        =   7223
      _ExtentY        =   2566
      _Version        =   393216
   End
   Begin VB.Line Line5 
      BorderColor     =   &H000000FF&
      X1              =   1680
      X2              =   6000
      Y1              =   3000
      Y2              =   3000
   End
   Begin VB.Line Line4 
      BorderColor     =   &H000000FF&
      X1              =   6000
      X2              =   6000
      Y1              =   360
      Y2              =   3000
   End
   Begin VB.Line Line3 
      BorderColor     =   &H000000FF&
      X1              =   1680
      X2              =   1680
      Y1              =   360
      Y2              =   3000
   End
   Begin VB.Line Line2 
      X1              =   240
      X2              =   120
      Y1              =   120
      Y2              =   120
   End
   Begin VB.Line Line1 
      BorderColor     =   &H000000FF&
      X1              =   1680
      X2              =   6000
      Y1              =   360
      Y2              =   360
   End
   Begin VB.Label Label1 
      Caption         =   "进出清单"
      Height          =   255
      Left            =   2160
      TabIndex        =   1
      Top             =   720
      Width           =   1095
   End
End
Attribute VB_Name = "kufangguanli"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim rs_data2 As New ADODB.Recordset
Dim select_row As String
Dim showgrid2 As Boolean
Dim rs_custom As New ADODB.Recordset
Dim jinchu As String                 '进出库标志
Dim modify As Boolean                '修改状态标志

Private Sub Combo1_Change()

End Sub

Private Sub Command1_Click()
kufangguanli.Hide
End Sub

Private Sub Form_Load()
On Error GoTo loaderror
Dim sql As String
sql = "select * from 图书资料"
rs_custom.CursorLocation = adUseClient
rs_custom.Open sql, conn, adOpenKeyset, adLockPessimistic
While Not rs_custom.EOF
      Combol.AddItem rs_custom.Fields(0)
      rs_custom.MoveNext
Wend
findok = True
modify = False                                 '非修改状态
'cmdcancel.Enabled = False
displaygrid1                                    '调用显示Datagrid1子程序
loaderror:
If Err.Number <> 0 Then
   MsgBox Err.Description
End If
End Sub
'显示msflexgrid1子程序
Public Sub displaygrid1()
Dim i As Integer
On Error GoTo displayerror
setgrid
setgridhead
MSFlexGrid1.Row = 0
If Not rs_data1.EOF Then
   rs_data1.MoveFirst
   Do While Not rs_data1.EOF
            MSFlexGrid1.Row = MSFlexGrid1.Row + 1
            MSFlexGrid1.Col = 0
            If Not IsNull(rs_data1.Fields(0)) Then MSFlexGrid1.Text = rs_data1.Fields(0) Else MSFlexGrid1.Text = ""
            MSFlexGrid1.Col = 1
            If Not IsNull(rs_data1.Fields(1)) Then MSFlexGrid1.Text = rs_data1.Fields(1) Else MSFlexGrid1.Text = ""
            MSFlexGrid1.Col = 2
            If Not IsNull(rs_data1.Fields(2)) Then MSFlexGrid1.Text = rs_data1.Fields(2) Else MSFlexGrid1.Text = ""
            MSFlexGrid1.Col = 3
            If Not IsNull(rs_data1.Fields(3)) Then MSFlexGrid1.Text = rs_data1.Fields(3) Else MSFlexGrid1.Text = ""
            MSFlexGrid1.Col = 4
            If Not IsNull(rs_data1.Fields(4)) Then MSFlexGrid1.Text = rs_data1.Fields(4) Else MSFlexGrid1.Text = ""
            MSFlexGrid1.Col = 5
            If Not IsNull(rs_data1.Fields(5)) Then MSFlexGrid1.Text = rs_data1.Fields(5) Else MSFlexGrid1.Text = ""
            'MSFlexGrid1.Col = 6
            'If rs_data1.Fields(6) = True Then MSFlexGrid1.Text = "入库" Else MSFlexGrid1.Text = "出库"
            rs_data1.MoveNext
   Loop
End If
displayerror:
If Err.Number <> 0 Then
   MsgBox Err.Description
End If
End Sub
Public Sub setgrid()
Dim i As Integer
On Error GoTo seterror
With MSFlexGrid1
    .ScrollBars = flexScrollBarBoth
    .FixedCols = 0
    .Rows = rs_data1.RecordCount + 1
    .Cols = 7
    .SelectionMode = flexSelectionByRow
For i = 0 To .Rows - 1
    .RowHeight(i) = 315
Next
For i = 0 To .Cols - 1
    .ColWidth(i) = 1300
Next i
End With
Exit Sub
seterror:
     MsgBox Err.Description
End Sub
Public Sub setgridhead()
On Error GoTo setheaderror
MSFlexGrid1.Row = 0
MSFlexGrid1.Col = 0
MSFlexGrid1.Text = "编号"
MSFlexGrid1.Col = 1
MSFlexGrid1.Text = "书名"
MSFlexGrid1.Col = 2
MSFlexGrid1.Text = "类型"
MSFlexGrid1.Col = 3
MSFlexGrid1.Text = "购买日期"
MSFlexGrid1.Col = 4
MSFlexGrid1.Text = "  定价"
MSFlexGrid1.Col = 5
MSFlexGrid1.Text = "备注"
Exit Sub
setheaderror:
   MsgBox Err.Description
End Sub

Private Sub Form_Unload(Cancel As Integer)
findok = False
rs_data1.Close
rs_custom.Close
If showgrid2 = True Then
   rs_data2.Close
End If
End Sub