?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;
        }
    }
}