C#实现把String字符串转化为SQL语句中的In后接的参数

实现把String字符串转化为In后可用参数代码：

 public string StringToList(string aa)

    {

        string bb1 = "(";

        if (!string.IsNullOrEmpty(aa.Trim()))

        {

            string[] bb = aa.Split(new string[] { "\r\n", ",", ";", "* " }, StringSplitOptions.RemoveEmptyEntries);

            for (int i = ; i < bb.Length; i++)

            {

                if (!bb1.Contains(bb[i]))//去掉重复的輸入值

                {

                    bb1 += "'" + bb[i] + "',";

                }

            }

        }

        bb1 = bb1.Substring(, bb1.LastIndexOf(",")) + ")";

        return bb1;

    }