예제 #1
0
        protected void ParseSelectQuery()
        {
            string w = "", o = "", f = "", tb, s;

            tb        = FormatFieldName(Form["tb"]);
            TableName = tb;
            f         = ParseFields();
            ClauseBuilder cw = new ClauseBuilder(new string[] { " and ", " and ", " or " }, new string[] { "", "", "" });
            Node          nw = ParseClause("wheres");

            cw.BuildClause(nw, new string[] { "", "", "" }, 0);
            if (!string.IsNullOrEmpty(cw.MergeRlt))
            {
                w += " where " + cw.MergeRlt;
            }
            ClauseBuilder co = new ClauseBuilder(new string[] { " , ", " " }, new string[] { "", "" });
            Node          nd = ParseClause("orders");

            co.BuildClause(nd, new string[] { "", "" }, 0);
            if (!string.IsNullOrEmpty(co.MergeRlt))
            {
                o += " order by " + co.MergeRlt;
            }
            s   = " select " + f + " from " + tb + w + o;
            Sql = s;
        }
예제 #2
0
파일: HttpExecute.cs 프로젝트: mind0n/hive
		protected void ParseSelectQuery()
		{
			string w = "", o = "", f = "", tb, s;
			tb = FormatFieldName(Form["tb"]);
			TableName = tb;
			f = ParseFields();
			ClauseBuilder cw = new ClauseBuilder(new string[] { " and ", " and ", " or " }, new string[] { "", "", "" });
			Node nw = ParseClause("wheres");
			cw.BuildClause(nw, new string[] { "", "", "" }, 0);
			if (!string.IsNullOrEmpty(cw.MergeRlt))
			{
				w += " where " + cw.MergeRlt;
			}
			ClauseBuilder co = new ClauseBuilder(new string[] { " , ", " " }, new string[] { "", "" });
			Node nd = ParseClause("orders");
			co.BuildClause(nd, new string[] { "", "" }, 0);
			if (!string.IsNullOrEmpty(co.MergeRlt))
			{
				o += " order by " + co.MergeRlt;
			}
			s = " select " + f + " from " + tb + w + o;
			Sql = s;
		}