聚合函数 | 对应 SQL 语句 |
---|---|
DBMethod.Count(field) | COUNT([FIELD]) |
DBMethod.Sum(field) | SUM([FIELD]) |
DBMethod.Max(field) | MAX([FIELD]) |
DBMethod.Min(field) | MIN([FIELD]) |
DBMethod.Avg(field) | AVG([FIELD]) |
字符串处理函数 | 对应 SQL 语句 |
---|---|
DBMethod.Len(data) | LEN([DATA]) |
DBMethod.Lower(data) | LOWER([DATA]) |
DBMethod.Upper(data) | UPPER([DATA]) |
DBMethod.Trim(data) | RTRIM(LTRIM([DATA])) |
DBMethod.TrimStart(data) | LTRIM([DATA]) |
DBMethod.TrimEnd(data) | RTRIM([DATA]) |
DBMethod.SubString(data, start, length) | SUBSTRING([DATA], [START], [LENGTH]) |
DBMethod.Replace(data, pattern, replacement) | REPLACE([DATA], [PATTERN], [REPLACEMENT]) |
field.IndexOf(data) | CHARINDEX([DATA], [FIELD]) |
field.Contains(data) | like %[DATA]% |
list.Contains(field) | [FIELD] in ([LIST]) |
field.StartsWith(data) | like [DATA]% |
field.EndsWith(data) | like %[DATA] |
日期函数 | 对应 SQL 语句 |
---|---|
DBMethod.DateDiff(dateType, oneDate, twoDate) | DATEDIFF([DATETYPE], [ONEDATE], [TWODATE]) |
DBMethod.DateAdd(dateType, date, num) | DATEADD([DATETYPE], [NUM], [DATE]) |
Convert | 对应 SQL 语句 |
---|---|
DBMethod.ConvertDate(data) | CONVERT([DATE], [DATA]) |
DBMethod.ConvertInt(data) | CONVERT([INT], [DATA]) |
DBMethod.ConvertVarchar(data, length, style) | CONVERT(VARCHAR([LENGTH]), [DATA], [STYLE]) |
DBMethod.ConvertString(data, length) | CONVERT(NVARCHAR([LENGTH]), [DATA]) |
DBMethod.ConvertDecimal(data, length, dec) | CONVERT(DECIMAL([LENGTH], [DEC]), [DATA]) |
DBMethod.ConvertFloat(data, dec) | CONVERT(FLOAT([DEC]), [DATA]) |
其他函数 | 对应 SQL 语句 |
---|---|
DBMethod.ListIndexOf(field, dataDict) | CHARINDEX([DATA1], [FIELD]) > POS1 or CHARINDEX([DATA2], [FIELD]) > POS2 ... |
DBMethod.ListContains(field, dataList) | CHARINDEX([DATA1], [FIELD]) > 0 or CHARINDEX([DATA2], [FIELD]) > 0 ... |
DBMethod.BetweenAnd(field, beginData, endData) | BETWEEN BEGINDATA AND ENDDATA |
DBMethod.CaseWhen(field, dataDict, defaultData) | CASE FIELD WHEN DATA1 THEN ELSE DEFAULTDATA END |
DBMethod.CaseWhenRange(field, itemList, defaultData) | CASE WHEN FIELD > DATA1 and FIELD <= DATA2 THEN ELSE DEFAULTDATA END |
DBMethod.Bracket(data) | (DATA->SQL) |