📄 sys_gyszl.frm
字号:
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 6
Left = 3540
TabIndex = 27
Top = 6240
Width = 855
End
Begin VB.Label Label1
BackColor = &H8000000B&
Caption = "国(州省):"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 5
Left = 120
TabIndex = 26
Top = 770
Width = 1575
End
Begin VB.Label Label1
BackColor = &H8000000B&
Caption = "市(区)/县:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 4
Left = 5100
TabIndex = 25
Top = 810
Width = 1215
End
Begin VB.Label Label1
BackColor = &H8000000B&
Caption = "乡/镇:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 3
Left = 120
TabIndex = 24
Top = 1180
Width = 1335
End
Begin VB.Label Label1
BackColor = &H8000000B&
Caption = "币制:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 2
Left = 120
TabIndex = 23
Top = 5280
Width = 855
End
Begin VB.Label Label1
BackColor = &H8000000B&
Caption = "登记日期:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 1
Left = 5820
TabIndex = 22
Top = 6240
Width = 1455
End
Begin VB.Label Label1
BackColor = &H8000000B&
Caption = "供应商编号"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 0
Left = 120
TabIndex = 21
Top = 360
Width = 1755
End
Begin VB.Label Label1
BackColor = &H8000000B&
Caption = "付款方式:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 14
Left = 120
TabIndex = 20
Top = 4870
Width = 1095
End
Begin VB.Label Label1
BackColor = &H8000000B&
Caption = "英文地址:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 15
Left = 120
TabIndex = 19
Top = 2820
Width = 1170
End
Begin VB.Label Label1
BackColor = &H8000000B&
Caption = "英文名称:"
BeginProperty Font
Name = "Arial"
Size = 11.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 16
Left = 120
TabIndex = 18
Top = 2000
Width = 1215
End
End
Begin MSAdodcLib.Adodc Adoprimaryrs
Height = 735
Left = 5580
Top = 2880
Width = 4215
_ExtentX = 7435
_ExtentY = 1296
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adoprimaryrs"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
End
Attribute VB_Name = "Sys_GYSZL"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub CMd_Find_Click()
On Error Resume Next
Set CX_FrM_SjY = Sys_GYSZL.AdoprimaryRs
CX_SJy = "select * from sys_gyszl where not gysmc is null "
With SEC_Dialog
.Combo1(0).Clear
.Combo1(1).Clear
.Combo1(0).AddItem ("gysbh(供方编号）")
.Combo1(1).AddItem ("gysbh(供方编号）")
.Combo1(0).AddItem ("gysmc(供方名称）")
.Combo1(1).AddItem ("gysmc(供方名称）")
.Combo1(0).AddItem ("sheng(省）")
.Combo1(1).AddItem ("sheng(省）")
.Combo1(0).AddItem ("shi(市）")
.Combo1(1).AddItem ("shi(市）")
.Combo1(0).AddItem ("zheng(镇）")
.Combo1(1).AddItem ("zheng(镇）")
.Combo1(0).AddItem ("lxr(联系人）")
.Combo1(1).AddItem ("lxr(联系人）")
End With
Load SEC_Dialog
SEC_Dialog.Show 1
End Sub
Private Sub CmdPrint_Click()
'ActiveReport1.DataControl1.ConnectionString = Conn_Str
khzl_rpt.DataControl1.ConnectionString = Conn_Str
khzl_rpt.Label29.Caption = "供 应 商 资 料 统 计 表"
khzl_rpt.Label31.Caption = "供应商名称"
khzl_rpt.Field1.DataField = "gysbh"
khzl_rpt.Field2.DataField = "gysmc"
khzl_rpt.DataControl1.Source = "select * from sys_gyszl order by gysbh " '"
khzl_rpt.Show VBRUN.FormShowConstants.vbModal
'ActiveReport1.DataControl1.Source = "select * from sys_gyszl with (nolock) order by gysbh " '"
'ActiveReport1.Show VBRUN.FormShowConstants.vbModal
End Sub
Private Sub Cmdreturn_Click()
Unload Me
End Sub
'*******************************************************
'* 曹汉华 2002.8.29 编写 *
'*******************************************************
Private Sub cmdnext_Click() '向后
On Error GoTo GoNextError
If Not AdoprimaryRs.Recordset.EOF Then AdoprimaryRs.Recordset.MoveNext
If AdoprimaryRs.Recordset.EOF And AdoprimaryRs.Recordset.RecordCount > 0 Then
Beep
AdoprimaryRs.Recordset.MoveLast
End If
Exit Sub
GoNextError:
MsgBox Err.Description
End Sub
Private Sub Cmdqd_Click() '首端
If AdoprimaryRs.Recordset.RecordCount > 0 Then
If AdoprimaryRs.BOFAction = False Then
AdoprimaryRs.Recordset.MoveFirst
Else
AdoprimaryRs.Recordset.MoveNext
End If
Else
Exit Sub
End If
End Sub
Private Sub cmdxq_Click() '向前
On Error GoTo GoPrevError
If Not AdoprimaryRs.Recordset.BOF Then AdoprimaryRs.Recordset.MovePrevious
If AdoprimaryRs.Recordset.BOF And AdoprimaryRs.Recordset.RecordCount > 0 Then
Beep
AdoprimaryRs.Recordset.MoveFirst
End If
Exit Sub
GoPrevError:
MsgBox Err.Description
End Sub
Private Sub cmdmd_Click() '末端
If AdoprimaryRs.Recordset.RecordCount > 0 Then
If AdoprimaryRs.Recordset.EOF = False Then
AdoprimaryRs.Recordset.MoveLast
Else
AdoprimaryRs.Recordset.MovePrevious
End If
Else
Exit Sub
End If
End Sub
Private Sub Combo1_Click(Index As Integer)
If Index = 0 Then
Set combo2_data = New Recordset
combo2_data.Open "select DISTINCT shi from sys_qysz where sheng='" & Trim(Combo1(0).Text) & "' and (not shi is null or shi<>'') ", DB, adOpenStatic
If combo2_data.RecordCount > 0 Then
Combo1(1).Clear
For i = 1 To combo2_data.RecordCount
Combo1(1).AddItem (combo2_data.Fields("shi"))
If combo2_data.EOF = False Then
combo2_data.MoveNext
End If
Next i
Combo1(1).Refresh
combo2_data.MoveFirst
Else
Exit Sub
End If
Combo1(1).Enabled = True
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -