public IEnumerable <OfficerModel> Page(string orgId, string ptId, string name, string code, int page, int size, out int count)
{
using (var officerHandler = new OfficerHandle(Repository))
using (var userHandler = new UserHandle(Repository))
using (var orgHandler = new OrganizationHandle(Repository))
using (var ptpHandler = new PoliceTypeHandle(Repository))
{
var noDel = (short)DeleteStatus.No;
var query =
from officer in officerHandler.All(t => t.IsDel == noDel)
join useritem in userHandler.All(t => t.IsDel == noDel) on officer.UserId equals useritem.Id into usrs
from usr in usrs.DefaultIfEmpty(new User {
})
join org in orgHandler.All(t => t.IsDel == noDel) on officer.OrgId equals org.Id
join ptp in ptpHandler.All(t => t.IsDel == noDel) on officer.PtId equals ptp.Id
select new { officer = officer, usr = usr, org = org, ptp = ptp };
if (!string.IsNullOrWhiteSpace(name))
{
query = query.Where(t => t.officer.Name.Contains(name));
}
if (!string.IsNullOrWhiteSpace(code))
{
query = query.Where(t => t.officer.IdentyCode.Contains(code));
}
if (!string.IsNullOrWhiteSpace(ptId))
{
query = query.Where(t => t.officer.PtId == ptId);
}
if (!string.IsNullOrWhiteSpace(orgId))
{
query = query.Where(t => t.officer.OrgId == orgId);
}
if (string.IsNullOrWhiteSpace(orgId) && !User.IsSupperAdministrator)
{
orgId = User.Organization.Id;
query = query.Where(t => t.officer.OrgId == orgId);
}
count = query.Count();
var skipCount = (page - 1) * size;
var items =
query.OrderByDescending(t => t.officer.SignupDate).Skip(skipCount).Take(size).ToArray()
.Select(t => new OfficerModel
{
officer = t.officer,
org = t.org,
ptp = t.ptp,
user = t.usr
});
return(items);
}
}
public IEnumerable <AccountModel> Page(string orgId, string roleId, int page, int size, out int count)
{
var noDel = (short)DeleteStatus.No;
using (var userHandler = new UserHandle(Repository))
using (var roleHandler = new RoleHandle(Repository))
using (var orgHandler = new OrganizationHandle(Repository))
{
var query =
from usr in userHandler.All(t => t.IsDel == noDel)
join ritem in roleHandler.All(t => t.IsDel == noDel) on usr.RoleId equals ritem.Id into rls
from role in rls.DefaultIfEmpty(new Role {
})
join orgitem in orgHandler.All(t => t.IsDel == noDel) on usr.OrgId equals orgitem.Id into orgs
from org in orgs.DefaultIfEmpty(new Organization {
})
select new { usr = usr, role = role, org = org };
var roleEmp = string.IsNullOrWhiteSpace(roleId);
if (!roleEmp)
{
query = query.Where(t => t.role.Id == roleId);
}
if (roleEmp && !User.IsSupperAdministrator)
{
orgId = string.IsNullOrWhiteSpace(orgId) ? User.Organization.Id : orgId;
query = query.Where(t => t.org.Pid == orgId);
}
count = query.Count();
var skipCount = (page - 1) * size;
return
(query.OrderBy(t => t.usr.SignupDate).Skip(skipCount).Take(size).ToArray().Select(t => new AccountModel
{
org = t.org,
role = t.role,
user = t.usr
}).ToArray());
}
}
/// <summary>
/// 使用用户名和密码获取用户内容
/// </summary>
/// <param name="userId">用户名</param>
/// <param name="passwd">密码</param>
/// <param name="user">返回的用户信息</param>
/// <returns></returns>
public AccountLoginStatus Signin(string userId, string passwd, out UserInfo user)
{
var userHandler = new UserHandle(Repository);
var roleHandler = new RoleHandle(Repository);
var officerHandler = new OfficerHandle(Repository);
var orgHandler = new OrganizationHandle(Repository);
var featureHandler = new FeatureHandle(Repository);
var menuHandler = new MenuHandle(Repository);
var isDel = (short)DeleteStatus.No;
var query =
from usr in userHandler.All(t => t.Account == userId && t.IsDel == isDel)
join orgitem in orgHandler.All(t => t.IsDel == isDel) on usr.OrgId equals orgitem.Id into orgarr
from org in orgarr.DefaultIfEmpty(new data.entity.Organization())
join officeritem in officerHandler.All(t => t.IsDel == isDel) on usr.Id equals officeritem.UserId into officers
from officer in officers.DefaultIfEmpty(new data.entity.Officer())
join roleitem in roleHandler.All(t => t.IsDel == isDel) on usr.RoleId equals roleitem.Id into roles
from role in roles.DefaultIfEmpty(new data.entity.Role())
join fitem in featureHandler.All(t => t.IsDel == isDel) on role.Id equals fitem.RoleId into farr
from feature in farr.DefaultIfEmpty(new data.entity.Feature())
join mitem in menuHandler.All(t => t.IsDel == isDel) on feature.MenuId equals mitem.Id into marr
from menu in marr.DefaultIfEmpty(new data.entity.Menu())
select new { usr = usr, org = org, officer = officer, role = role, feature = feature, menu = menu };
user =
query
.GroupBy(t => new { usr = t.usr, org = t.org, officer = t.officer, role = t.role })
.ToArray()
.Select(t => new UserInfo
{
User = t.Key.usr,
Officer = t.Key.officer,
Organization = t.Key.org,
Role = t.Key.role,
Features = t.Select(x => x.feature).Where(x => !string.IsNullOrWhiteSpace(x.MenuId)),
Menus = t.Select(x => x.menu).Where(x => !string.IsNullOrWhiteSpace(x.Title))
})
.FirstOrDefault();
if (user == null)
{
return(AccountLoginStatus.UserNoExist);
}
if (user.User.Passwd != EscapePassword(userId, passwd))
{
return(AccountLoginStatus.PasswordError);
}
if (user.User.Status == (int)AccountStatus.Exception)
{
return(AccountLoginStatus.ExceptionAccount);
}
if (user.User.Status == (int)AccountStatus.Locked)
{
return(AccountLoginStatus.LockedAccount);
}
user.User.SigninStatus = (short)AccountSigninStatus.Online;
if (null == userHandler.Modify(user.User, true))
{
return(AccountLoginStatus.Error);
}
return(AccountLoginStatus.Success);
}