1
using System;
2
using System.Data;
3
using System.Collections;
4
using System.Data.SqlClient;
5
6
using OnLineExam.DataAccessLayer;
7
using OnLineExam.DataAccessHelper;
8
9
namespace OnLineExam.BusinessLogicLayer
10
...{
11
public class Department
12
...{
13
私有成员#region 私有成员
14
15
private int _departmentId; //部门ID
16
private string _departmentName; //部门名
17
18
#endregion 私有成员
19
20
属性#region 属性
21
22
public int DepartmentId
23
...{
24
set
25
...{
26
this._departmentId = value;
27
}
28
get
29
...{
30
return this._departmentId;
31
}
32
}
33
public string DepartmentName
34
...{
35
set
36
...{
37
this._departmentName = value;
38
}
39
get
40
...{
41
return this._departmentName;
42
}
43
}
44
45
#endregion 属性
46
47
方法#region 方法
48
49
/**//// <summary>
50
/// 根据参数departmentId,获取部门详细信息
51
/// </summary>
52
/// <param name="topicID">部门ID</param>
53
public bool LoadData(int DepartmentId)
54
...{
55
SqlParameter[] Params = new SqlParameter[1];
56
DataBase DB = new DataBase();
57
58
Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId); //用户编号
59
60
DataSet ds = DB.GetDataSet("Proc_DepartmentDetail", Params);
61
ds.CaseSensitive = false;
62
DataRow DR;
63
if (ds.Tables[0].Rows.Count > 0)
64
...{
65
DR = ds.Tables[0].Rows[0];
66
this._departmentId = GetSafeData.ValidateDataRow_N(DR, "DepartmentId");
67
this._departmentName = GetSafeData.ValidateDataRow_S(DR, "DepartmentName");
68
69
return true;
70
}
71
else
72
...{
73
return false;
74
}
75
}
76
public bool CheckDepartment(int XDepartmentId)
77
...{
78
SqlParameter[] Params = new SqlParameter[1];
79
DataBase DB = new DataBase();
80
81
Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, XDepartmentId);
82
83
SqlDataReader DR = DB.RunProcGetReader("Proc_DepartmentDetail", Params);
84
if (!DR.Read())
85
...{
86
return false;
87
}
88
else
89
...{
90
return true;
91
}
92
}
93
public bool InsertByProc()
94
...{
95
SqlParameter[] Params = new SqlParameter[2];
96
97
DataBase DB = new DataBase();
98
99
Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId);
100
Params[1] = DB.MakeInParam("@DepartmentName", SqlDbType.VarChar, 50, DepartmentName);
101
102
103
int Count = -1;
104
Count = DB.RunProc("Proc_DepartmentAdd", Params);
105
if (Count > 0)
106
return true;
107
else return false;
108
}
109
public bool UpdateByProc(string DepartmentId)
110
...{
111
SqlParameter[] Params = new SqlParameter[2];
112
113
DataBase DB = new DataBase();
114
115
Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId);
116
Params[1] = DB.MakeInParam("@DepartmentName", SqlDbType.VarChar, 50, DepartmentName);
117
118
119
int Count = -1;
120
Count = DB.RunProc("Proc_DepartmentModify", Params);
121
if (Count > 0)
122
return true;
123
else return false;
124
}
125
public bool DeleteByProc(string DepartmentId)
126
...{
127
SqlParameter[] Params = new SqlParameter[1];
128
129
DataBase DB = new DataBase();
130
131
Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId); //用户编号
132
133
int Count = -1;
134
Count = DB.RunProc("Proc_DepartmentDelete", Params);
135
if (Count > 0)
136
return true;
137
else return false;
138
}
139
public DataSet QueryDepartment()
140
...{
141
DataBase DB = new DataBase();
142
return DB.GetDataSet("Proc_DepartmentList");
143
}
144
145
public static DataTable Query(Hashtable queryItems)
146
...{
147
string where = SQLString.GetConditionClause(queryItems);
148
string sql = "Select * From [Department]" + where;
149
DataBase db = new DataBase();
150
return db.GetDataTable(sql);
151
}
152
153
#endregion 方法
154
}
155
}
156