private bool HasChild(IEnumerable <string> ids) { if (ids == null || ids.Count() < 1) { return(false); } var sqlPlainText = _groupRep.GetSql(SqlName_HasChild); List <string> paraNames = new List <string>(); var paraValues = new ExpandoObject() as IDictionary <string, Object>; int i = 0; foreach (var id in ids) { paraNames.Add("@gp_id_" + i); paraValues.Add("gp_id_" + i, id); i++; } string sqlText = string.Format(sqlPlainText, string.Join(",", paraNames)); var val = _groupRep.ExecuteScalar <int>(sqlText, paraValues); return(val > 0); }