classs.cs

大二做的课程设计。一个学生信息管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace StudentLibrary.Business
{
    using StudentLibrary.DataAccess;
    /// <summary>
    /// Classs 的摘要说明。
    /// </summary>
    public class Classs
    {
        private DataBaseOperate cDbObject = null;
        private bool bConn = false;


        public Classs()
        {
            cDbObject = new DataBaseOperate();
            bConn = false;
        }


        public Classs(DataBaseOperate dbOperate)
        {
            cDbObject = dbOperate;
            bConn = true;
        }

        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(true);
        }
        /// <summary>
        /// 功能：通过传过来的班级号，查询班级课程
        /// 由frmUpdateClass的窗体的getCourses()函数调用
        /// </summary>
        /// <param name="iClassId">班级号</param>
        /// <returns>返回含有该班级的数据集</returns>
        public DataSet SelectClassCourse(
            int iClassId)
        {
            string sSql =

                "select a.*,"
                + " (select top 1 courseid from course b where b.subjectid = a.subjectid and b.classId = " + iClassId.ToString() + ") courseid"
                + " from subject a";

            DataSet dataSet = new DataSet();
            try
            {
                dataSet = cDbObject.Search(sSql, "Course");
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            return dataSet;

        }
        /// <summary>
        /// 功能：修改班级
        /// 由frmUpdateClass窗体的btn_submit()方法调用
        /// </summary>
        /// <param name="iClassId">班级号</param>
        /// <param name="sClassName">班级名</param>
        /// <param name="dEntranceDate">入学日期</param>
        /// <param name="sRemark">备注</param>
        /// <returns>修改成功返回true</returns>
        public bool UpdateClass(
            int iClassId,
            string sClassName,
            DateTime dEntranceDate,
            string sRemark)
        {
            string sSql =
                "update Class"
                + " set ClassName = '" + sClassName + "'"
                + ",EntranceDate = '" + dEntranceDate.ToString() + "'"
                + ",Remark = '" + sRemark + "'"
                + " where ClassId = " + iClassId.ToString();

            try
            {
                cDbObject.Execute(sSql);
            }
            catch (Exception e)
            {
                throw (e);
            }
            return true;
        }
        /// <summary>
        /// 功能：新建班级
        /// 由frmNewClass的 窗体的btn_submit_Click()方法调用
        /// </summary>
        /// <param name="sClassName">班级名</param>
        /// <param name="dEntranceDate">入学日期</param>
        /// <param name="sRemark">备注</param>
        /// <returns>新建班级成功返回ture</returns>
        public bool InsertClass(
            string sClassName,
            DateTime dEntranceDate,
            string sRemark)
        {
            string sSql =
                " insert Class("
                + " ClassName"
                + ",EntranceDate"
                + ",Remark"
                + ")"
                + " values("
                + " '" + sClassName + "'"
                + ",'" + dEntranceDate.ToString() + "'"
                + ",'" + sRemark + "'"
                + ")";

            try
            {
                cDbObject.Execute(sSql);
            }
            catch (Exception e)
            {
                throw (e);
            }
            return true;
        }
        /// <summary>
        /// 功能：获得所有的班级
        /// 由frmMain窗体加载时，此窗体的getClass()方法调用
        /// </summary>
        /// <param name="iClassId">班级号（-1）</param>
        /// <param name="sClassName">班级名（""）</param>
        /// <returns>成功返回true</returns>
        public DataSet SelectClass(
            int iClassId,
            string sClassName)
        {
            string sSql =
                " select *"
                + " from Class"
                + " where 1 = 1";
            if (iClassId != -1)
            {
                sSql += " and ClassId = " + iClassId.ToString();
            }
            if (sClassName != "")
            {
                sSql += " and ClassName like '%" + sClassName + "%'";
            }

            DataSet dataSet = new DataSet();
            try
            {
                dataSet = cDbObject.Search(sSql, "Class");
            }
            catch (Exception e)
            {
                throw (e);
            }

            return dataSet;
        }
        /// <summary>
        /// 功能：删除班级
        /// 由frmUpdateClass窗体的btnDelete_Click()方法调用
        /// </summary>
        /// <param name="iClassId">班级号</param>
        /// <returns>成功返回true</returns>
        public bool DeleteClass(
            int iClassId)
        {
            string sSql = "delete Class where ClassId = " + iClassId.ToString();
            try
            {
                cDbObject.Execute(sSql);
            }
            catch (Exception e)
            {
                throw (e);
            }

            return true;
        }
        /// <summary>
        /// 功能：关闭数据库
        /// </summary>
        /// <param name="disposing"></param>
        public virtual void Dispose(bool disposing)
        {
            if (!disposing)
            {
                return;
            }

            if (!bConn)
            {
                cDbObject.CloseDataBase();
            }
        }

    }
}