public List<Model.PlayTime> getPlayTimeList() { List<Model.PlayTime> lst = new List<Model.PlayTime>(); DataTable dt = DBUtility.SqlHelper.executeTable("select * from PlayTimes", CommandType.Text, null); foreach (DataRow item in dt.Rows) { Model.PlayTime emp = new Model.PlayTime() { PlaytimeID = int.Parse(item[0].ToString()), MovieID =int.Parse( item[1].ToString()), CinemaID =int.Parse( item[2].ToString()), Playtime =DateTime.Parse( item[3].ToString()), PlayState =bool.Parse( item[4].ToString()) }; lst.Add(emp); } return lst; //throw new NotImplementedException(); }
public List<Model.PlayTime> getPlayTimeList(int movieID, int cinemaID) { List<Model.PlayTime> lst = new List<Model.PlayTime>(); string sql = "SELECT * FROM PlayTimes WHERE MovieID=@movieID AND CinemaID=@cinemaID"; SqlParameter[] sps = new SqlParameter[]{ new SqlParameter(){ParameterName="@movieID",Value=movieID}, new SqlParameter(){ParameterName="@cinemaID",Value=cinemaID} }; DataTable dt = DBUtility.SqlHelper.executeTable(sql, CommandType.Text, sps); foreach (DataRow item in dt.Rows) { Model.PlayTime emp = new Model.PlayTime() { PlaytimeID = int.Parse(item[0].ToString()), MovieID = int.Parse(item[1].ToString()), CinemaID = int.Parse(item[2].ToString()), Playtime = DateTime.Parse(item[3].ToString()), PlayState = bool.Parse(item[4].ToString()) }; lst.Add(emp); } return lst; //throw new NotImplementedException(); }