public List<UsersList> ConvertUsersList(DataSet ds)
{
List<UsersList> ul = new List<UsersList>();
if (ds == null || ds.Tables.Count == 0) return ul;
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
UsersList us = new UsersList();
us.ID = dt.Rows[i]["ID"].ToString();
us.UserId = dt.Rows[i]["UserId"].ToString().ToInteger();
us.UserName = dt.Rows[i]["UserName"].ToString();
us.EngName = dt.Rows[i]["EngName"].ToString();
us.LoginName = dt.Rows[i]["LoginName"].ToString();
us.Sex = dt.Rows[i]["Sex"].ToString().ToInteger();
us.JobTitle = dt.Rows[i]["JobTitle"].ToString().ToInteger();
us.DeptId = dt.Rows[i]["DeptId"].ToString().ToInteger();
us.ParentId = dt.Rows[i]["ParentId"].ToString().ToInteger();
us.ParentName = dt.Rows[i]["ParentName"].ToString();
us.JoinDate = dt.Rows[i]["JoinDate"].ToString().ToDateTime();
us.LeaveDate = dt.Rows[i]["LeaveDate"].ToString().ToDateTime();
us.Status = dt.Rows[i]["Status"].ToString().ToInteger();
ul.Add(us);
}
return ul;
}
/// <summary>
/// 查询用户列表，三个条件 部门、职位、状态
/// </summary>
/// <returns></returns>
public List<UsersList> GetUserList(string deptId, string jobTitle, string status)
{
UsersList ul = new UsersList();
UsersListDao uld = new UsersListDao();
ul.Status = string.IsNullOrEmpty(status) ? (int)AccountStatusEnum.Active : status.ToInteger();
var tag = false;
if (!string.IsNullOrEmpty(deptId))
{
ul.Where += string.Format("u.DeptId = {0} ", deptId.ToInteger());
tag = true;
}
if (!string.IsNullOrEmpty(jobTitle))
{
if (tag)
{
ul.Where += string.Format("AND u.JobTitle = {0}", jobTitle.ToInteger());
}
else
{
ul.Where += string.Format("u.JobTitle = {0}", jobTitle.ToInteger());
}
}
DataSet ds = uld.SelectUsersList(ul);
return ConvertUsersList(ds);
}