📄 form1.frm
字号:
End
Begin MSAdodcLib.Adodc Adodc1
Height = 330
Left = 6120
Top = 0
Visible = 0 'False
Width = 1215
_ExtentX = 2143
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 2
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl"
OLEDBString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "dkk"
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 15.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSAdodcLib.Adodc Adodc3
Height = 330
Left = 6150
Top = 720
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 2
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl"
OLEDBString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "dqk"
Caption = "Adodc3"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 15.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.TextBox Text1
ForeColor = &H00FF0000&
Height = 495
Left = 600
TabIndex = 1
Top = 2640
Width = 5295
End
Begin MSAdodcLib.Adodc Adodc4
Height = 330
Left = 6165
Top = 1080
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 2
LockType = 3
CommandType = 2
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl;Mode=Read|Write;Initial Catalog=qfgl"
OLEDBString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl;Mode=Read|Write;Initial Catalog=qfgl"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "xtk"
Caption = "Adodc4"
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
Begin VB.Label Label2
Caption = "ver:2-04.02"
Height = 375
Left = 5880
TabIndex = 2
Top = 7320
Width = 1935
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "欢迎使用增值税专用发票比对监测系统"
BeginProperty Font
Name = "仿宋_GB2312"
Size = 26.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = -1 'True
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 525
Left = 1080
TabIndex = 0
Top = 1800
Width = 9180
End
Begin VB.Menu mnujb
Caption = "导入数据"
Begin VB.Menu mnuhfdk
Caption = "导入数据至抵扣库"
End
Begin VB.Menu mnuhfcg
Caption = "导入数据至存根库"
End
Begin VB.Menu mnuaaa
Caption = "-"
End
Begin VB.Menu mnushcw
Caption = "删除上月文件"
End
End
Begin VB.Menu mnudkjc
Caption = "抵扣联检查"
Begin VB.Menu mnucfp
Caption = "生成重复票文件"
End
Begin VB.Menu mnudkdf
Caption = "生成抵扣档案不符文件"
End
Begin VB.Menu mnuybns
Caption = "生成抵扣联预查结果文件"
End
End
Begin VB.Menu mnu
Caption = "清分数据"
Begin VB.Menu mnuwj
Caption = "生成非本地数据文件"
Visible = 0 'False
End
Begin VB.Menu mnudawj
Caption = "生成档案不符文件"
End
Begin VB.Menu mnudcdk
Caption = "导出档案库"
End
End
Begin VB.Menu mnubd
Caption = "比对数据"
Begin VB.Menu mnuqc
Caption = "比对清除"
End
Begin VB.Menu dywcsj
Caption = "打印无存根联数据"
End
End
Begin VB.Menu mnuxtsd
Caption = "系统维护"
Begin VB.Menu mnuczy
Caption = "操作员管理"
End
Begin VB.Menu mnucjdw
Caption = "采集点维护"
End
Begin VB.Menu mnubdsh
Caption = "本地税号"
End
Begin VB.Menu mnufg
Caption = "-"
End
Begin VB.Menu mnudak
Caption = "档案库维护"
End
End
Begin VB.Menu mnutc
Caption = "退出"
End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command12_Click()
Dim ss As String
If Adodc4.Recordset.EOF Then
MsgBox ("您没有输入地区税号，不能进行此操作！！")
Exit Sub
End If
ss = Adodc4.Recordset!dqh
Adodc3.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl"
Adodc3.CommandType = adCmdText
Adodc3.CursorLocation = adUseClient
Adodc3.RecordSource = "select * from dkk where left(gfsh,4)<>" & ss & " or Left(xfsh, 4) <> " & ss
Adodc3.Refresh
Adodc5.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl"
Adodc5.CommandType = adCmdText
Adodc5.CursorLocation = adUseClient
Adodc5.RecordSource = "select * from cgk where left(gfsh,4)<>" & ss & " or Left(xfsh, 4) <> " & ss
Adodc5.Refresh
Dim rss As TextStream
Set rss = fso.CreateTextFile("c:\dkk.txt", True)
If Not Adodc3.Recordset.EOF Then
Dim kk As Integer
Dim i As Integer
Adodc3.Recordset.MoveFirst
kk = Adodc3.Recordset.RecordCount
Text1.Text = kk
Adodc3.Recordset.MoveFirst
For i = 1 To kk
rss.WriteLine (Adodc3.Recordset!fpdm & Adodc3.Recordset!fph & Adodc3.Recordset!gfsh & Adodc3.Recordset!xfsh)
Adodc3.Recordset.MoveNext
Next i
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl"
cn.Open
Dim cm As ADODB.Command
Set cm = New ADODB.Command
cm.ActiveConnection = cn
cm.CommandType = adCmdText
cm.CommandText = "delete from cgk where left(gfsh,4)<>" & ss & " or Left(xfsh, 4) <> " & ss
cm.Execute
'Dim cn1 As ADODB.Connection
'Set cn1 = New ADODB.Connection
'cn1.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=qfgl"
'cn1.Open
'Dim cm1 As ADODB.Command
'Set cm1 = New ADODB.Command
'cm1.ActiveConnection = cn
'cm1.CommandType = adCmdText
'cm1.CommandText = "delete from dkk "
'cm1.Execute
cn.Close
'cn1.Close
MsgBox ("wwwwwwbbbbbbbb")
End If
End Sub
Private Sub Command2_Click()
a.Command1
drp2.Show 1
End Sub
Private Sub Command1_Click()
Adodc3.Recordset.MoveFirst
Do While Not Adodc3.Recordset.EOF
If fso.FileExists("c:\dak\" & Trim(Adodc3.Recordset!dm) & "\dkk.html") = True Then
fso.DeleteFile ("c:\dak\" & Trim(Adodc3.Recordset!dm) & "\dkk.html"), True
End If
If fso.FileExists("c:\dak\" & Trim(Adodc3.Recordset!dm) & "\cgk.html") = True Then
fso.DeleteFile ("c:\dak\" & Trim(Adodc3.Recordset!dm) & "\cgk.html"), True
End If
Adodc3.Recordset.MoveNext
Loop
End Sub
Private Sub dywcsj_Click()
Load Form8
Form8.Show
End Sub
Private Sub Form_Activate()
If xt = 0 Then
Load Form4
Form4.Show 1
End If
End Sub
Private Sub Form_Load()
Adodc4.Refresh
Adodc3.Refresh
If Adodc4.Recordset.EOF Then
MsgBox ("请输入本地税号，否则操作将不正常！！！！")
End If
Text1.Visible = False
End Sub
Private Sub mnuac97_Click()
On Error GoTo aa
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -