form_publisher.cs

中小型书店图书购书系统

			this.butDelete.Location = new System.Drawing.Point(168, 256);
			this.butDelete.Name = "butDelete";
			this.butDelete.Size = new System.Drawing.Size(56, 24);
			this.butDelete.TabIndex = 48;
			this.butDelete.Text = "删除";
			this.butDelete.Click += new System.EventHandler(this.butDelete_Click);
			// 
			// butAdd
			// 
			this.butAdd.BackColor = System.Drawing.Color.Transparent;
			this.butAdd.Location = new System.Drawing.Point(112, 256);
			this.butAdd.Name = "butAdd";
			this.butAdd.Size = new System.Drawing.Size(56, 24);
			this.butAdd.TabIndex = 47;
			this.butAdd.Text = "添加";
			this.butAdd.Click += new System.EventHandler(this.butAdd_Click);
			// 
			// butAlter
			// 
			this.butAlter.BackColor = System.Drawing.Color.Transparent;
			this.butAlter.Location = new System.Drawing.Point(56, 256);
			this.butAlter.Name = "butAlter";
			this.butAlter.Size = new System.Drawing.Size(56, 24);
			this.butAlter.TabIndex = 46;
			this.butAlter.Text = "修改";
			this.butAlter.Click += new System.EventHandler(this.butAlter_Click);
			// 
			// Form_Publisher
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
			this.ClientSize = new System.Drawing.Size(472, 382);
			this.ControlBox = false;
			this.Controls.Add(this.butDelete);
			this.Controls.Add(this.butAdd);
			this.Controls.Add(this.butAlter);
			this.Controls.Add(this.comboBox2);
			this.Controls.Add(this.textForSearch);
			this.Controls.Add(this.presstelephone);
			this.Controls.Add(this.pressaddress);
			this.Controls.Add(this.presslinkman);
			this.Controls.Add(this.pressname);
			this.Controls.Add(this.butSearch);
			this.Controls.Add(this.comboBox1);
			this.Controls.Add(this.label5);
			this.Controls.Add(this.butShowAll);
			this.Controls.Add(this.butLast);
			this.Controls.Add(this.butFirst);
			this.Controls.Add(this.butNext);
			this.Controls.Add(this.butPrev);
			this.Controls.Add(this.butBookManagement);
			this.Controls.Add(this.label4);
			this.Controls.Add(this.label3);
			this.Controls.Add(this.label2);
			this.Controls.Add(this.label1);
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
			this.Name = "Form_Publisher";
			this.StartPosition = System.Windows.Forms.FormStartPosition.Manual;
			this.Text = "Form_Publisher";
			this.Load += new System.EventHandler(this.Form_Publisher_Load);
			this.ResumeLayout(false);

		}
		#endregion

		private void butBookManagement_Click(object sender, System.EventArgs e)
		{
			if(Pressname!="")
			{
				Form_Publisher_BookManagement child=new Form_Publisher_BookManagement();
				child.ShowDialog();
			}
			else
			{
				MessageBox.Show("还没有选择出版社!","提示");
			}
		}

		SQL sql;
		public static string Pressname;
		private void Form_Publisher_Load(object sender, System.EventArgs e)
		{
			sql=new SQL("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=图书管理系统数据库.mdb");
			sql.ExecuteSQL("select * from 出版社信息表 order by pressname");
			show();
		}

		public void show()
		{
			if(sql.rows.GetLength(0)!=0)
			{
				pressname.Text=sql.rows[sql.getPos(),0].ToString();
				presslinkman.Text=sql.rows[sql.getPos(),1].ToString();
				pressaddress.Text=sql.rows[sql.getPos(),2].ToString();
				presstelephone.Text=sql.rows[sql.getPos(),3].ToString();
			}
			else
			{
				pressname.Text="";
				presslinkman.Text="";
				pressaddress.Text="";
				presstelephone.Text="";
				MessageBox.Show("无符合查询条件的结果!","提示");
			}
			Pressname=pressname.Text;
		}

		private void butPrev_Click(object sender, System.EventArgs e)
		{
			sql.pointToPrev();
			show();
		}

		private void butNext_Click(object sender, System.EventArgs e)
		{
			sql.pointToNext();
			show();
		}

		private void butFirst_Click(object sender, System.EventArgs e)
		{
			sql.pointToFirst();
			show();
		}

		private void butLast_Click(object sender, System.EventArgs e)
		{
			sql.pointToLast();
			show();
		}

		string oldpressname;

		private void butAlter_Click(object sender, System.EventArgs e)
		{
			if(butAlter.Text=="修改")
			{
				butAlter.Text="更新";
				oldpressname=pressname.Text;
				pressname.ReadOnly =false;
				presslinkman.ReadOnly  =false;
				pressaddress.ReadOnly  =false;
				presstelephone.ReadOnly  =false;

				butAdd.Enabled=false;
				butDelete.Enabled=false;
				butFirst.Enabled=false;
				butPrev.Enabled=false;
				butNext.Enabled=false;
				butLast.Enabled=false;
				butShowAll.Enabled=false;
				butSearch.Enabled=false;
				butBookManagement.Enabled=false;
			}
			else
			{
				if(sql.ExecuteSQL("update 出版社信息表 set pressname='"+pressname.Text+"',presslinkman='"+presslinkman.Text+"',pressaddress='"+pressaddress.Text+"',presstelephone='"+presstelephone.Text+"' where pressname='"+oldpressname+"'")
					==false)
				{
					show();
				}
				else
				{
					Pressname=pressname.Text;
					sql.ExecuteSQL("update 出版社图书信息表 set pressname='"+pressname.Text+"' where pressname='"+oldpressname+"'");
				}
				pressname.ReadOnly  =true;
				presslinkman.ReadOnly  =true;
				pressaddress.ReadOnly  =true;
				presstelephone.ReadOnly =true;
				butAlter.Text="修改";

				butAdd.Enabled=true;
				butDelete.Enabled=true;
				butFirst.Enabled=true;
				butPrev.Enabled=true;
				butNext.Enabled=true;
				butLast.Enabled=true;
				butShowAll.Enabled=true;
				butSearch.Enabled=true;
				butBookManagement.Enabled=true;
			}
		}

		private void butAdd_Click(object sender, System.EventArgs e)
		{
			if(butAdd.Text=="添加")
			{
				butAdd.Text="提交";
				pressname.Text="";
				presslinkman.Text="";
				pressaddress.Text="";
				presstelephone.Text="";
				pressname.ReadOnly =false;
				presslinkman.ReadOnly  =false;
				pressaddress.ReadOnly  =false;
				presstelephone.ReadOnly  =false;

				butAlter.Enabled=false;
				butDelete.Enabled=false;
				butFirst.Enabled=false;
				butPrev.Enabled=false;
				butNext.Enabled=false;
				butLast.Enabled=false;
				butShowAll.Enabled=false;
				butSearch.Enabled=false;
				butBookManagement.Enabled=false;
			}
			else
			{
				if(sql.ExecuteSQL("insert into 出版社信息表 values('"+pressname.Text+"','"+presslinkman.Text+"','"+pressaddress.Text+"','"+presstelephone.Text+"')")
					==false)
				{
					show();
				}
				else
				{
					Pressname=pressname.Text;
				}
				pressname.ReadOnly  =true;
				presslinkman.ReadOnly  =true;
				pressaddress.ReadOnly  =true;
				presstelephone.ReadOnly =true;
				butAdd.Text="添加";

				butAlter.Enabled=true;
				butDelete.Enabled=true;
				butFirst.Enabled=true;
				butPrev.Enabled=true;
				butNext.Enabled=true;
				butLast.Enabled=true;
				butShowAll.Enabled=true;
				butSearch.Enabled=true;
				butBookManagement.Enabled=true;
			}
		}

		private void butDelete_Click(object sender, System.EventArgs e)
		{
			sql.ExecuteSQL("delete from 出版社信息表 where pressname='"+pressname.Text+"'");
			sql.ExecuteSQL("delete from 出版社图书信息表 where pressname='"+pressname.Text+"'");
			sql.pointToFirst();
			show();
		}

		private void butSearch_Click(object sender, System.EventArgs e)
		{
			if(comboBox1.Text=="出版社名称")
			{
				if(comboBox2.Text=="精确")
				{
					sql.ExecuteSQL("select * from 出版社信息表 where pressname='"+textForSearch.Text+"'");
					show();
				}
				else
				{
					sql.ExecuteSQL("select * from 出版社信息表 where pressname like '%"+textForSearch.Text+"%'");
					show();
				}
			}
			else
			{
				if(comboBox2.Text=="精确")
				{
					sql.ExecuteSQL("select * from 出版社信息表 where presstelephone='"+textForSearch.Text+"'");
					show();
				}
				else
				{
					sql.ExecuteSQL("select * from 出版社信息表 where presstelephone like '%"+textForSearch.Text+"%'");
					show();
				}
			}
		}

		private void butShowAll_Click(object sender, System.EventArgs e)
		{
			sql.ExecuteSQL("select * from 出版社信息表 order by pressname");
			show();
		}

	}
}