DAL/StuHomeworkDAO.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 StuHomeworkDAO
    {
        private SQLHelper sqlhelper;
        public StuHomeworkDAO()
        {
            sqlhelper = new SQLHelper();
        }
        #region 学生提交作业
        /// <summary>
        /// 学生提交作业
        /// </summary>
        /// <param name="n">学生作业实体类</param>
        /// <returns></returns>
        public bool Insert(stuHomework n)
        {
            bool flag = false;
            SqlParameter[] paras = new SqlParameter[]
            {
                new SqlParameter("@classId",n.ClassId),
                new SqlParameter("@content",n.Content),
                new SqlParameter("@creater",n.Creater),
                new SqlParameter("@modifier",n.Creater),
                new SqlParameter("@studentId",n.StudentId ),
                new SqlParameter("@times",n.Times ),
            };
            int res = sqlhelper.ExecuteNonQuery("INSERT INTO stuHomework (classId, [content], creater, modifier, studentId, times) VALUES (@classId,@content,@creater,@creater,@studentId,@times)", paras, CommandType.Text);
            if (res > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion
        #region 查看单一班级单一次数已交作业列表
        /// <summary>
        /// 查看单一班级单一次数已交作业列表
        /// </summary>
        /// <param name="n">学生作业实体类</param>
        /// <returns></returns>
        public DataTable SelectByClass(stuHomework  n)
        {
            SqlParameter[] paras = new SqlParameter[]
            {
                 new SqlParameter ("@classId",n.ClassId ),
                 new SqlParameter ("@times",n.Times ),
            };
            return sqlhelper.ExecuteQuery("SELECT stuHomework.studentId, [content], remarks, results,comment, students.name, students.subject FROM stuHomework  JOIN students on stuHomework.studentId=students.studentId AND classId=@classId AND times=@times ", paras, CommandType.Text);
        }
        #endregion
        #region 学生更新学生作业