//查詢單一活動
public EWC_SignUp GetSignUp2(string ID)
{
DataTable dt = EWC_DBHelper.GetDataTable("select * from EWC_ActivitySignUpDetail where ActivityID=@atvid",
new Dictionary <string, object> {
{ "@atvid", ID }
}); //呼叫DBHelper的GetDataTable方法,查詢條件參數給活動ID
EWC_SignUp signUp = new EWC_SignUp(); //建立EWC_Activity型別的List,之後接GetDataTable回傳的EWC_Activity List
foreach (DataRow row in dt.Rows) //dt取回是object,要轉型成EWC_Activity型別
{
signUp = new EWC_SignUp()
{ //dt.Rows是一個陣列
ActivitySignUpDetailID = row["ActivitySignUpDetailID"].ToString(), //將欄位值(object)轉成EWC_SignUp型別
ActivityID = row["ActivityID"].ToString(),
EmployeeID = row["EmployeeID"].ToString(),
Name = row["Name"].ToString(),
IsEmployee = row["IsEmployee"].ToString(),
TourBus = row["TourBus"].ToString(),
};
//aList.Add(a);
}
return(signUp);
}
public void Insert(EWC_SignUp s)
{
EWC_DBHelper.RunTSQL("insert into EWC_ActivitySignUpDetail values(@suid ,@aid, @eid, @name, @ise , @tb)",
new Dictionary <string, object> {
{ "@suid", s.ActivitySignUpDetailID },
{ "@aid", s.ActivityID },
{ "@eid", s.EmployeeID },
{ "@name", s.Name },
{ "@ise", s.IsEmployee },
{ "@tb", s.TourBus }
});
}
//查詢所有活動
public List <EWC_SignUp> GetSignUp()
{
DataTable dt = EWC_DBHelper.GetDataTable("select * from EWC_ActivitySignUpDetail ORDER BY ActivityID DESC", null); //呼叫DBHelper的GetDataTable方法,查詢全部資料條件參數給null即可
List <EWC_SignUp> sList = new List <EWC_SignUp>(); //建立EWC_Activity型別的List,之後接GetDataTable回傳的EWC_Activity List
foreach (DataRow row in dt.Rows) //dt取回是object,要轉型成EWC_Activity型別
{
EWC_SignUp s = new EWC_SignUp()
{ //dt.Rows是一個陣列
ActivitySignUpDetailID = row["ActivitySignUpDetailID"].ToString(), //將欄位值(object)轉成EWC_SignUp型別
ActivityID = row["ActivityID"].ToString(),
EmployeeID = row["EmployeeID"].ToString(),
Name = row["Name"].ToString(),
IsEmployee = row["IsEmployee"].ToString(),
TourBus = row["TourBus"].ToString(),
};
sList.Add(s);
}
return(sList);
}
