| 聚合函数 | 对应 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) |