frmhwck.frm

企业的进销存源码

VERSION 5.00
Object = "{D76D7128-4A96-11D3-BD95-D296DC2DD072}#1.0#0"; "Vsflex7.ocx"
Begin VB.Form frmHwCk 
   Caption         =   "仓库资料"
   ClientHeight    =   5115
   ClientLeft      =   1920
   ClientTop       =   1635
   ClientWidth     =   8430
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   ScaleHeight     =   5115
   ScaleWidth      =   8430
   Begin VB.Frame Frame 
      Height          =   2205
      Left            =   2940
      TabIndex        =   0
      Top             =   60
      Width           =   5355
      Begin VB.CommandButton Command 
         Caption         =   "保存(&S)"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Index           =   3
         Left            =   2850
         TabIndex        =   6
         Top             =   1530
         Width           =   1125
      End
      Begin VB.CommandButton Command 
         Caption         =   "新增(&A)"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Index           =   0
         Left            =   210
         TabIndex        =   5
         Top             =   1530
         Width           =   1125
      End
      Begin VB.CommandButton Command 
         Caption         =   "删除(&D)"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Index           =   2
         Left            =   1530
         TabIndex        =   4
         Top             =   1530
         Width           =   1125
      End
      Begin VB.CheckBox Check 
         Caption         =   "停用"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   285
         Index           =   0
         Left            =   1320
         TabIndex        =   2
         Top             =   690
         Width           =   1965
      End
      Begin VB.TextBox Text 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   330
         Index           =   1
         Left            =   1320
         TabIndex        =   1
         Top             =   255
         Width           =   3255
      End
      Begin VB.Label Label 
         Caption         =   "仓库名称:"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   195
         Index           =   1
         Left            =   270
         TabIndex        =   3
         Top             =   315
         Width           =   945
      End
   End
   Begin VSFlex7Ctl.VSFlexGrid Flex 
      Height          =   4935
      Index           =   0
      Left            =   60
      TabIndex        =   7
      Top             =   60
      Width           =   2775
      _cx             =   4895
      _cy             =   8705
      _ConvInfo       =   1
      Appearance      =   1
      BorderStyle     =   1
      Enabled         =   -1  'True
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      MousePointer    =   0
      BackColor       =   -2147483643
      ForeColor       =   -2147483640
      BackColorFixed  =   -2147483633
      ForeColorFixed  =   -2147483630
      BackColorSel    =   -2147483635
      ForeColorSel    =   -2147483634
      BackColorBkg    =   -2147483636
      BackColorAlternate=   -2147483643
      GridColor       =   -2147483633
      GridColorFixed  =   -2147483632
      TreeColor       =   -2147483632
      FloodColor      =   192
      SheetBorder     =   -2147483642
      FocusRect       =   1
      HighLight       =   1
      AllowSelection  =   -1  'True
      AllowBigSelection=   -1  'True
      AllowUserResizing=   1
      SelectionMode   =   1
      GridLines       =   1
      GridLinesFixed  =   2
      GridLineWidth   =   1
      Rows            =   2
      Cols            =   2
      FixedRows       =   1
      FixedCols       =   1
      RowHeightMin    =   0
      RowHeightMax    =   0
      ColWidthMin     =   0
      ColWidthMax     =   0
      ExtendLastCol   =   0   'False
      FormatString    =   "|<仓库名称"
      ScrollTrack     =   0   'False
      ScrollBars      =   3
      ScrollTips      =   0   'False
      MergeCells      =   0
      MergeCompare    =   0
      AutoResize      =   -1  'True
      AutoSizeMode    =   0
      AutoSearch      =   0
      AutoSearchDelay =   2
      MultiTotals     =   -1  'True
      SubtotalPosition=   1
      OutlineBar      =   0
      OutlineCol      =   0
      Ellipsis        =   0
      ExplorerBar     =   0
      PicturesOver    =   0   'False
      FillStyle       =   0
      RightToLeft     =   0   'False
      PictureType     =   0
      TabBehavior     =   0
      OwnerDraw       =   0
      Editable        =   0
      ShowComboButton =   -1  'True
      WordWrap        =   0   'False
      TextStyle       =   0
      TextStyleFixed  =   0
      OleDragMode     =   0
      OleDropMode     =   0
      DataMode        =   0
      VirtualData     =   -1  'True
      DataMember      =   ""
      ComboSearch     =   3
      AutoSizeMouse   =   -1  'True
      FrozenRows      =   0
      FrozenCols      =   0
      AllowUserFreezing=   0
      BackColorFrozen =   0
      ForeColorFrozen =   0
      WallPaperAlignment=   9
   End
End
Attribute VB_Name = "frmHwCk"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'QQ:75347626
'MSN:[e-mail]
Option Explicit

Const FlexHwCk = 0
Const TxtHwCkMc = 1
Const ChkHwCkIsStop = 0

Const CmdAdd = 0
Const CmdDel = 2
Const CmdSave = 3

Dim OHwCk As HwCk
Dim OHwCks As HwCks

Private Sub Command_Click(Index As Integer)
On Error GoTo Errorhandle

   Select Case Index
   Case CmdAdd
         AddRecord
   Case CmdDel
         Delrecord
   Case CmdSave
         SaveRecord
   End Select

Exit Sub
Errorhandle:
   MsgBox Err.Description
End Sub

