C# (CSharp) Zephyr.Core DateRangeSqlMakerの例

コード例 #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}')))");
 }

コード例 #2

ファイル: MySql.cs プロジェクト: 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}')))");

        }

コード例 #3

ファイル: SqlServer.cs プロジェクト: 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}%'");
 }

コード例 #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}%'");
 }