classoperate.cs

一个经典的东东

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

namespace Business
{
	public class ClassOperate
	{
		DataBaseOperate dbo=null;
		/// <summary>
		/// 构造函数中实例化dbo，即DataBaseOperate类
		/// </summary>
		public ClassOperate()
		{
			dbo=new DataBaseOperate();
		}
		/// <summary>
		/// 添加班级信息
		/// </summary>
		/// <param name="ClassName">班级创建名称</param>
		/// <param name="EntranceDate">创建时间</param>
		/// <param name="Remark">备注</param>
		/// <returns>插入成功返回true</returns>
		public bool insertdata(string ClassName,string EntranceDate,string Remark)
		{
			string sql="insert into class values('"+ClassName
				+"','"+EntranceDate+"','"+Remark+"')";
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}

		/// <summary>
		/// 删除class表中的某条记录
		/// </summary>
		/// <param name="ClassId">传入要删除的classid号</param>
		/// <returns>成功返回true</returns>
		public bool deletedata(string ClassId)
		{
			string sql="delete class where ClassID="+ClassId;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}

		/// <summary>
		/// 更新class表中的某条记录
		/// </summary>
		/// <param name="ClassId">传入要更新的classid号</param>
		/// <param name="ClassName">传入更新后的classname</param>
		/// <param name="EntranceDate">传入更新后的EntranceDate</param>
		/// <param name="Remark">传入更新后的Remark</param>
		/// <returns>更新成功返回true</returns>
		public bool updatedata(string ClassId,string ClassName,string EntranceDate,string Remark)
		{
			string sql="update class set ClassName='"+ClassName+"',EntranceDate='"
				+EntranceDate+"',Remark='"+Remark+"' where ClassId="+ClassId;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
		/// <summary>
		/// 查询class表中的所有信息
		/// </summary>
		/// <returns>信息返回存储为DataSet</returns>
		public DataSet selectdata()
		{
			return dbo.Search("select * from class","class");
		}
		/// <summary>
		/// 根据班级名称查询班级信息
		/// </summary>
		/// <returns></returns>
		public DataSet selectbyname(string classname)
		{
			string sql="select * from class where classname='"+classname+"'";
			return dbo.Search(sql,"class");
		}
		/// <summary>
		/// 对班级表的className进行模糊查询,
		/// </summary>
		/// <param name="classDetails">classDetails表示模糊查询的关键字</param>
		/// <returns>返回DataSet存储查询结果</returns>
		public DataSet selectbyDetails(string classDetails)
		{
			string sql="select * from class where classname like '"+classDetails+"'+'%'";
			return dbo.Search(sql,"class");
		}
	}
}