关于拼接字符串的一个小问题

Question

foreach (string item in list)
        {
            if (where == string.Empty)
            {
                where += "and ([TT_Price_ItemID] = '" + item.Trim() + "' ";
            }
            else
            {
                where += " or [TT_Price_ItemID] = '" + item.Trim() + "') ";
            }
        }

在没有OR条件是‘）’收在and条件后面。我是初级菜鸟，所以......

Answer 1

foreach (string item in list)
        {
            if (where == string.Empty)
            {
                where += "and ([TT_Price_ItemID] = '" + item.Trim() + "' ";
            }
            else
            {
                where += " or [TT_Price_ItemID] = '" + item.Trim() + "'";

            }
        }

 where += ") ";

---

歡迎參觀我的Blog.NET菜鳥自救會

Answer 2

foreach (string item in list)
        {
            if (where == string.Empty)
            {
                where += "and ([TT_Price_ItemID] = '" + item.Trim() + "' ";
            }
            else
            {
                where += " or [TT_Price_ItemID] = '" + item.Trim() + "'";

            }
        }

 where += ") ";

---

歡迎參觀我的Blog.NET菜鳥自救會

感谢！是这个。