101 lines
5.1 KiB
C#
Executable File
101 lines
5.1 KiB
C#
Executable File
using Microsoft.Extensions.DependencyInjection;
|
|
using Newtonsoft.Json.Linq;
|
|
using Opsoft.Data;
|
|
using Opsoft.NetCore.O3App.Domain.UnitOfWork.BaseData.IRepositories;
|
|
using Opsoft.NetCore.O3App.Domain.UnitOfWork.BaseData.Model;
|
|
using Opsoft.NetCore.O3App.Shared;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace Opsoft.NetCore.O3App.Repositories.BaseData
|
|
{
|
|
[MapTo(typeof(IPersonalMessageRepository), ServiceLifetime.Transient)]
|
|
public class PersonalMessageRepository : RepositoryBase<SYS_PRESONINFO>, IPersonalMessageRepository
|
|
{
|
|
/// <summary>
|
|
/// 获取当前登录用户的所有消息
|
|
/// </summary>
|
|
/// <param name="data"></param>
|
|
/// <returns></returns>
|
|
public async Task<GetPersonalMessage> GetAllPersonalMessage(object data)
|
|
{
|
|
dynamic getData = JsonOperator.JsonDeserialize<dynamic>(data.ToString());
|
|
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
|
DataTable dtUser = context.Database.SqlQuery($@"SELECT PA_ID,USER_ID FROM SYS_LOGINUSER WHERE USER_ID='{getData.userId}'");
|
|
|
|
if (dtUser == null || dtUser.Rows.Count == 0)
|
|
throw new Exception("该用户不存在");
|
|
string sqlAll = $@" SELECT
|
|
ROW_NUMBER() OVER(ORDER BY T01.C_YMD desc) AS RowNumber,
|
|
T01.FNUMBER,T01.FNAME,T01.C_YMD,T01.FINFOSTATUS,T01.FCONTENT,T01.FMESSAGETYPE,
|
|
T03.FNAME AS FRECEIVERNAME
|
|
FROM SYS_PRESONINFO T01
|
|
LEFT JOIN T_HR_EMPINFO T03 ON T01.FRECEIVER = T03.FINTERID
|
|
WHERE DATEDIFF(DD,T01.C_YMD,GETDATE())<=30
|
|
AND FINFOSTATUS IN ('1','2','3')
|
|
AND T03.FNUMBER='{dtUser.Rows[0]["PA_ID"].ToStringEx()}'";
|
|
GetPersonalMessage retData = new GetPersonalMessage();
|
|
retData.Data = await context.Database.SqlQueryAsync<PersonalMessage>(sqlAll);
|
|
retData.SumCount = retData.Data.Count;
|
|
string sql = $@"SELECT S.*
|
|
FROM
|
|
(
|
|
{sqlAll}
|
|
) AS S
|
|
WHERE S.RowNumber BETWEEN ({getData.pageNum}-1)*({getData.pageCount}+1) AND ({getData.pageNum}*{getData.pageCount})
|
|
ORDER BY RowNumber";
|
|
retData.Data = await context.Database.SqlQueryAsync<PersonalMessage>(sql);
|
|
return retData;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 更新个人消息
|
|
/// </summary>
|
|
/// <param name="data"></param>
|
|
/// <returns></returns>
|
|
public async Task<GetPersonalMessage> UpdatePersonalMessage(UpdatePersonalMeaasge data)
|
|
{
|
|
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
|
GetPersonalMessage retData = new GetPersonalMessage();
|
|
string sql = $@"update SYS_PRESONINFO set FINFOSTATUS={data.Type} where FNUMBER IN ('{string.Join("','", data.MeaasgeNoList)}')";
|
|
await context.Database.SqlQueryAsync<PersonalMessage>(sql);
|
|
sql = $@"SELECT
|
|
T01.FNUMBER,T01.FNAME,T01.C_YMD,T01.FINFOSTATUS,T01.FCONTENT,T01.FMESSAGETYPE,
|
|
T03.FNAME AS FRECEIVERNAME
|
|
FROM SYS_PRESONINFO T01
|
|
LEFT JOIN T_HR_EMPINFO T03 ON T01.FRECEIVER = T03.FINTERID
|
|
WHERE T01.FNUMBER IN('{string.Join("','", data.MeaasgeNoList)}')";
|
|
retData.Data = await context.Database.SqlQueryAsync<PersonalMessage>(sql);
|
|
retData.SumCount = retData.Data.Count;
|
|
return retData;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取个人未读的消息数量
|
|
/// </summary>
|
|
/// <param name="data"></param>
|
|
/// <returns></returns>
|
|
public async Task<object> GetCountUnReadPersonalMessage(object data)
|
|
{
|
|
dynamic getData = JsonOperator.JsonDeserialize<dynamic>(data.ToString());
|
|
using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID);
|
|
JObject jo = new JObject();
|
|
DataTable dtUser = context.Database.SqlQuery($@"SELECT PA_ID,USER_ID FROM SYS_LOGINUSER WHERE USER_ID='{getData.userId}'");
|
|
|
|
if (dtUser == null || dtUser.Rows.Count == 0)
|
|
throw new Exception("该用户不存在");
|
|
DataTable dt = context.Database.SqlQuery($@" SELECT count(1) SumCount
|
|
FROM SYS_PRESONINFO T01
|
|
LEFT JOIN T_HR_EMPINFO T03 ON T01.FRECEIVER = T03.FINTERID
|
|
WHERE DATEDIFF(DD,T01.C_YMD,GETDATE())<=30
|
|
AND FINFOSTATUS='2' AND T03.FNUMBER='{dtUser.Rows[0]["PA_ID"].ToStringEx()}'");
|
|
jo.Add("SumCount", dt.Rows[0]["SumCount"].ToInt());
|
|
return await Task.Run(() => { return jo; });
|
|
}
|
|
|
|
}
|
|
}
|