Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        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);
        }