query.cs

Csharp SQL图书馆管理系统 Csharp SQL图书馆管理系统源码

			this.MinimizeBox = false;
			this.Name = "Query";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "综合查询";
			this.Load += new System.EventHandler(this.Query_Load);
			((System.ComponentModel.ISupportInitialize)(this.dg)).EndInit();
			this.groupBox1.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		public void ErrorHandle(System.Exception E)
		{
			MessageBox.Show(E.ToString());
		}		


		
		
		

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

		private void comboDataTable_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			string strTable=this.comboDataTable.SelectedItem.ToString();
			SetcomboDataItem(strTable);	
		}
			
			
	
		
		private void SetcomboDataItem(string strTable)
		{
				switch(strTable)
				{
					case"读者信息"://当列表框的"读者信息"项被选中
						this.comboDataItem.Items.Clear();
						this.comboDataItem.Items.Add("借书证号");
						this.comboDataItem.Items.Add("读者姓名");
						this.comboDataItem.Items.Add("读者密码");
						this.comboDataItem.Items.Add("读者电话号码");
						this.comboDataItem.Items.Add("读者邮箱");
						this.comboDataItem.Items.Add("读者已借书数目");
						break;
				
					case"图书信息"://当列表框的"图书信息"项被选中
						this.comboDataItem.Items.Clear();
						this.comboDataItem.Items.Add("图书编号");
						this.comboDataItem.Items.Add("书名");
						this.comboDataItem.Items.Add("作者");
						this.comboDataItem.Items.Add("出版社");
						this.comboDataItem.Items.Add("出版日期");
						this.comboDataItem.Items.Add("单价");
						this.comboDataItem.Items.Add("类型");
						this.comboDataItem.Items.Add("馆藏总数");
						this.comboDataItem.Items.Add("剩余数目");
						break;
				
					case"出版社信息"://当列表框的"出版社信息"项被选中
						this.comboDataItem.Items.Clear();
						this.comboDataItem.Items.Add("出版社名");
						this.comboDataItem.Items.Add("地址");
						this.comboDataItem.Items.Add("电话号码");
						this.comboDataItem.Items.Add("邮箱");
						break;
				
					case"借阅信息"://当列表框的"借阅信息"项被选中
						this.comboDataItem.Items.Clear();
						this.comboDataItem.Items.Add("借书证号");
						this.comboDataItem.Items.Add("图书编号");
						this.comboDataItem.Items.Add("借书日期");
						this.comboDataItem.Items.Add("应还书日期");
						this.comboDataItem.Items.Add("实际还书日期");
						break;
				}
		}
		
		
		private void btnClear_Click(object sender, System.EventArgs e)
		{
			this.comboDataTable.Text="";
			this.comboDataItem.Text="";
			this.comboCondition.Text="";
			this.textValue.Text="";
		}

		private string SetSelectTable(string strTable)
		{
			string SqlString="";
			switch(strTable)
			{
				case"图书信息"://当列表框的"图书信息"项被选中
					SqlString="SELECT BookID AS 图书编号, BookName AS 书名, BookWriter AS 作者, ";
					SqlString+="BookPublish AS 出版社, BookPublishDate AS 出版日期, BookPrice AS 单价, ";
					SqlString+="  BookSort AS 类型, BookAmount AS 馆藏总数, BookRemain AS 剩余数目";
					SqlString+="  FROM dbo.Book";
					break;
					
				case"读者信息"://当列表框的"读者信息"项被选中
					SqlString="SELECT ReaderID AS 借书证号, ReaderName AS 读者姓名, ReaderPassword AS 读者密码, ";
					SqlString+="  ReaderPhoneNo AS 读者电话号码, ReaderEmail AS 读者邮箱, ";
					SqlString+="  ReaderBorrowedbooks AS 读者已借书数目";
					SqlString+=" FROM dbo.Reader";
					break;
				case"出版社信息"://当列表框的"出版社信息"项被选中
					SqlString="SELECT PublishName AS 出版社名, PublishAddress AS 地址, ";
					SqlString+="  PublishPhoneNo AS 电话号码, PbulishEmail AS 邮箱 ";
					SqlString+=" FROM dbo.PublishCompany";
					break;
				case"借阅信息"://当列表框的"借阅信息"项被选中
					SqlString="SELECT ReaderID AS 借书证号, BookID AS 图书编号, BorrowDate AS 借书日期, ";
					SqlString+="  ReturnDate AS 应还书日期, FactReturnDate AS 实际还书日期";
					SqlString+="  FROM dbo.BorrowBook";
					break;
			}
			return SqlString;
		}
		private string SetSelectData(string dataItem)
		{
			string Item="";
			switch(dataItem)
			{
				case"借书证号"://当列表框的"借书证号"项被选中
					Item=" ReaderID";
					break;
				case"读者姓名"://当列表框的"读者姓名"项被选中
					Item=" ReaderName ";
					break;
				case"读者密码"://当列表框的"读者密码"项被选中
					Item=" ReaderPassword";
					break;
				case"读者邮箱"://当列表框的"读者邮箱"项被选中
					Item=" ReaderEmail";
					break;
				case"读者已借书数目"://当列表框的"读者已借书目"项被选中
					Item=" ReaderBorrowedbooks";
					break;
				case"读者电话号码": ////当列表框的"读者电话号码"项被选中
					Item=" ReaderPhoneNo";
					break;
				case"图书编号":
					Item=" BookID";
					break;
				case"书名":
					Item=" BookName";
					break;
				case"作者":
					Item=" BookWriter";
					break;
				case"出版社":
					Item=" BookPublish";
					break;
				case"出版日期":
					Item=" BookPublishDate";
					break;
				case"单价":
					Item=" BookPrice";
					break;
				case"类型":
					Item=" BookSort";
					break;
				case"馆藏总数":
					Item=" BookAmount";
					break;
				case"剩余数目":
					Item=" BookRemain";
					break;
				case"出版社名":
					Item=" PublishName";
					break;
				case"地址":
					Item=" PublishAddress";
					break;
				case"电话号码":
					Item=" PublishPhoneNo";
					break;
				case"邮箱":
					Item=" PbulishEmail";
					break;
				case"借书日期":
					Item=" BorrowDate";
					break;
				case"应还书日期":
					Item=" ReturnDate";
					break;
				case"实际还书日期":
					Item=" FactReturnDate";
					break;
			}
			return Item;
		}
		private string SetTableName(string tableName)
		{
			string TableName="";
			switch(tableName)
			{
				case"图书信息":
					TableName="Book";
					break;
				case"读者信息":
					TableName="Reader";
					break;
				case"出版社信息":
					TableName="PublishCompany";
					break;
				case"借阅信息":
					TableName="BorrowBook";
					break;
			
			}
			return TableName;
		}
		private void btnQuery_Click(object sender, System.EventArgs e)
		{
			string conValue = this.textValue.Text;//指定的条件值
			string strTable=this.comboDataTable.Text;
			SqlString=SetSelectTable(strTable);
			if ((this.comboCondition.Text == "Like") && (this.textValue.Text != ""))
				conValue = "%"+this.textValue.Text+"%";
			string dataItem=SetSelectData(this.comboDataItem.Text);
			if ((this.comboDataItem.Text != "") && (this.comboCondition.Text != "") && (this.textValue.Text != ""))
				SqlString=SqlString+" where "+dataItem+" "+this.comboCondition.Text+" '"+conValue+"'";
				DataSet ds=new DataSet();
			SqlDataAdapter da=new SqlDataAdapter(SqlString,conn);
			try
			{
				da.Fill(ds,"Query");
				dg.DataSource=ds.Tables["Query"].DefaultView;
				
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
		}

		private void Query_Load(object sender, System.EventArgs e)
		{
			
		}

		
	}
}