public List <Tab_User> GetUserByGzhList(int gid, int pageIndex, int pageSize, out int totalPage, out int totalRecord)
{
PageCriteria page = new PageCriteria();
page.TableName = "Tab_User a JOIN Tab_User_GZH_Relation b ON a.F_Id = b.F_UserId JOIN Tab_User_Role_Relation c ON c.F_UserId = a.F_Id JOIN Tab_Role d ON d.F_Id = c.F_RoleId";
page.Fields = "a.F_Id, a.F_Name, a.F_CreateDate, d.F_Name RoleName";
page.Condition = " b.F_GZHId = " + gid;
page.Sort = "a.F_Id DESC";
page.PageSize = pageSize;
page.CurrentPage = pageIndex;
return(CommonRepository.GetSomeList <Tab_User>(page, out totalPage, out totalRecord));
}
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));
}