public HttpResponseMessage Get(SearchCondition sc)
 {
     string json = "[]";
     switch (sc.pattern)
     {
         case "0":
             TXLDal.SearchCondition tsc = new TXLDal.SearchCondition();
             tsc.keyword = sc.keyword;
             tsc.size = sc.size;
             tsc.start = sc.start;
             tsc.status = sc.status;
             tsc.d = sc.d;
             tsc.e = sc.e;
             tsc.dm = sc.dm;
             tsc.i = sc.i;
             tsc.p = sc.p;
             tsc.r = sc.r;
             tsc.eid = sc.eid;
             tsc.pn = sc.pn;
             tsc.depid = sc.depid;
             json = _dal.Get(tsc).Replace("\r", string.Empty).Replace("\n", string.Empty);
             break;
         //case "1":
         //    json = _dal.Get(sc.id).Replace("\r", string.Empty).Replace("\n", string.Empty);
         //    break;
         default:
             json = _dal.Get(sc.keyword, sc.field, sc.start, sc.size).Replace("\r", string.Empty).Replace("\n", string.Empty);
             break;
     }
     HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(json, Encoding.GetEncoding("UTF-8"), "application/json") };
     return result;
 }

 public int GetCount(SearchCondition sc)
 {
     if (!string.IsNullOrEmpty(sc.flag))
     {
         switch (sc.flag)
         {
             case "member":
                 return GetCountByM(sc);
             case "member_track":
                 return GetCountByTrack(sc);
             case "member_contact":
                 return GetCountByContact(sc);
             case "member_introducer":
                 return GetCountByIntroducer(sc);
             case "es_fina_pay":
                 return GetCountByEFP(sc);
             default:
                 return -1;
         }
     }
     else
     {
         return -1;
     }
 }

        private static SelectStatement CreateSelectFromLevelQuery(IEntity rootEntity, DbRelation recursiveRelation, SearchCondition leafFilter, int level, LevelQuerySelectList itemsToSelect)
        {
            if (level > Settings.GenericHierarchicalQueryExecutorMaxLevel)
                throw new InvalidOperationException(string.Format(CultureInfo.InvariantCulture, Messages.GenericHierarchicalQueryExecutor_MaxLevelReachedFormat, Settings.GenericHierarchicalQueryExecutorMaxLevel));

            // Target level table must be child table because that is the table which is used in leafFilter.
            // If leaf filter is used then the we must ensure that proper table name is used for target table.
            IDbTable targetLevelTable;
            if (leafFilter != null && !leafFilter.IsEmpty)
                targetLevelTable = recursiveRelation.Child;
            else
                targetLevelTable = rootEntity.Table.Clone("L" + level);

            SelectStatement selectFromTargetLevel = new SelectStatement(targetLevelTable);
            CreateSelectListItems(itemsToSelect, targetLevelTable, selectFromTargetLevel);

            if (leafFilter != null && !leafFilter.IsEmpty)
                selectFromTargetLevel.Where.Add(leafFilter);

            IDbTable prevLevel = targetLevelTable;
            for (int parentLevel = level - 1; parentLevel >= 0; parentLevel--)
            {
                IDbTable nextLevel = rootEntity.Table.Clone("L" + parentLevel);
                DbRelation joinLevels = JoinLevelsInSubTree(prevLevel, nextLevel, recursiveRelation);
                selectFromTargetLevel.Relations.Add(joinLevels, false, false);
                prevLevel = nextLevel;
            }

            IDbTable subTreeRoot = prevLevel;
            foreach (IDbColumn rootPkPart in subTreeRoot.PrimaryKey)
                selectFromTargetLevel.Where.Add(rootPkPart, rootEntity.GetField(rootPkPart));

            return selectFromTargetLevel;
        }

		public void Test_Empty()
		{
			var sc = new SearchCondition<object>();
			Assert.AreEqual(0, sc.Values.Length);
			Assert.AreEqual(SearchConditionTest.None, sc.Test);
			Assert.IsTrue(sc.IsEmpty);
		}

 public HttpResponseMessage GetCount(SearchCondition sc)
 {
     int count = 0;
     switch (sc.pattern)
     {
         case "0":
             TXLDal.SearchCondition tsc = new TXLDal.SearchCondition();
             tsc.keyword = sc.keyword;
             tsc.size = sc.size;
             tsc.start = sc.start;
             tsc.status = sc.status;
             tsc.d = sc.d;
             tsc.dm = sc.dm;
             tsc.e = sc.e;
             tsc.i = sc.i;
             tsc.p = sc.p;
             tsc.r = sc.r;
             tsc.eid = sc.eid;
             tsc.pn = sc.pn;
             tsc.depid = sc.depid;
             count = _dal.GetCount(tsc);
             break;
         //case "1":
         //    count = _dal.GetCount(sc.id);
         //    break;
         default:
             count = _dal.GetCount(sc.keyword, sc.field, sc.start, sc.size) ;
             break;
     }
     HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(count.ToString(), Encoding.GetEncoding("UTF-8"), "application/json") };
     return result;
 }

 public HttpResponseMessage getme(SearchCondition model)
 {
     int em = 0;
     DAL.Implement.MemberDal.SearchCondition sc = new MemberDal.SearchCondition();
     sc.address = model.address;
     sc.aftersales = model.aftersales;
     sc.city = model.city;
     sc.classx = model.classx;
     sc.country = model.country;
     sc.field = model.field;
     sc.flag = model.flag;
     sc.keyword = model.keyword;
     sc.memo = model.memo;
     sc.province = model.province;
     sc.size = model.size < 30 ? model.size : 30;
     sc.start = model.start;
     sc.tracktype = model.tracktype;
     string[] kstr = model.keyword.ToString().Split(',');
     sc.keywords = kstr;
     string str = "[]";
     if (ValidateSign(Regex.Replace(model.keyword, ",", string.Empty), model.flag, model.field, Convert.ToDateTime(model.timestamp), model.sign))
     {
         str = _dal.GetList(sc, out em).Replace("\r", string.Empty).Replace("\n", string.Empty);
     }
     //str = _dal.GetList(sc, out em).Replace("\r", string.Empty).Replace("\n", string.Empty);
     //string str = _dal.GetList(sc, out em);
     HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(str, Encoding.GetEncoding("UTF-8"), "application/json") };
     return result;
 }

        public override SearchCondition GetParsingTree()
        {
            // *** TODO Value.AddLeadingWhitespace();

            var sc = new SearchCondition();
            sc.Stack.AddLast(Value);
            return sc;
        }

 private static void AppendWhere(SearchCondition where, DbmsType dbms, StringBuilder output, DbParameterCollection parameters)
 {
     bool hasFilter = (where != null) && !where.IsEmpty;
     if (hasFilter)
     {
         output.Append(" WHERE ");
         where.Render(dbms, output, parameters);
     }
 }

        public static WhereClause Create(SearchCondition sc)
        {
            var wh = new WhereClause();

            wh.Stack.AddLast(Keyword.Create("WHERE"));
            wh.Stack.AddLast(Whitespace.Create());
            wh.Stack.AddLast(sc);

            return wh;
        }

        public static SearchConditionBrackets Create(SearchCondition sc)
        {
            var scb = new SearchConditionBrackets();

            scb.Stack.AddLast(new BracketOpen());
            scb.Stack.AddLast(sc);
            scb.Stack.AddLast(new BracketClose());

            return scb;
        }

        public static SearchCriteria AddCriteria(this SearchCriteria searchCriteria, string field, SearchCondition condition, string comparisonValue, bool? isNumeric = null)
        {
            if (searchCriteria.Criteria == null)
            {
                searchCriteria.Criteria = new List<Criteria>();
            }

            searchCriteria.Criteria.Add(new Criteria { ComparisonValue = comparisonValue, Condition = condition, Field = field, IsNumeric = isNumeric});

            return searchCriteria;
        }

    public DataTable getDataTable(PaginationObj paginationObj, int schoolId, SearchCondition condition)
    {
        string sql = "select pr.id,pr.student_id,old_table.name,old_table.grade,old_table.sex, "
                + @" pr.red,pr.blue,pr.green,pr.yellow,rc.cn_name,pr.update_at,pr.print_count "
                + @" from pts_result pr "
                + @" inner join inside_student old_table on pr.student_id = old_table.id "
                + @" inner join result_const rc on pr.color = rc.color "
                + @" where old_table.school = " + schoolId
                + SearchCondictionStr.getString(condition);

        return BaseDao.getTableInfo(sql);
    }

    public static string getString(SearchCondition condition)
    {
        string temp = " ";
        string upadateAt = "";

        if (!String.IsNullOrWhiteSpace(condition.State)) {

            string state = " and old_table.state=" + condition.State;
            temp += state;
        }

        if (!String.IsNullOrWhiteSpace(condition.Name)) {

            string name = " and old_table.name like '%" + condition.Name + "%' ";
            temp += name;
        }

        if (!String.IsNullOrWhiteSpace(condition.Grade))
        {

            string grade = " and old_table.grade= " + condition.Grade;
            temp += grade;
        }

        if (!String.IsNullOrWhiteSpace(condition.Sex))
        {

            string sex = " and old_table.sex=" + condition.Sex;
            temp += sex;
        }

        if (!String.IsNullOrWhiteSpace(condition.TimeBegin) && !String.IsNullOrWhiteSpace(condition.TimeEnd))
        {
            upadateAt = " and CONVERT(VARCHAR(10),old_table.update_at,120) between '" + condition.TimeBegin + "' and '" + condition.TimeEnd + "' ";
        }
        else if (!String.IsNullOrWhiteSpace(condition.TimeBegin))
        {
            upadateAt = " and CONVERT(VARCHAR(10),old_table.update_at,120)='" + condition.TimeBegin + "' ";
        }
        else if (!String.IsNullOrWhiteSpace(condition.TimeEnd))
        {
            upadateAt = " and CONVERT(VARCHAR(10),old_table.update_at,120)='" + condition.TimeEnd + "' ";
        }
        else
        {

        }

        temp += upadateAt;

        return temp;
    }

        public void AppendCondition(SearchCondition sc, string opstring)
        {
            var cond = this.FindDescendant<SearchCondition>();
            this.Stack.Remove(cond);

            SearchConditionBrackets br1 = SearchConditionBrackets.Create(sc);
            SearchConditionBrackets br2 = SearchConditionBrackets.Create(cond);

            var op = LogicalOperator.Create(opstring);
            cond = SearchCondition.Create(br1, op, SearchCondition.Create(false, br2));

            this.Stack.AddLast(cond);
        }

        public ObjectSearchResults FindObjectsByObjectType(string objectType)
        {
            var vault = this.VaultService.Vault.Value;

              int objectTypeId = GetObjectTypeId(objectType);

              /* find all files with the specified object type */
              var searchCondition = new SearchCondition();
              searchCondition.ConditionType = MFConditionType.MFConditionTypeEqual;
              searchCondition.Expression.DataStatusValueType = MFStatusType.MFStatusTypeObjectTypeID;
              searchCondition.TypedValue.SetValue(MFDataType.MFDatatypeLookup, objectTypeId);

              return Find(searchCondition);
        }

        public ObjectSearchResults FindObjectsByClass(string className)
        {
            var vault = this.VaultService.Vault.Value;

              int classId = GetClassId(className);

              /* find all files with the specified class */
              var searchCondition = new SearchCondition();
              searchCondition.ConditionType = MFConditionType.MFConditionTypeEqual;
              searchCondition.Expression.DataPropertyValuePropertyDef = (int)MFBuiltInPropertyDef.MFBuiltInPropertyDefClass;
              searchCondition.TypedValue.SetValue(MFDataType.MFDatatypeLookup, classId);

              return Find(searchCondition);
        }

 public static string buildPaginationString(string tableName, PaginationObj paginationObj, int schoolId, SearchCondition condition)
 {
     return "select * from "
         + " (select old_table.*, ROW_NUMBER() over(order by update_at) as row_num from "
         + tableName
         + " old_table "
         + " where old_table.school="
         + schoolId
         + SearchCondictionStr.getString(condition)
         + " ) new_table "
         + " where new_table.row_num between "
         + ((paginationObj.PageNum - 1) * paginationObj.NumPerPage + 1)
         + " and "
         + paginationObj.PageNum * paginationObj.NumPerPage;
 }

		protected void DoContinue(object sender, EventArgs e)
		{
			this.TimeCondition = new SearchCondition() { TimeFrom = this.timeFrom.Value, TimeTo = this.timeTo.Value };
			this.views.ActiveViewIndex = 1;
			WhereSqlClauseBuilder where = ConditionMapping.GetWhereSqlClauseBuilder(this.TimeCondition);

			string[] ids = TimeRangeDataSource.QueryGuidsByCondition(where);

			this.postVal.Value = MCS.Web.Library.Script.JSONSerializerExecute.Serialize(ids);

			this.lblCount.InnerText = ids.Length.ToString("#,##0");

			this.btnRecalc.Visible = ids.Length > 0;

			//this.grid.InitialData = new TimeRangeDataSource().Query(0, 0, builder, "CREATE_TIME", ref total);
		}

 public static string GetString(SearchCondition aSearchCondition)
 {
     string lRet = "";
     switch (aSearchCondition)
     {
         case SearchCondition.KNULL:
             lRet = "";
             break;
         case SearchCondition.AND:
             lRet = "与";
             break;
         case SearchCondition.OR:
             lRet = "或";
             break;
     }
     return lRet;
 }

		public void Test_Clone()
		{
			var sc = new SearchCondition<object>();
			var x = new object();
			var y = new object();

			sc.Between(x, y);
			sc.SortDesc(3);

			var copy = (SearchCondition<object>)sc.Clone();

			Assert.AreEqual(sc.Test, copy.Test);
			Assert.AreEqual(sc.Values.Length, copy.Values.Length);
			Assert.AreEqual(sc.Values[0], copy.Values[0]);
			Assert.AreEqual(sc.Values[1], copy.Values[1]);
			Assert.AreEqual(sc.SortDirection, copy.SortDirection);
			Assert.AreEqual(sc.SortPosition, copy.SortPosition);
			Assert.IsFalse(ReferenceEquals(sc.Values, copy.Values));
		}