public DbCommandSpec GetFindCommand(IList <Parameter> parameters, IList <string> condtions) { var command = new DbCommandSpec(); foreach (var parameter in parameters) { command.AddParameters(parameter); } var sql = BaseSelectSql; if (condtions.Count > 0) { sql += " where " + string.Join(" and ", condtions.ToArray()); } command.SetCommandText(sql); return(command); }