courseoperate.cs

一个经典的东东

using System;
using DataAccess;
using System.Data;
using System.Data.SqlClient;

namespace Business
{
	public class CourseOperate
	{
		DataBaseOperate dbo=null;
		/// <summary>
		/// 构造函数中实例化dbo，即DataBaseOperate类
		/// </summary>
		public CourseOperate()
		{
			dbo=new DataBaseOperate();
		}
		/// <summary>
		/// 添加课程信息
		/// </summary>
		/// <param name="classid">班级编号</param>
		/// <param name="subjectid">课程编号</param>
		/// <param name="BeginDate">开课时间</param>
		/// <param name="FinishDate">结束时间</param>
		/// <param name="Remark">备注</param>
		/// <returns>成功返回true</returns>
		public bool insertdata(int classid,int subjectid,string BeginDate,string FinishDate,string Remark)
		{
			string sql="insert into course(classid,subjectid,begindate,finishdate,remark) values("
				+classid+","+subjectid+",'"+BeginDate+"','"+FinishDate+"','"+Remark+"')";
			try
			{
				dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
			return true;
		}

		/// <summary>
		/// 删除course表中的某条记录
		/// </summary>
		/// <param name="ClassId">传入要删除的courseid号</param>
		/// <returns>成功返回true</returns>
		public bool deletedata(int CourseId)
		{
			string sql="delete course where courseid="+CourseId;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
		/// <summary>
		/// 查询course_view视图的信息
		/// </summary>
		/// <returns>course_view表的记录集</returns>
		public DataSet selectdata()
		{
			return dbo.Search("select * from course_view","course_view");
		}
		/// <summary>
		/// 根据班级名查询course_view视图的信息
		/// </summary>
		/// <param name="classname">传入班级名</param>
		/// <returns>返回course_view记录集</returns>
		public DataSet selectbyname(string classname)
		{
			string sql="select * from course_view where classname='"+classname+"'";
			return dbo.Search(sql,"course_view");
		}
		/// <summary>
		/// 对course_view表的className进行模糊查询,
		/// </summary>
		/// <param name="classDetails">classDetails表示模糊查询的关键字</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbyDetails(string classDetails)
		{
			string sql="select * from course_view where classname like '"+classDetails+"'+'%'";
			return dbo.Search(sql,"course_view");
		}
		/// <summary>
		/// 根据subjectname对course_view表进行查询
		/// </summary>
		/// <param name="subjectname">传入subjectname</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbysubjectname(string subjectname)
		{
			string sql="select * from course_view where subjectname like '%'+'"+subjectname+"'+'%'";
			return dbo.Search(sql,"course_view");
		}
		/// <summary>
		/// 根据学期名对course_subject_view表进行查询
		/// </summary>
		/// <param name="xueqi">传入学期名</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbyxueqiname(string xueqi)
		{
			string sql="select * from course_view where remark like '%'+'"+xueqi+"'+'%'";
			return dbo.Search(sql,"course_view");
		}
		/// <summary>
		/// 根据classid,subjectid对表进行查询
		/// </summary>
		/// <param name="classid">传入classid,subjectid</param>
		/// <param name="subjectid">返回结果集</param>
		/// <returns></returns>
		public DataSet selectbyclassidsubjectid(int classid,int subjectid)
		{
			string sql="select * from course where classid="+classid+" and subjectid="+subjectid;
			return dbo.Search(sql,"course");
		}
		/// <summary>
		/// 更新course表中的某条记录
		/// </summary>
		/// <param name="CourseId">传入要更新的courseid号</param>
		/// <param name="ClassId">传入要更新的classid号</param>
		/// <param name="SubjectId">传入要更新的subjectid号</param>
		/// <param name="opendate">传入要更新的opendate值</param>
		/// <param name="enddate">传入要更新的enddate值</param>
		/// <param name="remark">传入要更新的remark值</param>
		/// <returns>成功返回true</returns>
		public bool updatedata(int CourseId,int ClassId,int SubjectId
			,string opendate,string enddate,string remark)
		{
			string sql="update course set classid="+ClassId+",subjectid="
				+SubjectId+",begindate='"+opendate
				+"',finishdate='"+enddate+"',remark='"+remark+"' where courseid="+CourseId;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
		/// <summary>
		/// 按照classid查找
		/// </summary>
		/// <param name="classid">classid</param>
		/// <returns>返回DataSet</returns>
		public DataSet getsubjectid(int classid)
		{
			return dbo.Search("select subjectname from subject where subjectid in (select subjectid from course where classid in(select classid from student where classid="+classid+"))","course");
		}
	}
}