📄 frmclassedit.frm
字号:
VERSION 5.00
Object = "{7DE2015C-ABB4-4432-9634-EA5170D02672}#1.0#0"; "sTextBox.ocx"
Object = "{E11E7285-4386-40E5-A4D4-F55704D4D491}#1.0#0"; "sSuperGrid.ocx"
Object = "{8803088E-2AEB-4D2F-9AF0-D08480A9BEB9}#3.0#0"; "Sinour_ES.ocx"
Begin VB.Form frmClassEdit
BorderStyle = 3 'Fixed Dialog
Caption = "班次编辑"
ClientHeight = 3615
ClientLeft = 45
ClientTop = 330
ClientWidth = 6900
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 3615
ScaleWidth = 6900
ShowInTaskbar = 0 'False
Begin VB.Frame Frame
Height = 2955
Left = 120
TabIndex = 7
Top = 555
Width = 5070
Begin STEXTBOXLib.STextBox txt
Height = 300
Left = 420
TabIndex = 8
Top = 1365
Visible = 0 'False
Width = 1500
_Version = 65536
_ExtentX = 2646
_ExtentY = 529
_StockProps = 68
End
Begin SSUPERGRIDLib.SSuperGrid Grid
Height = 2760
Left = 45
TabIndex = 9
Top = 135
Width = 4965
_Version = 65536
_ExtentX = 8758
_ExtentY = 4868
_StockProps = 132
End
End
Begin STEXTBOXLib.STextBox txtName
Height = 300
Left = 1035
TabIndex = 0
Top = 225
Width = 1815
_Version = 65536
_ExtentX = 3201
_ExtentY = 529
_StockProps = 68
End
Begin Sinour_ES.sButton cmdSaveNew
Height = 375
Left = 5295
TabIndex = 2
Top = 1575
Width = 1455
_ExtentX = 2566
_ExtentY = 661
BTYPE = 7
TX = "保存新增 "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 13160660
BCOLO = 13160660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmClassEdit.frx":0000
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin Sinour_ES.sButton cmdExit
Height = 375
Left = 5295
TabIndex = 3
Top = 2430
Width = 1455
_ExtentX = 2566
_ExtentY = 661
BTYPE = 7
TX = "取消退出 "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 13160660
BCOLO = 13160660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmClassEdit.frx":001C
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin Sinour_ES.sButton cmdSaveExit
Height = 375
Left = 5310
TabIndex = 4
Top = 1995
Width = 1455
_ExtentX = 2566
_ExtentY = 661
BTYPE = 7
TX = "保存退出 "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 13160660
BCOLO = 13160660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmClassEdit.frx":0038
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin Sinour_ES.sButton cmdNext
Height = 375
Left = 5295
TabIndex = 5
Top = 1140
Width = 1455
_ExtentX = 2566
_ExtentY = 661
BTYPE = 7
TX = "后一记录 "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 13160660
BCOLO = 13160660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmClassEdit.frx":0054
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin Sinour_ES.sButton cmdPrevious
Height = 375
Left = 5295
TabIndex = 6
Top = 705
Width = 1455
_ExtentX = 2566
_ExtentY = 661
BTYPE = 7
TX = "前一记录 "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 13160660
BCOLO = 13160660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmClassEdit.frx":0070
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "班次名称:"
Height = 180
Left = 165
TabIndex = 1
Top = 285
Width = 810
End
End
Attribute VB_Name = "frmClassEdit"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim recGrid As New ADODB.Recordset
Dim recExec As New ADODB.Recordset
Dim m_ClassID As Integer
Dim m_Edit As Boolean
Public m_Changed As Boolean
Private Sub Form_Load()
Me.Icon = MDI.Icon
Set cmdPrevious.PictureNormal = MDI.Image.ListImages.Item("Previous").Picture
Set cmdNext.PictureNormal = MDI.Image.ListImages.Item("Next").Picture
Set cmdSaveExit.PictureNormal = MDI.Image.ListImages.Item("SaveExit").Picture
Set cmdExit.PictureNormal = MDI.Image.ListImages.Item("Exit").Picture
Set cmdSaveNew.PictureNormal = MDI.Image.ListImages.Item("SaveNew").Picture
Grid.AddHeader "序号", "Serial", 30, -1, -1, False, sSerial
Grid.AddHeader "上班时间", "OnDutyTime", 120, -1, "OnDutyTime", False, sDefault
Grid.AddHeader "下班时间", "OffDutyTime", 120, -1, "OffDutyTime", False, sDefault
Grid.Col("OnDutyTime").TextType = sTimeHM
Grid.Col("OnDutyTime").EditType = TextBox
Grid.Col("OffDutyTime").TextType = sTimeHM
Grid.Col("OffDutyTime").EditType = TextBox
Grid.EditHwnd(TextBox) = txt.hWnd
txt.RelateHwnd = Grid.hWnd
Grid.ColAutoResize = True
Grid.AllowAddNew = True
Grid.AllowEdit = True
Grid.MainCol = "OnDutyTime"
txtName.MaxTextLen = 20
txt.MaxTextLen = 20
End Sub
Public Sub AddBill()
txtName.PutText ""
If recGrid.State = 1 Then recGrid.Close
Set recGrid = Nothing
recGrid.CursorLocation = adUseClient
recGrid.Open "select * from Class_D where ClassID=0", con, adOpenStatic, adLockBatchOptimistic
Set Grid.DataSource = recGrid
m_Edit = False
m_Changed = False
End Sub
Public Sub EditBill(ByVal ClassID As Integer)
If recExec.State = 1 Then recExec.Close
Set recExec = Nothing
recExec.CursorLocation = adUseClient
recExec.Open "select * from Class where ClassID=" & ClassID, con, adOpenStatic, adLockBatchOptimistic
If IsNull(recExec.Fields("ClassName")) Then txtName.Text = "" Else txtName.Text = recExec.Fields("ClassName")
If recGrid.State = 1 Then recGrid.Close
Set recGrid = Nothing
recGrid.CursorLocation = adUseClient
recGrid.Open "select * from Class_D where ClassID=" & ClassID, con, adOpenStatic, adLockBatchOptimistic
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -