scoreoperate.cs

一个经典的东东

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

namespace Business
{
	public class ScoreOperate
	{
		DataBaseOperate dbo=null;
		/// <summary>
		/// 构造函数中实例化dbo，即DataBaseOperate类
		/// </summary>
		public ScoreOperate()
		{
			dbo=new DataBaseOperate();
		}
		/// <summary>
		/// 查询Score表中的所有信息
		/// </summary>
		/// <returns>信息返回存储为DataSet</returns>
		public DataSet selectdata()
		{
			return dbo.Search("select * from Score_View","Score_View");
		}
		/// <summary>
		/// 对Score_View_Class表的className进行模糊查询
		/// </summary>
		/// <param name="classDetails">classDetails表示模糊查询的关键字</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbyDetails(string classDetails)
		{
			string sql="select * from Score_View_Class where classname like '"+classDetails+"'+'%'";
			return dbo.Search(sql,"Score_View_Class");
		}
		/// <summary>
		/// 对Score_View表的studentname进行查询
		/// </summary>
		/// <param name="studentname">studentname</param>
		/// <returns></returns>
		public DataSet selectwithStudentnameinScore_View(string studentname)
		{
			string sql="select * from Score_View where studentname='"+studentname+"'";
			return dbo.Search(sql,"Score_View");
		}
		/// <summary>
		/// 根据班级名查询Score_View_Class的信息
		/// </summary>
		/// <param name="classname">传入班级名</param>
		/// <returns>返回Score_View_Class记录集</returns>
		public DataSet selectbyname(string classname)
		{
			string sql="select * from Score_View_Class where classname='"+classname+"'";
			return dbo.Search(sql,"Score_View_Class");
		}
		/// <summary>
		///  对Score_View_Class表的className进行模糊查询,提取出没有重复的studentname
		/// </summary>
		/// <param name="classDetail">classDetails表示模糊查询的关键字</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbyStudentDetail(string classDetails)
		{
			string sql="select Distinct(studentname) from Score_View_Class where classname like '"+classDetails+"'+'%'";
			return dbo.Search(sql,"Score_View_Class");
		}
		/// <summary>
		/// 根据班级名查询Score_View_Class的信息,提取出没有重复的studentname
		/// </summary>
		/// <param name="classname">传入班级名</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbyStudentname(string classname)
		{
			string sql="select Distinct(studentname) from Score_View_Class where classname='"+classname+"'";
			return dbo.Search(sql,"Score_View_Class");
		}
		/// <summary>
		/// 根据学生姓名查询Score_View_Class的信息
		/// </summary>
		/// <param name="classname">传入学生姓名</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbySName(string studentname)
		{
			string sql="select * from Score_View_Class where studentname='"+studentname+"'";
			return dbo.Search(sql,"Score_View_Class");
		}
		/// <summary>
		/// 添加成绩信息
		/// </summary>
		/// <param name="courseid">courseid</param>
		/// <param name="studentid">studentid</param>
		/// <param name="score">score</param>
		/// <returns>成功返回true</returns>
		public bool insertdata(int courseid,int studentid,int score)
		{
			string sql="insert into score(courseid,studentid,score) values("
				+courseid+","+studentid+",'"+score+"')";
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
		/// <summary>
		/// 根据courseid,studentid对表score进行查询
		/// </summary>
		/// <param name="courseid">courseid</param>
		/// <param name="studentid">studentid</param>
		/// <returns>返回记录集DataSet</returns>
		public DataSet selectbycourseidstudentid(int courseid,int studentid)
		{
			string sql="select * from score where courseid="+courseid+" and studentid="+studentid+"";
			return dbo.Search(sql,"student");
		}
		/// <summary>
		/// 删除score中某个scoreid的值
		/// </summary>
		/// <param name="ScoreID">scoreid</param>
		/// <returns>成功返回true</returns>
		public bool deletedata(int ScoreID)
		{
			string sql="delete score where scoreID="+ScoreID;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
		/// <summary>
		/// 更新score中某条数据
		/// </summary>
		/// <param name="scoreid">传入要更新的scoreid</param>
		/// <param name="courseid">courseid</param>
		/// <param name="studentid">studentid</param>
		/// <param name="score">score</param>
		/// <returns>成功返回true</returns>
		public bool updatedata(int scoreid,int courseid,int studentid,int score)
		{
			string sql="update score set courseid="
				+courseid+",studentid="
				+studentid+",score="
				+score+" where scoreid="
				+scoreid;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
	}
}