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