生成分页用Sql语句
Namespace: Adf.DbAssembly: Adf (in Adf.dll) Version: 4.1.5549.27750
Syntaxpublic virtual string PageSql(
int pageindex,
int pagesize,
string fields,
string tablename,
string condition,
string orderby,
string key = "",
string groupby = "",
bool distinct = false
)
Public Overridable Function PageSql (
pageindex As Integer,
pagesize As Integer,
fields As String,
tablename As String,
condition As String,
orderby As String,
Optional key As String = "",
Optional groupby As String = "",
Optional distinct As Boolean = false
) As String
public:
virtual String^ PageSql(
int pageindex,
int pagesize,
String^ fields,
String^ tablename,
String^ condition,
String^ orderby,
String^ key = L"",
String^ groupby = L"",
bool distinct = false
)
abstract PageSql :
pageindex : int *
pagesize : int *
fields : string *
tablename : string *
condition : string *
orderby : string *
?key : string *
?groupby : string *
?distinct : bool
(* Defaults:
let _key = defaultArg key ""
let _groupby = defaultArg groupby ""
let _distinct = defaultArg distinct false
*)
-> string
override PageSql :
pageindex : int *
pagesize : int *
fields : string *
tablename : string *
condition : string *
orderby : string *
?key : string *
?groupby : string *
?distinct : bool
(* Defaults:
let _key = defaultArg key ""
let _groupby = defaultArg groupby ""
let _distinct = defaultArg distinct false
*)
-> string
Parameters
- pageindex
- Type: SystemInt32
页序 - pagesize
- Type: SystemInt32
页大小 - fields
- Type: SystemString
字段值,前后不带空格,位于 Select 与 From 之间的字段部表示 - tablename
- Type: SystemString
要进行查询的数据表,可为多个 - condition
- Type: SystemString
要进行查询的查询串,Where的后缀,如果未有,请设置为 null - orderby
- Type: SystemString
排序方法,如果未有排序则为null - key (Optional)
- Type: SystemString
键 - groupby (Optional)
- Type: SystemString
分组,分组请设置为null - distinct (Optional)
- Type: SystemBoolean
[Missing <param name="distinct"/> documentation for "M:Adf.Db.SqlBuilder.PageSql(System.Int32,System.Int32,System.String,System.String,System.String,System.String,System.String,System.String,System.Boolean)"]
Return Value
Type:
String返回生成后的Sql语句
See Also