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 (AppsDBEntities db = new AppsDBEntities())
{
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 int Create(Flow_FormAttr entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.Flow_FormAttr.Add(entity);
return(db.SaveChanges());
}
}
public int Create(Flow_FormContentStepCheck entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.Flow_FormContentStepCheck.Add(entity);
return(db.SaveChanges());
}
}
public int Create(Flow_StepRule entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.Flow_StepRule.Add(entity);
return(db.SaveChanges());
}
}
/// <summary>
/// 添加一个实体
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Create(SysSample entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.Set <SysSample>().Add(entity);
return(db.SaveChanges());
}
}
/// <summary>
/// 创建一个对象
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Create(SysLog entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.SysLog.Add(entity);//db.SysLog.AddObject(entity); 博客里面这么写，代码报错，没有addObject
return(db.SaveChanges());
}
}
/// <summary>
/// 创建一个实体
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Create(SysException entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.SysException.Add(entity);
return(db.SaveChanges());
}
}
public int Create(SysStruct entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.SysStruct.Add(entity);
return(db.SaveChanges());
}
}
public int Create(MIS_Article_Category entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.MIS_Article_Category.Add(entity);
return(db.SaveChanges());
}
}
public int Create(SysModuleOperate entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.SysModuleOperate.Add(entity);
return(db.SaveChanges());
}
}
public int Create(WC_MessageResponse entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.WC_MessageResponse.Add(entity);
return(db.SaveChanges());
}
}
public int Create(WC_OfficalAccounts entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.WC_OfficalAccounts.Add(entity);
return(db.SaveChanges());
}
}
/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Edit(SysSample entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.Set <SysSample>().Attach(entity);
db.Entry <SysSample>(entity).State = EntityState.Modified;
return(db.SaveChanges());
}
}
/// <summary>
/// 删除一条实体
/// </summary>
/// <param name="id">实体ID</param>
/// <returns></returns>
public int Delete(string id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
SysSample entity = db.SysSample.SingleOrDefault(a => a.Id == id);
db.Set <SysSample>().Remove(entity);
return(db.SaveChanges());
}
}
public int Create(SysModule entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
//db.SysModule.AddObject(entity);
db.SysModule.Add(entity);
return(db.SaveChanges());
}
}
public int Delete(int id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
var entity = db.SysUser.SingleOrDefault(s => s.Id == id);
db.SysUser.Remove(entity);
return(db.SaveChanges());
}
}
public int Delete(string id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
SysException entity = db.SysException.SingleOrDefault(a => a.Id == id);
db.SysException.Remove(entity);
return(db.SaveChanges());
}
}
public int Edit(MIS_Article_Category entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.MIS_Article_Category.Attach(entity);
//db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
db.Entry <MIS_Article_Category>(entity).State = EntityState.Modified;
return(db.SaveChanges());
}
}
public int Edit(WC_MessageResponse entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.WC_MessageResponse.Attach(entity);
db.Entry <WC_MessageResponse>(entity).State = EntityState.Modified;
//db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
return(db.SaveChanges());
}
}
public int Edit(Flow_FormContentStepCheck entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.Flow_FormContentStepCheck.Attach(entity);
db.Entry <Flow_FormContentStepCheck>(entity).State = System.Data.Entity.EntityState.Modified;
//db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
return(db.SaveChanges());
}
}
public int Edit(SysRole entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.SysRole.Attach(entity);
//db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
db.Entry <SysRole>(entity).State = EntityState.Modified;
return(db.SaveChanges());
}
}
public int Edit(WC_OfficalAccounts entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.WC_OfficalAccounts.Attach(entity);
db.Entry <WC_OfficalAccounts>(entity).State = EntityState.Modified;
//db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
return(db.SaveChanges());
}
}
public int Edit(Flow_Form entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.Flow_Form.Attach(entity);
db.Entry <Flow_Form>(entity).State = EntityState.Modified;
//db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
return(db.SaveChanges());
}
}
public int Delete(string id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
SysModuleOperate entity = db.SysModuleOperate.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
db.SysModuleOperate.Remove(entity);
}
return(db.SaveChanges());
}
}
public int Delete(string id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
WC_MessageResponse entity = db.WC_MessageResponse.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
db.WC_MessageResponse.Remove(entity);
}
return(db.SaveChanges());
}
}
public int Delete(string id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
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 int Delete(string id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
Flow_FormContentStepCheck entity = db.Flow_FormContentStepCheck.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
db.Flow_FormContentStepCheck.Remove(entity);
}
return(db.SaveChanges());
}
}
/// <summary>
/// 删除对象集合
/// </summary>
/// <param name="db">数据库</param>
/// <param name="deleteCollection">集合</param>
public void Delete(AppsDBEntities db, string[] deleteCollection)
{
IQueryable <SysLog> collection = from f in db.SysLog
where deleteCollection.Contains(f.Id)
select f;
foreach (var deleteItem in collection)
{
db.SysLog.Remove(deleteItem);
db.SaveChanges();
}
}
public int Delete(string id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
WC_OfficalAccounts entity = db.WC_OfficalAccounts.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
db.WC_OfficalAccounts.Remove(entity);
}
return(db.SaveChanges());
}
}
public void UpdateSysRoleSysUser(string roleId, string[] userIds)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.P_Sys_DeleteSysRoleSysUserByRoleId(roleId);
foreach (string userid in userIds)
{
if (!string.IsNullOrWhiteSpace(userid))
{
db.P_Sys_UpdateSysRoleSysUser(roleId, userid);
}
}
db.SaveChanges();
}
}
