//查詢單一活動
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 List <EWC_SignUpAtv> GetSignUpAtv(string empid)
{
DataTable dt = EWC_DBHelper.GetDataTable("select a.ActivityID,a.EmployeeID,b.Title,b.Type,b.StartDate,b.EndDate,b.StartTime,b.EndTime from EWC_ActivitySignUpDetail as a join EWC_Activity as b on a.ActivityID = b.ActivityID where EmployeeID = @empid",
new Dictionary <string, object> {
{ "@empid", empid }
}); //呼叫DBHelper的GetDataTable方法,查詢全部資料條件參數給null即可
List <EWC_SignUpAtv> sList = new List <EWC_SignUpAtv>(); //建立EWC_Activity型別的List,之後接GetDataTable回傳的EWC_Activity List
foreach (DataRow row in dt.Rows) //dt取回是object,要轉型成EWC_Activity型別
{
EWC_SignUpAtv s = new EWC_SignUpAtv()
{ //dt.Rows是一個陣列
ActivityID = row["ActivityID"].ToString(), //將欄位值(object)轉成EWC_SignUp型別
EmployeeID = row["EmployeeID"].ToString(),
Title = row["Title"].ToString(),
Type = row["Type"].ToString(),
StartDate = row["StartDate"].ToString(),
EndDate = row["EndDate"].ToString(),
StartTime = row["StartTime"].ToString(),
EndTime = row["EndTime"].ToString(),
};
sList.Add(s);
}
return(sList);
}
public List <EWC_Album> GetAlbum()
{
DataTable dt = EWC_DBHelper.GetDataTable("select a.*, b.StartDate from EWC_Album as a join EWC_Activity as b on a.ActivityID = b.ActivityID order by StartDate DESC ", null); //呼叫DBHelper的GetDataTable方法,查詢全部資料條件參數給null即可
List <EWC_Album> aList = new List <EWC_Album>(); //建立EWC_Activity型別的List,之後接GetDataTable回傳的EWC_Activity List
foreach (DataRow row in dt.Rows) //dt取回是object,要轉型成EWC_Activity型別
{
EWC_Album a = new EWC_Album()
{ //dt.Rows是一個陣列
AlbumID = row["AlbumID"].ToString(), //將欄位值(object)轉成EWC_Activity型別
ActivityID = row["ActivityID"].ToString(),
AlbumTitle = row["AlbumTitle"].ToString(),
AlbumDesc = row["AlbumDesc"].ToString(),
DefaultPhoto = row["DefaultPhoto"].ToString(),
};
aList.Add(a);
}
return(aList);
}
//public List<EWC_Photo> GetPhoto()
//{
// DataTable dt = EWC_DBHelper.GetDataTable("select * from EWC_Photo ORDER BY AlbumID DESC", null); //呼叫DBHelper的GetDataTable方法,查詢全部資料條件參數給null即可
// List<EWC_Photo> aList = new List<EWC_Photo>(); //建立EWC_Activity型別的List,之後接GetDataTable回傳的EWC_Activity List
// foreach (DataRow row in dt.Rows) //dt取回是object,要轉型成EWC_Activity型別
// {
// EWC_Photo p = new EWC_Photo()
// { //dt.Rows是一個陣列
// PhotoID = row["PhotoID"].ToString(), //將欄位值(object)轉成EWC_Activity型別
// AlbumID = row["AlbumID"].ToString(),
// FilePath = row["FilePath"].ToString(),
// PhotoDesc = row["PhotoDesc"].ToString(),
// };
// aList.Add(p);
// }
// return aList;
//}
public List <EWC_Photo> GetPhoto(string ID)
{
DataTable dt = EWC_DBHelper.GetDataTable("select * from EWC_Photo where AlbumID=@abid",
new Dictionary <string, object> {
{ "@abid", ID }
}); //呼叫DBHelper的GetDataTable方法,查詢條件參數給相簿ID
List <EWC_Photo> aList = new List <EWC_Photo>(); //建立EWC_Activity型別的List,之後接GetDataTable回傳的EWC_Activity List
foreach (DataRow row in dt.Rows) //dt取回是object,要轉型成EWC_Activity型別
{
EWC_Photo p = new EWC_Photo()
{ //dt.Rows是一個陣列
PhotoID = row["PhotoID"].ToString(), //將欄位值(object)轉成EWC_Activity型別
AlbumID = row["AlbumID"].ToString(),
FilePath = row["FilePath"].ToString(),
PhotoDesc = row["PhotoDesc"].ToString(),
};
aList.Add(p);
}
return(aList);
}
//查詢單一活動
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_SignUpEmployee> GetSignUpEmployee()
{
DataTable dt = EWC_DBHelper.GetDataTable("select a.*,b.Email,b.ext from EWC_ActivitySignUpDetail as a join AMS_Employee as b on a.EmployeeID = b.EmployeeID", null); //呼叫DBHelper的GetDataTable方法,查詢全部資料條件參數給null即可
List <EWC_SignUpEmployee> sList = new List <EWC_SignUpEmployee>(); //建立EWC_Activity型別的List,之後接GetDataTable回傳的EWC_Activity List
foreach (DataRow row in dt.Rows) //dt取回是object,要轉型成EWC_Activity型別
{
EWC_SignUpEmployee s = new EWC_SignUpEmployee()
{ //dt.Rows是一個陣列
ActivityID = row["ActivityID"].ToString(), //將欄位值(object)轉成EWC_SignUp型別
EmployeeID = row["EmployeeID"].ToString(),
Name = row["Name"].ToString(),
Email = row["Email"].ToString(),
Ext = row["Ext"].ToString(),
};
sList.Add(s);
}
return(sList);
}
//查詢所有活動
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);
}
//查詢所有活動
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);
}