public static NoticeModel GetNoticeModel(long noticeID) { var model = new NoticeModel(); using (var utility = DbUtility.GetInstance()) { var sql = new StringBuilder(); sql.Append(@" SELECT `t_notice`.`NoticeID`, `t_notice`.`OrganizationID`, `t_notice`.`Title`, `t_notice`.`NoticeDateTime`, `t_notice`.`AttachmentFile1` as AttachmentFileID1, `t_notice`.`ContentType`, `t_notice`.`ContentDesc`, `t_notice`.`ContentTxt`, `t_notice`.`StartDate`, `t_notice`.`EndDate`, `t_notice`.`CreateUserID`, `t_notice`.`CreateDateTime`, `t_notice`.`LastUserID`, `t_notice`.`LastUpdatetime`, `t_notice`.`Sticky`, createUser.UserName as CreateUserName, updateUser.UserName as UpdateUserName, files.FileName as AttachmentFileFileName1 FROM `t_notice` left join m_user createUser on createUser.Guid=`t_notice`.`CreateUserID` left join m_user updateUser on updateUser.Guid=`t_notice`.`LastUserID` left join t_files files on files.FilesID=`t_notice`.`AttachmentFile1` where `t_notice`.`NoticeID`=@NoticeID; "); utility.AddParameter("NoticeID", noticeID); utility.ExecuteReaderModel(sql.ToString(), model); return(model); } }
public static bool Save(NoticeModel model, SystemRollEnum roll) { var noticeID = model.NoticeID; var displayNo = 0; using (var utility = DbUtility.GetInstance()) { var sql = new StringBuilder(); if (model.NoticeID == 0) { sql.Append(@" INSERT INTO `t_notice` (`NoticeID`, "); if (roll != SystemRollEnum.SysAdmin) { sql.Append(@" `OrganizationID`,"); } sql.Append(@" `Sticky`, `DisplayNo`, `Title`, `NoticeDateTime`, `AttachmentFile1`, `ContentType`, `ContentDesc`, `ContentTxt`, `StartDate`, `EndDate`, `CreateUserID`, `CreateDateTime`, `LastUserID`, `LastUpdatetime`) VALUES (@NoticeID,"); if (roll != SystemRollEnum.SysAdmin) { sql.Append(@" @OrganizationID,"); } sql.Append(@" @Sticky, @DisplayNo, @Title, @NoticeDateTime, @AttachmentFile1, @ContentType, @ContentDesc, @ContentTxt, @StartDate, @EndDate, @CreateUserID, @CreateDateTime, @LastUserID, @LastUpdatetime);"); noticeID = GetUUID(); } else { sql.Append(@" UPDATE `t_notice` SET `Sticky` = @Sticky, `DisplayNo` = @DisplayNo, `Title` = @Title, `NoticeDateTime` = @NoticeDateTime,"); if (model.AttachmentFileID1 > 0) { sql.Append(@" `AttachmentFile1` = @AttachmentFile1,"); } else if (model.AttachmentFileID1 == -1) { sql.Append(@" `AttachmentFile1` = 0,"); } if (roll == SystemRollEnum.SysAdmin) { sql.Append(@" OrganizationID=null,"); } sql.Append(@" `ContentType` = @ContentType, `ContentDesc` = @ContentDesc, `ContentTxt` = @ContentTxt, `LastUserID` = @LastUserID, `LastUpdatetime` = @LastUpdatetime WHERE `NoticeID` = @NoticeID and CreateUserID=@CreateUserID;"); if (model.Sticky) { displayNo = model.DisplayNo; } } utility.AddParameter("NoticeID", noticeID); utility.AddParameter("OrganizationID", model.OrganizationID); utility.AddParameter("Sticky", model.Sticky); utility.AddParameter("DisplayNo", displayNo); utility.AddParameter("Title", model.Title); utility.AddParameter("NoticeDateTime", model.NoticeDateTime); utility.AddParameter("AttachmentFile1", model.AttachmentFileID1); utility.AddParameter("ContentType", model.ContentType); utility.AddParameter("ContentDesc", model.ContentDesc); utility.AddParameter("ContentTxt", model.ContentTxt); utility.AddParameter("StartDate", model.StartDate); utility.AddParameter("EndDate", model.EndDate); utility.AddParameter("CreateUserID", model.CreateUserID); utility.AddParameter("CreateDateTime", model.CreateDateTime); utility.AddParameter("LastUserID", model.LastUserID); utility.AddParameter("LastUpdatetime", model.LastUpdatetime); var effRow = utility.ExecuteNonQuery(sql.ToString()); if (effRow == 1 && model.NoticeID == 0) { model.NoticeID = noticeID; } return(effRow == 1); } }