110,533
社区成员
发帖
与我相关
我的任务
分享
string GetSqlWhere(IList columns)
{
if(columns == null || columns.Length == 0)
return String.Empty;
else if(columns.Length == 1)
return String.Format("{0} = {1}", columns[0]);
string first = columns[0];
StringBuilder builder = new StringBuilder(columns.Length);
for(int i=1; i < columns.Length; i++)
{
builder.Append(first);
builder.Append("=");
builder.Append(columns[i]);
builder.Append(" AND ");
}
return builder.ToString().SubString(0, builder.Length-1);
}