/// <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; }
}
}
