dapper sql
//多条件参数
var args = new DynamicParameters(new {}); if (!string.IsNullOrWhiteSpace(userId))
{ sb.Append(" AND userId = @userId"); args.Add("userId", userId); } if (!string.IsNullOrWhiteSpace(username))
{
sb.Append(" AND username= @username");
args.Add("username", username);
}
//insert排除
[Write(false)]
public string AreaID { get; set; }