求教if语句条件控制:(
BonusesCount=0
IF (not rs_T_Member.eof) and T_Count<=20 THEN
IF T_Count<=20 and rs_T_Member("T_Number_MemberCount")=1 THEN
rs_T_Member("T_Put_MoneyCount") = rs_T_Member("T_Put_MoneyCount") + 10*User_Type_Count
rs_T_Member("T_T_MoneyCount") = rs_T_Member("T_T_MoneyCount") + 10*User_Type_Count
BonusesCount=10*User_Type_Count
ELSEIF T_Count<=20 and rs_T_Member("T_Number_MemberCount")=2 THEN
rs_T_Member("T_Put_MoneyCount") = rs_T_Member("T_Put_MoneyCount") + 10*User_Type_Count
rs_T_Member("T_T_MoneyCount") = rs_T_Member("T_T_MoneyCount") + 10*User_Type_Count
BonusesCount=10*User_Type_Count
ELSEIF T_Count<=20 and rs_T_Member("T_Number_MemberCount")=3 THEN
rs_T_Member("T_Put_MoneyCount") = rs_T_Member("T_Put_MoneyCount") + 10*User_Type_Count
rs_T_Member("T_T_MoneyCount") = rs_T_Member("T_T_MoneyCount") + 10*User_Type_Count
BonusesCount=10*User_Type_Count
END IF
修改要求:
1)将T_count<=20 分为两种情况:第一种:当Tcount<=15 and rs_T_Member("T_Number_MemberCount")=1 时 得到下面的结果:
rs_T_Member("T_Put_MoneyCount") = rs_T_Member("T_Put_MoneyCount") + 10*User_Type_Count
rs_T_Member("T_T_MoneyCount") = rs_T_Member("T_T_MoneyCount") + 10*User_Type_Count
BonusesCount=10*User_Type_Count
第二种:当15<=Tcount<=20 and rs_T_Member("T_Number_MemberCount")=1 得到下面的结果:
rs_T_Member("T_Put_MoneyCount") = rs_T_Member("T_Put_MoneyCount") + 5*User_Type_Count
rs_T_Member("T_T_MoneyCount") = rs_T_Member("T_T_MoneyCount") + 5*User_Type_Count
BonusesCount=5*User_Type_Count
最后要求两种情况的和值
2)将T_count<=20 分为两种情况:第一种:当Tcount<=15 and rs_T_Member("T_Number_MemberCount")=2 时 得到下面的结果:
rs_T_Member("T_Put_MoneyCount") = rs_T_Member("T_Put_MoneyCount") + 10*User_Type_Count
rs_T_Member("T_T_MoneyCount") = rs_T_Member("T_T_MoneyCount") + 10*User_Type_Count
BonusesCount=10*User_Type_Count
第二种:当15<=Tcount<=20 and rs_T_Member("T_Number_MemberCount")=2 得到下面的结果:
rs_T_Member("T_Put_MoneyCount") = rs_T_Member("T_Put_MoneyCount") + 5*User_Type_Count
rs_T_Member("T_T_MoneyCount") = rs_T_Member("T_T_MoneyCount") + 5*User_Type_Count
BonusesCount=5*User_Type_Count
最后要求两种情况的和值
3)2)将T_count<=20 分为两种情况:第一种:当Tcount<=15 and rs_T_Member("T_Number_MemberCount")=3 时 得到下面的结果:
rs_T_Member("T_Put_MoneyCount") = rs_T_Member("T_Put_MoneyCount") + 10*User_Type_Count
rs_T_Member("T_T_MoneyCount") = rs_T_Member("T_T_MoneyCount") + 10*User_Type_Count
BonusesCount=10*User_Type_Count
第二种:当15<=Tcount<=20 and rs_T_Member("T_Number_MemberCount")=3 得到下面的结果:
rs_T_Member("T_Put_MoneyCount") = rs_T_Member("T_Put_MoneyCount") + 5*User_Type_Count
rs_T_Member("T_T_MoneyCount") = rs_T_Member("T_T_MoneyCount") + 5*User_Type_Count
BonusesCount=5*User_Type_Count
最后要求两种情况的和值
请问代码该如何调整啊,谢谢了!!