using System;

using System.Collections.Generic;

public class Program

{

    public static void Main()

    {

        string sServiceCurrency = "1,2"; //人民幣加上美金

        string sSuerySataement = "";

        List<string> listSQL = new List<string>();

        if (sServiceCurrency != null && sServiceCurrency.Length > 0)

        {

            if (sServiceCurrency != "1,2,3,4"){ // 1,2,3,4 搜尋全部, 不用條件

                if (sServiceCurrency.IndexOf("1") >= 0){ //人民幣

                    listSQL.Add("(ATM_WITHDRAW_CNY=1)");

                }

                if (sServiceCurrency.IndexOf("2") >= 0){ //美金

                    listSQL.Add("(ATM_WITHDRAW_USD=1)");

                }

                if (sServiceCurrency.IndexOf("3") >= 0){ //JPY

                    listSQL.Add("(ATM_WITHDRAW_JPY=1)");

                }

                if (sServiceCurrency.IndexOf("4") >= 0){ //HKD

                    listSQL.Add("(ATM_WITHDRAW_HKD=1)");

                }

            }

        }

        if (listSQL.Count >= 1)

        {

            sSuerySataement = " ATM_WITHDRAW=1 and (" + string.Join(" or ", listSQL) + ") and ";

        }

        else

        {

            sSuerySataement = " ATM_WITHDRAW=1 ";

        }

        Console.WriteLine(sSuerySataement);

    }

}