answerservices.cs

在线考试系统完整版源码(C#&Access) 该考试系统为一同学毕业设计

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

using System.Data.OleDb;
using ExamModel.Auto_Generated_Code;


namespace ExamDAL.Auto_Generated_Code
{
    public class AnswerServices
    {
        //添加简答题答案方法
        public static int AddAnswer(Answer answer)
        {
            string sql = "insert into [Answer] ([UID],PaperID,ScoreID,[Question],[Answer],[Mark]) values (@UID,@PaperID,@ScoreID,@Question,@Answer,@Mark)";
            OleDbParameter[] para = new OleDbParameter[]
            {
                new OleDbParameter("@UID",answer.UID.UID),//Fk
                new OleDbParameter("@PaperID",answer.PaperID.PaperId),//FK
                new OleDbParameter("@ScoreID",answer.ScoreID.ScoreID),//Fk
                new OleDbParameter("@Question",answer.Question),
                new OleDbParameter("@Answer",answer.ANswer),
                new OleDbParameter("@Mark",answer.Mark)
            };
            return DBHelp.ExecuteCommand(sql, para);

           
        }
        //获得改试卷的简答题
        public static DataSet GetAnswerByuidPaperid(string uid, int paperid)
        {
            string sql = "select * from Answer where UID='" + uid + "'and PaperID=" + paperid;
            return DBHelp.GetDataSet(sql);
        }
        //通过scoreid删除answer记录
        public static void DelAnswerByscoreid(int scoreid)
        {
            string sql="Delete from [Answer] where ScoreID=" + scoreid;
            try
            {
                DBHelp.ExecuteCommand(sql);

            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
    }
}