1
using System;
2using System.Data;
3using System.Collections;
4using System.Data.SqlClient;
5using OnLineExam.DataAccessLayer;
6using OnLineExam.DataAccessHelper;
7
8
9namespace OnLineExam.BusinessLogicLayer
10
...{
11
//单选题类
12 public class SingleProblem
13
...{
14 私有成员#region 私有成员
15 private int _ID; //题目编号
16 private int _CourseID; //所属科目
17 private string _Title; //题目
18 private string _AnswerA; //答案A
19 private string _AnswerB; //答案B
20 private string _AnswerC; //答案C
21 private string _AnswerD; //答案D
22 private string _Answer; //答案
23
24
#endregion 私有成员
25
26 属性#region 属性
27
28 public int ID
29 ...{
30 set
31 ...{
32 this._ID = value;
33 }
34 get
35 ...{
36 return this._ID;
37 }
38 }
39 public int CourseID
40 ...{
41 set
42 ...{
43 this._CourseID = value;
44 }
45 get
46 ...{
47 return this._CourseID;
48 }
49 }
50 public string Title
51 ...{
52 set
53 ...{
54 this._Title = value;
55 }
56 get
57 ...{
58 return this._Title;
59 }
60 }
61 public string AnswerA
62 ...{
63 set
64 ...{
65 this._AnswerA = value;
66 }
67 get
68 ...{
69 return this._AnswerA;
70 }
71 }
72 public string AnswerB
73 ...{
74 set
75 ...{
76 this._AnswerB = value;
77 }
78 get
79 ...{
80 return this._AnswerB;
81 }
82 }
83 public string AnswerC
84 ...{
85 set
86 ...{
87 this._AnswerC = value;
88 }
89 get
90 ...{
91 return this._AnswerC;
92 }
93 }
94 public string AnswerD
95 ...{
96 set
97 ...{
98 this._AnswerD = value;
99 }
100 get
101 ...{
102 return this._AnswerD;
103 }
104 }
105 public string Answer
106 ...{
107 set
108 ...{
109 this._Answer = value;
110 }
111 get
112 ...{
113 return this._Answer;
114 }
115 }
116
117 #endregion 属性
118
119 方法#region 方法
120
121 //根据题目ID 初始化题目
122 //输入：
123 // TID - 题目编号；
124 //输出：
125 // 题目存在：返回True；
126 // 题目不在：返回False；
127 public bool LoadData(int TID)
128 ...{
129 SqlParameter[] Params = new SqlParameter[1];
130 DataBase DB = new DataBase();
131
132 Params[0] = DB.MakeInParam("@ID", SqlDbType.Int,4, TID); //用户编号
133
134 DataSet ds = DB.GetDataSet("Proc_SingleProblemDetail", Params);
135 ds.CaseSensitive = false;
136 DataRow DR;
137 if (ds.Tables[0].Rows.Count > 0)
138 ...{
139 DR= ds.Tables[0].Rows[0];
140 this._CourseID = GetSafeData.ValidateDataRow_N(DR, "CourseID"); //科目编号
141 this._Title = GetSafeData.ValidateDataRow_S(DR, "Title"); //题目
142 this._AnswerA = GetSafeData.ValidateDataRow_S(DR, "AnswerA"); //答案A
143 this._AnswerB = GetSafeData.ValidateDataRow_S(DR, "AnswerB"); //答案B
144 this._AnswerC = GetSafeData.ValidateDataRow_S(DR, "AnswerC"); //答案C
145 this._AnswerD = GetSafeData.ValidateDataRow_S(DR, "AnswerD"); //答案D
146 this._Answer = GetSafeData.ValidateDataRow_S(DR, "Answer"); //答案
147 return true;
148 }
149 else
150 ...{
151 return false;
152 }
153 }
154
155
156 //向SingleProblem表中添加题目信息(采用存储过程)
157 //输出：
158 // 插入成功：返回True；
159 // 插入失败：返回False；
160 public bool InsertByProc()
161 ...{
162 SqlParameter[] Params = new SqlParameter[7];
163
164 DataBase DB = new DataBase();
165
166 Params[0] = DB.MakeInParam("@CourseID", SqlDbType.Int,4, CourseID); //科目编号
167 Params[1] = DB.MakeInParam("@Title", SqlDbType.VarChar,1000, Title); //题目
168 Params[2] = DB.MakeInParam("@AnswerA", SqlDbType.VarChar, 500, AnswerA); //答案A
169 Params[3] = DB.MakeInParam("@AnswerB", SqlDbType.VarChar, 500, AnswerB); //答案B
170 Params[4] = DB.MakeInParam("@AnswerC", SqlDbType.VarChar, 500, AnswerC); //答案C
171 Params[5] = DB.MakeInParam("@AnswerD", SqlDbType.VarChar, 500, AnswerD); //答案D
172 Params[6] = DB.MakeInParam("@Answer", SqlDbType.VarChar, 2, Answer); //答案
173
174 int Count = -1;
175 Count = DB.RunProc("Proc_SingleProblemAdd", Params);
176 if (Count > 0)
177 return true;
178 else return false;
179 }
180
181 //更新单选题试题信息
182 public bool UpdateByProc(int TID)
183 ...{
184 SqlParameter[] Params = new SqlParameter[8];
185
186 DataBase DB = new DataBase();
187
188 Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //题目编号
189 Params[1] = DB.MakeInParam("@CourseID", SqlDbType.Int, 4, CourseID); //科目编号
190 Params[2] = DB.MakeInParam("@Title", SqlDbType.VarChar, 1000, Title); //题目
191 Params[3] = DB.MakeInParam("@AnswerA", SqlDbType.VarChar, 500, AnswerA); //答案A
192 Params[4] = DB.MakeInParam("@AnswerB", SqlDbType.VarChar, 500, AnswerB); //答案B
193 Params[5] = DB.MakeInParam("@AnswerC", SqlDbType.VarChar, 500, AnswerC); //答案C
194 Params[6] = DB.MakeInParam("@AnswerD", SqlDbType.VarChar, 500, AnswerD); //答案D
195 Params[7] = DB.MakeInParam("@Answer", SqlDbType.VarChar, 2, Answer); //答案
196
197 int Count = -1;
198 Count = DB.RunProc("Proc_SingleProblemModify", Params);
199 if (Count > 0)
200 return true;
201 else return false;
202 }
203
204
205 //删除题目
206 //输入：
207 // TID - 题目编号；
208 //输出：
209 // 删除成功：返回True；
210 // 删除失败：返回False；
211 public bool DeleteByProc(int TID)
212 ...{
213 SqlParameter[] Params = new SqlParameter[1];
214
215 DataBase DB = new DataBase();
216
217 Params[0] = DB.MakeInParam("@ID", SqlDbType.Int,4, TID); //题目编号
218
219 int Count = -1;
220 Count = DB.RunProc("Proc_SingleProblemDelete", Params);
221 if (Count > 0)
222 return true;
223 else return false;
224 }
225
226 //查询单选题
227 public DataSet QuerySingleProblem(int TCourseID)
228 ...{
229 SqlParameter[] Params = new SqlParameter[1];
230
231 DataBase DB = new DataBase();
232
233 Params[0] = DB.MakeInParam("@CourseID", SqlDbType.Int, 4, TCourseID); //题目编号
234 return DB.GetDataSet("Proc_SingleProblemList",Params);
235 }
236
237 #endregion 方法
238 }
239
}
打包下载该项目完整源码：多功能在线考试系统改进版源码
