protected void btn_confirm_Click(object sender, EventArgs e)
{
if (rbl_group.SelectedItem == null)
{
Response.Write("<script language='javascript'>alert('推荐失败，未选中任何想要推荐的小组');</script>");
lab_tip.Text = "未选中任何想要分享推荐的小组";
}
else
{
int group_id = Convert.ToInt32(rbl_group.SelectedItem.Value);
User user = (User)Session["user"];
AdminBook adminbook = (AdminBook)Session["adminbook"];
RecommendTableAdapter ta_recommend = new RecommendTableAdapter();
DataTable dt_recommend = ta_recommend.GetRecoByNameGroup(adminbook.name, group_id);
if (dt_recommend.Rows.Count > 0)
{
Response.Write("<script language='javascript'>alert('推荐失败，要推荐的内容在想推荐的组中已存在');</script>");
lab_tip.Text = "要推荐的内容在想推荐的组中已存在";
}
else
{
ta_recommend.InsertRecommend(adminbook.name, adminbook.url, adminbook.star, adminbook.author, adminbook.keyword, adminbook.score, adminbook.filetype,
group_id, user.name);
Response.Write("<script language='javascript'>alert('推荐成功');</script>");
lab_tip.Text = "推荐成功";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
User user = (User)Session["user"];
Connect connect = new Connect();
if (Session["user"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
AdminBook adminbook = (AdminBook)Session["adminbook"];
bookname = adminbook.name;
if (!IsPostBack)
{
string sql = "SELECT distinct dbo.[Group].id,dbo.[Group].boss_name,dbo.[Group].name FROM dbo.[Group] INNER JOIN dbo.UG ON dbo.UG.gid = dbo.[Group].id " +
"INNER JOIN dbo.[User] ON dbo.UG.user_id = dbo.[User].id " +
"WHERE dbo.[Group].boss_name='" + user.name + "' OR dbo.[User].name='" + user.name + "'";
DataSet dsGroup = new DataSet();
connect.FillDataSet(dsGroup, sql, "[Group]");
rbl_group.DataSource = dsGroup;
rbl_group.DataTextField = "name";
rbl_group.DataValueField = "id";
rbl_group.DataBind();
}
}
}
public static void AdminChoiceOfMenu(int input, int adminId)
{
switch (input)
{
case 1:
AdminBook.AddsBook(adminId);
break;
case 2:
AdminBook.SetsAmount(adminId);
break;
case 3:
AdminUsers.PrintUsers(adminId);
break;
case 4:
AdminUsers.SearchForUser(adminId);
break;
case 5:
AdminBook.UpdatesBook(adminId);
break;
case 6:
AdminBook.DeleteBook(adminId);
break;
case 7:
AdminBookCategory.AddsCategory(adminId);
break;
case 8:
AdminBook.AddCategoryToBook(adminId);
break;
case 9:
AdminBookCategory.UpdateCategory(adminId);
break;
case 10:
AdminBookCategory.DeleteCategory(adminId);
break;
case 11:
AdminUsers.AddingUser(adminId);
break;
default:
Messages.WrongInput();
break;
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
if (this.tree.SelectedNode == null)
{
lab_tip.Text = "<script>alert('没有选中目录项'); window.location.href='addbook.aspx'</script>";
}
else
{
Boolean b1 = lbl_selectednode.Text.EndsWith(".doc");
Boolean b2 = lbl_selectednode.Text.EndsWith(".pdf");
Boolean b3 = lbl_selectednode.Text.EndsWith(".txt");
Boolean b4 = lbl_selectednode.Text.EndsWith(".ppt");
Boolean b5 = lbl_selectednode.Text.EndsWith(".dwg");
if (b1 || b2 || b3 || b4 || b5)
{
lab_tip.Text = "<script>alert('不能在书籍下面添加书籍'); window.location.href='addbook.aspx'</script>";
}
else
{
AdminBookTableAdapter ta_adminbook = new AdminBookTableAdapter();
AdminBook book = new AdminBook();
book.name = txt_name.Text;
book.author = txt_author.Text;
book.keyword = txt_keyword.Text;
book.score = Convert.ToInt32(txt_score.Text);
book.star = Convert.ToInt32(ddl_star.SelectedItem.Value);
book.filetype = ddl_type.SelectedItem.Value;
book.name = book.name + "." + book.filetype;
if (file_book.HasFile)
{
string filename = file_book.FileName.ToLower();
file_book.SaveAs(Server.MapPath("~/admin/upload/bookfile/") + filename);
book.url = "admin/upload/bookfile/" + filename;
/*if (filename.EndsWith(".doc"))
* {
* file_book.SaveAs(Server.MapPath("~/upload/bookfile/") + filename + ".doc" );
* book.Bookway = "/upload/bookfile/" + filename + ".doc";
* }
* if (filename.EndsWith(".pdf"))
* {
* file_book.SaveAs(Server.MapPath("~/upload/bookfile/") + filename + ".pdf");
* book.Bookway = "/upload/bookfile/" + filename + ".pdf";
* }
* if (filename.EndsWith(".epub"))
* {
* file_book.SaveAs(Server.MapPath("~/upload/bookfile/") + book.Id.ToString() + ".epub");
* book.Bookway = "/upload/bookfile/" + book.Id.ToString() + ".epub";
* }*/
}
ta_adminbook.InsertAdminBook(book.name, book.url, book.star, book.author, book.keyword, book.score, book.filetype);
DataTable dt_adminBook = ta_adminbook.GetAdminBookByName(book.name);
int book_id = Convert.ToInt32(dt_adminBook.Rows[0]["id"]);
int booktype_id = Convert.ToInt32(this.tree.SelectedNode.Value);
AdminBTTableAdapter ta_adminBT = new AdminBTTableAdapter();
ta_adminBT.InsertAdminBT(book_id, booktype_id);
lab_tip.Text = "<script>alert('添加成功'); window.location.href='addbook.aspx'</script>";
}
}
}
