1
using System;
2using System.Data;
3using System.Collections;
4
5using MyOA.DataAccessLayer;
6using MyOA.DataAccessHelper;
7using MyOA.CommonComponent;
8
9namespace MyOA.BusinessLogicLayer
10
...{
11
/**//// <summary>
12
/// User 的摘要说明。
13
/// </summary>
14 public class User
15 ...{
16 私有成员#region 私有成员
17
18 private int _userId; //用户Id
19 private string _loginName; //用户登录名
20 private string _userName; //用户姓名
21 private string _password; //用户密码
22 private string _department; //用户部门
23 private string _role; //用户角色
24 private ArrayList _duties=new ArrayList(); //用户所有的权限
25
26 private bool _exist; //是否存在标志
27
28 #endregion 私有成员
29
30 属性#region 属性
31
32 public int UserId
33 ...{
34 set
35 ...{
36 this._userId=value;
37 }
38 get
39 ...{
40 return this._userId;
41 }
42 }
43 public string LoginName
44 ...{
45 set
46 ...{
47 this._loginName=value;
48 }
49 get
50 ...{
51 return this._loginName;
52 }
53 }
54 public string UserName
55 ...{
56 set
57 ...{
58 this._userName=value;
59 }
60 get
61 ...{
62 return this._userName;
63 }
64 }
65 public string Password
66 ...{
67 set
68 ...{
69 this._password=value;
70 }
71 get
72 ...{
73 return this._password;
74 }
75 }
76 public string Department
77 ...{
78 set
79 ...{
80 this._department=value;
81 }
82 get
83 ...{
84 return this._department;
85 }
86 }
87 public string Role
88 ...{
89 set
90 ...{
91 this._role=value;
92 }
93 get
94 ...{
95 return this._role;
96 }
97 }
98 public ArrayList Duties
99 ...{
100 set
101 ...{
102 this._duties=value;
103 }
104 get
105 ...{
106 return this._duties;
107 }
108 }
109 public bool Exist
110 ...{
111 get
112 ...{
113 return this._exist;
114 }
115 }
116
117 #endregion 属性
118
119 方法#region 方法
120
121 /**//// <summary>
122 /// 根据参数loginName，获取用户详细信息
123 /// </summary>
124 /// <param name="loginName">用户登录名</param>
125 public void LoadData(string loginName)
126 ...{
127 Database db=new Database(); //实例化一个Database类
128
129 string sql="";
130 sql="Select * from [User],[Department],[Role] where LoginName = "
131 +SqlStringConstructor.GetQuotedString(loginName)
132 +" And [User].DepartmentId=[Department].DepartmentId"
133 +" And [User].RoleId=[Role].RoleId";
134
135 DataRow dr=db.GetDataRow(sql); //利用Database类的GetDataRow方法查询用户数据
136
137 //根据查询得到的数据，对成员赋值
138 if(dr!=null)
139 ...{
140 this._userId=GetSafeData.ValidateDataRow_N(dr,"UserID");
141 this._loginName=GetSafeData.ValidateDataRow_S(dr,"loginName");
142 this._userName=GetSafeData.ValidateDataRow_S(dr,"UserName");
143 this._password=GetSafeData.ValidateDataRow_S(dr,"PassWord");
144 this._department=GetSafeData.ValidateDataRow_S(dr,"DepartmentName");
145 this._role=GetSafeData.ValidateDataRow_S(dr,"RoleName");
146
147 //获取权限集合
148 string colName="";
149 for(int i=0;i<dr.ItemArray.Length;i++)
150 ...{
151 colName=dr.Table.Columns[i].ColumnName;
152 if(colName.StartsWith("HasDuty_") && GetSafeData.ValidateDataRow_N(dr,colName)==1)
153 ...{
154 this._duties.Add(dr.Table.Columns[i].ColumnName.Substring(8)); //去掉前缀“HasDuty_”
155 }
156 }
157
158 //解密口令
159 this._password=Encrypt.DecryptString(_password,_loginName);
160
161 this._exist=true;
162 }
163 else
164 ...{
165 this._exist=false;
166 }
167 }
168
169 /**//// <summary>
170 /// 向数据库添加一个用户
171 /// </summary>
172 /// <param name="htUserInfo">用户信息哈希表</param>
173 public static void Add(Hashtable userInfo)
174 ...{
175 Database db=new Database(); //实例化一个Database类
176 db.Insert("[User]",userInfo ); //利用Database类的Insert方法添加用户数据
177 }
178
179 /**//// <summary>
180 /// 修改用户数据
181 /// </summary>
182 /// <param name="htUserInfo">用户信息哈希表</param>
183 public static void Update(Hashtable userInfo,string where)
184 ...{
185 Database db=new Database(); //实例化一个Database类
186 db.Update("[User]",userInfo,where); //利用Database类的Update方法修改用户数据
187 }
188
189 /**//// <summary>
190 /// 删除用户数据
191 /// </summary>
192 /// <param name="loginName">用户登录名</param>
193 public static void Delete(string loginName)
194 ...{
195 Database db=new Database(); //实例化一个Database类
196 string sql="Delete from [User] Where [LoginName] = "
197 +SqlStringConstructor.GetQuotedString(loginName);
198 db.ExecuteSQL(sql);
199 }
200
201 /**//// <summary>
202 /// 判断是否存在登录名为loginName的用户
203 /// </summary>
204 /// <param name="loginName">用户登录名</param>
205 /// <returns>如果存在，返回true；否则，返回false</returns>
206 public static bool HasUser(string loginName)
207 ...{
208 Database db=new Database();
209
210 string sql="";
211 sql="Select * from [User] where [LoginName] = "
212 +SqlStringConstructor.GetQuotedString(loginName);
213
214 DataRow row=db.GetDataRow(sql);
215 if(row!=null)
216 return true;
217 else
218 return false;
219 }
220
221 /**//// <summary>
222 /// 查询用户
223 /// </summary>
224 /// <param name="queryItems"></param>
225 /// <returns></returns>
226 public static DataTable QueryUsers(Hashtable queryItems)
227 ...{
228 string where=SqlStringConstructor.GetConditionClause(queryItems);
229 string sql="Select * From [User],[Department],[Role] "+where;
230
231 if(where=="")
232 sql+=" Where";
233 else
234 sql+=" And";
235
236 sql+=" [User].DepartmentId=[Department].DepartmentId"
237 +" And [User].RoleId=[Role].RoleId";
238
239 Database db = new Database();
240 return db.GetDataTable(sql);
241 }
242
243 #endregion 方法
244 }
245
}
246
GongWenLiuZhuan/App_Code/BusinessLogicLayer/User.cs[5K，2009-6-12 11:43:27]，打开代码结构图
打包下载该项目完整源码：Asp.net简单公文流转系统(MVC)源码