// if (a.note == "")
// {
// DBNull.Value
//}else
//a.note
public void Update(EWC_Activity a)
{
EWC_DBHelper.RunTSQL("update EWC_Activity set Type=@type, Title=@title, Photo=@photo, ActivityDescription=@desc , ActiveDate=@ad , StartDate=@sd , EndDate=@ed , StartTime=@st , EndTime=@et , Location=@locat , ActivitySchedule=@sche , AllowSignUp=@as , StartSignUpDate=@ssd , EndSignUpDate=@esd , CompanyAmount=@ca , Charge=@charge , Bus=@bus , Note=@note where ActivityID=@id",
new Dictionary <string, object> {
{ "@id", a.ActivityID },
{ "@type", a.Type },
{ "@title", a.Title },
{ "@photo", a.Photo },
{ "@desc", a.ActivityDescription },
{ "@ad", a.ActiveDate },
{ "@sd", a.StartDate },
{ "@ed", a.EndDate },
{ "@st", a.StartTime },
{ "@et", a.EndTime },
{ "@locat", a.Location },
{ "@sche", a.ActivitySchedule },
{ "@as", a.AllowSignUp },
{ "@ssd", a.StartSignUpDate },
{ "@esd", a.EndSignUpDate },
{ "@ca", a.CompanyAmount },
{ "@charge", a.Charge },
{ "@bus", a.Bus },
{ "@note", a.Note }
});
}
public void Insert(EWC_Activity a)
{
EWC_DBHelper.RunTSQL("insert into EWC_Activity values(@id ,@type, @title, @photo, @desc , @ad , @sd , @ed , @st , @et , @locat , @sche , @as , @ssd , @esd , @ca , @charge , @bus , @note)",
new Dictionary <string, object> {
{ "@id", a.ActivityID },
{ "@type", a.Type },
{ "@title", a.Title },
{ "@photo", a.Photo },
{ "@desc", a.ActivityDescription },
{ "@ad", a.ActiveDate },
{ "@sd", a.StartDate },
{ "@ed", a.EndDate },
{ "@st", a.StartTime },
{ "@et", a.EndTime },
{ "@locat", a.Location },
{ "@sche", a.ActivitySchedule },
{ "@as", a.AllowSignUp },
{ "@ssd", a.StartSignUpDate },
{ "@esd", a.EndSignUpDate },
{ "@ca", a.CompanyAmount },
{ "@charge", a.Charge },
{ "@bus", a.Bus },
{ "@note", a.Note }
});
}
//查詢單一活動
public EWC_Activity GetActivity2(string ID)
{
DataTable dt = EWC_DBHelper.GetDataTable("select * from EWC_Activity where ActivityID=@atvid",
new Dictionary <string, object> {
{ "@atvid", ID }
}); //呼叫DBHelper的GetDataTable方法,查詢條件參數給活動ID
EWC_Activity atv = new EWC_Activity(); //建立EWC_Activity型別的List,之後接GetDataTable回傳的EWC_Activity List
foreach (DataRow row in dt.Rows) //dt取回是object,要轉型成EWC_Activity型別
{
atv = new EWC_Activity()
{ //dt.Rows是一個陣列
ActivityID = row["ActivityID"].ToString(), //將欄位值(object)轉成EWC_Activity型別
Type = row["Type"].ToString(),
Title = row["Title"].ToString(),
Photo = row["Photo"].ToString(),
ActivityDescription = row["ActivityDescription"].ToString(),
ActiveDate = row["ActiveDate"].ToString(),
StartDate = row["StartDate"].ToString(),
EndDate = row["EndDate"].ToString(),
StartTime = row["StartTime"].ToString(),
EndTime = row["EndTime"].ToString(),
Location = row["Location"].ToString(),
ActivitySchedule = row["ActivitySchedule"].ToString(),
AllowSignUp = row["AllowSignUp"].ToString(),
StartSignUpDate = row["StartSignUpDate"].ToString(),
EndSignUpDate = row["EndSignUpDate"].ToString(),
CompanyAmount = row["CompanyAmount"].ToString(),
Charge = row["Charge"].ToString(),
Bus = row["Bus"].ToString(),
Note = row["Note"].ToString()
};
//aList.Add(a);
}
return(atv);
}
//查詢所有活動
public List <EWC_Activity> GetActivity()
{
DataTable dt = EWC_DBHelper.GetDataTable("select * from EWC_Activity ORDER BY StartDate DESC", null); //呼叫DBHelper的GetDataTable方法,查詢全部資料條件參數給null即可
List <EWC_Activity> aList = new List <EWC_Activity>(); //建立EWC_Activity型別的List,之後接GetDataTable回傳的EWC_Activity List
foreach (DataRow row in dt.Rows) //dt取回是object,要轉型成EWC_Activity型別
{
EWC_Activity a = new EWC_Activity()
{ //dt.Rows是一個陣列
ActivityID = row["ActivityID"].ToString(), //將欄位值(object)轉成EWC_Activity型別
Type = row["Type"].ToString(),
Title = row["Title"].ToString(),
Photo = row["Photo"].ToString(),
ActivityDescription = row["ActivityDescription"].ToString(),
ActiveDate = row["ActiveDate"].ToString(),
StartDate = row["StartDate"].ToString(),
EndDate = row["EndDate"].ToString(),
StartTime = row["StartTime"].ToString(),
EndTime = row["EndTime"].ToString(),
Location = row["Location"].ToString(),
ActivitySchedule = row["ActivitySchedule"].ToString(),
AllowSignUp = row["AllowSignUp"].ToString(),
StartSignUpDate = row["StartSignUpDate"].ToString(),
EndSignUpDate = row["EndSignUpDate"].ToString(),
CompanyAmount = row["CompanyAmount"].ToString(),
Charge = row["Charge"].ToString(),
Bus = row["Bus"].ToString(),
Note = row["Note"].ToString()
};
aList.Add(a);
}
return(aList);
}
