manger.cs

实施医院管理系统

		public void FillDataGrid3()
		{
			DataTable table = new DataTable("Symptom");
			table = symAccess.SelectSym();
			dataGrid3.DataSource = table;
		}
/// <summary>
/// 新增医院
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button1_Click(object sender, System.EventArgs e)
		{
			HosEdit hosEdit = new HosEdit();
			if(hosEdit.ShowDialog() == DialogResult.OK)
			{
				hosAccess.AddHosp(hosEdit.Hospital);
			}
			FillDataGrid1();
		}
/// <summary>
/// 填充数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void Manger_Load(object sender, System.EventArgs e)
		{
			Dictionary[] dic = dicAccess.GetDetailByCate("医院级别");
			Dictionary[] dic1 = dicAccess.GetDetailByCate("所在省份");
			Dictionary[] dic2 = dicAccess.GetDetailByCate("所属科室");
			Dictionary[] dic3 = dicAccess.GetDetailByCate("职称");
			Dictionary[] dic4 = dicAccess.GetDetailByCate("性别");
			

			for(int i=0;i<dic.Length;i++)
			{
				this.comboBox1.Items.Add(dic[i]);
			}
			for(int i=0;i<dic1.Length;i++)
			{
				this.comboBox2.Items.Add(dic1[i]);
			}
			for(int i=0;i<dic2.Length;i++)
			{
				this.comboBox7.Items.Add(dic2[i]);
			}
			for(int i=0;i<dic2.Length;i++)
			{
				this.comboBox4.Items.Add(dic2[i]);
			}
			for(int i=0;i<dic3.Length;i++)
			{
				this.comboBox5.Items.Add(dic3[i]);
			}
			for(int i=0;i<dic4.Length;i++)
			{
				this.comboBox6.Items.Add(dic4[i]);
			}




			FillDataGrid1();
			FillDataGrid3();
			FillDataGrid2();
		}
/// <summary>
/// 修改医院
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button2_Click(object sender, System.EventArgs e)
		{
			DataRowView row = (DataRowView)this.BindingContext[dataGrid1.DataSource].Current;
			HosEdit hosEdit = new HosEdit(row["Name"].ToString(),row["Grade"].ToString(),row["ProvinceName"].ToString(),row["CityName"].ToString(),row["Traffic"].ToString(),row["Address"].ToString());
			if(hosEdit.ShowDialog() == DialogResult.OK)
			{
				hosAccess.UpdateHos(hosEdit.Hospital,Convert.ToInt32(row["HospitalID"]));
			}
			FillDataGrid1();
		}
