用事件跟委託執行調用資料庫的方法

標籤：資料   一個   index   view   mysql資料庫   ace   mes   new   col   

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Model;
using Dal;

namespace Unit_WeekOne.Controllers
{
public class IndexController : Controller
{

SqlServer sl = new SqlServer();
MySql mys = new MySql();

// GET: Index
public ActionResult Index()
{
Events<UserInfoModel> evs = new Events<UserInfoModel>();
evs.deleteEnents += SqlList;

List<UserInfoModel> list= evs.Send();

return View(list);
}
/// <summary>
/// 執行SqlServer的資料庫
/// </summary>
/// <returns></returns>
public List<UserInfoModel> SqlList()
{
List<UserInfoModel> list= sl.SqlServers<UserInfoModel>();
return list;
}
/// <summary>
/// 執行MySql資料庫
/// </summary>
/// <returns></returns>
//public List<UserInfoModel> MyList()
//{
// List<UserInfoModel> list = mys.MySqls<UserInfoModel>();
// return list;
//}
/// <summary>
/// 定義事件執行的方法
/// </summary>
/// <typeparam name="T"></typeparam>
public class Events<T>
{
public delegate List<T> deleteEnent(); //定義一個委託
public event deleteEnent deleteEnents; //定義一個事件

public List<T> Send()
{
return deleteEnents();
}
}

}
}

用事件跟委託執行調用資料庫的方法