Backup/component/CompanyOffer.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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)
		{