public List <ADDepartment> GetDepList()
{
List <ADDepartment> list = new List <ADDepartment>();
SQLGetDataList bll = new SQLGetDataList();
try
{
var dataList = bll.GetBsonDocumentDataList(connString, "select * from OADep where [IsActive] = 1");
foreach (var item in dataList)
{
ADDepartment dep = new ADDepartment();
dep.DepId = item.Int("DepID");
dep.Name = item.Text("DepName");
dep.Guid = item.Text("DepID");
dep.Code = item.Text("DepCode");
dep.ParentGuid = item.Text("ParentDepID");
dep.Level = item.Int("DepLevel");
list.Add(dep);
}
}
catch (Exception ex)
{
_log.Error(ex.Message);
}
return(list);
}
public List <BsonDocument> GetDataList()
{
List <BsonDocument> list = new List <BsonDocument>();
SQLGetDataList bll = new SQLGetDataList();
try
{
list = bll.GetBsonDocumentDataList(_connString, "select * from person_mobile_no where fd_mobile_no is not null and fd_mobile_no <>''");
}
catch (Exception ex)
{
_log.Error(ex.Message);
}
return(list);
}
public List <ADUser> GetUserList()
{
List <ADUser> list = new List <ADUser>();
SQLGetDataList bll = new SQLGetDataList();
try
{
var userList = bll.GetBsonDocumentDataList(connString, "select * from OAUserInfo where [IsActive] = 1");
var relList = bll.GetBsonDocumentDataList(connString, "select * from OADepUsers");
foreach (var item in userList)
{
ADUser user = new ADUser();
user.UserId = item.Int("UserID");
user.Name = item.Text("UserNameCn");
user.LoginName = item.Text("UserNameEn");
user.EmailAddr = item.Text("Email");
user.MobieNumber = item.Text("Mobile");
user.PhoneNumber = item.Text("OfficeTel");
user.Guid = item.Text("UserID");
user.Remark = item.Text("UserAD");
var rel = relList.Where(t => t.Int("UserID") == item.Int("UserID")).ToList();
if (rel.Count > 0)
{
user.DepartMentGuids = new List <string>();
foreach (var entity in rel)
{
user.DepartMentGuids.Add(entity.Text("DepID"));
}
}
list.Add(user);
}
}
catch (Exception ex)
{
_log.Error(ex.Message);
}
return(list);
}