DAL/DBPaperByRandomSelection.cs

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

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

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

using Entity;

namespace DAL
{
    public class DBPaperByRandomSelection : DBOperation<PaperByRandomSelection>
    {
        #region DBOperation<PaperByRandomSelection> Members

        public void Insert(PaperByRandomSelection obj)
        {
            string sql = "insert into T_PaperByRandomSelection(paperName,deptID,paperType,creator,createdTime,judgeSum,singleSelectionSum,multiSelectionSum,judgeCateID,singleSelectionCateID,multiSelectionCateID) values(@paperName,@deptID,@paperType,@creator,@createdTime,@judgeSum,@singleSelectionSum,@multiSelectionSum,@judgeCateID,@singleSelectionCateID,@multiSelectionCateID)";
            SqlParameter[] parms ={
                                     new SqlParameter("@paperName",obj.PaperName),
                                     new SqlParameter("@deptID",obj.PaperType.DeptID),
                                     new SqlParameter("@paperType",obj.PaperType.DeptName),
                                     new SqlParameter("@creator",obj.Creator.Name),
                                     new SqlParameter("@createdTime",obj.CreatedTime),
                                     new SqlParameter("@judgeSum",obj.JudgeSum),
                                     new SqlParameter("@singleSelectionSum",obj.SingleSelectionSum),
                                     new SqlParameter("@multiSelectionSum",obj.MultiSelectionSum),
                                     new SqlParameter("@judgeCateID",obj.JudgeCateID),
                                     new SqlParameter("@singleSelectionCateID",obj.SingleSelectionCateID),
                                     new SqlParameter("@multiSelectionCateID",obj.MultiSelectionCateID)};
            DBHelper2.Insert(sql, parms);
        }

        public void Update(PaperByRandomSelection obj)
        {
            throw new NotImplementedException();
        }

        public void Delete(string id)
        {
            string sql = "delete from T_PaperByRandomSelection where paperID=@paperID";
            SqlParameter[] parms ={
                                     new SqlParameter("@paperID",id)};
            DBHelper2.Delete(sql, parms);
        }

        /// <summary>
        /// 只获取试卷的基本信息
        /// </summary>
        public PaperByRandomSelection SelectByID2(string id)
        {
            string sql = "select * from T_PaperByRandomSelection where paperID=@paperID";
            SqlParameter[] parms ={
                                     new SqlParameter("@paperID",id)};
            PaperByRandomSelection paper =null;
            using (SqlDataReader dr = DBHelper2.Select(sql, parms))
            {
                if (dr.Read())
                {
                    paper = new PaperByRandomSelection();
                    paper.PaperID = Convert.ToInt32(dr["paperID"]);