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); }
public ResNoticeBase AddNotice([FromBody] NOTICEBOARDBASE notice) { ResNoticeBase retValue = new ResNoticeBase(); using (var db = DbContext.GetInstance("T_NOTICE_BOARD")) { try { //设置时间 notice.createTime = DateTime.Now; notice.lastEditTime = DateTime.Now; //设置最近编辑人信息 notice.lastEditUserCode = notice.createUserCode; notice.lastEditUserName = notice.createUserName; var res = db.Insert(notice); retValue.SuccessDefalut("发布成功", 1); LogWirter.Record(LogType.Admin, OpType.Add, notice.mainTitle + "]", "添加公告 [", Convert.ToInt32(res), notice.createUserCode, notice.createUserName); } catch (Exception ex) { retValue.FailDefalut(ex); } } return(retValue); }