grouprequest.cs

ASP.NET简洁论坛源代码 这是一个简单的论坛

using System;
using System.Collections.Generic;
using System.Text;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using NetFocus.Web.Core;

namespace NetFocus.Web.Applications.Forum
{
    public class GroupRequest : EntityRequest
    {
        public int Enabled = -1;

        public override string GetPopulateSql()
        {
            StringBuilder sb = new StringBuilder();

            sb.AppendFormat("Select top {0} {2} From tb_Entities E where E.EntityType = {1}", (PageIndex + 1) * PageSize, (int)NetFocus.Web.Applications.Forum.EntityType.Group, GetInternalSelectSql());

            if (Enabled == 0 || Enabled == 1)
            {
                sb.AppendFormat(" and E.IntField1 = {0}", Enabled);
            }

            sb.Append(base.GetOrderSql());

            return sb.ToString();
        }
        public override string GetFullPopulateSql()
        {
            StringBuilder sb = new StringBuilder();

            sb.AppendFormat("Select E.EntityId From tb_Entities E where E.EntityType = {0}", (int)NetFocus.Web.Applications.Forum.EntityType.Group);

            if (Enabled == 0 || Enabled == 1)
            {
                sb.AppendFormat(" and E.IntField1 = {0}", Enabled);
            }

            return sb.ToString();
        }
    }
}