protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { NoticeBll bll = new NoticeBll(); title = Request["navname"]; news = Request["navnews"]; if (title != "" && news != "") { DataTable dt = bll.showNotice(); foreach (DataRow item in dt.Rows) { if (item["title"].ToString() == title) { Response.Write("<script>alert('通知标题不能重复!!!');</script>"); title = ""; return; } } Notice model = new Notice(); model.Title = title; model.News = news; model.Time = Convert.ToString(DateTime.Now); int result = bll.AddNotice(model); if (result > 0) { Response.Write("<script>alert('添加成功!')window.location.href='InformList.aspx'</script>"); } } else { Response.Write("<script>alert('通知标题不能为空!!!');</script>"); } } }
/// <summary> /// 数据绑定 /// </summary> public void Bind() { DataTable dt = bll.showNotice(); repList.DataSource = dt; repList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //加载导航信息 DataTable dt2 = bll2.NavQuery(); StringBuilder str3 = new StringBuilder(); StringBuilder str4 = new StringBuilder(); if (dt2.Rows.Count > 0) { str3.Append("<li class='active'><a href='" + dt2.Rows[0]["url"].ToString() + "'>" + dt2.Rows[0]["name"] + "</a></li>"); str4.Append("<li><a href='" + dt2.Rows[0]["url"].ToString() + "'>" + dt2.Rows[0]["name"] + "</a>|</li>"); for (int i = 1; i < dt2.Rows.Count; i++) { str3.Append("<li><a href='" + dt2.Rows[i]["url"].ToString() + "'>" + dt2.Rows[i]["name"] + "</a></li>"); str4.Append("<li><a href='" + dt2.Rows[i]["url"].ToString() + "'>" + dt2.Rows[i]["name"] + "</a>|</li>"); } nav1.InnerHtml = str3.ToString(); nav2.InnerHtml = str4.ToString(); } //加载通知信息 DataTable dt = bll.showNotice(); StringBuilder str = new StringBuilder(); if (dt.Rows.Count > 0) { for (int i = dt.Rows.Count - 1; i > 0; i--) { str.Append("<li><span class='time'>" + dt.Rows[i]["Time"].ToString() + "</span><a href='Infrom_introduce.aspx?Id=" + Convert.ToInt32(dt.Rows[i]["Id"]) + "'>" + dt.Rows[i]["Title"].ToString() + "</a></li>"); } inform.InnerHtml = str.ToString(); } else { inform.InnerHtml = "暂无通知数据!"; } } else { string content = Request["tt"].ToString(); DataTable dt = bll.seekNotice(content); StringBuilder str = new StringBuilder(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { str.Append("<li><span class='time'>" + dt.Rows[i]["Time"].ToString() + "</span><a href='Infrom_introduce.aspx?Id=" + Convert.ToInt32(dt.Rows[i]["Id"]) + "'>" + dt.Rows[i]["Title"].ToString() + "</a></li>"); } inform.InnerHtml = str.ToString(); } else { inform.InnerHtml = "暂无该内容通知数据!"; } } }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(Request["Id"]); if (!IsPostBack) { Notice model = new Notice(); DataTable dt = bll.QueryNotice(id); DataRow dr = dt.Rows[0]; if (dt.Rows.Count > 0) { title = dr["title"].ToString(); news = dr["news"].ToString(); time = Convert.ToDateTime(dr["time"]); } } else { title = Request["navtitle"]; news = Request["navnews"]; time = Convert.ToDateTime(Request["navtime"]); if (title != "" && news != "") { DataTable dt = bll.showNotice(); foreach (DataRow item in dt.Rows) { if (item["title"].ToString() == title) { Response.Write("<script>alert('通知标题不能重复!!!');</script>"); return; } if (item["news"].ToString() == news) { Response.Write("<script>alert('通知内容不能重复!!!');</script>"); return; } } int result = bll.EditNotice(id, title, news, time); if (result > 0) { Response.Write("<script>alert('修改成功!');window.location.href='InformList.aspx'</script>"); } } else { Response.Write("<script>alert('通知标题或内容不能为空!!!');</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { EntranceBll bll1 = new EntranceBll(); NavBLL bll2 = new NavBLL(); NoticeBll bll3 = new NoticeBll(); if (!IsPostBack) { //加载导航信息 DataTable dt2 = bll2.NavQuery(); StringBuilder str3 = new StringBuilder(); StringBuilder str4 = new StringBuilder(); if (dt2.Rows.Count > 0) { str3.Append("<li class='active'><a href='" + dt2.Rows[0]["url"].ToString() + "'>" + dt2.Rows[0]["name"] + "</a></li>"); str4.Append("<li><a href='" + dt2.Rows[0]["url"].ToString() + "'>" + dt2.Rows[0]["name"] + "</a>|</li>"); for (int i = 1; i < dt2.Rows.Count; i++) { str3.Append("<li><a href='" + dt2.Rows[i]["url"].ToString() + "'>" + dt2.Rows[i]["name"] + "</a></li>"); str4.Append("<li><a href='" + dt2.Rows[i]["url"].ToString() + "'>" + dt2.Rows[i]["name"] + "</a>|</li>"); } nav1.InnerHtml = str3.ToString(); nav2.InnerHtml = str4.ToString(); } //加载图标信息 DataTable dt1 = bll1.ShowEnter(); StringBuilder str1 = new StringBuilder(); StringBuilder str2 = new StringBuilder(); for (var i = 0; i < dt1.Rows.Count; i++) { string type = dt1.Rows[i]["Type"].ToString(); if (type == "1") { str1.Append("<div class='col-md-4'><div class='modal-content clearfix'><a href='Labrary_introduce.aspx?Id=" + dt1.Rows[i]["Id"] + "'><span class='icon icon0" + (i + 1) + "'></span><h3>" + dt1.Rows[i]["Cname"].ToString() + "<small>" + dt1.Rows[i]["Ename"].ToString() + "</small></h3><p> " + dt1.Rows[i]["News"].ToString() + "</p></a></div></div>"); enter1.InnerHtml = str1.ToString(); } else if (type == "2") { str2.Append("<div class='col-xs-12 col-md-4 clearfix'><a href='Labrary_introduce.aspx?Id=" + dt1.Rows[i]["Id"] + "' class='img-circle text-center'><img src='img/icon08.png' width='37' height='62'></a><h3><a href='Labrary_introduce.aspx?Id=" + dt1.Rows[i]["Id"] + "'>" + dt1.Rows[i]["Cname"] + "<small>" + dt1.Rows[i]["Ename"] + "</small></a></h3><p>" + dt1.Rows[i]["News"] + "</p><a href='Labrary_introduce.aspx?Id=" + dt1.Rows[i]["Id"] + "' class='btn btn-more'>MORE</a></div>"); enter2.InnerHtml = str2.ToString(); } } //加载通知信息 DataTable dt3 = bll3.showNotice(); StringBuilder str5 = new StringBuilder(); if (dt3.Rows.Count > 0) { for (int i = dt3.Rows.Count - 1; i > dt3.Rows.Count - 11; i--) { str5.Append("<li><a href='#'>" + dt3.Rows[i]["Title"].ToString() + "</a></li>"); inform.InnerHtml = str5.ToString(); } } else { inform.InnerHtml = "暂无通知数据!"; } } }