📄 sc_ywdw.frm
字号:
Index = 4
Left = 7920
Picture = "sc_ywdw.frx":0CB0
TabIndex = 15
Top = 6840
Width = 1575
End
Begin VB.CommandButton Cmd2
Caption = "查询(F10)"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 555
Index = 5
Left = 9840
Picture = "sc_ywdw.frx":0DB2
TabIndex = 14
Top = 6840
Width = 1575
End
Begin VB.Timer Timer1
Interval = 1000
Left = 240
Top = 2400
End
Begin VB.Frame Frame6
Caption = "筛选条件"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 2055
Left = 6240
TabIndex = 10
Top = 4560
Width = 5535
Begin VB.TextBox m_khdm1
Height = 255
Left = 1440
MaxLength = 5
TabIndex = 11
Text = "Text2"
Top = 360
Width = 1215
End
Begin VB.Label Label21
AutoSize = -1 'True
Caption = "订房单位:"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 360
TabIndex = 13
Top = 360
Width = 945
End
Begin VB.Label Label22
AutoSize = -1 'True
Caption = "预达日期:"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 360
TabIndex = 12
Top = 840
Width = 945
End
End
Begin MSFlexGridLib.MSFlexGrid FLEX1
Height = 5655
Left = 120
TabIndex = 20
Top = 960
Width = 5895
_ExtentX = 10398
_ExtentY = 9975
_Version = 327680
Rows = 3
Cols = 10
FixedCols = 0
BackColor = -2147483624
FocusRect = 0
SelectionMode = 1
AllowUserResizing= 3
End
Begin VB.Label nam
AutoSize = -1 'True
Caption = "操作类型:"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 9360
TabIndex = 34
Top = 240
Width = 1035
End
Begin VB.Label name1
AutoSize = -1 'True
Caption = "市场管理:"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 600
TabIndex = 33
Top = 360
Width = 1035
End
Begin VB.Label rec_no
AutoSize = -1 'True
Caption = "当前记录数:"
Height = 180
Left = 4200
TabIndex = 32
Top = 360
Width = 990
End
End
Begin VB.Label frm_msg
BackColor = &H8000000A&
ForeColor = &H00FF0000&
Height = 735
Left = 5400
TabIndex = 35
Top = 0
Width = 6375
End
Begin VB.Label Label1
BackColor = &H00C0C0C0&
BeginProperty Font
Name = "黑体"
Size = 18
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 615
Left = 0
TabIndex = 36
Top = 0
Width = 11775
End
End
Attribute VB_Name = "scgl_ywdw"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim key_index As Integer
Dim t_bt As String
Dim t_fields As Variant
Dim Response As String
Dim t_rec3 As Recordset 'ADDNEW,EDIT,DELETE
Dim t_rec4 As Recordset 'LOCK_NO
Dim t_rec As Recordset 'MSFLEXGRID
Dim t_rec1 As Recordset
Dim rec As Recordset
Dim t_rq As String
Dim dh As String
Dim T_TJ As String '筛选条件
Private Sub Cmd2_Click(Index As Integer)
Select Case Index
Case 0
Case 1
Case 2
Case 3
Case 4
Case 5
Case 6
End Select
End Sub
Private Sub Form_Load()
Dim SYS_UID As String, SYS_PWD As String
JZ_USER = SYS_USER + Space(1) + SYS_NAME
JZ_JRSJ2 = Time()
SYS_UID = "db2user"
SYS_PWD = "db2user"
KeyPreview = True
name1.Caption = "客户单位一览表"
Call atfirst
Set rec = PUB_data.OpenRecordset("select KHDM,YWDW_MC,DZ,LXR,LXDH,BZ,LOCK_NO from YX_DWQK", 4)
If Not rec.BOF Then
rec.MoveLast
t_fields = Array(0, 1, 2, 3, 4, 5)
t_bt = "^ 客户编号 |^ 单位名称 |^ 详细地址 |^ 联系人 |^ 联系电话 |^ 备注 "
Call pub_memo.Flex_full(FLEX1, t_bt, rec, t_fields, 5, Array(0, 0, 0, 0, 0, 0))
End If
rec_no.Caption = "当前记录数:" + CStr(FLEX1.Rows - 1)
End Sub
Sub MAIN(t_gnmc As String)
Label1.Caption = t_gnmc
JZ_USER = SYS_USER + Space(1) + SYS_NAME
JZ_JRSJ2 = Time()
JZ_DQSJ2 = Time()
End Sub
Private Sub Cmd3_Click()
Unload Me
yx_main.Show (1)
End Sub
Private Sub FLEX1_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyReturn Then
Cmd2(0).SetFocus
End If
End Sub
Private Sub FLEX1_GotFocus()
On Error GoTo ERROR1
m_khdm.Text = Trim(FLEX1.TextArray(FLEX1.Row * 6))
m_ywdw_mc.Text = IIf(Trim(FLEX1.TextArray(FLEX1.Row * 6 + 1)) = "*", "", Trim(FLEX1.TextArray(FLEX1.Row * 6 + 1)))
m_dz.Text = IIf(Trim(FLEX1.TextArray(FLEX1.Row * 6 + 2)) = "*", "", Trim(FLEX1.TextArray(FLEX1.Row * 6 + 2)))
m_lxr.Text = IIf(Trim(FLEX1.TextArray(FLEX1.Row * 6 + 3)) = "*", "", Trim(FLEX1.TextArray(FLEX1.Row * 6 + 3)))
m_lxdh.Text = IIf(Trim(FLEX1.TextArray(FLEX1.Row * 6 + 4)) = "*", "", Trim(FLEX1.TextArray(FLEX1.Row * 6 + 4)))
m_bz.Text = Trim(FLEX1.TextArray(FLEX1.Row * 6 + 5))
Exit Sub
ERROR1:
If Err() = 383 Then
Resume Next
End If
End Sub
Private Sub FLEX1_RowColChange()
On Error GoTo ERROR1
m_khdm.Text = Trim(FLEX1.TextArray(FLEX1.Row * 6))
m_ywdw_mc.Text = IIf(Trim(FLEX1.TextArray(FLEX1.Row * 6 + 1)) = "*", "", Trim(FLEX1.TextArray(FLEX1.Row * 6 + 1)))
m_dz.Text = IIf(Trim(FLEX1.TextArray(FLEX1.Row * 6 + 2)) = "*", "", Trim(FLEX1.TextArray(FLEX1.Row * 6 + 2)))
m_lxr.Text = IIf(Trim(FLEX1.TextArray(FLEX1.Row * 6 + 3)) = "*", "", Trim(FLEX1.TextArray(FLEX1.Row * 6 + 3)))
m_lxdh.Text = IIf(Trim(FLEX1.TextArray(FLEX1.Row * 6 + 4)) = "*", "", Trim(FLEX1.TextArray(FLEX1.Row * 6 + 4)))
m_bz.Text = Trim(FLEX1.TextArray(FLEX1.Row * 6 + 5))
Exit Sub
ERROR1:
If Err() = 383 Then
Resume Next
End If
End Sub
Private Sub Timer1_Timer()
JZ_DQSJ2 = Time()
End Sub
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
key_index = 100
Select Case KeyCode
Case vbKeyF2
key_index = 0 '建立
Case vbKeyF3
key_index = 1 '修改
Case vbKeyF4
key_index = 2 '解除
Case vbKeyF5
key_index = 3 '打印
Case vbKeyF6
key_index = 4 '筛选
Case vbKeyF7
key_index = 7 '转预订等待
Case vbKeyF10
key_index = 5 '查询
Case vbKeyF9
key_index = 6
Case vbKeyEscape
key_index = 99 '退出
End Select
If key_index = 99 Then
If Frame2.Enabled = False And Frame6.Enabled = False Then
Call Cmd3_Click
Else
Call atfirst
End If
Else
If Frame2.Enabled = False And Frame6.Enabled = False Then
Call Cmd2_Click(key_index)
End If
End If
End Sub
Private Sub atfirst()
Cmd2(0).Enabled = True
Cmd2(1).Enabled = True
Cmd2(2).Enabled = True
Cmd2(3).Enabled = True
Cmd2(4).Enabled = True
Cmd2(5).Enabled = True
Cmd2(6).Enabled = True
Cmd2(7).Enabled = True
Cmd3.Enabled = True
If FLEX1.Enabled = False Then
FLEX1.Enabled = True
FLEX1.SetFocus
End If
If scgl_ywdw.KeyPreview = False Then
scgl_ywdw.KeyPreview = True
End If
STY = ""
m_khdm.Text = ""
nam.Caption = ""
End Sub
Private Sub refresh1()
If frm_msg.Enabled = True Then
frm_msg.Caption = ""
End If
If Not T_TJ = "" Then
Set t_rec = PUB_data.OpenRecordset("select YDD_H,KR_MC,RZRQ,YDSJ,LDRQ,DF_JS,GZ_JS,RS,DFY_DM,KHDM,LOCK_NO from YD_YDDK Where " & T_TJ, 4)
If Not t_rec.BOF Then
t_rec.MoveLast
End If
Else
Set t_rec = PUB_data.OpenRecordset("select YDD_H,KR_MC,RZRQ,YDSJ,LDRQ,DF_JS,GZ_JS,RS,DFY_DM,KHDM,LOCK_NO from YD_YDDK", 4)
If Not t_rec.BOF Then
t_rec.MoveLast
End If
End If
Call Flex_full(FLEX1, t_bt, t_rec, t_fields, 8, Array(0, 0, 0, 0, 0, 0, 0, 0, 0))
rec_no.Caption = "当前记录数:" + CStr(FLEX1.Rows - 1)
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -