major.cs

学生成绩管理系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;
using TeachHelper.DataAccessLayer;


namespace TeachHelper.BusinessLogicLayer
{
    /// <summary>
    /// Summary description for Major
    /// </summary>
    public class Major
    {
        public Major()
        {
        }

        public static int GetId(string name)
        {
            string sqlCommand = string.Format("SELECT Id FROM TeachHelper_Major WHERE (Name = '{0}')", name);
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
            int id = Convert.ToInt32(db.ExecuteScalar(dbCommand));
            return id;
        }

        public static string GetName(int id)
        {
            string sqlCommand = string.Format("SELECT Name FROM TeachHelper_Major WHERE (Id = {0})", id.ToString());
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
            string name = (string)db.ExecuteScalar(dbCommand);
            return name;
        }

        public static DataSet GetCollect()
        {
            string sqlCommand = "SELECT * FROM TeachHelper_Major";
            return DataAccess.ExecuteDataSet(sqlCommand);
        }

        public static DataSet GetCollectByDepartmentId(int departmentId)
        {
            string sqlCommand = string.Format("SELECT * FROM TeachHelper_Major WHERE (DepartmentId = {0})", departmentId.ToString());
            return DataAccess.ExecuteDataSet(sqlCommand);
        }

        public static void Add(string name, int departmentId)
        {
            string sqlCommand = string.Format("INSERT INTO TeachHelper_Major (Name,DepartmentId) VALUES ('{0}',{1})", name, departmentId.ToString());
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);

            try
            {
                db.ExecuteNonQuery(dbCommand);
            }
            catch (Exception ex)
            {

                throw new Exception("该专业已存在");
            }
        }

        public static void Update(int id, string name)
        {
            string sqlCommand = string.Format("UPDATE TeachHelper_Major SET Name = '{0}' WHERE Id = {1}", name, id.ToString());
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);

            try
            {
                db.ExecuteNonQuery(dbCommand);
            }
            catch (Exception ex)
            {

                throw new Exception("更改专业失败");
            }
        }

        public static void Delete(int id)
        {
            string sqlCommand = string.Format("DELETE FROM TeachHelper_Major WHERE Id = {0}", id.ToString());
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);

            try
            {
                db.ExecuteNonQuery(dbCommand);
            }
            catch (Exception ex)
            {

                throw new Exception("该专业删除失败");
            }
        }


    }
}