studentinfo.cs

1、该系统只是测试一下本人设计的类库是否正确。 2、只包含一些简单的查询(主键

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

namespace BusinessRules
{
	/// <summary>
	/// StudentInfo 的摘要说明。
	/// </summary>
	public class StudentInfo:IDataBaseClass
	{
		public StudentInfo()
		{
		}
		string mStudentID;      //学生ID
		string mOrganizationID; //组织机构ID
		string mGradeID;        //班级ID
		string mRoleID;	        //角色ID
		string mNationCodeID;   //民族ID
		string mStudentName;    //学生姓名
		string mSex;			//学生姓别
		string mBirthDay;		//学生生日
		string mPassword;		//用户密码

		#region 属性定义
		/// <summary>
		/// StudentID 学生ID
		/// </summary>
		public string StudentID
		{
			get
			{
				return mStudentID;
			}
			set
			{
				mStudentID=value;
			}
		}
		/// <summary>
		/// OrganizationID 组织机构ID
		/// </summary>
		public string OrganizationID
		{
			get
			{
				return mOrganizationID;
			}
			set
			{
				mOrganizationID=value;
			}
		}

		/// <summary>
		/// GradeID 班级ID
		/// </summary>
		public string GradeID
		{
			get
			{
				return mGradeID;
			}
			set
			{
				mGradeID=value;
			}
		}
		/// <summary>
		/// RoleID 角色ID
		/// </summary>
		public string RoleID
		{
			get
			{
				return mRoleID;
			}
			set
			{
				mRoleID=value;
			}
		}
		/// <summary>
		/// NationCodeID 民族ID
		/// </summary>
		public string NationCodeID
		{
			get
			{
				return mNationCodeID;
			}
			set
			{
				mNationCodeID=value;
			}
		}
		/// <summary>
		/// StudentName 学生姓名
		/// </summary>
		public string StudentName
		{
			get
			{
				return mStudentName;
			}
			set
			{
				mStudentName=value;
			}
		}
		/// <summary>
		/// Sex 学生性别
		/// </summary>
		public string Sex
		{
			get
			{
				return mSex;
			}
			set
			{
				mSex=value;
			}
		}
		/// <summary>
		/// BirthDay 出生日期
		/// </summary>
		public string BirthDay
		{
			get
			{
				return mBirthDay;
			}
			set
			{
				mBirthDay=value;
			}
		}
		/// <summary>
		/// Password 用户密码
		/// </summary>
		public string Password
		{
			get
			{
				return mPassword;
			}
			set
			{
				mPassword=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)
		{
			DataSet ds=null;
			try
			{
				DB db=new DB();
				ds=db.GetSqlDataSet(this.GetSqlString(condition));
			}
			catch(Exception e)
			{
				throw e;
			}
			return ds.Tables[0];
		}
		#endregion

		#region 根据主键查询 QueryWithKey(string keyValue)
		/// <summary>
		/// 根据主键查询
		/// </summary>
		public void QueryWithKey(string keyValue)
		{
			DataSet ds=null;
			try
			{
				string cond="StudentID='"+ format(keyValue)+"'" ;
				DB db=new DB();
				ds=db.GetSqlDataSet(this.GetSqlString(cond));
				mStudentID=ds.Tables[0].Rows[0]["StudentID"].ToString();
				mOrganizationID=ds.Tables[0].Rows[0]["OrganizationID"].ToString();
				mGradeID=ds.Tables[0].Rows[0]["GradeID"].ToString();
				mRoleID=ds.Tables[0].Rows[0]["RoleID"].ToString();
				mNationCodeID=ds.Tables[0].Rows[0]["NationCodeID"].ToString();
				mStudentName=ds.Tables[0].Rows[0]["StudentName"].ToString();
				mSex=ds.Tables[0].Rows[0]["Sex"].ToString();
				mBirthDay=ds.Tables[0].Rows[0]["BirthDay"].ToString();
				mPassword=ds.Tables[0].Rows[0]["Password"].ToString();
			}
			catch(Exception e)
			{
				throw(e);
			}
		}
		#endregion		

		#region 添加一条记录 Insert()
		/// <summary>
		///添加一条记录
		/// </summary>
		public int Insert()
		{
			StringBuilder sql=new StringBuilder();
			DB db=new DB();
			try
			{
				sql.Append("INSERT StudentInfo");
				sql.Append("(StudentID,OrganizationID,GradeID,RoleID,NationCodeID,StudentName,Sex,BirthDay,Password) ");
				sql.Append(" VALUES(");
				sql.Append("'"+ format(mStudentID) +"'");
				sql.Append(",'"+ format(mOrganizationID) +"'");
				sql.Append(",'"+ format(mGradeID) +"'");
				sql.Append(",'"+ format(mRoleID) +"'");
				sql.Append(",'"+ format(mNationCodeID) +"'");
				sql.Append(",'"+ format(mStudentName) +"'");
				sql.Append(",'"+ format(mSex) +"'");
				sql.Append(",'"+ format(mBirthDay) +"'");			
				sql.Append(",'"+ format(mPassword) +"'");
				sql.Append(")");
			}
			catch(Exception e)
			{
				throw(e);
			}
			return db.ExecuteSql(sql.ToString());
		}

		#endregion

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

		#region 删除一条记录 boll Delete(string keyValue)
		/// <summary>
		/// 要求在调用IsDelete（）后使用
		/// 返回为true时，表示删除成功
		/// 返回为false时，表示删除失败
		/// </summary>
		public bool Delete(string keyValue)
		{
			StringBuilder sql=new StringBuilder();
			DB db=new DB();
			try
			{
				sql.Append(" DELETE FROM StudentInfo ");
				sql.Append(" WHERE StudentID='" + keyValue+"'");
				db.ExecuteSql(sql.ToString());
			}
			catch(Exception e)
			{
				throw(e);
			}
			return true;
		}
		#endregion

		#region 有条件删除 int DeleteWithCondition(string condition)
		/// <summary>
		/// 要求在调用IsDelete（）后使用
		/// 返回为true时，表示删除成功
		/// 返回为false时，表示删除失败
		/// 返回值为删除的记录数
		/// 能否删除，完全依靠程序员的判断，
		/// 一般用于和其他表没有约束关系的表
		/// 说明：出现删除异常时并不表示一个都没有删除
		/// </summary>
		public int DeleteWithCondition(string condition)
		{
			StringBuilder sql=new StringBuilder();
			DB db=new DB();
			try
			{
				sql.Append(" DELETE FROM StudentInfo ");
				sql.Append(" WHERE " + condition);		
			}
			catch(Exception e)
			{
				throw(e);
			}
			return db.ExecuteSql(sql.ToString());
		}
		#endregion

		#region 更新 Update(string condition)
		/// <summary>
		/// 根据条件更新
		/// 返回值为int  为影响多少行
		/// </summary>
		public int Update(string condition)
		{
			StringBuilder sql=new StringBuilder();
			DB db=new DB();
			try
			{
				sql.Append("UPDATE StudentInfo SET ");
				sql.Append("OrganizationID='"+ format(mOrganizationID) + "'" );
				sql.Append(",GradeID='"+ format(mGradeID) + "'" );
				sql.Append(",RoleID='"+ format(mRoleID) + "'" );
				sql.Append(",NationCodeID='"+ format(mNationCodeID) + "'" );
				sql.Append(",StudentName='"+ format(mStudentName) + "'" );
				sql.Append(",Sex='"+ format(mSex) + "'" );
				sql.Append(",BirthDay='"+ format(mBirthDay) + "'" );
				sql.Append(",Password='"+ format(mPassword) + "'" );
				sql.Append(" WHERE " + condition);
			}
			catch(Exception e)
			{
				throw(e);
			}
			return db.ExecuteSql(sql.ToString());
		}

		#endregion
		
		#region 通过主键更新 UpdateWithKey(string keyValue)
		/// <summary>
		/// 通过主键更新
		/// </summary>
		public int UpdateWithKey(string keyValue)
		{
			StringBuilder sql=new StringBuilder();
			DB db=new DB();
			try
			{
				sql.Append("UPDATE StudentInfo SET ");
				sql.Append("OrganizationID='"+ format(mOrganizationID) + "'" );
				sql.Append(",GradeID='"+ format(mGradeID) + "'" );
				sql.Append(",RoleID='"+ format(mRoleID) + "'" );
				sql.Append(",NationCodeID='"+ format(mNationCodeID) + "'" );
				sql.Append(",StudentName='"+ format(mStudentName) + "'" );
				sql.Append(",Sex='"+ format(mSex) + "'" );
				sql.Append(",BirthDay='"+ format(mBirthDay) + "'" );
				sql.Append(",Password='"+ format(mPassword) + "'" );
				sql.Append(" WHERE StudentID='" + keyValue+"'");
			}
			catch(Exception e)
			{
				throw(e);
			}
			return db.ExecuteSql(sql.ToString());
		}

		#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)
		{
			
			StringBuilder sql=new StringBuilder();
			DB db=new DB();
			DataSet ds;
			try
			{
				sql.Append(" SELECT StudentID FROM StudentInfo ");
				sql.Append(" WHERE " + condition);
				ds=db.GetSqlDataSet(sql.ToString());
			}
			catch(Exception e)
			{
				throw(e);
			}
			if(ds.Tables[0]!=null && ds.Tables[0].Rows.Count>0)
			{
				return true;
			}
			else
			{
				return false;
			}
			
		}
		#endregion

		#region 获取查询Sql GetSqlString(string condition)
		/// <summary>
		/// 获取查询Sql
		/// </summary>
		public string GetSqlString(string condition)
		{						
			StringBuilder sql=new StringBuilder();
			try
			{
				sql.Append("SELECT ");
				sql.Append(" StudentID,OrganizationID,GradeID,RoleID,NationCodeID,StudentName,Sex,BirthDay,Password ");
				sql.Append(" FROM StudentInfo");
				if(condition!="" && condition!=null)
				{
					sql.Append(" WHERE " + condition);
				}
			}
			catch(Exception e)
			{
				throw(e);
			}
			return sql.ToString();
			
		}
		#endregion
		
		#endregion

		#region 自定义方法

		#endregion

	}
}