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