看看有什么用?

来源：互联网发布：青岛特锐德软件开发编辑：程序博客网时间：2024/04/20 13:03

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace MySchoolDAL
{
   public class ClassService
    {
        #region Private Members
        //从配置文件中读取数据库连接字符串
        private readonly string connString = ConfigurationManager.ConnectionStrings["MySchoolConnectionString"].ToString();
        private readonly string dboOwner = ConfigurationManager.ConnectionStrings["DataBaseOwner"].ToString();
        #endregion

        #region Public Methods
        /// <summary>
        /// 根据班级名称得到班级ＩＤ
        /// </summary>
        /// <param name="className">班级名称</param>
        /// <returns>班级ID</returns>
        public int GetClassIDByClassName(string className)
        {
            int number = 0;
            SqlConnection conn = new SqlConnection(connString);
            SqlCommand objCommand = new SqlCommand(dboOwner + ".usp_SelectClassIDByClassName", conn);
            objCommand.CommandType = CommandType.StoredProcedure;
            objCommand.Parameters.Add("@ClassName", SqlDbType.NVarChar, 50).Value = className;
            conn.Open();
            SqlDataReader objReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
            if (objReader.Read())
                number = Convert.ToInt32(objReader["ClassID"]);
            objReader.Close();
            objReader.Dispose();
            conn.Close();
            conn.Dispose();
            return number;
        }
        /// <summary>
        /// 增加班级信息
        /// </summary>
        /// <param name="dsClass">班级信息数据集</param>
        public void AddClass(DataSet dsClass)
        {
            SqlConnection conn = new SqlConnection(connString);
            SqlCommand objCommand = new SqlCommand(dboOwner + ".usp_InsertClass", conn);
            objCommand.CommandType = CommandType.StoredProcedure;
            objCommand.Parameters.Add("@ClassName", SqlDbType.NVarChar, 50).Value = dsClass.Tables["Class"].Rows[0]["ClassName"];
            objCommand.Parameters.Add("@GradeID", SqlDbType.Int).Value = dsClass.Tables["Class"].Rows[0]["GradeID"];
            conn.Open();
            objCommand.ExecuteNonQuery();
            conn.Close();
            conn.Dispose();
        }
        #endregion
        }
}