/// <summary>
/// 保存通知信息
/// </summary>
/// <param name="db"></param>
/// <param name="fromUid">发起通知的人</param>
/// <param name="busId">内容ID</param>
/// <param name="msgType">通知类型</param>
/// <param name="contentType">内容类型(1:一级规划;2:二级规划;3:三级规划;4:一级评论;5:二级评论;6:修改的职业规划;7:计划)</param>
/// <param name="content2">通知内容</param>
public void SaveMsg(SqlSugarClient db, string fromUid, string busId, int msgType, int busType, string content2 = "")
{
try
{
DateTime now = db.GetDate();
int timestamp = FunctionHelper.GetTimestamp();
string fromUser = db.Queryable <SYS_USER_INFO>()
.Where(x => x.USER_ID == fromUid && x.STATE == "A")
.Select(x => x.NICK_NAME)
.First();
string msgInfo = "";
ISingleBus sb = InterfaceArray.DicVD[busType];
BusinessModel toInfo = this.GetBusData(db, busId, sb);
string toUid = toInfo.USER_ID;
string oldContent = toInfo.CONTENT;
if (msgType == 1)
{
msgInfo = fromUser + "对你的文章" + oldContent + "进行评论：" + content2;
}
if (msgType == 2)
{
msgInfo = fromUser + "对你的评论" + oldContent + "进行回复：" + content2;
}
if (msgType == 3)
{
msgInfo = fromUser + "赞了你的文章" + oldContent;
}
if (msgType == 4)
{
msgInfo = fromUser + "赞了你的评论" + oldContent;
}
SYS_MESSAGE_INFO smi = new SYS_MESSAGE_INFO();
smi.ID = Guid.NewGuid().ToString();
smi.DATETIME_CREATED = now;
smi.STATE = "A";
smi.TIMESTAMP_INT = timestamp;
smi.FROM_UID = fromUid;
smi.TO_UID = toUid;
smi.STATUS = 0;
smi.TYPE = msgType;
smi.CONTENT = msgInfo;
db.Insertable(smi).ExecuteCommand();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 功能描述:获取数据库时间
/// </summary>
/// <returns>返回值</returns>
public DateTime GetDBTime()
{
return(_db.GetDate());
}
