111,092
社区成员




string namewhere = "";
for(int i= 0 ; i< name.Length; i++)
{
namewhere += "@p" + i + "," ;
paramlist.Add(new SqlParameter("@p" + i, name[i]));
}
namewhere = namewhere.TrimEnd(',');
sql += " and EngineerName in(" + namewhere + ")";
select distinct mi.EngineerName,count(*) as count from MeetImage_info as mi inner join Split(@name,',') as sp on sp.Result =mi.EngineerName