sqlteachercontroller.cs

一个网上书店的源码

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using MySchool.DataProvideController;
using MySchool.BusinessEntity;
/************************************
 * 类名：SqlTeacherController
 * 创建日期：2007-7-13
 * 功能描述：提供教员信息操作
 * *********************************/
namespace MySchool.DataController
{
    public class SqlTeacherController:TeacherController
    {
        #region Private Members
        private readonly string connString = ConfigurationManager.ConnectionStrings["MySchoolConnectionString"].ToString();
        private readonly string dboOwner = ConfigurationManager.ConnectionStrings["DataBaseOwner"].ToString();
        #endregion

        #region Public Methods
        public override int AddTeacher(TeacherInfo objTeacherInfo)
        {
            int number;
            using (SqlConnection conn = new SqlConnection(connString))
            {
                SqlCommand objCommand = new SqlCommand(dboOwner + ".usp_InsertTeacher", conn);
                objCommand.CommandType = CommandType.StoredProcedure;

                objCommand.Parameters.Add("@LoginID", SqlDbType.NVarChar, 50).Value = objTeacherInfo.LoginId;
                conn.Open();
                number = Convert.ToInt32(objCommand.ExecuteScalar());
                conn.Close();
                conn.Dispose();
            }
            return number;
        }
        public override void DeleteTeacher(int TeacherID)
        {
        }
        public override void SelectTeacher(string name)
        {

        }
        public override ArrayList SelectTeacherLoginPwdByLoginID(string loginID)
        {
            ArrayList teacherState = new ArrayList();
            using (SqlConnection conn = new SqlConnection(connString))
            {
                SqlCommand objCommand = new SqlCommand(dboOwner + ".usp_SelectTeacherByLoginID", conn);
                objCommand.CommandType = CommandType.StoredProcedure;
                objCommand.Parameters.Add("@LoginId", SqlDbType.NVarChar, 50).Value = loginID;
                conn.Open();
                using (SqlDataReader objReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    if (objReader.Read())
                    {
                        teacherState.Add(objReader["LoginPwd"]);
                        teacherState.Add(objReader["UserStateId"]);
                    }
                    objReader.Dispose();
                }
                conn.Close();
                conn.Dispose();
            }

            return teacherState;
        }
        public override void UpdateTeacher(TeacherInfo objTeacherInfo)
        {

        }
        public override ArrayList SelectAllTeacher()
        {
            ArrayList objlist = new ArrayList();
            return objlist;
        }
        #endregion
    }
}