/// <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}"); }