/// <summary> /// /// </summary> /// <param name="page">页号</param> /// <param name="mid">上级ID</param> /// <param name="id">查询ID</param> /// <param name="pq">分页信息</param> /// <returns></returns> public static IEnumerable <AgentUser> GetListByPage(int pageid, int pagesize, int mid, int id, out PagerQuery pq) { pq = new PagerQuery(); pq.StartItemIndex = pageid; pq.PageSize = pagesize; pq.RecordCount = GetRecordCount(id); pq.Sql = string.Format(@"select * from AgentUsers where HigherLevel = @ID or Id = @ID order by HigherLevel asc limit @StartRowNumber, @PageSize"); //pq.Sql = string.Format(@"select * from AgentUsers order by Id desc limit @StartRowNumber, @PageSize"); return(AgentUserDAL.GetListByPage(pq, mid, id)); }
public static string GetUserListString(int masterID) { return(AgentUserDAL.GetUserListString(masterID)); }
public static AgentUser GetModel(int agentID) { return(AgentUserDAL.GetModel(agentID)); }
public static IEnumerable <AgentUser> GetUserList(string idlist) { return(AgentUserDAL.GetUserList(idlist)); }
public static bool CheckUser(int mid, int id) { return(AgentUserDAL.CheckUser(mid, id)); }
public static int GetRecordCount(int id) { return(AgentUserDAL.GetRecordCount(id)); }