Beispiel #1
0
        public void SqlBuilderSample(FeiniuBus.DynamicQuery dynamicQuery, ISelectBuilder selectBuilder)
        {
            var sb       = new StringBuilder();
            var mappings = new SqlFieldMappings();

            mappings.Map("Guest", "t1.Guest")
            .Map("Address", "t1.Address")
            .Map("Disabled", "t1.Disabled")
            .Map("Amout", "t1.Amout")
            .Map("Price", "t1.Price")
            .Map("Drink", "t1.Drink")
            .Map("Count", "t1.Count")
            .Map("Total", "t1.Total")
            .Map("Url", "t1.Url");
            selectBuilder.Mapping(mappings);
            selectBuilder.Where(dynamicQuery.ParamGroup);

            var whereClause   = selectBuilder.BuildWhere();
            var orderbyClause = selectBuilder.OrderBy(dynamicQuery.Order);

            System.Console.WriteLine(whereClause);
            System.Console.WriteLine(orderbyClause);
        }