classtable.cs

ASP.NET+SQLServer200作的学生管理系统

using System;
using System.Text;
using System.Data;

namespace BusinessRules
{
	/// <summary>
	/// ClassTable 的摘要说明。
	/// </summary>
	public class ClassTable:IDataBaseClass
	{
		public ClassTable()
		{
		}
		string mClassID ; //班级ID
		string mClassName; //班级名称
		string mRemark; //注释

		#region 属性定义
		/// <summary>
		/// ClassID 班级ID
		/// </summary>
		public string ClassID
		{
			get
			{
				return mClassID;
			}
			set
			{
				mClassID=value;
			}
		}

		/// <summary>
		/// ClassName 班级名称
		/// </summary>
		public string ClassName
		{
			get
			{
				return mClassName;
			}
			set
			{
				mClassName=value;
			}
		}

		/// <summary>
		/// Remark 注释
		/// </summary>
		public string Remark
		{
			get
			{
				return mRemark;
			}
			set
			{
				mRemark=value;
			}
		}
		#endregion

		#region 接口要求的方法
		#region 无条件查询 Query()
		/// <summary>
		/// 无条件查询
		/// </summary>
		public DataTable Query()
		{
			DataSet ds=null;
			try
			{
				DB db=new DB();
				ds=db.GetSqlDataSet(this.GetSqlString(""));
			}
			catch(Exception e)
			{
				throw(e);
			}
			return ds.Tables[0];
		}
		#endregion

		#region 有条件查询 Query(string condition)
		/// <summary>
		/// 有条件查询
		/// </summary>
		public DataTable Query(string condition)
		{
			
			try
			{
				DB db=new DB();
				DataSet ds=db.GetSqlDataSet(this.GetSqlString(condition));
				return ds.Tables[0];
			}
			catch(Exception e)
			{
				throw(e);
			}
		}
		#endregion

		#region 根据主键查询 QueryWithKey(string keyValue)
		/// <summary>
		/// 根据主键查询
		/// </summary>
		public void QueryWithKey(string keyValue)
		{
			
			try
			{
				string cond="ClassID='"+ format(keyValue) + "'";
				DB db=new DB();
				DataSet ds=db.GetSqlDataSet(this.GetSqlString(cond));
				mClassID=ds.Tables[0].Rows[0]["ClassID"].ToString();
				mClassName=ds.Tables[0].Rows[0]["ClassName"].ToString();
				mRemark=ds.Tables[0].Rows[0]["Remark"].ToString();

			}
			catch(Exception e)
			{
				throw(e);
			}

		}
		#endregion		

		#region 添加一条记录 Insert()
		/// <summary>
		///添加一条记录
		/// </summary>
		public int Insert()
		{
			
			try
			{
				StringBuilder sql=new StringBuilder();
				sql.Append("INSERT ClassTable");
				sql.Append("(ClassName,Remark) ");
				sql.Append(" VALUES(");
				sql.Append("'"+ format(mClassName) +"'");
				sql.Append(",'"+ format(mRemark) +"'");
				sql.Append(")");		
				DB db=new DB();
				return db.ExecuteSql(sql.ToString());

			}
			catch(Exception e)
			{
				throw(e);
			}

		}

		#endregion

		#region 能否删除 string IsDelete(string keyValue)
		/// <summary>
		/// 能否删除,返回为null时，表示可以删除
		/// 返回不为空，表示为不能删除的原因
		/// </summary>
		public string IsDelete(string keyValue)
		{
			try
			{
				string temp=null;
				string cond=" ClassID=" + keyValue;
				StudentInfo myScoreTable=new StudentInfo();
				if(myScoreTable.IsExist(cond))
				{
					temp="在成绩表中存在ClassID=" + keyValue +"的值";
				}			
				return temp;
			}
			catch(Exception e)
			{
				throw(e);
			}	
			
		}
		#endregion

