employeemanageform.cs

超市管理系统的完整版文档

			dt.Columns.Add(new System.Data.DataColumn("sex"));
			dt.Columns.Add(new System.Data.DataColumn("age"));
			dt.Columns.Add(new System.Data.DataColumn("workyear"));
			dt.Columns.Add(new System.Data.DataColumn("username"));
			dt.Columns.Add(new System.Data.DataColumn("post"));
			dt.Columns.Add(new System.Data.DataColumn("priority"));
			dt.Columns.Add(new System.Data.DataColumn("password"));
			getEmployeeList();
			for (int i=0;i<employeeList.Count;i++)
				//for (int i = 0; i<3; i++) 
			{
				Employee m_employee;
				m_employee=(Employee)employeeList[i];
				dr = dt.NewRow();
				dr[0] = m_employee.Employeename;
				dr[1] = m_employee.Employeesex;
				dr[2] = m_employee.Birthday;
				dr[3] = m_employee.StartWorkTime;
				dr[4] = m_employee.UserName;
				dr[5] = m_employee.Employeepost;
				dr[6] = m_employee.Priority;
				dr[7] = m_employee.Employeepassword;
				dt.Rows.Add(dr);
			}
			System.Data.DataView dv = new System.Data.DataView(dt);
			m_EmployeeDataGrid.DataSource=dv;			
			previousRowNumber=m_EmployeeDataGrid.CurrentCell.RowNumber;	
			if (!(employeeList==null||employeeList.Count==0))
			{
				string sex=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,1];
				string priority=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,6];
				m_NameText.Text=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,0];
				m_NameText.ReadOnly=true;
				if (sex.Equals("男"))
					m_SexCombo.SelectedIndex=0;
				else if (sex.Equals("女"))
					m_SexCombo.SelectedIndex=1;
				else
				{}
				m_SexCombo.Enabled=false;
				m_BirthdayDateTime.Value=DateTime.Parse((string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,2]);
				m_BirthdayDateTime.Enabled=false;
				m_StartWorkDateTime.Value=DateTime.Parse((string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,3]);
				m_StartWorkDateTime.Enabled=false;
				m_PostText.Text=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,5];
				m_PostText.ReadOnly=true;
				if (priority.Equals("0"))
					m_PriorityCombo.SelectedIndex=0;
				else if (priority.Equals("1"))
					m_PriorityCombo.SelectedIndex=1;
				else if (priority.Equals("2"))
					m_PriorityCombo.SelectedIndex=2;
				else
				{}
				m_PriorityCombo.Enabled=false;
				m_PasswordText.Text=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,7];
				m_UserText.Text=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,4];
				m_UserText.ReadOnly=true;
				m_PasswordText.ReadOnly=true;
				m_IDText.Text=""+((Employee)employeeList[0]).Employeeid;		
				m_ModifyButton.Enabled=true;
				m_DeleteButton.Enabled=true;	
			}	
			else
			{
				m_IDText.Text="";
				m_NameText.Text="";
				m_NameText.ReadOnly=true;
				m_UserText.Text="";
				m_UserText.ReadOnly=true;
				m_PasswordText.Text="";
				m_PasswordText.ReadOnly=true;
				m_PostText.Text="";
				m_PostText.ReadOnly=true;
				m_PriorityCombo.SelectedIndex=0;
				m_PriorityCombo.Enabled=false;
				m_SexCombo.SelectedIndex=0;
				m_SexCombo.Enabled=false;
				m_BirthdayDateTime.Value=DateTime.Parse("1980-1-1");
				m_BirthdayDateTime.Enabled=false;
				m_StartWorkDateTime.Value=DateTime.Parse("1988-1-1");
				m_StartWorkDateTime.Enabled=false;
				m_ModifyButton.Enabled=false;
				m_DeleteButton.Enabled=false;
			}
			m_AddButton.Enabled=true;
			m_CancelButton.Enabled=false;
			m_OKButton.Enabled=false;
		}

		private void m_ModifyButton_Click(object sender, System.EventArgs e)
		{
			m_ModifyButton.Enabled=false;
			m_DeleteButton.Enabled=false;
			m_AddButton.Enabled=false;
			m_CancelButton.Enabled=true;
			m_OKButton.Enabled=true;
			m_NameText.ReadOnly=false;
			m_SexCombo.Enabled=true;
			m_BirthdayDateTime.Enabled=true;
			m_StartWorkDateTime.Enabled=true;
			m_UserText.ReadOnly=false;
			m_PostText.ReadOnly=false;
			m_PriorityCombo.Enabled=true;
			m_PasswordText.ReadOnly=false;
		}

		private void m_DeleteButton_Click(object sender, System.EventArgs e)
		{
			DialogResult dr1=MessageBox.Show(this,"是否真的删除该员工？\n删除后，该员工记录不能被恢复！","询问",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
			if (dr1==DialogResult.OK)
			{
				SqlCommand sqlDeleteCommand=new SqlCommand();
				m_sqlDataAdapter.DeleteCommand=sqlDeleteCommand;
				sqlDeleteCommand.CommandText="delete from Employee where EmployeeID="+m_IDText.Text;
				sqlDeleteCommand.Connection=m_Connection;
				try
				{
					sqlDeleteCommand.Connection.Open();
					sqlDeleteCommand.ExecuteNonQuery();
					sqlDeleteCommand.Connection.Close();
					MessageBox.Show(this,"已经成功删除一条员工记录！","正确");
				}
				catch(SqlException e1)
				{
					MessageBox.Show(this,e1.Message,"错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
				}
				System.Data.DataTable dt = new System.Data.DataTable();
				System.Data.DataRow dr;
				dt.Columns.Add(new System.Data.DataColumn("name"));
				dt.Columns.Add(new System.Data.DataColumn("sex"));
				dt.Columns.Add(new System.Data.DataColumn("age"));
				dt.Columns.Add(new System.Data.DataColumn("workyear"));
				dt.Columns.Add(new System.Data.DataColumn("username"));
				dt.Columns.Add(new System.Data.DataColumn("post"));
				dt.Columns.Add(new System.Data.DataColumn("priority"));
				dt.Columns.Add(new System.Data.DataColumn("password"));
				getEmployeeList();
				for (int i=0;i<employeeList.Count;i++)
				//for (int i = 0; i<3; i++) 
				{
					Employee m_employee;
					m_employee=(Employee)employeeList[i];
					dr = dt.NewRow();
					dr[0] = m_employee.Employeename;
					dr[1] = m_employee.Employeesex;
					dr[2] = m_employee.Birthday;
					dr[3] = m_employee.StartWorkTime;
					dr[4] = m_employee.UserName;
					dr[5] = m_employee.Employeepost;
					dr[6] = m_employee.Priority;
					dr[7] = m_employee.Employeepassword;
					dt.Rows.Add(dr);
				}
				System.Data.DataView dv = new System.Data.DataView(dt);
				m_EmployeeDataGrid.DataSource=dv;			
				previousRowNumber=m_EmployeeDataGrid.CurrentCell.RowNumber;
				if (!(employeeList==null||employeeList.Count==0))
				{
					string sex=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,1];
					string priority=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,6];
					m_NameText.Text=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,0];
					m_NameText.ReadOnly=true;
					if (sex.Equals("男"))
						m_SexCombo.SelectedIndex=0;
					else if (sex.Equals("女"))
						m_SexCombo.SelectedIndex=1;
					else
					{}
					m_SexCombo.Enabled=false;
					m_BirthdayDateTime.Value=DateTime.Parse((string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,2]);
					m_BirthdayDateTime.Enabled=false;
					m_StartWorkDateTime.Value=DateTime.Parse((string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,3]);
					m_StartWorkDateTime.Enabled=false;
					m_PostText.Text=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,5];
					m_PostText.ReadOnly=true;
					if (priority.Equals("0"))
						m_PriorityCombo.SelectedIndex=0;
					else if (priority.Equals("1"))
						m_PriorityCombo.SelectedIndex=1;
					else if (priority.Equals("2"))
						m_PriorityCombo.SelectedIndex=2;
					else
					{}
					m_PriorityCombo.Enabled=false;
					m_PasswordText.Text=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,7];
					m_UserText.Text=(string)m_EmployeeDataGrid[m_EmployeeDataGrid.CurrentCell.RowNumber,4];
					m_UserText.ReadOnly=true;
					m_PasswordText.ReadOnly=true;
					m_IDText.Text=""+((Employee)employeeList[0]).Employeeid;		
					m_ModifyButton.Enabled=true;
					m_DeleteButton.Enabled=true;	
				}	
				else
				{
					m_IDText.Text="";
					m_NameText.Text="";
					m_NameText.ReadOnly=true;
					m_UserText.Text="";
					m_UserText.ReadOnly=true;
					m_PasswordText.Text="";
					m_PasswordText.ReadOnly=true;
					m_PostText.Text="";
					m_PostText.ReadOnly=true;
					m_PriorityCombo.SelectedIndex=0;
					m_PriorityCombo.Enabled=false;
					m_SexCombo.SelectedIndex=0;
					m_SexCombo.Enabled=false;
					m_BirthdayDateTime.Value=DateTime.Parse("1980-1-1");
					m_BirthdayDateTime.Enabled=false;
					m_StartWorkDateTime.Value=DateTime.Parse("1988-1-1");
					m_StartWorkDateTime.Enabled=false;
					m_ModifyButton.Enabled=false;
					m_DeleteButton.Enabled=false;
				}
				m_AddButton.Enabled=true;
				m_CancelButton.Enabled=false;
				m_OKButton.Enabled=false;
			}
		}

		private void m_OKButton_Click(object sender, System.EventArgs e)
		{
			if(checkInput()==true)
			{
				if (!m_IDText.Text.Trim().Equals(""))
				{
					//修改
					SqlCommand m_sqjUpdateCommand=new SqlCommand();
					m_sqlDataAdapter.UpdateCommand=m_sqjUpdateCommand;
					m_sqjUpdateCommand.Connection=m_Connection;
					m_sqjUpdateCommand.CommandText="update Employee set EmployeeName=@name,Sex=@sex,Birthday=@birthday,StartworkingTime=@startworkingtime,Title=@post,Priority=@priority,Password=@password,UserName=@username where EmployeeID=@employeeID";
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar, 50)); 
					m_sqjUpdateCommand.Parameters["@name"].Value=m_NameText.Text.Trim();
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@sex", SqlDbType.VarChar, 50)); 
					m_sqjUpdateCommand.Parameters["@sex"].Value=""+((string)m_SexCombo.Items[m_SexCombo.SelectedIndex]);
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@birthday", SqlDbType.DateTime));
					m_sqjUpdateCommand.Parameters["@birthday"].Value=m_BirthdayDateTime.Value.ToString("d");
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@startworkingtime", SqlDbType.DateTime));
					m_sqjUpdateCommand.Parameters["@startworkingtime"].Value=m_StartWorkDateTime.Value.ToString("d");
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@post", SqlDbType.VarChar, 50));
					m_sqjUpdateCommand.Parameters["@post"].Value=m_PostText.Text.Trim();
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@username", SqlDbType.VarChar, 50));
					m_sqjUpdateCommand.Parameters["@username"].Value=m_UserText.Text.Trim();
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@priority", SqlDbType.VarChar, 50));
					m_sqjUpdateCommand.Parameters["@priority"].Value=""+m_PriorityCombo.SelectedIndex;
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@password", SqlDbType.VarChar, 50));
					m_sqjUpdateCommand.Parameters["@password"].Value=m_PasswordText.Text.Trim();	
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@employeeID", SqlDbType.VarChar, 50));
					m_sqjUpdateCommand.Parameters["@employeeID"].Value=m_IDText.Text.Trim();	
					try
					{
						m_sqjUpdateCommand.Connection.Open();
						m_sqjUpdateCommand.ExecuteNonQuery();
						m_sqjUpdateCommand.Connection.Close();
						MessageBox.Show(this,"已经成功修改该员工的信息！","正确");
					}
					catch (SqlException e1)
					{
						MessageBox.Show(this,e1.Message,"错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
					}
				}
				else
				{
					//添加
					SqlCommand m_sqlInsertCommand=new SqlCommand();
					m_sqlDataAdapter.InsertCommand=m_sqlInsertCommand;
					m_sqlInsertCommand.Connection=m_Connection;
					m_sqlInsertCommand.CommandText="insert into Employee (EmployeeName,sex,birthday,startworkingtime,username,title,priority,password) values (@name,@sex,@birthday,@startworkingtime,@username,@post,@priority,@password)";
					m_sqlInsertCommand.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar, 50)); 
					m_sqlInsertCommand.Parameters["@name"].Value=m_NameText.Text.Trim();
					m_sqlInsertCommand.Parameters.Add(new SqlParameter("@sex", SqlDbType.VarChar, 50)); 
					m_sqlInsertCommand.Parameters["@sex"].Value=""+((string)m_SexCombo.Items[m_SexCombo.SelectedIndex]);
					m_sqlInsertCommand.Parameters.Add(new SqlParameter("@birthday", SqlDbType.DateTime));
					m_sqlInsertCommand.Parameters["@birthday"].Value=m_BirthdayDateTime.Value.ToString("d");
					m_sqlInsertCommand.Parameters.Add(new SqlParameter("@startworkingtime", SqlDbType.DateTime));
					m_sqlInsertCommand.Parameters["@startworkingtime"].Value=m_StartWorkDateTime.Value.ToString("d");
					m_sqlInsertCommand.Parameters.Add(new SqlParameter("@post", SqlDbType.VarChar, 50));
					m_sqlInsertCommand.Parameters["@post"].Value=m_PostText.Text.Trim();
					m_sqlInsertCommand.Parameters.Add(new SqlParameter("@username", SqlDbType.VarChar, 50));
					m_sqlInsertCommand.Parameters["@username"].Value=m_UserText.Text.Trim();
					m_sqlInsertCommand.Parameters.Add(new SqlParameter("@priority", SqlDbType.VarChar, 50));
					m_sqlInsertCommand.Parameters["@priority"].Value=""+m_PriorityCombo.SelectedIndex;
					m_sqlInsertCommand.Parameters.Add(new SqlParameter("@password", SqlDbType.VarChar, 50));
					m_sqlInsertCommand.Parameters["@password"].Value=m_PasswordText.Text.Trim();	
					try
					{
						m_sqlInsertCommand.Connection.Open();
						m_sqlInsertCommand.ExecuteNonQuery();
						m_sqlInsertCommand.Connection.Close();
						MessageBox.Show(this,"已经成功插入一条员工记录！","正确");
					}
					catch (SqlException e1)
					{
						MessageBox.Show(this,e1.Message,"错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
					}
				}
				m_CancelButton_Click(sender,e);
			}
		}

		private bool checkInput()
		{
			//检验用户的输入是否合法
			bool isvalid=false;
			if (m_NameText.Text.Trim().Equals(""))
			{
				MessageBox.Show(this,"员工的名字不能为空！","错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
				m_NameText.Focus();
			}
			else
			{
				if (m_BirthdayDateTime.Value.ToString("d").CompareTo(m_StartWorkDateTime.Value.ToString("d"))>=0)
				{
					MessageBox.Show(this,"员工的开始工作时间输入有误，只能大于出生日期！","错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
					m_StartWorkDateTime.Focus();
				}
				else
				{
					if (m_PostText.Text.Trim().Equals(""))
					{
						MessageBox.Show(this,"员工的职称不能为空！","错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
						m_PostText.Focus();
					}
					else
					{
						if(m_UserText.Text.Trim().Equals(""))
						{
							MessageBox.Show(this,"员工的用户名不能为空！","错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
							m_PasswordText.Focus();
						}
						else
						{
							if(m_PasswordText.Text.Trim().Equals(""))
							{
								MessageBox.Show(this,"员工的密码不能为空！","错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
								m_PasswordText.Focus();
							}
							else
							{
								isvalid=true;
							}
						}
					}
				}
			}
			return isvalid;
		}
	}
}