subjectoperate.cs

一个经典的东东

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

namespace Business
{
	public class SubjectOperate
	{
		DataBaseOperate dbo=null;
		/// <summary>
		/// 构造函数中实例化dbo，即DataBaseOperate类
		/// </summary>
		public SubjectOperate()
		{
			dbo=new DataBaseOperate();
		}
		/// <summary>
		/// 查询subject表中的所有信息
		/// </summary>
		/// <returns>信息返回存储为DataSet</returns>
		public DataSet selectdata()
		{
			return dbo.Search("select * from subject","subject");
		}
		/// <summary>
		/// 传入视图名，查询该视图信息
		/// </summary>
		/// <param name="viewname">视图名</param>
		/// <returns>返回结果集</returns>
		public DataSet selectbyView(string viewname)
		{
			return dbo.Search("select * from "+viewname,viewname);
		}
		/// <summary>
		/// 根据科目名查询记录集
		/// </summary>
		/// <param name="subjectname">传入科目名</param>
		/// <returns>返回结果集</returns>
		public DataSet selectbyName(string subjectname)
		{
			return dbo.Search("select * from subject where subjectname='"+subjectname+"'","subject");
		}
		/// <summary>
		/// 根据备注查看科目信息表(Subject)
		/// </summary>
		/// <param name="remark">传入remark的值</param>
		/// <returns>返回记录集</returns>
		public DataSet selectbyRemark(string remark)
		{
			return dbo.Search("select * from subject where remark='"+remark+"'","subject");
		}
		/// <summary>
		/// 向科目表添加信息
		/// </summary>
		/// <param name="subjectname">传入subjectname的值</param>
		/// <param name="remark">传入remark的值</param>
		/// <returns>成功返回true</returns>
		public bool insertdata(string subjectname,string remark)
		{
			string sql="insert into subject(subjectname,remark) values('"
				+subjectname+"','"+remark+"')";
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
		/// <summary>
		/// 删除科目表中的某条数据
		/// </summary>
		/// <param name="SubjectId">传入要删除的SubjectID</param>
		/// <returns>成功返回true</returns>
		public bool deletedata(int SubjectId)
		{
			string sql="delete Subject where subjectid="+SubjectId;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
		/// <summary>
		/// 更新科目表中某条数据
		/// </summary>
		/// <param name="subjectid">传入要更新的科目编号</param>
		/// <param name="subjectname">传入要更新的科目姓名</param>
		/// <param name="remark">传入要更新的科目备注</param>
		/// <returns>更新成功返回true</returns>
		public bool updatedata(int subjectid,string subjectname,string remark)
		{
			string sql="update subject set subjectname='"+subjectname+"',remark='"+remark+"' where subjectid="+subjectid;
			try
			{
				return dbo.Execute(sql);
			}
			catch(SqlException ex)
			{
				throw ex;
			}
			catch(Exception ex)
			{
				throw ex;
			}
		}
	}
}