/// <summary> /// 获得所有电影院的信息 /// </summary> /// <returns>电影院信息列表</returns> public List<Model.Cinema> getCinemaList() { List<Model.Cinema> lst = new List<Model.Cinema>(); DataTable dt = DBUtility.SqlHelper.executeTable("select * from vew_Cinemas", CommandType.Text, null); foreach (DataRow item in dt.Rows) { Model.Cinema emp = new Model.Cinema() { CinemaID = int.Parse(item[0].ToString()), CinemaName = item[1].ToString(), Address = item[2].ToString(), CinemaMap = item[3].ToString(), CinemaGrade =item[5].ToString(), CinemaTel = item[4].ToString(),Privilege=item[6].ToString(), VIP=item[7].ToString(),Dining=item[8].ToString(),Park=item[9].ToString(),GameCenter=item[10].ToString(),Intro3D=item[11].ToString(),IntroVIP=item[12].ToString(),Introduce=item[13].ToString()}; List<Model.CinemaPic> cinemaPic = new List<Model.CinemaPic>(); DataTable picDT = DBUtility.SqlHelper.executeTable("select * from CinemaPic where CinemaID=" + emp.CinemaID, CommandType.Text, null); foreach(DataRow picItem in picDT.Rows) { Model.CinemaPic pic = new Model.CinemaPic() { PicURL = picItem[2].ToString() }; cinemaPic.Add(pic); } emp.CinemaPic = cinemaPic; lst.Add(emp); } return lst; }
public Model.Cinema getCinemaById(int id) { Model.Cinema cinema = new Model.Cinema(); string sql = "SELECT * FROM vew_Cinemas WHERE CinemaID=@id"; SqlParameter[] sps = new SqlParameter[]{ new SqlParameter(){ParameterName="@id",Value=id} }; //DataTable db = DBUtility.SqlHelper.executeTable(sql, CommandType.Text, sps); SqlDataReader sr = DBUtility.SqlHelper.executeReader(sql, CommandType.Text, sps); if (sr.Read()) { cinema.CinemaID = int.Parse(sr[0].ToString()); cinema.CinemaName = sr[1].ToString(); cinema.Address = sr[2].ToString(); cinema.CinemaMap = sr[3].ToString(); cinema.CinemaTel = sr[4].ToString(); cinema.CinemaGrade = sr[5].ToString(); cinema.Privilege = sr[6].ToString(); cinema.VIP = sr[7].ToString(); cinema.Dining = sr[8].ToString(); cinema.Park = sr[9].ToString(); cinema.GameCenter = sr[10].ToString(); cinema.Intro3D = sr[11].ToString(); cinema.IntroVIP = sr[12].ToString(); cinema.Introduce = sr[13].ToString(); List<Model.CinemaPic> pics = new List<Model.CinemaPic>(); string sql1 = "SELECT * FROM CinemaPic WHERE CinemaID=@cinemaID"; SqlParameter[] sps2 = new SqlParameter[]{ new SqlParameter(){ParameterName="@cinemaID",Value=cinema.CinemaID} }; DataTable dt = DBUtility.SqlHelper.executeTable(sql1, CommandType.Text, sps2); if (dt != null) { foreach (DataRow item in dt.Rows) { Model.CinemaPic pic = new Model.CinemaPic() { PicURL = item[2].ToString() }; pics.Add(pic); } cinema.CinemaPic = pics; } else { cinema.CinemaPic = null; } return cinema; } return null; //throw new NotImplementedException(); }