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();
}
}
