Esempio n. 1
0
        private string BuildWhere <TResult>(string sqlTemplate, Expression <Func <TResult, bool> > expression, out object arguments)
        {
            var queryArgments = LamdaHelper.GetWhere <TResult>(expression);
            //  Dictionary<string, object> dic = new Dictionary<string, object>();
            dynamic args = new ExpandoObject();

            StringBuilder where = new StringBuilder();
            // where.Append("where ");
            // object arguments = new object();
            string template = "{TableAlias}.{ColumnName} {Operator} @{ArgumentName} {Link} ";

            foreach (QueryArgument argument in queryArgments)
            {
                ((IDictionary <string, object>)args)[argument.Name] = argument.Value;
                string temp = template.Replace("{TableAlias}", aliasDic[argument.EntityType]);
                temp = temp.Replace("{ColumnName}", _dialectBuilder.GetColumn(argument.Name));
                temp = temp.Replace("{Operator}", argument.Operator);
                temp = temp.Replace("{ArgumentName}", argument.ArgumentName);
                temp = temp.Replace("{Link}", argument.Link);
                where.Append(temp);
            }
            arguments = args;

            sqlTemplate = sqlTemplate.Replace("{WhereClause}", where.ToString());
            return(sqlTemplate);
        }
Esempio n. 2
0
        public void TestWhere()
        {
            string value = "234" + "%";
            Expression <Func <Category, bool> > exp = n => n.Id.Like(value) && n.Level == 2;
            var result = LamdaHelper.GetWhere <Category>(exp);

            Assert.AreEqual("11", "11");
        }
Esempio n. 3
0
        public void TestWhere_constraint()
        {
            Category cat = new Category()
            {
                Id       = "01",
                Name     = "shp",
                FullName = "222",
                Level    = 1
            };
            Expression <Func <Category, bool> > exp = n => n.Id.Like(cat.Id + "%") && n.Level == cat.Level;
            var result = LamdaHelper.GetWhere <Category>(exp);

            Assert.AreEqual("11", "11");
        }
Esempio n. 4
0
        private string BuildWhere <TEntity>(System.Linq.Expressions.Expression <Func <TEntity, bool> > expression, out object arguments)
        {
            var           queryArgments = LamdaHelper.GetWhere <TEntity>(expression);
            dynamic       args          = new ExpandoObject();
            StringBuilder sql           = new StringBuilder();

            foreach (QueryArgument argument in queryArgments)
            {
                ((IDictionary <string, object>)args)[argument.ArgumentName] = argument.Value;
                sql.AppendFormat("{0} {1} @{2} {3} ", this._dialectBuilder.GetColumn(argument.Name), argument.Operator, argument.ArgumentName, argument.Link);
            }
            arguments = args;

            return(sql.ToString().Trim());
        }