Files

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