frmmain_gj.cs

因本人正在学习中

			this.txt_hs.Text = "";
			// 
			// toolBarButton10
			// 
			this.toolBarButton10.ImageIndex = 0;
			this.toolBarButton10.Text = "查询";
			this.toolBarButton10.ToolTipText = "查询";
			// 
			// frmMain_gj
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(768, 477);
			this.Controls.Add(this.tabControl1);
			this.MaximizeBox = false;
			this.Name = "frmMain_gj";
			this.Text = "图书管理系统（管理员）";
			this.Load += new System.EventHandler(this.frmMain_gj_Load);
			this.tabp_sj.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
			this.groupBox2.ResumeLayout(false);
			this.tabControl1.ResumeLayout(false);
			this.tabp_dz.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid3)).EndInit();
			this.groupBox3.ResumeLayout(false);
			this.tabPage1.ResumeLayout(false);
			this.groupBox5.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.datag_js)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.tab_hs.ResumeLayout(false);
			this.groupBox7.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataG_hs)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void toolBar2_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			if(e.Button.Text=="新增")
			{

				insert_book newfrm=new insert_book();
				newfrm.ShowDialog();
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				SqlDataAdapter da=new SqlDataAdapter("select * from sjxxb",conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"sjxxb");
				this.dataGrid2.SetDataBinding(ds,"sjxxb");		
			}
			if(e.Button.Text=="修改")
			{
				
				updata_book f=new updata_book();
				
				f.ShowDialog();
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				SqlDataAdapter da=new SqlDataAdapter("select * from sjxxb",conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"sjxxb");
				this.dataGrid2.SetDataBinding(ds,"sjxxb");
			}
			if(e.Button.Text=="删除")
			{
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				this.txt2.Focus();
				string	delCmd="delete from sjxxb where sjbh like'"+this.txt2.Text+"'";
				MessageBox.Show (delCmd);
				SqlCommand  comm=new SqlCommand (delCmd,conn);
				
				try
				{
					conn.Open();
					DialogResult dr=MessageBox.Show ("确定要删除记录吗？","确认",MessageBoxButtons .YesNo );
					if(dr==DialogResult.Yes)
					{
						comm.ExecuteNonQuery ();
						MessageBox .Show ("删除成功！");
					}
				}
				catch(SqlException ex)
				{
					MessageBox.Show(ex.Message );
				}
				finally
				{
					conn.Close();
				}
			}
			
			if(e.Button.Text=="查询")
			{
				if(txt2.Text.Trim()=="")//检查非空字段
				{
					MessageBox.Show("查询编号不能为空","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
					return;
				}	
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				string  sql="select * from sjxxb where sjbh='"+this.txt2.Text+"'"; 
				SqlDataAdapter da=new SqlDataAdapter(sql,conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"sjxxb");
				this.dataGrid2.SetDataBinding(ds,"sjxxb");
							
			}

			if (e.Button.Text == "刷新")
			{
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				SqlDataAdapter da=new SqlDataAdapter("select * from sjxxb",conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"sjxxb");
				this.dataGrid2.SetDataBinding(ds,"sjxxb");

			}

			if(e.Button.Text=="退出")
			{
				
				this.Close();
				
			}
		}
		
		private void toolBar3_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			if(e.Button.Text=="新增")
			{
				insert_man newfrm=new insert_man();
				newfrm.ShowDialog();
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				SqlDataAdapter da=new SqlDataAdapter("select * from dzxxb",conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"dzxxb");
				this.dataGrid3.SetDataBinding(ds,"dzxxb");
				
			}
			if(e.Button.Text=="修改")
			{
				updata_man f=new updata_man();
				f.ShowDialog();
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				SqlDataAdapter da=new SqlDataAdapter("select * from dzxxb",conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"dzxxb");
				this.dataGrid3.SetDataBinding(ds,"dzxxb");
			}

			if(e.Button.Text=="删除")
			{
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				this.txt12.Focus();
				string	delCmd="delete from dzxxb where dzbh ='"+this.txt12.Text +"'";
				MessageBox.Show (delCmd);
				SqlCommand  comm=new SqlCommand (delCmd,conn);		
			
				try
				{
					conn.Open();
					DialogResult dr=MessageBox.Show ("确定要删除记录吗？","确认",MessageBoxButtons .YesNo );
					if(dr==DialogResult.Yes)
					{
						comm.ExecuteNonQuery ();
						MessageBox .Show ("删除成功！");
					}
				}
				catch(SqlException ex)
				{
					MessageBox.Show(ex.Message );
				}
				finally
				{
					conn.Close();
				}
				
				SqlDataAdapter da=new SqlDataAdapter("select * from dzxxb",conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"dzxxb");
				this.dataGrid3.SetDataBinding(ds,"dzxxb");
			}
			if(e.Button.Text=="查询")
			{
				if(txt12.Text.Trim()=="")//检查非空字段
				{
					MessageBox.Show("查询编号不能为空","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
					return;
				}		
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				string  sql="select * from dzxxb where dzbh='"+this.txt12.Text+"'"; 
				SqlDataAdapter da=new SqlDataAdapter(sql,conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"dzxxb");
				this.dataGrid3.SetDataBinding(ds,"dzxxb");
		
			}
			


			if (e.Button.Text == "刷新")
			{
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				SqlDataAdapter da=new SqlDataAdapter("select * from dzxxb",conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"dzxxb");
				this.dataGrid3.SetDataBinding(ds,"dzxxb");
			}

			if(e.Button.Text=="退出")
			{
				this.Close();
			}
		}
		private void databinding()
		{
			string connstr=Form1.connstr;
			SqlConnection conn=new SqlConnection(connstr);
			SqlCommand comm=new SqlCommand("",conn);
			
		
		}
		private void frmMain_gj_Load(object sender, System.EventArgs e)
		{
		databinding();

			StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
			string sn=sr.ReadLine();	
			SqlConnection conn=new SqlConnection(sn);	
			string  sql="select * from jsxxb "; 
			SqlDataAdapter da2=new SqlDataAdapter(sql,conn);
			dx=new DataSet();
			da2.Fill(dx,"jsxxb");
			this.datag_js.DataSource=dx.Tables["jsxxb"].DefaultView;
			SetModifyMode();
		}

		private void toolBar5_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
		
		}

		private void toolBar4_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			if(e.Button.Text=="新增")
			{

				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				string  sql="select * from sjxxb where sjbh='"+this.txt2.Text+"'"; 
				SqlDataAdapter da=new SqlDataAdapter(sql,conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"sjxxb");
				this.dataGrid2.SetDataBinding(ds,"sjxxb");
							
							
			}
			if(e.Button.Text=="修改")
			{
				
				updata_book f=new updata_book();
				
				f.Show();
			}
			if(e.Button.Text=="删除")
			{
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				string	delCmd="delete from sjxxb where sjbh like'"+this.txt2.Text +"'";
				MessageBox.Show (delCmd);
				SqlCommand  comm=new SqlCommand (delCmd,conn);
				try
				{
					conn.Open();
					DialogResult dr=MessageBox.Show ("确定要删除记录吗？","确认",MessageBoxButtons .YesNo );
					if(dr==DialogResult.Yes)
					{
						comm.ExecuteNonQuery ();
						MessageBox .Show ("删除成功！");
					}
				}
				catch(SqlException ex)
				{
					MessageBox.Show(ex.Message );
				}
				finally
				{
					conn.Close();
				}
			}
			
			if(e.Button.Text=="查询")
			{
				if(txt2.Text.Trim()=="")//检查非空字段
				{
					MessageBox.Show("查询编号不能为空","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
					return;
				}	
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				string  sql="select * from sjxxb where sjbh='"+this.txt2.Text+"'"; 
				SqlDataAdapter da=new SqlDataAdapter(sql,conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"sjxxb");
				this.dataGrid2.SetDataBinding(ds,"sjxxb");
							
			}

			if (e.Button.Text == "刷新")
			{
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				SqlDataAdapter da=new SqlDataAdapter("select * from sjxxb",conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"sjxxb");
				this.dataGrid2.SetDataBinding(ds,"sjxxb");

			}

			if(e.Button.Text=="退出")
			{
				
				this.Close();
				
			}
		}

		private void toolBar4_ButtonClick_1(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			if(e.Button.Text=="新增")
			{
				insert_jsbook f=new insert_jsbook();
				f.ShowDialog();
				StreamReader sr=new StreamReader("ts.ini",System.Text.Encoding.Default);
				string sn=sr.ReadLine();	
				SqlConnection conn=new SqlConnection(sn);	
				SqlDataAdapter da=new SqlDataAdapter("select * from jsxxb",conn);