?? 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;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -