linkmanmanage.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 linkmanManage
	{
		/// <summary>
		/// 新增联系人资料
		/// </summary>
		/// <param name="ada_linkman"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void addlinkman(System.Data.OleDb.OleDbDataAdapter ada_linkman,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{
			linker l_add = new linker();
			l_add.ShowDialog();
			if(l_add.lsubmit.BackColor == Color.GreenYellow)
			{
				try
				{			
					ada_linkman.InsertCommand.CommandText = 
						"INSERT INTO Linkman (LinkmanID,LinkmanName,LinkmanSex,LBirthday,"+
						"LDepartment,LDuty,LTitle,LWorkPhone,LCellPhone,LHomePhone,"+
						"LOtherPhone,LFax,LEmail,LCharacter,LFavorite,LNote,ClientID"+
						" ) VALUES ( '" + 
						l_add.LinkmanID.Text + "','"+
						l_add.LinkmanName.Text + "','"+
						l_add.LinkmanSex.Text + "','"+
						l_add.LBirthday.Text + "','"+
						l_add.LDepartment.Text + "','"+
						l_add.LDuty.Text + "','"+
						l_add.LTitle.Text + "','"+
						l_add.LWorkPhone.Text + "','"+
						l_add.LCellPhone.Text + "','"+
						l_add.LHomePhone.Text + "','"+
						l_add.LOtherPhone.Text + "','"+
						l_add.LFax.Text + "','"+
						l_add.LEmail.Text + "','"+
						l_add.LCharacter.Text + "','"+
						l_add.LFavorite.Text + "','"+
						l_add.LNote.Text + "','"+
						l_add.ClientID.Text + "')";

						ada_linkman.InsertCommand.ExecuteNonQuery();					//执行Insert语句
					dset.Clear(); 
					ada_linkman.Fill(dset);
					dgrid.DataSource=dset.Tables["Linkman"];
				}
				catch(System.Exception ie)
				{
					MessageBox.Show(ie.Message);
				}
			}
		}
		
		/// <summary>
		/// 查询联系人资料
		/// </summary>
		/// <param name="ada_linkman"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>

		public void searchlinkman(System.Data.OleDb.OleDbDataAdapter ada_linkman,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{
			linker l_search = new linker();
			l_search.LBirthday.Enabled = false;
			l_search.LWorkPhone.Enabled = false;
			l_search.LCellPhone.Enabled = false;
			l_search.LHomePhone.Enabled = false;
			l_search.LOtherPhone.Enabled = false;
			l_search.LFax.Enabled = false;
			l_search.LEmail.Enabled = false;
			l_search.LCharacter.Enabled = false;
			l_search.LFavorite.Enabled = false;
			l_search.LNote.Enabled = false;
			l_search.ShowDialog();

			if(l_search.lsubmit.BackColor == Color.GreenYellow)
			{
				try
				{
					if(l_search.LinkmanID.Text == "" && l_search.LinkmanName.Text == "" && l_search.LinkmanSex.Text 
						== "" && l_search.LDepartment.Text == "" && l_search.LDuty.Text == "" 
						&& l_search.LTitle.Text == "" && l_search.ClientID.Text == "")
						ada_linkman.SelectCommand.CommandText = "SELECT * FROM Linkman";
					else
					{
						int i = 0;
						String cmdstr = "SELECT * FROM Linkman WHERE ";
						if(l_search.LinkmanID.Text != "")
						{
							i++;
							cmdstr +=  "LinkmanID='"+l_search.LinkmanID.Text +"'";
						}
						if(l_search.LinkmanName.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "LinkmanName='"+l_search.LinkmanName.Text +"'";
						}
						if(l_search.LinkmanSex.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "LinkmanSex='"+l_search.LinkmanSex.Text +"'";
						}
						if(l_search.LDepartment.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "LDepartment='"+l_search.LDepartment.Text +"'";
						}
						if(l_search.LDuty.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "LDuty='"+l_search.LDuty.Text +"'";
						}
						if(l_search.LTitle.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "LTitle='"+l_search.LTitle.Text +"'";
						}
						if(l_search.ClientID.Text != "")
						{
							if( i>0 ) cmdstr += " AND ";
							i++;
							cmdstr +=  "ClientID='"+l_search.ClientID.Text +"'";
						}

						ada_linkman.SelectCommand.CommandText = cmdstr;
					}

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

		/// <summary>
		/// 删除联系人资料
		/// </summary>
		/// <param name="ada_linkman"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void deletelinkman(System.Data.OleDb.OleDbDataAdapter ada_linkman,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{			
			try
			{
				int i = dgrid.CurrentCell.RowNumber;
				int id = (int)dset.Tables["Linkman"].Rows[i]["LinkmanID"];

				DialogResult Result;
				Result = MessageBox.Show("确定要删除ID号为"+id+"的联系人吗？",
					"警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning,MessageBoxDefaultButton.Button2);
				if(Result == DialogResult.Yes) 
				{
					ada_linkman.DeleteCommand.CommandText="DELETE FROM Linkman WHERE LinkmanID = '"+id+"'";
					ada_linkman.DeleteCommand.ExecuteNonQuery();

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

		/// <summary>
		/// 修改联系人资料
		/// </summary>
		/// <param name="ada_linkman"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void modifylinkman(System.Data.OleDb.OleDbDataAdapter ada_linkman,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{
			int i = dgrid.CurrentCell.RowNumber;

			linker l_modify = new linker();
			l_modify.LinkmanID.Text = ""+(int)dset.Tables["Linkman"].Rows[i]["LinkmanID"];
			l_modify.LinkmanID.Enabled = false;
			l_modify.lreset.Enabled = false;
			l_modify.LinkmanName.Text = ""+dset.Tables["Linkman"].Rows[i]["LinkmanName"];
			l_modify.LinkmanSex.Text = ""+dset.Tables["Linkman"].Rows[i]["LinkmanSex"];
			l_modify.LBirthday.Text = ""+dset.Tables["Linkman"].Rows[i]["LBirthday"];
			l_modify.LDepartment.Text = ""+dset.Tables["Linkman"].Rows[i]["LDepartment"];
			l_modify.LDuty.Text = ""+dset.Tables["Linkman"].Rows[i]["LDuty"];
			l_modify.LTitle.Text = ""+dset.Tables["Linkman"].Rows[i]["LTitle"];
			l_modify.LWorkPhone.Text = ""+dset.Tables["Linkman"].Rows[i]["LWorkPhone"];
			l_modify.LCellPhone.Text = ""+dset.Tables["Linkman"].Rows[i]["LCellPhone"];
			l_modify.LHomePhone.Text = ""+dset.Tables["Linkman"].Rows[i]["LHomePhone"];
			l_modify.LFax.Text = ""+dset.Tables["Linkman"].Rows[i]["LFax"];
			l_modify.LEmail.Text = ""+dset.Tables["Linkman"].Rows[i]["LEmail"];
			l_modify.LCharacter.Text = ""+dset.Tables["Linkman"].Rows[i]["LCharacter"];
			l_modify.LFavorite.Text = ""+dset.Tables["Linkman"].Rows[i]["LFavorite"];
			l_modify.LNote.Text = ""+dset.Tables["Linkman"].Rows[i]["LNote"];
			l_modify.ClientID.Text = ""+dset.Tables["Linkman"].Rows[i]["ClientID"];

			l_modify.ShowDialog();
			if(l_modify.lsubmit.BackColor == Color.GreenYellow)
			{
				try
				{		
					ada_linkman.UpdateCommand.CommandText = "UPDATE Linkman SET " +
						"LinkmanName = '"+l_modify.LinkmanName.Text + 
						"',LinkmanSex = '"+l_modify.LinkmanSex.Text + 
						"',LBirthday = '"+l_modify.LBirthday.Text + 
						"',LDepartment = '"+l_modify.LDepartment.Text + 
						"',LDuty = '"+l_modify.LDuty.Text + 
						"',LTitle = '"+l_modify.LTitle.Text + 
						"',LWorkPhone = '"+l_modify.LWorkPhone.Text + 
						"',LCellPhone = '"+l_modify.LCellPhone.Text + 
						"',LHomePhone = '"+l_modify.LHomePhone.Text +
						"',LFax = '"+l_modify.LFax.Text +
						"',LEmail = '"+l_modify.LEmail.Text +
						"',LCharacter = '"+l_modify.LCharacter.Text +
						"',LFavorite = '"+l_modify.LFavorite.Text +
						"',LNote = '"+l_modify.LNote.Text +
						"' WHERE LinkmanID = "+l_modify.LinkmanID.Text;

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

		/// <summary>
		/// 初始化设置联系人生日提醒
		/// </summary>
		/// <param name="ada_linkman"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		public void setremind(System.Data.OleDb.OleDbDataAdapter ada_linkman,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid)
		{
			int i = dgrid.CurrentCell.RowNumber;

			if(((""+dset.Tables["Linkman"].Rows[i]["LBirthday"]) == "1900-1-1 0:00:00" )||
				((""+dset.Tables["Linkman"].Rows[i]["LBirthday"]) == "" ))
			{
				MessageBox.Show("Please Modify this Linkman's Birthday!");
				return;
			}

			remind_linkman rel = new remind_linkman ();
			
			rel.LinkmanID.Text = ""+(int)dset.Tables["Linkman"].Rows[i]["LinkmanID"];
			rel.LinkmanID.Enabled = false;
			rel.ShowDialog();

			if(rel.rlsubmit.BackColor == Color.GreenYellow)
			{
				double PreRemind = Double.Parse(""+rel.PreRemind.Text);
				undateremind(ada_linkman, dset, dgrid, PreRemind, dgrid.CurrentCell.RowNumber);
				remindlinkman(ada_linkman, dset, dgrid, false);	
			}

		}

		/// <summary>
		/// 更新联系人生日距期
		/// </summary>
		/// <param name="ada_linkman"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		/// <param name="PreRemind"></param>		//提前多少天提醒，-1表示用原值
		/// <param name="i"></param>				//更新哪个？
		public void undateremind(System.Data.OleDb.OleDbDataAdapter ada_linkman,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, double  PreRemind, int i)
		{
			try
			{	
				DateTime targetday = new DateTime();
				targetday = (DateTime)(dset.Tables["Linkman"].Rows[i]["LBirthday"]);
				DateTime today = new DateTime ();
				today = DateTime.Now;

				int tyear = today.Year;
				if(targetday.Month < today.Month || (targetday.Month == today.Month && targetday.Day < today.Day) )
					tyear += 1;

				DateTime ttarday = new DateTime (tyear, targetday.Month, targetday.Day);
				string UptoRemind = ""+(ttarday.Date-today.Date);
				UptoRemind = UptoRemind.Substring(0, UptoRemind.IndexOf(":"));
				double utRemind = Double.Parse(UptoRemind);

				string str= "UPDATE Linkman SET " +
					"UptoRemind = '"+utRemind; 
				
				if(PreRemind != -1)  str = str + "',PreRemind = '"+PreRemind;
				
				str += "' WHERE LinkmanID = "+dset.Tables["Linkman"].Rows[i]["LinkmanID"];
				
				ada_linkman.UpdateCommand.CommandText = str;
				ada_linkman.UpdateCommand.ExecuteNonQuery();					
				dset.Clear(); 
				ada_linkman.Fill(dset);
				dgrid.DataSource=dset.Tables["Linkman"];

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

		}

		/// <summary>
		/// 联系人生日提醒显示
		/// </summary>
		/// <param name="ada_linkman"></param>
		/// <param name="dset"></param>
		/// <param name="dgrid"></param>
		/// <param name="ifupdate"></param>			//要不要更新距期
		public void remindlinkman(System.Data.OleDb.OleDbDataAdapter ada_linkman,
			System.Data.DataSet dset, System.Windows.Forms.DataGrid dgrid, bool ifupdate)
		{
			int count = 0;
			try
			{
				while(dset.Tables["Linkman"].Rows[count]["LinkmanID"] != null)
				{
					count++;
				}
			}
			catch(System.IndexOutOfRangeException)
			{
				for(int i=0; i<count; i++)
				{
					if( ifupdate )
						undateremind(ada_linkman, dset, dgrid, -1, i);
					if(""+dset.Tables["Linkman"].Rows[i]["PreRemind"] != "" &&
						""+dset.Tables["Linkman"].Rows[i]["UptoRemind"] != "" &&
						(Double.Parse(""+dset.Tables["Linkman"].Rows[i]["PreRemind"]) >= 
						Double.Parse(""+dset.Tables["Linkman"].Rows[i]["UptoRemind"])))
					{
						
						/*将对应的行变成红色*/
						dgrid.SelectionBackColor = Color.Red;
						dgrid.Select(i);
						MessageBox.Show("提醒: ID为 "+dset.Tables["Linkman"].Rows[i]["LinkmanID"]+" 的联系人"+
							"还有 "+dset.Tables["Linkman"].Rows[i]["UptoRemind"]+" 天生日!");	
						
					}
						
				}

			}

		}
	}
}