protected void btnOk_ServerClick(object sender, EventArgs e) { NavBLL bll = new NavBLL(); string name = navname.Value; string url = navurl.Value; if (name != "") { DataTable dt = bll.NavQuery(); foreach (DataRow item in dt.Rows) { if (item["name"].ToString() == name) { Response.Write("<script>alert('导航名不能重复!!!');</script>"); navname.Value = ""; return; } } //DataTable dt = bll.NavQuery(); int result = bll.NavAdd(name, url); if (result > 0) { Context.Response.Write("<script>alert('添加成功')</script>"); Context.Response.Redirect("NavList.aspx"); } } else { Response.Write("<script>alert('导航名不能为空!!!');</script>"); } }
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) { BLL.BookBll bll = new BLL.BookBll(); //接收传过来的ID int newbookId = Convert.ToInt32(Request["id"]); 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(); } ////新书的类别id为7 //int kindId = 7; //string str = string.Format("kindId={0}", kindId); ////获取model实体 //List<Book> booklist=bll.GetModelList(str); Book bookmodel = bll.GetBookModel(newbookId); StringBuilder builderContent = new StringBuilder(); builderContent.Append("<h2>新书速递<small>/New Express</small></h2>"); builderContent.Append("<div class='row book-info'><div class='col-md-6'><div class='col-xs-5 col-md-4 text-left' runat='server'><img src='" + bookmodel.Image + "'/></div>"); builderContent.Append("<div class='col-xs-7 col-md-8 text-left' runat='server'>"); builderContent.Append("<h3>" + bookmodel.Bookname + "</h3><ul class='list-unstyled'>"); builderContent.Append("<li>作者:" + bookmodel.Author + " </li>"); builderContent.Append("<li>出版社:" + bookmodel.Publishing_hose + "</li>"); builderContent.Append("<li>出版年:" + bookmodel.YearString + " </li>"); builderContent.Append("<li>定价:" + bookmodel.Price + "元</li>"); builderContent.Append("<li>装帧:" + bookmodel.Decorate + "</li>"); builderContent.Append("<li>ISBN:" + bookmodel.Number + "</li></ul></div></div>"); builderContent.Append("<div class='col-md-6'>"); builderContent.Append("<blockquote class='evaluate'><p><span class='star pull-left'></span><span class='red'>8.5</span><span class='sum'>(36个人评价)</span></p>"); builderContent.Append("<p class='info'>评价:<span class='star-lg'><em class='star-lg-hover star-lg04-hover'></em></span></p>"); builderContent.Append("<button type='button' class='btn btn-success'>评价</button></blockquote></div></div>"); builderContent.Append("<div id='book_content' class='book-content' runat='server'>"); builderContent.Append("<h4>内容简介</h4><p>" + bookmodel.Book_introduce + "</p>"); builderContent.Append("<h4>作者简介 </h4><p>" + bookmodel.Author_introduce + "</p>"); builderContent.Append("<h4>目录 </h4><p>" + bookmodel.Catalogs + "</p>"); builderContent.Append("</div>"); book_content.InnerHtml = builderContent.ToString(); } }
protected void btnOk_ServerClick(object sender, EventArgs e) { string old = oldname.Value; string news = newname.Value; string url = newUrl.Value; NavBLL bll = new NavBLL(); if (old == news) { Response.Write("<script>alert('请输入不同的导航名')</script>"); } else { if (news != "") { DataTable dt = bll.NavQuery(); foreach (DataRow item in dt.Rows) { if (item["name"].ToString() == news) { Response.Write("<script>alert('导航名不能重复!!!');</script>"); newname.Value = ""; return; } } int result = navBll.NavEdit(newname.Value, newUrl.Value, Nav.Id); if (result > 0) { Response.Write("<script>alert('修改成功')</script>"); Response.Redirect("NavList.aspx"); } } else { Response.Write("<script>alert('导航名不能为空!!!');</script>"); } } }
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(); } if (!string.IsNullOrEmpty(Request["Id"])) { int id = Convert.ToInt32(Request["Id"]); Entrance model = new Entrance(); DataTable dt = bll.QueryEnter(id); DataRow dr = dt.Rows[0]; if (dt.Rows.Count > 0) { Cname = dr["Cname"].ToString(); Ename = dr["Ename"].ToString(); News = dr["news"].ToString(); ss.InnerHtml = News; } } } }
protected void Page_Load(object sender, EventArgs e) { NavBLL bll2 = new NavBLL(); 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(); } } }
protected void Page_Load(object sender, EventArgs e) { NavBLL bll2 = new NavBLL(); 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(); } //加载单条通知详情 int id = Convert.ToInt32(Request["Id"]); 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(); tt.InnerHtml = News; } } }
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 = "暂无通知数据!"; } } }