examtype.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 ExamType
    /// </summary>
    public class ExamType
    {
        public ExamType()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        public static int GetId(string name)
        {
            string sqlCommand = string.Format("SELECT Id FROM TeachHelper_ExamType 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_ExamType 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_ExamType";
            return DataAccess.ExecuteDataSet(sqlCommand);
        }
    }
}