getjobinfo.cs

网络人才招聘,系统全面很好,喜欢的朋友拿去

using System;
using System.Data;
using System.Data.SqlClient;
using My.Hr.DbBase;
using System.Collections ;
//该源码下载自www.51aspx.com(５1aｓｐｘ．ｃｏｍ)

namespace My
{
	/// <summary>
	/// Book description for book。
	/// </summary>
	public class GetJobInfo:Base
	{
		public GetJobInfo()
		{
			
		}
		//get all data of books
		public static DataSet GetGetJobInfo()
		{
			String strsql;
			strsql="SELECT * FROM getJobInfo";
			try
			{
				return ExecuteSql4Ds(strsql);				
			}
			catch
			{
				throw new Exception("Get all the Information failed!");
			}	
		}
		
		//from personID get getJobInfo
		public DataRow GetMyBaseInfo(int personId)
		{
			DataSet myDs;
			strSQL = "SELECT name,sex,email,phone,address,addrNum from GetJobInfo Where personID=" + personId.ToString();
			try
			{
				myDs = ExecuteSql4Ds(strSQL);
				return myDs.Tables[0].Rows[0];				
			}
			catch
			{
				throw new Exception("Get information failed!");
			}
		}
		public DataRow GetMyResume(int personId)
		{
			DataSet myDs;
			strSQL = "SELECT education,strong,experience,introduction from GetJobInfo Where personID=" + personId.ToString();
			try
			{
				myDs = ExecuteSql4Ds(strSQL);
				return myDs.Tables[0].Rows[0];				
			}
			catch
			{
				throw new Exception("Get information failed!");
			}
		}
		public DataRow GetMyCareer(int personId)
		{
			DataSet myDs;
			strSQL = "SELECT type,workPosition,workCity,wage,other,publicTime,lookTimes from GetJobInfo Where personID=" + personId.ToString();
			try
			{
				myDs = ExecuteSql4Ds(strSQL);
				return myDs.Tables[0].Rows[0];				
			}
			catch
			{
				throw new Exception("Get information failed!");
			}
		}
		/////////////update info/////////////////////////////////////
		public void UpdateMyBaseInfo(ArrayList tempary)
		{
			SqlConnection myCn=new SqlConnection(strConn);
			SqlCommand myCm=new SqlCommand("updatePBaseInfo",myCn);
			myCm.CommandType =CommandType.StoredProcedure ;

			myCm.Parameters.Add(new SqlParameter("@personID",SqlDbType.Int));
			myCm.Parameters["@personID"].Value =tempary[0];

			myCm.Parameters.Add(new SqlParameter("@name",SqlDbType.VarChar,10));
			myCm.Parameters["@name"].Value =tempary[1];

			myCm.Parameters.Add(new SqlParameter("@sex",SqlDbType.VarChar,5));
			myCm.Parameters["@sex"].Value =tempary[2];
			
			myCm.Parameters.Add(new SqlParameter("@email",SqlDbType.VarChar,50));
			myCm.Parameters["@email"].Value =tempary[3];
			
			myCm.Parameters.Add(new SqlParameter("@phone",SqlDbType.VarChar,20));
			myCm.Parameters["@phone"].Value =tempary[4];
			
			myCm.Parameters.Add(new SqlParameter("@address",SqlDbType.VarChar,50));
			myCm.Parameters["@address"].Value =tempary[5];
			
			myCm.Parameters.Add(new SqlParameter("@addrNum",SqlDbType.VarChar,10));
			myCm.Parameters["@addrNum"].Value =tempary[6];												

			try
			{
				myCn.Open() ;
				myCm.ExecuteNonQuery() ;
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new  Exception(er.Message);
			}
			finally
			{
				myCm.Dispose() ;
				myCn.Close() ;
			}
		}
		public void UpdateMyResume(ArrayList tempary)
		{
			SqlConnection myCn=new SqlConnection(strConn);
			SqlCommand myCm=new SqlCommand("updatePResume",myCn);
			myCm.CommandType =CommandType.StoredProcedure ;

			myCm.Parameters.Add(new SqlParameter("@personID",SqlDbType.Int));
			myCm.Parameters["@personID"].Value =tempary[0];

			myCm.Parameters.Add(new SqlParameter("@education",SqlDbType.VarChar,20));
			myCm.Parameters["@education"].Value =tempary[1];

			myCm.Parameters.Add(new SqlParameter("@strong",SqlDbType.Text));
			myCm.Parameters["@strong"].Value =tempary[2];
			
			myCm.Parameters.Add(new SqlParameter("@experience",SqlDbType.Text));
			myCm.Parameters["@experience"].Value =tempary[3];
			
			myCm.Parameters.Add(new SqlParameter("@introduction",SqlDbType.Text));
			myCm.Parameters["@introduction"].Value =tempary[4];											

			try
			{
				myCn.Open() ;
				myCm.ExecuteNonQuery() ;
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new  Exception(er.Message);
			}
			finally
			{
				myCm.Dispose() ;
				myCn.Close() ;
			}
		}
		public void UpdateMyCareer(ArrayList tempary)
		{
			SqlConnection myCn=new SqlConnection(strConn);
			SqlCommand myCm=new SqlCommand("updatePCareer",myCn);
			myCm.CommandType =CommandType.StoredProcedure ;

			myCm.Parameters.Add(new SqlParameter("@personID",SqlDbType.Int));
			myCm.Parameters["@personID"].Value =tempary[0];

			myCm.Parameters.Add(new SqlParameter("@type",SqlDbType.VarChar,50));
			myCm.Parameters["@type"].Value =tempary[1];

			myCm.Parameters.Add(new SqlParameter("@workPosition",SqlDbType.VarChar,50));
			myCm.Parameters["@workPosition"].Value =tempary[2];
			
			myCm.Parameters.Add(new SqlParameter("@workCity",SqlDbType.VarChar,50));
			myCm.Parameters["@workCity"].Value =tempary[3];
			
			myCm.Parameters.Add(new SqlParameter("@wage",SqlDbType.VarChar,50));
			myCm.Parameters["@wage"].Value =tempary[4];
			
			myCm.Parameters.Add(new SqlParameter("@other",SqlDbType.Text));
			myCm.Parameters["@other"].Value =tempary[5];
			
			myCm.Parameters.Add(new SqlParameter("@publicTime",SqlDbType.DateTime)); //
			myCm.Parameters["@publicTime"].Value =tempary[6];	
			
			myCm.Parameters.Add(new SqlParameter("@lookTimes",SqlDbType.Int)); //
			myCm.Parameters["@lookTimes"].Value =tempary[7];												

			try
			{
				myCn.Open() ;
				myCm.ExecuteNonQuery() ;
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new  Exception(er.Message);
			}
			finally
			{
				myCm.Dispose() ;
				myCn.Close() ;
			}
		}
		//////////////////////////////////////////////////////////////////////////////////////
		//get top ten best salers
		public DataView GetJobInfoTop10()
		{
			String strsql;
			DataSet myDs;
			strsql="select top 10 getJobInfoID,name,workPosition,education from getJobInfo order by lookTimes DESC";
			myDs=ExecuteSql4Ds(strsql);
			return myDs.Tables[0].DefaultView ;
		}

