📄 stuff_query_in.frm
字号:
_ExtentX = 4921
_ExtentY = 635
_Version = 393216
Style = 2
BackColor = 14737632
ListField = "yielder_name"
Text = "DBCombo1"
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
End
Begin MSDBCtls.DBCombo show_little
Bindings = "stuff_query_in.frx":0320
Height = 360
Left = 4725
TabIndex = 31
Top = 1320
Width = 2625
_ExtentX = 4630
_ExtentY = 635
_Version = 393216
Style = 2
BackColor = 12640511
Text = ""
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
End
Begin MSDBCtls.DBCombo show_great
Bindings = "stuff_query_in.frx":0336
Height = 360
Left = 1170
TabIndex = 32
Top = 1320
Width = 2550
_ExtentX = 4498
_ExtentY = 635
_Version = 393216
Style = 2
BackColor = 12640511
Text = ""
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
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 = &H00C00000&
Height = 240
Index = 5
Left = 60
TabIndex = 34
Top = 1395
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 = &H00C00000&
Height = 240
Index = 2
Left = 3870
TabIndex = 33
Top = 1365
Width = 1080
End
Begin VB.Label Label5
Caption = "经办人"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Left = 5265
TabIndex = 29
Top = 1020
Width = 945
End
Begin VB.Label Label4
Caption = "到"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Left = 4845
TabIndex = 27
Top = 270
Width = 360
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 = 3
Left = 2685
TabIndex = 25
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 = &H000000FF&
Height = 240
Index = 4
Left = 120
TabIndex = 24
Top = 1050
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 = 4335
TabIndex = 9
Top = 645
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 = 8
Top = 255
Width = 1080
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 = 7
Top = 645
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 = 1
Left = 3045
TabIndex = 6
Top = 270
Width = 765
End
End
Begin MSDBGrid.DBGrid show_data
Bindings = "stuff_query_in.frx":034B
Height = 4455
Left = 135
OleObjectBlob = "stuff_query_in.frx":0361
TabIndex = 21
Top = 2295
Width = 9360
End
Begin VB.Line Line1
BorderColor = &H00FF00FF&
X1 = 1200
X2 = 7500
Y1 = 480
Y2 = 480
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 = 4365
TabIndex = 13
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 = 0
Left = 1365
TabIndex = 12
Top = 120
Width = 1020
End
End
Attribute VB_Name = "stuff_query_in"
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_source.DatabaseName = dbfname
data_source.Connect = dbfstr
data_source.RecordSource = "select * from stuff_yielder order by yielder_name"
stuff_source.ListField = "yielder_name"
data_great.DatabaseName = dbfname
data_great.Connect = dbfstr
data_little.DatabaseName = dbfname
data_little.Connect = dbfstr
data_little.RecordSource = "select * from stuff_littlekind WHERE G_id=''"
data_little.Refresh
show_little.ListField = "L_NAME"
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 = "卫生材料"
'''''隐藏主菜单''''''''''''''
Form3.Visible = False
Form3.Enabled = False
'''''''''''''''''''''''
End Sub
Private Sub Form_Unload(Cancel As Integer)
Form3.Enabled = True
Form3.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
lsh_up.SelLength = Len(lsh_up.Text)
lsh_up.BackColor = &HFFFFFF
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -