returnbook.cs

数据库文件先要导入

			this.label9.AutoSize = true;
			this.label9.Location = new System.Drawing.Point(240, 88);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(54, 17);
			this.label9.TabIndex = 4;
			this.label9.Text = "出版社：";
			// 
			// label11
			// 
			this.label11.AutoSize = true;
			this.label11.Location = new System.Drawing.Point(40, 24);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(42, 17);
			this.label11.TabIndex = 7;
			this.label11.Text = "ISBN：";
			// 
			// label12
			// 
			this.label12.AutoSize = true;
			this.label12.Location = new System.Drawing.Point(40, 88);
			this.label12.Name = "label12";
			this.label12.Size = new System.Drawing.Size(42, 17);
			this.label12.TabIndex = 3;
			this.label12.Text = "作者：";
			// 
			// label16
			// 
			this.label16.AutoSize = true;
			this.label16.Location = new System.Drawing.Point(40, 56);
			this.label16.Name = "label16";
			this.label16.Size = new System.Drawing.Size(42, 17);
			this.label16.TabIndex = 2;
			this.label16.Text = "类别：";
			// 
			// label17
			// 
			this.label17.AutoSize = true;
			this.label17.Location = new System.Drawing.Point(40, 144);
			this.label17.Name = "label17";
			this.label17.Size = new System.Drawing.Size(42, 17);
			this.label17.TabIndex = 6;
			this.label17.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 = "还书日期：";
			// 
			// 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 = "";
			// 
			// 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 = 38;
			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 = "性别：";
			// 
			// 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 = "读者编号：";
			// 
			// 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);
			// 
			// label2
			// 
			this.label2.AutoSize = true;
			this.label2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label2.ForeColor = System.Drawing.Color.Red;
			this.label2.Location = new System.Drawing.Point(24, 24);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(0, 17);
			this.label2.TabIndex = 34;
			// 
			// returnbook
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(648, 438);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.groupBox2);
			this.Controls.Add(this.groupBox3);
			this.Name = "returnbook";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "还书";
			this.groupBox3.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			this.groupBox1.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		private void texID1_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
		{
			if(e.KeyChar==13)
			{
				string[] s=new string[5];
				s=lc.selectreader("RID",texID1.Text);
				texN1.Text=s[1];   
				texS1.Text=s[2];
				texE1.Text=s[3];
				texBZ1.Text=s[4];
			}
		}

		private void texI1_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
		{
			if(e.KeyChar==13)
			{
				string[] s=new string[8];
				s=lc.selectbook("ISBN",texI1.Text);
				texBN1.Text=s[1];   
				texT1.Text=s[2];
				texPr1.Text=s[4];
				texA1.Text=s[5];
				texP1.Text=s[6];
				texBZ2.Text=s[7];
				texRD1.Text=lc.Rdate(texID1.Text,texI1.Text);
				texBD1.Text=lc.Bdate(texID1.Text,texI1.Text);
			}
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			if(Convert.ToDateTime(texRD1.Text)<DateTime.Now.Date)
			{
				label2.Text="已超过还书日期!";
				lc.returnbook(texI1.Text,texID1.Text,DateTime.Now.Date,Convert.ToDateTime(texRD1.Text),texBZ1.Text);
			}
			else
			{
                lc.returnbook(texI1.Text,texID1.Text,DateTime.Now.Date,Convert.ToDateTime(texRD1.Text),texBZ1.Text);
			}
		}
	}
}