当前文件路径:OnLineExam/App_Code/BusinessLogicLayer/Scores.cs 
1
using System;
2
using System.Data;
3
using System.Collections;
4
using System.Data.SqlClient;
5
using MyOnLineExam.DataAccessLayer;
6
using MyOnLineExam.DataAccessHelper;
7
8
9
namespace MyOnLineExam.BusinessLogicLayer
10
...{
11
//用户类
12
public class Scores
13
...{
14
私有成员#region 私有成员
15
private int _ID; //用户编号
16
private string _userID; //用户密码
17
private int _paperID; //用户权限
18
private int _score; //用户姓名
19
20
#endregion 私有成员
21
22
属性#region 属性
23
24
public int ID
25
...{
26
set
27
...{
28
this._ID = value;
29
}
30
get
31
...{
32
return this._ID;
33
}
34
}
35
public string UserID
36
...{
37
set
38
...{
39
this._userID = value;
40
}
41
get
42
...{
43
return this._userID;
44
}
45
}
46
public int PaperID
47
...{
48
set
49
...{
50
this._paperID = value;
51
}
52
get
53
...{
54
return this._paperID;
55
}
56
}
57
public int Score
58
...{
59
set
60
...{
61
this._score = value;
62
}
63
get
64
...{
65
return this._score;
66
}
67
}
68
69
70
#endregion 属性
71
72
方法#region 方法
73
74
//向Score表中添加成绩
75
//输出:
76
// 插入成功:返回True;
77
// 插入失败:返回False;
78
public bool InsertByProc()
79
...{
80
SqlParameter[] Params = new SqlParameter[3];
81
82
DataBase DB = new DataBase();
83
84
Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20, UserID); //用户编号
85
Params[1] = DB.MakeInParam("@PaperID", SqlDbType.Int,4, PaperID); //用户密码
86
Params[2] = DB.MakeInParam("@Score", SqlDbType.Int,4, Score); //用户权限
87
88
89
int Count = -1;
90
Count = DB.RunProc("Proc_ScoreAdd", Params);
91
if (Count > 0)
92
return true;
93
else return false;
94
}
95
96
//删除成绩
97
//输入:
98
// XUserID - 用户编号;
99
//输出:
100
// 删除成功:返回True;
101
// 删除失败:返回False;
102
public bool DeleteByProc(int SID)
103
...{
104
SqlParameter[] Params = new SqlParameter[1];
105
106
DataBase DB = new DataBase();
107
108
Params[0] = DB.MakeInParam("@ID", SqlDbType.Int,4, SID); //成绩编号
109
110
int Count = -1;
111
Count = DB.RunProc("Proc_ScoreDelete", Params);
112
if (Count > 0)
113
return true;
114
else return false;
115
}
116
117
//查询所用成绩
118
//不需要参数
119
public DataSet QueryScore()
120
...{
121
DataBase DB = new DataBase();
122
return DB.GetDataSet("Proc_ScoreList");
123
}
124
125
#endregion 方法
126
}
127
}