/// <summary> /// 更新到数据库 /// </summary> public void Update() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from msg in Applicate.AccountDbContext.MessageList where msg.Jid == this.Jid select msg ).FirstOrDefault(); if (result != null) { //result.Jid = this.Jid; result.UnReadCount = this.UnReadCount; result.MessageTitle = this.MessageTitle; result.MessageItemType = this.MessageItemType; result.MessageItemContent = this.MessageItemContent; result.TimeSend = this.TimeSend; result.Msg = this.Msg; result.Avator = this.Avator; result.ShowTitle = this.ShowTitle; //result.Id = this.Id; //Applicate.dbContext.Entry(result).State = EntityState.Modified; var res = Applicate.AccountDbContext.SaveChanges(); ConsoleLog.Output("Update RecentList --:" + res);// } } }
/// <summary> /// 更新公告至数据库(By Id) /// </summary> /// <param name="desc">公告</param> public void UpdateDescById(string desc) { lock (Applicate.AccountDbContext) { try { SQLiteDBContext.DBAutoConnect(); var result = ( from rom in Applicate.AccountDbContext.Rooms where rom.id == this.id select rom ).FirstOrDefault(); if (result != null) { result.desc = desc; Applicate.AccountDbContext.Entry(result).Property(r => r.desc).IsModified = true;//设置单字段更新 Applicate.AccountDbContext.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } }
public RoomShare GetByShareId() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); return(Applicate.AccountDbContext.RoomShares.FirstOrDefault(d => d.roomId == this.roomId && d.shareId == this.shareId)); } }
/// <summary> /// 根据RoomId获取群成员数量 /// </summary> /// <param name="roomid">RoomId</param> /// <returns></returns> internal int GetCountByRoomId(string roomid) { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); int count = Applicate.AccountDbContext.RoomMembers.Count(m => m.groupid == roomid); return(count); } }
/// <summary> /// 根据GroupId获取成员数量 /// </summary> /// <returns></returns> public int CountByRoomId() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); int result = Applicate.AccountDbContext.RoomMembers.Count(m => m.groupid == this.groupid); return(result); } }
/// <summary> /// 删除 /// </summary> public void Delete() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); Applicate.AccountDbContext.RoomMembers.Remove(this); Applicate.AccountDbContext.SaveChanges(); } }
/// <summary> /// 根据toUserId获得本地数据库对象 /// </summary> /// <returns></returns> public DataOfFriends GetByUserId() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = Applicate.AccountDbContext.Friends.FirstOrDefault(f => f.toUserId == this.toUserId); return(result); } }
/// <summary> /// 是否存在对应Jid的群 /// </summary> /// <returns></returns> internal bool Exists() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = Applicate.AccountDbContext.Rooms.Count(r => r.jid == this.jid); return(result != 0); } }
/// <summary> /// 更新到数据库 /// </summary> public void Update() { try { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from friend in Applicate.AccountDbContext.Friends where friend.toUserId == this.toUserId select friend ).FirstOrDefault(); result.active = this.active; result.areaCode = this.areaCode; result.areaId = this.areaId; result.attCount = this.attCount; result.balance = this.balance; result.birthday = this.birthday; result.cityId = this.cityId; result.companyId = this.companyId; result.countryId = this.countryId; result.createTime = this.createTime; result.description = this.description; result.fansCount = this.fansCount; result.friendsCount = this.friendsCount; result.idcard = this.idcard; result.idcardUrl = this.idcardUrl; result.isAuth = this.isAuth; result.level = this.level; result.modifyTime = this.modifyTime; result.name = this.name; result.nickname = this.nickname; result.num = this.num; result.offlineNoPushMsg = this.offlineNoPushMsg; result.onlinestate = this.onlinestate; result.password = this.password; result.phone = this.phone; result.provinceId = this.provinceId; result.sex = this.sex; result.status = this.status; result.telephone = this.telephone; result.totalConsume = this.totalConsume; result.totalRecharge = this.totalRecharge; result.toUserId = this.toUserId; result.toNickname = this.toNickname; result.userKey = this.userKey; result.userType = this.userType; result.vip = this.vip; Applicate.AccountDbContext.SaveChanges(); } } catch (Exception ex) { ConsoleLog.Output(ex.Message); } }
/// <summary> /// 好友总数 /// </summary> /// <returns></returns> internal int FriendsCount() { lock (Applicate.AccountDbContext) { int res = 0; SQLiteDBContext.DBAutoConnect(); res = Applicate.AccountDbContext.Friends.Count(); return(res); } }
/// <summary> /// 获取对应UserId的好友昵称 /// </summary> /// <param name="toUserId"></param> /// <returns></returns> public string GetUserNameByUserId(string toUserId) { string nickname = ""; SQLiteDBContext.DBAutoConnect(); nickname = (from friends in Applicate.AccountDbContext.Friends where friends.userId == toUserId select friends.toNickname ).FirstOrDefault();//获取对应UserId的好友的昵称 return(nickname); }
/// <summary> /// 根据status获得列表 /// </summary> public List <DataOfFriends> GetListByStatus() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from friend in Applicate.AccountDbContext.Friends where friend.status == this.status select friend); return(result.ToList()); } }
/// <summary> /// 获取好友列表 /// </summary> /// <returns></returns> public List <VerifingFriend> GetVerifingsList() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from verify in Applicate.AccountDbContext.VerifingFriends select verify ); return(result.ToList()); } }
public List <DataOfFriends> GetByUserName() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from friend in Applicate.AccountDbContext.Friends where friend.toNickname.Contains(this.toNickname) select friend).ToList(); return(result); } }
/// <summary> /// 根据UserId获得对象 /// </summary> /// <param name="userId"></param> /// <returns></returns> public DataOfFriends GetByUserId(string userId) { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from friend in Applicate.AccountDbContext.Friends where friend.toUserId == userId select friend).FirstOrDefault(); return(result); } }
public List <MessageListItem> GetAllList() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from msg in Applicate.AccountDbContext.MessageList orderby msg.TimeSend descending select msg ).ToList(); return(result); } }
/// <summary> /// 根据RoomId查询 /// </summary> /// <param name="id">对应的Id</param> /// <returns></returns> public Room GetByRoomId(string id) { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from room in Applicate.AccountDbContext.Rooms where room.id == id select room ).FirstOrDefault(); return(result); } }
/// <summary> /// 根据Jid获取RoomId /// </summary> /// <param name="jid">查询的Jid</param> /// <returns></returns> public string GetRoomIdByJid(string jid) { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var resultId = ( from room in Applicate.AccountDbContext.Rooms where room.jid == jid select room.id ).FirstOrDefault(); return(resultId); } }
/// <summary> /// 获取已加入群组 /// </summary> /// <returns>已加入群组列表</returns> public List <Room> GetJoinedList() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from room in Applicate.AccountDbContext.Rooms //where room.IsJoined == true select room ).ToList(); return(result); } }
/// <summary> /// 根据toUserId获得对象 /// </summary> /// <param name="userId"></param> /// <returns></returns> public VerifingFriend GetByUserId() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from friend in Applicate.AccountDbContext.VerifingFriends where friend.toUserId == this.toUserId select friend ).FirstOrDefault(); return(result); } }
public Room GetObjectByRoomJid() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from room in Applicate.AccountDbContext.Rooms where room.jid == this.jid select room ).FirstOrDefault(); return(result); } }
/// <summary> /// 根据群聊ID查询 /// <paramref name="roomid">对应的群组ID</paramref> /// </summary> public List <DataofMember> GetListByRoomId(string roomid) { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from RoomMember in Applicate.AccountDbContext.RoomMembers where RoomMember.groupid == roomid select RoomMember ).ToList(); return(result); } }
/// <summary> /// 根据Jid获取 /// </summary> /// <param name="jid">需要查询的Jid</param> /// <returns></returns> internal string GetRoomNameByJid(string jid) { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from room in Applicate.AccountDbContext.Rooms where room.jid == jid select room.name ).FirstOrDefault(); return(result); } }
/// <summary> /// 删除 /// </summary> public void Delete(string userId) { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var item = Applicate.AccountDbContext.RoomMembers.FirstOrDefault(m => m.userId == userId);//获取群聊 if (item != null) { Applicate.AccountDbContext.RoomMembers.Remove(item); } Applicate.AccountDbContext.SaveChanges(); } }
/// <summary> /// 获取黑名单列表 /// </summary> /// <returns></returns> public DataOfFriends GetBlackUser(string userid) { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from fri in Applicate.AccountDbContext.Friends where fri.status == -1 && fri.toUserId == userid select fri ).FirstOrDefault(); return(result); } }
/// <summary> /// 更新群聊成员人数 /// </summary> /// <param name="roomId">RoomId</param> public void UpdateMemberSize(string roomId, int count) { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var tmp = Applicate.AccountDbContext.Rooms.FirstOrDefault(m => m.id == roomId);//获取当前群组 if (tmp != null && tmp.userSize != count) { tmp.userSize = count; Applicate.AccountDbContext.SaveChanges();//保存更改 } } }
/// <summary> /// 获取黑名单列表 /// </summary> /// <returns></returns> public List <DataOfFriends> GetBlacksList() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from friend in Applicate.AccountDbContext.Friends where friend.status == -1 select friend ).ToList(); return(result); } }
/// <summary> /// 移出黑名单 /// </summary> /// <param name="toUserId"></param> /// <returns></returns> public void DelBlack() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from friend in Applicate.AccountDbContext.VerifingFriends where friend.toUserId == this.toUserId select friend ).FirstOrDefault(); result.VerifyStatus = 2; Applicate.AccountDbContext.SaveChanges(); } }
/// <summary> /// 删除 /// </summary> public void DeleteByStatus() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = ( from friend in Applicate.AccountDbContext.VerifingFriends where friend.VerifyStatus == this.VerifyStatus select friend ); Applicate.AccountDbContext.VerifingFriends.RemoveRange(result); Applicate.AccountDbContext.SaveChanges(); } }
/// <summary> /// 更新到数据库 /// </summary> public void UpdateDetial() { lock (Applicate.AccountDbContext) { SQLiteDBContext.DBAutoConnect(); var result = Applicate.AccountDbContext.Friends.FirstOrDefault(f => f.toUserId == this.toUserId); if (result == null) { result = new DataOfFriends(); } result.active = this.active; result.areaCode = this.areaCode; result.areaId = this.areaId; result.attCount = this.attCount; result.balance = this.balance; result.birthday = this.birthday; result.cityId = this.cityId; result.companyId = this.companyId; result.countryId = this.countryId; result.createTime = this.createTime; result.description = this.description; result.fansCount = this.fansCount; result.friendsCount = this.friendsCount; result.idcard = this.idcard; result.idcardUrl = this.idcardUrl; result.isAuth = this.isAuth; result.level = this.level; result.modifyTime = this.modifyTime; result.name = this.name; result.nickname = this.nickname; result.num = this.num; result.offlineNoPushMsg = this.offlineNoPushMsg; result.onlinestate = this.onlinestate; result.password = this.password; result.phone = this.phone; result.provinceId = this.provinceId; result.sex = this.sex; //result.status = this.status; result.telephone = this.telephone; result.totalConsume = this.totalConsume; result.totalRecharge = this.totalRecharge; result.toUserId = this.toUserId; result.toNickname = this.nickname; result.userKey = this.userKey; result.userType = this.userType; result.vip = this.vip; Applicate.AccountDbContext.Entry(result).State = EntityState.Modified; Applicate.AccountDbContext.SaveChanges(); } }