cmd.CommandText = "Sele ct top " & pagerows & " [_Identify], [_Identify] As 编号,[客户ID],[产品ID],[数量],[单价],[折扣] ,[数量]*[单价]*(1-[折扣]) as 金额 From {订单} where "
If flt > "" Then
cmd.CommandText &= iif(page=0, "1=1 and " & flt & " order by [_identify] DESC" , "[_Identify] not In (Sele ct top " & pagerows * page & " [_identify] from {订单} where " & flt & " order by [_identify] DESC) And " & flt & " order by [_Identify] DESC")
Else
cmd.CommandText &= iif(page=0, "1=1 order by [_identify] DESC" , "[_Identify] not In (Sele ct top " & pagerows * page & " [_identify] from {订单} order by [_identify] DESC) order by [_Identify] DESC")
End If
加好友 
发短信
Post By：2018/10/7 12:01:00 [显示全部帖子]
