public void Delete(DBContainer db, string id)
{
SysModule entity = db.SysModules.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
//删除SysRight表数据
var sr = db.SysRights.AsQueryable().Where(a => a.ModuleId == id);
foreach (var o in sr)
{
//删除SysRightOperate表数据
var sro = db.SysRightOperates.AsQueryable().Where(a => a.RightId == o.Id);
foreach (var o2 in sro)
{
db.SysRightOperates.DeleteObject(o2);
}
db.SysRights.DeleteObject(o);
}
//删除SysModuleOperate数据
var smo = db.SysModuleOperates.AsQueryable().Where(a => a.ModuleId == id);
foreach (var o3 in smo)
{
db.SysModuleOperates.DeleteObject(o3);
}
db.SysModules.DeleteObject(entity);
}
}
public SysModuleOperate GetById(string id)
{
using (DBContainer db = new DBContainer())
{
return db.SysModuleOperates.SingleOrDefault(a => a.Id == id);
}
}
public SysSample GetById(string id)
{
using (DBContainer db = new DBContainer())
{
return db.SysSamples.SingleOrDefault(a => a.ID == id);
}
}
/// <summary>
/// 根据ID获取一个实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public SysException GetById(string id)
{
using (DBContainer db = new DBContainer())
{
return db.SysException.SingleOrDefault(a => a.Id == id);
}
}
public List<SysException> GetList(ref GridPager pager, string queryStr)
{
DBContainer db = new DBContainer();
List<SysException> query = null;
IQueryable<SysException> list = exceptionRepository.GetList(db);
if (!string.IsNullOrWhiteSpace(queryStr))
{
list = list.Where(a => a.Message.Contains(queryStr));
pager.totalRows = list.Count();
}
else
{
pager.totalRows = list.Count();
}
if (pager.order == "desc")
{
query = list.OrderByDescending(c => c.CreateTime).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList();
}
else
{
query = list.OrderBy(c => c.CreateTime).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList();
}
return query;
}
public int UpdateRight(SysRightOperateModel model)
{
//转换
SysRightOperate rightOperate = new SysRightOperate();
rightOperate.Id = model.Id;
rightOperate.RightId = model.RightId;
rightOperate.KeyCode = model.KeyCode;
rightOperate.IsValid = model.IsValid;
//判断rightOperate是否存在，如果存在就更新rightOperate,否则就添加一条
using (DBContainer db = new DBContainer())
{
SysRightOperate right = db.SysRightOperates.Where(a => a.Id == rightOperate.Id).FirstOrDefault();
if (right != null)
{
right.IsValid = rightOperate.IsValid;
}
else
{
db.SysRightOperates.AddObject(rightOperate);
}
if (db.SaveChanges() > 0)
{
//更新角色--模块的有效标志RightFlag
var sysRight = (from r in db.SysRights
where r.Id == rightOperate.RightId
select r).First();
db.P_Sys_UpdateSysRightRightFlag(sysRight.ModuleId, sysRight.RoleId);
return 1;
}
}
return 0;
}
/// <summary>
/// 创建一个实体
/// </summary>
/// <param name="db">数据库上下文</param>
/// <param name="entity">实体</param>
public int Create(SysSample entity)
{
using (DBContainer db = new DBContainer())
{
db.SysSample.Add(entity);
return db.SaveChanges();
}
}
public int Create(SysRole entity)
{
using (DBContainer db = new DBContainer())
{
db.SysRoles.AddObject(entity);
return db.SaveChanges();
}
}
/// <summary>
/// 创建一个对象
/// </summary>
/// <param name="db">数据库</param>
/// <param name="entity">实体</param>
public int Create(SysException entity)
{
using (DBContainer db = new DBContainer())
{
db.SysException.Add(entity);
return db.SaveChanges();
}
}
public SysUser Login(string username, string pwd)
{
using (DBContainer db = new DBContainer())
{
SysUser user = db.SysUsers.SingleOrDefault(a => a.UserName == username && a.Password == pwd);
return user;
}
}
/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="db">数据库上下文</param>
/// <param name="entity">实体</param>
public int Edit(SysSample entity)
{
using (DBContainer db = new DBContainer())
{
db.SysSample.Attach(entity);
db.Entry(entity).State = System.Data.EntityState.Modified;
return db.SaveChanges();
}
}
public int Edit(SysRole entity)
{
using (DBContainer db = new DBContainer())
{
db.SysRoles.Attach(entity);
db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
return db.SaveChanges();
}
}
//按选择的角色及模块加载模块的权限项
public List<P_Sys_GetRightByRoleAndModule_Result> GetRightByRoleAndModule(string roleId, string moduleId)
{
List<P_Sys_GetRightByRoleAndModule_Result> result = null;
using (DBContainer db = new DBContainer())
{
result = db.P_Sys_GetRightByRoleAndModule(roleId, moduleId).ToList();
}
return result;
}
public void Delete(DBContainer db, string[] deleteCollection)
{
IQueryable<SysUser> collection = from f in db.SysUsers
where deleteCollection.Contains(f.Id)
select f;
foreach (var deleteItem in collection)
{
db.SysUsers.DeleteObject(deleteItem);
}
}
public bool IsExist(string id)
{
using (DBContainer db = new DBContainer())
{
SysRole entity = GetById(id);
if (entity != null)
return true;
return false;
}
}
public IQueryable<SysUser> GetRefSysUser(DBContainer db, string id)
{
if (!string.IsNullOrEmpty(id))
{
return from m in db.SysRoles
from f in m.SysUsers
where m.Id == id
select f;
}
return null;
}
public int Delete(string id)
{
using (DBContainer db = new DBContainer())
{
SysRole entity = db.SysRoles.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
db.SysRoles.DeleteObject(entity);
}
return db.SaveChanges();
}
}
/// <summary>
/// 取角色模块的操作权限，用于权限控制
/// </summary>
/// <param name="accountid">acount Id</param>
/// <param name="controller">url</param>
/// <returns></returns>
public List<PermModel> GetPermission(string accountid, string controller)
{
using (DBContainer db = new DBContainer())
{
List<PermModel> rights = (from r in db.P_Sys_GetRightOperate(accountid, controller)
select new PermModel
{
KeyCode = r.KeyCode,
IsValid = r.IsValid
}).ToList();
return rights;
}
}
public List<SysModule> GetMenuByPersonId(string moduleId)
{
using (DBContainer db = new DBContainer())
{
var menus =
(
from m in db.SysModule
where m.ParentId == moduleId
where m.Id != "0"
select m
).Distinct().OrderBy(a => a.Sort).ToList();
return menus;
}
}
/// <summary>
/// 加入异常日志
/// </summary>
/// <param name="ex">异常</param>
public static void WriteException(Exception ex)
{
try
{
using (DBContainer db = new DBContainer())
{
SysException model = new SysException()
{
Id = ResultHelper.NewId,
HelpLink = ex.HelpLink,
Message = ex.Message,
Source = ex.Source,
StackTrace = ex.StackTrace,
TargetSite = ex.TargetSite.ToString(),
Data = ex.Data.ToString(),
CreateTime = ResultHelper.NowTime
};
db.SysExceptions.AddObject(model);
db.SaveChanges();
}
}
catch (Exception ep)
{
try
{
//异常失败写入txt
string path = @"~/exceptionLog.txt";
string txtPath = System.Web.HttpContext.Current.Server.MapPath(path);//获取绝对路径
using (StreamWriter sw = new StreamWriter(txtPath, true, Encoding.Default))
{
sw.WriteLine((ex.Message + "|" + ex.StackTrace + "|" + ep.Message + "|" + DateTime.Now.ToString()).ToString());
sw.Dispose();
sw.Close();
}
return;
}
catch { return; }
}
}
public List<SysModule> GetMenuByPersonId(string personId, string moduleId)
{
using (DBContainer db = new DBContainer())
{
var menus =
(
from m in db.SysModules
join rl in db.SysRights
on m.Id equals rl.ModuleId
join r in
(from r in db.SysRoles
from u in r.SysUsers
where u.Id == personId
select r)
on rl.RoleId equals r.Id
where rl.Rightflag == true
where m.ParentId == moduleId
where m.Id != "0"
select m
).Distinct().OrderBy(a => a.Sort).ToList();
return menus;
}
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="db">数据库</param>
/// <returns>集合</returns>
public IQueryable<SysException> GetList(DBContainer db)
{
IQueryable<SysException> list = db.SysException.AsQueryable();
return list;
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="db">数据库</param>
/// <returns>集合</returns>
public IQueryable<SysLog> GetList(DBContainer db)
{
IQueryable<SysLog> list = db.SysLogs.AsQueryable();
return list;
}
public void UpdateSysRoleSysUser(string roleId,string[] userIds)
{
using(DBContainer db = new DBContainer())
{
db.P_Sys_DeleteSysRoleSysUserByRoleId(roleId);
foreach (string userid in userIds)
{
if (!string.IsNullOrWhiteSpace(userid))
{
db.P_Sys_UpdateSysRoleSysUser(roleId, userid);
}
}
db.SaveChanges();
}
}
public IQueryable<SysModuleOperate> GetList(DBContainer db)
{
IQueryable<SysModuleOperate> list = db.SysModuleOperates.AsQueryable();
return list;
}
public IQueryable<P_Sys_GetUserByRoleId_Result> GetUserByRoleId(DBContainer db, string roleId)
{
return db.P_Sys_GetUserByRoleId(roleId).AsQueryable();
}
public IQueryable<SysUser> GetList(DBContainer db)
{
IQueryable<SysUser> list = db.SysUsers.AsQueryable();
return list;
}
public IQueryable<SysRole> GetList(DBContainer db)
{
IQueryable<SysRole> list = db.SysRoles.AsQueryable();
return list;
}
public IQueryable<P_Sys_GetRoleByUserId_Result> GetRoleByUserId(DBContainer db, string userId)
{
return db.P_Sys_GetRoleByUserId(userId).AsQueryable();
}
public BaseBLL()
{
dbContainer = new DBContainer();
}
