var name ="xxx";//入参var codes =newList<string>();//入参,要限制数量,数据多查询会很慢var sql =newStringBuilder();//sql语句var where_str =newStringBuilder();//查询条件var paras =newDictionary<string,dynamic>();//查询参数//like:if(!string.IsNullOrWhiteSpace(name)){
paras.Add("name",$"%{name}%");
where_str.Append($" and table1.name like @name");}//in:if(codes.Count >0){var codes_paras =newList<string>();for(var i =0; i < codes.Count; i++){
codes_paras.Add($"@Code{i}");
paras.Add($"Code{i}", codes[i]);}var codes_paras_str =string.Join(",", codes_paras);
where_str.Append($" and table1.code in ({codes_paras_str})");}
sql.Append(@$"
select
*
from table1
where 1=1
{where_str};
");var res = db.Excute(sql.ToString(), paras);