예제 #1
0
        public override ClubMemberCollection GetTopClubManagers(int clubID, int top)
        {
            using (SqlQuery db = new SqlQuery())
            {
                db.CommandText = "SELECT TOP (@Top) * FROM bx_ClubMembers WHERE ClubID = @ClubID AND Status IN (4, 5)";

                db.CreateTopParameter("@Top", top);
                db.CreateParameter <int>("@ClubID", clubID, SqlDbType.Int);

                using (XSqlDataReader reader = db.ExecuteReader())
                {
                    ClubMemberCollection result = new ClubMemberCollection(reader);

                    return(result);
                }
            }
        }
예제 #2
0
        public override ClubMemberCollection GetClubMembers(int clubID, int pageSize, int pageNumber, ClubMemberStatus?status)
        {
            using (SqlQuery db = new SqlQuery())
            {
                db.Pager.TableName   = "bx_ClubMembers";
                db.Pager.SortField   = "SortOrder";
                db.Pager.PageSize    = pageSize;
                db.Pager.PageNumber  = pageNumber;
                db.Pager.Condition   = "ClubID = @ClubID";
                db.Pager.SelectCount = true;

                if (status != null)
                {
                    db.Pager.Condition += " AND Status = @Status";
                    db.CreateParameter <ClubMemberStatus>("@Status", status.Value, SqlDbType.TinyInt);
                }
                else
                {
                    db.Pager.Condition += " AND Status <> 1 AND Status <> 2";
                }

                db.CreateParameter <int>("@ClubID", clubID, SqlDbType.Int);

                using (XSqlDataReader reader = db.ExecuteReader())
                {
                    ClubMemberCollection result = new ClubMemberCollection(reader);

                    reader.NextResult();
                    reader.Read();

                    result.TotalRecords = reader.Get <int>(0);

                    return(result);
                }
            }
        }
예제 #3
0
파일: ClubDao.cs 프로젝트: huchao007/bbsmax
        public override ClubMemberCollection GetClubMembers(int clubID, int pageSize, int pageNumber, ClubMemberStatus? status)
        {
            using (SqlQuery db = new SqlQuery())
            {
                db.Pager.TableName = "bx_ClubMembers";
                db.Pager.SortField = "SortOrder";
                db.Pager.PageSize = pageSize;
                db.Pager.PageNumber = pageNumber;
                db.Pager.Condition = "ClubID = @ClubID";
                db.Pager.SelectCount = true;

                if (status != null)
                {
                    db.Pager.Condition += " AND Status = @Status";
                    db.CreateParameter<ClubMemberStatus>("@Status", status.Value, SqlDbType.TinyInt);
                }
                else
                {
                    db.Pager.Condition += " AND Status <> 1 AND Status <> 2";
                }

                db.CreateParameter<int>("@ClubID", clubID, SqlDbType.Int);

                using (XSqlDataReader reader = db.ExecuteReader())
                {
                    ClubMemberCollection result = new ClubMemberCollection(reader);

                    reader.NextResult();
                    reader.Read();

                    result.TotalRecords = reader.Get<int>(0);

                    return result;
                }
            }
        }
예제 #4
0
파일: ClubDao.cs 프로젝트: huchao007/bbsmax
        public override ClubMemberCollection GetTopClubManagers(int clubID, int top)
        {
            using (SqlQuery db = new SqlQuery())
            {
                db.CommandText = "SELECT TOP (@Top) * FROM bx_ClubMembers WHERE ClubID = @ClubID AND Status IN (4, 5)";

                db.CreateTopParameter("@Top", top);
                db.CreateParameter<int>("@ClubID", clubID, SqlDbType.Int);

                using (XSqlDataReader reader = db.ExecuteReader())
                {
                    ClubMemberCollection result = new ClubMemberCollection(reader);

                    return result;
                }
            }
        }