📄 frmhouseaskquery.frm
字号:
VERSION 5.00
Object = "{AA0D501B-0C16-11D4-8531-00E098160F52}#4.0#0"; "ComnButtons.ocx"
Object = "{C932BA88-4374-101B-A56C-00AA003668DC}#1.1#0"; "MSMASK32.OCX"
Begin VB.Form frmHouseAskQuery
BackColor = &H8000000A&
BorderStyle = 1 'Fixed Single
Caption = "请领查询条件"
ClientHeight = 3540
ClientLeft = 2376
ClientTop = 1896
ClientWidth = 5916
Icon = "frmHouseAskQuery.frx":0000
KeyPreview = -1 'True
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
Moveable = 0 'False
ScaleHeight = 3540
ScaleWidth = 5916
Begin VB.PictureBox Picture1
Align = 1 'Align Top
BackColor = &H8000000B&
Height = 3975
Left = 0
ScaleHeight = 3924
ScaleWidth = 5868
TabIndex = 5
Top = 0
Width = 5916
Begin VB.Frame Frame1
Caption = "状态"
ForeColor = &H8000000D&
Height = 972
Left = 72
TabIndex = 12
Top = 2472
Width = 2844
Begin VB.OptionButton OptStatus
Caption = "请领确认"
Height = 276
Index = 2
Left = 816
TabIndex = 15
Top = 624
Width = 1284
End
Begin VB.OptionButton OptStatus
Caption = "请领未确认"
Height = 276
Index = 1
Left = 816
TabIndex = 14
Top = 360
Width = 1284
End
Begin VB.OptionButton OptStatus
Caption = "所有"
Height = 276
Index = 0
Left = 816
TabIndex = 13
Top = 120
Width = 1284
End
End
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 = 11
Top = 3012
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 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 = 48
X2 = 6588
Y1 = 2436
Y2 = 2436
End
Begin VB.Line Line1
BorderColor = &H80000010&
Index = 1
X1 = 48
X2 = 6603
Y1 = 2448
Y2 = 2448
End
End
End
Attribute VB_Name = "frmHouseAskQuery"
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 WithEvents CmnHlp As frmInputHelp
Attribute CmnHlp.VB_VarHelpID = -1
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)
OptStatus(0).Value = True
txtDepart = gtydSysConfig.VsStoreName
txtDepart.Tag = gtydSysConfig.VsStore
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(tsH_ASK_IN), "", 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
If OptStatus(0).Value Then
gDBFldsObj.Add "House_BusMain.Flag & 2", 0, -32767, lmEquel
End If
If OptStatus(1).Value Then
gDBFldsObj.Add "House_BusMain.Flag & 3", 1, -32767, lmEquel
End If
If OptStatus(2).Value Then
gDBFldsObj.Add "House_BusMain.Flag & 3", 0, -32767, lmEquel
End If
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 frmHouseAskQuery = 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 + -