studentoperate.cs

一个经典的东东

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

namespace Business
{
	public class StudentOperate
	{
		DataBaseOperate dbo=null;
		/// <summary>
		/// 构造函数中实例化dbo，即DataBaseOperate类
		/// </summary>
		public StudentOperate()
		{
			dbo=new DataBaseOperate();
		}
		/// <summary>
		/// 查询student_class_view的信息
		/// </summary>
		/// <returns>student_class_view表的记录集</returns>
		public DataSet selectdata()
		{
			return dbo.Search("select * from student_class_view","student_class_view");
		}
		/// <summary>
		/// 根据班级名查询student_class_view的信息
		/// </summary>
		/// <param name="classname">传入班级名</param>
		/// <returns>返回student_class_view记录集</returns>
		public DataSet selectbyname(string classname)
		{
			string sql="select * from student_class_view where classname='"+classname+"'";
			return dbo.Search(sql,"student_class_view");
		}
		/// <summary>
		/// 对student_class_view表的className进行模糊查询,
		/// </summary>
		/// <param name="classDetails">classDetails表示模糊查询的关键字</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbyDetails(string classDetails)
		{
			string sql="select * from student_class_view where classname like '"+classDetails+"'+'%'";
			return dbo.Search(sql,"student_class_view");
		}
		/// <summary>
		/// 根据学期名对student_course_view表进行查询
		/// </summary>
		/// <param name="xueqi">传入学期名</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbyxueqiname(string xueqi)
		{
			string sql="select StudentId,StudentNO,StudentName,Sex,Birthday,classname,remark from student_course_view where classname like '%'+'"+xueqi+"'+'%'";
			return dbo.Search(sql,"student_course_view");
		}
		/// <summary>
		/// 根据subjectname对student_course_view表进行查询
		/// </summary>
		/// <param name="subjectname">传入subjectname</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbysubjectname(string subjectname)
		{
			string sql="select StudentId,StudentNO,StudentName,Sex,Birthday,classname,remark from student_course_view where subjectname like '%'+'"+subjectname+"'+'%'";
			return dbo.Search(sql,"student_course_view");
		}
		/// <summary>
		/// 添加学生信息
		/// </summary>
		/// <param name="StudentNO">学号</param>
		/// <param name="StudentName">学生姓名</param>
		/// <param name="Gender">性别</param>
		/// <param name="Birthday">出生日期</param>
		/// <param name="ClassId">班级ID</param>
		/// <param name="Remark">备注</param>
		/// <returns></returns>
		public bool insertdata(string StudentNO,string StudentName,int Gender,string Birthday,int ClassId,string Remark)
		{
			string sql="insert into student(studentno,studentname,gender,Birthday,ClassId,remark) values('"
				+StudentNO+"','"+StudentName+"',"+Gender+",'"+Birthday+"',"+ClassId+",'"+Remark+"')";
			try
			{
				dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
			return true;
		}
		/// <summary>
		/// 按学号查找学生信息
		/// </summary>
		/// <param name="StudentNo">输入学号</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbyStudentNo(string StudentNo)
		{
			return dbo.Search("select * from student where studentNO='"+StudentNo+"'","student");
		}
		/// <summary>
		/// 删除student表中的某条记录
		/// </summary>
		/// <param name="StudentId">传入要删除的studentid号</param>
		/// <returns>成功返回true</returns>
		public bool deletedata(int StudentId)
		{
			string sql="delete student where studentid="+StudentId;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
		/// <summary>
		/// 更新student表中的数据
		/// </summary>
		/// <param name="studentid">传入要更新的studentid</param>
		/// <param name="studentno">传入要更新的studentno</param>
		/// <param name="studentname">传入要更新的studentname</param>
		/// <param name="gender">传入要更新的gender</param>
		/// <param name="birthday">传入要更新的birthday</param>
		/// <param name="classid">传入要更新的classid</param>
		/// <param name="remark">传入要更新的remark</param>
		/// <returns>成功返回true</returns>
		public bool updatedata(int studentid,string studentno,string studentname,
			int gender,string birthday,int classid,string remark)
		{
			string sql="update student set studentno='"
				+studentno+"',studentname='"
				+studentname+"',gender="
				+gender+",birthday='"
				+birthday+"',classid="
				+classid+",remark='"
				+remark+"' where studentid="+studentid;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
		/// <summary>
		/// 按学生姓名查找学生信息（学生重名是个漏洞）
		/// </summary>
		/// <param name="studentname">传入学生姓名</param>
		/// <returns>返回DataSet</returns>
		public DataSet selectbyStudentName(string studentname)
		{
			return dbo.Search("select * from student where studentname='"+studentname+"'","student");
		}
	}
}