1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using System.Data.OleDb;
 11/**//// <summary>
 12/// Activities 的摘要说明
 13/// </summary>
 14namespace WebQuest
 15...{
 16    public class Activities
 17    ...{
 18        私有成员和属性#region 私有成员和属性
 19        private int _activityId;
 20
 21        public int ActivityId
 22        ...{
 23            get ...{ return _activityId; }
 24            set ...{ _activityId = value; }
 25        }
 26        private string _description;
 27
 28        public string Description
 29        ...{
 30            get ...{ return _description; }
 31            set ...{ _description = value; }
 32        }
 33        private int _userId;
 34
 35        public int UserId
 36        ...{
 37            get ...{ return _userId; }
 38            set ...{ _userId = value; }
 39        }
 40        private string _activityName;
 41
 42        public string ActivityName
 43        ...{
 44            get ...{ return _activityName; }
 45            set ...{ _activityName = value; }
 46        }
 47    
 48        #endregion
 49        public DataSet RetrieveTop()
 50        ...{
 51            AccessDB myObj = new AccessDB();
 52            myObj.SqlStr = "select top 20 * from webquest_activities order by activityid desc";
 53            return myObj.ExecuteSqlStrReturnDs();
 54        }
 55        public DataSet Retrieve()
 56        ...{
 57            AccessDB myObj = new AccessDB();
 58            myObj.SqlStr = "select  * from webquest_activities order by activityid desc";
 59            return myObj.ExecuteSqlStrReturnDs();
 60        }
 61        public int Delete()
 62        ...{ AccessDB myObj = new AccessDB();
 63        myObj.SqlStr = "delete from webquest_activities where activityid="+_activityId.ToString();
 64        myObj.ExecuteSqlStr();
 65        return 0;
 66    }
 67        public int Create()
 68        ...{
 69            AccessDB myObj = new AccessDB();
 70            myObj.SqlStr = "insert into webquest_activities (activityname,description,userid) values ('" + _activityName + "','" + _description + "','"+_userId+"')";
 71            myObj.ExecuteSqlStr();
 72            return 0;
 73        }
 74        public int Update()
 75        ...{
 76            AccessDB myObj = new AccessDB();
 77            myObj.SqlStr = "update webquest_activities set activityname='" + _activityName + "',description='" + _description + "' where activityid=" + _activityId.ToString();
 78            myObj.ExecuteSqlStr();
 79            return 0;
 80        }
 81        public OleDbDataReader RetrieveById()
 82        ...{
 83            AccessDB myObj = new AccessDB();
 84            myObj.SqlStr = "select  * from webquest_activities where activityid="+_activityId.ToString();
 85            return myObj.ExecuteSqlStrReturnDr();
 86        }
 87        public DataSet RetrieveAll()
 88        ...{
 89            AccessDB myObj = new AccessDB();
 90            myObj.SqlStr = "select  * from activity_all order by activityid desc";
 91            return myObj.ExecuteSqlStrReturnDs();
 92        }
 93        public DataSet RetrieveByUser()
 94        ...{
 95            AccessDB myObj = new AccessDB();
 96            myObj.SqlStr = "select  * from webquest_activities where userid="+_userId.ToString();
 97            return myObj.ExecuteSqlStrReturnDs();
 98        }
 99        public Activities()
100        ...{
101            //
102            // TODO: 在此处添加构造函数逻辑
103            //
104        }
105    }
106    
107}