/// <summary>
/// 生成更新语句
/// </summary>
/// <param name="exceptColumn">不需要更新的列</param>
/// <returns></returns>
public override string BuildUpdate(List <string> exceptColumn)
{
if (exceptColumn?.Count == 0)
{
throw new MissingFieldException("except column should not be empty");
}
var columns = UpdateFields.Where(f => !exceptColumn.Contains(f)).Select(f => $"`{f}` = @{f}").ToList();
return($@"UPDATE {TableName} SET { string.Join(" , ", columns) } WHERE `{mPrimaryKeyName}` = @{mPrimaryKeyName}");
}