📄 query_out.frm
字号:
EndProperty
ForeColor = &H000000FF&
Height = 240
Index = 3
Left = 2640
TabIndex = 25
Top = 1020
Width = 1080
End
Begin VB.Label Label1
Caption = "单价下限"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 240
Index = 4
Left = 90
TabIndex = 24
Top = 1035
Width = 1080
End
Begin VB.Label Label1
Caption = "单据号"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 240
Index = 1
Left = 2805
TabIndex = 17
Top = 255
Width = 1020
End
Begin VB.Label Label2
Caption = "科 室"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 315
Left = 120
TabIndex = 16
Top = 630
Width = 1215
End
Begin VB.Label Label1
Caption = "类 别"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 240
Index = 0
Left = 105
TabIndex = 15
Top = 255
Width = 1080
End
Begin VB.Label Label9
Caption = "拼音缩写"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 0
Left = 4365
TabIndex = 14
Top = 645
Width = 1215
End
End
Begin VB.CommandButton browse_com
Caption = "浏 览 (&B)"
BeginProperty Font
Name = "隶书"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 7545
TabIndex = 1
Top = 765
Width = 1665
End
Begin VB.CommandButton quit_com
Caption = "退 出 (&Q)"
BeginProperty Font
Name = "隶书"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 7545
TabIndex = 0
Top = 1500
Width = 1665
End
Begin ComCtl2.UpDown UpDown_end
Height = 285
Left = 6810
TabIndex = 5
Top = 105
Width = 270
_ExtentX = 476
_ExtentY = 503
_Version = 327681
Enabled = -1 'True
End
Begin MSMask.MaskEdBox end_date
Height = 345
Left = 5355
TabIndex = 6
Top = 75
Width = 1740
_ExtentX = 3069
_ExtentY = 609
_Version = 393216
BackColor = 14737632
MaxLength = 10
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Mask = "####-##-##"
PromptChar = "_"
End
Begin ComCtl2.UpDown UpDown_begin
Height = 285
Left = 3825
TabIndex = 7
Top = 105
Width = 270
_ExtentX = 476
_ExtentY = 503
_Version = 327681
Enabled = -1 'True
End
Begin MSMask.MaskEdBox begin_date
Height = 345
Left = 2370
TabIndex = 8
Top = 75
Width = 1740
_ExtentX = 3069
_ExtentY = 609
_Version = 393216
BackColor = 14737632
MaxLength = 10
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Mask = "####-##-##"
PromptChar = "_"
End
Begin MSRDC.MSRDC select_data
Height = 435
Left = 3285
Top = 3270
Visible = 0 'False
Width = 2070
_ExtentX = 3651
_ExtentY = 767
_Version = 393216
Options = 0
CursorDriver = 1
BOFAction = 0
EOFAction = 0
RecordsetType = 1
LockType = 3
QueryType = 0
Prompt = 3
Appearance = 1
QueryTimeout = 30
RowsetSize = 100
LoginTimeout = 15
KeysetSize = 0
MaxRows = 0
ErrorThreshold = -1
BatchSize = 15
BackColor = -2147483643
ForeColor = -2147483640
Enabled = -1 'True
ReadOnly = 0 'False
Appearance = -1 'True
DataSourceName = ""
RecordSource = ""
UserName = ""
Password = ""
Connect = ""
LogMessages = ""
Caption = "MSRDC1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin MSDBGrid.DBGrid show_data
Bindings = "query_out.frx":034C
Height = 4440
Left = 90
OleObjectBlob = "query_out.frx":0362
TabIndex = 21
Top = 2325
Width = 9360
End
Begin VB.Line Line1
BorderColor = &H00FF0000&
X1 = 1080
X2 = 7380
Y1 = 495
Y2 = 495
End
Begin VB.Label Label3
Caption = "起始日期"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 270
Index = 0
Left = 1305
TabIndex = 19
Top = 135
Width = 1020
End
Begin VB.Label Label3
Caption = "终止日期"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 270
Index = 1
Left = 4305
TabIndex = 18
Top = 150
Width = 1020
End
End
Attribute VB_Name = "query_out"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim mkind_code As String
Dim great_id As String
Dim little_id As String
Private Sub begin_date_GotFocus()
begin_date.SelStart = 0
begin_date.SelLength = Len(begin_date.Text)
End Sub
Private Sub begin_date_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 And IsDate(begin_date.Text) Then
spell_head_Change
end_date.SetFocus
End If
End Sub
Private Sub begin_date_KeyPress(KeyAscii As Integer)
If (KeyAscii < Asc("0") Or KeyAscii > Asc("9")) And KeyAscii <> 8 Then
KeyAscii = 0
End If
End Sub
Private Sub browse_com_Click()
spell_head_Change
End Sub
Private Sub buyer_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
If Trim(buyer.Text) <> "" Then spell_head_Change
show_great.SetFocus
End If
End Sub
Private Sub Check_in_Click()
spell_head_Change
End Sub
Private Sub Check_inback_Click()
spell_head_Change
End Sub
Private Sub end_date_GotFocus()
end_date.SelStart = 0
end_date.SelLength = Len(end_date.Text)
End Sub
Private Sub end_date_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 And IsDate(end_date.Text) Then
spell_head_Change
stuff_kind.SetFocus
End If
End Sub
Private Sub end_date_KeyPress(KeyAscii As Integer)
If (KeyAscii < Asc("0") Or KeyAscii > Asc("9")) And KeyAscii <> 8 Then
KeyAscii = 0
End If
End Sub
Private Sub Form_Load()
select_data.DataSourceName = dbfname
select_data.Connect = dbfstr
data_section.DatabaseName = dbfname
data_section.Connect = dbfstr
data_section.RecordSource = "select * from ks_table order by ks_name"
stuff_section.ListField = "ks_name"
data_great.DatabaseName = dbfname
data_great.Connect = dbfstr
reprint_com.Enabled = False
end_date.Text = Date
begin_date.Text = DateAdd("m", -1, Date)
begin_date.Text = DateAdd("d", 1, begin_date.Text)
stuff_kind.AddItem "卫生材料"
stuff_kind.AddItem "卫杂材料"
stuff_kind.AddItem "其他材料"
stuff_kind.Text = "卫生材料"
'''''隐藏主菜单''''''''''''''
stuff_main.Visible = False
stuff_main.Enabled = False
'''''''''''''''''''''''
End Sub
Private Sub Form_Unload(Cancel As Integer)
stuff_main.Enabled = True
stuff_main.Visible = True
End Sub
Private Sub lsh_up_Change()
If Trim(lsh_up) <> "" Then
reprint_com.Enabled = True
Else
reprint_com.Enabled = False
End If
End Sub
Private Sub lsh_up_GotFocus()
lsh_up.SelStart = 0
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -