public User Login(string userName, string password)
{
using (HelpDbContext db = new HelpDbContext())
{
return(db.Users.FirstOrDefault(s => s.UserName == userName && s.PassWard == password));
}
}
public User GetUser(int id)
{
using (HelpDbContext db = new HelpDbContext())
{
return(db.Users.FirstOrDefault(s => s.Id == id));
}
}
/// <summary>
/// 获取user
/// </summary>
/// <param name="expression"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public PagedResult <UserDto> GetList(Expression <Func <UserDto, bool> > expression, int page, int rows)
{
using (HelpDbContext db = new HelpDbContext())
{
var qry = from u in db.Users
select new UserDto
{
Id = u.Id,
UserName = u.UserName,
Moblie = u.Moblie,
RealName = u.RealName,
PassWard = u.PassWard,
Email = u.Email,
CreateTime = u.CreateTime,
Birthday = u.Birthday,
Qq = u.Qq,
Sex = u.Sex == 1 ? "男" :"女"
};
qry = qry.Where(expression);
return(new PagedResult <UserDto>()
{
PageNumber = page,
PageSize = rows,
Data = qry.OrderByDescending(s => s.CreateTime).Skip((page - 1) * rows).Take(rows).ToListOrDefault(),
TotalRecords = qry.Count()
});
}
}
public bool AddAdmin(User user)
{
using (HelpDbContext db = new HelpDbContext())
{
var model = db.Users.FirstOrDefault(s => s.UserName == user.UserName);
if (model != null)
{
return(false);
}
db.Users.Add(user);
return(db.SaveChanges() > 0);
}
}
public bool EditAdmin(User user)
{
using (HelpDbContext db = new HelpDbContext())
{
var model = db.Users.FirstOrDefault(s => s.Id == user.Id);
model.UserName = user.UserName;
model.RealName = user.RealName;
model.Sex = user.Sex;
model.Moblie = user.Moblie;
model.Qq = user.Qq;
model.Email = user.Email;
model.Birthday = user.Birthday;
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 是否有权限
/// </summary>
/// <param name="roleId"></param>
/// <param name="code"></param>
/// <returns></returns>
public bool IsAuthorizePass(int id, string code)
{
using (HelpDbContext ctx = new HelpDbContext())
{
string sql = string.Format(@"SELECT [actionid] as [Id]
,[actionkey] as [ActionKey]
,[actionname] as [ActionName]
,[menuid] as [MenuId]
,[sort] as [Sort] from admin_action
where actionid =
(
select actionid from admin_roleaction
where roleid = {0} and actionid = '{1}'
)", id, code);
var action = ctx.Database.SqlQuery <Model.admin.AdminAction>(sql).FirstOrDefault();
return(action == null ? false : true);
}
}
/// <summary>
/// 通过目录获取权限
/// </summary>
/// <param name="roleId"></param>
/// <param name="id"></param>
/// <returns></returns>
public List <AdminAction> GetActionByMenuId(int id, string menuId)
{
using (HelpDbContext ctx = new HelpDbContext())
{
string sql = string.Format(@"SELECT [actionid] as [Id]
,[actionkey] as [ActionKey]
,[actionname] as [ActionName]
,[menuid] as [MenuId]
,[sort] as [Sort] from admin_action
where menuid='{0}' and actionid in
(
select actionid from admin_roleaction
where roleid = {1}
)", menuId, id);
var actions = ctx.Database.SqlQuery <AdminAction>(sql).AsQueryable();
return(actions.ToListOrDefault());
}
}
/// <summary>
/// 二级菜单
/// </summary>
/// <param name="adminId"></param>
/// <param name="parentMenuId"></param>
/// <returns></returns>
public List <AdminMenu> GetAdministratorsecondMenu(int adminId, string parentMenuId)
{
using (HelpDbContext ctx = new HelpDbContext())
{
var sqlParm1 = new SqlParameter
{
ParameterName = "@UserID",
Value = adminId,
Direction = System.Data.ParameterDirection.Input
};
var sqlParm2 = new SqlParameter
{
ParameterName = "@ParentMenuID",
Value = parentMenuId,
Direction = System.Data.ParameterDirection.Input
};
return(ctx.Database.SqlQuery <AdminMenu>("exec UserMenu @UserID,@ParentMenuID", sqlParm1, sqlParm2).AsQueryable().ToListOrDefault());
}
}
public List <UserDto> Excel(Expression <Func <UserDto, bool> > expression)
{
using (HelpDbContext db = new HelpDbContext())
{
var qry = from u in db.Users
select new UserDto
{
Id = u.Id,
UserName = u.UserName,
Moblie = u.Moblie,
RealName = u.RealName,
PassWard = u.PassWard,
Email = u.Email,
CreateTime = u.CreateTime,
Birthday = u.Birthday,
Qq = u.Qq,
Sex = u.Sex == 1 ? "男" : "女"
};
return(qry.Where(expression).ToList());
}
}
public UsuarioRepository(HelpDbContext helpDbContext)
{
_context = helpDbContext;
}