public void ToSqlTextTest03() { string expected = string.Empty; string actual = string.Empty; SQLWhereTextBuilder target = new SQLWhereTextBuilder(); target.Set("aaa", SQLText.CompareOperation.Equal, DbType.Boolean, true); SQLWhereTextBuilder target1 = new SQLWhereTextBuilder(); target1.Set("bbb", SQLText.CompareOperation.Equal, DbType.Double, 222); SQLWhereTextBuilder target2 = new SQLWhereTextBuilder(); target2.Set("ccc", SQLText.CompareOperation.Equal, DbType.DateTime, DateTime.Parse("1999-9-9 9:9:9")); SQLWhereTextBuilder target3 = new SQLWhereTextBuilder(); target3.Set("ddd", SQLText.CompareOperation.Equal, DbType.String, "DDD"); target.Add(SQLText.LogicOperation.And, target1); target.Add(SQLText.LogicOperation.Or, target2); target.Add(SQLText.LogicOperation.Or, target3); expected = "(aaa = True AND bbb = 222 OR ccc = '1999-09-09 09:09:09.000' OR ddd = 'DDD')"; actual = target.ToSqlText(); Assert.AreEqual(expected, actual); }
internal static void Do() { SQLWhereTextBuilder ctb = new SQLWhereTextBuilder(); SQLWhereTextBuilder b1 = new SQLWhereTextBuilder(); b1.Set("name", SQLText.CompareOperation.Equal, DbType.String, "%kkp%"); SQLWhereTextBuilder b2 = new SQLWhereTextBuilder(); b2.Set("nickName", SQLText.CompareOperation.Like, DbType.String, "%'kkp'%"); SQLWhereTextBuilder b3 = new SQLWhereTextBuilder(); b3.Set("age", SQLText.CompareOperation.Equal, DbType.Date, DateTime.Now); SQLWhereTextBuilder b4 = new SQLWhereTextBuilder(); b4.Set("signTime", SQLText.CompareOperation.Equal, DbType.DateTime, DateTime.Now); SQLWhereTextBuilder b5 = new SQLWhereTextBuilder(); b5.Set("count", SQLText.CompareOperation.MoreThan, DbType.Int32, 88888); SQLWhereTextBuilder b51 = new SQLWhereTextBuilder(); b51.Set("length", SQLText.CompareOperation.MoreThan, DbType.Decimal, 88888); SQLWhereTextBuilder b52 = new SQLWhereTextBuilder(); b52.Set("price", SQLText.CompareOperation.MoreThan, DbType.Double, 888.88); b1.Add(SQLText.LogicOperation.And, b2); b2.Add(SQLText.LogicOperation.And, b3); b3.Add(SQLText.LogicOperation.And, b4); b4.Add(SQLText.LogicOperation.And, b5); b5.Add(SQLText.LogicOperation.And, b51); b5.Add(SQLText.LogicOperation.And, b52); ctb.Add(SQLText.LogicOperation.Or, b1); Console.WriteLine(ctb.ToSqlText()); Console.WriteLine(); Console.WriteLine(ctb.ToSqlTempletText()); Console.WriteLine(); DbParameter[] sqls = ctb.GetDbParameters(); foreach (var item in sqls) { Console.WriteLine(item.ToString()); } Console.WriteLine("............................"); SQLFieldTextBuilder ftb = new SQLFieldTextBuilder(); ftb.Set("a", "b", "c", "d"); Console.WriteLine(ftb.ToSqlText()); ftb = new SQLFieldTextBuilder(); ftb.Set( new Pair <string, string>("aaa", "AAA"), new Pair <string, string>("bbb", "BBB"), new Pair <string, string>("ccc", "CCC") ); ftb.Set( new Pair <string, string>("ddd", "DDD"), new Pair <string, string>("eee", "EEE") ); Console.WriteLine(ftb.ToSqlText()); }
internal static void Do() { SQLWhereTextBuilder ctb = new SQLWhereTextBuilder(); SQLWhereTextBuilder b1 = new SQLWhereTextBuilder(); b1.Set("name", SQLText.CompareOperation.Equal, DbType.String, "%kkp%"); SQLWhereTextBuilder b2 = new SQLWhereTextBuilder(); b2.Set("nickName", SQLText.CompareOperation.Like, DbType.String, "%'kkp'%"); SQLWhereTextBuilder b3 = new SQLWhereTextBuilder(); b3.Set("age", SQLText.CompareOperation.Equal, DbType.Date, DateTime.Now); SQLWhereTextBuilder b4 = new SQLWhereTextBuilder(); b4.Set("signTime", SQLText.CompareOperation.Equal, DbType.DateTime, DateTime.Now); SQLWhereTextBuilder b5 = new SQLWhereTextBuilder(); b5.Set("count", SQLText.CompareOperation.MoreThan, DbType.Int32, 88888); SQLWhereTextBuilder b51 = new SQLWhereTextBuilder(); b51.Set("length", SQLText.CompareOperation.MoreThan, DbType.Decimal, 88888); SQLWhereTextBuilder b52 = new SQLWhereTextBuilder(); b52.Set("price", SQLText.CompareOperation.MoreThan, DbType.Double, 888.88); b1.Add(SQLText.LogicOperation.And, b2); b2.Add(SQLText.LogicOperation.And, b3); b3.Add(SQLText.LogicOperation.And, b4); b4.Add(SQLText.LogicOperation.And, b5); b5.Add(SQLText.LogicOperation.And, b51); b5.Add(SQLText.LogicOperation.And, b52); ctb.Add(SQLText.LogicOperation.Or, b1); Console.WriteLine(ctb.ToSqlText()); Console.WriteLine(); Console.WriteLine(ctb.ToSqlTempletText()); Console.WriteLine(); DbParameter[] sqls = ctb.GetDbParameters(); foreach (var item in sqls) { Console.WriteLine(item.ToString()); } Console.WriteLine("............................"); SQLFieldTextBuilder ftb = new SQLFieldTextBuilder(); ftb.Set("a", "b", "c", "d"); Console.WriteLine(ftb.ToSqlText()); ftb = new SQLFieldTextBuilder(); ftb.Set( new Pair<string, string>("aaa", "AAA"), new Pair<string, string>("bbb", "BBB"), new Pair<string, string>("ccc", "CCC") ); ftb.Set( new Pair<string, string>("ddd", "DDD"), new Pair<string, string>("eee", "EEE") ); Console.WriteLine(ftb.ToSqlText()); }