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 = "暂无通知数据！";
}
}
}
