SQLServerDAL/AssistantDAL.cs

（开头部分） 6KB

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using System.Data.SqlClient;

using CheckOnWork.Model;
using CheckOnWork.IDAL;
using CheckOnWork.DBHelper;
using CheckOnWork.WebConfig;

namespace CheckOnWork.SQLServerDAL
{
    public class AssistantDAL:DBAccess,IAssistant
    {

        #region  得到某系的辅导员与副主任
        /// <summary>
        /// 得到某系的辅导员与副主任
        /// </summary>
        /// <param name="departmentId"></param>
        /// <returns></returns>
        public IList<Assistant> GetAssistantByDepartment(int departmentId)
        {
            IList<Model.Assistant> list = new List<Assistant>();
            SqlParameter param=new SqlParameter("@departmentID",departmentId);

            using (SqlDataReader read = ExecuteReader(StoredProcedureName.assistantSelectByDepartmentId, param))
            {
                while (read.Read())
                {
                    Assistant assist = new Assistant(read.GetString(0),read.GetString(1),read.GetString(2),read.GetInt32(3),read.GetString(4),read.GetString(5));

                    list.Add(assist);
                }
            }

            return list;
        }
        #endregion

        #region 添加辅导员与副主任信息
        /// <summary>
        /// 添加辅导员与副主任信息
        /// </summary>
        /// <param name="teacher"></param>
        /// <returns></returns>
        public int Insert(Assistant teacher)
        {
            SqlParameter[] param = { 
                                   new SqlParameter("@assistantID",teacher.assistantID),
                                   new SqlParameter("@assistantName",teacher.assistantName),
                                   new SqlParameter("@assistantPwd",teacher.assistantPwd),
                                   new SqlParameter("@departmentID",teacher.departmentID),
                                   new SqlParameter("@assistantPhone",teacher.assistantPhone),
                                   new SqlParameter("@assistantEmail",teacher.assistantEmail)
                                   };
            if (CheckAssistant(teacher.assistantID))
后面还有 109 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。