Exemple #1
0
        /// <summary>
        /// group by
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="selectAction"></param>
        /// <param name="iExpression"></param>
        /// <returns></returns>
        public static LinqQueryAction <T> GroupBy <T>(
            this LinqQueryAction <T> selectAction,
            Expression <Func <T, object[]> > iExpression)
        {
            ConditionBuilder conditionBuilder = new ConditionBuilder();

            conditionBuilder.Build(iExpression.Body);
            selectAction.CAction.SqlGroupBy(conditionBuilder.Condition);
            return(selectAction);
        }
Exemple #2
0
        /// <summary>
        /// order by
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="selectAction"></param>
        /// <param name="iExpression"></param>
        /// <param name="eByEnum"></param>
        /// <returns></returns>
        public static LinqQueryAction <T> OrderBy <T>(
            this LinqQueryAction <T> selectAction,
            Expression <Func <T, object> > iExpression, OrderByEnum eByEnum)
        {
            ConditionBuilder conditionBuilder = new ConditionBuilder();

            conditionBuilder.Build(iExpression.Body);
            selectAction.CAction.SqlOrderBy(conditionBuilder.Condition, eByEnum);
            return(selectAction);
        }
Exemple #3
0
        /// <summary>
        /// 新增,修改的条件的添加
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="action"></param>
        /// <param name="iExpression">直接添加实体类</param>
        /// <returns></returns>
        public static LinqQueryAction <T> SqlValue <T>(this LinqQueryAction <T> action,
                                                       Expression <Func <T, T> > iExpression)
        {
            ConditionBuilder conditionBuilder = new ConditionBuilder();

            conditionBuilder.Build(iExpression.Body);
            if (conditionBuilder.ConObjects.Count > 0)
            {
                action.CAction.SetDbEntity((BaseEntity)conditionBuilder.ConObjects[0]);
            }
            return(action);
        }
Exemple #4
0
        /// <summary>
        /// 新增,修改的条件的添加
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="action"></param>
        /// <param name="iExpression"></param>
        /// <returns></returns>
        public static LinqQueryAction <T> SqlValue <T>(this LinqQueryAction <T> action,
                                                       Expression <Func <T, bool> > iExpression)
        {
            ConditionBuilder conditionBuilder = new ConditionBuilder();

            conditionBuilder.Build(iExpression.Body);
            for (int i = 0; i < conditionBuilder.ConObjects.Count; i++)
            {
                action.CAction.SqlKeyValue(conditionBuilder.ConObjects[i].ToString(), conditionBuilder.Arguments[i]);
            }
            return(action);
        }
Exemple #5
0
        /// <summary>
        /// 多个新增同时操作
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="action"></param>
        /// <param name="iExpression">直接添加实体类</param>
        /// <returns></returns>
        public static LinqQueryAction InsertList(this LinqQueryAction action,
                                                 Expression <Func <List <BaseEntity> > > iExpression)
        {
            ConditionBuilder conditionBuilder = new ConditionBuilder();

            conditionBuilder.Build(iExpression.Body);
            if (conditionBuilder.Arguments.Length > 0)
            {
                List <BaseEntity> entities = ((List <BaseEntity>)conditionBuilder.Arguments[0]).Cast <BaseEntity>().ToList();
                ((InserAction)action.CAction).InsertList(entities);
            }
            return(action);
        }
Exemple #6
0
        /// <summary>
        ///  查找,删除,更新的where条件的添加
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="dataBaseAction"></param>
        /// <param name="wherePredicate"></param>
        /// <returns></returns>
        public static LinqQueryAction <T> Where <T>(this LinqQueryAction <T> dataBaseAction, Expression <Func <T, bool> > wherePredicate)
            where T : BaseEntity
        {
            string command = string.Empty;

            ConditionBuilder conditionBuilder = new ConditionBuilder();

            conditionBuilder.Build(wherePredicate.Body);

            if (!String.IsNullOrEmpty(conditionBuilder.Condition))
            {
                command = conditionBuilder.Condition;
            }
            dataBaseAction.CAction.SqlWhere(command);
            return(dataBaseAction);
        }