/// <summary>
        /// 处理SQL语句, 关于简写
        /// </summary>
        /// <param name="s">SQL语句</param>
        /// <returns></returns>
        public static string DealSQL <ObjectType>(string s)
        {
            //s = " =Adminname and =Pwd and <>SortId1 or %Sex or -Sex% or %Sex% ";
            s = " " + s + " ";
            Regex           _R  = new Regex(@"\s(=|<>|%|-)([_a-zA-Z][_a-zA-Z0-9]*)%?\s");
            MatchCollection _mc = _R.Matches(s);

            foreach (Match m in _mc)
            {
                string c  = m.Value;
                string a1 = m.Result("$1");
                string a2 = m.Result("$2");
                switch (a1)
                {
                case "=":
                    s = s.Replace(c, " " + a2 + a1 + "@" + a2 + " ");
                    break;

                case "<>":
                    s = s.Replace(c, " " + a2 + a1 + "@" + a2 + " ");
                    break;

                case "%":
                    if (c.LastIndexOf("%") > 1)
                    {
                        s = s.Replace(c, " " + a2 + " like " + "'%' + @" + a2 + " + '%' ");
                    }
                    else
                    {
                        s = s.Replace(c, " " + a2 + " like " + "'%' + @" + a2 + " ");
                    }
                    break;

                case "-":
                    if (c.LastIndexOf("%") > 1)
                    {
                        s = s.Replace(c, " " + a2 + " like " + "@" + a2 + " + '%' ");
                    }
                    break;
                }
            }

            //加入分站条件
            s = s.Trim();
            string SubSite = Common.Base.CookieClass.getCookie("SubSite");

            if (!string.IsNullOrEmpty(SubSite) && SubSite.ToInt32() != 0 && IsOpenSubSite)
            {
                TableInfo tableInfo = AttributeHelper.GetInfo <ObjectType>();
                foreach (ColumnAttribute ca in tableInfo.Columns)
                {
                    if (ca.Name.ToLower() == "SiteCityID".ToLower())
                    {
                        if (string.IsNullOrEmpty(s))
                        {
                            s = " 1=1 ";
                        }
                        s += " and SiteCityID=" + SubSite.ToInt32().ToString() + " ";
                        break;
                    }
                }
            }
            return(s.Trim());
        }