-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathfrmAddMoneyOption.frm
More file actions
209 lines (209 loc) · 6.36 KB
/
frmAddMoneyOption.frm
File metadata and controls
209 lines (209 loc) · 6.36 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form frmAddMoneyOption
BorderStyle = 3 'Fixed Dialog
Caption = "充值结转"
ClientHeight = 2250
ClientLeft = 45
ClientTop = 330
ClientWidth = 4665
Icon = "frmAddMoneyOption.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 2250
ScaleWidth = 4665
ShowInTaskbar = 0 'False
StartUpPosition = 3 'Windows Default
Begin VB.CommandButton cmdCancel
Cancel = -1 'True
Caption = "取消(&C)"
Height = 400
Left = 3090
TabIndex = 7
Top = 960
Width = 1200
End
Begin VB.CommandButton cmdOK
Caption = "开始(&B)"
Default = -1 'True
Height = 400
Left = 3090
TabIndex = 6
Top = 300
Width = 1200
End
Begin MSComCtl2.DTPicker DTPicker3
Height = 360
Left = 2790
TabIndex = 5
Top = 1575
Width = 1560
_ExtentX = 2752
_ExtentY = 635
_Version = 393216
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Format = 59310081
CurrentDate = 37424
End
Begin MSComCtl2.DTPicker DTPicker2
Height = 360
Left = 1155
TabIndex = 4
Top = 1575
Width = 1560
_ExtentX = 2752
_ExtentY = 635
_Version = 393216
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Format = 59310081
CurrentDate = 37424
End
Begin VB.OptionButton optBetween
Caption = "此间"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Left = 240
TabIndex = 3
Top = 1605
Width = 855
End
Begin MSComCtl2.DTPicker dtpBefore
Height = 360
Left = 1155
TabIndex = 2
Top = 930
Width = 1560
_ExtentX = 2752
_ExtentY = 635
_Version = 393216
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Format = 59310081
CurrentDate = 37424
End
Begin VB.OptionButton optBefore
Caption = "此前"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Left = 240
TabIndex = 1
Top = 960
Width = 810
End
Begin VB.OptionButton optAll
Caption = "结转全部充值信息"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Left = 240
TabIndex = 0
Top = 315
Value = -1 'True
Width = 2265
End
End
Attribute VB_Name = "frmAddMoneyOption"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub cmdCancel_Click()
Unload Me
End Sub
Private Sub cmdOK_Click()
Dim rstAddMoney As New ADODB.Recordset
Dim cmdAddMoney As New ADODB.Command
Dim rstAddMoneyHistory As New ADODB.Recordset
Dim i As Integer
Dim lngrow As Long
Dim strSql As String
writeLog Me.Name, "Begin"
If optAll Then
strSql = " * from AddMoney"
End If
If optBefore Then
strSql = " * from AddMoney where AddDate <= #" & Format(dtpBefore.Value, "YYYY-MM-DD") & "#"
End If
If optBetween Then
MsgShow "对不起，您不能采用此方式转出！"
Exit Sub
End If
Me.Hide
frmStatus.Show
rstAddMoney.Open "select " & strSql, gCnn, adOpenStatic, adLockReadOnly
rstAddMoneyHistory.Open "select top 1 * from AddMoneyHistory", gCnn, adOpenStatic, adLockOptimistic
lngrow = 1
With rstAddMoneyHistory
While Not rstAddMoney.EOF
.AddNew
For i = 1 To .Fields.Count - 2
.Fields(i) = rstAddMoney.Fields(i)
Next i
!ZZDate = Date
frmStatus.ShowMsg "正在转出使用使用日志，账号：" & !CountNo
.Update
rstAddMoney.MoveNext
lngrow = lngrow + 1
Wend
.Close
rstAddMoney.Close
cmdAddMoney.CommandText = "delete " & strSql
cmdAddMoney.ActiveConnection = gCnn
cmdAddMoney.Execute
Unload frmStatus
MsgShow "转账完毕！"
Unload Me
End With
writeLog Me.Name, "End", "共计：" & Str(lngrow)
End Sub
Private Sub Form_Load()
CenterForm Me
End Sub