/// <summary>
/// 执行分页查询类信息
/// </summary>
/// <param name="handler"></param>
/// <param name="_currentpage"></param>
/// <param name="pagesize"></param>
/// <returns></returns>
protected virtual string SelectPage(string handler, int _currentpage, int pagesize)
{
KdtPageEx page = new KdtPageEx(_currentpage, pagesize);
// 执行操作
using (var helper = CreateHelper())
{
switch (handler.Trim().ToLower())
{
case "user":
return(JsonGridInvork <Handles.User.UserEntity>((out int total) =>
{
var list = helper.SelectPage <Handles.User.UserEntity>(SetHandler <Handles.User.UserHandler>(), page);
total = page.total;
return list;
}));
case "format":
return(JsonGridInvork <Handles.FileStore.FileFormatQuery>((out int total) =>
{
var list = helper.SelectPage <Handles.FileStore.FileFormatQuery>(SetHandler <Handles.FileStore.FileFormatHandler>(), page);
total = page.total;
return list;
}));
case "version":
return(JsonGridInvork <Handles.Object.ObjVersionQuery>((out int total) =>
{
var list = helper.SelectPage <Handles.Object.ObjVersionQuery>(SetHandler <Handles.Object.ObjVersionHandler>(), page);
total = page.total;
return list;
}));
case "ruser":
return(JsonGridInvork <Handles.User.RoleUserEntity>((out int total) =>
{
var list = helper.SelectPage <Handles.User.RoleUserEntity>(SetHandler <Handles.User.RoleUserHandler>(), page);
total = page.total;
return list;
}));
default: throw new NotExist(handler);
}
}
}
public void GetAllPage()
{
using (MysqlExecute helper = new MysqlExecute())
{
int start = 0;
int size = 5;
var entity = new MysqlTestHandler();
KdtPageEx page = new KdtPageEx()
{
selpage = "selectPage",
selpagetotal = "selectPageCount",
start = start,
end = start + size
};
var test = helper.SelectPage <MySqlTestQuery>(entity, page);
var aa = 0;
//helper.Add(entity);
}
}
