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//该源码下载自www.51aspx.com(５1ａｓｐｘ．ｃｏｍ)
 12
 13/**//// <summary>
 14/// Subjects 的摘要说明
 15/// </summary>
 16namespace WebQuest
 17...{
 18    私有成员及属性#region 私有成员及属性
 19    public class Subjects
 20    ...{
 21        private int _subjectId;
 22
 23        public int SubjectId
 24        ...{
 25            get ...{ return _subjectId; }
 26            set ...{ _subjectId = value; }
 27        }
 28        private string _subjectName;
 29
 30        public string SubjectName
 31        ...{
 32            get ...{ return _subjectName; }
 33            set ...{ _subjectName = value; }
 34        }
 35        private string _description;
 36
 37        public string Description
 38        ...{
 39            get ...{ return _description; }
 40            set ...{ _description = value; }
 41        }
 42        private int _webquestId;
 43
 44        public int WebquestId
 45        ...{
 46            get ...{ return _webquestId; }
 47            set ...{ _webquestId = value; }
 48        } 
 49    #endregion
 50        public int Create()
 51        ...{
 52            try
 53            ...{
 54                AccessDB myObj = new AccessDB();
 55                myObj.SqlStr = "insert into webquest_subjects(subjectname,description) values('" + _subjectName + "','" + _description + "') ";
 56                myObj.ExecuteSqlStr();
 57                return 0;
 58            }
 59            catch (Exception a)
 60            ...{
 61
 62                throw a;
 63                return -1;
 64            }
 65        }
 66        public DataSet Retrieve()
 67        ...{
 68            AccessDB myObj = new AccessDB();
 69            myObj.SqlStr = "select * from webquest_subjects ";
 70            return myObj.ExecuteSqlStrReturnDs();
 71        }
 72        public int Update()
 73        ...{
 74            try
 75            ...{
 76                AccessDB myObj = new AccessDB();
 77                myObj.SqlStr = "update  webquest_subjects set subjectname='"+_subjectName+"',description='"+_description+"' where subjectid="+_subjectId.ToString();
 78                myObj.ExecuteSqlStr();
 79                return 0;
 80            }
 81            catch (Exception a)
 82            ...{
 83
 84                throw a;
 85                return -1;
 86            }
 87        }
 88        public int Delete()
 89        ...{
 90            try
 91            ...{
 92                AccessDB myObj = new AccessDB();
 93                myObj.SqlStr = "delete from webquest_subjects where subjectid=" + _subjectId.ToString();
 94                myObj.ExecuteSqlStr();
 95                return 0;
 96            }
 97            catch (Exception a)
 98            ...{
 99
100                throw a;
101                return -1;
102            }
103        }
104        public OleDbDataReader RetrieveById()
105        ...{ AccessDB myObj = new AccessDB();
106        myObj.SqlStr = "select * from webquest_subjects where subjectid=" + _subjectId.ToString();
107        return myObj.ExecuteSqlStrReturnDr();
108    }
109        public Subjects()
110        ...{
111            //
112            // TODO: 在此处添加构造函数逻辑
113            //
114        }
115    }
116    
117}