?using System;
using System.Data;
using System.Data.SqlClient;

/// <summary>
/// 關于招聘的操作類
/// </summary>
public class Job
{
   //SQL語句設置為常量，方便日后的維護
    private const string SQL_PARM_DEPARTID = "@departid";
    private const string SQL_PARM_OPENINGJOB = "@jobname";
    private const string SQL_PARM_AMOUNT = "@peopleamount";
    private const string SQL_PARM_REQUIREMENT = "@require";
    private const string SQL_PARM_NOTE = "@note";
    private const string SQL_INSERT_INVITE = "INSERT INTO invite (departid,openingjob,peopleamount,require,note) VALUES(@departid,@jobname,@peopleamount,@require,@note)";
    public Job()
	{
	}
    /// <summary>
    /// 申請空缺的方法
    /// </summary>
    /// <param name="departid">部門ID</param>
    /// <param name="jobname">空缺職位</param>
    /// <param name="peopleamount">招聘人數</param>
    /// <param name="require">招聘要求</param>
    public void SaveApply(int departid, string jobname, int peopleamount, string require,string note)
    {
        //初始化參數數組
        SqlParameter[] parms = new SqlParameter[] {
                new SqlParameter(SQL_PARM_DEPARTID, SqlDbType.Int),
                new SqlParameter(SQL_PARM_OPENINGJOB, SqlDbType.NVarChar,20),
                new SqlParameter(SQL_PARM_AMOUNT, SqlDbType.Int),
                new SqlParameter(SQL_PARM_REQUIREMENT, SqlDbType.NVarChar,200),
                new SqlParameter(SQL_PARM_NOTE, SqlDbType.NVarChar,100)};
        SqlCommand cmd = new SqlCommand();

        // 依次給參數賦值
        parms[0].Value = departid;
        parms[1].Value = jobname;
        parms[2].Value = peopleamount;
        parms[3].Value = require;
        parms[4].Value = note;

        //將參數添加到SqlCommand命令中
        foreach (SqlParameter parm in parms)
            cmd.Parameters.Add(parm);

        //獲取數據庫的連接字符串
        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
        {
            //打開數據庫連接，執行命令
            conn.Open();
            //設置Sqlcommand命令的屬性
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = SQL_INSERT_INVITE;
            //執行添加的SqlCommand命令
            cmd.ExecuteNonQuery();
            //清空SqlCommand命令中的參數
            cmd.Parameters.Clear();
        }
    }
}