returnbook.cs

数据库文件先要导入

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;

namespace 图书管理系统
{
	/// <summary>
	/// returnbook 的摘要说明。
	/// </summary>
	public class returnbook : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Button button2;
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.GroupBox groupBox3;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.TextBox texPr1;
		private System.Windows.Forms.Label label21;
		private System.Windows.Forms.TextBox texP1;
		private System.Windows.Forms.TextBox texA1;
		private System.Windows.Forms.TextBox texT1;
		private System.Windows.Forms.TextBox texI1;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.TextBox texBZ1;
		private System.Windows.Forms.Label label26;
		private System.Windows.Forms.TextBox texN1;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.TextBox texE1;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox texID1;
		private System.Windows.Forms.TextBox texBZ2;
		private System.Windows.Forms.TextBox texBN1;
		private System.Windows.Forms.TextBox texBD1;
		private System.Windows.Forms.TextBox texRD1;


		LibClass lc=new LibClass();
		private System.Windows.Forms.TextBox texS1;
		private System.Windows.Forms.Label label2;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public returnbook()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.button2 = new System.Windows.Forms.Button();
			this.button1 = new System.Windows.Forms.Button();
			this.groupBox3 = new System.Windows.Forms.GroupBox();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.texPr1 = new System.Windows.Forms.TextBox();
			this.label21 = new System.Windows.Forms.Label();
			this.texBZ2 = new System.Windows.Forms.TextBox();
			this.texP1 = new System.Windows.Forms.TextBox();
			this.texA1 = new System.Windows.Forms.TextBox();
			this.texT1 = new System.Windows.Forms.TextBox();
			this.texBN1 = new System.Windows.Forms.TextBox();
			this.texI1 = new System.Windows.Forms.TextBox();
			this.label8 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.label11 = new System.Windows.Forms.Label();
			this.label12 = new System.Windows.Forms.Label();
			this.label16 = new System.Windows.Forms.Label();
			this.label17 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.texBD1 = new System.Windows.Forms.TextBox();
			this.texRD1 = new System.Windows.Forms.TextBox();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.texS1 = new System.Windows.Forms.TextBox();
			this.texBZ1 = new System.Windows.Forms.TextBox();
			this.label26 = new System.Windows.Forms.Label();
			this.texN1 = new System.Windows.Forms.TextBox();
			this.label13 = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.texE1 = new System.Windows.Forms.TextBox();
			this.label15 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.texID1 = new System.Windows.Forms.TextBox();
			this.label2 = new System.Windows.Forms.Label();
			this.groupBox3.SuspendLayout();
			this.groupBox2.SuspendLayout();
			this.groupBox1.SuspendLayout();
			this.SuspendLayout();
			// 
			// button2
			// 
			this.button2.Location = new System.Drawing.Point(40, 240);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(75, 45);
			this.button2.TabIndex = 33;
			this.button2.Text = "取消";
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// button1
			// 
			this.button1.Location = new System.Drawing.Point(40, 112);
			this.button1.Name = "button1";
			this.button1.Size = new System.Drawing.Size(75, 45);
			this.button1.TabIndex = 32;
			this.button1.Text = "还书";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// groupBox3
			// 
			this.groupBox3.Controls.Add(this.label2);
			this.groupBox3.Controls.Add(this.button1);
			this.groupBox3.Controls.Add(this.button2);
			this.groupBox3.Location = new System.Drawing.Point(480, 8);
			this.groupBox3.Name = "groupBox3";
			this.groupBox3.Size = new System.Drawing.Size(152, 416);
			this.groupBox3.TabIndex = 36;
			this.groupBox3.TabStop = false;
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.texPr1);
			this.groupBox2.Controls.Add(this.label21);
			this.groupBox2.Controls.Add(this.texBZ2);
			this.groupBox2.Controls.Add(this.texP1);
			this.groupBox2.Controls.Add(this.texA1);
			this.groupBox2.Controls.Add(this.texT1);
			this.groupBox2.Controls.Add(this.texBN1);
			this.groupBox2.Controls.Add(this.texI1);
			this.groupBox2.Controls.Add(this.label8);
			this.groupBox2.Controls.Add(this.label9);
			this.groupBox2.Controls.Add(this.label11);
			this.groupBox2.Controls.Add(this.label12);
			this.groupBox2.Controls.Add(this.label16);
			this.groupBox2.Controls.Add(this.label17);
			this.groupBox2.Controls.Add(this.label5);
			this.groupBox2.Controls.Add(this.label6);
			this.groupBox2.Controls.Add(this.texBD1);
			this.groupBox2.Controls.Add(this.texRD1);
			this.groupBox2.Location = new System.Drawing.Point(16, 168);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(456, 256);
			this.groupBox2.TabIndex = 37;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "书籍信息";
			// 
			// texPr1
			// 
			this.texPr1.Location = new System.Drawing.Point(304, 56);
			this.texPr1.Name = "texPr1";
			this.texPr1.ReadOnly = true;
			this.texPr1.Size = new System.Drawing.Size(128, 21);
			this.texPr1.TabIndex = 16;
			this.texPr1.TabStop = false;
			this.texPr1.Text = "";
			// 
			// label21
			// 
			this.label21.AutoSize = true;
			this.label21.Location = new System.Drawing.Point(256, 56);
			this.label21.Name = "label21";
			this.label21.Size = new System.Drawing.Size(42, 17);
			this.label21.TabIndex = 15;
			this.label21.Text = "价格：";
			// 
			// texBZ2
			// 
			this.texBZ2.Location = new System.Drawing.Point(96, 152);
			this.texBZ2.Multiline = true;
			this.texBZ2.Name = "texBZ2";
			this.texBZ2.ReadOnly = true;
			this.texBZ2.Size = new System.Drawing.Size(336, 88);
			this.texBZ2.TabIndex = 14;
			this.texBZ2.TabStop = false;
			this.texBZ2.Text = "";
			// 
			// texP1
			// 
			this.texP1.Location = new System.Drawing.Point(304, 88);
			this.texP1.Name = "texP1";
			this.texP1.ReadOnly = true;
			this.texP1.Size = new System.Drawing.Size(128, 21);
			this.texP1.TabIndex = 12;
			this.texP1.TabStop = false;
			this.texP1.Text = "";
			// 
			// texA1
			// 
			this.texA1.Location = new System.Drawing.Point(96, 88);
			this.texA1.Name = "texA1";
			this.texA1.ReadOnly = true;
			this.texA1.Size = new System.Drawing.Size(128, 21);
			this.texA1.TabIndex = 11;
			this.texA1.TabStop = false;
			this.texA1.Text = "";
			// 
			// texT1
			// 
			this.texT1.Location = new System.Drawing.Point(96, 56);
			this.texT1.Name = "texT1";
			this.texT1.ReadOnly = true;
			this.texT1.Size = new System.Drawing.Size(128, 21);
			this.texT1.TabIndex = 10;
			this.texT1.TabStop = false;
			this.texT1.Text = "";
			// 
			// texBN1
			// 
			this.texBN1.Location = new System.Drawing.Point(304, 24);
			this.texBN1.Name = "texBN1";
			this.texBN1.ReadOnly = true;
			this.texBN1.Size = new System.Drawing.Size(128, 21);
			this.texBN1.TabIndex = 9;
			this.texBN1.TabStop = false;
			this.texBN1.Text = "";
			// 
			// texI1
			// 
			this.texI1.Location = new System.Drawing.Point(96, 24);
			this.texI1.Name = "texI1";
			this.texI1.Size = new System.Drawing.Size(128, 21);
			this.texI1.TabIndex = 8;
			this.texI1.Text = "";
			this.texI1.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.texI1_KeyPress);
			// 
			// label8
			// 
			this.label8.AutoSize = true;
			this.label8.Location = new System.Drawing.Point(256, 24);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(42, 17);
			this.label8.TabIndex = 1;
			this.label8.Text = "书名：";
			// 
			// label9
			//