customermanageform.cs

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

			System.Data.DataRow dr;
			dt.Columns.Add(new System.Data.DataColumn("name"));
			dt.Columns.Add(new System.Data.DataColumn("contact"));
			dt.Columns.Add(new System.Data.DataColumn("remark"));
			getCustomerList();
			for (int i=0;i<customerList.Count;i++)
				//for (int i = 0; i<3; i++) 
			{
				Customer m_customer;
				m_customer=(Customer)customerList[i];
				dr = dt.NewRow();
				dr[0] = m_customer.Customername;
				dr[1] = m_customer.Contactway;
				dr[2] = m_customer.Remark;
				dt.Rows.Add(dr);
			}
			System.Data.DataView dv = new System.Data.DataView(dt);
			m_CustomerDataGrid.DataSource=dv;			
			previousRowNumber=m_CustomerDataGrid.CurrentCell.RowNumber;
			if (!(customerList==null||customerList.Count==0))
			{
				m_NameText.Text=(string)dt.Rows[0][0];
				m_ContactText.Text=(string)dt.Rows[0][1];
				m_RemarkText.Text=(string)dt.Rows[0][1];
				m_IDText.Text=""+((Customer)customerList[0]).Customerid;
			}
			else
			{	
				m_IDText.Text="";
				m_ModifyButton.Enabled=false;
				m_DeleteButton.Enabled=false;
			}
		}

		private void getCustomerList()
		{
			customerList=new ArrayList();
			int rowCount;
			//从数据库读取员工数据
			System.Data.DataSet m_DataSet=new DataSet();
			SqlCommand m_sqlSelectCommand=new SqlCommand();
			m_sqlDataAdapter.SelectCommand=m_sqlSelectCommand;
			m_sqlSelectCommand.CommandText="select * from Guest";
			m_sqlSelectCommand.Connection=m_Connection;
			try
			{
				m_Connection.Open();	
			}
			catch (SqlException e1)
			{
				MessageBox.Show(this,e1.Message,"数据库连接错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
			}
			m_sqlSelectCommand.ExecuteNonQuery();
			m_DataSet=new System.Data.DataSet();			
			//填充m_DataSet
			m_sqlDataAdapter.Fill(m_DataSet);				
			DataTable m_DataTable=m_DataSet.Tables[0];
			rowCount=m_DataTable.Rows.Count;
			//将数据放入ArrayList中
			for (int i=0;i<rowCount;i++)
			{
				Customer m_customer=new Customer();
				try
				{
					m_customer.Customerid=Int32.Parse(((Int32)m_DataTable.Rows[i]["GuestID"]).ToString());
					m_customer.Customername=(string)m_DataTable.Rows[i]["GuestName"];
					m_customer.Contactway=(string)m_DataTable.Rows[i]["Contract"];
					m_customer.Remark=(string)m_DataTable.Rows[i]["Remark"];
					customerList.Add(m_customer);
				}
				catch(Exception e2)
				{
					MessageBox.Show(this,e2.Message,"类型转换错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
				}
			}
			m_Connection.Close();
		}

		private void m_AddButton_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_NameText.Text="";
			m_ContactText.Text="";
			m_ContactText.ReadOnly=false;
			m_RemarkText.Text="";
			m_RemarkText.ReadOnly=false;
			m_IDText.Text="";
		}

		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_ContactText.ReadOnly=false;
			m_RemarkText.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 Guest where GuestID="+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("contact"));
				dt.Columns.Add(new System.Data.DataColumn("remark"));
				getCustomerList();
				for (int i=0;i<customerList.Count;i++)
					//for (int i = 0; i<3; i++) 
				{
					Customer m_customer;
					m_customer=(Customer)customerList[i];
					dr = dt.NewRow();
					dr[0] = m_customer.Customername;
					dr[1] = m_customer.Contactway;
					dr[2] = m_customer.Remark;
					dt.Rows.Add(dr);
				}
				System.Data.DataView dv = new System.Data.DataView(dt);
				m_CustomerDataGrid.DataSource=dv;			
				previousRowNumber=m_CustomerDataGrid.CurrentCell.RowNumber;	
				if (!(customerList==null||customerList.Count==0))
				{
					m_NameText.Text=(string)m_CustomerDataGrid[m_CustomerDataGrid.CurrentCell.RowNumber,0];
					m_ContactText.Text=(string)m_CustomerDataGrid[m_CustomerDataGrid.CurrentCell.RowNumber,1];
					m_RemarkText.Text=(string)m_CustomerDataGrid[m_CustomerDataGrid.CurrentCell.RowNumber,2];
					m_ContactText.ReadOnly=true;
					m_NameText.ReadOnly=true;
					m_RemarkText.ReadOnly=true;
					m_IDText.Text=""+((Customer)customerList[0]).Customerid;		
					m_ModifyButton.Enabled=true;
					m_DeleteButton.Enabled=true;	
				}	
				else
				{
					m_NameText.Text="";
					m_ContactText.Text="";
					m_RemarkText.Text="";
					m_NameText.ReadOnly=true;
					m_ContactText.ReadOnly=true;
					m_RemarkText.ReadOnly=true;
					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 Guest set GuestName=@name,Contract=@contract,Remark=@remark where GuestID=@guestID";
					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("@contract", SqlDbType.VarChar, 50));
					m_sqjUpdateCommand.Parameters["@contract"].Value=m_ContactText.Text.Trim();
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@remark", SqlDbType.VarChar, 200));
					m_sqjUpdateCommand.Parameters["@remark"].Value=m_RemarkText.Text.Trim();
					m_sqjUpdateCommand.Parameters.Add(new SqlParameter("@guestID", SqlDbType.VarChar, 200));
					m_sqjUpdateCommand.Parameters["@guestID"].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 Guest (GuestName,Contract,Remark) values (@name,@contract,@remark)";
					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("@contract", SqlDbType.VarChar, 50));
					m_sqlInsertCommand.Parameters["@contract"].Value=m_ContactText.Text.Trim();
					m_sqlInsertCommand.Parameters.Add(new SqlParameter("@remark", SqlDbType.VarChar, 200));
					m_sqlInsertCommand.Parameters["@remark"].Value=m_RemarkText.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 void m_CancelButton_Click(object sender, System.EventArgs e)
		{
			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("contact"));
			dt.Columns.Add(new System.Data.DataColumn("remark"));
			getCustomerList();
			for (int i=0;i<customerList.Count;i++)
				//for (int i = 0; i<3; i++) 
			{
				Customer m_customer;
				m_customer=(Customer)customerList[i];
				dr = dt.NewRow();
				dr[0] = m_customer.Customername;
				dr[1] = m_customer.Contactway;
				dr[2] = m_customer.Remark;
				dt.Rows.Add(dr);
			}
			System.Data.DataView dv = new System.Data.DataView(dt);
			m_CustomerDataGrid.DataSource=dv;			
			previousRowNumber=m_CustomerDataGrid.CurrentCell.RowNumber;	
			if (!(customerList==null||customerList.Count==0))
			{
				m_NameText.Text=(string)m_CustomerDataGrid[m_CustomerDataGrid.CurrentCell.RowNumber,0];
				m_ContactText.Text=(string)m_CustomerDataGrid[m_CustomerDataGrid.CurrentCell.RowNumber,1];
				m_RemarkText.Text=(string)m_CustomerDataGrid[m_CustomerDataGrid.CurrentCell.RowNumber,2];
				m_ContactText.ReadOnly=true;
				m_NameText.ReadOnly=true;
				m_RemarkText.ReadOnly=true;
				m_IDText.Text=""+((Customer)customerList[0]).Customerid;		
				m_ModifyButton.Enabled=true;
				m_DeleteButton.Enabled=true;	
			}	
			else
			{
				m_NameText.Text="";
				m_ContactText.Text="";
				m_RemarkText.Text="";
				m_NameText.ReadOnly=true;
				m_ContactText.ReadOnly=true;
				m_RemarkText.ReadOnly=true;
				m_ModifyButton.Enabled=false;
				m_DeleteButton.Enabled=false;
			}
			m_AddButton.Enabled=true;
			m_CancelButton.Enabled=false;
			m_OKButton.Enabled=false;
		}
		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_ContactText.Text.Trim().Equals(""))
				{
					MessageBox.Show(this,"客户的联系方式不能为空！","错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
					m_ContactText.Focus();
				}
				else
				{
					isvalid=true;
				}
			}
			return isvalid;
		}
	}
}