		public DataView GetNewInfo10()
		{
			String strsql;
			DataSet myDs;
			strsql="select top 10 getJobInfoID,name,workPosition,education from getJobInfo order by getJobInfoID desc";
			myDs=ExecuteSql4Ds(strsql);
			return myDs.Tables[0].DefaultView ;
		}

		public DataRow GetInfoDetail(string personID)
		{
			string strsql;
			DataSet myDs;
			try
			{
				strsql="select * from getJobInfo where getJobInfo.personID="+personID;
				myDs=ExecuteSql4Ds(strsql);
				return myDs.Tables[0].Rows[0];
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new Exception(er.Message);
			}

		}
		
		/// <summary>
		/// Add  book hits
		/// </summary>
		/// <param name="bookId">book ID</param>
		/// <returns></returns>
		public static void Hits(string personId)
		{
			strSQL =  "Update getJobInfo set lookTimes=lookTimes+1 Where getJobInfoID= " + personId;
			try
			{
				ExecuteSql4Ds(strSQL);				
			}
			catch
			{
				throw new Exception("Hits FAILED!!");
			}
		}

		/// <summary>
		/// Search Book By name,author,translator,publisher
		/// </summary>
		/// <param name="Msg"></param>
		/// <returns></returns>
		public static DataSet SearchPersonInfo(string Msg)
		{
			string str;
			str="select * from getJobInfo where name like '%" + Msg + "%' or workPosition like '%" + Msg + "%' or workCity like '%" + Msg + "%' or education like '%" + Msg + "%' ";
			DataSet myDs;
			myDs=ExecuteSql4Ds(str);
			return myDs;
		}
	}
}