DAL/StudentsDAO.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MODEL;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class StudentsDAO
    {
         private SQLHelper sqlhelper;
         public StudentsDAO()
        {
            sqlhelper = new SQLHelper();
        }
        #region 选择全部学生信息
        /// <summary>
         /// 选择全部学生信息
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        {
            return sqlhelper.ExecuteQuery("SELECT studentId, name, pwd, sex, subject, college, cellphone, email FROM students", CommandType.Text);
        }
        #endregion
        #region 按条件选择学生信息
        /// <summary>
        /// 按条件选择学生信息
        /// </summary>
        /// <returns></returns>
        public DataTable SelectByValue( string n)
        {
            SqlParameter[] paras = new SqlParameter[]
            {
                 new SqlParameter ("@value",n ),
            };
            return sqlhelper.ExecuteQuery("SELECT studentId, name, pwd, sex, subject, college, cellphone, email FROM students WHERE studentId=@value or name like '%'+@value+'%' ", paras, CommandType.Text);
        }
        #endregion
        #region 更新学生信息
        /// <summary>
        /// 更新学生信息
        /// </summary>
        /// <param name="n">学生信息实体类</param>
        public void Update(students  n)
        {
            SqlParameter[] paras = new SqlParameter[]
            {
                new SqlParameter ("@name",n.Name),
                new SqlParameter ("@sex",n.Sex),  
                new SqlParameter ("@subject",n.Subject),
                new SqlParameter ("@college",n.College), 
                new SqlParameter ("@cellphone",n.Cellphone ),
                new SqlParameter ("@email",n.Email),
                new SqlParameter ("@modifier",n.Modifier),
                new SqlParameter ("@studentId",n.StudentId),
            };
            sqlhelper.ExecuteQuery("UPDATE students SET name = @name,sex = @sex,subject=@subject,college=@college,cellphone = @cellphone,email = @email,modifier = @modifier,lastmodify = getdate() where studentId=@studentId", paras, CommandType.Text);