operator_manager.cs

问题定义 随着生活水平的日益提高

			ListViewItem lstv=new ListViewItem();
			try
			{
				opermana.Open();
				sqlda.Fill(ds);
				//初始化现有管理员纪录
				for(i=0;i<ds.Tables[0].Rows.Count;i++)
				{
					string s=ds.Tables[0].Rows[i]["userid"].ToString();
					lstv=new ListViewItem(s);
					string s2=ds.Tables[0].Rows[i]["levels"].ToString();
					lstv.SubItems.Add(s2);
					lv.Items.Add(lstv);
				}	
			}
			catch (Exception ex)
			{
				MessageBox.Show(ex.ToString());
			}
			//隐藏各个操作面板，根据使用者点击的操作显示相应的面板！
			panel1.Hide();
			panel2.Hide(); 
			panel3.Hide();
			panel4.Hide();

		}
		#endregion

		#region 退出
		private void btnexit_Click(object sender, System.EventArgs e)
		{
			this.Close();//退出
		}
		#endregion

		#region 根据被选择的条目的变化，纪录当前选择项，供其他操作使用
		private void lv_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			try
			{
				if (lv.SelectedItems.Count!=0) //如果有纪录被选定
				{
					//	MessageBox.Show(lv.SelectedItems.Count.ToString());
					selectuserid=lv.SelectedItems[0].SubItems[0].Text;
					selectlevels=lv.SelectedItems[0].SubItems[1].Text;
					txtuserid.Text=selectuserid;
					txtlevels.Text=selectlevels;
				}
			}
			catch
			{}
		}
		#endregion

		#region "添加操作员"
		private void btnok1_Click(object sender, System.EventArgs e)
		{
			string insertuser="";
			string level1;//保存用户权限变量的值
			if(txtlevel1.Text=="") 
			{
				level1="3";
			}
			else
			{
				level1=txtlevel1.Text;
			}

			if(txtuserid1.Text=="")
			{
				MessageBox.Show("用户名不能为空！");
			}
			else if(txtpwd1.Text=="")
			{
				MessageBox.Show("请输入密码！");
			}
			else 
			{
				int i;
				md5eny md5=new md5eny();
				string user=txtuserid1.Text; //保存用户明名变量的值
				string pwd1=md5.getmd5(txtpwd1.Text); //保存用户密码变量的值
				insertuser="insert into account_user(userid,passwd,levels) values ('" + user;
				insertuser += "','";
				insertuser += pwd1;
				insertuser +="','";
				insertuser +=level1;
				insertuser +="')";
				Classdb insertdb=new Classdb();
				SqlConnection insertcon=insertdb.conds();
			//	MessageBox.Show(insertuser);
				SqlCommand insertda=new SqlCommand();
				insertda.CommandText=insertuser;
				insertda.Connection=insertcon;
				try
				{
					insertcon.Open();
					i=insertda.ExecuteNonQuery();//将数据写入数据库，返回受影响的行数
					MessageBox.Show("添加成功！");
					if (i==0)
					{
						MessageBox.Show("添加失败！");
					}
				}
				catch
				{
					MessageBox.Show("添加失败！");
				}
				finally
				{
					insertcon.Close();
				}
			}
			panel1.Hide();
			panel2.Hide(); 
			panel3.Hide();
			panel4.Hide();
		}

		#endregion

		#region "更改用户权限"
		private void btnok2_Click(object sender, System.EventArgs e)
		{
			Classdb updatedb=new Classdb();
			string updateuserid="";//存储用户名
			if(txtuserid2.Text=="")
			{
				MessageBox.Show("请输入用户名！");
			}
			else
			{
				updateuserid=txtuserid2.Text;
			}

			SqlConnection updatecon=updatedb.conds();//连接数据库
			string newlevels=txtlevel2.Text;
			string updatelevels="update account_user set levels='" + newlevels;//更新语句
			updatelevels +="' where userid='";
			updatelevels += updateuserid;
			updatelevels += "'";
		//	MessageBox.Show(updatelevels);
				int i; //纪录受更新语句影响的行数
			SqlCommand updatecom=new SqlCommand(updatelevels,updatecon);
			try
			{
				updatecon.Open();
				i=updatecom.ExecuteNonQuery();
				if (i!=0)
					//更新成功
				{
					MessageBox.Show("update success complete!");
				}
				else
					//更新失败
				{
					MessageBox.Show("update failled!");
				}
			}
			catch 
			{
				MessageBox.Show("update failled!");
			}
			finally
			{
				updatecom.Dispose();
				updatecon.Close();
			}
			panel1.Hide();
			panel2.Hide(); 
			panel3.Hide();
			panel4.Hide();
		}
		#endregion

		#region 修改密码
		private void btnok3_Click(object sender, System.EventArgs e)
		{
              if (txtoldpwd.Text=="") 
			{
				MessageBox.Show("请输入旧密码！");
			}
			else if (txtnewpwd.Text=="")
			{
				MessageBox.Show("请输入新密码！");
			}
			else if (txtconfirmnewpwd.Text=="")
			{
				MessageBox.Show("请输入确认新密码！");
			}
			else if (txtnewpwd.Text!=txtconfirmnewpwd.Text)
			{
				MessageBox.Show("两次输入的密码不一致，请重新输入！");
			}
			else
			{
				//  MessageBox.Show("begin change!");
				Classdb updatedb=new Classdb();
				  md5eny md5=new md5eny();
				SqlConnection confirmcon=updatedb.conds();
				string confirmstr="select * from account_user where userid='" + txtuserid3.Text;
				confirmstr +="' and passwd='";
				confirmstr +=md5.getmd5(txtoldpwd.Text);
				confirmstr +="'";
				//   MessageBox.Show(confirmstr);
				SqlCommand confirmcom=new SqlCommand(confirmstr,confirmcon);
				SqlDataReader dr;
				try
				{
					confirmcon.Open();
					dr=confirmcom.ExecuteReader();
					if (dr.Read())
					{
						//如果原密码输入正确，则执行更改密码操作
						int i;
						string updatepwdstr="update account_user set passwd='" + md5.getmd5(txtnewpwd.Text);
						updatepwdstr+="' where userid='";
						updatepwdstr+=txtuserid3.Text;
						updatepwdstr+="'";
						Classdb updatepwd=new Classdb();
						SqlConnection updatecon=updatepwd.conds();
					//	MessageBox.Show(updatepwdstr);
						updatecon.Open();
						SqlCommand updatepwdcom=new SqlCommand(updatepwdstr,updatecon);
						i=updatepwdcom.ExecuteNonQuery();
						if (i!=0)
						{
							MessageBox.Show("密码修改成功!");
							updatecon.Dispose();
							updatepwdcom.Dispose();
						}
						else
						{
							MessageBox.Show("密码修改失败！");
						}
					}
					else
					{
					MessageBox.Show("原密码输入错误！");
					}
				}
				catch (Exception ex)
				{
					MessageBox.Show("更新失败\n" + ex.ToString());
				}
				finally
				{
					confirmcom.Dispose();
					confirmcon.Close();}
			}
			panel1.Hide();
			panel2.Hide(); 
			panel3.Hide();
			panel4.Hide();
		}
		#endregion

		#region 删除用户
		private void btnok4_Click(object sender, System.EventArgs e)
		{
			Classdb deluser=new Classdb();
			SqlConnection delusercon=deluser.conds();
			string deluserid=txtuserid4.Text;
			string delstr="delete from account_user where userid='" + deluserid;
			delstr += "'";
			SqlCommand delcom=new SqlCommand(delstr,delusercon);
			try
			{
				int i;
				delusercon.Open();
				i=delcom.ExecuteNonQuery();
				if(i==0)
				{
					MessageBox.Show("删除失败！");
				}
				else
				{
					MessageBox.Show("删除成功!");
				}
			}
			catch 
			{
				MessageBox.Show("删除失败！");
			}
			finally
			{
			delusercon.Close();
			}
		}
		#endregion  

		private void btnsearch_Click(object sender, System.EventArgs e)
		{
			if (txtuserid4.Text=="") 
			{
				MessageBox.Show("请输入要删除的用户名！");
			}
			else
			{
			Classdb deldb=new Classdb();
		    SqlConnection delcon=deldb.conds();
			string searchstr="select levels from account_user where userid='" + txtuserid4.Text;
				searchstr += "'";
		    SqlDataAdapter da=new SqlDataAdapter(searchstr,delcon);
					DataSet ds=new DataSet();
				try
				{
					delcon.Open();
					da.Fill(ds);
					if (ds.Tables[0].Rows.Count!=0)
					{
						txtlevel4.Text=ds.Tables[0].Rows[0]["levels"].ToString();
					}
					else
					{
					MessageBox.Show("该用户不存在！");
					}
				}
				catch (Exception ex)
				{
				MessageBox.Show(ex.ToString());
				}
				finally
				{
					ds.Dispose();
					da.Dispose();
				  delcon.Close();				
				}
			}
		}

		private void btnrefresh_Click(object sender, System.EventArgs e)
		{
			lv.Items.Clear();
			int i;
			string selstr="select userid,levels from account_user";
			SqlConnection opermana=new Classdb().conds();
			SqlDataAdapter sqlda=new SqlDataAdapter(selstr,opermana);
			DataSet ds=new DataSet();
			DataTable table=new DataTable();
			ListViewItem lstv=new ListViewItem();
			try
			{
				opermana.Open();
				sqlda.Fill(ds);
				//初始化现有管理员纪录
				for(i=0;i<ds.Tables[0].Rows.Count;i++)
				{
					string s=ds.Tables[0].Rows[i]["userid"].ToString();
					lstv=new ListViewItem(s);
					string s2=ds.Tables[0].Rows[i]["levels"].ToString();
					lstv.SubItems.Add(s2);
					lv.Items.Add(lstv);
				}	
			}
			catch (Exception ex)
			{
				MessageBox.Show(ex.ToString());
			}
			//隐藏各个操作面板，根据使用者点击的操作显示相应的面板！
			panel1.Hide();
			panel2.Hide(); 
			panel3.Hide();
			panel4.Hide();
		}
}
}