Пример #1
0
        /// <summary>
        /// 构造查询条件
        /// </summary>
        /// <param name="propertyName"></param>
        /// <param name="value"></param>
        /// <param name="op"></param>
        /// <param name="paramName"></param>
        /// <returns></returns>
        private static WhereClip BuildWhereChip(string propertyName, object value, QueryOper op, string paramName = null)
        {
            if (op != QueryOper.IsNull && op != QueryOper.IsNotNull && (value == null || value == DBNull.Value))
            {
                return(null);
            }
            WhereClip where = new WhereClip();
            StringBuilder sbSql = new StringBuilder($"{propertyName}{op.ToDescription()}");

            if (value != null && value != DBNull.Value)
            {
                if (paramName == null)
                {
                    paramName = SqlQueryUtils.GetParmName(propertyName);
                }
                if (paramName.Length > 0)
                {
                    sbSql.Append($"@{paramName} ");
                    where.Parameters.Add(new DataParameter(paramName, value));
                }
                else
                {
                    sbSql.Append($"{value} ");
                }
            }
            where.WhereSql = sbSql.ToString();
            return(where);
        }
Пример #2
0
 /// <summary>
 /// Not In  (Dapper.Net)
 /// </summary>
 /// <typeparam name="T"></typeparam>
 /// <param name="propertyName"></param>
 /// <param name="values"></param>
 /// <param name="paramName"></param>
 /// <returns></returns>
 public static WhereClip DapperNotIn <T>(string propertyName, IEnumerable <T> values, string paramName = null)
 {
     if (values == null || !values.Any())
     {
         return(null);
     }
     WhereClip where = new WhereClip();
     if (paramName == null)
     {
         paramName = SqlQueryUtils.GetParmName(propertyName);
     }
     if (paramName.Length > 0)
     {
         where.Parameters.Add(new DataParameter(paramName, values));
         where.WhereSql = $"{propertyName} not in @{paramName} ";
     }
     else
     {
         if (typeof(T).FullName == typeof(string).FullName)
         {
             string strIn = string.Join <T>("','", values);
             where.WhereSql = $"{propertyName} not in ('{strIn}') ";
         }
         else
         {
             string strIn = string.Join <T>(",", values);
             where.WhereSql = $"{propertyName} not in ({strIn}) ";
         }
     }
     return(where);
 }
Пример #3
0
        /// <summary>
        /// Apply a "between" constraint to the named property
        /// </summary>
        /// <param name="propertyName">The name of the Property in the class.</param>
        /// <param name="lo">The low value for the Property.</param>
        /// <param name="hi">The high value for the Property.</param>
        /// <returns>A <see cref="WhereClip" />.</returns>
        public static WhereClip Between(string propertyName, object lo, object hi, string paramName = null)
        {
            WhereClip where = new WhereClip();
            StringBuilder sbSql = new StringBuilder($"{propertyName} between ");

            if (paramName == null)
            {
                paramName = SqlQueryUtils.GetParmName(propertyName);
            }
            if (paramName.Length > 0)
            {
                string strParamName1 = paramName + "_pmin";
                string strParamName2 = paramName + "_pmax";
                sbSql.Append($"@{strParamName1} and @{strParamName2} ");
                where.Parameters.Add(new DataParameter(strParamName1, lo));
                where.Parameters.Add(new DataParameter(strParamName2, hi));
            }
            else
            {
                sbSql.Append($"{lo} and {hi} ");
            }
            where.WhereSql = sbSql.ToString();
            return(where);
        }
Пример #4
0
        /// <summary>
        /// Apply an "in" constraint to the named property (Dapper.Net)
        /// </summary>
        /// <typeparam name="TEntity"></typeparam>
        /// <param name="expression"></param>
        /// <param name="values"></param>
        /// <param name="paramName"></param>
        /// <returns></returns>
        public static WhereClip DapperIn <TEntity, T>(Expression <Func <TEntity, object> > expression, IEnumerable <T> values, string paramName = null) where TEntity : class
        {
            string propertyName = SqlQueryUtils.GetPropertyName(expression);

            return(DapperIn(propertyName, values, paramName));
        }
Пример #5
0
        /// <summary>
        /// Apply a "between" constraint to the named property
        /// </summary>
        /// <param name="expression">The name of the Property in the class.</param>
        /// <param name="lo">The low value for the Property.</param>
        /// <param name="hi">The high value for the Property.</param>
        /// <returns>A <see cref="WhereClip" />.</returns>
        public static WhereClip Between <TEntity>(Expression <Func <TEntity, object> > expression, object lo, object hi, string paramName = null) where TEntity : class
        {
            string propertyName = SqlQueryUtils.GetPropertyName(expression);

            return(Between(propertyName, lo, hi, paramName));
        }
Пример #6
0
        /// <summary>
        /// Apply a "greater than or equal" constraint to the named property
        /// </summary>
        /// <param name="expression">The name of the Property in the class.</param>
        /// <param name="value">The value for the Property.</param>
        public static WhereClip Ge <TEntity>(Expression <Func <TEntity, object> > expression, object value, string paramName = null) where TEntity : class
        {
            string propertyName = SqlQueryUtils.GetPropertyName(expression);

            return(Ge(propertyName, value, paramName));
        }
Пример #7
0
        /// <summary>
        /// 不为空
        /// </summary>
        /// <param name="expression"></param>
        /// <returns></returns>
        public static WhereClip IsNotNull <TEntity>(Expression <Func <TEntity, object> > expression) where TEntity : class
        {
            string propertyName = SqlQueryUtils.GetPropertyName(expression);

            return(IsNotNull(propertyName));
        }
Пример #8
0
        internal OrderByClip OrderBy <TEntity>(Expression <Func <TEntity, object> > expression, SortDirection sortDirection = SortDirection.Ascending)
        {
            string propertyName = SqlQueryUtils.GetPropertyName(expression);

            return(OrderBy(propertyName, sortDirection));
        }