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;
10
11/**//// <summary>
12/// GuestBook 的摘要说明
13/// </summary>
14namespace WebQuest
15...{
16    public class GuestBook
17    ...{
18        私有成员与属性#region 私有成员与属性
19        private int _guestBookId;
20
21        public int GuestBookId
22        ...{
23            get ...{ return _guestBookId; }
24            set ...{ _guestBookId = value; }
25        }
26        private string _title;
27
28        public string Title
29        ...{
30            get ...{ return _title; }
31            set ...{ _title = value; }
32        }
33        private string _content;
34
35        public string Content
36        ...{
37            get ...{ return _content; }
38            set ...{ _content = value; }
39        }
40        private int _userId;
41
42        public int UserId
43        ...{
44            get ...{ return _userId; }
45            set ...{ _userId = value; }
46        }
47        private int _activityId;
48
49        public int ActivityId
50        ...{
51            get ...{ return _activityId; }
52            set ...{ _activityId = value; }
53        }
54        
55        #endregion
56        public DataSet Retrieve()
57        ...{ AccessDB myObj = new AccessDB();
58        myObj.SqlStr = "select * from Guestbook_All where activityid=" + _activityId.ToString();
59        return myObj.ExecuteSqlStrReturnDs();
60    }
61        public int Create()
62        ...{ AccessDB myObj = new AccessDB();
63        myObj.SqlStr = "insert into Webquest_GuestBook (title,content,userid,activityid) values ('"+_title+"','"+_content+"','"+_userId+"','"+_activityId+"')";
64        myObj.ExecuteSqlStr();
65        return 0;
66    }
67    public DataSet RetrieveById()
68    ...{
69        AccessDB myObj = new AccessDB();
70        myObj.SqlStr = "select * from Guestbook_All where userid=" +_userId.ToString();
71        return myObj.ExecuteSqlStrReturnDs();
72    }
73        public int Delete()
74        ...{ AccessDB myObj = new AccessDB();
75        myObj.SqlStr = "delete from Webquest_GuestBook where guestbookid="+_guestBookId.ToString();
76        myObj.ExecuteSqlStr();
77        return 0;
78    }
79        public GuestBook()
80        ...{
81            //
82            // TODO: 在此处添加构造函数逻辑
83            //
84        }
85    }
86    
87}