public List <CinemaInfoModel> Filtrate(string CinemaArea, string OfficeName)
{
string str = "select distinct c.CinemaID,c.CinemaName,c.CinemaAddress,c.CinemaArea from CinemaInfo c ,[dbo].[OfficeInfo] o " +
"where c.CinemaID=o.CinemaID and c.CinemaArea like '%'+@CinemaArea+'%' and o.OfficeName like '%'+@OfficeName+'%' ";
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@CinemaArea", System.Data.SqlDbType.NVarChar)
{
Value = CinemaArea
},
new SqlParameter("@OfficeName", System.Data.SqlDbType.NVarChar)
{
Value = OfficeName
},
};
SqlDataReader reader = SqlHelper.ExecuteReader(str, System.Data.CommandType.Text, sqlParameters);
List <CinemaInfoModel> ls = new List <CinemaInfoModel>();
while (reader.Read())
{
CinemaInfoModel ci = new CinemaInfoModel(reader);
ls.Add(ci);
}
reader.Close();
return(ls);
}
private void FindOfficeInfo()
{
//如果传入的影片ID和影院ID都不为空，
//证明从电影界面点击进来
if (!String.IsNullOrEmpty(Request["CinemaID"]) && !String.IsNullOrEmpty(Request["MovieID"]))
{
MovieInfoModel mi = new MovieInfoModel();
mi.MovieID = Convert.ToInt32(Request["MovieID"]);
CinemaInfoModel ci = new CinemaInfoModel();
ci.CinemaID = Convert.ToInt32(Request["CinemaID"]);
List <ShowDetails> sd = new ChooseOfficeBLL().FindOffice(mi, ci);
var jsondata = JsonConvert.SerializeObject(sd);
Response.Write(jsondata);
Response.End();
}
else
{
MovieInfoModel mi = new MovieInfoModel();
mi.MovieID = 0;
CinemaInfoModel ci = new CinemaInfoModel();
ci.CinemaID = Convert.ToInt32(Request["CinemaID"]);
List <ShowDetails> sd = new ChooseOfficeBLL().FindOffice(mi, ci);
var jsondata = JsonConvert.SerializeObject(sd);
Response.Write(jsondata);
Response.End();
}
}
public List <ShowDetails> FindTom(MovieInfoModel mi, CinemaInfoModel om)
{
string str = " select ch.StartTime,ch.StopTime,mi.MovieArea,ofi.OfficeID,ofi.OfficeName,ch.ChipInfoID,mi.MovieMoney as [Money] from ChipInfo ch ,MovieInfo mi, OfficeInfo ofi where ch.MovieName = mi.MovieName and ch.OfficeID = ofi.OfficeID and ch.CinemaID = @CinemaID and ch.MovieName = @MovieName and ch.StartTime >= Convert(DateTime, CONVERT(nvarchar, GETDATE(), 23) + ' 23:59:00') AND ch.StartTime < Convert(DateTime, CONVERT(nvarchar, GETDATE() + 1, 23) + ' 23:59:59')";
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@CinemaID", System.Data.SqlDbType.Int)
{
Value = om.CinemaID
},
new SqlParameter("@MovieName", System.Data.SqlDbType.NVarChar)
{
Value = mi.MovieName
}
};
SqlDataReader reader = SqlHelper.ExecuteReader(str, System.Data.CommandType.Text, sqlParameters);
List <ShowDetails> ls = new List <ShowDetails>();
//获取到了所有的厅位信息
while (reader.Read())
{
ShowDetails ofs = new ShowDetails(reader);
ls.Add(ofs);
}
reader.Close();
return(ls);
}
/// <summary>
/// 根据传入的影院ID和电影ID返回厅院电影信息
/// </summary>
/// <param name="mi"></param>
/// <param name="om"></param>
/// <returns></returns>
public List <MovieInfoModel> FindMovieInfo(MovieInfoModel mi, CinemaInfoModel om)
{
string str;
SqlParameter[] sqlParameters = null;
str = "Select * from MovieInfo where MovieName in ( select MovieName from [dbo].[ChipInfo] where CinemaID=@CinemaID)";
sqlParameters = new SqlParameter[] {
new SqlParameter("@CinemaID", System.Data.SqlDbType.Int)
{
Value = om.CinemaID
}
};
SqlDataReader reader = SqlHelper.GetSqlDataReader(str, sqlParameters);
//获取到该电影院所有的排片电影
List <MovieInfoModel> ls = new List <MovieInfoModel>();
while (reader.Read())
{
ls.Add(new MovieInfoModel(reader));
}
reader.Close();
return(ls);
}
private void loadCinema(string ChipInfoID)
{
//找到影院名
List <CinemaInfoModel> cinemaModel = new List <CinemaInfoModel>();
cinemaModel = new ChooseSeatBLL().selectCinemaName(ChipInfoID);
CinemaInfoModel cinemaModela = cinemaModel[0];
var jsonList = JsonConvert.SerializeObject(cinemaModela);
Response.Write(jsonList);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
//页面初始化
if (!IsPostBack)
{
CinemaInfoModel oi = new CinemaInfoModel();
oi.CinemaID = Convert.ToInt32(Request["CinemaID"]);
om = new ChooseOfficeBLL().FindOffice(oi);
if (!String.IsNullOrEmpty(Request["CinemaID"]) && !String.IsNullOrEmpty(Request["MovieID"]))
{
//绑定电影封面
this.Repeater1.DataSource = new ChooseOfficeBLL().FindMovieInfo(new MovieInfoModel()
{
MovieID = Convert.ToInt32(Request["MovieID"])
}, oi);
this.Repeater1.DataBind();
}
if (!String.IsNullOrEmpty(Request["CinemaID"]) && String.IsNullOrEmpty(Request["MovieID"]))
{
//绑定电影封面
this.Repeater1.DataSource = new ChooseOfficeBLL().FindMovieInfo(new MovieInfoModel()
{
MovieID = 0
}, oi);
this.Repeater1.DataBind();
}
}
//前端传值加载界面
if (!String.IsNullOrEmpty(Request["Method"]))
{
switch (Request["Method"])
{
case "FindOfficeInfo":
FindOfficeInfo();
break;
case "FindMovieInfo":
FindMovieInfo();
break;
case "FindTom":
FindTom();
break;
case "FindTod":
FindTod();
break;
}
}
}
/// <summary>
/// 找到电影名
/// </summary>
/// <param name="chipInfoID"></param>
/// <returns></returns>
public List <CinemaInfoModel> selectCinemaName(string chipInfoID)
{
string sql = "select CinemaName,CinemaAddress from CinemaInfo where CinemaID=(select CinemaID from ChipInfo where chipInfoID=@chipInfoID)";
List <CinemaInfoModel> list = new List <CinemaInfoModel>();
SqlDataReader reader = SqlHelper.GetSqlDataReader(sql, new SqlParameter("@chipInfoID", chipInfoID));
while (reader.Read())
{
CinemaInfoModel m = new CinemaInfoModel(reader);
list.Add(m);
}
return(list);
}
public List <CinemaInfoModel> selectAllCinema()
{
string sql = "select *from CinemaInfo";
SqlDataReader reader = SqlHelper.GetSqlDataReader(sql);
List <CinemaInfoModel> ls = new List <CinemaInfoModel>();
while (reader.Read())
{
CinemaInfoModel mov = new CinemaInfoModel(reader);
ls.Add(mov);
}
reader.Close();
return(ls);
}
/// <summary>
/// 查询所有正在放映此电影的影院
/// </summary>
/// <param name="model"></param>
/// <returns> List<CinemaInfoModel></returns>
public List <CinemaInfoModel> chooseCinema(MovieInfoModel model)
{
//--查询正在放映此电影的所有电影
//--开场十五分钟前
string sql = "select * from CinemaInfo where CinemaID in (select CinemaID from ChipInfo where MovieName = (select MovieName from MovieInfo where MovieID = @MovieID) and datediff(MINUTE, getdate(), StartTime) > 15)";
List <CinemaInfoModel> list = new List <CinemaInfoModel>();
SqlDataReader reader = SqlHelper.GetSqlDataReader(sql, new SqlParameter("@MovieID", model.MovieID));
while (reader.Read())
{
CinemaInfoModel m = new CinemaInfoModel(reader);
list.Add(m);
}
return(list);
}
private void FindTom()
{
string b = Request["MovieName"].ToString();
MovieInfoModel mi = new MovieInfoModel();
mi.MovieName = Request["MovieName"].ToString();
CinemaInfoModel ci = new CinemaInfoModel();
ci.CinemaID = Convert.ToInt32(Request["CinemaID"]);
List <ShowDetails> sd = new ChooseOfficeBLL().FindTom(mi, ci);
var jsondata = JsonConvert.SerializeObject(sd);
Response.Write(jsondata);
Response.End();
}
public List <CinemaInfoModel> FindCinema()
{
string str = "select * from CinemaInfo";
SqlDataReader reader = SqlHelper.GetSqlDataReader(str);
List <CinemaInfoModel> ls = new List <CinemaInfoModel>();
while (reader.Read())
{
CinemaInfoModel ci = new CinemaInfoModel(reader);
ls.Add(ci);
}
reader.Close();
return(ls);
}
/// <summary>
/// 通过传入的影片ID和影院ID找该影院所有排片电影信息
/// </summary>
/// <param name="mi"></param>
/// <param name="om"></param>
/// <returns></returns>
public List <MovieInfoModel> FindMovieInfo(MovieInfoModel mi, CinemaInfoModel om)
{
List <MovieInfoModel> ls = new ChooseOfficeDAL().FindMovieInfo(mi, om);
//如果有传入电影ID，则将该电影放置在首位
if (mi.MovieID != 0)
{
for (int i = 0; i < ls.Count; i++)
{
if (ls[i].MovieID == mi.MovieID)
{
ls.Insert(0, ls[i]);
ls.RemoveAt(i + 1);
}
}
}
return(ls);
}
/// <summary>
/// 通过传入的影片ID和影院ID找厅位放映详情
/// </summary>
/// <param name="mi"></param>
/// <param name="om"></param>
/// <returns></returns>
public List <ShowDetails> FindOffice(MovieInfoModel mi, CinemaInfoModel om)
{
List <ShowDetails> sd = new ChooseOfficeDAL().FindShowDetails(mi, om);
//根据地区来选定播放语言
for (int i = 0; i < sd.Count; i++)
{
if (sd[i].Language != "大陆" && sd[i].Language != "中国香港" && sd[i].Language != "中国台湾")
{
sd[i].Language = "英语";
}
else
{
sd[i].Language = "国语";
}
//不同的影厅价格不一致
switch (sd[i].OfficeName)
{
case "杜比巨幕厅":
sd[i].Money = sd[i].Money + (sd[i].Money * 1);
break;
case "中国巨幕厅":
sd[i].Money = sd[i].Money + (sd[i].Money * 0.8);
break;
case "激光2D厅":
sd[i].Money = sd[i].Money + (sd[i].Money * 0.3);
break;
case "激光3D厅":
sd[i].Money = sd[i].Money + (sd[i].Money * 0.6);
break;
case "IMAX厅":
sd[i].Money = sd[i].Money + (sd[i].Money * 1.5);
break;
}
}
return(sd);
}
/// <summary>
/// 找到该影院信息
/// </summary>
/// <param name="om"></param>
/// <returns></returns>
public CinemaInfoModel FindOffice(CinemaInfoModel om)
{
string str = "select * from CinemaInfo where CinemaID=@CinemaID";
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@CinemaID", System.Data.SqlDbType.Int)
{
Value = om.CinemaID
}
};
SqlDataReader reader = SqlHelper.ExecuteReader(str, System.Data.CommandType.Text, sqlParameters);
CinemaInfoModel oi = new CinemaInfoModel();
while (reader.Read())
{
oi = new CinemaInfoModel(reader);
}
reader.Close();
return(oi);
}
/// <summary>
/// 通过传入的影院ID找该影院所有信息
/// </summary>
/// <param name="om"></param>
/// <returns></returns>
public CinemaInfoModel FindOffice(CinemaInfoModel om)
{
return(new ChooseOfficeDAL().FindOffice(om));
}
/// <summary>
/// 传入影院ID和电影ID时返回厅院上映信息
/// </summary>
/// <param name="mi"></param>
/// <param name="om"></param>
/// <returns></returns>
public List <ShowDetails> FindShowDetails(MovieInfoModel mi, CinemaInfoModel om)
{
string str;
SqlParameter[] sqlParameters = null;
if (mi.MovieID != 0)
{
//通过电影ID查询到该电影信息
str = "select * from MovieInfo where MovieID =@MovieID";
sqlParameters = new SqlParameter[] {
new SqlParameter("@MovieID", System.Data.SqlDbType.Int)
{
Value = mi.MovieID
}
};
}
else
{
// 在没有电影ID的时候，查询该电影院的Top 1排片电影
str = " Select Top 1* from MovieInfo where MovieName in " +
"(select MovieName from[dbo].[ChipInfo] where CinemaID = @CinemaID " +
" and datediff(MINUTE, getdate(),StartTime)>15)";
sqlParameters = new SqlParameter[] {
new SqlParameter("@CinemaID", System.Data.SqlDbType.Int)
{
Value = om.CinemaID
}
};
}
SqlDataReader reader = SqlHelper.ExecuteReader(str, System.Data.CommandType.Text, sqlParameters);
MovieInfoModel mo = new MovieInfoModel();
while (reader.Read())
{
mo = new MovieInfoModel(reader);
}
reader.Close();
//上映详情集合
List <ShowDetails> ls = new List <ShowDetails>();
if (String.IsNullOrEmpty(mo.MovieName))
{
return(ls);
}
//通过传入的影院ID获取该排片的开始结束时间、且必须为今日排片、离上映时间大于15分钟
str = "select * from [dbo].[ChipInfo] where CinemaID=@CinemaID and datediff(MINUTE,getdate(),StartTime)>15 and Convert(nvarchar,StartTime,120) like @TimeNow+'%' and MovieName=@MovieName";
sqlParameters = new SqlParameter[] {
new SqlParameter("@CinemaID", System.Data.SqlDbType.Int)
{
Value = om.CinemaID
},
new SqlParameter("@MovieName", System.Data.SqlDbType.NVarChar)
{
Value = mo.MovieName
},
new SqlParameter("@TimeNow", System.Data.SqlDbType.NVarChar)
{
Value = DateTime.Now.ToString().Substring(0, DateTime.Now.ToString().IndexOf(' ')).Replace('/', '-')
}
};
reader = SqlHelper.ExecuteReader(str, System.Data.CommandType.Text, sqlParameters);
//排片集合
List <ChipInfoModel> os = new List <ChipInfoModel>();
while (reader.Read())
{
ChipInfoModel oi = new ChipInfoModel(reader);
os.Add(oi);
}
reader.Close();
//将该影院所有关于该电影的排片信息（开始结束时间）放入ShowDetails集合
for (int i = 0; i < os.Count; i++)
{
ls.Add(new ShowDetails()
{
ChipInfoID = os[i].ChipInfoID, StartTime = os[i].StartTime, StopTime = os[i].StopTime, Money = mo.MovieMoney, Language = mo.MovieArea
});
}
List <OfficeInfoModel> of = new List <OfficeInfoModel>();
//通过传入的影院ID获取厅信息
for (int i = 0; i < os.Count; i++)
{
str = " select * from [dbo].[OfficeInfo] where [OfficeID] in (@OfficeID)";
sqlParameters = new SqlParameter[] {
new SqlParameter("@OfficeID", System.Data.SqlDbType.Int)
{
Value = os[i].OfficeID
}
};
reader = SqlHelper.ExecuteReader(str, System.Data.CommandType.Text, sqlParameters);
//获取到了所有的厅位信息
while (reader.Read())
{
OfficeInfoModel ofs = new OfficeInfoModel(reader);
of.Add(ofs);
}
reader.Close();
}
for (int i = 0; i < of.Count; i++)
{
ls[i].OfficeID = of[i].OfficeID;
ls[i].OfficeName = of[i].OfficeName;
}
return(ls);
}
