public List<LabMS.Model.Announcement> GetLatest(int counts)
{
StringBuilder sb = new StringBuilder();
sb.Append("select top ");
sb.Append(counts);
sb.Append(" [key],AnnouncementTitle,AnnouncementContent,PublishTime,ExpireTime,Importance,AttachmentPath,LabID,PublisherID from Announcement ");
sb.Append(" where ExpireTime > getdate() ");
sb.Append(" order by [key] desc");
LabMS.Model.Announcement model;
List<LabMS.Model.Announcement> notices = new List<LabMS.Model.Announcement>();
System.Data.DataSet ds = Maticsoft.DBUtility.DbHelperSQL.Query(sb.ToString());
foreach (System.Data.DataRow row in ds.Tables[0].Rows)
{
model = new LabMS.Model.Announcement();
if (row["key"].ToString() != "")
{
model.key = int.Parse(row["key"].ToString());
}
model.AnnouncementTitle = row["AnnouncementTitle"].ToString();
model.AnnouncementContent = row["AnnouncementContent"].ToString();
if (row["PublishTime"].ToString() != "")
{
model.PublishTime = DateTime.Parse(row["PublishTime"].ToString());
}
if (row["ExpireTime"].ToString() != "")
{
model.ExpireTime = DateTime.Parse(row["ExpireTime"].ToString());
}
if (row["Importance"].ToString() != "")
{
model.Importance = int.Parse(row["Importance"].ToString());
}
model.AttachmentPath = row["AttachmentPath"].ToString();
if (row["LabID"].ToString() != "")
{
model.LabID = int.Parse(row["LabID"].ToString());
}
if (row["PublisherID"].ToString() != "")
{
model.PublisherID = int.Parse(row["PublisherID"].ToString());
}
notices.Add(model);
}
return notices;
}
protected void BtnSubmn_Click(object sender, EventArgs e)
{
DateTime dateExpire = DateTime.Now;
#region validation
if (string.IsNullOrEmpty(NoticeTitle.Text.Trim())) { WriteBackScript("alert('֪ͨ���ⲻ��Ϊ��!')"); return; }
else if (NoticeTitle.Text.Length > 200) { WriteBackScript("alert('֪ͨ�������!')"); return; }
if (string.IsNullOrEmpty(NoticeExpireTime.Text.Trim())) { WriteBackScript("alert('֪ͨʧЧʱ�䲻��Ϊ��!')"); return; }
try
{
dateExpire = DateTime.Parse(NoticeExpireTime.Text);
if (dateExpire <= DateTime.Now) { WriteBackScript("alert('֪ͨʧЧʱ������ڵ�ǰʱ��֮��!')"); return; }
}
catch { WriteBackScript("'֪ͨʧЧʱ��Ϊ�Ƿ���ʱ���ʽ!'"); return; }
#endregion
LabMS.BLL.Announcement notice = new LabMS.BLL.Announcement();
LabMS.Model.Announcement noticeInfo = new LabMS.Model.Announcement();
noticeInfo.AnnouncementTitle = NoticeTitle.Text;
noticeInfo.ExpireTime = dateExpire;
noticeInfo.Importance = (ImportanceValue.Value == "0") ? 0 : 1;
noticeInfo.PublishTime = DateTime.Now;
noticeInfo.AnnouncementContent = Server.HtmlEncode(NoticeContent.Text);
noticeInfo.LabID = int.Parse(LabList.SelectedValue);
noticeInfo.PublisherID = int.Parse(UserID);
// TBD ����Ķ�֪ͨ�Ľ�ɫ��Ӧ
#region Upload file
if (NoticeAttachment.HasFile)
{
noticeInfo.AttachmentPath = "Attachment/" + Guid.NewGuid().ToString() + "." + ExtendBLL.FileUtility.GetFileExtension(NoticeAttachment.FileName);
NoticeAttachment.SaveAs(Server.MapPath(noticeInfo.AttachmentPath));
}
#endregion
noticeInfo.key = notice.Add(noticeInfo);
WriteBackScript("alert('���֪ͨ�ɹ�!');window.location.href='list.aspx';");
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.Announcement GetModel(int key)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 [key],AnnouncementTitle,AnnouncementContent,PublishTime,ExpireTime,Importance,AttachmentPath,LabID,PublisherID from Announcement ");
strSql.Append(" where [key]=@key ");
SqlParameter[] parameters = {
new SqlParameter("@key", SqlDbType.Int,4)};
parameters[0].Value = key;
LabMS.Model.Announcement model = new LabMS.Model.Announcement();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["key"].ToString() != "")
{
model.key = int.Parse(ds.Tables[0].Rows[0]["key"].ToString());
}
model.AnnouncementTitle = ds.Tables[0].Rows[0]["AnnouncementTitle"].ToString();
model.AnnouncementContent = ds.Tables[0].Rows[0]["AnnouncementContent"].ToString();
if (ds.Tables[0].Rows[0]["PublishTime"].ToString() != "")
{
model.PublishTime = DateTime.Parse(ds.Tables[0].Rows[0]["PublishTime"].ToString());
}
if (ds.Tables[0].Rows[0]["ExpireTime"].ToString() != "")
{
model.ExpireTime = DateTime.Parse(ds.Tables[0].Rows[0]["ExpireTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Importance"].ToString() != "")
{
model.Importance = int.Parse(ds.Tables[0].Rows[0]["Importance"].ToString());
}
model.AttachmentPath = ds.Tables[0].Rows[0]["AttachmentPath"].ToString();
if (ds.Tables[0].Rows[0]["LabID"].ToString() != "")
{
model.LabID = int.Parse(ds.Tables[0].Rows[0]["LabID"].ToString());
}
if (ds.Tables[0].Rows[0]["PublisherID"].ToString() != "")
{
model.PublisherID = int.Parse(ds.Tables[0].Rows[0]["PublisherID"].ToString());
}
return model;
}
else
{
return null;
}
}
