studentmanager.cs

C#2.0宝典源码,C#经典书籍,很多例子

using System;
using System.Data.OleDb;
using StudentsMIS.DataAccess;

namespace StudentsMIS.Business
{
	/// <summary>
	/// StudentManager 的摘要说明。
	/// </summary>
	public class StudentManager : IManager
	{
		public StudentManager()
		{
			
		}

    public IEntity Select(string id)
    {
      StudentEntity entity = new StudentEntity();
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("SELECT students.*, speciality.*, colleges.* FROM (colleges INNER JOIN speciality ON colleges.college_ID = speciality.speciality_college) INNER JOIN (classes INNER JOIN students ON classes.class_ID = students.student_class) ON speciality.speciality_ID = classes.class_speciality Where students.student_ID=@StudentID");
      objCommand.Parameters.Add("@StudentID",id);
      OleDbDataReader objReader = objCommand.ExecuteReader();
      if(objReader.Read())
      {
        entity.StudentID = id;
        entity.StudentName = objReader["student_name"].ToString().Trim();
        entity.StudentSex = objReader["student_sex"].ToString().Trim();
        entity.StudentIDCardNum = objReader["student_IDCardNum"].ToString().Trim();
        entity.StudentCollegeID = objReader["college_ID"].ToString().Trim();
        entity.StudentCollegeName = objReader["college_name"].ToString().Trim();
        entity.StudentSpecialityID = objReader["speciality_ID"].ToString().Trim();
        entity.StudentSpecialityName = objReader["speciality_name"].ToString().Trim();
        entity.StudentClass = objReader["student_class"].ToString().Trim();
        entity.StudentEnterYear = objReader["student_enterYear"].ToString().Trim();
        entity.StudentStuType = objReader["student_stuType"].ToString().Trim();
        entity.StudentBirthday = System.DateTime.Parse(objReader["student_birthday"].ToString().Trim());
        entity.StudentNative = objReader["student_native"].ToString().Trim();
        entity.StudentHomeAdd = objReader["student_homeAdd"].ToString().Trim();
        entity.StudentHomeTel = objReader["student_homeTel"].ToString().Trim();
        entity.StudentFlatTel = objReader["student_flatTel"].ToString().Trim();
        entity.StudentMobile = objReader["student_mobile"].ToString().Trim();
        entity.StudentEmail = objReader["student_email"].ToString().Trim();
      }
      return entity;

    }

    public int Insert(IEntity obj)
    {
      StudentEntity entity = (StudentEntity)obj;
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select student_ID From students Where student_ID=@StudentID");
      objCommand.Parameters.Add("@StudentID",entity.StudentID);
      if(objCommand.ExecuteReader().HasRows)
      {
        CommandCloser.CloseOleDbCommand(objCommand);
        return 0;
      }
      objCommand = CommandBuilder.BuildOleDbCommand("Insert Into students(student_ID,student_name,student_password,student_sex,student_class,student_IDCardNum,student_birthday,student_native,student_enterYear,student_stuType,student_homeAdd,student_homeTel,student_flatTel,student_mobile,student_email) values(@StudentID,@StudentName,@StudentPassword,@StudentSex,@StudentClass,@StudentIDCardNum,@StudentBirthday,@StudentNative,@StudentEnterYear,@StudentStuType,@StudentHomeAdd,@StudentHomeTel,@StudentFlatTel,@StudentMobile,@StudentEmail)");
      objCommand.Parameters.Add("@StudentID",entity.StudentID);
      objCommand.Parameters.Add("@StudentName",entity.StudentName);
      objCommand.Parameters.Add("@StudentPassword",entity.StudentPassword);
      objCommand.Parameters.Add("@StudentSex",entity.StudentSex);
      objCommand.Parameters.Add("@StudentClass",entity.StudentClass);
      objCommand.Parameters.Add("@StudentIDCardNum",entity.StudentIDCardNum);
      objCommand.Parameters.Add("@StudentBirthday",entity.StudentBirthday);
      objCommand.Parameters.Add("@StudentNative",entity.StudentNative);
      objCommand.Parameters.Add("@StudentEnterYear",entity.StudentEnterYear);
      objCommand.Parameters.Add("@StudentStuType",entity.StudentStuType);
      objCommand.Parameters.Add("@StudentHomeAdd",entity.StudentHomeAdd);
      objCommand.Parameters.Add("@StudentHomeTel",entity.StudentHomeTel);
      objCommand.Parameters.Add("@StudentFlatTel",entity.StudentFlatTel);
      objCommand.Parameters.Add("@StudentMobile",entity.StudentMobile);
      objCommand.Parameters.Add("@StudentEmail",entity.StudentEmail);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
      return 1;
    }

    public void Delete(string id)
    {
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Delete From students Where student_ID=@StudentID");
      objCommand.Parameters.Add("@StudentID",id);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
    }

    public int Update(IEntity obj)
    {
      StudentEntity entity = (StudentEntity)obj;
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select student_ID From students Where student_ID=@StudentID");
      objCommand.Parameters.Add("@StudentID",entity.StudentID);
      if(!objCommand.ExecuteReader().HasRows)
      {
        CommandCloser.CloseOleDbCommand(objCommand);
        return 0;
      }
      objCommand = CommandBuilder.BuildOleDbCommand("Update students Set student_name=@StudentName,student_password=@StudentPassword,student_sex=@StudentSex,student_IDCardNum=@StudentIDCardNum,student_birthday=@StudentBirthday,student_native=@StudentNative,student_enterYear=@StudentEnterYear,student_stuType=@StudentStuType,student_homeAdd=@StudentHomeAdd,student_homeTel=@StudentHomeTel,student_flatTel=@StudentFlatTel,student_mobile=@StudentMobile,student_email=@StudentEmail Where student_ID=@StudentID");
      objCommand.Parameters.Add("@StudentName",entity.StudentName);
      objCommand.Parameters.Add("@StudentPassword",entity.StudentPassword);
      objCommand.Parameters.Add("@StudentSex",entity.StudentSex);
      objCommand.Parameters.Add("@StudentIDCardNum",entity.StudentIDCardNum);
      objCommand.Parameters.Add("@StudentBirthday",entity.StudentBirthday);
      objCommand.Parameters.Add("@StudentNative",entity.StudentNative);
      objCommand.Parameters.Add("@StudentEnterYear",entity.StudentEnterYear);
      objCommand.Parameters.Add("@StudentStuType",entity.StudentStuType);
      objCommand.Parameters.Add("@StudentHomeAdd",entity.StudentHomeAdd);
      objCommand.Parameters.Add("@StudentHomeTel",entity.StudentHomeTel);
      objCommand.Parameters.Add("@StudentFlatTel",entity.StudentFlatTel);
      objCommand.Parameters.Add("@StudentMobile",entity.StudentMobile);
      objCommand.Parameters.Add("@StudentEmail",entity.StudentEmail);
      objCommand.Parameters.Add("@StudentID",entity.StudentID);      
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
      return 1;
    }
	}
}