?? borrowbooks.cs
字號:
/***********************************
*
* 流通表
* 設(shè)立歸還標(biāo)志，從而可以實現(xiàn)歷史記錄的功能
* 標(biāo)志：1 為 未歸還；0 為 已歸還
*
*
* *********************************/
using System;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
namespace Library
{
/// <summary>
/// BorrowBooks 的摘要說明。
/// </summary>
public class BorrowBooks : System.Windows.Forms.Form
{
private System.Windows.Forms.Label label1;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.GroupBox groupBox2;
private System.Windows.Forms.GroupBox groupBox3;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.TextBox textBox6;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.GroupBox groupBox4;
private System.Windows.Forms.ListView listView1;
private System.Windows.Forms.GroupBox groupBox5;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button btnBorrow;
private System.Windows.Forms.Label label10;
private System.Windows.Forms.TextBox textBox7;
private System.Windows.Forms.GroupBox groupBox6;
private System.Windows.Forms.Label label12;
private System.Windows.Forms.Label label11;
private System.Windows.Forms.Label label13;
private System.Windows.Forms.TextBox textBox8;
private System.Windows.Forms.TextBox textBox9;
private System.Windows.Forms.TextBox textBox10;
private System.Windows.Forms.Label label14;
private System.Windows.Forms.Label label15;
private System.Windows.Forms.Button btnRefresh;
private System.Windows.Forms.Button btnForfeit;
private System.Windows.Forms.GroupBox groupBox7;
private System.Windows.Forms.Label label16;
/// <summary>
/// 必需的設(shè)計器變量。
/// </summary>
private System.ComponentModel.Container components = null;
private SqlCommand cmd = null;
private SqlDataReader dr = null;
private int i = 0;//讀者已經(jīng)借閱圖書數(shù)量
private int dc = 0;//讀者能夠借閱圖書天數(shù)
private int rc = 0;//讀者能夠借閱的圖書數(shù)量
private bool canBorrow = false;//圖書是否能夠被借閱
public BorrowBooks()
{
//
// Windows 窗體設(shè)計器支持所必需的
//
InitializeComponent();
//ListView
listView1.Columns.Add("借書證號",100,HorizontalAlignment.Left);
listView1.Columns.Add("所借圖書",120,HorizontalAlignment.Left);
listView1.Columns.Add("作者",80,HorizontalAlignment.Left);
listView1.Columns.Add("出版社",100,HorizontalAlignment.Left);
listView1.Columns.Add("借書日期",100,HorizontalAlignment.Left);
listView1.Columns.Add("還書日期",100,HorizontalAlignment.Left);
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設(shè)計器生成的代碼
/// <summary>
/// 設(shè)計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
this.label1 = new System.Windows.Forms.Label();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.label14 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.textBox1 = new System.Windows.Forms.TextBox();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.label9 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.textBox6 = new System.Windows.Forms.TextBox();
this.textBox5 = new System.Windows.Forms.TextBox();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.groupBox3 = new System.Windows.Forms.GroupBox();
this.label15 = new System.Windows.Forms.Label();
this.textBox7 = new System.Windows.Forms.TextBox();
this.label10 = new System.Windows.Forms.Label();
this.groupBox4 = new System.Windows.Forms.GroupBox();
this.listView1 = new System.Windows.Forms.ListView();
this.groupBox5 = new System.Windows.Forms.GroupBox();
this.btnForfeit = new System.Windows.Forms.Button();
this.btnRefresh = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.btnBorrow = new System.Windows.Forms.Button();
this.groupBox6 = new System.Windows.Forms.GroupBox();
this.textBox10 = new System.Windows.Forms.TextBox();
this.textBox9 = new System.Windows.Forms.TextBox();
this.textBox8 = new System.Windows.Forms.TextBox();
this.label13 = new System.Windows.Forms.Label();
this.label12 = new System.Windows.Forms.Label();
this.label11 = new System.Windows.Forms.Label();
this.groupBox7 = new System.Windows.Forms.GroupBox();
this.label16 = new System.Windows.Forms.Label();
this.groupBox1.SuspendLayout();
this.groupBox2.SuspendLayout();
this.groupBox3.SuspendLayout();
this.groupBox4.SuspendLayout();
this.groupBox5.SuspendLayout();
this.groupBox6.SuspendLayout();
this.groupBox7.SuspendLayout();
this.SuspendLayout();
//
// label1
//
this.label1.BackColor = System.Drawing.Color.WhiteSmoke;
this.label1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.label1.Font = new System.Drawing.Font("宋體", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label1.Location = new System.Drawing.Point(282, 16);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(216, 23);
this.label1.TabIndex = 0;
this.label1.Text = "借 閱 圖 書";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// groupBox1
//
this.groupBox1.Controls.Add(this.label14);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.textBox1);
this.groupBox1.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.groupBox1.Location = new System.Drawing.Point(32, 56);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(261, 112);
this.groupBox1.TabIndex = 0;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "讀者驗證";
//
// label14
//
this.label14.AutoSize = true;
this.label14.ForeColor = System.Drawing.Color.Red;
this.label14.Location = new System.Drawing.Point(192, 72);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(48, 17);
this.label14.TabIndex = 4;
this.label14.Text = "<Enter>";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(34, 35);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(79, 17);
this.label2.TabIndex = 3;
this.label2.Text = "讀者借書證號";
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(34, 67);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(158, 21);
this.textBox1.TabIndex = 0;
this.textBox1.Text = "";
this.textBox1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.textBox1_KeyDown);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.label9);
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.textBox6);
this.groupBox2.Controls.Add(this.textBox5);
this.groupBox2.Controls.Add(this.textBox4);
this.groupBox2.Controls.Add(this.textBox3);
this.groupBox2.Controls.Add(this.textBox2);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.label3);
this.groupBox2.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.groupBox2.Location = new System.Drawing.Point(32, 176);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(261, 208);
this.groupBox2.TabIndex = 3;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "讀者信息";
//
// label9
//
this.label9.AutoSize = true;
this.label9.Location = new System.Drawing.Point(208, 176);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(17, 17);
this.label9.TabIndex = 11;
this.label9.Text = "冊";
//
// label8
//
this.label8.AutoSize = true;
this.label8.Location = new System.Drawing.Point(208, 136);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(17, 17);
this.label8.TabIndex = 10;
this.label8.Text = "冊";
//
// textBox6
//
this.textBox6.Location = new System.Drawing.Point(96, 176);
this.textBox6.Name = "textBox6";
this.textBox6.ReadOnly = true;
this.textBox6.Size = new System.Drawing.Size(104, 21);
this.textBox6.TabIndex = 8;
this.textBox6.Text = "";
//
// textBox5
//
this.textBox5.Location = new System.Drawing.Point(96, 136);
this.textBox5.Name = "textBox5";
this.textBox5.ReadOnly = true;
this.textBox5.Size = new System.Drawing.Size(104, 21);
this.textBox5.TabIndex = 7;
this.textBox5.Text = "";
//
// textBox4
//
this.textBox4.Location = new System.Drawing.Point(96, 96);
this.textBox4.Name = "textBox4";
this.textBox4.ReadOnly = true;
this.textBox4.Size = new System.Drawing.Size(136, 21);
this.textBox4.TabIndex = 6;
this.textBox4.Text = "";
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(96, 56);
this.textBox3.Name = "textBox3";
this.textBox3.ReadOnly = true;
this.textBox3.Size = new System.Drawing.Size(136, 21);
this.textBox3.TabIndex = 5;
this.textBox3.Text = "";
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(96, 24);
this.textBox2.Name = "textBox2";
this.textBox2.ReadOnly = true;
this.textBox2.Size = new System.Drawing.Size(136, 21);
this.textBox2.TabIndex = 4;
this.textBox2.Text = "";
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(24, 176);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(54, 17);
this.label7.TabIndex = 4;
this.label7.Text = "當(dāng)前剩余";
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(24, 136);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(66, 17);
this.label6.TabIndex = 3;
this.label6.Text = "可借閱數(shù)量";
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(24, 96);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(29, 17);
this.label5.TabIndex = 2;
this.label5.Text = "類型";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(24, 64);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(29, 17);
this.label4.TabIndex = 1;
this.label4.Text = "性別";
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(24, 24);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(29, 17);
this.label3.TabIndex = 0;
this.label3.Text = "姓名";
//
// groupBox3
//
this.groupBox3.Controls.Add(this.label15);
this.groupBox3.Controls.Add(this.textBox7);
this.groupBox3.Controls.Add(this.label10);
this.groupBox3.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.groupBox3.Location = new System.Drawing.Point(336, 56);
this.groupBox3.Name = "groupBox3";
this.groupBox3.Size = new System.Drawing.Size(416, 72);
this.groupBox3.TabIndex = 1;
this.groupBox3.TabStop = false;
this.groupBox3.Text = "借閱圖書";
//
// label15
//
this.label15.AutoSize = true;
this.label15.ForeColor = System.Drawing.Color.Red;
this.label15.Location = new System.Drawing.Point(320, 32);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(48, 17);
this.label15.TabIndex = 5;
this.label15.Text = "<Enter>";
//
// textBox7
//
this.textBox7.Location = new System.Drawing.Point(112, 30);
this.textBox7.Name = "textBox7";
this.textBox7.Size = new System.Drawing.Size(200, 21);
this.textBox7.TabIndex = 1;
this.textBox7.Text = "";
this.textBox7.KeyDown += new System.Windows.Forms.KeyEventHandler(this.textBox7_KeyDown);
//
// label10
//
this.label10.AutoSize = true;
this.label10.Location = new System.Drawing.Point(32, 32);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(54, 17);
this.label10.TabIndex = 0;
this.label10.Text = "圖書條碼";
//
// groupBox4
//
this.groupBox4.Controls.Add(this.listView1);
this.groupBox4.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.groupBox4.Location = new System.Drawing.Point(336, 264);
this.groupBox4.Name = "groupBox4";
this.groupBox4.Size = new System.Drawing.Size(416, 160);
this.groupBox4.TabIndex = 5;
this.groupBox4.TabStop = false;
this.groupBox4.Text = "當(dāng)前讀者已借書";
//
// listView1
//
this.listView1.Dock = System.Windows.Forms.DockStyle.Fill;
this.listView1.FullRowSelect = true;
this.listView1.GridLines = true;
this.listView1.Location = new System.Drawing.Point(3, 17);
this.listView1.Name = "listView1";
this.listView1.Size = new System.Drawing.Size(410, 140);
this.listView1.TabIndex = 5;
this.listView1.View = System.Windows.Forms.View.Details;
//
// groupBox5
//
this.groupBox5.Controls.Add(this.btnForfeit);
this.groupBox5.Controls.Add(this.btnRefresh);
this.groupBox5.Controls.Add(this.button2);
this.groupBox5.Controls.Add(this.btnBorrow);
this.groupBox5.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.groupBox5.Location = new System.Drawing.Point(336, 432);
this.groupBox5.Name = "groupBox5";
this.groupBox5.Size = new System.Drawing.Size(416, 64);
this.groupBox5.TabIndex = 2;
this.groupBox5.TabStop = false;
//
// btnForfeit
//
this.btnForfeit.Enabled = false;
this.btnForfeit.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.btnForfeit.Location = new System.Drawing.Point(220, 24);
this.btnForfeit.Name = "btnForfeit";
this.btnForfeit.TabIndex = 6;
this.btnForfeit.Text = "罰款";
//
// btnRefresh
//
this.btnRefresh.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.btnRefresh.Location = new System.Drawing.Point(121, 24);
this.btnRefresh.Name = "btnRefresh";
this.btnRefresh.TabIndex = 4;
this.btnRefresh.Text = "重置";
this.btnRefresh.Click += new System.EventHandler(this.btnRefresh_Click);
//
// button2
//
this.button2.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.button2.Location = new System.Drawing.Point(319, 24);
this.button2.Name = "button2";
this.button2.TabIndex = 3;
this.button2.Text = "關(guān)閉";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// btnBorrow
//
this.btnBorrow.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.btnBorrow.Location = new System.Drawing.Point(22, 24);
this.btnBorrow.Name = "btnBorrow";
this.btnBorrow.TabIndex = 2;
this.btnBorrow.Text = "借閱";
this.btnBorrow.Click += new System.EventHandler(this.btnBorrow_Click);
//
// groupBox6
//
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -