C# (CSharp) Zephyr.Core DefaultSqlMaker Examples

Example #1

 public void RegistSQL(Dictionary <string, ISqlMaker> dict)
 {
     dict["DtGreaterEqual"] = new DefaultSqlMaker("datediff('{p0}',{c}) <=0");
     dict["DtLessEqual"]    = new DefaultSqlMaker("datediff('{p0}',{c}) >=0");
     dict["DateRange"]      = new DateRangeSqlMaker('到', "datediff('{p0}',{c}) <=0", "datediff('{p0}',{c}) >=0");
     dict["MapChild"]       = new DefaultSqlMaker("{c} in (select {c} from {p1} where FIND_IN_SET({p2}, GetChild('{p3}','{p0}')))");
 }

Example #2

File: MySql.cs Project: uwitec/web-mvc-logistics

        public void RegistSQL(Dictionary<string, ISqlMaker> dict)
        {
            dict["DtGreaterEqual"] = new DefaultSqlMaker("datediff('{p0}',{c}) <=0");
            dict["DtLessEqual"] = new DefaultSqlMaker("datediff('{p0}',{c}) >=0");
            dict["DateRange"] = new DateRangeSqlMaker('到', "datediff('{p0}',{c}) <=0", "datediff('{p0}',{c}) >=0");
            dict["MapChild"] = new DefaultSqlMaker("{c} in (select {c} from {p1} where FIND_IN_SET({p2}, GetChild('{p3}','{p0}')))");

        }

Example #3

File: SqlServer.cs Project: uwitec/web-mvc-logistics

 public void RegistSQL(Dictionary<string, ISqlMaker> dict)
 {
     dict["DtGreaterEqual"] = new DefaultSqlMaker("datediff(day,'{p0}',{c}) >=0");
     dict["DtLessEqual"] = new DefaultSqlMaker("datediff(day,'{p0}',{c}) <=0");
     dict["DateRange"] = new DateRangeSqlMaker('到', "datediff(day,'{p0}',{c}) >=0", "datediff(day,'{p0}',{c}) <=0");
     dict["Child"] = new DefaultSqlMaker("{c} in (select ID from [dbo].[GetChild]('{p0}','{p1}'))");
     dict["MapChild"] = new DefaultSqlMaker("{c} in (select {c} from {p1} where {p2} in (select ID from [dbo].[GetChild]('{p3}','{p0}')))");
     dict["StartWithPY"] = new DefaultSqlMaker("{c} like '{p0}%' or [dbo].[fun_getPY]({c}) like N'{p0}%'");
 }

Example #4

 public void RegistSQL(Dictionary <string, ISqlMaker> dict)
 {
     dict["DtGreaterEqual"] = new DefaultSqlMaker("datediff(day,'{p0}',{c}) >=0");
     dict["DtLessEqual"]    = new DefaultSqlMaker("datediff(day,'{p0}',{c}) <=0");
     dict["DateRange"]      = new DateRangeSqlMaker('到', "datediff(day,'{p0}',{c}) >=0", "datediff(day,'{p0}',{c}) <=0");
     dict["Child"]          = new DefaultSqlMaker("{c} in (select ID from [dbo].[GetChild]('{p0}','{p1}'))");
     dict["MapChild"]       = new DefaultSqlMaker("{c} in (select {c} from {p1} where {p2} in (select ID from [dbo].[GetChild]('{p3}','{p0}')))");
     dict["StartWithPY"]    = new DefaultSqlMaker("{c} like '{p0}%' or [dbo].[fun_getPY]({c}) like N'{p0}%'");
 }

Example #5

File: Default.cs Project: uwitec/web-mvc-logistics

 public void RegistSQL(Dictionary<string, ISqlMaker> dict)
 {
     dict["Equal"] = new DefaultSqlMaker("{c}='{p0}'");
     dict["NotEqual"] = new DefaultSqlMaker("{c}<>'{p0}'");
     dict["Greater"] = new DefaultSqlMaker("{c}>'{p0}'");
     dict["GreaterEqual"] = new DefaultSqlMaker("{c}>='{p0}'");
     dict["Less"] = new DefaultSqlMaker("{c}<'{p0}'");
     dict["LessEqual"] = new DefaultSqlMaker("{c}<='{p0}'");
     dict["In"] = new DefaultSqlMaker("{c} in ({p0})");
     dict["Like"] = new DefaultSqlMaker("{c} like '%{p0}%'");
     dict["StartWith"] = new DefaultSqlMaker("{c} like '{p0}%'");
     dict["EndWith"] = new DefaultSqlMaker("{c} like '%{p0}'");
     dict["Between"] = new DefaultSqlMaker("{c} between '{p0}' and '{p1}'");
     dict["Map"] = new DefaultSqlMaker("{c} in (select {p0} from {p1} where {p0}='{p2}'");
     dict["Sql"] = new StringFormatSqlMaker();
 }

Example #6

 public void RegistSQL(Dictionary <string, ISqlMaker> dict)
 {
     dict["Equal"]        = new DefaultSqlMaker("{c}='{p0}'");
     dict["NotEqual"]     = new DefaultSqlMaker("{c}<>'{p0}'");
     dict["Greater"]      = new DefaultSqlMaker("{c}>'{p0}'");
     dict["GreaterEqual"] = new DefaultSqlMaker("{c}>='{p0}'");
     dict["Less"]         = new DefaultSqlMaker("{c}<'{p0}'");
     dict["LessEqual"]    = new DefaultSqlMaker("{c}<='{p0}'");
     dict["In"]           = new DefaultSqlMaker("{c} in ({p0})");
     dict["Like"]         = new DefaultSqlMaker("{c} like '%{p0}%'");
     dict["StartWith"]    = new DefaultSqlMaker("{c} like '{p0}%'");
     dict["EndWith"]      = new DefaultSqlMaker("{c} like '%{p0}'");
     dict["Between"]      = new DefaultSqlMaker("{c} between '{p0}' and '{p1}'");
     dict["Map"]          = new DefaultSqlMaker("{c} in (select {p0} from {p1} where {p0}='{p2}'");
     dict["Sql"]          = new StringFormatSqlMaker();
 }