public List <Tab_GongZhongHao> GetGZHList(int pageIndex, int pageSize, out int totalPage, out int totalRecord) { PageCriteria page = new PageCriteria(); page.TableName = "[Tab_GongZhongHao]"; page.Fields = "[F_Id], [F_GZHName], [F_WXName], [F_Logo], [F_About], [F_CreateDate]"; page.Condition = "1 = 1"; page.Sort = "[F_Id] DESC"; page.PageSize = pageSize; page.CurrentPage = pageIndex; return(CommonRepository.GetSomeList <Tab_GongZhongHao>(page, out totalPage, out totalRecord)); }
public List <Tab_MHImg> GetMHImgList(int mhid, int pageIndex, int pageSize, out int totalPage, out int totalRecord) { PageCriteria page = new PageCriteria(); page.TableName = "[Tab_MHImg]"; page.Fields = "[F_Id], [F_Name], [F_Img], [F_MHId], [F_Sort], [F_IsEnable], [F_UserId], [F_CreateDate]"; page.Condition = "[F_MHId] = " + mhid + " AND [F_IsEnable] = 1"; page.Sort = "[F_Sort] DESC"; page.PageSize = pageSize; page.CurrentPage = pageIndex; return(CommonRepository.GetSomeList <Tab_MHImg>(page, out totalPage, out totalRecord)); }
public List <Tab_MHCatalog> GetMHList(int gzhid, int pageIndex, int pageSize, out int totalPage, out int totalRecord) { PageCriteria page = new PageCriteria(); page.TableName = "[Tab_MHCatalog] a JOIN [Tab_GongZhongHao] b ON a.[F_GZHId] = b.[F_Id] JOIN [dbo].[Tab_User] c ON c.F_Id = a.[F_CreateUser]"; page.Fields = "a.[F_Id], a.[F_Catalog], a.[F_Logo], a.[F_About], a.[F_GZHId], c.[F_Name] [userName], a.[F_CreateUser], a.[F_CreateDate], b.[F_GZHName] [GZHName]"; page.Condition = "b.[F_Id] = " + gzhid; page.Sort = "a.[F_Id] DESC"; page.PageSize = pageSize; page.CurrentPage = pageIndex; return(CommonRepository.GetSomeList <Tab_MHCatalog>(page, out totalPage, out totalRecord)); }