Class PagerParameters
Namespace: Tool.SqlCore
Assembly: Tool.Net.dll
根据指定分页信息查询SQL
public class PagerParametersInheritance
Inherited Members
object.Equals(object?), object.Equals(object?, object?), object.GetHashCode(), object.GetType(), object.MemberwiseClone(), object.ReferenceEquals(object?, object?), object.ToString()
Extension Methods
ObjectExtension.Add<T>(object, object, object), ObjectExtension.CopyEntity(object, object, params string[]), ObjectExtension.EntityToJson(object), ObjectExtension.EntityToJson(object, bool), ObjectExtension.EntityToJson(object, bool, string), DictionaryExtension.GetDictionary(object), TypeExtension.GetFieldKey(object, string, out bool), TypeExtension.GetFieldKey<T>(object, string, out bool), TypeExtension.GetFieldKey(object, Type, string, out bool), ObjectExtension.GetIntPtr(object), ObjectExtension.GetIntPtrInt(object), TypeExtension.GetPropertieFind(object, string, bool), TypeExtension.GetProperties(object), TypeExtension.GetPropertyKey(object, string, out bool), TypeExtension.GetPropertyKey<T>(object, string, out bool), TypeExtension.GetPropertyKey(object, Type, string, out bool), TypeExtension.GetValue(object, PropertyDescriptor), TypeExtension.GetValue(object, string, bool), TypeExtension.GetValue(object, string), ObjectExtension.Read<T>(object, object, int, int), ObjectExtension.Read<T>(object, int, object, int, int), DictionaryExtension.SetDictionary(object, IDictionary<string, object>), TypeExtension.SetFieldKey(object, string, object), TypeExtension.SetFieldKey<T>(object, string, object), TypeExtension.SetFieldKey(object, Type, string, object), TypeExtension.SetPropertyKey(object, string, object), TypeExtension.SetPropertyKey<T>(object, string, object), TypeExtension.SetPropertyKey(object, Type, string, object), TypeExtension.SetValue(object, PropertyDescriptor, object), TypeExtension.SetValue(object, string, object, bool), TypeExtension.SetValue(object, string, object), ObjectExtension.ToBase64String(object), ObjectExtension.ToBytes(object), ObjectExtension.ToBytes(object, out Type), DictionaryExtension.ToDictionary(object), DictionaryExtension.ToDictionary<T>(object), DictionaryExtension.ToIDictionary(object), DictionaryExtension.ToIDictionary<T>(object), ObjectExtension.ToJson(object), ObjectExtension.ToJson(object, JsonSerializerOptions), ObjectExtension.ToJsonWeb(object), ObjectExtension.ToJsonWeb(object, Action<JsonSerializerOptions>), ObjectExtension.ToTryVar<T>(object, T), ObjectExtension.ToVar<T>(object), ObjectExtension.ToVar(object, Type, bool), ObjectExtension.ToVar(object, string), ObjectExtension.ToXml(object)
Remarks
代码由逆血提供支持
Constructors
PagerParameters()
实例化分页对象
public PagerParameters()PagerParameters(string, string, int)
实例化分页对象
public PagerParameters(string table, string pkey, int pageIndex)Parameters
table string
查询表名
pkey string
显示方式，例如：倒序，顺序（ORDER By ID DESC）
pageIndex int
页索引
PagerParameters(string, string, int, int)
实例化分页对象
public PagerParameters(string table, string pkey, int pageIndex, int pageSize)Parameters
table string
查询表名
pkey string
显示方式，例如：倒序，顺序（ORDER By ID DESC）
pageIndex int
页索引
pageSize int
页大小
PagerParameters(string, string, int, string)
实例化分页对象
public PagerParameters(string table, string pkey, int pageIndex, string whereStr)Parameters
table string
查询表名
pkey string
显示方式，例如：倒序，顺序（ORDER By ID DESC）
pageIndex int
页索引
whereStr string
查询条件
PagerParameters(string, string, string, int, int)
实例化分页对象
public PagerParameters(string table, string pkey, string whereStr, int pageIndex, int pageSize)Parameters
table string
查询表名
pkey string
显示方式，例如：倒序，顺序（ORDER By ID DESC）
whereStr string
查询条件
pageIndex int
页索引
pageSize int
页大小
PagerParameters(string, string, string, int, int, string[])
实例化分页对象
public PagerParameters(string table, string pkey, string whereStr, int pageIndex, int pageSize, string[] fields)Parameters
table string
查询表名
pkey string
显示方式，例如：倒序，顺序（ORDER By ID DESC）
whereStr string
查询条件
pageIndex int
页索引
pageSize int
页大小
fields string[]
SQL表查询的字段
PagerParameters(string, string, string, int, int, string[], string[])
实例化分页对象
public PagerParameters(string table, string pkey, string whereStr, int pageIndex, int pageSize, string[] fields, string[] fieldAlias)Parameters
table string
查询表名
pkey string
显示方式，例如：倒序，顺序（ORDER By ID DESC）
whereStr string
查询条件
pageIndex int
页索引
pageSize int
页大小
fields string[]
SQL表查询的字段
fieldAlias string[]
SQL表查询的字段 AS 别名
PagerParameters(string, string, string, int, int, string[], bool)
实例化分页对象
public PagerParameters(string sql, string pkey, string whereStr, int pageIndex, int pageSize, string[] fields, bool issql)Parameters
sql string
查询表名
pkey string
显示方式，例如：倒序，顺序（ORDER By ID DESC）
whereStr string
查询条件
pageIndex int
页索引
pageSize int
页大小
fields string[]
SQL表查询的字段
issql bool
使用表名还是使用SQL执行分页（true：SQL，false：表名）
PagerParameters(string, string, string, int, int, string[], string[], bool)
实例化分页对象
public PagerParameters(string sql, string pkey, string whereStr, int pageIndex, int pageSize, string[] fields, string[] fieldAlias, bool issql)Parameters
sql string
查询表名
pkey string
显示方式，例如：倒序，顺序（ORDER By ID DESC）
whereStr string
查询条件
pageIndex int
页索引
pageSize int
页大小
fields string[]
SQL表查询的字段
fieldAlias string[]
SQL表查询的字段 AS 别名
issql bool
使用表名还是使用SQL执行分页（true：SQL，false：表名）
Properties
FieldAlias
SQL表查询的字段 AS 别名
public string[] FieldAlias { get; set; }Property Value
string[]
Fields
SQL表查询的字段
public string[] Fields { get; set; }Property Value
string[]
IsSql
使用表名还是使用SQL执行分页（true：SQL，false：表名）
public bool IsSql { get; set; }Property Value
PKey
显示方式，例如：倒序，顺序（ORDER By ID DESC）
public string PKey { get; set; }Property Value
PageIndex
页索引
public int PageIndex { get; set; }Property Value
PageSize
页大小
public int PageSize { get; set; }Property Value
Table
表名
public string Table { get; set; }Property Value
WhereStr
查询条件
public string WhereStr { get; set; }