/// <summary> /// 修改分类数据 /// </summary> /// <returns></returns> public static bool Modify(Entity.CusCategory entity) { if (entity == null) { return(false); } var db = new DataCore.EFDBContext(); Entity.CusCategory p_entity = null; if (entity.PID != null) { p_entity = db.CusCategorys.Find(entity.PID); if (p_entity == null) { entity.PID = null; entity.Depth = 1; } else { entity.Depth = p_entity.Depth + 1; } } db.Entry <Entity.CusCategory>(entity).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); db.Dispose(); return(true); }
/// <summary> /// 添加分类数据 /// </summary> /// <returns></returns> public static int Add(Entity.CusCategory entity) { if (entity == null) { return(-1); } var db = new DataCore.EFDBContext(); Entity.CusCategory p_entity = null; if (entity.PID != null) { p_entity = db.CusCategorys.Find(entity.PID); if (p_entity == null) { entity.PID = null; entity.Depth = 1; } else { entity.Depth = p_entity.Depth + 1; } } db.CusCategorys.Add(entity); db.SaveChanges(); db.Dispose(); return(entity.ID); }
/// <summary> /// 设置消息已读 /// </summary> /// <param name="id">-1时全部,否则单挑</param> /// <returns></returns> public static bool SetMsgRead(int id, out string msg) { msg = "ok"; using (var db = new DataCore.EFDBContext()) { if (id == -1) { db.Database.ExecuteSqlCommand("Update SysMessage set IsRead = 1 where IsRead = 0"); } else { var entity = db.SysMessages.Find(id); if (entity != null) { if (!entity.IsRead) { entity.IsRead = true; db.SaveChanges(); } } } } return(true); }