public IList<CY.UME.Core.Business.AccountGroup> GetLatestVisitors(int groupId, CY.UME.Core.PagingInfo pageInfo) { IList<Core.Business.AccountGroup> accountGroupList = new List<Core.Business.AccountGroup>(); SqlServerUtility sql = new SqlServerUtility(SqlConnection); #region ���� string tables = "AccountGroup"; string pK = "Id"; string sort = "LastVisitDate Desc"; int pageNum = pageInfo.CurrentPage; int pageSize = pageInfo.PageSize; string fields = "[Id], [AccountId],[GroupId],[DateCreated],[Role],[LastVisitDate],[Name]"; string filter = "[GroupId]=" + groupId.ToString(); string group = String.Empty; #endregion sql.AddParameter("@Tables", SqlDbType.VarChar, tables); sql.AddParameter("@PK", SqlDbType.VarChar, pK); sql.AddParameter("@Sort", SqlDbType.VarChar, sort); sql.AddParameter("@PageNumber", SqlDbType.Int, pageNum); sql.AddParameter("@PageSize", SqlDbType.Int, pageSize); sql.AddParameter("@Fields", SqlDbType.VarChar, fields); sql.AddParameter("@Filter", SqlDbType.VarChar, filter); sql.AddParameter("@Group", SqlDbType.VarChar, group); SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount"); if (reader != null) { while (reader.Read()) { Core.Business.AccountGroup accountGroup = new AccountGroup(); if (!reader.IsDBNull(0)) accountGroup.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) accountGroup.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) accountGroup.GroupId = reader.GetInt32(2); if (!reader.IsDBNull(3)) accountGroup.DateCreated = reader.GetDateTime(3); if (!reader.IsDBNull(4)) accountGroup.Role = reader.GetInt32(4); if (!reader.IsDBNull(5)) accountGroup.LastVisitDate = reader.GetDateTime(5); if (!reader.IsDBNull(6)) accountGroup.Name = reader.GetString(6); accountGroup.MarkOld(); accountGroupList.Add(accountGroup); } reader.Close(); } return accountGroupList; }
public IList<Core.Business.AccountGroup> GetAccountGroupByAccountIdOrGroupId(long accountId, int groupId) { IList<Core.Business.AccountGroup> accountGroupList = new List<Core.Business.AccountGroup>(); SqlServerUtility sql = new SqlServerUtility(SqlConnection); sql.AddParameter("@AccountId", SqlDbType.BigInt, accountId); sql.AddParameter("@GroupId", SqlDbType.Int, groupId); SqlDataReader reader = sql.ExecuteSPReader("USP_AccountGroup_Select_By_AccountId_And_GroupId"); if (reader != null) { while (reader.Read()) { Core.Business.AccountGroup accountGroup = new AccountGroup(); if (!reader.IsDBNull(0)) accountGroup.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) accountGroup.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) accountGroup.GroupId = reader.GetInt32(2); if (!reader.IsDBNull(3)) accountGroup.DateCreated = reader.GetDateTime(3); if (!reader.IsDBNull(4)) accountGroup.Role = reader.GetInt32(4); if (!reader.IsDBNull(5)) accountGroup.LastVisitDate = reader.GetDateTime(5); if (!reader.IsDBNull(6)) accountGroup.Name = reader.GetString(6); accountGroup.MarkOld(); accountGroupList.Add(accountGroup); } reader.Close(); } return accountGroupList; }
public IList<CY.UME.Core.Business.AccountGroup> GetAccountGroupByGroupIdAndRoleAndAccountId(CY.UME.Core.Business.Group Group, int type, int role, CY.UME.Core.Business.Account account, CY.UME.Core.PagingInfo pageInfo) { IList<Core.Business.AccountGroup> accountGroupList = new List<Core.Business.AccountGroup>(); SqlServerUtility sql = new SqlServerUtility(SqlConnection); #region ���� string tables = "AccountGroup"; string pK = "Id"; string sort = "Id Desc"; int pageNum = pageInfo.CurrentPage; int pageSize = pageInfo.PageSize; string fields = "[Id], [AccountId],[GroupId],[DateCreated],[Role],[LastVisitDate],[Name]"; string group = String.Empty; string filter = "1=1"; if (Group != null) { filter += " and [GroupId]=" + Group.Id.ToString(); } if (type != -1) { if (type==-2) { filter += " and [GroupId] in (select [Id] from [Group] where [type]>0 and [IsChecked]=1)"; } else { filter += " and [GroupId] in (select [Id] from [Group] where [type]=" + type.ToString() + " and [IsChecked]=1)"; } } if (role != -1) { filter += " and [Role]=" + role.ToString(); } if (account != null) { filter += " and [AccountId]=" + account.Id.ToString(); } #endregion sql.AddParameter("@Tables", SqlDbType.VarChar, tables); sql.AddParameter("@PK", SqlDbType.VarChar, pK); sql.AddParameter("@Sort", SqlDbType.VarChar, sort); sql.AddParameter("@PageNumber", SqlDbType.Int, pageNum); sql.AddParameter("@PageSize", SqlDbType.Int, pageSize); sql.AddParameter("@Fields", SqlDbType.VarChar, fields); sql.AddParameter("@Filter", SqlDbType.VarChar, filter); sql.AddParameter("@Group", SqlDbType.VarChar, group); SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount"); if (reader != null) { while (reader.Read()) { Core.Business.AccountGroup accountGroup = new AccountGroup(); if (!reader.IsDBNull(0)) accountGroup.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) accountGroup.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) accountGroup.GroupId = reader.GetInt32(2); if (!reader.IsDBNull(3)) accountGroup.DateCreated = reader.GetDateTime(3); if (!reader.IsDBNull(4)) accountGroup.Role = reader.GetInt32(4); if (!reader.IsDBNull(5)) accountGroup.LastVisitDate = reader.GetDateTime(5); if (!reader.IsDBNull(6)) accountGroup.Name = reader.GetString(6); accountGroup.MarkOld(); accountGroupList.Add(accountGroup); } reader.Close(); } return accountGroupList; }