		#region 删除一条记录 boll Delete(string keyValue)
		/// <summary>
		/// 要求在调用IsDelete（）后使用
		/// 返回为true时，表示删除成功
		/// 返回为false时，表示删除失败
		/// </summary>
		public bool Delete(string keyValue)
		{
					

			try
			{
				StringBuilder sql=new StringBuilder();
				sql.Append(" DELETE FROM ClassTable ");
				sql.Append(" WHERE ClassID=" + keyValue);					
				DB db=new DB();
				db.ExecuteSql(sql.ToString());
				return true;
			}
			catch(Exception e)
			{
				throw(e);
			}

		}
		#endregion

		#region 有条件删除 int DeleteWithCondition(string condition)
		/// <summary>
		/// 返回值为删除的记录数
		/// 能否删除，完全依靠程序员的判断，
		/// 一般用于和其他表没有约束关系的表
		/// 说明：出现删除异常时并不表示一个都没有删除
		/// </summary>
		public int DeleteWithCondition(string condition)
		{
			
			try
			{
				StringBuilder sql=new StringBuilder();
				sql.Append("DELETE  FROM ClassTable  ");
				sql.Append("ClassName='"+ format(mClassName) + "'" );
				sql.Append(",Remark='"+ format(mRemark) + "'" );
				sql.Append(" WHERE " + condition);
				DB db=new DB();
				return db.ExecuteSql(sql.ToString());

			}
			catch(Exception e)
			{
				throw(e);
			}
		}
		#endregion

		#region 更新 Update(string condition)
		/// <summary>
		/// 更新
		/// </summary>
		public int Update(string condition)
		{
			try
			{
				StringBuilder sql=new StringBuilder();
				sql.Append("UPDATE ClassTable SET ");
				sql.Append("ClassName='"+ format(mClassName) + "'" );
				sql.Append(",Remark='"+ format(mRemark) + "'" );
				sql.Append(" WHERE " + condition);
				DB db=new DB();
				return db.ExecuteSql(sql.ToString());
			}
			catch(Exception e)
			{
				throw(e);
			}
		}

		#endregion
		
		#region 通过主键更新 UpdateWithKey(string keyValue)
		/// <summary>
		/// 通过主键更新
		/// </summary>
		public int UpdateWithKey(string keyValue)
		{
			
			try
			{
				StringBuilder sql=new StringBuilder();
				sql.Append("UPDATE ClassTable SET ");
				sql.Append("ClassName ='"+ format(mClassName) + "'" );
				sql.Append(",Remark='"+ format(mRemark) + "'" );
				sql.Append(" WHERE ClassID='" + keyValue + "'");
				DB db=new DB();
				return db.ExecuteSql(sql.ToString());

			}
			catch(Exception e)
			{
				throw(e);
			}
		}

		#endregion				

		#region 单引号的处理 format(string myString)
		/// <summary>
		/// 单引号的处理
		/// </summary>
		public string format(string myString)
		{
			return myString.Replace("'","''");
		}
		#endregion

		#region 是否存在 IsExist(string myString)
		/// <summary>
		/// 是否存在
		///返回值为true表示存在
		///返回值为false表示不存在
		/// </summary>
		public bool IsExist(string condition)
		{
		   try
			{
				
				StringBuilder sql=new StringBuilder();
				sql.Append(" SELECT ClassID FROM ClassTable ");
				sql.Append(" WHERE " + condition);
						
				DB db=new DB();
				DataSet ds;
				ds=db.GetSqlDataSet(sql.ToString());
			   if(ds.Tables[0]!=null && ds.Tables[0].Rows.Count>0)
			   {
				   return true;
			   }
			   else
			   {
				   return false;
			   }
			}
			catch(Exception e)
			{
				throw(e);
			}
			
		}
		#endregion

		#region 获取查询Sql GetSqlString(string condition)
		/// <summary>
		/// 获取查询Sql
		/// </summary>
		public string GetSqlString(string condition)
		{						
			try
			{
				StringBuilder sql=new StringBuilder();
				sql.Append("SELECT ");
				sql.Append(" ClassID,ClassName,Remark ");
				sql.Append(" FROM ClassTable");
				if(condition!="" && condition!=null)
				{
					sql.Append(" WHERE " + condition);
				}		
				return sql.ToString();

			}
			catch(Exception e)
			{
				throw(e);
			}
			
		}
		#endregion

		#endregion

		#region 自定义方法

		#endregion

	}
}