public int Create(SysRole entity)
{
using (OriginEntities db = new OriginEntities()){
db.SysRole.Add(entity);
return(db.SaveChanges());
}
}
public int Edit(SysModule entity)
{
using (OriginEntities db = new OriginEntities())
{
db.SysModule.Add(entity);
return db.SaveChanges();
}
}
public int Edit(SysRole entity)
{
using (OriginEntities db = new OriginEntities())
{
db.SysRole.Attach(entity);
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 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(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 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="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 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);
}
}
