salermanage.cs

软件工程的课程作业

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

namespace PSMS
{
	/// <summary>
	/// 销售人员资料管理类
	/// </summary>
	public class salerManage
	{
		/// <summary>
		/// 新增销售人员
		/// </summary>
		/// <param name="ada_saler"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void addsaler(System.Data.OleDb.OleDbDataAdapter ada_saler,
						System.Data.OleDb.OleDbDataAdapter ada_user,
						System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, int popedom)
		{
			saler s_add = new saler();
			if( popedom == 0 ) 
			{
				s_add.SalerDuty.Text = "部门经理";
				s_add.SalerDuty.Enabled = false;
			}
			s_add.ShowDialog();
			if(s_add.ssubmit.BackColor == Color.GreenYellow)
			{
				try
				{

					
					int newpod = 1;
					if(s_add.SalerDuty.Text == "部门经理") newpod = 1;
					else if(s_add.SalerDuty.Text == "销售经理") newpod++;
					else if(s_add.SalerDuty.Text == "销售助理") newpod = 3;
					else newpod = 4;
					ada_user.InsertCommand.CommandText = 
						"INSERT INTO Users (UserID,Username,UserPwd,Popedom "+
						" ) VALUES ( '"+
						s_add.SalerAcount.Text + "','" +
						s_add.SalerName.Text + "','" +
						s_add.SalerPwd.Text + "','" +
						newpod + "')" ;
					ada_user.InsertCommand.ExecuteNonQuery();

					ada_saler.InsertCommand.CommandText =
						"INSERT INTO Saler (SalerID,SalerName,SalerSex,SalerBirthday,SalerDuty,"+
						"SalerLevel,SalerAcount,SalerPwd,SWorkPhone,SCellPhone,SHomePhone,"+
						"SOtherPhone,SEmail,OnDuty,OffDuty,SNote "+
						" ) VALUES ( '"+
						s_add.SalerID.Text + "','" +
						s_add.SalerName.Text + "','" +
						s_add.SalerSex.Text + "','" +
						s_add.SalerBirthday.Text + "','" +
						s_add.SalerDuty.Text + "','" +
						s_add.SalerLevel.Text + "','" +
						s_add.SalerAcount.Text + "','" +
						s_add.SalerPwd.Text + "','" +
						s_add.SWorkPhone.Text + "','" +
						s_add.SCellPhone.Text + "','" +
						s_add.SHomePhone.Text + "','" +
						s_add.SOtherPhone.Text + "','" +
						s_add.SEmail.Text + "','" +
						s_add.OnDuty.Text + "','" +
						s_add.OffDuty.Text + "','" +
						s_add.SNote.Text + "')" ;

					ada_saler.InsertCommand.ExecuteNonQuery();					//执行Insert语句
					dset.Clear(); 
					ada_saler.Fill(dset);
					dgrid.DataSource=dset.Tables["Saler"];


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

		/// <summary>
		/// 查询销售人员
		/// </summary>
		/// <param name="ada_saler"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void searchsaler(System.Data.OleDb.OleDbDataAdapter ada_saler,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, int popedom)
		{
			saler s_search = new saler();
			if( popedom == 0 ) 
			{
				s_search.SalerDuty.Text = "部门经理";
				s_search.SalerDuty.Enabled = false;
			}
			s_search.SalerBirthday.Enabled = false;
			s_search.SalerAcount.Enabled = false;
			s_search.SalerPwd.Enabled = false;
			s_search.SWorkPhone.Enabled = false;
			s_search.SCellPhone.Enabled = false;
			s_search.SHomePhone.Enabled = false;
			s_search.SOtherPhone.Enabled = false;
			s_search.SEmail.Enabled = false;
			s_search.SNote.Enabled = false;
			s_search.ShowDialog();		

			if(s_search.ssubmit.BackColor == Color.GreenYellow)
			{
				try
				{
					if(s_search.SalerID.Text == "" && s_search.SalerName.Text == "" && s_search.SalerSex.Text 
						== "" && s_search.SalerDuty.Text == "" && s_search.SalerLevel.Text == ""
						&& s_search.OnDuty.Text == "" && s_search.OffDuty.Text == "")
						ada_saler.SelectCommand.CommandText = "SELECT * FROM Saler";
					else
					{
						int i = 0;
						String cmdstr = "SELECT * FROM Saler WHERE ";
						if(s_search.SalerID.Text != "")
						{
							i++;
							cmdstr +=  "SalerID='"+s_search.SalerID.Text +"'";
						}
						if(s_search.SalerName.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "SalerName='"+s_search.SalerName.Text +"'";
						}
						if(s_search.SalerSex.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "SalerSex='"+s_search.SalerSex.Text +"'";
						}
						if(s_search.SalerDuty.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "SalerDuty='"+s_search.SalerDuty.Text +"'";
						}
						if(s_search.SalerLevel.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "SalerLevel='"+s_search.SalerLevel.Text +"'";
						}
						if(s_search.OnDuty.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "OnDuty='"+s_search.OnDuty.Text +"'";
						}
						if(s_search.OffDuty.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "OffDuty='"+s_search.OffDuty.Text +"'";
						}
							
						ada_saler.SelectCommand.CommandText = cmdstr;
					}

					ada_saler.SelectCommand.ExecuteNonQuery();					//执行Insert语句
					dset.Clear(); 
					ada_saler.Fill(dset);
					dgrid.DataSource=dset.Tables["Saler"];
				}
				catch(System.Exception ie)
				{
					MessageBox.Show(ie.Message);
				}
			}	
		}

		/// <summary>
		/// 删除销售人员
		/// </summary>
		/// <param name="ada_saler"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void deletesaler(System.Data.OleDb.OleDbDataAdapter ada_saler,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{
			try
			{
				int i = dgrid.CurrentCell.RowNumber;
				int id = (int)dset.Tables["Saler"].Rows[i]["SalerID"];

				DialogResult Result;
				Result = MessageBox.Show("确定要删除ID号为"+id+"的销售人员吗？",
					"警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning,MessageBoxDefaultButton.Button2);
				if(Result == DialogResult.Yes) 
				{
					ada_saler.DeleteCommand.CommandText="DELETE FROM Saler WHERE SalerID = '"+id+"'";
					ada_saler.DeleteCommand.ExecuteNonQuery();

					dset.Clear(); 
					ada_saler.Fill(dset);
					dgrid.DataSource=dset.Tables["Saler"];
				}
			}
			catch(System.Exception ie)
			{
				MessageBox.Show(ie.Message);
			}
		}

		/// <summary>
		/// 修改销售人员
		/// </summary>
		/// <param name="ada_saler"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void modifysaler(System.Data.OleDb.OleDbDataAdapter ada_saler,
				System.Data.OleDb.OleDbDataAdapter ada_user,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, int popedom)
		{
			int i = dgrid.CurrentCell.RowNumber;

			saler s_modify = new saler();
			if( popedom == 0 ) 
			{
				s_modify.SalerDuty.Text = "部门经理";
				s_modify.SalerDuty.Enabled = false;
			}
			s_modify.SalerID.Text = ""+(int)dset.Tables["Saler"].Rows[i]["SalerID"];
			s_modify.SalerID.Enabled = false;
			s_modify.sreset.Enabled = false;
			s_modify.SalerName.Text = ""+dset.Tables["Saler"].Rows[i]["SalerName"];
			s_modify.SalerSex.Text = ""+dset.Tables["Saler"].Rows[i]["SalerSex"];
			s_modify.SalerBirthday.Text = ""+dset.Tables["Saler"].Rows[i]["SalerBirthday"];
			s_modify.SalerDuty.Text = ""+dset.Tables["Saler"].Rows[i]["SalerDuty"];
			s_modify.SalerLevel.Text = ""+dset.Tables["Saler"].Rows[i]["SalerLevel"];
			s_modify.SalerAcount.Text = ""+dset.Tables["Saler"].Rows[i]["SalerAcount"];
			s_modify.SalerAcount.Enabled = false;
			s_modify.SalerPwd.Text = ""+dset.Tables["Saler"].Rows[i]["SalerPwd"];
			s_modify.SalerPwd.Enabled = false;
			s_modify.SWorkPhone.Text = ""+dset.Tables["Saler"].Rows[i]["SWorkPhone"];
			s_modify.SCellPhone.Text = ""+dset.Tables["Saler"].Rows[i]["SCellPhone"];
			s_modify.SHomePhone.Text = ""+dset.Tables["Saler"].Rows[i]["SHomePhone"];
			s_modify.SOtherPhone.Text = ""+dset.Tables["Saler"].Rows[i]["SOtherPhone"];
			s_modify.SEmail.Text = ""+dset.Tables["Saler"].Rows[i]["SEmail"];
			s_modify.OnDuty.Text = ""+dset.Tables["Saler"].Rows[i]["OnDuty"];
			s_modify.OffDuty.Text = ""+dset.Tables["Saler"].Rows[i]["OffDuty"];
			s_modify.SNote.Text = ""+dset.Tables["Saler"].Rows[i]["SNote"];

			s_modify.ShowDialog();
			if(s_modify.ssubmit.BackColor == Color.GreenYellow)
			{
				try
				{		
					ada_saler.UpdateCommand.CommandText = "UPDATE Saler SET " +
						"SalerName = '"+s_modify.SalerName.Text + 
						"',SalerSex = '"+s_modify.SalerSex.Text + 
						"',SalerBirthday = '"+s_modify.SalerBirthday.Text + 
						"',SalerDuty = '"+s_modify.SalerDuty.Text + 
						"',SalerLevel = '"+s_modify.SalerLevel.Text + 
						"',SalerAcount = '"+s_modify.SalerAcount.Text + 
						"',SalerPwd = '"+s_modify.SalerPwd.Text + 
						"',SWorkPhone = '"+s_modify.SWorkPhone.Text + 
						"',SCellPhone = '"+s_modify.SCellPhone.Text +
						"',SHomePhone = '"+s_modify.SHomePhone.Text +
						"',SOtherPhone = '"+s_modify.SOtherPhone.Text +
						"',SEmail = '"+s_modify.SEmail.Text +
						"',OnDuty = '"+s_modify.OnDuty.Text +
						"',OffDuty = '"+s_modify.OffDuty.Text +
						"',SNote = '"+s_modify.SNote.Text +
						"' WHERE SalerID = "+s_modify.SalerID.Text;

					ada_saler.UpdateCommand.ExecuteNonQuery();					
					dset.Clear(); 
					ada_saler.Fill(dset);
					dgrid.DataSource=dset.Tables["Saler"];
				}
				catch(System.Exception ie)
				{
					MessageBox.Show(ie.Message);
				}
			}
		}
	}
}