Exemplo n.º 1
0
        /// <summary>
        /// 解释LessThen
        /// </summary>
        /// <param name="scope"></param>
        /// <param name="dbType"></param>
        /// <param name="paramName"></param>
        /// <param name="handle"></param>
        /// <param name="table"></param>
        /// <param name="entityInfo"></param>
        /// <returns></returns>
        internal static BQLCondition LessThen(Scope scope, DbType dbType, string paramName, BQLCondition handle, BQLTableHandle table, EntityInfoHandle entityInfo)
        {
            BQLValueTypeItem cvalue1 = new BQLValueTypeItem(scope.Value1);


            return(table[paramName, dbType] <= cvalue1);
        }
Exemplo n.º 2
0
        ///// <summary>
        ///// 要插入的字段
        ///// </summary>
        //internal BQLParamHandle[] ParamHandles
        //{
        //    get
        //    {
        //        return paramHandles;
        //    }
        //}

        /// <summary>
        /// 值
        /// </summary>
        /// <param name="values">值</param>
        /// <returns></returns>
        public KeyWordInsertValueItem Values(params object[] values)
        {
            BQLValueItem[] vitems = new BQLValueItem[values.Length];
            for (int i = 0; i < values.Length; i++)
            {
                if (values[i] == null)
                {
                    vitems[i] = new BQLValueTypeItem(null);
                }
                else if (values[i] is BQLValueItem)
                {
                    vitems[i] = values[i] as BQLValueItem;
                }
                else if (values[i].GetType().IsEnum)
                {
                    vitems[i] = new BQLValueTypeItem((int)values[i]);
                }
                else
                {
                    vitems[i] = new BQLValueTypeItem(values[i]);
                }
            }
            KeyWordInsertValueItem valuesItem = new KeyWordInsertValueItem(vitems, this);

            return(valuesItem);
        }
Exemplo n.º 3
0
        /// <summary>
        /// 解释Between
        /// </summary>
        /// <param name="scope"></param>
        /// <param name="dbType"></param>
        /// <param name="paramName"></param>
        /// <param name="handle"></param>
        /// <param name="table"></param>
        /// <param name="entityInfo"></param>
        /// <returns></returns>
        internal static BQLCondition Between(Scope scope, DbType dbType, string paramName, BQLCondition handle, BQLTableHandle table, EntityInfoHandle entityInfo)
        {
            BQLValueTypeItem cvalue1 = new BQLValueTypeItem(scope.Value1);
            BQLValueTypeItem cvalue2 = null;

            if (scope.Value2 != null)
            {
                cvalue2 = new BQLValueTypeItem(scope.Value2);
            }

            return(table[paramName, dbType].Between(cvalue1, cvalue2));
        }
Exemplo n.º 4
0
        /// <summary>
        /// 解释IN
        /// </summary>
        /// <param name="scope"></param>
        /// <param name="dbType"></param>
        /// <param name="paramName"></param>
        /// <param name="handle"></param>
        /// <param name="table"></param>
        /// <param name="entityInfo"></param>
        /// <returns></returns>
        internal static BQLCondition IN(Scope scope, DbType dbType, string paramName, BQLCondition handle, BQLTableHandle table, EntityInfoHandle entityInfo)
        {
            BQLValueTypeItem cvalue1 = new BQLValueTypeItem(scope.Value1);

            return(table[paramName, dbType].In(scope.Value1 as IEnumerable));
        }