companyoffer.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections ;

namespace Hr.component
{
	public class CompanyOffer:DatabaseOperation
	{
		public CompanyOffer()
		{
			
		}
		public static DataSet GetCompanyOffer()
		{
			String strsql;

			strsql="SELECT * FROM CompanyOffer";
			try
			{
				return ExecuteReturnDS(strsql);				
			}
			catch
			{
				throw new Exception("读取信息发生错误!");
			}	
		}
		
		public DataRow GetCompanyInfo(int companyId)
		{
			DataSet myDs;
			strSQL = "SELECT companyName,vocation,email,phone,address,addrNum from CompanyOffer Where companyID=" + companyId.ToString();
			try
			{
				myDs = ExecuteReturnDS(strSQL);
				return myDs.Tables[0].Rows[0];				
			}
			catch
			{
				throw new Exception("读取信息发生错误！");
			}
		}
		public DataRow GetMyCareer(int companyId)
		{
			DataSet myDs;
			strSQL = "SELECT workPosition,giveNum,workCity,discribe,request,publicTime,lookTimes from CompanyOffer Where companyID=" + companyId.ToString();
			try
			{
				myDs = ExecuteReturnDS(strSQL);
				return myDs.Tables[0].Rows[0];				
			}
			catch
			{
				throw new Exception("读取信息发生错误！");
			}
		}


		public void UpdateCompanyInfo(ArrayList tempary)
		{
			SqlConnection myConn=new SqlConnection(strConn);
			SqlCommand myCm=new SqlCommand("updateCBaseInfo",myConn);
			myCm.CommandType =CommandType.StoredProcedure ;

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

			myCm.Parameters.Add(new SqlParameter("@companyName",SqlDbType.VarChar,50));
			myCm.Parameters["@companyName"].Value =tempary[1];
			
			myCm.Parameters.Add(new SqlParameter("@vocation",SqlDbType.VarChar,50));
			myCm.Parameters["@vocation"].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,50));
			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,50));
			myCm.Parameters["@addrNum"].Value =tempary[6];												

			try
			{
				myConn.Open() ;
				myCm.ExecuteNonQuery() ;
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new  Exception(er.Message);
			}
			finally
			{
				myCm.Dispose() ;
				myConn.Close() ;
			}
		}

		public void UpdateMyCareer(ArrayList tempary)
		{
			SqlConnection myConn=new SqlConnection(strConn);
			SqlCommand myCm=new SqlCommand("updateCCareer",myConn);
			myCm.CommandType =CommandType.StoredProcedure ;

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

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

			myCm.Parameters.Add(new SqlParameter("@giveNum",SqlDbType.VarChar,50));
			myCm.Parameters["@giveNum"].Value =tempary[2];
			
			myCm.Parameters.Add(new SqlParameter("@workCity",SqlDbType.VarChar,50));
			myCm.Parameters["@workCity"].Value =tempary[3];
			
			myCm.Parameters.Add(new SqlParameter("@discribe",SqlDbType.Text));
			myCm.Parameters["@discribe"].Value =tempary[4];
			
			myCm.Parameters.Add(new SqlParameter("@request",SqlDbType.Text));
			myCm.Parameters["@request"].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
			{
				myConn.Open() ;
				myCm.ExecuteNonQuery() ;
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new  Exception(er.Message);
			}
			finally
			{
				myCm.Dispose() ;
				myConn.Close() ;
			}
		}

		public DataView CompanyOfferTop10()
		{
			String strsql;
			DataSet myDs;
			strsql="select top 10 CompanyOfferID,companyName,vocation,workPosition from CompanyOffer order by lookTimes DESC";
			myDs=ExecuteReturnDS(strsql);
			return myDs.Tables[0].DefaultView ;
		}

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

		}
		
		public void Hits(string CompanyOfferID)
		{
			strSQL =  "Update CompanyOffer set lookTimes=lookTimes+1 Where CompanyOfferID= " + CompanyOfferID;
			try
			{
				ExecuteReturnDS(strSQL);				
			}
			catch
			{
				throw new Exception("更新发生错误!");
			}
		}

		public static DataSet SearchCompanyInfo(string Msg)
		{
			string str;
			str="select * from CompanyOffer where companyName like '%" + Msg + "%' or workPosition like '%" + Msg + "%' or workCity like '%" + Msg + "%' or request like '%" + Msg + "%' ";
			DataSet myDs;
			myDs=ExecuteReturnDS(str);
			return myDs;
		}
	}
}