?? frmhwbm.frm
字號:
VERSION 5.00
Object = "{D76D7128-4A96-11D3-BD95-D296DC2DD072}#1.0#0"; "Vsflex7.ocx"
Begin VB.Form frmHwbm
Caption = "貨物資料"
ClientHeight = 4905
ClientLeft = 2235
ClientTop = 2400
ClientWidth = 8445
LinkTopic = "Form2"
LockControls = -1 'True
ScaleHeight = 4905
ScaleWidth = 8445
Begin VB.Frame Frame
Height = 3195
Left = 2970
TabIndex = 0
Top = 30
Width = 5355
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 = 1620
TabIndex = 10
Top = 2400
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 = 300
TabIndex = 9
Top = 2400
Width = 1125
End
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 = 2940
TabIndex = 8
Top = 2400
Width = 1125
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 = 2
Left = 1320
TabIndex = 6
Top = 1130
Width = 1575
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 = 4
Top = 700
Width = 3255
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 = 1290
TabIndex = 3
Top = 1530
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 = 0
Left = 1320
TabIndex = 1
Top = 270
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 = 2
Left = 270
TabIndex = 7
Top = 1185
Width = 945
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 = 5
Top = 765
Width = 975
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 = 0
Left = 270
TabIndex = 2
Top = 330
Width = 945
End
End
Begin VSFlex7Ctl.VSFlexGrid Flex
Height = 4695
Index = 0
Left = 60
TabIndex = 11
Top = 60
Width = 2775
_cx = 4895
_cy = 8281
_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 = 3
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 = "frmHwbm"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'QQ:75347626
'MSN:whailin2000@hotmail.com
Option Explicit
Const FlexHwbm = 0
Const TxtHwBmCode = 0
Const TxtHwBmMc = 1
Const TxtHwBmDw = 2
Const ChkHwbmIsStop = 0
Const CmdAdd = 0
Const CmdDel = 2
Const CmdSave = 3
Dim OHwbm As Hwbm
Dim OHwbms As Hwbms
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 mHwbm As Hwbm
On Error GoTo Errorhandle
Flex(FlexHwbm).Rows = 1
Set OHwbms = New Hwbms
OHwbms.Fillbydb
For Each mHwbm In OHwbms
ItemStr = vbTab & mHwbm.HwBmCode & vbTab & mHwbm.HwBmMc
Flex(FlexHwbm).AddItem ItemStr
Flex(FlexHwbm).RowData(Flex(FlexHwbm).Rows - 1) = mHwbm.HwbmKey
Next
If Flex(FlexHwbm).Rows > 1 Then
Flex(FlexHwbm).Row = 1
Set OHwbm = OHwbms(CStr(Flex(FlexHwbm).RowData(1)))
SetValueToControl
Else
Set OHwbm = Nothing
Clearcontrol
End If
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub AddRecord()
On Error GoTo Errorhandle
Set OHwbm = New Hwbm
Clearcontrol
Text(TxtHwBmCode).SetFocus
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub Clearcontrol()
On Error GoTo Errorhandle
Text(TxtHwBmCode).Text = ""
Text(TxtHwBmMc).Text = ""
Text(TxtHwBmDw).Text = ""
Check(ChkHwbmIsStop).Value = vbUnchecked
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub SaveRecord()
On Error GoTo Errorhandle
SetValueToObject
If OHwbm.HwbmId = -1 Then
OHwbms.Add OHwbm
ChgGrid "ADD"
Else
OHwbm.Save
ChgGrid "CHG"
End If
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub SetValueToObject()
On Error GoTo Errorhandle
OHwbm.HwBmCode = Trim(Text(TxtHwBmCode).Text)
OHwbm.HwBmMc = Trim(Text(TxtHwBmMc).Text)
OHwbm.HwBmDw = Trim(Text(TxtHwBmDw).Text)
OHwbm.HwBmIsStop = Check(ChkHwbmIsStop)
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 & OHwbm.HwBmCode & vbTab & OHwbm.HwBmMc
Flex(FlexHwbm).AddItem ItemStr
Flex(FlexHwbm).RowData(Flex(FlexHwbm).Rows - 1) = OHwbm.HwbmKey
Flex(FlexHwbm).Row = Flex(FlexHwbm).Rows - 1
Else
Flex(FlexHwbm).TextMatrix(Flex(FlexHwbm).Row, 1) = Text(TxtHwBmCode).Text
Flex(FlexHwbm).TextMatrix(Flex(FlexHwbm).Row, 2) = Text(TxtHwBmMc).Text
End If
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub Delrecord()
On Error GoTo Errorhandle
If Flex(FlexHwbm).Rows = 1 Then
Exit Sub
End If
If MsgBox("您真的要刪除嗎？", vbYesNo) = vbYes Then
OHwbms.Remove CStr(OHwbm.HwbmKey)
Flex(FlexHwbm).RemoveItem Flex(FlexHwbm).Row
If Flex(FlexHwbm).Rows = 1 Then
Set OHwbm = Nothing
Clearcontrol
Else
Set OHwbm = OHwbms(CStr(Flex(FlexHwbm).RowData(Flex(FlexHwbm).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(FlexHwbm).Rows >= 1 Then
Set OHwbm = OHwbms(CStr(Flex(FlexHwbm).RowData(Flex(FlexHwbm).Row)))
SetValueToControl
Else
Set OHwbm = Nothing
Clearcontrol
End If
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
Private Sub SetValueToControl()
On Error GoTo Errorhandle
Text(TxtHwBmCode).Text = OHwbm.HwBmCode
Text(TxtHwBmMc).Text = OHwbm.HwBmMc
Text(TxtHwBmDw).Text = OHwbm.HwBmDw
Check(ChkHwbmIsStop).Value = OHwbm.HwBmIsStop
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 OHwbm = Nothing
Set OHwbms = Nothing
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -