📄 menu55.frm
字号:
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 7440
TabIndex = 7
Top = 240
Width = 1215
End
Begin VB.Label Label7
Caption = "三单元"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 5280
TabIndex = 6
Top = 240
Width = 975
End
Begin VB.Label Label5
Caption = "五单元"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 9720
TabIndex = 5
Top = 240
Width = 975
End
Begin VB.Label Label4
Caption = "二单元"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3360
TabIndex = 4
Top = 240
Width = 1215
End
Begin VB.Label Label3
Caption = "一单元"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 1200
TabIndex = 3
Top = 240
Width = 1215
End
Begin VB.Line Line7
X1 = 0
X2 = 4800
Y1 = 7500
Y2 = 7500
End
Begin VB.Line Line6
X1 = 0
X2 = 11640
Y1 = 4800
Y2 = 4800
End
Begin VB.Line Line5
X1 = 0
X2 = 11640
Y1 = 4000
Y2 = 4000
End
Begin VB.Line Line4
X1 = 0
X2 = 11640
Y1 = 3270
Y2 = 3270
End
Begin VB.Line Line3
X1 = 0
X2 = 11640
Y1 = 2541
Y2 = 2541
End
Begin VB.Line Line2
X1 = 0
X2 = 11640
Y1 = 1200
Y2 = 1200
End
Begin VB.Line Line1
X1 = 0
X2 = 11640
Y1 = 720
Y2 = 720
End
End
Begin VB.Frame Frame2
Height = 735
Left = 120
TabIndex = 24
Top = 7200
Width = 11640
Begin VB.CommandButton Command4
Caption = "界面更换"
Height = 375
Left = 120
TabIndex = 108
Top = 240
Width = 1095
End
Begin VB.CommandButton Command2
Caption = "退出"
Height = 375
Left = 10680
TabIndex = 36
Top = 240
Width = 855
End
Begin VB.Image Image109
Height = 480
Left = 9840
Picture = "menu55.frx":4BFA
Top = 165
Width = 480
End
Begin VB.Label Label40
BackStyle = 0 'Transparent
Caption = "房屋售出，且款已付清标记："
Height = 375
Left = 7080
TabIndex = 27
Top = 330
Width = 2535
End
Begin VB.Image Image108
Height = 480
Left = 6000
Picture = "menu55.frx":4F04
Top = 165
Width = 480
End
Begin VB.Label Label39
BackStyle = 0 'Transparent
Caption = "房屋已售，款未付清标记："
Height = 255
Left = 3840
TabIndex = 26
Top = 360
Width = 2175
End
Begin VB.Image Image107
Height = 480
Left = 2760
Picture = "menu55.frx":520E
Top = 165
Width = 480
End
Begin VB.Label Label38
BackStyle = 0 'Transparent
Caption = "房屋未出售标记："
Height = 375
Left = 1320
TabIndex = 25
Top = 360
Width = 1455
End
End
Begin VB.Label Label2
Caption = "幸福小区一区楼栋销售状况一览图(第五栋)"
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 3240
TabIndex = 2
Top = 480
Width = 5775
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "金风房地产开发有限责任公司售房管理系统"
BeginProperty Font
Name = "宋体"
Size = 21.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 495
Left = 1920
TabIndex = 0
Top = 0
Width = 8415
End
End
Attribute VB_Name = "winmenu55"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim xsda As Database
Dim xstab As Recordset
Dim xstab1 As Recordset
Private Sub Combo1_KeyPress(KeyAscii As Integer)
KeyAscii = 0
End Sub
Private Sub Command1_Click()
Label44.Caption = LTrim(RTrim(Label44.Caption))
Text2.Text = LTrim(RTrim(Text2.Text))
Text1.Text = LTrim(RTrim(Text1.Text))
xsda.Execute "update falsexs set xiaosou ='" + Left(Combo1.Text, 1) + "', dys='" + Text2.Text + "', xsmj='" + Text1.Text + "' where dongs='5' and bh='" + Label44.Caption + "'"
b = Left(Combo1.Text, 1)
a = Val(Label44.Caption)
Select Case b
Case 1
'onef(a).Picture = LoadPicture(App.Path + "\ico\face1.ico")
onef(a).Picture = Nothing
Case 2
onef(a).Picture = LoadPicture(App.Path + "\ico\face2.ico")
Case 3
onef(a).Picture = LoadPicture(App.Path + "\ico\FACE3.ico")
End Select
Frame3.Visible = False
End Sub
Private Sub Command2_Click()
'winmenu0.Show
Unload Me
End Sub
Private Sub Command4_Click()
Set xsda = OpenDatabase(App.Path + "\sfgl.mdb")
Set xstab = xsda.OpenRecordset("select * from falsexs where dongs='5' order by val(bh)")
Set ckd = OpenDatabase(App.Path + "\sfgl.mdb")
Set ckt = ckd.OpenRecordset("ckbbb")
Do Until xstab.EOF
b = Val(xstab("xiaosou"))
a = Val(xstab("bh"))
If lamj(a - 1).Visible = False Then
onef(a).Visible = False
lamj(a - 1).Visible = True
'lamj(a - 1).Caption = " "
lamj(a - 1).Caption = Val(xstab("xsmj"))
Else
onef(a).Visible = True
lamj(a - 1).Visible = False
Select Case b
Case 1
'onef(a).Picture = LoadPicture(App.Path + "\ico\face1.ico")
onef(a).Picture = Nothing
Case 2
onef(a).Picture = LoadPicture(App.Path + "\ico\face2.ico")
Case 3
onef(a).Picture = LoadPicture(App.Path + "\ico\face3.ico")
End Select
End If
xstab.MoveNext
Loop
End Sub
Private Sub onef_Click(Index As Integer)
Set xstab1 = xsda.OpenRecordset("select * from falsexs where dongs='5' and bh='" + LTrim(Str$(Index)) + "'")
Frame3.Visible = True
Frame3.Left = 3480
Frame3.Top = 2160
Frame3.Width = 4815
Frame3.Height = 2775
'Label42.Caption = "第二单元"
Text2.Text = xstab1.Fields("dys")
Label44.Caption = Index
If xstab1("xsmj") = Empty Then Text1.Text = " " Else Text1.Text = Val(xstab1("xsmj"))
Combo1.ListIndex = Val(xstab1("xiaosou")) - 1
Select Case Index
Case 0
Case 1
End Select
Text2.SetFocus
End Sub
Private Sub Form_Load()
For i = 0 To 66
lamj(i).Caption = ""
lamj(i).Visible = False
Next i
winmenu55.Left = 0
winmenu55.Top = 0
winmenu55.Width = 11930
winmenu55.Height = 7940
Shape1.Left = 11
Shape1.Top = 11
Shape1.Height = 6419
Shape1.Width = 11640
Set xsda = OpenDatabase(App.Path + "\sfgl.mdb")
'Set xstab = xsda.OpenRecordset("falsexs")
'xsda.Execute "update falsexs set xsmj=' '"
Set xstab = xsda.OpenRecordset("select * from falsexs where dongs='5' order by val(bh)")
Do Until xstab.EOF
b = Val(xstab("xiaosou"))
a = Val(xstab("bh"))
Select Case b
Case 1
'onef(a).Picture = LoadPicture(App.Path + "\ico\face1.ico")
onef(a).Picture = Nothing
Case 2
onef(a).Picture = LoadPicture(App.Path + "\ico\face2.ico")
Case 3
onef(a).Picture = LoadPicture(App.Path + "\ico\face3.ico")
End Select
xstab.MoveNext
Loop
Combo1.AddItem "1-未销售"
Combo1.AddItem "2-销售未全部付款"
Combo1.AddItem "3-销售已全部付款"
Frame3.Height = 2785
Frame3.Width = 4825
Frame3.Left = 3680
Frame3.Top = 2100
Shape2.Left = 11
Shape2.Top = 11
Shape2.Height = 2754
Shape2.Width = 4804
'xsda.Execute "delete * from falsexs where dongs='5'"
'Set xstab = xsda.OpenRecordset("falsexs")
'For i = 1 To 66
' xstab.AddNew
' xstab("xiaosou") = "3"
' xstab("bh") = LTrim(Str$(i))
' xstab("dys") = "5"
' xstab.Update
'Next i
End Sub
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then Command1.SetFocus
If KeyAscii < 48 Or KeyAscii > 57 Then
If KeyAscii <> 8 Then
If KeyAscii <> 46 Then
KeyAscii = 0
End If
End If
End If
End Sub
Private Sub Text2_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then Text1.SetFocus
If KeyAscii < 48 Or KeyAscii > 57 Then If KeyAscii <> 8 Then KeyAscii = 0
End Sub
Private Sub Timer1_Timer()
Static move1 As Integer
move1 = Not move1
For i = 1 To 67
If move1 Then onef(i).Top = onef(i).Top - 40 Else onef(i).Top = onef(i).Top + 40
Next i
'If move1 Then onef(1).Top = onef(1).Top - 40 Else onef(1).Top = onef(1).Top + 40
'If move1 Then onef(2).Top = onef(2).Top - 40 Else onef(2).Top = onef(2).Top + 40
'If move1 Then onef(3).Top = one⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -