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/// Items 的摘要说明
 13/// </summary>
 14namespace WebQuest
 15...{
 16    public class Items
 17    ...{
 18        私有成员及属性#region 私有成员及属性
 19        private int _webquestId;
 20
 21        public int WebquestId
 22        ...{
 23            get ...{ return _webquestId; }
 24            set ...{ _webquestId = value; }
 25        }
 26        private string _title;
 27
 28        public string Title
 29        ...{
 30            get ...{ return _title; }
 31            set ...{ _title = value; }
 32        }
 33        private string _description;
 34
 35        public string Description
 36        ...{
 37            get ...{ return _description; }
 38            set ...{ _description = value; }
 39        }
 40        private int _userId;
 41
 42        public int UserId
 43        ...{
 44            get ...{ return _userId; }
 45            set ...{ _userId = value; }
 46        }
 47        private int _subjectId;
 48
 49        public int SubjectId
 50        ...{
 51            get ...{ return _subjectId; }
 52            set ...{ _subjectId = value; }
 53        }
 54        private string _styleName;
 55
 56        public string StyleName
 57        ...{
 58            get ...{ return _styleName; }
 59            set ...{ _styleName = value; }
 60        } 
 61        #endregion
 62        //获取所有记录，返回dataset
 63        public OleDbDataReader RetrieveById()
 64        ...{
 65            AccessDB myObj = new AccessDB();
 66            myObj.SqlStr = "select * from webquest_items where webquestid="+_webquestId.ToString();
 67            return myObj.ExecuteSqlStrReturnDr();
 68        }
 69        public DataSet Retrieve0()
 70        ...{
 71            AccessDB myObj = new AccessDB();
 72            myObj.SqlStr = "select * from webquest_items order by createdate desc ";
 73            return myObj.ExecuteSqlStrReturnDs();
 74        }
 75        public DataSet RetrieveByUser()
 76        ...{
 77            AccessDB myObj = new AccessDB();
 78            myObj.SqlStr = "select * from webquest_items  where userid=" + _userId .ToString();
 79            return myObj.ExecuteSqlStrReturnDs();
 80        }
 81        public DataSet RetrieveTop()
 82        ...{
 83            AccessDB myObj = new AccessDB();
 84            myObj.SqlStr = "select top 20 * from webquest_items order by webquestid desc";
 85            return myObj.ExecuteSqlStrReturnDs();
 86        }
 87    
 88        public OleDbDataReader GetMaxId()
 89        ...{
 90            AccessDB myObj = new AccessDB();
 91            myObj.SqlStr = "select top 1 * from webquest_items  order by webquestid desc";
 92            return myObj.ExecuteSqlStrReturnDr();
 93        }
 94        public int Create()
 95        ...{
 96            try
 97            ...{
 98                AccessDB myObj = new AccessDB();
 99                myObj.SqlStr = "insert into webquest_items(title,description,userid,subjectid,stylename) values('" + _title + "','" + _description + "','" + _userId + "','" + _subjectId + "','" + _styleName + "')";
100                myObj.ExecuteSqlStr();
101                return 0;
102            }
103            catch (Exception a)
104            ...{
105                
106                throw a;
107                return -1;
108            }
109        }
110        public int Update()
111        ...{
112            try
113            ...{
114                AccessDB myObj = new AccessDB();
115                myObj.SqlStr = "update webquest_items set title='" + _title + "',description='" + _description + "',subjectid='" + _subjectId + "',stylename='" + _styleName + "' where webquestid="+_webquestId.ToString();
116                myObj.ExecuteSqlStr();
117                return 0;
118            }
119            catch (Exception a)
120            ...{
121
122                throw a;
123                return -1;
124            }
125        }
126        public int Delete()
127        ...{
128            try
129            ...{
130                AccessDB myObj = new AccessDB();
131                myObj.SqlStr = "delete from webquest_items where webquestid=" + _webquestId.ToString(); ;
132                myObj.ExecuteSqlStr();
133                return 0;
134            }
135            catch (Exception a)
136            ...{
137
138                throw a;
139                return -1;
140            }
141        }
142        public DataSet RetrieveBySubjectId()
143        ...{
144            AccessDB myObj = new AccessDB();
145            myObj.SqlStr = "select * from webquest_items where subjectid=" + _subjectId.ToString();
146            return myObj.ExecuteSqlStrReturnDs();
147        }
148        public Items()
149        ...{
150            //
151            // TODO: 在此处添加构造函数逻辑
152            //
153
154        }
155    } 
156}
157