当前文件： ExamOnlineAccess/ExamDAL/Auto Generated Code/AnswerServices.cs[1K，2009-6-12 11:42:06]，打开代码结构图

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;
 5
 6using System.Data.OleDb;
 7using ExamModel.Auto_Generated_Code;
 8
 9
10namespace ExamDAL.Auto_Generated_Code
11...{
12    public class AnswerServices
13    ...{
14        //添加简答题答案方法
15        public static int AddAnswer(Answer answer)
16        ...{
17            string sql = "insert into [Answer] ([UID],PaperID,ScoreID,[Question],[Answer],[Mark]) values (@UID,@PaperID,@ScoreID,@Question,@Answer,@Mark)";
18            OleDbParameter[] para = new OleDbParameter[]
19            ...{
20                new OleDbParameter("@UID",answer.UID.UID),//Fk
21                new OleDbParameter("@PaperID",answer.PaperID.PaperId),//FK
22                new OleDbParameter("@ScoreID",answer.ScoreID.ScoreID),//Fk
23                new OleDbParameter("@Question",answer.Question),
24                new OleDbParameter("@Answer",answer.ANswer),
25                new OleDbParameter("@Mark",answer.Mark)
26            };
27            return DBHelp.ExecuteCommand(sql, para);
28
29           
30        }
31        //获得改试卷的简答题
32        public static DataSet GetAnswerByuidPaperid(string uid, int paperid)
33        ...{
34            string sql = "select * from Answer where UID='" + uid + "'and PaperID=" + paperid;
35            return DBHelp.GetDataSet(sql);
36        }
37        //通过scoreid删除answer记录
38        public static void DelAnswerByscoreid(int scoreid)
39        ...{
40            string sql="Delete from [Answer] where ScoreID=" + scoreid;
41            try
42            ...{
43                DBHelp.ExecuteCommand(sql);
44
45            }
46            catch (Exception e)
47            ...{
48                Console.WriteLine(e.Message);
49                throw e;
50            }
51        }
52    }
53}
54