usermanage.cs

软件工程的课程作业

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;


namespace PSMS
{
	/// <summary>
	/// userManage 的摘要说明。
	/// </summary>
	public class userManage
	{
		public userManage()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
			
		}	
		/// <summary>
		/// 查询销售人员
		/// </summary>
		/// <param name="ada_saler"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public int searchsaler(System.Data.OleDb.OleDbDataAdapter ada_user,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, string uID, string ukey)//login log)//string userstr, string keystr)
		{
			
			    int type = 0; //0代表用户名错误；1代表用户名正确，密码错误；2代表通过验证
				try
				{
					
					 
					//int temp = 0;
					string temp;
					ada_user.Fill(dset);
					DataTable userDT = dset.Tables["Users"];

					foreach(DataRow myRow in userDT.Rows)
					{
						  if(myRow[0].Equals(uID))//log.username.Text))
						  {
							  type = 1;
							 
							  temp = myRow[2].ToString();//(string)(myRow[2]);
							  if(temp.Equals(ukey)) type = 2;
							  break;
						  }
					}
				
					
				}
				catch(System.Exception ie)
				{
					MessageBox.Show(ie.Message);
				}
			return type;
				
		}

		public int certify(System.Data.OleDb.OleDbDataAdapter ada_user,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, string uID)
		{
			int popedom = 0;
			try
			{
					
				//int type = 0; //0代表用户名错误；1代表用户名正确，密码错误；2代表通过验证
				//int popedom = 0;
				ada_user.Fill(dset);
				DataTable userDT = dset.Tables["Users"];

				foreach(DataRow myRow in userDT.Rows)
				{
					if(myRow[0].Equals(uID))
					{
						popedom = int.Parse(""+myRow[3]);
						popedom = popedom % 4;
					}
				}

				//return popedom;
					
			}
			catch(System.Exception ie)
			{
				MessageBox.Show(ie.Message);
			}

			return popedom;
		}

		public void update_ukey(System.Data.OleDb.OleDbDataAdapter ada_user,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, string uID, string ukey)
		{
			string newID = "";
			string newukey = "";

			try
			{
				ada_user.Fill(dset);
				DataTable userDT = dset.Tables["Users"];

				foreach(DataRow myRow in userDT.Rows)
				{
					if(myRow[0].ToString().Equals(uID))
					{
						newID = myRow[0].ToString();
						newukey = ukey;
						break;
					}
				}
				
				ada_user.UpdateCommand.CommandText = "UPDATE [Users] SET " +
					"UserPwd = '"+ newukey + 
				
					"' WHERE UserID = '"+ newID + "'";

				ada_user.UpdateCommand.ExecuteNonQuery();
				/*dset.Clear();
				ada_user.Fill(dset.Tables["User"]);
				dgrid.DataSource=dset.Tables["User"];
				*/
				MessageBox.Show("密码已修改");
			}
			catch(System.Exception ie)
			{
				MessageBox.Show(ie.Message);
			}
	
		}

		public int retsID(System.Data.OleDb.OleDbDataAdapter ada_saler,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, string uID)
		{
			ada_saler.SelectCommand.CommandText = "SELECT * FROM Saler WHERE SalerAcount = '"
							+uID+"'";
			ada_saler.SelectCommand.ExecuteNonQuery();
			ada_saler.Fill(dset);
			int i=0;
			try
			{
				while(dset.Tables["Saler"].Rows[i]["SalerID"] != null)
					i++;
			}
			catch(System.IndexOutOfRangeException)
			{
				if(i == 0) return -1;
				else return (int)dset.Tables["Saler"].Rows[0]["SalerID"];
			}
			return -1;
		}


		public string[] retproID(System.Data.OleDb.OleDbDataAdapter ada_project,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, int sID)
		{
			string[] tproID = new string [50000];
			ada_project.SelectCommand.CommandText = "SELECT * FROM Project WHERE ManagerID = '"
				+sID+"'";
			ada_project.SelectCommand.ExecuteNonQuery();
			ada_project.Fill(dset);
			int count=0;
			try
			{
				while(dset.Tables["Project"].Rows[count]["ProjectID"] != null)
				{
					tproID[count] = ""+dset.Tables["Project"].Rows[count]["ProjectID"];
					count++;
				}
			}
			catch(System.IndexOutOfRangeException)
			{
				string[] proID = new string [count];
				for(int i=0; i<count; i++)	proID[i] = tproID[i];
				return proID;
			}
			return tproID;
		}
	
         
		public void modifykey(System.Data.OleDb.OleDbDataAdapter ada_user,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, string uID)
		{
			key kk = new key();
			kk.ShowDialog();
			Color kcolor = kk.BackColor;
			int times = 0;
			int type = 0;
			string newkey;
			userManage um = new userManage();
			
			while(times < 5)
			{
				
				if(kk.Enabled== false)
				{
				
					if(kk.cancel.BackColor == Color.GreenYellow) break;
					type = searchsaler(ada_user, dset, dgrid, uID, kk.prebox.Text);
					//if(type == 2) break;
					kk.Enabled = true;
					
					if(type == 1)
					{
						
						MessageBox.Show("密码错误");
						times ++;
						if(times < 5)
						{
							kk.BackColor = kcolor;
							kk.prebox.Clear();
							kk.newbox.Clear();
							kk.config.Enabled = true;
							kk.ShowDialog();
						}
						else
						{
							MessageBox.Show("对不起，你已尝试5次，请退出！");
							return;
						}
					  
					}
						//times ++;
					else
					{
						Console.WriteLine("" + type);
						newkey = kk.newbox.Text;
						config_key ck = new config_key();
						ck.ShowDialog();
						if(ck.sure.BackColor == Color.GreenYellow)
						{
							if(ck.configbox.Text.Equals(newkey))
							{
								//修改密码
								update_ukey(ada_user, dset, dgrid, uID, newkey);
								break;
							}
							else
							{
								MessageBox.Show("重输密码不正确");
								kk.BackColor = kcolor;
								kk.prebox.Clear();
								kk.newbox.Clear();
								kk.config.Enabled = true;
								kk.ShowDialog();
							}
						}
						
					}
				}
			}
		}
		
		
		
	}
}