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();
}
