天翼翔幻

一樣是我的備忘錄

主要功能是想要作個函數判斷今天是否符合「假日」的規則，如果符合，則不允許使用者進行該日相關的操作！
public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction(Name = "FN_TodayIsHoliday", DataAccess = DataAccessKind.Read)] public static SqlBoolean FN_TodayIsHoliday() { using (SqlConnection conn = new SqlConnection("context connection=true")) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { DateTime now = DateTime.Now; cmd.CommandText = string.Format("Select Count(*) from [Holiday] where " + "([enabled] = 1) And " + "(([RuleStart] IS NULL Or [RuleStart] >= @datenow) And " + " ([RuleEnd] IS NULL Or [RuleEnd] <= @datenow)) And " + "([year] IS NULL Or [year] = {0}) And " + "([month] IS NULL Or [month] = {0}) And " + "([day] IS NULL Or [day] = {0})", now.Year, now.Month, now.Day); cmd.Parameters.AddWithValue("@datenow", now); return (Convert.ToInt32(cmd.ExecuteScalar()) > 0); } } } };