/// <summary> /// 删除对象集合 /// </summary> /// <param name="db">数据库</param> /// <param name="deleteCollection">集合</param> public int Delete(AppDBContainer db, string id) { SysException entity = db.SysException.SingleOrDefault(x => x.Id == id); db.SysException.Remove(entity); return(db.SaveChanges()); }
public MIS_Article GetById(string id) { using (AppDBContainer db = new AppDBContainer()) { return(db.MIS_Article.SingleOrDefault(a => a.Id == id)); } }
public SysModuleOperate GetById(string id) { using (AppDBContainer db = new AppDBContainer()) { return(db.SysModuleOperate.SingleOrDefault(a => a.Id == id)); } }
/// <summary> /// 获取列表 ///</summary> /// <param name="db">数据库上下文</param> /// <returns>数据列表</returns> public IQueryable <SysSample> GetList(AppDBContainer db) { IQueryable <SysSample> list = db.SysSample.AsQueryable(); return(list); }
public bool Delete(AppDBContainer db, string id) { SysModule entity = db.SysModule.SingleOrDefault(a => a.Id == id); if (entity != null) { //删除SysRight表数据 var sr = db.SysRight.AsQueryable().Where(a => a.ModuleId == id); foreach (var o in sr) { //删除SysRightOperate表数据 var sro = db.SysRightOperate.AsQueryable().Where(a => a.RightId == o.Id); foreach (var o2 in sro) { db.SysRightOperate.Remove(o2); } db.SysRight.Remove(o); } //删除SysModuleOperate数据 var smo = db.SysModuleOperate.AsQueryable().Where(a => a.ModuleId == id); foreach (var o3 in smo) { db.SysModuleOperate.Remove(o3); } db.SysModule.Remove(entity); return(db.SaveChanges() > 0); } return(false); }
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 (AppDBContainer db = new AppDBContainer()) { SysRightOperate right = db.SysRightOperate.Where(a => a.Id == rightOperate.Id).FirstOrDefault(); if (right != null) { right.IsValid = rightOperate.IsValid; } else { db.SysRightOperate.Add(rightOperate); } if (db.SaveChanges() > 0) { //更新角色--模块的有效标志RightFlag var sysRight = (from r in db.SysRight where r.Id == rightOperate.RightId select r).First(); db.P_Sys_UpdateSysRightRightFlag(sysRight.ModuleId, sysRight.RoleId); return(1); } } return(0); }
public SysUser GetById(string id) { using (AppDBContainer db = new AppDBContainer()) { return(db.SysUser.SingleOrDefault(a => a.Id == id)); } }
/// <summary> /// 创建一个实体 ///</summary> /// <param name="db">数据库上下文</param> /// <param name="entity">实体</param> public int Create(SysSample entity) { using (AppDBContainer db = new AppDBContainer()) { db.Set <SysSample>().Add(entity); return(db.SaveChanges()); } }
public int Create(MIS_Article entity) { using (AppDBContainer db = new AppDBContainer()) { db.MIS_Article.Add(entity); return(db.SaveChanges()); } }
public SysUser Login(string userName, string pwd) { using (AppDBContainer db = new AppDBContainer()) { SysUser user = db.SysUser.SingleOrDefault(x => x.UserName == userName && x.Password == pwd); return(user); } }
public int Create(SysUser entity) { using (AppDBContainer db = new AppDBContainer()) { db.SysUser.Add(entity); return(db.SaveChanges()); } }
public int Create(SysModuleOperate entity) { using (AppDBContainer db = new AppDBContainer()) { db.SysModuleOperate.Add(entity); return(db.SaveChanges()); } }
/// <summary> /// 修改一个实体 ///</summary> /// <param name="db">数据库上下文</param> /// <param name="entity">实体</param> public int Edit(SysSample entity) { using (AppDBContainer db = new AppDBContainer()) { db.Set <SysSample>().Attach(entity); db.Entry <SysSample>(entity).State = EntityState.Modified; return(db.SaveChanges()); } }
/// <summary> /// 删除一个实体 ///</summary> /// <param name="db">数据库上下文</param> /// <param name="entity">主键ID</param> public int Delete(string id) { using (AppDBContainer db = new AppDBContainer()) { SysSample entity = db.SysSample.SingleOrDefault(a => a.Id == id); db.Set <SysSample>().Remove(entity); return(db.SaveChanges()); } }
public int Edit(MIS_Article_Category entity) { using (AppDBContainer db = new AppDBContainer()) { db.MIS_Article_Category.Attach(entity); db.Entry(entity).State = EntityState.Modified; return(db.SaveChanges()); } }
/// <summary> /// 创建一个对象 /// </summary> /// <param name="db">数据库</param> /// <param name="entity">实体</param> public int Create(SysLog entity) { using (AppDBContainer db = new AppDBContainer()) { //db.SysLogs.AddObject(entity); db.SysLog.Add(entity); return(db.SaveChanges()); } }
public int Edit(SysRole entity) { using (AppDBContainer db = new AppDBContainer()) { db.SysRole.Attach(entity); db.Entry <SysRole>(entity).State = System.Data.EntityState.Modified; return(db.SaveChanges()); } }
public int Edit(SysUser entity) { using (AppDBContainer db = new AppDBContainer()) { db.SysUser.Attach(entity); db.Entry(entity).State = EntityState.Modified; return(db.SaveChanges()); } }
//按选择的角色及模块加载模块的权限项 public List <P_Sys_GetRightByRoleAndModule_Result> GetRightByRoleAndModule(string roleId, string moduleId) { List <P_Sys_GetRightByRoleAndModule_Result> result = null; using (AppDBContainer db = new AppDBContainer()) { result = db.P_Sys_GetRightByRoleAndModule(roleId, moduleId).ToList(); } return(result); }
public IQueryable <SysUser> GetRefSysUser(AppDBContainer db, string id) { if (!string.IsNullOrEmpty(id)) { return(from m in db.SysRole from f in m.SysUser where m.Id == id select f); } return(null); }
public void Delete(AppDBContainer db, string[] deleteCollection) { IQueryable <SysUser> collection = from f in db.SysUser where deleteCollection.Contains(f.Id) select f; foreach (var deleteItem in collection) { db.SysUser.Remove(deleteItem); } db.SaveChanges(); }
public int Delete(string id) { using (AppDBContainer db = new AppDBContainer()) { SysUser entity = db.SysUser.SingleOrDefault(a => a.Id == id); if (entity != null) { db.SysUser.Remove(entity); } return(db.SaveChanges()); } }
public int Delete(string id) { using (AppDBContainer db = new AppDBContainer()) { MIS_Article_Category entity = db.MIS_Article_Category.SingleOrDefault(a => a.Id == id); if (entity != null) { db.MIS_Article_Category.Remove(entity); } return(db.SaveChanges()); } }
public void Delete(AppDBContainer db, string[] deleteCollection) { IQueryable <MIS_Article_Category> collection = from f in db.MIS_Article_Category where deleteCollection.Contains(f.Id) select f; foreach (var deleteItem in collection) { db.MIS_Article_Category.Remove(deleteItem); } db.SaveChanges(); }
public bool IsExist(string id) { using (AppDBContainer db = new AppDBContainer()) { MIS_Article_Category entity = GetById(id); if (entity != null) { return(true); } return(false); } }
public bool IsExist(string id) { using (AppDBContainer db = new AppDBContainer()) { SysUser entity = GetById(id); if (entity != null) { return(true); } return(false); } }
/// <summary> /// 删除对象集合 /// </summary> /// <param name="db">数据库</param> /// <param name="deleteCollection">集合</param> public int Delete(AppDBContainer db, string id) { IQueryable <SysLog> collection = from f in db.SysLog where f.Id == id select f; foreach (var deleteItem in collection) { //db.SysLogs.DeleteObject(deleteItem); db.SysLog.Remove(deleteItem); } return(db.SaveChanges()); }
public List <PermModel> GetPermission(string accountId, string controller) { using (AppDBContainer db = new AppDBContainer()) { 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 void UpdateSysRoleSysUser(string userId, string[] roleIds) { using (AppDBContainer db = new AppDBContainer()) { db.P_Sys_DeleteSysRoleSysUserByUserId(userId); foreach (string roleid in roleIds) { if (!string.IsNullOrWhiteSpace(roleid)) { db.P_Sys_UpdateSysRoleSysUser(roleid, userId); } } db.SaveChanges(); } }
/// <summary> /// 加入异常日志 /// </summary> /// <param name="ex">异常</param> public static void WriteException(Exception ex) { try { using (AppDBContainer db = new AppDBContainer()) { 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; } } }