/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public static WhereHelper <T> Update(T entity)
{
entity.Validate();
WhereHelper <T> wherehelper = new WhereHelper <T>();
List <PropertyInfo> properties = MemberInfoEx.GetPropertyCache <T>();
properties.ForEach(x => wherehelper.ParaAppend(x.Name, x.FastGetValue(entity), false));
return(wherehelper.StringAppend(_UpdateSql, " WHERE "));
}
/// <summary>
/// 比较符
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="wherehelper">wherehelper</param>
/// <param name="value">值</param>
/// <returns><see cref="WhereHelper{T}"/></returns>
public static WhereHelper <T> LessThan <T>(this WhereHelper <T> wherehelper, object value) where T : BaseEntity, new()
=> wherehelper.StringAppend(" < ", WhereHelper <T> .TurnParaToWherePrefix(wherehelper.PreField)).ParaAppend(string.Empty, value);
/// <summary>
/// 字段 like 值%
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="wherehelper">wherehelper</param>
/// <param name="field">字段</param>
/// <param name="value">值</param>
/// <returns><see cref="WhereHelper{T}"/></returns>
public static WhereHelper <T> FieldStartWith <T>(this WhereHelper <T> wherehelper, string field, object value) where T : BaseEntity, new()
=> wherehelper.StringAppend(" ", field, " Like ", WhereHelper <T> .TurnParaToWherePrefix(field)).ParaAppend(field, $"{value}%");
/// <summary>
/// 字段=值
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="wherehelper">wherehelper</param>
/// <param name="field">字段</param>
/// <param name="value">值</param>
/// <returns><see cref="WhereHelper{T}"/></returns>
public static WhereHelper <T> FieldEqual <T>(this WhereHelper <T> wherehelper, string field, object value) where T : BaseEntity, new()
=> wherehelper.StringAppend(" ", field, "=", WhereHelper <T> .TurnParaToWherePrefix(field)).ParaAppend(field, value);
/// <summary>
/// 并且
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="wherehelper">wherehelper</param>
/// <returns><see cref="WhereHelper{T}"/></returns>
public static WhereHelper <T> And <T>(this WhereHelper <T> wherehelper) where T : BaseEntity, new()
=> wherehelper.StringAppend(" And ");