student.cs

很不错的学生管理系统

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
using es_data = com.egt.data;

namespace com.egt.business
{
    public class student
    {
        /*
    * 编码人员：胡鹏飞
    * 
    * 编码时间：2007-9-27
    * 
    * 内容：学员业务类
    */
        private SqlParameter[] para;
        private DataSet ds;

        /// <summary>
        /// 修改学员信息
        /// </summary>
        /// <param name="StuAtt"></param>
        /// <returns></returns>
        public int update_student(StudentAttribute StuAtt)
        {
            try
            {
                para = new SqlParameter[8];
                para[0] = es_data.DataBaseAdmin.MakeInParam("@inid", SqlDbType.Int, 30, StuAtt.id);
                para[1] = es_data.DataBaseAdmin.MakeInParam("@varnames", SqlDbType.VarChar, 30, StuAtt.names);
                para[2] = es_data.DataBaseAdmin.MakeInParam("@varpassword", SqlDbType.VarChar, 30, StuAtt.password);
                para[3] = es_data.DataBaseAdmin.MakeInParam("@varphone", SqlDbType.VarChar, 30, StuAtt.phone);
                para[4] = es_data.DataBaseAdmin.MakeInParam("@varschoolname", SqlDbType.VarChar, 30, StuAtt.schoolname);
                para[5] = es_data.DataBaseAdmin.MakeInParam("@intclassid", SqlDbType.VarChar, 30, StuAtt.classid);
                para[6] = es_data.DataBaseAdmin.MakeInParam("@varaddress", SqlDbType.VarChar, 30, StuAtt.address);
                para[7] = es_data.DataBaseAdmin.MakeInParam("@varsex", SqlDbType.VarChar, 30, StuAtt.sex);
                es_data.DataBaseAdmin.ExecuteReader("sp_users_update", para);
                return 1;
            }
            catch (Exception ex)
            {
                string ms = ex.Message;
                return 0;
            }
        }

        /// <summary>
        /// 新建学员信息
        /// </summary>
        /// <param name="StuAtt"></param>
        /// <returns></returns>
        public int new_student(StudentAttribute StuAtt)
        {
            try
            {
                para = new SqlParameter[8];
                para[0] = es_data.DataBaseAdmin.MakeInParam("@varnames", SqlDbType.VarChar, 30, StuAtt.names);
                para[1] = es_data.DataBaseAdmin.MakeInParam("@varpassword", SqlDbType.VarChar, 30, StuAtt.password);
                para[2] = es_data.DataBaseAdmin.MakeInParam("@varphone", SqlDbType.VarChar, 30, StuAtt.phone);
                para[3] = es_data.DataBaseAdmin.MakeInParam("@varschoolname", SqlDbType.VarChar, 30, StuAtt.schoolname);
                para[4] = es_data.DataBaseAdmin.MakeInParam("@intclassid", SqlDbType.VarChar, 30, StuAtt.classid);
                para[5] = es_data.DataBaseAdmin.MakeInParam("@varaddress", SqlDbType.VarChar, 30, StuAtt.address);
                para[6] = es_data.DataBaseAdmin.MakeInParam("@varsex", SqlDbType.VarChar, 30, StuAtt.sex);
                para[7] = es_data.DataBaseAdmin.MakeInParam("@landnames", SqlDbType.VarChar, 30, StuAtt.landnames);
                es_data.DataBaseAdmin.ExecuteReader("sp_users_new", para);
                return 1;
            }
            catch (Exception ex)
            {
                string ms = ex.Message;
                return 0;
            }
        }
        /// <summary>
        /// 查询所有学员信息
        /// </summary>
        /// <returns></returns>
        public DataSet select_student()
        {
            ds = es_data.DataBaseAdmin.ExecuteDataSet("sp_users_selectall");
            if (ds == null || ds.Tables[0].Rows.Count == 0)
                return null;
            return ds;
        }

        /// <summary>
        /// 查询所有班级信息
        /// </summary>
        /// <returns></returns>
        public DataSet select_class()
        {
            ds = es_data.DataBaseAdmin.ExecuteDataSet("sp_class_select");
            if (ds == null || ds.Tables[0].Rows.Count == 0)
                return null;
            return ds;
        }
    }
}