bookborrow.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 cancel_Click(object sender, EventArgs e)
    {
        booknumber.Text = "";
        readernumber.Text = "";
    }
    protected void borrow_Click(object sender, EventArgs e)
    {
        string bn = booknumber.Text;
        string rn = readernumber.Text;
        string time=DateTime.Now.ToShortDateString();
        string etime=DateTime.Now.AddMonths(1).ToShortDateString();
       
        string getbn="select count(*) from book where bgetnumber='"+bn+"'";
        string getrn = "select count(*) from aspnet_Users where UserName='" + rn + "'";
        string addborrow="insert into bookborrow values('"+bn+"','"+rn +"','"+time+"','"+etime+"')";

        if (Convert.ToString(operatedb.ExecuteScalar(getbn)) == "0")
            Response.Write("<script   language='javascript'   defer>alert('没有该图书，或图书索取号输入错误，请重新输入');</script>");
        else if (Convert.ToString(operatedb.ExecuteScalar(getrn)) == "0")
            Response.Write("<script   language='javascript'   defer>alert('没有该读者，或读者证件号码输入错误');</script>");
        else
        {
            operatedb.ExecuteSql(addborrow);
            Response.Write("<script   language='javascript'   defer>alert('借书成功');</script>");
        }
        
    }
}