/// <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); } }