private void button1_Click(object sender, EventArgs e)
{
if (textBox2.Text == "")
{
MessageBox.Show("제목을 입력하셔야합니다.");
textBox2.Focus();
return;
}
if (textBox1.Text == "")
{
MessageBox.Show("내용을 입력하셔야합니다.");
textBox1.Focus();
return;
}
NoticeVo vo = new NoticeVo
{
Title = textBox2.Text,
Description = textBox1.Text,
Notice_Date = dateTimePicker1.Value.ToString("yyyy-MM-dd")
};
NoticeService service = new NoticeService();
service.InsertNotice(vo);
this.Close();
}
/// <summary>
/// 将entity转换为vo。不包括来自元数据的属性
/// </summary>
private void CopyToVo(NoticeVo vo, NoticeEntity entity)
{
vo.Id = entity.Id;
vo.Title = entity.Title;
vo.Body = entity.Body;
vo.DataStatus = entity.DataStatus;
vo.CreateTime = entity.CreateTime;
vo.LastUpdateTime = entity.LastUpdateTime;
}
/// <summary>
/// 查询公告信息ById
/// </summary>
/// <param name="noticeId"></param>
/// <returns></returns>
public ActionResult SelectNoticeById(int noticeId)
{
try
{
NoticeVo notice = (from tbNoticeTable in myDYXTEntities.B_NoticeTable
join tbNoticeTypeTable in myDYXTEntities.B_NoticeTypeTable on tbNoticeTable.NoticeTypeID equals tbNoticeTypeTable.NoticeTypeID
join tbNoticeStatus in myDYXTEntities.S_NoticeStatusTable on tbNoticeTable.NoticeStatusID equals tbNoticeStatus.NoticeStatusID
join tbAccount in myDYXTEntities.B_AccountTable on tbNoticeTable.AccountID equals tbAccount.AccountID
where tbNoticeTable.NoticeID == noticeId
select new NoticeVo
{
NoticeID = tbNoticeTable.NoticeID,
Title = tbNoticeTable.Title.Trim(),
ArticleLabel = tbNoticeTable.ArticleLabel.Trim(),
AccountID = tbNoticeTable.AccountID,
User = tbAccount.User.Trim(),
NoticeContent = tbNoticeTable.NoticeContent.Trim(),
NoticeStatusID = tbNoticeStatus.NoticeStatusID,
NoticeTypeID = tbNoticeTable.NoticeTypeID,
IssueTime = tbNoticeTable.IssueTime,
NoticeTypeName = tbNoticeTypeTable.NoticeTypeName.Trim(),
NoticeStatusName = tbNoticeStatus.NoticeStatusName.Trim(),
ReleaseTimeStr = tbNoticeTable.IssueTime.ToString()
}).Single();
//加载公告内容
string textFileName = Server.MapPath("~/Document/Notice/Text/") + notice.NoticeContent;
if (System.IO.File.Exists(textFileName))
{
//文件存在
notice.NoticeContent = System.IO.File.ReadAllText(textFileName);
}
else
{
//文件不存在
notice.NoticeContent = "<p>没有找到公告内容,可能文件已经丢失;请重新编辑发布</p>";
}
//返回公告信息的内容
return(Json(notice, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
Console.WriteLine(e);
return(Json(null, JsonRequestBehavior.AllowGet));
}
}
//根据公告ID查询详细
public ActionResult NoticeDetailed(int NoticeID)
{
try
{
NoticeVo notice = (from tbNoticeTable in myDYXTEntities.B_NoticeTable
join tbNoticeTypeTable in myDYXTEntities.B_NoticeTypeTable on tbNoticeTable.NoticeTypeID equals tbNoticeTypeTable.NoticeTypeID
join tbNoticeStatus in myDYXTEntities.S_NoticeStatusTable on tbNoticeTable.NoticeStatusID equals tbNoticeStatus.NoticeStatusID
join tbAccount in myDYXTEntities.B_AccountTable on tbNoticeTable.AccountID equals tbAccount.AccountID
where tbNoticeTable.NoticeID == NoticeID
select new NoticeVo
{
NoticeID = tbNoticeTable.NoticeID,
Title = tbNoticeTable.Title,
ArticleLabel = tbNoticeTable.ArticleLabel,
AccountID = tbNoticeTable.AccountID,
User = tbAccount.User,
NoticeContent = tbNoticeTable.NoticeContent,
NoticeStatusID = tbNoticeStatus.NoticeStatusID,
NoticeTypeID = tbNoticeTable.NoticeTypeID,
IssueTime = tbNoticeTable.IssueTime,
NoticeTypeName = tbNoticeTypeTable.NoticeTypeName,
NoticeStatusName = tbNoticeStatus.NoticeStatusName,
ReleaseTimeStr = tbNoticeTable.IssueTime.ToString()
}).Single();
//加载公告内容
string textFileName = Server.MapPath("~/Document/Notice/Text/") + notice.NoticeContent;
if (System.IO.File.Exists(textFileName))
{
//文件存在
notice.NoticeContent = System.IO.File.ReadAllText(textFileName);
}
else
{
//文件不存在
notice.NoticeContent = "<p>没有找到公告内容,可能文件已经丢失;请重新编辑发布</p>";
}
ViewBag.notice = notice;
}
catch (Exception e)
{
}
return(View());
}
