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(SysException entity) { using (DBContainer db = new DBContainer()) { db.SysException.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(SysSample entity) { using (DBContainer db = new DBContainer()) { db.SysSample.Add(entity); 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(); } }
/// <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 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="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 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(); } }