/// <summary>
/// 删除医院
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button3_Click(object sender, System.EventArgs e)
		{
			DataRowView row = (DataRowView)this.BindingContext[dataGrid1.DataSource].Current;
			if(MessageBox.Show("您确定要删除这条记录吗？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Information) == DialogResult.Yes)
			{
				hosAccess.DeleteHos(Convert.ToInt32(row["HospitalID"]));
				docAccess.DeleteDocByBelongID(Convert.ToInt32(row["HospitalID"]));
			}
			FillDataGrid1();
			FillDataGrid2();
		}
/// <summary>
/// 新增病症
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button9_Click(object sender, System.EventArgs e)
		{
			SymEdit sym = new SymEdit();
			if(sym.ShowDialog() == DialogResult.OK)
			{
				symAccess.AddSym(sym.Symptom);
				
			}
			FillDataGrid3();
		}
/// <summary>
/// 修改病症
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button10_Click(object sender, System.EventArgs e)
		{
			DataRowView row = (DataRowView)this.BindingContext[dataGrid3.DataSource].Current;
			SymEdit sym = new SymEdit(row["SymptomName"].ToString(),row["Detail"].ToString());
			if(sym.ShowDialog() == DialogResult.OK)
			{
				symAccess.UpdateSym(sym.Symptom,Convert.ToInt32(row["ID"]));
				
			}
			FillDataGrid3();
		}
/// <summary>
/// 删除病症
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button11_Click(object sender, System.EventArgs e)
		{
			DataRowView row = (DataRowView)this.BindingContext[dataGrid3.DataSource].Current;
			if(MessageBox.Show("您确定要删除这条记录吗？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Information) == DialogResult.Yes)
				symAccess.DeleteSym(Convert.ToInt32(row["ID"]));
			FillDataGrid3();
		}
/// <summary>
/// 新增医生
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button4_Click(object sender, System.EventArgs e)
		{
			Docedit docEdit = new Docedit();
			if(docEdit.ShowDialog() == DialogResult.OK)
			{
				docAccess.AddDoc(docEdit.Doctor);
			}
			FillDataGrid2();
		}
/// <summary>
/// 修改医生资料
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button5_Click(object sender, System.EventArgs e)
		{
			DataRowView row = (DataRowView)this.BindingContext[dataGrid2.DataSource].Current;
			Docedit docEdit = new Docedit(row["Name"].ToString(),Convert.ToInt32(row["Old"]),row["Sex"].ToString(),row["Profess"].ToString(),row["BelongOff"].ToString(),row["HospitalName"].ToString(),row["TelphonNum"].ToString(),row["Specialty"].ToString(),row["DocTime"].ToString(),row["ProvinceName"].ToString(),row["CityName"].ToString());
			if(docEdit.ShowDialog() == DialogResult.OK)
			{
				docAccess.Updatedoc(docEdit.Doctor,Convert.ToInt32(row["DoctorID"]));
			}
			FillDataGrid2();
		}
/// <summary>
/// 删除医生资料
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button6_Click(object sender, System.EventArgs e)
		{
			DataRowView row = (DataRowView)this.BindingContext[dataGrid2.DataSource].Current;
			if(MessageBox.Show("您确定要删除这条记录吗？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Information) == DialogResult.Yes)
				docAccess.DeleteDoc(Convert.ToInt32(row["DoctorID"]));
			
			FillDataGrid2();
		}
/// <summary>
/// 医院信息查找
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button8_Click(object sender, System.EventArgs e)
		{
			string HosName;
			int ProvinceID;
			int CityID;
			int GradeID;
			if(this.textBox1.Text == "")
				HosName = "";
			else
				HosName = "%"+this.textBox1.Text+"%";
			if(this.comboBox2.SelectedIndex == -1)
				ProvinceID = -1;
			else
				ProvinceID = Convert.ToInt32(((Dictionary)this.comboBox2.SelectedItem).ID);
			if(this.comboBox3.SelectedIndex == -1)
				CityID = -1;
			else
				CityID = Convert.ToInt32(((City)this.comboBox3.SelectedItem).CityID);
			if(this.comboBox1.SelectedIndex == -1)
				GradeID = -1;
			else
				GradeID = Convert.ToInt32(((Dictionary)this.comboBox1.SelectedItem).ID);

			DataTable table = hosAccess.SerchHos(HosName,ProvinceID,CityID,GradeID);

			dataGrid1.DataSource = table;

			this.textBox1.Clear();
			this.comboBox1.Text = "";
			this.comboBox2.Text = "";
			this.comboBox3.Text = "";
		}

		private void comboBox2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			this.comboBox3.Items.Clear();
			City[] city = cityAccess.GetNameByProID(((Dictionary)this.comboBox2.SelectedItem).ID);

			for(int i =0;i<city.Length;i++)
			{
				this.comboBox3.Items.Add(city[i]);
			}
		}
/// <summary>
/// 病症信息查找
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button12_Click(object sender, System.EventArgs e)
		{

			string SymName;
			int BelongOffID;
			if(this.textBox4.Text == "")
				SymName = "";
			else
				SymName = "%"+this.textBox4.Text+"%";
			if(this.comboBox7.SelectedIndex == -1)
				BelongOffID = -1;
			else
				BelongOffID = ((Dictionary)this.comboBox7.SelectedItem).ID;

			DataTable table = symAccess.SerchSym(SymName,BelongOffID);
			
			dataGrid3.DataSource = table;
		}
/// <summary>
/// 医生信息查找
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button7_Click(object sender, System.EventArgs e)
		{
			string DocName;
			string Belong;
			int BelongOffID;
			int ProfesID;
			int SexID;
			if(this.textBox2.Text == "")
				DocName = "";
			else
				DocName = this.textBox2.Text;
			if(this.textBox3.Text == "")
				Belong = "";
			else
				Belong = "%"+this.textBox3.Text+"%";
			if(this.comboBox4.SelectedIndex == -1)
				BelongOffID = -1;
			else
				BelongOffID = ((Dictionary)this.comboBox4.SelectedItem).ID;
			if(this.comboBox5.SelectedIndex == -1)
				ProfesID = -1;
			else
				ProfesID = ((Dictionary)this.comboBox5.SelectedItem).ID;
			if(this.comboBox6.SelectedIndex == -1)
				SexID = -1;
			else
				SexID = ((Dictionary)this.comboBox6.SelectedItem).ID;
			DataTable table = docAccess.SerchDoc(DocName,Belong,BelongOffID,ProfesID,SexID);

			dataGrid2.DataSource = table;
		}
/// <summary>
/// 添加系统管理员
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void button13_Click(object sender, System.EventArgs e)
		{
			AddManger Add = new AddManger();
			if(Add.ShowDialog() == DialogResult.OK)
			{
				Add._userLoad.GradeID = 1;
				userLoadAccess.AddUser(Add._userLoad);
			}
		}

		private void button14_Click(object sender, System.EventArgs e)
		{
			FillDataGrid1();
		}

		private void button15_Click(object sender, System.EventArgs e)
		{
			FillDataGrid2();
		}
	}
}