- ©«¤l
- 334
- ¥DÃD
- 139
- ºëµØ
- 0
- ¿n¤À
- 621
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWSXP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥x¥_¿¤
- µù¥U®É¶¡
- 2010-8-5
- ³Ì«áµn¿ý
- 2022-11-3
|
©I¥s¦Ûq¨ç¼Æ
§Ú¦³¤@Óµ{¦¡½X¡A¦p¤U
½Ð°Ý§Ún¦p¦ó©I¥s¦Ûq¨ç¼Æ
§Ú¿ï¤½¦¡¡Ö´¡¤J¨ç¼Æ¡A§ä¤£¨ì¨Ï¥ÎªÌ©w¸q¨ç¼Æ¡An½Ð±Ð¦p¦ó©I¥s¦Ûq¨ç¼Æ¡A
¥i§_¼g¨BÆJ¥X¨Ó¡A·PÁÂ
Function AUTO_CATEGORY(A, B, C)
Dim result_start, result_make, result1, result2, result3, result4, result5
Dim result6, result7, result8, result9, result10, result11
Dim result12, result13, result14, result15, result16, result17
Dim result18, result19, result20, result21, result22, result23, result24
Dim result25, result26, result27, result28, result29, result30, result31
Dim result32, result33, result34, result35, result36, result37, result38
Dim result39, result40, result41, result42, result43, result44, result45, result46
result_make = InStr(A.Value, "7070")
result_start = InStr(B.Value, "7070")
result1 = InStr(C.Value, "¶g¥X±b")
result2 = InStr(C.Value, "¡]¢°¡^")
result3 = InStr(C.Value, "°O¤íµo²¼µ|ÃBÂà¦C")
result4 = InStr(C.Value, "«D°O¤í")
result5 = InStr(C.Value, "¡]¢³¡^")
result6 = InStr(C.Value, "¡]¢´¡^")
result7 = InStr(C.Value, "»¼©µ±b¶µÅu´£")
result8 = InStr(C.Value, "À³¦¬")
result9_1 = InStr(C.Value, "¾Ç¥Í±JªÙ")
result9_2 = InStr(C.Value, "±JªÙ")
result9_3 = InStr(C.Value, "±Jºô")
result10 = InStr(C.Value, "WI-FI")
result11 = InStr(C.Value, "¹w¦¬ÂàÀ禬")
result12 = InStr(C.Value, "¹º")
result13 = InStr(C.Value, "¶V")
result14 = InStr(C.Value, "À³Åu")
result15 = InStr(C.Value, "À禬±b¶µ½Õ¾ã")
result16 = InStr(C.Value, "¡]¢¶¡^")
result16_1 = InStr(C.Value, "¼Æ¾Úµo²¼ÃþªA°ÈÂà¦CÀ禬")
result17 = InStr(C.Value, "±b³æ¦X¨ÖÀ禬½Õ¾ã")
result18 = InStr(C.Value, "½Õ§ï±b¶Ç²¼")
result19 = InStr(C.Value, "µ¡¤f")
result20 = InStr(C.Value, "°h")
result21 = InStr(C.Value, "§ó¥¿")
result22 = InStr(C.Value, "À禬Âà±b¨Æ¶µ")
result23 = InStr(C.Value, "À禬¾P±b¹º¥X¶Ç²¼")
result24 = InStr(C.Value, "¬ì¥Ø½Õ¾ã")
result25 = InStr(C.Value, "«Ø°Ó")
result26 = InStr(C.Value, "±b°È½Õ±b")
result27 = InStr(C.Value, "LB410")
result28 = InStr(C.Value, "¤H¤u±b")
result29 = InStr(C.Value, "¹w¦ô")
result30 = InStr(C.Value, "µo²¼Ãþt¼Æ")
result31 = InStr(C.Value, "½Õ§ï±b¤J±b")
result32 = InStr(C.Value, "¸É¾P±b")
result33 = InStr(C.Value, "¼Æ¾Úµo²¼·~°Èt¼Æ")
result34 = InStr(C.Value, "¬ì¥Ø»~¦CÂॿ")
result35 = InStr(C.Value, "§Kµ|")
result36 = InStr(C.Value, "·|p¬ì¥ØÂॿ")
result37 = InStr(C.Value, "¨R±b")
result38 = InStr(C.Value, "¬õ§Q")
result39 = InStr(C.Value, "¶g¦ô¦C")
result40 = InStr(C.Value, "¶gµo²¼Ãþ¤ë¯²¶O")
result41 = InStr(C.Value, "¥¼¾P±b")
result42 = InStr(C.Value, "À³¦¬x¨Æ")
result43 = InStr(C.Value, "¬O¤è")
result44 = InStr(C.Value, "µ²ºâ")
result45 = InStr(C.Value, "¤½¸Ü")
result46 = InStr(C.Value, "¥~Àð")
result47 = InStr(C.Value, "HINET¹wú¨îµo²¼¤Îµo²¼§@·~«e¹wú¬ì¥ØÂà¦C")
result48 = InStr(C.Value, "¬ì¥ØÂà¦C")
result49 = InStr(C.Value, "À禬±b¶µ½Õ¾ã")
result50 = InStr(C.Value, "¥X¯²©ãª÷³]ºâ§Q®§")
If (result1 > 0 And result_start = 0) Then
AUTO_CATEGORY = "¨t²Î¥X±b"
ElseIf (result2 <> 1 And result3 > 0) Then
AUTO_CATEGORY = "°O¤íµo²¼"
ElseIf (result > 0 And result_start > 0) Then
AUTO_CATEGORY = "HD°O¤í"
ElseIf (result2 = 1 And result3 > 0) Then
AUTO_CATEGORY = "HD°O¤í"
ElseIf (result2 = 1 And result4 > 0) Then
AUTO_CATEGORY = "HD«D°O¤í"
ElseIf (result5 = 1) Then
AUTO_CATEGORY = "¦¬¤ä¨t²Î"
ElseIf (result6 = 1 Or result7 > 0 Or result8 = 1) Then
AUTO_CATEGORY = "¦¬¤ä½Õ¾ã"
ElseIf (result9_1 > 0 Or result9_2 > 0 Or result9_3 > 0) Then
AUTO_CATEGORY = "¦¬¤ä½Õ¾ã"
ElseIf (result10 > 0 Or result11 > 0) Then
AUTO_CATEGORY = "¦¬¤ä½Õ¾ã"
ElseIf (result_make = 0 And result12 = 1 And result13 = 0) Then
AUTO_CATEGORY = "¦¬¤ä½Õ¾ã"
ElseIf (result_make > 0 And result12 > 0 And result13 = 0) Then
AUTO_CATEGORY = "À³¥IÅu¤À"
ElseIf (result_make > 0 And result14 > 0) Then
AUTO_CATEGORY = "À³¥IÅu¤À"
ElseIf (result_make > 0 And result15 > 0) Then
AUTO_CATEGORY = "À³¥IÅu¤À"
ElseIf (result16 = 1 Or result16_1 > 0) Then
AUTO_CATEGORY = "¹w¦¬ÂàÀ禬"
ElseIf (result17 > 0 Or result18 > 0 Or result20 > 0 Or result21 > 0) Then
AUTO_CATEGORY = "½Õ§ï±b"
ElseIf (result5 <> 1 And result19 > 0) Then
AUTO_CATEGORY = "½Õ§ï±b"
ElseIf (result22 > 0 Or result23 > 0 Or result24 > 0 Or result25 > 0) Then
AUTO_CATEGORY = "½Õ§ï±b"
ElseIf (result26 > 0 Or result27 > 0 Or result30 > 0 Or result31 > 0) Then
AUTO_CATEGORY = "½Õ§ï±b"
ElseIf (result28 > 0 And result29 = 0) Then
AUTO_CATEGORY = "½Õ§ï±b"
ElseIf (result32 > 0 Or result33 > 0 Or result34 > 0 Or result35 > 0) Then
AUTO_CATEGORY = "½Õ§ï±b"
ElseIf (result36 > 0 Or result37 > 0 Or result47 > 0 Or result48 > 0 Or result49 > 0) Then
AUTO_CATEGORY = "½Õ§ï±b"
ElseIf (result_make > 0 And result29 > 0 And result38 = 0) Then
AUTO_CATEGORY = "¼Æ¤À¦ô¦C"
ElseIf (result39 > 0 Or result40 > 0) Then
AUTO_CATEGORY = "¥_¤À¦ô¦C"
ElseIf (result41 > 0) Then
AUTO_CATEGORY = "¥¼¾P±b¦ô¦C"
ElseIf (result42 > 0 Or result43 > 0 Or result44 = 1 Or result45 > 0 Or result46 > 0 Or result50 > 0) Then
AUTO_CATEGORY = "¨ä¥L"
ElseIf (result38 > 0) Then
AUTO_CATEGORY = "¬õ§Q¿nÂI"
Else
AUTO_CATEGORY = "[No Match Rule?]"
End If
End Function |
|