borrowbook.aspx.cs

课程设计专用的图书管理系统。绝对原创！希望对大家有所帮助

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;
using System.Data.SqlClient;

public partial class borrow : System.Web.UI.Page
{
    private static int MyBooks = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        Button1.Enabled = false;

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        
        //连接本地计算机的数据库
        SqlConnection cn = new SqlConnection("Server=.;database=Mylibrary;uid=sa;pwd=123");
        cn.Open();
        string constring = "insert into jieyue(图书编号,ReaderID,借阅时间,应还时间) Values('" + bookID.Text + "','" + ReaderID.Text + "','" + System.DateTime.Now.ToString() + "','" + System.DateTime.Now.AddMonths(1).ToString() + "')";
        //创建Command对象
        SqlCommand cm = new SqlCommand(constring, cn);
        try
        {
            int r = cm.ExecuteNonQuery();
            if (r == 1)
            {
                lblmessage.Text = "借阅成功！";
            }
            else
            {
                lblmessage.Text = "借阅失败！";
            }
           
        }
        catch (Exception ex)
        {
            Response.Write("出现错误，原因是： " + ex.Message);
        }
        finally
        {
            cn.Close();
        }
    }
    protected void check_Click(object sender, EventArgs e)
    {
        SqlConnection cn = new SqlConnection("Server=.;database=Mylibrary;uid=sa;pwd=123");
        cn.Open();
        string MySQL = "Select COUNT(ReaderID) From jieyue WHERE  ReaderID= '" + ReaderID.Text + "'";
        SqlCommand MyCommand = new SqlCommand(MySQL, cn);
        string MyCount = MyCommand.ExecuteScalar().ToString();
        MyBooks = Convert.ToInt16(MyCount);
        if (MyBooks < 5)
        {
            lblmessage.Text = "可以借阅！";
            Button1.Enabled = true;
        }
        else 
        {
            lblmessage.Text = "借书数量已满！不能再借";
            Button1.Enabled = false;
        }
    }
}