bookin.aspx.cs

c#做的一个图书管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class librarian_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void BulletedList1_Click(object sender, BulletedListEventArgs e)
    {
        ListItem li = BulletedList1.Items[e.Index];
        switch (Convert.ToString(li.Text))
        {
            case "本人信息": Server.Transfer("Default.aspx"); break;
            case "还书受理": Server.Transfer("bookreturn.aspx"); break;
            case "借阅受理": Server.Transfer("bookborrow.aspx"); break;
            case "读者罚款受理": Server.Transfer("finepro.aspx"); break;
            case "读者证件挂失受理": Server.Transfer("idlosspro.aspx"); break;
            case "新书入库": Server.Transfer("bookin.aspx"); break;
            case "密码修改": Server.Transfer("passwordchange.aspx"); break;
            case "使用帮助": Server.Transfer("help.aspx"); break;
            default: Server.Transfer("Default.aspx"); break;
        }
    }
    protected void LoginStatus1_LoggingOut(object sender, LoginCancelEventArgs e)
    {
        Response.Redirect("~/logout.aspx");
    }

    protected void Button2_Click(object sender, EventArgs e)
    {   string number = tbx_bindex.Text;
        string confirm="select count(*)from book where bgetnumber='"+number+"'";
        if (Convert.ToString(operatedb.ExecuteScalar(confirm))!="0")
            Response.Write("<script   language='javascript'   defer>alert('已有该索取号,不能插入重复的索取号');</script>");
        else
        {

            string name = tbx_bname.Text;
            string author = tbx_bauthor.Text;
            int price = int.Parse(tbx_bprice.Text);
            string press = tbx_bpress.Text;
            string backup =tbx_bdescribe.Text;
            DateTime time = DateTime.Parse(tbx_bdate.Text);

            string keyword = tbx_btheme.Text;


            string sql = "insert into book(bname,bauthor,bpress,bprice,bgetnumber,bkeyword,bbackup,bdate) values('" + name + "','" + author + "','" + press + "','" + price + "','" + number + "','" + keyword + "','" + backup + "','"+time+"')";
            operatedb.ExecuteSql(sql);
            Response.Write("<script   language='javascript'   defer>alert('添加成功');</script>");

        }
    }
}