searchform.cs

《数据库原理及应用》-刘玉宝主编-源代码

			this.cmbMemberNa.Location = new System.Drawing.Point(304, 40);
			this.cmbMemberNa.Name = "cmbMemberNa";
			this.cmbMemberNa.Size = new System.Drawing.Size(88, 20);
			this.cmbMemberNa.TabIndex = 3;
			this.cmbMemberNa.Tag = "0";
			this.cmbMemberNa.SelectionChangeCommitted += new System.EventHandler(this.cmbMemberNa_SelectionChangeCommitted);
			// 
			// gbMember
			// 
			this.gbMember.Controls.Add(this.cmbMemberNa);
			this.gbMember.Controls.Add(this.cmbCollegeNa);
			this.gbMember.Controls.Add(this.cbCollegeNa);
			this.gbMember.Controls.Add(this.cbMemberNa);
			this.gbMember.Location = new System.Drawing.Point(248, 224);
			this.gbMember.Name = "gbMember";
			this.gbMember.Size = new System.Drawing.Size(408, 96);
			this.gbMember.TabIndex = 5;
			this.gbMember.TabStop = false;
			this.gbMember.Tag = "1";
			this.gbMember.Text = " 参研人 ";
			// 
			// cbCollegeNa
			// 
			this.cbCollegeNa.Location = new System.Drawing.Point(16, 40);
			this.cbCollegeNa.Name = "cbCollegeNa";
			this.cbCollegeNa.Size = new System.Drawing.Size(64, 24);
			this.cbCollegeNa.TabIndex = 0;
			this.cbCollegeNa.Text = "院系：";
			this.cbCollegeNa.CheckedChanged += new System.EventHandler(this.cbCollegeNa_CheckedChanged);
			// 
			// cbMemberNa
			// 
			this.cbMemberNa.Enabled = false;
			this.cbMemberNa.Location = new System.Drawing.Point(240, 40);
			this.cbMemberNa.Name = "cbMemberNa";
			this.cbMemberNa.Size = new System.Drawing.Size(64, 24);
			this.cbMemberNa.TabIndex = 2;
			this.cbMemberNa.Tag = "false";
			this.cbMemberNa.Text = "姓名：";
			this.cbMemberNa.CheckedChanged += new System.EventHandler(this.cbMemberNa_CheckedChanged);
			// 
			// gbMemberMain
			// 
			this.gbMemberMain.Controls.Add(this.cmbMemberMain);
			this.gbMemberMain.Controls.Add(this.cmbCollegeMain);
			this.gbMemberMain.Controls.Add(this.cbMemberMain);
			this.gbMemberMain.Controls.Add(this.cbCollegeMain);
			this.gbMemberMain.Location = new System.Drawing.Point(248, 120);
			this.gbMemberMain.Name = "gbMemberMain";
			this.gbMemberMain.Size = new System.Drawing.Size(408, 96);
			this.gbMemberMain.TabIndex = 4;
			this.gbMemberMain.TabStop = false;
			this.gbMemberMain.Tag = "0";
			this.gbMemberMain.Text = " 负责人 ";
			// 
			// cmbMemberMain
			// 
			this.cmbMemberMain.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.cmbMemberMain.Enabled = false;
			this.cmbMemberMain.Location = new System.Drawing.Point(304, 40);
			this.cmbMemberMain.Name = "cmbMemberMain";
			this.cmbMemberMain.Size = new System.Drawing.Size(88, 20);
			this.cmbMemberMain.TabIndex = 3;
			this.cmbMemberMain.Tag = "0";
			this.cmbMemberMain.SelectionChangeCommitted += new System.EventHandler(this.cmbMemberNa_SelectionChangeCommitted);
			// 
			// cmbCollegeMain
			// 
			this.cmbCollegeMain.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.cmbCollegeMain.Enabled = false;
			this.cmbCollegeMain.Location = new System.Drawing.Point(80, 40);
			this.cmbCollegeMain.Name = "cmbCollegeMain";
			this.cmbCollegeMain.Size = new System.Drawing.Size(144, 20);
			this.cmbCollegeMain.TabIndex = 1;
			this.cmbCollegeMain.Tag = "0";
			this.cmbCollegeMain.SelectionChangeCommitted += new System.EventHandler(this.cmbCollegeNa_SelectionChangeCommitted);
			// 
			// cbMemberMain
			// 
			this.cbMemberMain.Enabled = false;
			this.cbMemberMain.Location = new System.Drawing.Point(240, 40);
			this.cbMemberMain.Name = "cbMemberMain";
			this.cbMemberMain.Size = new System.Drawing.Size(64, 24);
			this.cbMemberMain.TabIndex = 2;
			this.cbMemberMain.Tag = "false";
			this.cbMemberMain.Text = "姓名：";
			this.cbMemberMain.CheckedChanged += new System.EventHandler(this.cbMemberMain_CheckedChanged);
			// 
			// cbCollegeMain
			// 
			this.cbCollegeMain.Location = new System.Drawing.Point(16, 40);
			this.cbCollegeMain.Name = "cbCollegeMain";
			this.cbCollegeMain.Size = new System.Drawing.Size(64, 24);
			this.cbCollegeMain.TabIndex = 0;
			this.cbCollegeMain.Text = "院系：";
			this.cbCollegeMain.CheckedChanged += new System.EventHandler(this.cbCollegeMain_CheckedChanged);
			// 
			// cbCollege
			// 
			this.cbCollege.Location = new System.Drawing.Point(424, 24);
			this.cbCollege.Name = "cbCollege";
			this.cbCollege.Size = new System.Drawing.Size(88, 24);
			this.cbCollege.TabIndex = 2;
			this.cbCollege.Text = "所属院系：";
			this.cbCollege.CheckedChanged += new System.EventHandler(this.cbCollege_CheckedChanged);
			// 
			// btnQuery
			// 
			this.btnQuery.Cursor = System.Windows.Forms.Cursors.Hand;
			this.btnQuery.Location = new System.Drawing.Point(352, 16);
			this.btnQuery.Name = "btnQuery";
			this.btnQuery.Size = new System.Drawing.Size(144, 32);
			this.btnQuery.TabIndex = 0;
			this.btnQuery.Text = "查    询";
			this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);
			// 
			// btnBack
			// 
			this.btnBack.Cursor = System.Windows.Forms.Cursors.Hand;
			this.btnBack.Location = new System.Drawing.Point(528, 16);
			this.btnBack.Name = "btnBack";
			this.btnBack.Size = new System.Drawing.Size(144, 32);
			this.btnBack.TabIndex = 1;
			this.btnBack.Text = "返    回";
			this.btnBack.Click += new System.EventHandler(this.btnBack_Click);
			// 
			// rbQueryAll
			// 
			this.rbQueryAll.Location = new System.Drawing.Point(32, 16);
			this.rbQueryAll.Name = "rbQueryAll";
			this.rbQueryAll.TabIndex = 3;
			this.rbQueryAll.Text = "查找所有课题";
			// 
			// rbQueryWhat
			// 
			this.rbQueryWhat.Checked = true;
			this.rbQueryWhat.Location = new System.Drawing.Point(152, 16);
			this.rbQueryWhat.Name = "rbQueryWhat";
			this.rbQueryWhat.TabIndex = 3;
			this.rbQueryWhat.TabStop = true;
			this.rbQueryWhat.Text = "指定查询条件";
			this.rbQueryWhat.CheckedChanged += new System.EventHandler(this.rbQueryWhat_CheckedChanged);
			// 
			// gbCondition
			// 
			this.gbCondition.Controls.Add(this.tbEnd);
			this.gbCondition.Controls.Add(this.tbPlan);
			this.gbCondition.Controls.Add(this.tbStart);
			this.gbCondition.Controls.Add(this.lbMember);
			this.gbCondition.Controls.Add(this.lbMemberMain);
			this.gbCondition.Controls.Add(this.lbCollegeCo);
			this.gbCondition.Controls.Add(this.cbLevel);
			this.gbCondition.Controls.Add(this.cbSort);
			this.gbCondition.Controls.Add(this.cbAlready);
			this.gbCondition.Controls.Add(this.cbTask);
			this.gbCondition.Controls.Add(this.cbPlan);
			this.gbCondition.Controls.Add(this.gbMemberMain);
			this.gbCondition.Controls.Add(this.cbCollege);
			this.gbCondition.Controls.Add(this.cbYear);
			this.gbCondition.Controls.Add(this.cbStandard);
			this.gbCondition.Controls.Add(this.cbSurplus);
			this.gbCondition.Controls.Add(this.gbMember);
			this.gbCondition.Controls.Add(this.cmbCollege);
			this.gbCondition.Controls.Add(this.nudSurplus);
			this.gbCondition.Controls.Add(this.nudAlready);
			this.gbCondition.Controls.Add(this.nudStandard);
			this.gbCondition.Controls.Add(this.tbTaskName);
			this.gbCondition.Controls.Add(this.dtpYear);
			this.gbCondition.Controls.Add(this.cmbLevelNa);
			this.gbCondition.Controls.Add(this.cmbSortNa);
			this.gbCondition.Controls.Add(this.cbStart);
			this.gbCondition.Controls.Add(this.cbEnd);
			this.gbCondition.Controls.Add(this.lbSortCo);
			this.gbCondition.Controls.Add(this.lbLevelCo);
			this.gbCondition.Location = new System.Drawing.Point(16, 56);
			this.gbCondition.Name = "gbCondition";
			this.gbCondition.Size = new System.Drawing.Size(672, 336);
			this.gbCondition.TabIndex = 2;
			this.gbCondition.TabStop = false;
			this.gbCondition.Text = " 请指定查询条件 ";
			// 
			// tbEnd
			// 
			this.tbEnd.Enabled = false;
			this.tbEnd.Location = new System.Drawing.Point(104, 192);
			this.tbEnd.Name = "tbEnd";
			this.tbEnd.Size = new System.Drawing.Size(128, 21);
			this.tbEnd.TabIndex = 17;
			this.tbEnd.Text = "";
			// 
			// tbPlan
			// 
			this.tbPlan.Enabled = false;
			this.tbPlan.Location = new System.Drawing.Point(104, 160);
			this.tbPlan.Name = "tbPlan";
			this.tbPlan.Size = new System.Drawing.Size(128, 21);
			this.tbPlan.TabIndex = 15;
			this.tbPlan.Text = "";
			// 
			// tbStart
			// 
			this.tbStart.Enabled = false;
			this.tbStart.Location = new System.Drawing.Point(104, 128);
			this.tbStart.Name = "tbStart";
			this.tbStart.Size = new System.Drawing.Size(128, 21);
			this.tbStart.TabIndex = 13;
			this.tbStart.Text = "";
			// 
			// lbMember
			// 
			this.lbMember.ItemHeight = 12;
			this.lbMember.Location = new System.Drawing.Point(544, 88);
			this.lbMember.Name = "lbMember";
			this.lbMember.Size = new System.Drawing.Size(96, 16);
			this.lbMember.TabIndex = 68;
			this.lbMember.TabStop = false;
			this.lbMember.Visible = false;
			// 
			// lbMemberMain
			// 
			this.lbMemberMain.ItemHeight = 12;
			this.lbMemberMain.Location = new System.Drawing.Point(432, 88);
			this.lbMemberMain.Name = "lbMemberMain";
			this.lbMemberMain.Size = new System.Drawing.Size(96, 16);
			this.lbMemberMain.TabIndex = 67;
			this.lbMemberMain.TabStop = false;
			this.lbMemberMain.Visible = false;
			// 
			// lbCollegeCo
			// 
			this.lbCollegeCo.ItemHeight = 12;
			this.lbCollegeCo.Location = new System.Drawing.Point(248, 88);
			this.lbCollegeCo.Name = "lbCollegeCo";
			this.lbCollegeCo.Size = new System.Drawing.Size(144, 16);
			this.lbCollegeCo.TabIndex = 66;
			this.lbCollegeCo.TabStop = false;
			this.lbCollegeCo.Visible = false;
			// 
			// lbSortCo
			// 
			this.lbSortCo.ItemHeight = 12;
			this.lbSortCo.Location = new System.Drawing.Point(104, 40);
			this.lbSortCo.Name = "lbSortCo";
			this.lbSortCo.Size = new System.Drawing.Size(128, 16);
			this.lbSortCo.TabIndex = 64;
			this.lbSortCo.TabStop = false;
			this.lbSortCo.Visible = false;
			// 
			// lbLevelCo
			// 
			this.lbLevelCo.ItemHeight = 12;
			this.lbLevelCo.Location = new System.Drawing.Point(104, 72);
			this.lbLevelCo.Name = "lbLevelCo";
			this.lbLevelCo.Size = new System.Drawing.Size(128, 16);
			this.lbLevelCo.TabIndex = 65;
			this.lbLevelCo.TabStop = false;
			this.lbLevelCo.Visible = false;
			// 
			// SearchForm
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(704, 405);
			this.Controls.Add(this.gbCondition);
			this.Controls.Add(this.rbQueryWhat);
			this.Controls.Add(this.rbQueryAll);
			this.Controls.Add(this.btnBack);
			this.Controls.Add(this.btnQuery);
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
			this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
			this.MaximizeBox = false;
			this.MinimizeBox = false;
			this.Name = "SearchForm";
			this.ShowInTaskbar = false;
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "SearchForm";
			this.Load += new System.EventHandler(this.SearchForm_Load);
			((System.ComponentModel.ISupportInitialize)(this.nudSurplus)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.nudAlready)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.nudStandard)).EndInit();
			this.gbMember.ResumeLayout(false);
			this.gbMemberMain.ResumeLayout(false);
			this.gbCondition.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		private void SearchForm_Load(object sender, System.EventArgs e)
		{
			//
			this.ReadSort();
			this.ReadLevel();
			this.ReadCollege();
		}

		private void btnQuery_Click(object sender, System.EventArgs e)
		{
			if(this.rbQueryWhat.Checked)
			{
				//
				this.CreateQueryCondition();
			}
			else
			{
				this.queryCondition = "";
			}

			this.Close();
		}

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

		#region /* 单选框、复选框的相关控件设置 */
		private void rbQueryWhat_CheckedChanged(object sender, System.EventArgs e)
		{
			this.gbCondition.Enabled = this.rbQueryWhat.Checked;
		}

		private void cbSort_CheckedChanged(object sender, System.EventArgs e)
		{
			this.cmbSortNa.Enabled = this.cbSort.Checked;
		}

		private void cbLevel_CheckedChanged(object sender, System.EventArgs e)
		{
			this.cmbLevelNa.Enabled = this.cbLevel.Checked;
		}

		private void cbYear_CheckedChanged(object sender, System.EventArgs e)
		{
			this.dtpYear.Enabled = this.cbYear.Checked;
		}

		private void cbStart_CheckedChanged(object sender, System.EventArgs e)
		{
			this.tbStart.Enabled = this.cbStart.Checked;
		}

		private void cbPlan_CheckedChanged(object sender, System.EventArgs e)
		{
			this.tbPlan.Enabled = this.cbPlan.Checked;
		}

		private void cbEnd_CheckedChanged(object sender, System.EventArgs e)
		{
			this.tbEnd.Enabled = this.cbEnd.Checked;
		}

		private void cbStandard_CheckedChanged(object sender, System.EventArgs e)
		{
			this.nudStandard.Enabled = this.cbStandard.Checked;
		}

		private void cbAlready_CheckedChanged(object sender, System.EventArgs e)
		{
			this.nudAlready.Enabled = this.cbAlready.Checked;
		}

		private void cbSurplus_CheckedChanged(object sender, System.EventArgs e)
		{
			this.nudSurplus.Enabled = this.cbSurplus.Checked;
		}