📄 menu51.frm
字号:
Height = 255
Left = 120
TabIndex = 9
Top = 480
Width = 255
End
Begin VB.Label Label9
BackStyle = 0 'Transparent
Caption = "单元"
Height = 255
Left = 360
TabIndex = 8
Top = 240
Width = 375
End
Begin VB.Line Line9
X1 = 0
X2 = 720
Y1 = 0
Y2 = 720
End
Begin VB.Line Line8
X1 = 720
X2 = 720
Y1 = 0
Y2 = 6480
End
Begin VB.Label Label8
Caption = "四单元"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 7560
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 = 5520
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 = 9600
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 = 5280
Y2 = 5280
End
Begin VB.Line Line5
X1 = 0
X2 = 11640
Y1 = 4320
Y2 = 4320
End
Begin VB.Line Line4
X1 = 0
X2 = 11640
Y1 = 3480
Y2 = 3480
End
Begin VB.Line Line3
X1 = 0
X2 = 11640
Y1 = 2685
Y2 = 2685
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 = 31
Top = 7200
Width = 11640
Begin VB.CommandButton Command4
Caption = "统计"
Height = 375
Left = 120
TabIndex = 45
Top = 240
Width = 855
End
Begin VB.CommandButton Command2
Caption = "退出"
Height = 375
Left = 10680
TabIndex = 44
Top = 240
Width = 855
End
Begin VB.Image Image109
Height = 480
Left = 9840
Picture = "menu51.frx":5822
Top = 165
Width = 480
End
Begin VB.Label Label40
BackStyle = 0 'Transparent
Caption = "房屋售出，且款已付清标记："
Height = 375
Left = 7080
TabIndex = 34
Top = 330
Width = 2535
End
Begin VB.Image Image108
Height = 480
Left = 5880
Picture = "menu51.frx":5B2C
Top = 165
Width = 480
End
Begin VB.Label Label39
BackStyle = 0 'Transparent
Caption = "房屋已售，款未付清标记："
Height = 375
Left = 3600
TabIndex = 33
Top = 330
Width = 2535
End
Begin VB.Image Image107
Height = 480
Left = 2520
Picture = "menu51.frx":5E36
Top = 165
Width = 480
End
Begin VB.Label Label38
BackStyle = 0 'Transparent
Caption = "房屋未出售标记："
Height = 375
Left = 1080
TabIndex = 32
Top = 360
Width = 1455
End
End
Begin VB.Image Image12
Height = 375
Left = 3120
Top = 2400
Width = 375
End
Begin VB.Image Image11
Height = 375
Left = 3120
Top = 2280
Width = 375
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 = "winmenu51"
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 Command1_Click()
xsda.Execute "update falsexs set xiaosou ='" + Left(Combo1.Text, 1) + "' where dys='1' 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()
winmenu501.Show
End Sub
Private Sub onef_Click(Index As Integer)
Set xstab1 = xsda.OpenRecordset("select * from falsexs where dys='1' and bh='" + LTrim(Str$(Index)) + "'")
Frame3.Visible = True
Frame3.Left = 3480
Frame3.Top = 2160
Frame3.Width = 4815
Frame3.Height = 2775
Label42.Caption = "第六单元"
Label44.Caption = Index
Combo1.Text = xstab1("xiaosou")
Select Case Index
Case 0
Case 1
End Select
End Sub
Private Sub Form_Load()
winmenu51.Left = 0
winmenu51.Top = 0
winmenu51.Width = 11930
winmenu51.Height = 7940
Shape1.Left = 11
Shape1.Top = 11
Shape1.Height = 6419
Shape1.Width = 11260
Set xsda = OpenDatabase(App.Path + "\sfgl.mdb")
Set xstab = xsda.OpenRecordset("select * from falsexs where dys='1' 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")
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-销售已全部付款"
Shape2.Left = 0
Shape2.Top = 0
Shape2.Height = 2764
Shape2.Width = 4804
End Sub
Private Sub Timer1_Timer()
Static move1 As Integer
move1 = Not move1
For i = 1 To 85
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 = onef(3).Top - 40 Else onef(3).Top = onef(3).Top + 40
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -