For i = 1 To ListView2.ListItems.Count If ListView2.ListItems(i).Selected = True Then
If ListView2.ListItems(i).Text = "1" Then
MsgBox "This Item has been ordered"
Exit Sub
Else
Set oRs = New ADODB.Recordset
STx = "Select B.price,B.MenuID,B.ItemID from TableBookTrans A inner join TableBookDetail B on A.MenuID=B.MenuID Where A.Manualkey='" & mcID.Text & "' and B.Barcode='" & Sk & "'"
Set oRs = oCmn.ExecRS(STx, DCN)
Sm = CCur(Sm + oRs.Fields("Price"))
St = oRs.Fields("MenuID")
Sg = oRs.Fields("ItemID")
End If
End If
Next问题:我如何临时存储ListView2.ListItems(i).Selected = True时的数据st与sg? 我class modules中要处理这些数据。
需要建一个临时表存储吗?
If ListView2.ListItems(i).Text = "1" Then
MsgBox "This Item has been ordered"
Exit Sub
Else
Set oRs = New ADODB.Recordset
STx = "Select B.price,B.MenuID,B.ItemID from TableBookTrans A inner join TableBookDetail B on A.MenuID=B.MenuID Where A.Manualkey='" & mcID.Text & "' and B.Barcode='" & Sk & "'"
Set oRs = oCmn.ExecRS(STx, DCN)
Sm = CCur(Sm + oRs.Fields("Price"))
St = oRs.Fields("MenuID")
Sg = oRs.Fields("ItemID")
End If
End If
Next问题:我如何临时存储ListView2.ListItems(i).Selected = True时的数据st与sg? 我class modules中要处理这些数据。
需要建一个临时表存储吗?
解决方案 »
- ??? 数据库的读取---->过程运算
- 为什么我无法选出一个日期范围内的数值呢~~~!!!
- 请教一个复杂的文件处理问题?
- 如何实现向托盘的图标,如QQ。发送双击消息?
- 请教在VB将十六制数转换成二进制数
- 大家好
- 请问哪里有VB6下载?
- 怎样用VB通过FAX/MODEM接收、发送传真图象?各位高手帮帮忙了!!!
- 用prtfg控件打印DataGrid里的数据
- 我进了一家公司做Delphi程序,两个月了,老板说刚进来的时候是试用期,每个月300块钱,可是今天他炒了我,还说我没有为公司做什么事情,不给我工资,这合不合理呀。
- 新手学VB,过程的问题---在线狂等
- MSHFLexGrid 鼠标点击最后一行数据
.Source = str数据源
.ActiveConnection = cn连接
.CursorType = 前向光标
.LockType = 读锁定
.Open
.Save App.Path & str缓冲目录 & "\" & str缓冲文件名 & ".rst"End With
关闭纪录集 rst快速显示纪录集
基本汉语,应该能看明白吧?
Private Declare Function SafeArrayGetDim Lib "oleaut32.dll" (ByRef saArray() As Any) As Long
Dim ArrTmp() As Integer
'……
'……
'……
st = oRs.Fields("MenuID")
If SafeArrayGetDim(ArrTmp) > 0 Then
ReDim Preserve ArrTmp(UBound(ArrTmp) + 1)
Else
ReDim ArrTmp(0)
End If
ArrTmp(UBound(ArrTmp)) = st
For i = 1 To ListView2.ListItems.Count
If ListView2.ListItems(i).Selected = True Then
If ListView2.ListItems(i).Text = "1" Then
MsgBox "This Item has been ordered"
Exit Sub
Else
Set oRs = New ADODB.Recordset
STx = "Select B.price,B.MenuID,B.ItemID from TableBookTrans A " & _
"inner join TableBookDetail B on A.MenuID=B.MenuID Where A.Manualkey='" & _
mcID.Text & "' and B.Barcode='" & Sk & "'"
Set oRs = oCmn.ExecRS(STx, DCN)
Sm = CCur(Sm + oRs.Fields("Price"))
St = oRs.Fields("MenuID")
Sg = oRs.Fields("ItemID")
'注意这里可以这样保存
ListView2.ListItems(i).Tag = Sm & "|" & St & "|" & Sg
End If
End If
Next
'这里是把全部的读出来
Dim StrArray() As String
For i = 1 To ListView2.ListItems.Count
If ListView2.ListItems(i).Selected = True Then
If ListView2.ListItems(i).Text <> "1" Then
MsgBox "This Item has been ordered"
StrArray = Split(ListView2.ListItems(i).Tag, "|")
Sm = CCur(StrArray(0))
St = StrArray(1)
Sg = StrArray(2)
MsgBox "Sm:" & Sm & " St:" & St & " Sg:" & Sg
End If
End If
Next
For i = 1 To ListView2.ListItems.Count
If ListView2.ListItems(i).Selected = True Then
If ListView2.ListItems(i).Text <> "1" Then
MsgBox "This Item has been ordered"
StrArray = Split(ListView2.ListItems(i).Tag, "|")
Sm = CCur(StrArray(0))
St = StrArray(1)
Sg = StrArray(2)
MsgBox "Sm:" & Sm & " St:" & St & " Sg:" & Sg
End If
End If
Next我要把存储的数据传送到别的模块去,我要在别的模块对这些存储数据进行加工。
Transfer Sf, DCN, Sm,ArrTmp(UBound(ArrTmp)),ATp(UBound(ATp)),
如果要跟ListView2的次序对应,那么不用上面那么麻烦,直接可以这样
ReDim ArrTmp(ListView2.ListItems.Count -1)
ArrTmp(i)=St
那可以定义3个数组分别存放sm,st,sg
Transfer 是个函数名吧?sf,dcn我不知道你表示的是什么,如果是固定的
for i=0 to ubound(arrtmp)
Transfer Sf, DCN, ArrTmp1(i),ArrTmp2(i),ArrTmp3(i)
next
这样能看明白吧
也可以定义全局变量存储