/// <summary>
/// 根据电影院管理者查询电影厅
/// </summary>
/// <param name="m_name"></param>
/// <returns></returns>
public static List <DianYingTing> search_DianYingTing(string m_name)
{
List <DianYingTing> dyt = new List <DianYingTing>();
string sql = "select * from DianYingTing where y_id=(select DianYingYuan_id from Manage where name=@name)";
SqlParameter[] sp =
{
new SqlParameter("@name", m_name)
};
SqlDataReader sdr = DBHelper.ExecuteReader(sql, CommandType.Text, sp);
if (sdr.HasRows)
{
while (sdr.Read())
{
DianYingTing dyy = new DianYingTing();
dyy.Y_id = int.Parse(sdr["y_id"].ToString());
dyy.T_id = int.Parse(sdr["t_id"].ToString());
dyy.T_name = sdr["t_Name"].ToString();
dyy.T_line = int.Parse(sdr["t_line"].ToString());
dyy.T_row = int.Parse(sdr["t_row"].ToString());
dyy.T_count = int.Parse(sdr["t_count"].ToString());
dyt.Add(dyy);
}
}
return(dyt);
}
/// <summary>
/// 添加电影厅
/// </summary>
/// <param name="dyt"></param>
/// <returns></returns>
public static bool Insert_DianYingTing(DianYingTing dyt)
{
SqlParameter[] p =
{
new SqlParameter("@y_id", dyt.Y_id),
new SqlParameter("@t_name", dyt.T_name),
new SqlParameter("@t_count", dyt.T_count),
new SqlParameter("@t_row", dyt.T_row),
new SqlParameter("@t_line ", dyt.T_line)
};
int i = DBHelper.ExecuteNonQuery("InsertDianYingTing", CommandType.StoredProcedure, p);
return(i > 0);
}
public static DianYingTing search_DianYingTing_byP_id(int p_id)
{
string str = " select * from DianYingTing where t_id=(select t_id from PianChang where p_id=@id)";
SqlParameter[] p =
{
new SqlParameter("@id", p_id)
};
SqlDataReader sr = DBHelper.ExecuteReader(str, CommandType.Text, p);
DianYingTing dyt = new DianYingTing();
if (sr.Read())
{
dyt.T_name = sr["t_name"].ToString();
dyt.T_line = Convert.ToInt32(sr["t_line"]);
dyt.T_row = Convert.ToInt32(sr["t_row"]);
dyt.T_count = Convert.ToInt32(sr["t_count"]);
}
sr.Close();
return(dyt);
}
protected void Page_Load(object sender, EventArgs e)
{
p_id = 1032;
String Y_name = DAL.PianChangServer.search_DianYingYuanName_byP_id(p_id);
DianYingTing dyt = DAL.PianChangServer.search_DianYingTing_byP_id(p_id);
Movie movie = DAL.PianChangServer.search_Movie_byP_id(p_id);
PianChang pc = DAL.PianChangServer.search_pianChang_byP_id(p_id);
s_width = Convert.ToInt32(Math.Floor((double)(600 / (dyt.T_line))));
//s_heigh = Convert.ToInt32(Math.Floor((double)(600 / (dyt.T_line))));
p_name.Text = Y_name + " " + dyt.T_name;
m_name.InnerText = movie.M_name;
m_time.InnerText = "片长：" + movie.M_minute + "分钟";
m_voice.InnerText = "版本：" + movie.M_voice;
yY_name.InnerText = Y_name;
yT_name.InnerText = dyt.T_name;
jiaGe.Text = pc.P_price.ToString();
string[] Day = new string[] { "星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六" };
string week = Day[Convert.ToInt32(pc.P_time.DayOfWeek.ToString("d"))].ToString();
p_time.InnerText = pc.P_time.Date.ToShortDateString() + "(" + week + ")" + pc.P_time.Hour + ":" + pc.P_time.Minute;
for (int n = 1; n <= dyt.T_row; n++)
{
createCoulmn(n);
}
for (int n = 1; n <= dyt.T_row; n++)
{
for (int m = 1; m <= dyt.T_line; m++)
{
createSeat(n, m);
}
}
}
/// <summary>
/// 添加电影厅
/// </summary>
/// <param name="dyt"></param>
/// <returns></returns>
public static bool Insert_DianYingTing(DianYingTing dyt)
{
return(DAL.DianYingTingServer.Insert_DianYingTing(dyt));
}
