添加搜索Text （lower + like）- AddIQueryItemSearchText

2017-02-19 11:04:03 访问(1613) 赞(0) 踩(0)



        /// <summary>
        /// 添加搜索Text （lower + like）- AddIQueryItemSearchText
        /// </summary>
        /// <param name="_info"></param>
        /// <param name="isLower"></param>
        /// <param name="isLike"></param>
        /// <param name="theValue"></param>
        public void AddIQueryItemSearchText
            (
                EntityFieldInfo _info,
                bool isLower,
                bool isLike,
                string theValue
            )
        {
            if (theValue == null || theValue.Length == 0)
                return;

            if (isLower)
            {
                if (isLike)
                {
                    m_ListIQueryItem.Add
                        (
                            new DataColumnQueryItem
                                (
                                    _info,
                                    SlowX.Core.CoreClasses.DataColumnQueryAssist.dataColumnQueryAssistEmStringCaseLower,
                                    SlowX.Core.Enums.SqlLink.EmSqlLink._Like_,
                                    theValue.ToLower() 
                                )
                        );
                }
                else
                {
                    m_ListIQueryItem.Add
                        (
                            new DataColumnQueryItem
                                (
                                    _info,
                                    SlowX.Core.CoreClasses.DataColumnQueryAssist.dataColumnQueryAssistEmStringCaseLower,
                                    SlowX.Core.Enums.SqlLink.EmSqlLink.Equal,
                                    theValue.ToLower() 
                                )
                        );
                }
            }
            else
            {
                if (isLike)
                {
                    m_ListIQueryItem.Add
                        (
                            new DataColumnQueryItem
                                (
                                    _info,
                                    SlowX.Core.Enums.SqlLink.EmSqlLink._Like_,
                                    theValue
                                )
                        );
                }
                else
                {
                    m_ListIQueryItem.Add
                        (
                            new DataColumnQueryItem
                                (
                                    _info,
                                    SlowX.Core.Enums.SqlLink.EmSqlLink.Equal,
                                    theValue
                                )
                        );
                }
            }
        }