Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 8th, 2012  |  syntax: None  |  size: 0.86 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Get column-property mapping relationship in MyBatis
  2. switch (filter.FilterType)
  3.         {
  4.             case FilterType.BeginsWith:
  5.                 operatorStr = "UPPER({0}) LIKE '{1}%' ";
  6.                 value = filter.Value.ToUpper();
  7.                 break;
  8.             case FilterType.Contains:
  9.                 operatorStr = "UPPER({0}) LIKE '%{1}%' ";
  10.                 value = filter.Value.ToUpper();
  11.                 break;
  12.             case FilterType.GreaterThan:
  13.                 operatorStr = " {0} > {1} ";
  14.                 break;
  15.             case FilterType.GreaterThanOrEqual:
  16.                 operatorStr = " {0} >= {1} ";
  17.                 break;
  18.             case FilterType.LessThan:
  19.                 operatorStr = " {0} < {1} ";
  20.                 break;
  21.             case FilterType.LessThanOrEqual:
  22.                 operatorStr = " {0} <= {1} ";
  23.                 break;
  24.         }
create a new version of this paste RAW Paste Data