📄 systemset.frm
字号:
Size = 10.5
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 3
Left = 1200
TabIndex = 7
Top = 1680
Width = 3495
End
Begin VB.TextBox Text1
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 4
Left = 1200
TabIndex = 6
Top = 2160
Width = 3495
End
Begin VB.TextBox Text1
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 5
Left = 1200
TabIndex = 5
Top = 2640
Width = 2415
End
Begin VB.TextBox Text1
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 6
Left = 1200
TabIndex = 4
Top = 3120
Width = 3495
End
Begin VB.TextBox Text1
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Index = 7
Left = 1200
TabIndex = 3
Top = 3600
Width = 5535
End
Begin VB.Label Label1
Caption = "帐套名称："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 0
Left = 120
TabIndex = 18
Top = 240
Width = 1455
End
Begin VB.Label Label1
Caption = "公司名称："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 1
Left = 120
TabIndex = 17
Top = 720
Width = 1455
End
Begin VB.Label Label1
Caption = "公司地址："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 2
Left = 120
TabIndex = 16
Top = 1200
Width = 1455
End
Begin VB.Label Label1
Caption = "联系电话："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 3
Left = 120
TabIndex = 15
Top = 1680
Width = 1455
End
Begin VB.Label Label1
Caption = "传真号码："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 4
Left = 120
TabIndex = 14
Top = 2160
Width = 1455
End
Begin VB.Label Label1
Caption = "邮政编码："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 5
Left = 120
TabIndex = 13
Top = 2640
Width = 1455
End
Begin VB.Label Label1
Caption = "电子邮箱："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 6
Left = 120
TabIndex = 12
Top = 3120
Width = 1455
End
Begin VB.Label Label1
Caption = "主页地址："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 7
Left = 120
TabIndex = 11
Top = 3600
Width = 1455
End
End
End
End
Attribute VB_Name = "SystemSet"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim TempSQL As String
Dim TempRS As MYSQL_RS
Dim i As Long
Set TempRS = New MYSQL_RS
TempSQL = "Select * from userreftable"
TempRS.OpenRs TempSQL, gCnn
With TempRS
For i = 0 To 7
.Fields(2) = Text1(i).Text
GUserRef(i) = Text1(i).Text
.Update
.MoveNext
Next i
End With
TempRS.CloseRecordset
TempRS.ReleaseMemory
Set TempRS = Nothing
Set TempRS = New MYSQL_RS
TempSQL = "Select * from pricereftable"
TempRS.OpenRs TempSQL, gCnn
With TempRS
For i = 0 To 2
.Fields(1) = Val(Text2(i).Text)
GPriceRef(i) = Val(Text2(i).Text)
.Update
.MoveNext
Next i
End With
TempRS.CloseRecordset
TempRS.ReleaseMemory
Set TempRS = Nothing
Set TempRS = New MYSQL_RS
TempSQL = "Select * from counttable Where countname = " & Quote("货物入库方式")
TempRS.OpenRs TempSQL, gCnn
For i = 0 To 3
If Option1(i).Value = True Then Exit For
Next i
If i > 3 Then i = 0
TempRS.Fields("count") = i
GSellGoodsWay = i
TempRS.Update
TempRS.CloseRecordset
TempRS.ReleaseMemory
Set TempRS = Nothing
Unload Me
End Sub
Private Sub Command2_Click()
Unload Me
End Sub
Private Sub Form_Load()
VarInitData.InitBSE BSE1, 0
LoadData
End Sub
Private Sub Form_Unload(Cancel As Integer)
If BSE1.EngineStarted Then BSE1.EndSubClassing
End Sub
Private Sub Text2_LostFocus(Index As Integer)
Dim i As Integer
For i = 0 To 2
Text2(i).Text = Format(Text2(i).Text, "0.0000")
Next i
End Sub
Public Sub LoadData(Optional ByVal TypeBS As Boolean = False)
Dim TempSQL As String
Dim TempRS As MYSQL_RS
Dim i As Long
Set TempRS = New MYSQL_RS
TempSQL = VarInitData.DisplaySQLVal(40)
TempRS.OpenRs TempSQL, gCnn
i = 0
With TempRS
For i = 0 To 7
If TypeBS = False Then
Text1(i).Text = .Fields(2).Value
Else
GUserRef(i) = .Fields(2).Value
End If
.MoveNext
Next i
End With
TempRS.CloseRecordset
TempRS.ReleaseMemory
Set TempRS = Nothing
Set TempRS = New MYSQL_RS
TempSQL = VarInitData.DisplaySQLVal(26)
TempRS.OpenRs TempSQL, gCnn
With TempRS
For i = 0 To 2
If TypeBS = False Then
Text2(i).Text = .Fields(0).Value
Else
GPriceRef(i) = .Fields(0).Value
End If
.MoveNext
Next i
End With
TempRS.CloseRecordset
TempRS.ReleaseMemory
Set TempRS = Nothing
Set TempRS = New MYSQL_RS
TempSQL = "Select count from counttable Where countname = " & Quote("货物入库方式")
TempRS.OpenRs TempSQL, gCnn
If TypeBS = False Then
i = TempRS.Fields(0).Value
Option1(i).Value = True
Else
GSellGoodsWay = TempRS.Fields(0).Value
End If
TempRS.CloseRecordset
TempRS.ReleaseMemory
Set TempRS = Nothing
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -