//查詢單一活動 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); }