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