chaxunf.cs

图书管理系统！！C#+olc 大小是100多k

			this.dataGrid3.DataMember = "";
			this.dataGrid3.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid3.Location = new System.Drawing.Point(16, 24);
			this.dataGrid3.Name = "dataGrid3";
			this.dataGrid3.Size = new System.Drawing.Size(344, 160);
			this.dataGrid3.TabIndex = 3;
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(40, 16);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(72, 23);
			this.label1.TabIndex = 2;
			this.label1.Text = "读者编号：";
			// 
			// button1
			// 
			this.button1.Location = new System.Drawing.Point(312, 16);
			this.button1.Name = "button1";
			this.button1.TabIndex = 1;
			this.button1.Text = "查询";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// textBox1
			// 
			this.textBox1.Location = new System.Drawing.Point(136, 16);
			this.textBox1.Name = "textBox1";
			this.textBox1.Size = new System.Drawing.Size(136, 21);
			this.textBox1.TabIndex = 0;
			this.textBox1.Text = "textBox1";
			// 
			// tabPage4
			// 
			this.tabPage4.Controls.Add(this.groupBox2);
			this.tabPage4.Controls.Add(this.textBox2);
			this.tabPage4.Controls.Add(this.button2);
			this.tabPage4.Controls.Add(this.label2);
			this.tabPage4.Location = new System.Drawing.Point(4, 21);
			this.tabPage4.Name = "tabPage4";
			this.tabPage4.Size = new System.Drawing.Size(416, 303);
			this.tabPage4.TabIndex = 3;
			this.tabPage4.Text = "按编号查图书";
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.dataGrid4);
			this.groupBox2.Location = new System.Drawing.Point(8, 48);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(392, 216);
			this.groupBox2.TabIndex = 4;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "groupBox2";
			// 
			// dataGrid4
			// 
			this.dataGrid4.DataMember = "";
			this.dataGrid4.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid4.Location = new System.Drawing.Point(24, 32);
			this.dataGrid4.Name = "dataGrid4";
			this.dataGrid4.Size = new System.Drawing.Size(336, 136);
			this.dataGrid4.TabIndex = 3;
			// 
			// textBox2
			// 
			this.textBox2.Location = new System.Drawing.Point(152, 16);
			this.textBox2.Name = "textBox2";
			this.textBox2.TabIndex = 2;
			this.textBox2.Text = "textBox2";
			// 
			// button2
			// 
			this.button2.Location = new System.Drawing.Point(296, 16);
			this.button2.Name = "button2";
			this.button2.TabIndex = 1;
			this.button2.Text = "查询";
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// label2
			// 
			this.label2.Location = new System.Drawing.Point(40, 16);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(80, 23);
			this.label2.TabIndex = 0;
			this.label2.Text = "图书编号：";
			// 
			// tabPage5
			// 
			this.tabPage5.Controls.Add(this.groupBox3);
			this.tabPage5.Controls.Add(this.button3);
			this.tabPage5.Controls.Add(this.textBox3);
			this.tabPage5.Controls.Add(this.label3);
			this.tabPage5.Location = new System.Drawing.Point(4, 21);
			this.tabPage5.Name = "tabPage5";
			this.tabPage5.Size = new System.Drawing.Size(416, 303);
			this.tabPage5.TabIndex = 4;
			this.tabPage5.Text = "按编号查借书信息";
			// 
			// groupBox3
			// 
			this.groupBox3.Controls.Add(this.dataGrid5);
			this.groupBox3.Location = new System.Drawing.Point(16, 64);
			this.groupBox3.Name = "groupBox3";
			this.groupBox3.Size = new System.Drawing.Size(384, 200);
			this.groupBox3.TabIndex = 4;
			this.groupBox3.TabStop = false;
			this.groupBox3.Text = "groupBox3";
			// 
			// dataGrid5
			// 
			this.dataGrid5.DataMember = "";
			this.dataGrid5.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid5.Location = new System.Drawing.Point(24, 24);
			this.dataGrid5.Name = "dataGrid5";
			this.dataGrid5.Size = new System.Drawing.Size(336, 120);
			this.dataGrid5.TabIndex = 3;
			this.dataGrid5.Navigate += new System.Windows.Forms.NavigateEventHandler(this.dataGrid5_Navigate);
			// 
			// button3
			// 
			this.button3.Location = new System.Drawing.Point(296, 24);
			this.button3.Name = "button3";
			this.button3.TabIndex = 2;
			this.button3.Text = "查询";
			this.button3.Click += new System.EventHandler(this.button3_Click);
			// 
			// textBox3
			// 
			this.textBox3.Location = new System.Drawing.Point(160, 24);
			this.textBox3.Name = "textBox3";
			this.textBox3.TabIndex = 1;
			this.textBox3.Text = "textBox3";
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(56, 24);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(72, 23);
			this.label3.TabIndex = 0;
			this.label3.Text = "读者编号：";
			// 
			// ChaXunF
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(440, 349);
			this.Controls.Add(this.tabControl1);
			this.Name = "ChaXunF";
			this.Text = "ChaXunF";
			this.tabControl1.ResumeLayout(false);
			this.tabPage1.ResumeLayout(false);
			this.groupBox4.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.tabPage2.ResumeLayout(false);
			this.groupBox5.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
			this.tabPage3.ResumeLayout(false);
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid3)).EndInit();
			this.tabPage4.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid4)).EndInit();
			this.tabPage5.ResumeLayout(false);
			this.groupBox3.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid5)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void dataGrid5_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
		{
		
		}

		private void button4_Click(object sender, System.EventArgs e)
		{
			 string sql="select * from Reader";
			
			util.dataGridP(dataGrid1,sql,"Reader");

		}

		private void dataGrid1_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
		{
		
		}

		private void button5_Click(object sender, System.EventArgs e)
		{
			string sql="select * from Book";
			util.dataGridP(dataGrid2,sql,"Book");
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			//Reader read=new Reader();
			
			string dzbh=textBox1.Text;
            //read.setRId(dzbh);
			string sql="select * from Reader where Rid='"+dzbh+"'";
			if(util.isExist(sql))
			{
				 util.dataGridP(dataGrid3,sql,"Reader1");
			}
			else{
		     MessageBox.Show("没有该读者编号！！");
			}
		}

		private void button2_Click(object sender, System.EventArgs e)
		{
			//Book book=new Book();
			
			string tsbh=textBox2.Text;
			//book.setBId(tsbh);
			string sql="select * from Book where Bid='"+tsbh+"'";
			if(util.isExist(sql))
			{
				 util.dataGridP(dataGrid4,sql,"Book1");
			}
			else
			{
				 MessageBox.Show("没有该图书编号！！");
			}
		}

		private void button3_Click(object sender, System.EventArgs e)
		{
			string jyxx=textBox3.Text;
			//GetBInfo getb=new GetBInfo();
			//getb.setRid(jyxx);
			string sql="select * from GetBInfo where Rid='"+jyxx+"'";
			if(util.isExist(sql))
			{
				 util.dataGridP(dataGrid5,sql,"GetBInfo1");
			}
			else{
			 MessageBox.Show("该读者没有借阅信息！！");
			}
		}
	}
}