ExaminationDAL/TbTestPaperService.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ExaminationModels;
using System.Data.SqlClient;
using System.Data;

namespace ExaminationDAL
{
    public class TbTestPaperService
    {
        /// <summary>
        /// 添加一张试卷，返回当前试卷ID
        /// </summary>
        /// <param name="paper"></param>
        /// <returns></returns>
        public int AddPaper(TbTestPaper paper)
        {
            StringBuilder sbsql = new StringBuilder();
            sbsql.Append("insert into tbTestPaper(LsName,SjName,KmID,KsTime,JsTime,Remark)");
            sbsql.Append("values(@LsName,@SjName,@KmID,@KsTime,@JsTime,@Remark);select @@IDENTITY");
            SqlParameter[] paras = new SqlParameter[] { 
                    new SqlParameter("@LsName",paper.LsName),
                    new SqlParameter("@SjName",paper.SjName),
                    new SqlParameter("@KmID",paper.KmID),
                    new SqlParameter("@KsTime",paper.KsTime),
                    new SqlParameter("@JsTime",paper.JsTime),
                    new SqlParameter("@Remark",paper.Remark)
            };
            return DBHelper.GetScalar(sbsql.ToString(), paras);
        }

        /// <summary>
        /// 查询试卷列表
        /// </summary>
        /// <param name="len">每次查询的条数</param>
        /// <param name="page">当前页数</param>
        /// <returns></returns>

        public DataTable GetAllTestpaperByPage(int len, int page)
        {
            page--;
            StringBuilder sbsql = new StringBuilder();
            sbsql.Append("select top " + len + " tp.SjID,tp.SjName,sb.KmName,tp.LsName,tp.KsTime,tp.JsTime,tp.Zt,tp.Remark from tbTestPaper as tp, ");
            sbsql.Append("tbSubject as sb where tp.KmID=sb.KmID and SjID not in(select top " + len * page + " SjID from tbTestPaper)");
            return DBHelper.GetDataTable(sbsql.ToString());
        }
        public DataTable GetAllTestpaperByPages(int len, int page,string sjName)
        {
            page--;
            StringBuilder sbsql = new StringBuilder();
            sbsql.Append("select top "+len+" tp.SjID,tp.SjName,sb.KmName,tp.LsName,tp.KsTime,tp.JsTime,tp.Zt,tp.Remark from tbTestPaper as tp, ");
            sbsql.Append("tbSubject as sb where tp.KmID=sb.KmID and SjID not in(select top " + len * page + " SjID from tbTestPaper) and tp.SjName like '%" + sjName + "%'");
            return DBHelper.GetDataTable(sbsql.ToString());
        }

        /// <summary>
        /// 根据ID删除试卷信息