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}')))"); }
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}')))"); }
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}%'"); }
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}%'"); }
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(); }
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(); }