public SysUser GetById(int id)
{
using (OriginEntities db = new OriginEntities())
{
return(db.SysUser.SingleOrDefault(a => a.Id == id));
}
}
public SysRole GetById(string id)
{
using (OriginEntities db = new OriginEntities())
{
return(db.SysRole.SingleOrDefault(a => a.Id == id));
}
}
public SysModule GetById(string id)
{
using (OriginEntities db = new OriginEntities())
{
return db.SysModule.SingleOrDefault(a => a.ModuleId == id);
}
}
public int Create(SysRole entity)
{
using (OriginEntities db = new OriginEntities()){
db.SysRole.Add(entity);
return(db.SaveChanges());
}
}
public SysUser Login(string username, string pwd)
{
using (OriginEntities db = new OriginEntities())
{
SysUser user = db.SysUser.SingleOrDefault(a => a.UserName == username && a.Password == pwd);
return(user);
}
}
public int Edit(SysRole entity)
{
using (OriginEntities db = new OriginEntities())
{
db.SysRole.Attach(entity);
return(db.SaveChanges());
}
}
public int Edit(SysModule entity)
{
using (OriginEntities db = new OriginEntities())
{
db.SysModule.Add(entity);
return db.SaveChanges();
}
}
public int Edit(SysUser entity)
{
using (OriginEntities db = new OriginEntities())
{
db.Set <SysUser>().Attach(entity);
db.Entry <SysUser>(entity).State = EntityState.Modified;
return(db.SaveChanges());
}
}
public int Delete(int id)
{
using (OriginEntities db = new OriginEntities())
{
SysUser entity = db.SysUser.SingleOrDefault(a => a.Id == id);
db.Set <SysUser>().Remove(entity);
return(db.SaveChanges());
}
}
public bool IsExist(string id)
{
using (OriginEntities db = new OriginEntities())
{
SysModule entity = GetById(id);
if (entity != null)
return true;
return false;
}
}
public List <P_Sys_GetRightByRoleAndModule_Result> GetRightByRoleAndModule(string roleId, string moduleId)
{
List <P_Sys_GetRightByRoleAndModule_Result> results = null;
using (OriginEntities db = new OriginEntities())
{
results = db.P_Sys_GetRightByRoleAndModule(roleId, moduleId).ToList();
}
return(results);
}
public int Delete(string id)
{
using (OriginEntities db = new OriginEntities()){
SysRole entity = db.SysRole.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
db.SysRole.Remove(entity);
}
return(db.SaveChanges());
}
}
/// <summary>
/// 删除对象集合
/// </summary>
/// <param name="db">数据库</param>
/// <param name="deleteCollection">集合</param>
public void Delete(OriginEntities db, string[] deleteCollection)
{
IQueryable <SysLog> collection = from f in db.SysLog
where deleteCollection.Contains(f.Id.ToString())
select f;
foreach (var deleteItem in collection)
{
db.SysLog.Remove(deleteItem);
}
db.SaveChanges();
}
public bool IsExist(string id)
{
using (OriginEntities db = new OriginEntities())
{
SysRole entity = db.SysRole.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
return(true);
}
return(false);
}
}
public bool IsExist(int id)
{
using (OriginEntities db = new OriginEntities())
{
SysUser user = GetById(id);
if (user != null)
{
return(true);
}
return(false);
}
}
public bool IsExist(string id)
{
using (OriginEntities db = new OriginEntities())
{
SysModuleOperate entity = new SysModuleOperate();
if (entity != null)
{
return(true);
}
return(false);
}
}
public void Delete(OriginEntities db, string[] deleteCollection)
{
IQueryable <SysUser> collection = from u in db.SysUser
where
deleteCollection.Contains(u.Id.ToString())
select u;
foreach (var item in collection)
{
db.SysUser.Remove(item);
}
db.SaveChanges();
}
/// <summary>
/// 取角色模块的操作权限，用于权限控制
/// </summary>
/// <param name="accountid">acount Id</param>
/// <param name="controller">url</param>
/// <returns></returns>
public List <PermModel> GetPermission(int accountid, string controller)
{
using (OriginEntities db = new OriginEntities())
{
List <PermModel> rights = (from r in db.P_Sys_GetRightOperate(accountid, controller)
select new PermModel
{
KeyCode = r.KeyCode,
IsValid = r.IsValid
}).ToList();
return(rights);
}
}
/// <summary>
/// 获取模块资源，按钮除外
/// </summary>
/// <param name="keyList"></param>
/// <returns></returns>
public static IList <SysModule> GetModuleListOutBtn(IList <int?> keyList)
{
OriginEntities model = new OriginEntities();
IList <SysModule> modules = new List <SysModule>();
keyList.Each(c =>
{
var module = model.SysModule.FirstOrDefault(m => m.IsDel == 0 && m.ModuleId == c.ToString() && m.ModuleLevel != 3);
if (module != null)
{
modules.Add(module);
}
});
return(modules.OrderBy(c => c.Sort).ToList());
}
public List <SysLog> GetList(ref GridPager pager, string queryStr)
{
OriginEntities db = new OriginEntities();
List <SysLog> query = null;
IQueryable <SysLog> list = logDAL.GetList(db);
if (!string.IsNullOrWhiteSpace(queryStr))
{
list = list.Where(a => a.Message.Contains(queryStr) || a.Module.Contains(queryStr));
pager.totalRows = list.Count();
}
else
{
pager.totalRows = list.Count();
}
query = LinqHelper.SortingAndPaging(list, pager.sort, pager.order, pager.page, pager.rows).ToList();
return(query);
}
public List <SysException> GetList(ref GridPager pager, string queryStr)
{
OriginEntities db = new OriginEntities();
List <SysException> query = null;
IQueryable <SysException> list = exceptionDAL.GetList(db);
if (!string.IsNullOrWhiteSpace(queryStr))
{
list = list.Where(a => a.Message.Contains(queryStr));
pager.totalRows = list.Count();
}
else
{
pager.totalRows = list.Count();
}
query = LinqHelper.DataSorting(list, pager.sort, pager.order).ToList();
return(query);
}
/// <summary>
/// 获取资源模块
/// </summary>
/// <param name="keyList">资源模块主键</param>
/// <returns></returns>
public static IList <SysModule> GetModuleList(IList <int> keyList)
{
OriginEntities model = new OriginEntities();
IList <SysModule> modules = new List <SysModule>();
//foreach (var item in keyList)
//{
// var module = model.SysModule.FirstOrDefault(m => m.IsDel == 0 && m.ModuleId == item.GetInt().t);
//}
keyList.Each(c =>
{
var module = model.SysModule.FirstOrDefault(m => m.IsDel == 0 && m.ModuleId == c.ToString());
if (module != null)
{
modules.Add(module);
}
});
return(modules.OrderBy(c => c.Sort).ToList());
}
/// <summary>
/// 加入异常日志
/// </summary>
/// <param name="ex">异常</param>
public static void WriteException(Exception ex)
{
try
{
using (OriginEntities db = new OriginEntities())
{
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.SysException.Add(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 void Delete(OriginEntities db, string id)
{
SysModule entity = db.SysModule.SingleOrDefault(a => a.ModuleId == id);
if (entity != null)
{
//删除SysRight表数据
var sr = db.SysRight.AsQueryable().Where(a => a.ModuleId == id);
foreach (var o in sr)
{
var sro = db.SysRightOperate.AsQueryable().Where(a => a.RightId == o.Id);
foreach (var o2 in sro)
{
db.SysRightOperate.Remove(o2);
}
}
var smo = db.SysModuleOperate.AsQueryable().Where(a => a.ModuleId == id);
foreach (var o3 in smo)
{
db.SysModuleOperate.Remove(o3);
}
db.SysModule.Remove(entity);
}
}
public List<SysModule> GetMenuByPersonId(int personId, string moduleId)
{
using (OriginEntities db = new OriginEntities())
{
//得到角色
var roles = from r in db.SysRoleSysUser
from u in db.SysUser
where u.Id == personId
select r;
var menus = (from m in db.SysModule
from ri in db.SysRight
where ri.ModuleId == m.ModuleId
where roles.Any(r => r.SysRoleId == ri.RoleId)
where ri.Rightflag == true
where m.ParentId == moduleId
where m.ModuleId != "0"
where m.IsDisplay==true
select m)
.Distinct().OrderBy(a => a.Sort);
return menus.ToList();
}
}
public int UpdateRight(SysRightOperate model)
{
using (OriginEntities db = new OriginEntities())
{
SysRightOperate right = db.SysRightOperate.Where(a => a.Id == model.Id).FirstOrDefault();
if (right != null)
{
right.IsValid = model.IsValid;
}
else
{
db.SysRightOperate.Add(model);
}
if (db.SaveChanges() > 0)
{
var sysRight = (from r in db.SysRight
where r.Id == model.RightId
select r).First();
db.P_Sys_UpdateSysRightRightFlag(sysRight.ModuleId, sysRight.RoleId);
return(1);
}
return(0);
}
}
public IQueryable <SysUser> GetList(OriginEntities db)
{
IQueryable <SysUser> list = db.SysUser.AsQueryable();
return(list);
}
public IQueryable<SysModule> GetList(OriginEntities db)
{
return db.SysModule.AsQueryable();
}
public IQueryable <SysModule> GetList(OriginEntities db)
{
return(SysModuleDAL.GetList(db));
}
public IQueryable<SysModule> GetModuleBySystem(OriginEntities db, string parentId)
{
return db.SysModule.Where(a => a.ParentId == parentId).AsQueryable();
}
