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

/// <summary>
/// 關于日程安排的操作類
/// </summary>
public class CalendarSet
{
    //SQL語句設置為常量，方便日后的維護
    private const string SQL_PARM_NAME = "@employeename";
    private const string SQL_PARM_TITLE = "@title";
    private const string SQL_PARM_CONTENT = "@content";
    private const string SQL_PARM_SETDATE = "@date";
    private const string SQL_INSERT_CALENDAR = "INSERT INTO calendar VALUES(@employeename,@title,@content,@date)";

	public CalendarSet()
	{
	}
    /// <summary>
    /// 保存一個新的日程
    /// </summary>
    /// <param name="employeename">員工姓名</param>
    /// <param name="title">日程主題</param>
    /// <param name="content">日程內容</param>
    /// <param name="setdate">日程的安排日期</param>
    public void SaveCalendar(string employeename,string title,string content,DateTime setdate)
    {
        //初始化參數數組
        SqlParameter[] parms = new SqlParameter[] {
                new SqlParameter(SQL_PARM_NAME, SqlDbType.NVarChar,20),
                new SqlParameter(SQL_PARM_TITLE, SqlDbType.NVarChar,20),
                new SqlParameter(SQL_PARM_CONTENT, SqlDbType.NVarChar,100),
                new SqlParameter(SQL_PARM_SETDATE, SqlDbType.DateTime)};
        SqlCommand cmd = new SqlCommand();

        // 依次給參數賦值
        parms[0].Value = employeename;
        parms[1].Value = title;
        parms[2].Value = content;
        parms[3].Value = setdate;

        //將參數添加到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_CALENDAR;
            //執行添加的SqlCommand命令
            int val = cmd.ExecuteNonQuery();
            //清空SqlCommand命令中的參數
            cmd.Parameters.Clear();
        }
    }
}