using Jaina;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using HT.Cloud.Code;
using HT.Cloud.DataBase;
using HT.Cloud.Domain.InfoManage;
using HT.Cloud.Domain.SystemOrganize;
using HT.Cloud.Service.Event;
using HT.Cloud.Service.SystemManage;
namespace HT.Cloud.Service.InfoManage
{
///
/// 创 建:超级管理员
/// 日 期:2020-07-29 16:41
/// 描 述:通知管理服务类
///
public class MessageService : BaseService, IDenpendency
{
public ItemsDataService itemsApp { get; set; }
public MessageService(ISqlSugarClient context) : base(context)
{
}
#region 获取数据
public async Task> GetList(string keyword = "")
{
var query = repository.IQueryable();
if (!string.IsNullOrEmpty(keyword))
{
query = query.Where(a => a.F_MessageInfo.Contains(keyword) || a.F_CreatorUserName.Contains(keyword));
}
return await query.Where(a => a.F_EnabledMark == true).OrderBy(a => a.F_CreatorTime, OrderByType.Desc).ToListAsync();
}
public async Task> GetLookList(string keyword = "")
{
var query = repository.IQueryable().Where(a => a.F_EnabledMark == true);
if (!string.IsNullOrEmpty(keyword))
{
query = query.Where(a => a.F_MessageInfo.Contains(keyword) || a.F_CreatorUserName.Contains(keyword));
}
query = GetDataPrivilege("a", "", query);
return await query.OrderBy(a => a.F_CreatorTime, OrderByType.Desc).ToListAsync();
}
public async Task> GetUnReadListJson()
{
var hisquery = repository.Db.Queryable().Where(a => a.F_CreatorUserId == currentuser.UserId).Select(a => a.F_MessageId).ToList();
var tempList = repository.Db.Queryable((a, b) => new JoinQueryInfos(
JoinType.Inner, a.F_Id == b.F_MessageId && a.F_MessageType == 2
)).Select(a => a.F_Id).ToList();
hisquery.AddRange(tempList);
var query = repository.IQueryable(a => (a.F_ToUserId.Contains(currentuser.UserId) || a.F_ToUserId == "") && a.F_EnabledMark == true).Where(a => !hisquery.Contains(a.F_Id));
return await GetFieldsFilterDataNew("a", query.OrderBy(a => a.F_CreatorTime, OrderByType.Desc)).ToListAsync();
}
public async Task> GetLookList(SoulPage pagination, string keyword = "")
{
//反格式化显示只能用"等于",其他不支持
Dictionary> dic = new Dictionary>();
var setList = await itemsApp.GetItemList("MessageType");
Dictionary messageTypeTemp = new Dictionary();
foreach (var item in setList)
{
messageTypeTemp.Add(item.F_ItemCode, item.F_ItemName);
}
dic.Add("F_MessageType", messageTypeTemp);
pagination = ChangeSoulData(dic, pagination);
//获取数据权限
var query = repository.IQueryable().Where(a => a.F_EnabledMark == true);
if (!string.IsNullOrEmpty(keyword))
{
//此处需修改
query = query.Where(a => a.F_MessageInfo.Contains(keyword) || a.F_CreatorUserName.Contains(keyword));
}
query = GetDataPrivilege("a", "", query);
return await query.ToPageListAsync(pagination);
}
public async Task GetForm(string keyValue)
{
var data = await repository.FindEntity(keyValue);
return data;
}
#endregion 获取数据
public async Task GetLookForm(string keyValue)
{
var data = await repository.FindEntity(keyValue);
return GetFieldsFilterData(data);
}
#region 提交数据
public async Task SubmitForm(MessageEntity entity)
{
entity.Create();
entity.F_EnabledMark = true;
entity.F_CreatorUserName = currentuser.UserName;
MessageEntity messageEntity = new MessageEntity();
if (string.IsNullOrEmpty(entity.F_ToUserId))
{
string msg = entity.ToJson();
entity.F_ToUserName = "所有人";
entity.F_ToUserId = "";
messageEntity = await repository.Insert(entity);
}
else
{
var users = entity.F_ToUserId.Split(",");
entity.F_ToUserName = string.Join(",", repository.Db.Queryable().Where(a => users.Contains(a.F_Id)).Select(a => a.F_RealName).ToList());
messageEntity = await repository.Insert(entity);
}
//通过http发送消息
messageEntity.companyId = currentuser.CompanyId;
await GlobalContext.GetService().PublishAsync(new BaseEventSource("Message:send", messageEntity,currentuser));
}
public async Task ReadAllMsgForm(int type)
{
var unList = await GetUnReadListJson();
var strList = unList.Where(a => a.F_MessageType == type && a.F_ClickRead == true).Select(a => a.F_Id).ToList();
repository.Db.Ado.BeginTran();
foreach (var item in strList)
{
await ReadMsgForm(item);
}
repository.Db.Ado.CommitTran();
}
public async Task ReadMsgForm(string keyValue)
{
MessageHistoryEntity msghis = new MessageHistoryEntity();
msghis.Create();
msghis.F_CreatorUserName = currentuser.UserName;
msghis.F_MessageId = keyValue;
await repository.Db.Insertable(msghis).ExecuteCommandAsync();
}
public async Task CheckMsg(string keyValue)
{
var msg = await repository.FindEntity(keyValue);
if (msg == null)
{
return true;
}
if (msg.F_ClickRead == false)
{
return true;
}
if (await repository.Db.Queryable().Where(a => a.F_MessageId == keyValue && a.F_CreatorUserId == currentuser.UserId).AnyAsync())
{
return true;
}
else
{
return false;
}
}
public async Task DeleteForm(string keyValue)
{
var ids = keyValue.Split(',');
await repository.Update(a => ids.Contains(a.F_Id), a => new MessageEntity
{
F_EnabledMark = false
});
}
#endregion 提交数据
}
}