selstuinfo.cs

聊天系统的经

					{
						smsformss.Stu_Male.Checked = true;
					}
					else
					{
						smsformss.Stu_Female.Checked = true;
					}

					smsformss.Stu_Idcard.Text = dr[3].ToString();			
					
					
					//设置籍贯
					for(int i=0;i<smsformss.Stu_Race.Items.Count;i++)
					{
						if((dr[4].ToString()).Equals(smsformss.Stu_Race.Items[i]))
						{						
							smsformss.Stu_Race.Items[smsformss.Stu_Race.Items.Count-1] = smsformss.Stu_Race.Items[0];

							smsformss.Stu_Race.Items[0] = dr[4].ToString();							
						}
					}
					
		
	
					//设置最高学历
					for(int i=0;i<smsformss.Stu_educational.Items.Count;i++)
					{
						if(dr[5].ToString().Equals(smsformss.Stu_educational.Items[i]))
						{
							smsformss.Stu_educational.Items[smsformss.Stu_educational.Items.Count-1] = smsformss.Stu_educational.Items[0];
							
							smsformss.Stu_educational.Items[0] = dr[5].ToString();
						}
					}				
						



					smsformss.Stu_NativePlace.Text = dr[6].ToString();
					smsformss.Stu_Address.Text = dr[7].ToString();	
					smsformss.Stu_FixTel.Text = dr[8].ToString();
					smsformss.Stu_TelPhone.Text = dr[9].ToString();

					

					//设置爱好
					for(int i=0;i<smsformss.Stu_Love.Items.Count;i++)
					{
						if((dr[10].ToString()).Equals(smsformss.Stu_Love.Items[i]))
						{						
							smsformss.Stu_Love.Items[smsformss.Stu_Love.Items.Count-1] = smsformss.Stu_Love.Items[0];

							smsformss.Stu_Love.Items[0] = dr[10].ToString();							
						}
					}

					

					//设置特长		
					for(int i=0;i<smsformss.Stu_Special.Items.Count;i++)
					{
						if((dr[11].ToString()).Equals(smsformss.Stu_Special.Items[i]))
						{						
							smsformss.Stu_Special.Items[smsformss.Stu_Special.Items.Count-1] = smsformss.Stu_Special.Items[0];

							smsformss.Stu_Special.Items[0] = dr[11].ToString();							
						}
					}
							
					
					smsformss.Stu_Photo.Image = Image.FromFile(((FormMain)this.MdiParent).environmentpath+"\\"+dr[12].ToString());
					
					
					smsformss.Stu_Marks.Text = dr[13].ToString();
					smsformss.Update();	

					
					//为按钮添加相应的事件
					smsformss.Addinfo.Click +=new EventHandler(Addinfo_Click);
					smsformss.Reset.Click +=new EventHandler(Reset_Click);
					
				}
			}

			smsformss.MdiParent = this.MdiParent;
			smsformss.Show();
		}


		//删除学员信息
		public void btnDelStuinfo_Click(object sender, System.EventArgs e)
		{
			if(this.lvwStuinfo.CheckedItems.Count != 0)
			{
				if(MessageBox.Show("确定要删除吗？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Warning) == DialogResult.No)
				{
					return;
				}

				((FormMain)this.MdiParent).Status.Text = "状态:删除学员信息";

				for(int i=0;i<this.lvwStuinfo.CheckedItems.Count;i++)
				{
					for(int line=0;line<this.ds.Tables["stuinfo"].Rows.Count;line++)
					{
						if(this.lvwStuinfo.CheckedItems[i].Text.Equals(this.ds.Tables["stuinfo"].Rows[line]["Stu_Id"].ToString()))
						{

							//同时删除相片
							String filepath = this.ds.Tables["stuinfo"].Rows[line]["Stu_Photo"].ToString();
							File.Delete(((FormMain)this.MdiParent).environmentpath+"\\"+filepath);

							this.ds.Tables["stuinfo"].Rows[line].Delete();
							


							if(this.ds.HasChanges())
							{
								this.adapter.UpdateCommand = new OleDbCommandBuilder(this.adapter).GetDeleteCommand();
								this.adapter.Update(this.ds,"stuinfo");	
							}
							
						}
					}				
					
				}	
		

					
				db.closeConn();


				((FormMain)this.MdiParent).Probar.Visible = true;
				for(int i=1;i<=100;i++)
				{
					for(int j=1;j<=100;j++)
					{
						if(j%20 == 0)
						{
							((FormMain)this.MdiParent).Probar.Increment(i);
						}
					}
							 
				}
				MessageBox.Show("删除成功了!");
				((FormMain)this.MdiParent).Probar.Visible = false;


				//更新子窗体的表数据
				Form[] forms = this.MdiParent.MdiChildren;

				for(int j=0;j<forms.Length;j++)
				{
					if(forms[j].Text.Equals("查询学员信息"))
					{
						SelStuinfo form = ((SelStuinfo)forms[j]);
						form.SelStuinfo_Load(sender,e);
						form.Update();
						form.Refresh();

					}
				}
				

			}
			else
			{
				MessageBox.Show("请选择你要删除的行！");
				return;
			}
		}

		//自定义显示风格
		private void button1_Click(object sender, System.EventArgs e)
		{
			DinCloumn dcform = new DinCloumn();
			if(dcform.ShowDialog(this) == DialogResult.OK)
			{
							

				if(dcform.CboList.SelectedIndex==1)
				{
					SelStuinfo_Load(sender,e);
					this.lvwStuinfo.View = View.LargeIcon;
					//this.lvwStuinfo.CheckBoxes = false;
					this.lvwStuinfo.LargeImageList = this.imgLargeobj;
					for(int i=0;i<this.lvwStuinfo.Items.Count;i++)
					{
						this.lvwStuinfo.Items[i].ImageIndex = 1;
					}
					
					return;
				}
				
				
				if(dcform.CboList.SelectedIndex == 2)
				{
					SelStuinfo_Load(sender,e);
					this.lvwStuinfo.View =View.SmallIcon;	
					this.lvwStuinfo.SmallImageList = this.imgObj;

					for(int i=0;i<this.lvwStuinfo.Items.Count;i++)
					{
						this.lvwStuinfo.Items[i].ImageIndex = 1;
					}

					return;
				}
				
				
				if(dcform.CboList.SelectedIndex == 3)
				{
					this.lvwStuinfo.View =View.List;
					SelStuinfo_Load(sender,e);
					return;
				}

				if(dcform.ListBoxColumn.CheckedIndices.Count != 0)
				{
					
					this.lvwStuinfo.Items.Clear();
					this.lvwStuinfo.Columns.Clear();
					
					this.lvwStuinfo.View = View.Details;				
					
									
					/*

					//连接数据库
					db.Server = "Microsoft.Jet.OLEDB.4.0";
					db.Database = ((FormMain)this.MdiParent).environmentpath+"\\StuInfoMgr.mdb";

					db.createConn();
					db.openConn();
			
			
					this.ds = new DataSet("StuInfoMgr");

					this.adapter = new OleDbDataAdapter();
					this.adapter.SelectCommand = new OleDbCommand("select * from stuinfo",db.Conn);
					
					this.adapter.Fill(this.ds,"stuinfo");
					
					//关闭数据库的连接
					db.closeConn();
					*/


					//加表头
					this.lvwStuinfo.Columns.Add("学号",200,System.Windows.Forms.HorizontalAlignment.Left);
					for(int j=0;j<dcform.ListBoxColumn.CheckedIndices.Count;j++)
					{
						this.lvwStuinfo.Columns.Add(dcform.ListBoxColumn.Items[dcform.ListBoxColumn.CheckedIndices[j]].ToString(),150,System.Windows.Forms.HorizontalAlignment.Left);
					}
					
					int count = 0;

					//加数据
					foreach(DataRow dr in this.ds.Tables["stuinfo"].Rows)
					{
						ListViewItem lvi = new ListViewItem();
						lvi.Text = dr[0].ToString();
						lvi.ImageIndex = 2;
						lvi.Font = new Font("宋体",10);

						if(count % 2 == 0)
						{
							lvi.BackColor = Color.Pink;
						}

						for(int j=0;j<dcform.ListBoxColumn.CheckedIndices.Count;j++)
						{					
							
							String content = dr[dcform.ListBoxColumn.CheckedIndices[j]+1].ToString();

							/*
							if(j == 11)
							{
								content = dr[dcform.ListBoxColumn.CheckedIndices[j]+2].ToString();
							}*/

							lvi.SubItems.Add(content);
						}

						count ++;
						this.lvwStuinfo.Items.Add(lvi);
				     }
				}


				if(dcform.CboList.SelectedIndex==0)
				{
					return ;
				}

			}
			
		}

		//自定义查询条件
		private void button2_Click(object sender, System.EventArgs e)
		{
			SelectInfos siform = new SelectInfos();
			siform.ShowDialog(this);
		}


		//更新数据
		private void Addinfo_Click(object sender, EventArgs e)
		{
			if(smsformss != null)
			{
				//验证数据
				DateVali dv = new DateVali(smsformss);
				if(!dv.validate())
				{			
					return;
				}

				//连接数据库
				db.Server = "Microsoft.Jet.OLEDB.4.0";
				db.Database = ((FormMain)this.MdiParent).environmentpath+"\\StuInfoMgr.mdb";

				db.createConn();
				db.openConn();

				foreach(DataRow dr in this.ds.Tables["stuinfo"].Rows)
				{
					if(smsformss.Stu_Id.Text.Equals(dr[0].ToString()))
					{
						dr[1] = smsformss.Stu_Name.Text.ToString();

						if(smsformss.Stu_Male.Checked == true)
						{
							dr[2] = "男";
						}
						else
						{
							dr[2] = "女";
						}

						dr[3] = smsformss.Stu_Idcard.Text.ToString();
						dr[4] = smsformss.Stu_Race.SelectedItem.ToString();
						dr[5] = smsformss.Stu_educational.SelectedItem.ToString();
						dr[6] = smsformss.Stu_NativePlace.Text.ToString();
						dr[7] = smsformss.Stu_Address.Text.ToString();
						dr[8] = smsformss.Stu_FixTel.Text.ToString();
						dr[9] = smsformss.Stu_TelPhone.Text.ToString();
						dr[10] = smsformss.Stu_Love.SelectedItem.ToString();
						dr[11] = smsformss.Stu_Special.SelectedItem.ToString();

						//同时删除以前的相片						
						//File.Delete(((FormMain)this.MdiParent).environmentpath+"\\"+dr[12].ToString());


						//String filepath = "image\\"+smsformss.Fdlg.FileName.Substring(smsformss.Fdlg.FileName.LastIndexOf("\\")+1);
						//拷贝新相片到目录
						//File.Copy(smsformss.Fdlg.FileName,((FormMain)this.MdiParent).environmentpath+"\\"+filepath,true);

						
						
						//dr[12] = filepath;
						dr[13] = smsformss.Stu_Marks.Text.ToString(); 						
					}
				}			
				
				//更新数据库
				if(this.ds.HasChanges())
				{
					this.adapter.UpdateCommand = new OleDbCommandBuilder(this.adapter).GetUpdateCommand();				
					this.adapter.UpdateCommand.Connection = db.Conn;
					this.adapter.Update(this.ds,"stuinfo");	
					db.closeConn();
					
					((FormMain)this.MdiParent).Probar.Visible = true;
					for(int i=1;i<=100;i++)
					{
						for(int j=1;j<=100;j++)
						{
							if(j%20 == 0)
							{
								((FormMain)this.MdiParent).Probar.Increment(i);
							}
						}
							 
					}
					MessageBox.Show("更新成功了!");
					((FormMain)this.MdiParent).Probar.Visible = false;
					
						 //更新子窗体的表数据
						 Form[] forms = this.MdiParent.MdiChildren;

					for(int i=0;i<forms.Length;i++)
					{
						if(forms[i].Text.Equals("查询学员信息"))
						{
							SelStuinfo form = ((SelStuinfo)forms[i]);
							form.SelStuinfo_Load(sender,e);
							form.Update();
							form.Refresh();
						}
					}
				}				

			}
		}


		//重置
		private void Reset_Click(object sender, EventArgs e)
		{	
			smsformss.Dispose();
			btnUpdateStuinfo_Click(sender,e);
		}


		//全选
		private void btnSelectAll_Click(object sender, System.EventArgs e)
		{
			((FormMain)this.MdiParent).Status.Text = "状态:全选";
			for(int i=0;i<this.lvwStuinfo.Items.Count;i++)
			{
				this.lvwStuinfo.Items[i].Checked = true;
			}
	   }


		//返选
		private void btnSelectAllFan_Click(object sender, System.EventArgs e)
		{

			if(this.lvwStuinfo.CheckedIndices.Count == 0)
			{
				btnSelectAll_Click(sender,e);
				return;
			}
			else
			{	
				MessageBox.Show(this.lvwStuinfo.CheckedIndices.Count.ToString());
				for(int i=0;i<this.lvwStuinfo.CheckedIndices.Count;i++)
				{
					MessageBox.Show(this.lvwStuinfo.CheckedItems[i].Index.ToString());
					this.lvwStuinfo.CheckedItems[i].Checked = false;
				}
				

			}
		}


		
		private void menuItem1_Click(object sender, System.EventArgs e)
		{
			btnSelectAll_Click(sender,e);
		}


		//添加
		private void menuItem2_Click(object sender, System.EventArgs e)
		{
			AddStuinfo asForm = new AddStuinfo();	
			asForm.MdiParent = this.MdiParent;				
			asForm.Show();
			((FormMain)this.MdiParent).Status.Text = "状态: 添加学员信息";
		}


		//删除
		private void menuItem3_Click(object sender, System.EventArgs e)
		{
			btnDelStuinfo_Click(sender,e);
		}


		//查询
		private void menuItem5_Click(object sender, System.EventArgs e)
		{
			SelStuinfo ssForm = new SelStuinfo();
			ssForm.MdiParent = this.MdiParent;
			ssForm.WindowState = FormWindowState.Normal;
			ssForm.Show();
			((FormMain)this.MdiParent).Status.Text = "状态: 查询学员信息";	
		}


		//更新
		private void menuItem4_Click(object sender, System.EventArgs e)
		{
			Addinfo_Click(sender,e);

			//更新子窗体的表数据
			Form[] forms = this.MdiParent.MdiChildren;

			for(int i=0;i<forms.Length;i++)
			{
				if(forms[i].Text.Equals("查询学员信息"))
				{
					SelStuinfo form = ((SelStuinfo)forms[i]);
					form.btnUpdateStuinfo_Click(sender,e);
					form.Update();
					form.Refresh();
					return;

				}
			}
		}


		//刷新
		private void menuItem8_Click(object sender, System.EventArgs e)
		{
			this.ds = null;
			SelStuinfo_Load(sender,e);
		}
	}
}