Private Sub Form_Load()
On Error GoTo Errorhandle

   LoadDataIntoGrid
   
Exit Sub
Errorhandle:
   MsgBox Err.Description
End Sub

Private Sub LoadDataIntoGrid()
   Dim ItemStr As String
   Dim mHwCk As HwCk
On Error GoTo Errorhandle

   Flex(FlexHwCk).Rows = 1
   
   Set OHwCks = New HwCks
   OHwCks.Fillbydb
      
   For Each mHwCk In OHwCks
      ItemStr = vbTab & mHwCk.HwCkMc
      Flex(FlexHwCk).AddItem ItemStr
      Flex(FlexHwCk).RowData(Flex(FlexHwCk).Rows - 1) = mHwCk.HwCkKey
   Next
   If Flex(FlexHwCk).Rows > 1 Then
      Flex(FlexHwCk).Row = 1
      Set OHwCk = OHwCks(CStr(Flex(FlexHwCk).RowData(1)))
      SetValueToControl
   Else
      Set OHwCk = Nothing
      Clearcontrol
   End If

Exit Sub
Errorhandle:
   Err.Raise vbObjectError + 1, , Err.Description
End Sub

Private Sub AddRecord()
On Error GoTo Errorhandle

   Set OHwCk = New HwCk
   Clearcontrol
   Text(TxtHwCkMc).SetFocus
   
Exit Sub
Errorhandle:
   Err.Raise vbObjectError + 1, , Err.Description
End Sub

Private Sub Clearcontrol()
On Error GoTo Errorhandle

   Text(TxtHwCkMc).Text = ""
   Check(ChkHwCkIsStop).Value = vbUnchecked
   
Exit Sub
Errorhandle:
   Err.Raise vbObjectError + 1, , Err.Description
End Sub

Private Sub SaveRecord()
On Error GoTo Errorhandle
    
   SetValueToObject

   If OHwCk.HwCkId = -1 Then
      OHwCks.Add OHwCk
      ChgGrid "ADD"
   Else
      OHwCk.Save
      ChgGrid "CHG"
   End If
   
Exit Sub
Errorhandle:
   Err.Raise vbObjectError + 1, , Err.Description
End Sub

Private Sub SetValueToObject()
On Error GoTo Errorhandle

   OHwCk.HwCkMc = Trim(Text(TxtHwCkMc).Text)
   OHwCk.HwCkIsStop = Check(ChkHwCkIsStop)
   
Exit Sub
Errorhandle:
   Err.Raise vbObjectError + 1, , Err.Description
End Sub

Private Sub ChgGrid(RecordName As String)
   Dim ItemStr As String
On Error GoTo Errorhandle

   If RecordName = "ADD" Then
      ItemStr = vbTab & OHwCk.HwCkMc
      Flex(FlexHwCk).AddItem ItemStr
      Flex(FlexHwCk).RowData(Flex(FlexHwCk).Rows - 1) = OHwCk.HwCkKey
      Flex(FlexHwCk).Row = Flex(FlexHwCk).Rows - 1
   Else
      Flex(FlexHwCk).TextMatrix(Flex(FlexHwCk).Row, 1) = Text(TxtHwCkMc).Text
   End If

Exit Sub
Errorhandle:
   Err.Raise vbObjectError + 1, , Err.Description
End Sub

Private Sub Delrecord()
On Error GoTo Errorhandle

   If Flex(FlexHwCk).Rows = 1 Then
      Exit Sub
   End If

   If MsgBox("您真的要删除吗？", vbYesNo) = vbYes Then
      OHwCks.Remove CStr(OHwCk.HwCkKey)
      Flex(FlexHwCk).RemoveItem Flex(FlexHwCk).Row
      If Flex(FlexHwCk).Rows = 1 Then
         Set OHwCk = Nothing
         Clearcontrol
      Else
         Set OHwCk = OHwCks(CStr(Flex(FlexHwCk).RowData(Flex(FlexHwCk).Row)))
         SetValueToControl
      End If
   End If
   
Exit Sub
Errorhandle:
   Err.Raise vbObjectError + 1, , Err.Description
End Sub

Private Sub Flex_RowColChange(Index As Integer)
On Error GoTo Errorhandle

   If Flex(FlexHwCk).Rows >= 1 Then
      Set OHwCk = OHwCks(CStr(Flex(FlexHwCk).RowData(Flex(FlexHwCk).Row)))
      SetValueToControl
   Else
      Set OHwCk = Nothing
      Clearcontrol
   End If
   
Exit Sub
Errorhandle:
   MsgBox Err.Description
End Sub

Private Sub SetValueToControl()
On Error GoTo Errorhandle

   Text(TxtHwCkMc).Text = OHwCk.HwCkMc
   Check(ChkHwCkIsStop).Value = OHwCk.HwCkIsStop
   
Exit Sub
Errorhandle:
   Err.Raise vbObjectError + 1, , Err.Description
End Sub

Private Sub Form_Resize()
On Error GoTo Errorhandle
   Resize_ALL Me
Exit Sub
Errorhandle:
   MsgBox Err.Description
End Sub

Private Sub Form_Unload(Cancel As Integer)
On Error GoTo Errorhandle

   Set OHwCk = Nothing
   Set OHwCks = Nothing
   
Exit Sub
Errorhandle:
   MsgBox Err.Description
End Sub