ea2ddl-gen/dbflute/templates/om/csharp/allcommon/cbean/sqlclause/SqlClause_mssql.vmnet

   1 #set ($myClassName = "${glSqlClauseInterfaceName}${database.DaoGenDbName}")\r
   2 \r
   3 using System;\r
   4 \r
   5 namespace ${glPackageBaseCommonSqlClause} {\r
   6 \r
   7 [System.Serializable]\r
   8 public class ${myClassName} : ${glSqlClauseAbstractName} {\r
   9 \r
  10     protected String _fetchFirstSelectHint = "";\r
  11     protected String _lockFromHint = "";\r
  12 \r
  13     public ${myClassName}(String tableName)\r
  14         : base(tableName) {}\r
  15 \r
  16         protected override OrderByNullsSetupper createOrderByNullsSetupper() {\r
  17             return new OrderByNullsSetupperByCaseWhen();\r
  18         }\r
  19         \r
  20     protected override void doFetchFirst() {\r
  21         if (this.isFetchSizeSupported()) {\r
  22             _fetchFirstSelectHint = " top " + this.getFetchSize();\r
  23         }\r
  24     }\r
  25 \r
  26     protected override void doFetchPage() {\r
  27         if (this.isFetchSizeSupported()) {\r
  28             if (this.isFetchStartIndexSupported()) {\r
  29                 _fetchFirstSelectHint = " top " + this.getFetchSize();\r
  30             } else {\r
  31                 _fetchFirstSelectHint = " top " + this.getPageEndIndex();\r
  32             }\r
  33         }\r
  34     }\r
  35 \r
  36     protected override void doClearFetchPageClause() {\r
  37         _fetchFirstSelectHint = "";\r
  38     }\r
  39 \r
  40     public override bool isFetchStartIndexSupported() {\r
  41         return false; // Default\r
  42     }\r
  43 \r
  44     public override ${glSqlClauseInterfaceName} lockForUpdate() {\r
  45         _lockFromHint = " with (updlock)";\r
  46         return this;\r
  47     }\r
  48 \r
  49     protected override String createSelectHint() {\r
  50         return _fetchFirstSelectHint;\r
  51     }\r
  52 \r
  53     protected override String createFromBaseTableHint() {\r
  54         return _lockFromHint;\r
  55     }\r
  56 \r
  57     protected override String createFromHint() {\r
  58         return "";\r
  59     }\r
  60 \r
  61     protected override String createSqlSuffix() {\r
  62         return "";\r
  63     }\r
  64 }\r
  65 \r
  66 }\r