public static IUpdate <TEntity> AriesModify <TEntity>(this IFreeSql freesql, SqlModel <TEntity> model) where TEntity : class { if (model.ModifyInstance != null) { var handler = freesql.UpdateWithEntity(model.ModifyInstance.Fields, model.ModifyInstance.Instance); var instance = model.QueryInstance; if (instance != null) { if (instance.Contains != null && instance.Contains.Length > 0) { handler.Where(InQueryOperator <TEntity> .InHandler(instance.Contains)); } handler.WhereWithEntity(instance.Fields, instance.Instance); foreach (var item in model.GetWhereExpressions()) { handler.Where(item); } } if (model.QueryModel != null) { handler.WhereWithModel(model.QueryModel); } return(handler); } return(null); }
public static ISelect <TEntity> AriesQuery <TEntity>(this IFreeSql freesql, SqlModel <TEntity> model, out long total) where TEntity : class { var handler = freesql.Select <TEntity>(); var instance = model.QueryInstance; if (instance != null) { if (instance.Contains != null && instance.Contains.Length > 0) { handler.Where(InQueryOperator <TEntity> .InHandler(instance.Contains)); } handler.WhereWithEntity(instance.Fields, instance.Instance); foreach (var item in model.GetWhereExpressions()) { handler.Where(item); } } if (model.QueryModel != null) { handler.WhereWithModel(model.QueryModel); if (model.QueryModel.Total) { handler.Count(out total); } else { total = 0; } if (model.QueryModel.Size != 0) { handler.Page(model.QueryModel.Page, model.QueryModel.Size); } } else { total = 0; } return(handler); }