clientmanage.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 clientManage
	{
		/// <summary>
		/// 新增客户资料
		/// </summary>
		/// <param name="ada_client"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void addclient(System.Data.OleDb.OleDbDataAdapter ada_client,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{
			client c_add = new client();
			c_add.ShowDialog();
			if(c_add.csubmit.BackColor == Color.GreenYellow)
			{
				try
				{		
					//int i = Convert.ChangeType(c_add.ClientID.Text,System.Int32);
					/*int i = System.Int32.Parse(c_add.ClientID.Text);
					ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter(@ClientID,i));
					ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter(@ClientName,c_add.ClientName.Text));
                    ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@Industry",c_add.Industry.Text));
					ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@MainDirector",c_add.MainDirector.Text));
					ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@Area",c_add.Area.Text));
					ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@Location",c_add.Location.Text));
					ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@PostalCode",c_add.PostalCode.Text));
					ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@WebSite",c_add.WebSite.Text));
					ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@ProductName",c_add.ProductName.Text));
					ada_client.InsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@Note",c_add.Note.Text));
                    */
					/*ada_client.InsertCommand.Parameters["@ClientID"].Value=c_add.ClientID.Text;
					ada_client.InsertCommand.Parameters["@ClientName"].Value=c_add.ClientName.Text;
					ada_client.InsertCommand.Parameters["@Industry"].Value=c_add.Industry.Text;
					ada_client.InsertCommand.Parameters["@MainDirector"].Value=c_add.MainDirector.Text;
					ada_client.InsertCommand.Parameters["@Area"].Value=c_add.Area.Text;
					ada_client.InsertCommand.Parameters["@Location"].Value=c_add.Location.Text;
					ada_client.InsertCommand.Parameters["@PostalCode"].Value=c_add.PostalCode.Text;
					ada_client.InsertCommand.Parameters["@WebSite"].Value=c_add.WebSite.Text;
					ada_client.InsertCommand.Parameters["@ProductName"].Value=c_add.ProductName.Text;
					ada_client.InsertCommand.Parameters["@Note"].Value=c_add.Note.Text;
					
					ada_client.InsertCommand.CommandText = "INSERT INTO Client (" +
						"ClientID, ClientName, Industry, MainDirector, Area, Location, PostalCode,"+
						" WebSite, ProductName, Note" + " ) VALUES (333,@ClientName,"+
						"'@Industry','@MainDirector','@Area','@Location','@PostalCode',"+
						"'@WebSite','@ProductName','@Note')";*/
					
					ada_client.InsertCommand.CommandText = "INSERT INTO Client (" +
						"ClientID, ClientName, Industry, MainDirector, Area, Location, PostalCode,"+
						" WebSite, ProductName, Note" + " ) VALUES ( '"+
						c_add.ClientID.Text + "','"+
						c_add.ClientName.Text + "','"+
						c_add.Industry.Text + "','"+
						c_add.MainDirector.Text + "','"+
						c_add.Area.Text + "','"+
						c_add.Location.Text + "','"+
						c_add.PostalCode.Text + "','"+
						c_add.WebSite.Text + "','"+
						c_add.ProductName.Text + "','"+
						c_add.Note.Text + "')";

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

		/// <summary>
		/// 查询客户资料
		/// </summary>
		/// <param name="ada_client"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void searchclient(System.Data.OleDb.OleDbDataAdapter ada_client,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{
			client c_search = new client();
			c_search.Location.Enabled = false;
			c_search.PostalCode.Enabled = false;
			c_search.WebSite.Enabled = false;
			c_search.ProductName.Enabled = false;
			c_search.Note.Enabled = false;
			c_search.ShowDialog();

			if(c_search.csubmit.BackColor == Color.GreenYellow)
			{
				try
				{
					if(c_search.ClientID.Text == "" && c_search.ClientName.Text == "" && c_search.Industry.Text 
						== "" && c_search.MainDirector.Text == "" && c_search.Area.Text == "")
						ada_client.SelectCommand.CommandText = "SELECT * FROM Client";
					else
					{
						int i = 0;
						String cmdstr = "SELECT * FROM Client WHERE ";
						if(c_search.ClientID.Text != "")
						{
							i++;
							cmdstr +=  "ClientID='"+c_search.ClientID.Text +"'";
						}
						if(c_search.ClientName.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "ClientName='"+c_search.ClientName.Text +"'";
						}
						if(c_search.Industry.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "Industry='"+c_search.Industry.Text +"'";
						}
						if(c_search.MainDirector.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "MainDirector='"+c_search.MainDirector.Text +"'";
						}
						if(c_search.Area.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "Area='"+c_search.Area.Text +"'";
						}
							
						ada_client.SelectCommand.CommandText = cmdstr;
					}

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

		/// <summary>
		/// 删除客户资料
		/// </summary>
		/// <param name="ada_client"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void deleteclient(System.Data.OleDb.OleDbDataAdapter ada_client,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{
			try
			{
				int i = dgrid.CurrentCell.RowNumber;
				int id = (int)dset.Tables["Client"].Rows[i]["ClientID"];

				DialogResult Result;
				Result = MessageBox.Show("确定要删除ID号为"+id+"的客户吗？",
					"警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning,MessageBoxDefaultButton.Button2);
				if(Result == DialogResult.Yes) 
				{
					ada_client.DeleteCommand.CommandText="DELETE FROM Client WHERE ClientID = '"+id+"'";
					ada_client.DeleteCommand.ExecuteNonQuery();

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

		}

		/// <summary>
		/// 修改客户资料
		/// </summary>
		/// <param name="ada_client"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void modifyclient(System.Data.OleDb.OleDbDataAdapter ada_client,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{
			int i = dgrid.CurrentCell.RowNumber;

			client c_modify = new client();
			c_modify.ClientID.Text = ""+(int)dset.Tables["Client"].Rows[i]["ClientID"];
			c_modify.ClientID.Enabled = false;
			c_modify.creset.Enabled = false;
			c_modify.ClientName.Text = (string)dset.Tables["Client"].Rows[i]["ClientName"];
			c_modify.Industry.Text = (string)dset.Tables["Client"].Rows[i]["Industry"];
			c_modify.MainDirector.Text = (string)dset.Tables["Client"].Rows[i]["MainDirector"];
			c_modify.Area.Text = (string)dset.Tables["Client"].Rows[i]["Area"];
			c_modify.Location.Text = (string)dset.Tables["Client"].Rows[i]["Location"];
			c_modify.PostalCode.Text = (string)dset.Tables["Client"].Rows[i]["PostalCode"];
			c_modify.WebSite.Text = (string)dset.Tables["Client"].Rows[i]["WebSite"];
			c_modify.ProductName.Text = (string)dset.Tables["Client"].Rows[i]["ProductName"];
			c_modify.Note.Text = (string)dset.Tables["Client"].Rows[i]["Note"];

			c_modify.ShowDialog();
			if(c_modify.csubmit.BackColor == Color.GreenYellow)
			{
				try
				{		
					ada_client.UpdateCommand.CommandText = "UPDATE Client SET " +
						"ClientName = '"+c_modify.ClientName.Text + 
						"',Industry = '"+c_modify.Industry.Text + 
						"',MainDirector = '"+c_modify.MainDirector.Text + 
						"',Area = '"+c_modify.Area.Text + 
						"',Location = '"+c_modify.Location.Text + 
						"',PostalCode = '"+c_modify.PostalCode.Text + 
						"',WebSite = '"+c_modify.WebSite.Text + 
						"',ProductName = '"+c_modify.ProductName.Text + 
						"',Note = '"+c_modify.Note.Text +
						"' WHERE ClientID = "+c_modify.ClientID.Text;

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

		}

	}
}