?? calendarset.cs
字號:
?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();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -