borrowbook.cs

数据库文件先要导入

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

namespace 图书管理系统
{
	/// <summary>
	/// borrow 的摘要说明。
	/// </summary>
	public class borrowbook : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.Button button2;
		private System.Windows.Forms.TextBox texID1;
		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.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.GroupBox groupBox3;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.GroupBox groupBox4;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.TextBox texBD1;
		private System.Windows.Forms.TextBox texRD1;
		private System.Windows.Forms.TextBox texBZ2;
		private System.Windows.Forms.TextBox texBN1;
		private System.Windows.Forms.TextBox tex1;
		private System.Windows.Forms.TextBox tex2;


		LibClass lc=new LibClass();

	    public static string i,j;
		private System.Windows.Forms.TextBox texS1;
		private System.Windows.Forms.Button button3;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public borrowbook()
		{
			//
			// 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.label1 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.texID1 = new System.Windows.Forms.TextBox();
			this.texBD1 = new System.Windows.Forms.TextBox();
			this.texRD1 = new System.Windows.Forms.TextBox();
			this.button1 = new System.Windows.Forms.Button();
			this.button2 = new System.Windows.Forms.Button();
			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.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.groupBox3 = new System.Windows.Forms.GroupBox();
			this.button3 = new System.Windows.Forms.Button();
			this.label7 = new System.Windows.Forms.Label();
			this.tex2 = new System.Windows.Forms.TextBox();
			this.label4 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.tex1 = new System.Windows.Forms.TextBox();
			this.label2 = new System.Windows.Forms.Label();
			this.groupBox4 = new System.Windows.Forms.GroupBox();
			this.groupBox1.SuspendLayout();
			this.groupBox2.SuspendLayout();
			this.groupBox3.SuspendLayout();
			this.groupBox4.SuspendLayout();
			this.SuspendLayout();
			// 
			// label1
			// 
			this.label1.AutoSize = true;
			this.label1.Location = new System.Drawing.Point(16, 24);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(66, 17);
			this.label1.TabIndex = 0;
			this.label1.Text = "读者编号：";
			// 
			// label5
			// 
			this.label5.AutoSize = true;
			this.label5.Location = new System.Drawing.Point(16, 120);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(66, 17);
			this.label5.TabIndex = 4;
			this.label5.Text = "借书日期：";
			// 
			// label6
			// 
			this.label6.AutoSize = true;
			this.label6.Location = new System.Drawing.Point(232, 120);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(66, 17);
			this.label6.TabIndex = 5;
			this.label6.Text = "还书日期：";
			// 
			// texID1
			// 
			this.texID1.Location = new System.Drawing.Point(96, 24);
			this.texID1.Name = "texID1";
			this.texID1.Size = new System.Drawing.Size(128, 21);
			this.texID1.TabIndex = 7;
			this.texID1.Text = "";
			this.texID1.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.texID1_KeyPress);
			// 
			// texBD1
			// 
			this.texBD1.Location = new System.Drawing.Point(96, 120);
			this.texBD1.Name = "texBD1";
			this.texBD1.ReadOnly = true;
			this.texBD1.Size = new System.Drawing.Size(128, 21);
			this.texBD1.TabIndex = 11;
			this.texBD1.TabStop = false;
			this.texBD1.Text = "";
			// 
			// texRD1
			// 
			this.texRD1.Location = new System.Drawing.Point(304, 120);
			this.texRD1.Name = "texRD1";
			this.texRD1.ReadOnly = true;
			this.texRD1.Size = new System.Drawing.Size(128, 21);
			this.texRD1.TabIndex = 12;
			this.texRD1.TabStop = false;
			this.texRD1.Text = "";
			// 
			// button1
			// 
			this.button1.Location = new System.Drawing.Point(40, 64);
			this.button1.Name = "button1";
			this.button1.Size = new System.Drawing.Size(75, 48);
			this.button1.TabIndex = 14;
			this.button1.Text = "借出";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// button2
			// 
			this.button2.Location = new System.Drawing.Point(40, 152);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(75, 48);
			this.button2.TabIndex = 15;
			this.button2.Text = "取消";
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.texS1);
			this.groupBox1.Controls.Add(this.texBZ1);
			this.groupBox1.Controls.Add(this.label26);
			this.groupBox1.Controls.Add(this.texN1);
			this.groupBox1.Controls.Add(this.label13);
			this.groupBox1.Controls.Add(this.label14);
			this.groupBox1.Controls.Add(this.texE1);
			this.groupBox1.Controls.Add(this.label15);
			this.groupBox1.Controls.Add(this.label1);
			this.groupBox1.Controls.Add(this.texID1);
			this.groupBox1.Location = new System.Drawing.Point(16, 8);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(456, 160);
			this.groupBox1.TabIndex = 17;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "读者信息";
			// 
			// texS1
			// 
			this.texS1.Location = new System.Drawing.Point(96, 88);
			this.texS1.Name = "texS1";
			this.texS1.ReadOnly = true;
			this.texS1.Size = new System.Drawing.Size(128, 21);
			this.texS1.TabIndex = 13;
			this.texS1.TabStop = false;
			this.texS1.Text = "";
			// 
			// texBZ1
			// 
			this.texBZ1.Location = new System.Drawing.Point(304, 24);
			this.texBZ1.Multiline = true;
			this.texBZ1.Name = "texBZ1";
			this.texBZ1.ReadOnly = true;
			this.texBZ1.Size = new System.Drawing.Size(128, 120);
			this.texBZ1.TabIndex = 12;
			this.texBZ1.TabStop = false;
			this.texBZ1.Text = "";
			// 
			// label26
			// 
			this.label26.AutoSize = true;
			this.label26.Location = new System.Drawing.Point(248, 24);
			this.label26.Name = "label26";
			this.label26.Size = new System.Drawing.Size(42, 17);
			this.label26.TabIndex = 11;
			this.label26.Text = "备注：";
			// 
			// texN1
			// 
			this.texN1.Location = new System.Drawing.Point(96, 56);
			this.texN1.Name = "texN1";
			this.texN1.ReadOnly = true;
			this.texN1.Size = new System.Drawing.Size(128, 21);
			this.texN1.TabIndex = 5;
			this.texN1.TabStop = false;
			this.texN1.Text = "";
			// 
			// label13
			// 
			this.label13.AutoSize = true;
			this.label13.Location = new System.Drawing.Point(40, 56);
			this.label13.Name = "label13";
			this.label13.Size = new System.Drawing.Size(42, 17);
			this.label13.TabIndex = 0;
			this.label13.Text = "姓名：";
			// 
			// label14
			// 
			this.label14.AutoSize = true;
			this.label14.Location = new System.Drawing.Point(24, 120);
			this.label14.Name = "label14";
			this.label14.Size = new System.Drawing.Size(54, 17);
			this.label14.TabIndex = 4;
			this.label14.Text = "E-Mail：";
			// 
			// texE1
			// 
			this.texE1.Location = new System.Drawing.Point(96, 120);
			this.texE1.Name = "texE1";
			this.texE1.ReadOnly = true;
			this.texE1.Size = new System.Drawing.Size(128, 21);
			this.texE1.TabIndex = 8;
			this.texE1.TabStop = false;
			this.texE1.Text = "";
			// 
			// label15
			// 
			this.label15.AutoSize = true;
			this.label15.Location = new System.Drawing.Point(40, 88);
			this.label15.Name = "label15";
			this.label15.Size = new System.Drawing.Size(42, 17);
			this.label15.TabIndex = 1;
			this.label15.Text = "性别：";
			// 
			// 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);