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