private async void AddEditCinemaForm_Load(object sender, EventArgs e) { if (_cinemaId.HasValue) { Model.Cinema cinema = await _apiService.GetById <Model.Cinema>(_cinemaId); Title.Text = $"{cinema.Name}, {cinema.Location}"; Cinema.Text = cinema.Name; Address.Text = cinema.Address; StreetNumber.Value = cinema.StreetNumber; Location.Text = cinema.Location; PhoneNumber.Text = cinema.PhoneNumber; Rating.Text = cinema.Rating.ToString(); Description.Text = cinema.Description; ImageLink.Text = cinema.ImageLink; Image.DocumentText = "<style>.imgStyle{color:red; object-fit:cover;} body{margin:0;}</style>" + $"<img alt='No available image with the provided link' src={cinema.ImageLink} class='imgStyle' width='{Image.Width}' height='{Image.Height}'/>"; } else { Image.DocumentText = "<style>.imgStyle{color:red; object-fit:cover;} body{margin:0;}</style>" + $"<img alt='No available image with the provided link' src=https://www.deadlineclaims.com/wp-content/uploads/2017/02/placeholder-image.jpg class='imgStyle' width='{Image.Width}' height='{Image.Height}'/>"; Title.Text = "Add a new cinema"; } }
/// <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(); }