public static async Task <DB.messageDB> SendMsgtoDB(Model.JoinGroupAcceptedPackage package) { DB.messageDB msg = new DB.messageDB() { from = package.from, to = package.to, msgTime = package.time.Value, msgId = package.id, body = Util.Helpers.Json.ToJson(package.data), optionRecord = 1, roomId = package.data.groupId, Source = Util.Helpers.Json.ToJson(package), roomType = 1//群聊窗体显示 }; // msg.content = $"{package.data.inviteUserName}\t邀请:{string.Join<int>(",",package.data.userIds)}\t入群:{package.data.groupName}"; if (package.data.userName == SDKClient.Instance.property.CurrentAccount.userName) { msg.content = $"你进入群聊"; } else { msg.content = $"[{package.data.userName}] 进入群聊"; } msg.msgType = nameof(SDKProperty.MessageType.notification); try { await SDKProperty.SQLiteConn.InsertAsync(msg); return(msg); } catch (Exception) { return(null); } }
public static async Task <bool> DeleteJoinGroupItem(Model.JoinGroupAcceptedPackage acceptedPackage) { int i = await SDKProperty.SQLiteConn.ExecuteAsync($"delete from JoinGroupDB where groupId={acceptedPackage.data.groupId} and userId={acceptedPackage.data.memberId} "); return(i > 0 ? true : false); //var lst = await SDKProperty.SQLiteConn.Table<DB.JoinGroupDB>().Where(j => j.groupId == acceptedPackage.data.groupId && j.userId == acceptedPackage.data.memberId).ToListAsync(); //foreach (var item in lst) //{ // await SDKProperty.SQLiteConn.DeleteAsync(item); //} }