public ResGetNoticese GetNotices([FromHeader] ReqNoticeBase notice)
{
ResGetNoticese retValue = new ResGetNoticese();
using (var db = DbContext.GetInstance("T_NOTICE_BOARD"))
{
try
{
//如果有信息被设置为置顶并且根据创建时间降序
var topNoticeList = db.Queryable <NOTICEBOARDBASE>()
.Where(s => s.isTop == (int)isTop.Yes)
.OrderBy(s => s.lastEditTime, OrderByType.desc)
.ToList();
var noticeList = db.Queryable <NOTICEBOARDBASE>()
.Where(s => s.isTop == (int)isTop.No)
.OrderBy(s => s.createTime, OrderByType.desc)
.ToList();
//合并
var reList = topNoticeList.Union(noticeList)
.ToList();
//0是第一页
var resultList = reList.Skip((notice.currentPage - 1) * notice.pageSize).Take(notice.pageSize).ToList();
retValue.SuccessDefalut(resultList, reList.Count);
}
catch (Exception ex)
{
retValue.FailDefalut(ex);
}
}
return(retValue);
}
public ResNoticeBase UpdateNotice([FromBody] ReqNoticeBase notice)
{
ResNoticeBase retValue = new ResNoticeBase();
using (var db = DbContext.GetInstance("T_NOTICE_BOARD"))
{
try
{
bool isIDExist = db.Queryable <NOTICEBOARDBASE>()
.Any(s => s.ID == notice.ID);
if (isIDExist)
{
//设置禁止更新列
db.AddDisableUpdateColumns("create_time", "create_user_name", "create_user_name");
//设置时间
notice.lastEditTime = DateTime.Now;
//设置最近编辑人信息
notice.lastEditUserCode = notice.createUserCode;
notice.lastEditUserName = notice.createUserName;
var noticeModel = new NOTICEBOARDBASE();
db.Update <NOTICEBOARDBASE>(
new
{
mainTitle = notice.mainTitle,
subHead = notice.subHead,
content = notice.content,
formatType = notice.formatType,
contentType = notice.contentType,
isTop = notice.isTop,
lastEditUserName = notice.lastEditUserName,
lastEditUserCode = notice.lastEditUserCode
},
it => it.ID == notice.ID
);
retValue.SuccessDefalut("修改公告成功！", 1);
LogWirter.Record(LogType.Admin, OpType.Update, notice.mainTitle + "]", "修改公告 [", notice.ID, notice.createUserCode, notice.createUserName);
}
else
{
retValue.FailDefalut("不存在该公告ID");
}
}
catch (Exception ex)
{
retValue.FailDefalut(ex);
}
}
return(retValue);
}
