📄 frmhousebusquery.frm
字号:
VERSION 5.00
Object = "{AA0D501B-0C16-11D4-8531-00E098160F52}#2.0#0"; "COMNBUTTONS.OCX"
Object = "{C932BA88-4374-101B-A56C-00AA003668DC}#1.1#0"; "MSMASK32.OCX"
Begin VB.Form frmHouseBusQuery
BackColor = &H8000000A&
BorderStyle = 1 'Fixed Single
Caption = "查询条件"
ClientHeight = 3372
ClientLeft = 1824
ClientTop = 1812
ClientWidth = 5928
Icon = "frmHouseBusQuery.frx":0000
KeyPreview = -1 'True
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
Moveable = 0 'False
ScaleHeight = 3372
ScaleWidth = 5928
Begin VB.PictureBox Picture1
Align = 1 'Align Top
BackColor = &H8000000B&
Height = 3975
Left = 0
ScaleHeight = 3924
ScaleWidth = 5880
TabIndex = 5
Top = 0
Width = 5925
Begin VB.TextBox txtHandler
BeginProperty Font
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Left = 1095
TabIndex = 2
Text = "txtHandler"
Top = 1155
Width = 1800
End
Begin VB.TextBox txtSheetID
BeginProperty Font
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Left = 1095
TabIndex = 0
Text = "txtSheetID"
Top = 360
Width = 1800
End
Begin VB.TextBox txtDepart
BeginProperty Font
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Left = 3990
TabIndex = 1
Text = "txtDepart"
Top = 360
Width = 1800
End
Begin MSMask.MaskEdBox mskDate
Height = 345
Index = 0
Left = 1095
TabIndex = 3
Top = 1980
Width = 1800
_ExtentX = 3175
_ExtentY = 614
_Version = 393216
AutoTab = -1 'True
MaxLength = 10
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Mask = "####-##-##"
PromptChar = " "
End
Begin MSMask.MaskEdBox mskDate
Height = 330
Index = 1
Left = 3990
TabIndex = 4
Top = 1980
Width = 1800
_ExtentX = 3175
_ExtentY = 593
_Version = 393216
AutoTab = -1 'True
MaxLength = 10
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Mask = "####-##-##"
PromptChar = " "
End
Begin ComnButtons.ButtonGroup btg
Height = 468
Left = 3276
TabIndex = 13
Top = 2796
Width = 2532
_ExtentX = 4466
_ExtentY = 826
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BackColor = -2147483638
ButtonCount = 3
ButtonCaption = "&A.确定 &C.取消 &E.关闭"
KeyEnabled = "1#1#1#"
End
Begin VB.Label lblDtDes
AutoSize = -1 'True
Caption = "lblDtDes"
BeginProperty Font
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000D&
Height = 210
Left = 1200
TabIndex = 12
Top = 2850
Width = 840
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "事物名称:"
BeginProperty Font
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 120
TabIndex = 11
Top = 2850
Width = 945
End
Begin VB.Label Label8
AutoSize = -1 'True
Caption = "单 据 号"
BeginProperty Font
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 120
TabIndex = 10
Top = 420
Width = 840
End
Begin VB.Label lblDepart
AutoSize = -1 'True
Caption = "对应单位"
BeginProperty Font
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 3045
TabIndex = 9
Top = 420
Width = 840
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "发生日期"
BeginProperty Font
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 135
TabIndex = 8
Top = 2055
Width = 840
End
Begin VB.Label Label5
AutoSize = -1 'True
Caption = "操 作 员"
BeginProperty Font
Name = "宋体"
Size = 10.8
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 120
TabIndex = 7
Top = 1245
Width = 840
End
Begin VB.Label Label6
AutoSize = -1 'True
Caption = "--"
Height = 180
Left = 3345
TabIndex = 6
Top = 2070
Width = 180
End
Begin VB.Line Line1
BorderColor = &H80000009&
Index = 0
X1 = 45
X2 = 6585
Y1 = 2580
Y2 = 2580
End
Begin VB.Line Line1
BorderColor = &H80000010&
Index = 1
X1 = 45
X2 = 6600
Y1 = 2595
Y2 = 2595
End
End
End
Attribute VB_Name = "frmHouseBusQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public Event Ack(ByVal Cdt As String)
Public Event Cancel()
Private OldDepart As String
Private OldHandler As String
Private WithEvents CmnHlp As frmInputHelp
Attribute CmnHlp.VB_VarHelpID = -1
Public MDtType As TSDtType
Private Sub InitForm()
Set CmnHlp = New frmInputHelp
Set CmnHlp.CN = gDbObj.CN
lblDepart.Visible = False
txtDepart.Visible = False
Init
End Sub
Private Sub Init()
Dim CurDate As String
hisFormClear Me
txtHandler = gtydSysConfig.HdCode
mskDate(0) = gfnGetTime(gstrCOMN_DATE)
mskDate(1) = gfnGetTime(gstrCOMN_DATE)
Me.lblDtDes = gTsObj.Name(MDtType)
End Sub
Private Sub cmdAck_Click()
RaiseEvent Ack(MakeCdt())
Unload Me
End Sub
Private Function MakeCdt() As String
Set gDBFldsObj = New clsDBFields
gDBFldsObj.Add "House_BusMain.DtCode", gTsObj.Code(MDtType), "", lmEquel
gDBFldsObj.Add "House_BusMain.SheetID", txtSheetID, "", lmEquel
If txtDepart.Visible Then
gDBFldsObj.Add "House_BusMain.VsDepCode", txtDepart.Tag, "", lmlike
End If
gDBFldsObj.Add "House_BusMain.BusDate", mskDate(0).Text & " 00:00:00", gstrMASK_INIT_BGN, lmGreatAndEquel
gDBFldsObj.Add "House_BusMain.BusDate", mskDate(1).Text & " 23:59:59", gstrMASK_INIT_END, lmLessAndEquel
gDBFldsObj.Add "House_BusMain.HdCode", txtHandler, "", lmEquel
MakeCdt = gDBFldsObj.MakeSelectSQL("")
End Function
Private Sub cmdClose_Click()
Unload Me
End Sub
Private Sub CmnHlp_ResSelect(ByVal SelData As Variant, ByVal STag As String)
Me.SetFocus
Select Case STag
Case "Depart"
If TypeName(SelData) <> "Nothing" Then
txtDepart.Tag = SelData(0)
txtDepart = SelData(1)
Else
txtDepart.Tag = ""
txtDepart = ""
End If
OldDepart = txtDepart
End Select
End Sub
Private Sub btg_Click(ByVal WhichB As Integer)
Select Case WhichB
Case 0
RaiseEvent Ack(MakeCdt())
Unload Me
Case 1
Init
Case 2
RaiseEvent Cancel
Unload Me
End Select
End Sub
Private Sub Form_KeyPress(KeyAscii As Integer)
If KeyAscii = vbKeyReturn Then
hisToActiveCtl(Me).SetFocus
End If
End Sub
Private Sub Form_Load()
Call hisFormToCenter(Me, frmMain)
InitForm
End Sub
Private Sub Form_Unload(Cancel As Integer)
Set frmHouseBusQuery = Nothing
End Sub
Private Sub mskDate_LostFocus(Index As Integer)
If mskDate(Index) <> gstrMASK_INIT And Not IsDate(mskDate(Index)) Then
MsgBox gstrDATE_ERROR_MSG, vbCritical
mskDate(Index).SetFocus
End If
End Sub
Private Sub txtDepart_GotFocus()
OldDepart = txtDepart
End Sub
Private Sub txtDepart_LostFocus()
If OldDepart <> txtDepart Then
If txtDepart <> "" Then
CmnHlp.SQL = "SELECT m_Depart.DepCode,m_Depart.DepName FROM m_Depart" _
& " WHERE m_Depart.Brief LIKE '##%' AND Leaf =1" _
& " AND m_Depart.depCode <> '" & gtydSysConfig.DepCode & "'"
CmnHlp.InitPut = txtDepart.Text
CmnHlp.FormatHead = "科 别 编 码|科 别 名 称 "
CmnHlp.WidthRate = 1
CmnHlp.ParmTag = "Depart"
CmnHlp.ShowHelp vbModal
Else
txtDepart.Tag = ""
End If
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -