sqlstudentcotroller.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;
/************************************
 * 类名：SqlStudentCotroller
 * 创建日期：2007-7-13
 * 功能描述：提供学员信息操作
 * *********************************/
namespace MySchool.DataController
{
    public class SqlStudentCotroller:StudentController
    {
        #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 AddSutdent(StudentInfo objStudentInfo)
        {
            int number;
            using (SqlConnection conn = new SqlConnection(connString))
            {
                SqlCommand objCommand = new SqlCommand(dboOwner + ".usp_InsertPartStudentInfo", conn);
                objCommand.CommandType = CommandType.StoredProcedure;

                objCommand.Parameters.Add("@LoginID", SqlDbType.NVarChar, 50).Value = objStudentInfo.LoginId;
                objCommand.Parameters.Add("@LoginPwd",SqlDbType.NVarChar,50).Value = objStudentInfo.LingPwd;
                objCommand.Parameters.Add("@UserStateId",SqlDbType.Int).Value = objStudentInfo.UserStateId;
                objCommand.Parameters.Add("@ClassID",SqlDbType.Int).Value = objStudentInfo.ClassID;
                objCommand.Parameters.Add("@StudentNO",SqlDbType.NVarChar,255).Value = objStudentInfo.StudentNO;
                objCommand.Parameters.Add("@StudentName",SqlDbType.NVarChar,255).Value = objStudentInfo.StudentName;
                objCommand.Parameters.Add("@Sex",SqlDbType.NVarChar,255).Value = objStudentInfo.Sex;
                conn.Open();
                number = Convert.ToInt32(objCommand.ExecuteScalar());
                conn.Close();
                conn.Dispose();
            }
            return number;
        }
        public override void DeleteStudent(int studentID)
        {
        }
        public override void SelectStudent(string name)
        {
            
        }
        public override ArrayList SelectStudentLoginPwdByLoginID(string loginID)
        {
            ArrayList studentlist = new ArrayList();
            string pwd = string.Empty;
            using (SqlConnection conn = new SqlConnection(connString))
            {
                SqlCommand objCommand = new SqlCommand(dboOwner + ".usp_SelectStudentByLoginID", 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())
                    {
                        studentlist.Add(objReader["LoginPwd"]);
                        studentlist.Add(objReader["UserStateId"]);
                    }
                    objReader.Dispose();
                }
                conn.Close();
                conn.Dispose();
            }

            return studentlist;
        }
        public override void UpdateStudent( StudentInfo objStudentInfo)
        {

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