private void Equals_2() { Expression <Func <Student, bool> > exp = it => SqlFunc.Equals(it.Name, it.Name); SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, " ([Name] = [Name]) ", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "a") }, "Equals1 error"); Expression <Func <Student, bool> > exp2 = it => SqlFunc.Equals("a", "a2"); SqlServerExpressionContext expContext2 = new SqlServerExpressionContext(); expContext2.Resolve(exp2, ResolveExpressType.WhereSingle); var value2 = expContext2.Result.GetString(); var pars2 = expContext2.Parameters; base.Check(value2, pars2, " (@MethodConst0 = @MethodConst1) ", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "a"), new SugarParameter("@MethodConst1", "a2") }, "Equals2 error"); }
private void ContainsArray() { string[] array = new string[] { "1", "2" }; Expression <Func <Student, bool> > exp = it => SqlFunc.ContainsArray(array, it.Name); SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, null, " ([Name] IN ('1','2')) ", null, "Contains2 error"); }
private void whereSingle22() { Expression <Func <DataTestInfo2, bool> > exp = it => !it.Bool2.Value; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "NOT ( [Bool2]=1 ) ", new List <SugarParameter>() { }, "whereSingle22"); }
private void HasNumber() { Expression <Func <Student, bool> > exp = it => SqlFunc.HasNumber(it.Id); SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "( [Id]>0 AND [Id] IS NOT NULL )", new List <SugarParameter>() { }, "HasNumber error"); }
private void Length() { Expression <Func <Student, bool> > exp = it => SqlFunc.Length("aaaa") > 1; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(LEN(@MethodConst0) > @Const1 )", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "aaaa"), new SugarParameter("@Const1", 1) }, "Length error"); }
private void IIF4() { Expression <Func <DataTestInfo2, bool> > exp = it => SqlFunc.IIF(true, it.Bool1, it.Bool2) == true; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(( CASE WHEN ( 1 = 1 ) THEN [Bool1] ELSE [Bool2] END ) = @Const0 )", new List <SugarParameter>() { new SugarParameter("@Const0", true) }, "IIF4 error"); }
private void MappingColumn() { Expression <Func <Student, bool> > exp = it => SqlFunc.MappingColumn(it.Id, "Name") == 1; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(Name = @Const1 )", new List <SugarParameter>() { new SugarParameter("@Const1", 1) }, "MappingColumn error"); }
private void Test1() { var ids = new int[] { 1, 2, 3 }; Expression <Func <Student, bool> > exp = it => ids.Contains(it.Id) && !SqlFunc.IsNullOrEmpty(it.Name); SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(([Id] IN ('1','2','3')) AND NOT( [Name]='' OR [Name] IS NULL ))", new List <SugarParameter>() { }, "Test1 error"); }
private void HasValue2(int p = 1) { Expression <Func <Student, bool> > exp = it => it.CreateTime.HasValue; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.IsSingle = false; expContext.Resolve(exp, ResolveExpressType.WhereMultiple); var selectorValue = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check( @"( [it].[CreateTime]<>'' AND [it].[CreateTime] IS NOT NULL )", null, selectorValue, null, "Select.HasValue2 Error"); }
private void Length3() { Expression <Func <Student, bool> > exp = it => it.Name.Length > "a".Length; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(LEN([Name])> @Length1 )", new List <SugarParameter>() { new SugarParameter("@Length1", 1) }, "Length3 error"); }
private void whereSingle26() { var p = DateTime.Now; Expression <Func <DataTestInfo2, bool> > exp = it => it.Bool1 && it.Bool1; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "( ( [Bool1]=1 ) AND ( [Bool1]=1 ) )", new List <SugarParameter>() { }, "whereSingle26"); }
private void whereSingle24() { Expression <Func <DataTestInfo, bool> > exp = it => it.Datetime1 > DateTime.Now.Date; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "( [Datetime1] > @Datetime10 )", new List <SugarParameter>() { new SugarParameter("@Datetime10", DateTime.Now.Date) }, "whereSingle24"); }
private void whereSingle19() { Expression <Func <DataTestInfo2, bool> > exp = it => it.Bool2.Value == false; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "( [Bool2] = @Value0 )", new List <SugarParameter>() { new SugarParameter("@Value0", false) }, "whereSingle19"); }
private void whereSingle17() { Expression <Func <DataTestInfo, bool> > exp = it => true && it.String.Contains("a"); SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(( 1 = 1 ) AND ([String] like '%'+@MethodConst1+'%') )", new List <SugarParameter>() { new SugarParameter("@MethodConst1", "a") }, "whereSingle17"); }
private void ConvetToString() { Expression <Func <Student, bool> > exp = it => Convert.ToString(it.Id) == "a"; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(CAST([Id] AS NVARCHAR(MAX)) = @Const0 )", new List <SugarParameter>() { new SugarParameter("@Const0", "a") }, "ConvetToString error"); }
private void IIF5() { Expression <Func <DataTestInfo, bool> > exp = it => SqlFunc.IIF(true, Convert.ToBoolean(it.Datetime1), SqlFunc.ToBool(it.Datetime1)) == false; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(( CASE WHEN ( 1 = 1 ) THEN CAST([Datetime1] AS BIT) ELSE CAST([Datetime1] AS BIT) END ) = @Const0 )", new List <SugarParameter>() { new SugarParameter("@Const0", false) }, "IIF5 error"); }
private void StringIsNullOrEmpty() { Expression <Func <Student, bool> > exp = it => it.Id > 2 || SqlFunc.IsNullOrEmpty(it.Id);; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(( [Id] > @Id0 ) OR ( [Id]='' OR [Id] IS NULL ))", new List <SugarParameter>() { new SugarParameter("@Id0", 2) }, "StringIsNullOrEmpty error"); }
private void Trim() { Expression <Func <Student, bool> > exp = it => SqlFunc.Trim(" a") == it.Name; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "((rtrim(ltrim(@MethodConst0))) = [Name] )", new List <SugarParameter>() { new SugarParameter("@MethodConst0", " a") }, "Trim error"); }
private void ToLower() { Expression <Func <Student, bool> > exp = it => "a" == SqlFunc.ToLower(it.Id); SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "( @Const0 = (LOWER([Id])) )", new List <SugarParameter>() { new SugarParameter("@Const0", "a") }, "ToLower error"); }
private void Contains2(string name = "a") { Expression <Func <Student, bool> > exp = it => SqlFunc.Contains(it.Name, name); SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, " ([Name] like '%'+@MethodConst0+'%') ", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "a") }, "Contains2 error"); }
private void Between() { Expression <Func <Student, bool> > exp = it => SqlFunc.Between(it.Name, 1, 2); SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, " ([Name] BETWEEN @MethodConst0 AND @MethodConst1) ", new List <SugarParameter>() { new SugarParameter("@MethodConst0", 1), new SugarParameter("@MethodConst1", 2), }, "Between error"); }
private void ExtendDate() { var x2 = DateTime.Now; Expression <Func <Student, bool> > exp = it => Convert.ToDateTime("2015-1-1") == x2; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(CAST(@MethodConst0 AS DATETIME) = @Const1 )", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "2015-1-1"), new SugarParameter("@Const1", x2) }, "ExtendDate error"); }
private void ExtendSubstring() { var x2 = Guid.NewGuid(); Expression <Func <Student, bool> > exp = it => "aaaa".Substring(0, 2) == "a"; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(SUBSTRING(@MethodConst0,1 + @MethodConst1,@MethodConst2) = @Const3 )", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "aaaa"), new SugarParameter("@MethodConst1", 0), new SugarParameter("@MethodConst2", 2), new SugarParameter("@Const3", "a") }, "Substring error"); }
private void StringIsNullOrEmpty5() { WhereConst.name = "xx"; Expression <Func <Student, bool> > exp = it => !SqlFunc.IsNullOrEmpty(WhereConst.name);; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "NOT( @MethodConst0='' OR @MethodConst0 IS NULL )", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "xx") }, "StringIsNullOrEmpty5 error"); }
private void StringIsNullOrEmpty2() { Expression <Func <Student, bool> > exp = it => 2 == it.Id || SqlFunc.IsNullOrEmpty(true);; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(( @Id0 = [Id] ) OR ( @MethodConst1='' OR @MethodConst1 IS NULL ))", new List <SugarParameter>() { new SugarParameter("@MethodConst1", true), new SugarParameter("@Id0", 2) }, "StringIsNullOrEmpty2 error"); }
private void ToDouble() { var x2 = Guid.NewGuid(); Expression <Func <Student, bool> > exp = it => SqlFunc.ToDouble("2") == 2; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(CAST(@MethodConst0 AS FLOAT) = @Const1 )", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "2"), new SugarParameter("@Const1", (Double)2) }, "ToDouble error"); }
private void ToGuid() { var x2 = Guid.NewGuid(); Expression <Func <Student, bool> > exp = it => SqlFunc.ToGuid("A94027A3-476E-478D-8228-F4054394B874") == x2; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(CAST(@MethodConst0 AS UNIQUEIDENTIFIER) = @Const1 )", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "A94027A3-476E-478D-8228-F4054394B874"), new SugarParameter("@Const1", x2) }, "ToGuid error"); }
private void DateIsSameByDay() { var x2 = DateTime.Now; Expression <Func <Student, bool> > exp = it => SqlFunc.DateIsSame(x2, x2); SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(DATEDIFF(day,@MethodConst0,@MethodConst1)=0) ", new List <SugarParameter>() { new SugarParameter("@MethodConst0", x2), new SugarParameter("@MethodConst1", x2) }, "DateIsSameDay error"); }
private void DateValue() { var x2 = DateTime.Now; Expression <Func <Student, bool> > exp = it => SqlFunc.DateValue(x2, DateType.Year) == 1; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, " ((@MethodConst1(@MethodConst0)) = @Const2 ) ", new List <SugarParameter>() { new SugarParameter("@MethodConst0", x2), new SugarParameter("@MethodConst1", DateType.Year), new SugarParameter("@Const2", 1) }, "DateValue error"); }
private void ToInt32() { var x2 = DateTime.Now; Expression <Func <Student, bool> > exp = it => SqlFunc.ToInt32("3") == 1; SqlServerExpressionContext expContext = new SqlServerExpressionContext(); expContext.Resolve(exp, ResolveExpressType.WhereSingle); var value = expContext.Result.GetString(); var pars = expContext.Parameters; base.Check(value, pars, "(CAST(@MethodConst0 AS INT) = @Const1 )", new List <SugarParameter>() { new SugarParameter("@MethodConst0", "3"), new SugarParameter("@Const1", 1) }, "ToInt32 error"); }